where is epg stored (1 Viewer)

Martyvan

Portal Member
June 2, 2016
6
1
45
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
    652
    283
    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,577
    8,221
    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
    45
    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,577
    8,221
    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
    45
    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

    Similar threads
    OP Title 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
    Z EPG-Buddy / xmltv-plugin - zwei Quellen, selber Sender Elektronischer Programmführer (EPG) 2
    S Epg does not open at the last watched channel + epg grab stuck if not manually deleted first Electronic Program Guide 0
    ge2301 MP2 - V2.4 [MP2-867] Dynamic font scaling for EPG programs in relation to number of rows MediaPortal 2 2
    F EPG/Scheduler case sensitive Feature Requests 14
    Andy_2639 Few "Continuity error..." after EPG scan General Support 2
    D Problem getting Schedules Direct EPG to load data Installation, configuration support 4
    R 1.27.0 Digiguide for epg for DVBS Electronic Program Guide 0
    CyberSimian Split programmes in the UK DVB-T EPG TV-Server 0
    C MP2 - V2.3.1 EPG view: incorrect displayed fonts Submit: Bug Reports 2
    R Deadlock in TV Server if recording while importing EPG TV-Server 10
    C MP2 - V2.3 Nereus: EPG context menu not available anymore at a running program General 8
    P MP2 - V2.3 EPG Frustration................ General 26
    cbr954rr Clickfinder epg import wrong channels? General 0

    Similar threads

    Top Bottom