How to get the watched status from moving pictures to myvideos? (1 Viewer)

[MaxMan23]

Hi,

i want to change my Database from moving pictures to myvideos. By using movpicnfo, i created all the .nfo files. there is also a file named ...WatchStatus.xml.
When i import the Database by using the myvideos nfo scraper i get all the of the nfo files but not the watched status of the ...WatchStatus.xml
What could i do?

 

[Deda]

Just post one of you watched movie nfo file. I think I know what is the problem but just need nfo to confirm and fix this.

 

[MaxMan23]

I know what you want to see... Movpicnfo doesnt save the <watched>true</watched> status in the .nfo file. It created a separate ...WatchStatus.xml file. I think this would not be reading by the myvideo scraper..

But how do you get the status from one database to the other ?

 

[Deda]

Actually, there can be 2 tags, "watched" and "playedcount". As in my vids those two are not directly dependent (playedcount is historical data, watched can be reset) in case "watched" not exists and "playedcount" (XBMC style) is > 1 movie is not flagged as watched. I made fix for that in next release so XBMC sytle nfo can set movie as watched if playedcount is greater than 0 even "watched" not exist.

Concerning "WatchStatus.xml" I can't do anything.

 

[MaxMan23]

How can i set all movies to status watched?

 

[Deda]

All in one only by some external SQLite editor with commands executed on videodatabase:

UPDATE movie SET watched=1, iwatchedPercent =0, timeswatched=1 WHERE movie.idMovie in (SELECT idmovie from movieinfo)
UPDATE movieinfo set iswatched=1 where movieinfo.idMovie in (SELECT idmovie from movie)

or manually in GUI (title view) or config(videodatabase editor) by set/reset watched status one by one.

 

[MaxMan23]

Sorry for that question, but how can i open the .db3 file with the mysql workbench?

 

[Deda]

You can't (except if mysql tool can open SQLite databse).

There is many free SQLite tools available (http://www.sqlite.org/cvstrac/wiki?p=ManagementTools)

I use this (add on for Firefox) -> https://code.google.com/p/sqlite-manager/

 

[MaxMan23]

Ok, there is a new MvoPicNfo
https://forum.team-mediaportal.com/threads/movpicnfo.108725/page-6#post-949910

The watched Status is now in the nfo file:

´╗┐<?xml version="1.0" encoding="UTF-8"?>
<movie>
<title>"Monsters"</title>
<sorttitle>monsters</sorttitle>
<originaltitle>|Monsters|</originaltitle>
<rating>7.1</rating>
<year>1988</year>
<plot>Keine deutsche Zusammenfassung, bitte erstellen bei www.imdb.de.

Englisch:</plot>
<tagline>
</tagline>
<runtime>30</runtime>
<mpaa>
</mpaa>
<language>nglisch</language>
<id>tt0094512</id>
<director>|Tom Noonan|Christopher Todd|Debra Hill|Ernest D. Farino|Bette Gordon|Jeffrey Wolf|Jerry Smith|Brian Thomas Jones|Theodore Gershuny|David Misch|</director>
<studios>
</studios>
<watched>True</watched>



Then i cleared the Database and import by using the internal nfo grabber, but the watched status is not marked....

 

[Deda]

All is ok except :
<watched>True</watched>

it's not problem in your nfo but in MP (it specifically needs "true" -> lowercase), this is fixed for 1.3.0RC