[hop6919]

Looks like you figured it out even so

Odd tuple errors and python's sqlite not having similar methods as mysql (no .info() ) made things take longer than they should have.

Almost gave up and re-wrote in perl.

I ran your export script in Frodo (MyVideos75.db), deleted, relocated, re-scraped. I then ran the import function of your script ./xbmcwatched.py import /home/useromitted/.xbmc/userdata/Database/MyVideos75.db
Error: no such table: main.files

I checked the file watchedItems.p and it has all the shows and movies I have watched, it just seems it's not importing them properly. I am using the MySQL shared library, so is there something I should be doing differently?

Edit: I tried backing up watchedItems.p and re running the export script on the newly created database, and it created the same :Error: no such table: main.files" message. This is weird. I may have to just start my watched list again and plan better next time.

The SQL update command I use in my .net solution is slightly different - it uses 'myvideos75.files' instead of 'main.files'. Perhaps trying that will help.