Extra Zap2It Meta Data

[jorm]

Well so far I have been able to access zap2it downloading a big xml file of the data. I parse it apart and populate a new database with the fields.

The problem I am having is I need to be able to compact the database. Any ideas?

[sub]

You cant do a "compact" with the oledb .net database stuff. You need to use ado/jet interop stuff. That said, I'm not bothering at this stage - it very difficult to coordinate all the processes to drop their connections so I can get exclusive access...

[jorm]

Sounds like I should have a clean mdb file in the same directory that I will copy over the existing one.

[jorm]

can some zap2it users with ms access help me out with testing this on different lineups.


unzip these to gbpvr

run zapimport username password

then open it with access to make sure the data is good.

[KingArgyle]

I'll take a look at this when I get home later tonight.

[jorm]

I have only tested this on my listings. Once it stablizes a bit. I will post it and the code on wiki.

[ecorbin]

jorm, I have tested this on my line-up. There is data in the db, but I'm not sure exactly what data should be there. ChannelData, Crew, and Genre all look good, but there's some weird things in ProgramData. For example, I've got a program in there that says it has an air date of '1953-10-12'. There are many, many programs with old dates like that. Would you like me to email you my db?

[jorm]

ecorbin,

lets try this first.  There is now a file called zapdata.xml in your directory.  Can you search for '1953-10-12' in there.  The air date is the first air date.  Maybe some old holiday movies that first aired in the 50's are being picked up.  Let me know what you find.

I am glad to hear that the basic parsing is working.  

You can always get the program_id and look that up in the gbpvr.mdb in the unique_identifier tab to determine what show it is.

I have some shows in my xml like below with an old date as well.

program id="EP0026330066">
<title>
Little House on the Prairie
</title>
<subtitle>
The Wisdom of Solomon
</subtitle>
<description>
A black boy (Todd Bridges) offers to be the Ingalls' slave in exchange for attending school.
</description>
<showType>
Series
</showType>
<series>
SH002633
</series>
<syndicatedEpisodeNumber>
3019
</syndicatedEpisodeNumber>
<originalAirDate>
1977-02-28
</originalAirDate>
</program>

[Lucas_24]

just tried this, the database looks good, let me know if you'd like me to email the files. I never realised there was so much info available. I suspect you guys will write some pretty neat plugins using this.

[jorm]

I have run the database with my lineup. I was just checking to make sure it worked on more than just my machine. The next step is to make some of the existing plugins aware of the zap info so if it there it will have additional functionality.

Any suggestions of plugins or enhancement please post.

I am going to start a dll to interface with this data tomorrow.