ZapImport - ???

[rheslip]

download xrecord and pull the files from there. I will have to update the zapimport archive. The date should be like 2/9/2005

Sounds like I have the latest - I did get it from Xrecord. 2/9/05 is the version that barfs with the error message as above. From the errormessage it sounds like theres something in the listings it doesn't recognize. I'm in Canada and I use the Starchoice satellite listings but I doubt that makes any difference to the Zap2it database contents.

It sounds like a great add on to Fastfind which is one of the most useful plugins IMHO. I've been wanting to seach for programs by genre - its one of the features in Media Portal that I like. Zapimport just won't work on my machine : (

Rich

[jorm]

Do you have MS Access at all? Or can you zip up your zapimport.mdb and email it to jared_dubin at hotmail.com

I am trying to make sure that the endTime field is in the schedule table.

[Spartan]

Do you have MS Access at all? Or can you zip up your zapimport.mdb and email it to jared_dubin at hotmail.com

I am trying to make sure that the endTime field is in the schedule table.

I get the same error:

Code:

Unhandled Exception: System.Data.OleDb.OleDbException: The INSERT INTO statement contains the following unknown field name: 'endTime'.  Make sure you have typed the name correctly, and try the operation again.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at zapmetadata.DatabaseHelper.AddSchedule(Schedule s)
   at zapmetadata.ZapDataReader.persistSchedule(Schedule s)
   at zapmetadata.ZapDataReader.loadSchedules(XmlNode rootNode)
   at zapmetadata.MainClass.Main(String[] args)

My database does NOT have a field called endTime -- however, it does have a field called end_time

I will try renaming the field in the database and post back....

[Spartan]

As promised -- here's the update. After figuring out that I had to change the field in the zapcleandb.mdb database, it did make it farther. This time the error reads:

Code:

Unhandled Exception: System.Data.OleDb.OleDbException: The field is too small to accept the amount of data you attempted
to add.  Try inserting or pasting less data.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at zapmetadata.DatabaseHelper.AddProgramData(ProgramData s)
   at zapmetadata.ZapDataReader.persistProgramData(ProgramData programDataEntry)
   at zapmetadata.ZapDataReader.loadProgrammes(XmlNode rootNode)
   at zapmetadata.MainClass.Main(String[] args)

[jorm]

Not sure why the db is not right. Need to look at it.

ok. There were a few lines above it that can at least narrow the table. Typically data like

Schedules
Genere
Cast maybe Crew
Programs

What is the last one you get before the error. Then we can figure out what field needs to be modified.

[Spartan]

Code:

C:\Program Files\devnz\gbpvr>zapimport.exe xxx xxx
Path C:\Program Files\devnz\gbpvr\
Total Loaded 8067
Loading up schedules
root xtvd
children 6
Loading up channels
Loading up programs

Unhandled Exception: System.Data.OleDb.OleDbException: The fi....

[Spartan]

Even more info -- here is the line it barfs on:

"INSERT INTO ProgramData (program_id,show_type,star_rating,mpaa_rating,year_released,air_date,color_code,title) VALUES ('SH7430080000',1,'none',0,0,'2005-04-09',0,'Wedding of Prince Charles and Camilla Parker Bowles')"

My database does not have the ProgramData.title field. I am now running the code / database that is in the zaptools-src.zip archive on wiki.

EDIT: Once I added the ProgramData.title field, it completed successfully. I made the field a Text/100.

[rheslip]

Nice work Spartan !

Jorm - can I assume you will be tweeking the database to reflect these mods ?

Thanks guys !

Rich

[Spartan]

Nice work Spartan !

Jorm - can I assume you will be tweeking the database to reflect these mods ?

Thanks guys !

Rich

I've attached the modified database(s) -- use at your own risk. :p

[jorm]

That is my plan. The latest zaptools on wiki seem to have the right fields. Xrecords db seems to be the one that is wrong. I am going to do an update of xrecord with that and the date fix for the cdk scheduler.