EPG Data Question

volksman · 2007-01-09, 02:11 PM

Hey All!

Am planning a little app that will help me determine what is coming on in the next 14 days. Not really big on the idea of learning about XML parsers to go through the XMLTV or Zap2it dumps so I was wondering if GB stores this info in the DB. If so where? I found a table called PROGRAMME but it is a little confusing and shows no channel info. So how does it relate that to the correct channel?

Any info or pointers to where I can read up on how GB stores guide data would be greatly appreciated.

martint123 · 2007-01-09, 03:13 PM

One field of table 'programme' is 'channel_oid' this is a pointer to table 'channel' which has a 'name' field - the channel name.
I don't think sub has released any database info as it's a dangerous place to wander and would probably result in many unnecessary support 'calls'.

Martin

volksman · 2007-01-09, 03:33 PM

the channel_id field in my PROGRAMME table only has three values assigned throughout 1,2,231 spread over 1000 rows. I fail to see how this corresponds with the name field in the CHANNEL table. Did I miss something? Is this a stored procedure or something? Maybe its because I'm using SQLlite DB Browser and not something else?

And yeah I guess that not documenting it makes sense but I would think if the ability to create plugins depends on this stuff it might have been somewhere... Smile

***sub*** · 2007-01-09, 03:58 PM

As martin said above, the channel_oid column in the PROGRAMME table is used to find the related CHANNEL (joined on channel_oid to oid). The CHANNEL table has a 'name'.

Quote:the channel_id field in my PROGRAMME table only has three values assigned throughout 1,2,231 spread over 1000 rows. I fail to see how this corresponds with the name field in the CHANNEL table. Did I miss something?

I'm sure you've got it right, but there can be a lot of listings, so you'll probably need to look at a lot of rows. Some users with 13 days of listings and lots of channels can have over quarter of million PROGRAMME records.

volksman · 2007-01-09, 04:21 PM

Man was I confused on this for a bit here. My EPG works fine so I knew that the zap2it listings were getting parsed properly but I could only see 1000 rows.

Then I noticed the stupid > button in SQL Browser.... Smile

I can now see the correlation. Thanks for the info! I should be good from here...!

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Web API only_new Question	Gazavant	6	2,692	2021-04-04, 06:54 PM Last Post: sub
	Another Artwork question	scJohn	15	8,188	2019-09-10, 05:33 PM Last Post: nonob
	How to extract M3U8 and get matching XMLTV guide data from NPVR	almightyj	0	3,450	2018-10-23, 07:24 AM Last Post: almightyj
	Getting more than 24 hours of Guide Data	scJohn	4	3,618	2018-05-16, 04:20 AM Last Post: sub
	WEB API GuidService/Listing question(s)	scJohn	6	4,301	2017-08-09, 02:18 PM Last Post: scJohn
	skin question	pBS	2	3,350	2016-06-18, 07:03 PM Last Post: pBS
	Attention Sub: Open TV / Custom Data Grabber plugin	Benoire	2	2,922	2014-11-14, 02:05 AM Last Post: Benoire
	Another SQL question	bgowland	15	7,253	2014-05-21, 08:09 AM Last Post: bgowland
	Merge xmltv data with xslt	Graham	4	3,479	2014-01-02, 12:45 PM Last Post: Graham
	Timing.Info question	mvallevand	2	2,076	2013-04-19, 03:54 AM Last Post: mvallevand