[RELEASE] Watched Data Export/Import - Programs Addon

  Thread Rating:
  • 2 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #16
Well since the raspberry pi is so slow importing items into the library isn't that just a bigger reason to have a shared library on another machine? Then the quicked machine does most of the work and the raspberry only reads it.

No there's no option where the files goes, it's hardcoded to the same as the local db folder. The file is called watched.xml. But I think once you start having a big sample of watched movies/episodes you will start feeling it's slow on the raspberry pi also.

Exporting/Importing to a totally different set of files is possible but you might get a lot of misses due to filename not being identical (something being worked on with tvdb id and imdb id).

If you find any spelling mistakes you can keep them ;)
find quote
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #17
Version 1.3.1
- Fixed missing count value in old files could lead to error.
- Added lastPlayed info.

I'm working on the tvdb id and also imdb id, but to get it to work I have to split the info into series and movies so it's a bit more work.

If you find any spelling mistakes you can keep them ;)
find quote
JustinAiken Offline
Fan
Posts: 668
Joined: Feb 2007
Reputation: 0
Location: XBMC+Unraid=Happy!
Post: #18
Last night I completely wiped my HTPC, and installed XBMCbuntu from scatch... also set up mySQL on my unRaid...

Right before the wipe, I did an export, and watched.xml was the only file I saved...

Imported ~5500 watched statuses in just under a minute! Smile

Thanks for the plugin, don't know what I would have done without it! Big Grin

XBMC: Frodo 12.2, with Transparency!
17.5 TB Unraid Server: 2500 movies, 8800 episodes of TV Apps: SABnzbd, Sickbeard, Couchpotato, mySQL
HTPC: Win8 (cause Steam), i7 920, ATI 6850 OC
Watching on: Panasonic TC65-PS64 with lowend Sony 5.1 HTIB
find quote
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #19
Very nice to hear that clock2113 Smile

Have you noticed if there were any missing after the import?
Just checking since you have quite a large collection and I'm always looking to improve the code. Smile

If you find any spelling mistakes you can keep them ;)
find quote
Monkeysweat Offline
Member
Posts: 53
Joined: Jun 2010
Reputation: 0
Post: #20
(2012-05-21 09:12)Fox Wrote:  Well since the raspberry pi is so slow importing items into the library isn't that just a bigger reason to have a shared library on another machine? Then the quicked machine does most of the work and the raspberry only reads it.

No there's no option where the files goes, it's hardcoded to the same as the local db folder. The file is called watched.xml. But I think once you start having a big sample of watched movies/episodes you will start feeling it's slow on the raspberry pi also.

Exporting/Importing to a totally different set of files is possible but you might get a lot of misses due to filename not being identical (something being worked on with tvdb id and imdb id).

Well, I've been working on setting up my shared library due to your suggestion, once i have it all figured out it should work.

but your script has helped me out alot as i just ended up rescanning entire library into mysql as the 'library import' feature didn't work properly, but was nice for me just to have to import watched data to get like 500 items flagged Smile
find quote
mcfrojd Offline
Junior Member
Posts: 21
Joined: Apr 2009
Reputation: 0
Post: #21
When importing the .xml file it seems that .flv files won't get marked as watched again.
find quote
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #22
I think there's something else that's causing the problem, can't see any reason why the extension would cause a problem.

Could you have a look in the xml-file and see if they are there and look ok.

*edit*
Did a quick test here with an import of a few flv-files and it worked as it should.

If you find any spelling mistakes you can keep them ;)
(This post was last modified: 2012-06-08 18:56 by Fox.)
find quote
mcfrojd Offline
Junior Member
Posts: 21
Joined: Apr 2009
Reputation: 0
Post: #23
None of these gets marked as watched
<file count="1" id="5989">s04e01 EPT 4 - Barcelona Day 1.flv</file>
<file count="1" id="5990">s04e02 EPT 4 - Barcelona Day 2.flv</file>
<file count="1" id="5991">s04e03 EPT 4 - Barcelona Final Table.flv</file>
<file count="1" id="5992">s04e04 EPT 4 - London Day 1.flv</file>
<file count="1" id="5993">s04e05 EPT 4 - London Final Table.flv</file>
<file count="1" id="5994">s04e06 EPT 4 - Baden Day 1.flv</file>
<file count="1" id="5995">s04e07 EPT 4 - Baden Day 2.flv</file>
<file count="1" id="5996">s04e08 EPT 4 - Baden Final Table.flv</file>
<file count="1" id="5997">s04e09 EPT 4 - Dortmund Day 1.flv</file>
<file count="1" id="5998">s04e10 EPT 4 - Dortmund Day 2.flv</file>
<file count="1" id="5999">s04e11 EPT 4 - Dortmund Final Table.flv</file>
<file count="1" id="6000">s04e12 EPT 4 - Copenhagen Day 1.flv</file>
<file count="1" id="6001">s04e13 EPT 4 - Copenhagen Day 2.flv</file>
<file count="1" id="6002">s04e14 EPT 4 - Copenhagen Final Table.flv</file>
<file count="1" id="6003">s04e15 EPT 4 - San Remo Episode 1.flv</file>
<file count="1" id="6004">s04e16 EPT 4 - San Remo Episode 2.flv</file>
<file count="1" id="6005">s04e17 EPT 4 - San Remo Final Table.flv</file>
<file count="1" id="6006">s04e18 EPT 4 - Monte Carlo Episode 1.flv</file>
<file count="1" id="6007">s04e19 EPT 4 - Monte Carlo Episode 2.flv</file>
<file count="1" id="6008">s04e20 EPT 4 - Monte Carlo Final Table.flv</file>
<file count="1" id="6030">s05e01 EPT 5 - Barcelona Episode 1.flv</file>
<file count="1" id="6031">s05e02 EPT 5 - Barcelona Episode 2.flv</file>
<file count="1" id="6032">s05e03 EPT 5 - Barcelona Final Table.flv</file>
<file count="1" id="6036">s05e07 EPT 5 - Prague Episode 1.flv</file>
<file count="1" id="6037">s05e08 EPT 5 - Prague Episode 2.flv</file>
<file count="1" id="6038">s05e09 EPT 5 - Prague Final Table.flv</file>
<file count="1" id="6039">s05e10 EPT 5 - Dortmund Episode 1.flv</file>
<file count="1" id="6040">s05e11 EPT 5 - Dortmund Episode 2.flv</file>

And i have some more files in my huge .xml file to thats .flv files that won't get marked
these gets marked thou

<file count="1" id="496">The PartyPoker Big Game s05e11.flv</file>
<file count="1" id="497">The PartyPoker Big Game s05e12.flv</file>
<file count="1" id="498">The PartyPoker Big Game s05e13.flv</file>
<file count="1" id="499">The PartyPoker Big Game s05e14.flv</file>
<file count="1" id="500">The PartyPoker Big Game s05e15.flv</file>
<file count="1" id="501">The PartyPoker Big Game s05e16.flv</file>
<file count="1" id="502">The PartyPoker Big Game s05e17.flv</file>
<file count="1" id="503">The PartyPoker Big Game s05e18.flv</file>
<file count="1" id="504">The PartyPoker Big Game s05e19.flv</file>
<file count="1" id="505">The PartyPoker Big Game s05e20.flv</file>
these won't get marked.
<file count="1" id="4268">s2009e02 PCA 2009 - High Roller - Final Table.flv</file>
<file count="1" id="4267">s2009e01 PCA 2009 - High Roller - Episode 1.flv</file>

could it be the " - " in the filenames that causing this?
(This post was last modified: 2012-06-08 19:07 by mcfrojd.)
find quote
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #24
Very strange, do you get them shown as errors in the dialog box or do they just not get marked as watched?

If you find any spelling mistakes you can keep them ;)
find quote
mcfrojd Offline
Junior Member
Posts: 21
Joined: Apr 2009
Reputation: 0
Post: #25
no error just not marked.

i went trou all xml file looking for .flv files, the ones with an " - " and sometimes "-" seems to be the ones making trouble.
Gonna look if some other files with " - " or "-" is doing the same.
find quote
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #26
(2012-06-08 19:01)mcfrojd Wrote:  could it be the " - " in the filenames that causing this?

That might be, I'll check that.

If you find any spelling mistakes you can keep them ;)
find quote
mcfrojd Offline
Junior Member
Posts: 21
Joined: Apr 2009
Reputation: 0
Post: #27
No work
<file count="1" id="4270">s2010e02 PCA 2010 - High Roller - Episode 2.mp4</file>
<file count="1" id="4269">s2010e01 PCA 2010 - High Roller - Episode 1.mp4</file>

Work
<file count="1" id="2687">World.Poker.Tour.s09e42.Seminole Hard Rock Showdown - Part 2 HDTV.XviD-AT.avi</file>
<file count="1" id="2686">World.Poker.Tour.s09e41.Seminole Hard Rock Showdown - Part 1 HDTV.XviD-AT.avi</file>
<file count="1" id="2685">World.Poker.Tour.s09e40.Hollywood Poker Open - Part 2 HDTV.XviD-AT.avi</file>
<file count="1" id="2684">World.Poker.Tour.s09e39.Hollywood Poker Open - Part 1 HDTV.XviD-AT.avi</file>
<file count="1" id="2683">World.Poker.Tour.s09e36.Bay 101 Shooting Star - Part 2 HDTV.XviD-AT.avi</file>
find quote
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #28
Hmmm could be the season episode in the beginning but I don't see why that should be a problem.

If you find any spelling mistakes you can keep them ;)
find quote
mcfrojd Offline
Junior Member
Posts: 21
Joined: Apr 2009
Reputation: 0
Post: #29
maybe some combo with season and episode in the beginning and the use of space " " in filenames.
i seem to have about 300 files thats won't get marked, when making a new export it reports about 300 files less then when importing the previous file
These files in my xml file seems a bit strange to.
<file count="1" id="3515">banner.jpg</file>
<file count="1" id="3518">season-all.jpg</file>
<file count="1" id="3520">folder.jpg</file>

i can confirm that all lines in my xml file that starts with s**e** won't get marked
(This post was last modified: 2012-06-08 19:40 by mcfrojd.)
find quote
Fox Offline
Senior Member
Posts: 131
Joined: Oct 2003
Reputation: 1
Post: #30
Ya I tried it with minus signs here and that seems to be fine.

But I wonder what happens with your files that begin with season and episode, do they get scanned into the library correctly?

*edit*
Did you export with another version then the one you are using now?

*edit2*
(2012-06-08 19:33)mcfrojd Wrote:  These files in my xml file seems a bit strange to.
<file count="1" id="3515">banner.jpg</file>
<file count="1" id="3518">season-all.jpg</file>
<file count="1" id="3520">folder.jpg</file>

i can confirm that all lines in my xml file that starts with s**e** won't get marked

wow those are really strange, how can they be in the video database at all.

If you find any spelling mistakes you can keep them ;)
(This post was last modified: 2012-06-08 19:44 by Fox.)
find quote
Post Reply