where is epg stored (1 Viewer)

Martyvan

Portal Member
June 2, 2016
6
1
44
New Zealand New Zealand
Hello, i have been having so much fun with the epg, if i use xmltv its out by 12 hours. fixed the problem but now mp1 wont import the xml data keeps saying it is already importing. if i use dvbepg which worked fine for the first week but then all of the data was unreadable its like its using an incompatible font or corrupted. my question is, where does mp1 store the epg data. im presuming its in a database but cant work out where it is.

thanks
 

JimCatMP

Documentation Group
  • Team MediaPortal
  • April 1, 2010
    648
    281
    Leeds
    United Kingdom United Kingdom
    Country flag
    Hi Martyvan

    Assuming MySQL 5.6 install, C:/ProgramData/MySQL/MySQL Server 5.6/data is where DB's are located.

    12hrs out - sound like a timezone issue?

    Cheers - J.
     

    mm1352000

    Development Group
  • Team MediaPortal
  • September 1, 2008
    21,571
    8,218
    New Zealand New Zealand
    Country flag
    fixed the problem but now mp1 wont import the xml data keeps saying it is already importing.
    You probably need to be a bit more patient.

    if i use dvbepg which worked fine for the first week but then all of the data was unreadable its like its using an incompatible font or corrupted.
    You can't use the DVB EPG grabber if you're trying to get Freeview HD (DVB-T terrestrial) EPG. The EPG data is compressed and TV Server doesn't support decompressing it. Hence the "unreadable", "corrupted" appearance.

    my question is, where does mp1 store the epg data. im presuming its in a database but cant work out where it is.
    Yes, it's in a database. To be specific: either a MySQL or SQL Server database. Which one it is depends on the options you chose when installing MediaPortal.
     

    Martyvan

    Portal Member
    June 2, 2016
    6
    1
    44
    New Zealand New Zealand
    ha ha funny a stranger telling me i prob need a bit more patience. I have fixed the prob, however i dont really know what caused it. I ended up reinstalling MP1. set everything back up except for purevision HD, ( could pure vision be causing the fault. ??? ). tvguide.xml now imports correctly without timezone correction which btw didnt work. ( forgot to mention in original post had stopped using dvbepg and went to tvguide.xml ) .
     

    mm1352000

    Development Group
  • Team MediaPortal
  • September 1, 2008
    21,571
    8,218
    New Zealand New Zealand
    Country flag
    tvguide.xml now imports correctly without timezone correction which btw didnt work.
    Time-zone correction is tricky to understand. It definitely works, though it may not have done what you were expecting. The wiki (manual) gives a full explanation of the correction/compensation settings with examples if you're interested...
    http://wiki.team-mediaportal.com/1_...imezone_compensation_when_loading_tvguide.xml

    forgot to mention in original post had stopped using dvbepg and went to tvguide.xm
    As per my previous reply: that's good and necessary if trying to get NZ Freeview HD guide data.
     

    Martyvan

    Portal Member
    June 2, 2016
    6
    1
    44
    New Zealand New Zealand
    tvguide.xml now imports correctly without timezone correction which btw didnt work.
    Time-zone correction is tricky to understand. It definitely works, though it may not have done what you were expecting. The wiki (manual) gives a full explanation of the correction/compensation settings with examples if you're interested...
    http://wiki.team-mediaportal.com/1_...imezone_compensation_when_loading_tvguide.xml

    forgot to mention in original post had stopped using dvbepg and went to tvguide.xm
    As per my previous reply: that's good and necessary if trying to get NZ Freeview HD guide data.

    I did read that. Now its all working again properly i havnt had to adjust timezone compensation, it is being read off the tvguide file which is great.
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    J Where the heck is the Client side setup? General 2
    T [solved] Any idea where Channel 107 (DVB-T2) BBC News HD (and others!) have gone??? Installation, configuration support 12
    morpheus_xx [Help Me!] Where can I find source code for MPUrlSourceSplitter? Developer Discussions 3
    D Where should plugins be located on hard drive? General Support 0
    D I just installed MP 1.23. Which version of Schedules Direct should I use, where do I obtain it from Newcomers Forum 6
    C where is the Online Videos plugin General Support 1
    Jean-Christophe MP 2.2 - Where can I find Movies NOT imported (and why??) ? General 13
    N [fixed] Where do I find radio programmes I have recorded MediaPortal 2 1
    cbr954rr [MP2-795] Where is the radio? General 4
    B [solved] Where is the satellite data now? General 10
    Tinkerer Where to go from mp 1.12? Newcomers Forum 0
    uxDesign [Question] Where are the latest sources of mpextended? MPExtended 3
    H [solved] Where is Input Manager General 1
    A Thumbnails - where are they stored Installation, configuration support 20
    J silly question: where do I add my login details!! OnlineVideos for MediaPortal 2 5
    D EPG No Data General Support 2
    D [solved] EPG Data off by -20 hours? General 10
    G Q about scheduling weekly series when epg lists duplicate back to back episodes each week General Support 2
    F Mini EPG more information? WMC Skin 4
    N No TV or EPG on fresh install General 0
    framug No color in TVGuide when XMLTV without DVB EPG MediaPortal 1 Talk 59
    T Freesat EPG in UK anyone? Electronic Program Guide 78
    Dark Eyes TVService locks up or fails to restart on resuming from sleep, and crashes when grabbing EPG Installation, configuration support 7
    G Movie release date in guide Electronic Program Guide 2
    Rob Hexenmeister Navigation problems adding menu buttons to EPG General Support 1
    Similar threads

























    Top Bottom