My optimized dvb epg configuration for tv server

Discussion in 'MediaPortal 1 Talk' started by splatterpop, November 29, 2018.

Tags:
  1. splatterpop
    • Premium Supporter

    splatterpop MP Donator

    Joined:
    December 17, 2007
    Messages:
    177
    Likes Received:
    51
    Occupation:
    IT professional
    Location:
    planet ASPARAGUS
    Ratings:
    +56 / 1
    Home Country:
    Germany Germany
    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:

    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
    ;



    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


     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!