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

MaxMan23

MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    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

    Lead Dev MP1 Videos
  • Premium Supporter
  • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    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

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    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 :)?
     
    Last edited:

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
  • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    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.
     

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
  • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    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

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    Sorry for that question, but how can i open the .db3 file with the mysql workbench?
     

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    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....

    Bild1.png
     

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
  • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    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
     

    Users who are viewing this thread

    Top Bottom