NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public Add-ons (3rd party plugins, utilities and skins) Old Stuff (Legacy) TV Listings v
« Previous 1 … 6 7 8 9 10 … 13 Next »
Genre info missing from some guides

 
  • 0 Vote(s) - 0 Average
Genre info missing from some guides
roy
Offline

Posting Freak

Posts: 830
Threads: 95
Joined: Sep 2005
#1
2011-10-23, 02:50 PM
I use 3 different xmltv files for my listings. Recently the genre info (therefore genre color) and xmltvextra info has gone missing from the channels from two of them. The info is in the xmltv files, but does not seem to be getting brought in to the tvlistings database. It looks like only data from the first file processed by xmltvextras is getting imported.

How can we debug this? Is there a log file somewhere? Or what else would be useful to debug this?

Thanks
What, me worry?

MSI H270 PC Mate | Core i3-7100 | 16GB RAM | 275GB M.2 2280 SSD | 4TB + 2TB HDD | Zalman Z3 Case | Win10
HDHR Prime | HVR2250 | PCH A-110 | PCH A-100 | Harmony 650 & 700 remotes | Comcast | Schedules Direct
alibert
Offline

Posting Freak

Posts: 974
Threads: 83
Joined: Apr 2005
#2
2011-10-25, 09:40 AM
Hi,

a good starting point would be the output of the xmltvextras utitlity. You can get by executing it from a command prompt, or by directing the console output to a textfile, e.g. by executing "c:\Users\Public\NPVR\Scripts\XmltvExtras.exe > log.txt".

-alibert
roy
Offline

Posting Freak

Posts: 830
Threads: 95
Joined: Sep 2005
#3
2011-10-25, 12:15 PM
Log and my tvlistings.db3 files attached.

Thanks
What, me worry?

MSI H270 PC Mate | Core i3-7100 | 16GB RAM | 275GB M.2 2280 SSD | 4TB + 2TB HDD | Zalman Z3 Case | Win10
HDHR Prime | HVR2250 | PCH A-110 | PCH A-100 | Harmony 650 & 700 remotes | Comcast | Schedules Direct
roy
Offline

Posting Freak

Posts: 830
Threads: 95
Joined: Sep 2005
#4
2011-10-28, 06:26 PM
bump?
What, me worry?

MSI H270 PC Mate | Core i3-7100 | 16GB RAM | 275GB M.2 2280 SSD | 4TB + 2TB HDD | Zalman Z3 Case | Win10
HDHR Prime | HVR2250 | PCH A-110 | PCH A-100 | Harmony 650 & 700 remotes | Comcast | Schedules Direct
alibert
Offline

Posting Freak

Posts: 974
Threads: 83
Joined: Apr 2005
#5
2011-11-01, 10:16 AM
Hi,

sorry for the delay, but my free time is quite limited at the moment. From the text output you attached, it seems that the genre and other extra information were imported successfully from each of the three xmltv files to the tv listings database, so they should be included when a corresponding programme is shown in the tv listings plugin. You can try to reconstruct what's going on using an utitlity like sqlitespy to take a look in the tv listings.db3 and npvr.db3 database files. The programme_oid column in the programme_extras table maps to the oid column in the epg_event table of the npvr database.

-alibert
roy
Offline

Posting Freak

Posts: 830
Threads: 95
Joined: Sep 2005
#6
2011-11-01, 03:46 PM
No problem, thanks for the reply. I've been without power and cable for 3 days now since the snow storm. Just hooked up an antenna so we can get the 2 local stations while the generator powers the tv. Hopefully will get to look into it soon. Looks like I'll be downloading many missed recordings.
What, me worry?

MSI H270 PC Mate | Core i3-7100 | 16GB RAM | 275GB M.2 2280 SSD | 4TB + 2TB HDD | Zalman Z3 Case | Win10
HDHR Prime | HVR2250 | PCH A-110 | PCH A-100 | Harmony 650 & 700 remotes | Comcast | Schedules Direct
roy
Offline

Posting Freak

Posts: 830
Threads: 95
Joined: Sep 2005
#7
2011-11-05, 01:55 PM
Back on line after 5 days without power.

Looking into the .db3 files, I see that not all of the records listed in the oid column in the epg_event table of the npvr database are listed in the programme_oid column in the programme_extras or category_mapping tables.

Should the number of records be the same for epg_event and programme extras? I see epg_event has 71731, and programme_extras has only 28432. So it does seem that not all of the epg records are being imported.

I'll try messing with the .db3 to see if I can figure out why.
What, me worry?

MSI H270 PC Mate | Core i3-7100 | 16GB RAM | 275GB M.2 2280 SSD | 4TB + 2TB HDD | Zalman Z3 Case | Win10
HDHR Prime | HVR2250 | PCH A-110 | PCH A-100 | Harmony 650 & 700 remotes | Comcast | Schedules Direct
roy
Offline

Posting Freak

Posts: 830
Threads: 95
Joined: Sep 2005
#8
2011-11-05, 02:25 PM
Looking at the log for xmltvextras (attached) I see different numbers for each xml file, except "Mapped 128 xmltv channels to NPVR channels" is the same for all three guides. I think this is the number of channels in the lineup for guide 2 which is the last one run, and the only lineup that shows programme extras or category info in TVListings.
What, me worry?

MSI H270 PC Mate | Core i3-7100 | 16GB RAM | 275GB M.2 2280 SSD | 4TB + 2TB HDD | Zalman Z3 Case | Win10
HDHR Prime | HVR2250 | PCH A-110 | PCH A-100 | Harmony 650 & 700 remotes | Comcast | Schedules Direct
alibert
Offline

Posting Freak

Posts: 974
Threads: 83
Joined: Apr 2005
#9
2011-11-08, 01:13 PM
Hi,

Regarding the channel mapping ("Mapped 128 xmltv channels to NPVR channels.") - from memory I think that this step is done independantly of the actual xmltv file, and only the npvr database is used to create the mappings of npvr channels to xmltv-channel-ids. But I'll have a look at the code of the xmltvextras application again when I get the time.

-alibert
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Missing Dolby Indicators roc 6 4,263 2019-09-11, 03:34 PM
Last Post: SilverTiger
  TheTVDB missing from "Find More" LeGrandZombie 1 2,439 2016-11-27, 04:01 AM
Last Post: LeGrandZombie
  -24hrs/+24hrs missing Choronzon 2 3,444 2016-02-15, 01:00 PM
Last Post: Choronzon
  New Genre jrockow 2 1,927 2014-01-18, 02:21 PM
Last Post: jrockow
  Provide watched status, show preview/show info at top dinki 4 2,648 2013-10-15, 10:23 PM
Last Post: johnsonx42
  Channel position control missing ttfitz 2 2,292 2013-03-15, 08:15 AM
Last Post: ttfitz
  Does this only work if you are using XMLTV to get your channel info? divinehammer 3 2,815 2012-09-04, 02:49 AM
Last Post: divinehammer
  Genre Coloring Stopped Working Pat Clark 4 3,096 2012-05-14, 01:03 PM
Last Post: Pat Clark
  How to do get Genre Colors working? gonzo90017 2 1,961 2012-04-17, 04:14 AM
Last Post: gonzo90017
  Schedules Direct and extra info dvasco 1 1,780 2011-10-18, 08:08 AM
Last Post: alibert

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode