ZapTools Update

[UncleJohnsBand]

ZapTools has been updated.

Now complied in .Net 2.0.
Has conversion utility to move zapdb to SQLite.
Allows access of zapdb info from either Access or SQLite via config.

Enhanced Web Admin (EWA) has also been updated to be able to handle the SQLite db or Access DB.

The preference will be to move to SQLite since GBPVR will move permenatly to that db with the next release.

[Anthony]

zapimport is crashing for me everytime I run it?

My PostUpdateEPG.bat file has one line:

zapimport userid password >zapimport.log

userid and password reflect my Zap2It login, of course.

zapimport "seems" to be doing something, then crashes. I don't see any difference in the EPG in GBPVR.

The zapimport.log only has three lines:

Using Path C:\Program Files\devnz\gbpvr\
Begining zapdb.mdb update process...
Removing GBPVR Recording Entries...

Any ideas?

Anthony

[UncleJohnsBand]

zapimport is crashing for me everytime I run it?

My PostUpdateEPG.bat file has one line:

zapimport userid password >zapimport.log

userid and password reflect my Zap2It login, of course.

zapimport "seems" to be doing something, then crashes. I don't see any difference in the EPG in GBPVR.

The zapimport.log only has three lines:

Using Path C:\Program Files\devnz\gbpvr\
Begining zapdb.mdb update process...
Removing GBPVR Recording Entries...

Any ideas?

Anthony

What are the settings in your zapimport.exe.config file?

[capone]

I get the same thing...only thing I changed was that import setting to true

[Anthony]

> What are the settings in your zapimport.exe.config file?

I didn't make any changes, so I was just using the default config file.

I just tried changing the account user_id/password, and the useGBPVR option to true, but it still crashes.

Anthony

[ubu]

Running the new version of zapimport in a .Net 2.0, GBPVR 97.7 environment, I get the following:

Code:

Using Path C:\Program Files\devnz\gbpvr\

Begining zapdb.mdb update process...

   Removing GBPVR Recording Entries...

Unhandled Exception: System.InvalidOperationException: ExecuteNonQuery requires
the command to have a transaction when the connection assigned to the command is
in a pending local transaction.  The Transaction property of the command has no
t been initialized.
   at System.Data.OleDb.OleDbConnectionInternal.ValidateTransaction(OleDbTransac
tion transaction, String method)
   at System.Data.OleDb.OleDbConnection.ValidateTransaction(OleDbTransaction tra
nsaction, String method)
   at System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String met
hod)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behav
ior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at zapmetadata.DatabaseHelper.RemoveAllRecordings()
   at zapmetadata.MainClass.Main(String[] args)

The only change I've made to ZapImport.exe.config is to alter UseGBPVR_XML to "true". I overlayed my old zapdb.mdb with a fresh copy straight from the zip file (just in case ). Any ideas?

[ydekmekji]

I have the exact same error

[UncleJohnsBand]

> What are the settings in your zapimport.exe.config file?

I didn't make any changes, so I was just using the default config file.

I just tried changing the account user_id/password, and the useGBPVR option to true, but it still crashes.

Anthony

I get the same thing...only thing I changed was that import setting to true

Running the new version of zapimport in a .Net 2.0, GBPVR 97.7 environment, I get the following:

Code:

Using Path C:\Program Files\devnz\gbpvr\

Begining zapdb.mdb update process...

   Removing GBPVR Recording Entries...

Unhandled Exception: System.InvalidOperationException: ExecuteNonQuery requires
the command to have a transaction when the connection assigned to the command is
in a pending local transaction.  The Transaction property of the command has no
t been initialized.
   at System.Data.OleDb.OleDbConnectionInternal.ValidateTransaction(OleDbTransac
tion transaction, String method)
   at System.Data.OleDb.OleDbConnection.ValidateTransaction(OleDbTransaction tra
nsaction, String method)
   at System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String met
hod)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behav
ior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at zapmetadata.DatabaseHelper.RemoveAllRecordings()
   at zapmetadata.MainClass.Main(String[] args)

The only change I've made to ZapImport.exe.config is to alter UseGBPVR_XML to "true". I overlayed my old zapdb.mdb with a fresh copy straight from the zip file (just in case ). Any ideas?

I have the exact same error

Did you follow this instruction? It is important....

Update: Added functionality in a new config file for zapimport that allows the tool to reuse the XML that GBPVR downloads to populate its EPG rather than redownloading the entire XML from Zap2it Labs. This is a feture that can save Zap2it Labs bandwidth. To use this functionality you must set the <SaveZap2itXML> tag in the config.xml file of GBPVR to true and set the UseGBPVR_XML value in the new zapimport config file to true.

[ydekmekji]

Yes, both are set to true for me!

[capone]

I had changed it in both places.