How to get the watched status from moving pictures to myvideos?

Discussion in 'watch/edit Videos' started by MaxMan23, December 23, 2012.

  1. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    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?
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Deda
    • Team MediaPortal

    Deda Lead Dev MP1 Videos

    Joined:
    March 18, 2009
    Messages:
    2,423
    Likes Received:
    2,098
    Gender:
    Male
    Occupation:
    IT Consultant
    Location:
    Zagreb
    Ratings:
    +2,385 / 1
    Home Country:
    Croatia Croatia
    Show System Specs
    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.
     
  4. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    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: December 24, 2012
  5. Deda
    • Team MediaPortal

    Deda Lead Dev MP1 Videos

    Joined:
    March 18, 2009
    Messages:
    2,423
    Likes Received:
    2,098
    Gender:
    Male
    Occupation:
    IT Consultant
    Location:
    Zagreb
    Ratings:
    +2,385 / 1
    Home Country:
    Croatia Croatia
    Show System Specs
    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.
     
  6. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    Home Country:
    Germany Germany
    How can i set all movies to status watched?
     
  7. Deda
    • Team MediaPortal

    Deda Lead Dev MP1 Videos

    Joined:
    March 18, 2009
    Messages:
    2,423
    Likes Received:
    2,098
    Gender:
    Male
    Occupation:
    IT Consultant
    Location:
    Zagreb
    Ratings:
    +2,385 / 1
    Home Country:
    Croatia Croatia
    Show System Specs
    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.
     
  8. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    Home Country:
    Germany Germany
    Sorry for that question, but how can i open the .db3 file with the mysql workbench?
     
  9. Deda
    • Team MediaPortal

    Deda Lead Dev MP1 Videos

    Joined:
    March 18, 2009
    Messages:
    2,423
    Likes Received:
    2,098
    Gender:
    Male
    Occupation:
    IT Consultant
    Location:
    Zagreb
    Ratings:
    +2,385 / 1
    Home Country:
    Croatia Croatia
    Show System Specs
  10. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    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
     
  11. Deda
    • Team MediaPortal

    Deda Lead Dev MP1 Videos

    Joined:
    March 18, 2009
    Messages:
    2,423
    Likes Received:
    2,098
    Gender:
    Male
    Occupation:
    IT Consultant
    Location:
    Zagreb
    Ratings:
    +2,385 / 1
    Home Country:
    Croatia Croatia
    Show System Specs
    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
     
    • Like Like x 1
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!