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
MediaPortal 1 Talk
My optimized dvb epg configuration for tv server
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="splatterpop" data-source="post: 1250904" data-attributes="member: 62445"><p>Hello,</p><p></p><p>I would like to share this as a suggestion for configuring DVB EPG.</p><p></p><p>In TV server, configure under DVB EPG:</p><p>+ always try to fill holes = on</p><p>+ always try to update existing entries = on</p><p>+ enable CRC check = off</p><p>+ grab EPG only for channels on same transponder = on</p><p></p><p>Then use some SQL client to connect to the database, and execute the following SQL:</p><p></p><p style="margin-left: 20px"><span style="font-family: 'Courier New'">use mptvdb;</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'"></span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">select displayName, isRadio, isTv, grabEpg, visibleInGuide from mptvdb.channel as c1</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">where (c1.idchannel, c1.istv) in (</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">select c1, istv from (</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">select transportid, c.istv, min(c.idchannel) c1 </span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">from mptvdb.tuningdetail as t join mptvdb.channel as c on t.idChannel = c.idChannel</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">where 1=1</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">and c.visibleInGuide =1</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">group by transportid, c.istv</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">) as q1</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">) </span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">and grabepg = 0</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">order by istv desc, displayname</span></p> <p style="margin-left: 20px"><span style="font-family: 'Courier New'">; </span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"></p><p>This will list all channels for which EPG grabbing should be enabled (one per transponder). Go to TV server setup and set the check marks under TV/radio EPG grabber. I found a 3 minute timeout (idle and timeshifting) is sufficient to safely grab 1 week of EPG. </p><p></p><p>If configured this way, the EPG usually builds itself from scratch in under 2 hours. It also avoids the EPG becoming incompetely or sparsely populated - I found some channels provide EPG for channels on other transponders only in a very limited way.</p><p></p><p>Cheers,</p><p>splatterpop</p></blockquote><p></p>
[QUOTE="splatterpop, post: 1250904, member: 62445"] Hello, I would like to share this as a suggestion for configuring DVB EPG. In TV server, configure under DVB EPG: + always try to fill holes = on + always try to update existing entries = on + enable CRC check = off + grab EPG only for channels on same transponder = on Then use some SQL client to connect to the database, and execute the following SQL: [INDENT][FONT=Courier New]use mptvdb; select displayName, isRadio, isTv, grabEpg, visibleInGuide from mptvdb.channel as c1 where (c1.idchannel, c1.istv) in ( select c1, istv from ( select transportid, c.istv, min(c.idchannel) c1 from mptvdb.tuningdetail as t join mptvdb.channel as c on t.idChannel = c.idChannel where 1=1 and c.visibleInGuide =1 group by transportid, c.istv ) as q1 ) and grabepg = 0 order by istv desc, displayname ; [/FONT] [FONT=Courier New] [/FONT] [/INDENT] This will list all channels for which EPG grabbing should be enabled (one per transponder). Go to TV server setup and set the check marks under TV/radio EPG grabber. I found a 3 minute timeout (idle and timeshifting) is sufficient to safely grab 1 week of EPG. If configured this way, the EPG usually builds itself from scratch in under 2 hours. It also avoids the EPG becoming incompetely or sparsely populated - I found some channels provide EPG for channels on other transponders only in a very limited way. Cheers, splatterpop [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Talk
My optimized dvb epg configuration for tv server
Contact us
RSS
Top
Bottom