[freehood4all]

Upgrading to 1.9.x did the trick, should have RTFM.

By the way to anyone who tries to install ruby on Ubuntu ruby-rvm package is screwed up and you will need to install from github

First time I've setup a dev environment for ruby, it looks like a crazy ass language!

Thanks a ton clock2113!

[saitoh183]

Ruby script to import the watched statuses: https://github.com/JustinAiken/xbmc_watc...s_importer

Hope it helps someone else!

Trying this now and getting errors

Code:

C:\Ruby193\xbmc_>bundle
The source :rubygems is deprecated because HTTP requests are insecure.
Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not.
Fetching gem metadata from http://rubygems.org/...........
Fetching gem metadata from http://rubygems.org/..
Resolving dependencies...
Installing i18n (0.6.1)
Installing multi_json (1.5.0)
Installing activesupport (3.2.8)
Installing builder (3.0.4)
Installing activemodel (3.2.8)
Installing arel (3.0.2)
Installing tzinfo (0.3.35)
Installing activerecord (3.2.8)
Installing mysql2 (0.3.11)
Installing sqlite3 (1.3.7)
Installing xml-simple (1.1.2)
Using bundler (1.3.0)
Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed.
Post-install message from mysql2:

======================================================================================================

  You've installed the binary version of mysql2.
  It was built using MySQL Connector/C version 6.0.2.
  It's recommended to use the exact same version to avoid potential issues.

  At the time of building this gem, the necessary DLL files where available
  in the following download:

  http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick

  And put lib\libmysql.dll file in your Ruby bin directory, for example C:\Ruby\bin

======================================================================================================


C:\Ruby193\xbmc_>watched.rb
C:/Ruby193/lib/ruby/1.9.1/psych.rb:203:in `parse': (<unknown>): found unknown escape character while parsing a quoted scalar at line 12
column 11 (Psych::SyntaxError)
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:203:in `parse_stream'
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:151:in `parse'
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:127:in `load'
        from C:/Ruby193/xbmc_/watched.rb:6:in `<main>'

[hop6919]

For those Windows users like me who prematurely upgraded to Frodo before checking if they could take this fantastic little add-on with them, I have created this small .net application.

It can import the old watched.xml file created by Fox's add-on into Frodo, and can also export back out to a similar xml file. The only limitations being that it is only for those that have a MySQL back-end for XBMC, and it isn’t an XMBC add-on. You may also need to install the MySQL connector for .net:

http://dev.mysql.com/downloads/connector/net/

Please feel free to use it and comment. I’ve packed it all up into a zip file, including the source code for anyone interested. Thanks to BlackSack for the SQL statements that I shamelessly stole.

As for the settings – I think they’re pretty straight forward. The Username and Password are normally both ‘xbmc’.

Here is the download:

http://www.2shared.com/file/4ZzeCWIg/XBM...er_10.html

Hope this helps!

edit: see my later post for an updated version

[JustinAiken]

Ruby script to import the watched statuses: https://github.com/JustinAiken/xbmc_watc...s_importer

Hope it helps someone else!

Trying this now and getting errors

Code:

C:\Ruby193\xbmc_>bundle
The source :rubygems is deprecated because HTTP requests are insecure.
Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not.
Fetching gem metadata from http://rubygems.org/...........
Fetching gem metadata from http://rubygems.org/..
Resolving dependencies...
Installing i18n (0.6.1)
Installing multi_json (1.5.0)
Installing activesupport (3.2.8)
Installing builder (3.0.4)
Installing activemodel (3.2.8)
Installing arel (3.0.2)
Installing tzinfo (0.3.35)
Installing activerecord (3.2.8)
Installing mysql2 (0.3.11)
Installing sqlite3 (1.3.7)
Installing xml-simple (1.1.2)
Using bundler (1.3.0)
Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed.
Post-install message from mysql2:

======================================================================================================

  You've installed the binary version of mysql2.
  It was built using MySQL Connector/C version 6.0.2.
  It's recommended to use the exact same version to avoid potential issues.

  At the time of building this gem, the necessary DLL files where available
  in the following download:

  http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick

  And put lib\libmysql.dll file in your Ruby bin directory, for example C:\Ruby\bin

======================================================================================================


C:\Ruby193\xbmc_>watched.rb
C:/Ruby193/lib/ruby/1.9.1/psych.rb:203:in `parse': (<unknown>): found unknown escape character while parsing a quoted scalar at line 12
column 11 (Psych::SyntaxError)
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:203:in `parse_stream'
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:151:in `parse'
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:127:in `load'
        from C:/Ruby193/xbmc_/watched.rb:6:in `<main>'

Can you paste your database.yml?

[saitoh183]

Ruby script to import the watched statuses: https://github.com/JustinAiken/xbmc_watc...s_importer

Hope it helps someone else!

Trying this now and getting errors

Code:

C:\Ruby193\xbmc_>bundle
The source :rubygems is deprecated because HTTP requests are insecure.
Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not.
Fetching gem metadata from http://rubygems.org/...........
Fetching gem metadata from http://rubygems.org/..
Resolving dependencies...
Installing i18n (0.6.1)
Installing multi_json (1.5.0)
Installing activesupport (3.2.8)
Installing builder (3.0.4)
Installing activemodel (3.2.8)
Installing arel (3.0.2)
Installing tzinfo (0.3.35)
Installing activerecord (3.2.8)
Installing mysql2 (0.3.11)
Installing sqlite3 (1.3.7)
Installing xml-simple (1.1.2)
Using bundler (1.3.0)
Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed.
Post-install message from mysql2:

======================================================================================================

  You've installed the binary version of mysql2.
  It was built using MySQL Connector/C version 6.0.2.
  It's recommended to use the exact same version to avoid potential issues.

  At the time of building this gem, the necessary DLL files where available
  in the following download:

  http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick

  And put lib\libmysql.dll file in your Ruby bin directory, for example C:\Ruby\bin

======================================================================================================


C:\Ruby193\xbmc_>watched.rb
C:/Ruby193/lib/ruby/1.9.1/psych.rb:203:in `parse': (<unknown>): found unknown escape character while parsing a quoted scalar at line 12
column 11 (Psych::SyntaxError)
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:203:in `parse_stream'
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:151:in `parse'
        from C:/Ruby193/lib/ruby/1.9.1/psych.rb:127:in `load'
        from C:/Ruby193/xbmc_/watched.rb:6:in `<main>'

Can you paste your database.yml?

Sorry i dont have it anymore. Since i couldnt find the solution, i decided to just use Trakt.tv to sync the Eden install and installed it on Frodo and synced it back

[oldtvwatcher]

Is there any hope of this being updated for Frodo? If not, I will try BlackSack's or sargorn's python script as shown at http://forum.xbmc.org/archive/index.php?...874-8.html (posts dated 2012-12-30, 20:27 and 2013-01-30, 17:42 - not sure which would be the correct one to use) but I would prefer to see an update of this addon, since it worked so well from inside XBMC.

EDIT: sargorn's script turned out to be the one that worked for me.

I will note that when I upgraded from Eden to Frodo I did NOT blow away the existing database and nevertheless it seems to work okay (after tweaking the sound settings) and it preserved all my existing watched flags, but I still would like the ability to back them up, "just in case". Restoring items from the existing database is not a priority for me, but I can see how it would be for those who started over from scratch.

[shaktoo]

please just make an update for frodo .. I will try and get the other workaround but really is a very important feature that should be built into xbmc itself for future installs etc etc

[hop6919]

Here is an update to the .NET app that I wrote a little while ago. It can now set the watched flag for XBMC videos in either a shared MySQL library or the normal local SQLite .db file.

You can use this app in Frodo to import the watched.xml file created by the old add-on, and also export back out a similar xml file.

You don't need to install anything else as I've included all the dlls in the app folder. Source code is also included for anyone interested.

The local .db file doesn't need a password, but the username and password for the shared library is normally ‘xbmc’.

Here is the download:

http://code.google.com/p/xbmc-frodo-watc...loads/list

Hope it helps

[devkid]

Here is a pretty much complete rewrite of this addon to be compatible with Frodo and hopefully more future-proof. When importing the XML file the videos are matched by scraper titles and release year. So it does not care if you renamed the video or moved the video to another folder, it will still match.
This is a first version so bug reports are very appreciated.

script.watched.states-1.0.0.zip

When reporting bugs please enable XBMC debug mode and provide the complete logfile. Thank you.

[pettergulbra]

Would it be possible to have this run on two machines to sync the watched list between them?

PC and a Samsung Tab f.eks.

[chicowoodhill]

Here is a pretty much complete rewrite of this addon to be compatible with Frodo and hopefully more future-proof. When importing the XML file the videos are matched by scraper titles and release year. So it does not care if you renamed the video or moved the video to another folder, it will still match.

Thanks for this. I installed and ran it on my road machine and examined the exported watched.xml file...looks good. Now when I get to my home machine in a couple of days I'll import the .xml file and hopefully we're back in business. I'll report back soon...

Thanks again...

[devkid]

Would it be possible to have this run on two machines to sync the watched list between them?

PC and a Samsung Tab f.eks.

Not out of the box as it is. You are probably better off using a shared MYSQL database: http://wiki.xbmc.org/?title=HOW-TO:Sync_..._libraries

[PatrickBateman]

Does thiS updated frodo version have the same restriction with files names as the eden version, such as:

TV Shows/Show Name/Season/s01e01.avi
Etc

[devkid]

I am sorry but I dont know which restriction you are referring to since I did not use the old version with Eden. Could you elaborate a bit?

[PatrickBateman]

Hey Devkid, It's mentioned in the first post as a known issue

If you have your tv episodes named with only season and episode number (ie. s01e01.avi) or movies without name, this addon won't work for you.

I don't think it was particularly good at differentiating between the following types of files:
TV Shows/Friends/Season1/s01e01.avi
TV Shows/Scrubs/Season1/s01e01.avi

Does your version resolve that issue, unfortunately I name my fils this way