home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Quality Assurance
Bugreports
Archive
Recordings import assigns wrong channels
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Johannes Franke" data-source="post: 1170836" data-attributes="member: 157042"><p>Hi everyone,</p><p></p><p>I found a problem with MP 1.9.0 which apparently is still around with 1.13.0 and wanted to let you know about my findings.</p><p>I have a DVB-S setup (Hauppauge Win-TV 5500 HVR) and the previous scan revealed a lot of TV and radio stations. The scanner appears to add the radio stations first into the <em>channels </em>table so they get a lower record ID than the TV stations which reside in the same table. This is the result of a <em>SELECT * FROM channel WHERE displayName = 'RTL2'</em></p><p></p><p>[code]idChannel isRadio isTv timesWatched totalTimeWatched grabEpg lastGrabTime sortOrder visibleInGuide externalId displayName epgHasGaps channelNumber</p><p> 142 1 0 0 01.01.2000 00:00 0 01.01.2000 00:00 10000 1 RTL2 0 10000</p><p> 384 0 1 0 01.01.2000 00:00 1 11.01.2016 11:06 5 1 RTL2 0 10000[/code]</p><p></p><p>I picked RTL2 because it is where I found the issue. But this is just a representative example. The problem will occur whenever a radio and TV station share the same displayName.</p><p>Recordings are supposed to go to a large harddrive that does not contain the Windows system installation. So the recordings base folder had to be redirected to the other harddrive. After that, I cleared all invalid records in the configuration wizard and clicked <em>Change Channel</em> to refresh the list of available recordings for import. All are shown as expected. Just to mention it, each .ts file has an accompanying .xml file containing the recording info.</p><p>After importing them, I found that not all recordings are shown in the MediaPortal client, even though a record for each exists in the <em>recording</em> table, and no files remained in the list of files to be imported. The ones not shown both have <em>idChannel = 142</em>.</p><p>I imagine that the following happened during the import:</p><p></p><ol> <li data-xf-list-type="ol">for each .ts file, the respective .xml file is looked up and, if found, parsed</li> <li data-xf-list-type="ol">the .xml file has the channel name in it</li> <li data-xf-list-type="ol">the channel name is looked up by name (<em>displayName</em>, to be exact) in the <em>channel </em>table</li> <li data-xf-list-type="ol">actually this would result in multiple channel records matching but the first wins which unfortunately is the radio channel, not the TV</li> <li data-xf-list-type="ol">the id of the first <em>channel </em>record is used for the new record in the recordings table and goes into the <em>idChannel </em>column</li> <li data-xf-list-type="ol">when MediaPortal queries the available recordings, there is probably an inner join between the <em>recordings </em>and the <em>channels </em>table that excludes the radio-related channels</li> <li data-xf-list-type="ol">as a result, the list of recordings is incomplete</li> </ol><p>Probably this might be fixed if in step 3 the query would be changed to retrieve the channel matching the given name AND having <em>isTv = 1</em>. Eventually this is all about video recordings, not radio (at least for me). Unfortunately, the actual source of the recording (radio or TV) cannot be found out from the XML data because there is no respective information in there. But at least a small analysis of the .ts file might reveal whether it contains pure audio (--> radio) or audio and video (--> TV).</p><p>So far, the only fix is changing the <em>idChannel </em>value from 142 to 384 wherever 142 is assigned...</p><p></p><p>The problem has been around for some time. Maybe I am not the first one to notice and address it. In that case, sorry for the time wasted.</p><p></p><p>Best regards,</p><p>Johannes</p></blockquote><p></p>
[QUOTE="Johannes Franke, post: 1170836, member: 157042"] Hi everyone, I found a problem with MP 1.9.0 which apparently is still around with 1.13.0 and wanted to let you know about my findings. I have a DVB-S setup (Hauppauge Win-TV 5500 HVR) and the previous scan revealed a lot of TV and radio stations. The scanner appears to add the radio stations first into the [I]channels [/I]table so they get a lower record ID than the TV stations which reside in the same table. This is the result of a [I]SELECT * FROM channel WHERE displayName = 'RTL2'[/I] [code]idChannel isRadio isTv timesWatched totalTimeWatched grabEpg lastGrabTime sortOrder visibleInGuide externalId displayName epgHasGaps channelNumber 142 1 0 0 01.01.2000 00:00 0 01.01.2000 00:00 10000 1 RTL2 0 10000 384 0 1 0 01.01.2000 00:00 1 11.01.2016 11:06 5 1 RTL2 0 10000[/code] I picked RTL2 because it is where I found the issue. But this is just a representative example. The problem will occur whenever a radio and TV station share the same displayName. Recordings are supposed to go to a large harddrive that does not contain the Windows system installation. So the recordings base folder had to be redirected to the other harddrive. After that, I cleared all invalid records in the configuration wizard and clicked [I]Change Channel[/I] to refresh the list of available recordings for import. All are shown as expected. Just to mention it, each .ts file has an accompanying .xml file containing the recording info. After importing them, I found that not all recordings are shown in the MediaPortal client, even though a record for each exists in the [I]recording[/I] table, and no files remained in the list of files to be imported. The ones not shown both have [I]idChannel = 142[/I]. I imagine that the following happened during the import: [LIST=1] [*]for each .ts file, the respective .xml file is looked up and, if found, parsed [*]the .xml file has the channel name in it [*]the channel name is looked up by name ([I]displayName[/I], to be exact) in the [I]channel [/I]table [*]actually this would result in multiple channel records matching but the first wins which unfortunately is the radio channel, not the TV [*]the id of the first [I]channel [/I]record is used for the new record in the recordings table and goes into the [I]idChannel [/I]column [*]when MediaPortal queries the available recordings, there is probably an inner join between the [I]recordings [/I]and the [I]channels [/I]table that excludes the radio-related channels [*]as a result, the list of recordings is incomplete [/LIST] Probably this might be fixed if in step 3 the query would be changed to retrieve the channel matching the given name AND having [I]isTv = 1[/I]. Eventually this is all about video recordings, not radio (at least for me). Unfortunately, the actual source of the recording (radio or TV) cannot be found out from the XML data because there is no respective information in there. But at least a small analysis of the .ts file might reveal whether it contains pure audio (--> radio) or audio and video (--> TV). So far, the only fix is changing the [I]idChannel [/I]value from 142 to 384 wherever 142 is assigned... The problem has been around for some time. Maybe I am not the first one to notice and address it. In that case, sorry for the time wasted. Best regards, Johannes [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Quality Assurance
Bugreports
Archive
Recordings import assigns wrong channels
Contact us
RSS
Top
Bottom