[sargorn]

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.

For MySQL installs the table is myvideos75.files
For SQLite installs the table is main.files

---

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.

Hi,

My script was modded for SQLite. If you're using MySQL use BlackSack's original script. (note that the syntax is different, but the output file format is the same. (your generated file should work iirc).

---

Sargorn, I'm running XBMC over windows 7 64bit, I assume all those fancy terminal commands to activate the python are for use in a linux environment and so this wont work for me.

*EDIT: Ha ha, I just read my post - "activate the python"

If you're using MySQL and windows hop6919's .NET app should work for you.

Otherwise, there's always http://www.python.org/getit/windows/

Then you can play with the python all you like... on windows.