Database views - please teach me how (1 Viewer)

emphatic

Design Group
  • Team MediaPortal
  • August 25, 2006
    3,728
    1,185
    Alingsås
    Home Country
    Sweden Sweden
    • Thread starter
    • Moderator
    • #11
    It's weird though, even if MY custom view failed, the standard ones works with "Don't use database" checked. :cautious:

    I'm running an import now for everything with it unchecked to see if I get any hits. Do you want me to post logs?

    Edit: Didn't work. I give up. :(

    Emph
     
    Last edited:

    emphatic

    Design Group
  • Team MediaPortal
  • August 25, 2006
    3,728
    1,185
    Alingsås
    Home Country
    Sweden Sweden
    • Thread starter
    • Moderator
    • #12
    @Deda can you please try this in your working setup? In theory, everything should work, but it seems to be broken actually.

    Emph
     

    emphatic

    Design Group
  • Team MediaPortal
  • August 25, 2006
    3,728
    1,185
    Alingsås
    Home Country
    Sweden Sweden
    • Thread starter
    • Moderator
    • #14
    I think it has to do with me importing everything from .nfo files created by MovPicNFO from Moving Pictures' database. If I use the built in scraper in My Videos, and add my custom genre like you showed me to one item, I get one hit from my custom view, but it's not a movie, so I don't know what's going on.

    Using the .nfo importer is the only way currently for me to get Swedish movie info, as I don't know one scraper exists for My Videos as of yet. If I browse in shares, I can see all the info from the .nfo files like I want to, but filtering is a no-go.

    Thanks for trying though, my bet is that MovPicNFO's output files aren't 100% compatible with My Videos.
    Emph
     

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
  • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    Heh yea :), I know your problem, it's "|" separator. Your nfo genre tag is:
    <genre>|Drama|Animerad|Familjefilm|Musikal|Fantasy|Barn|</genre>

    but MP single line genre separator is "/" so MP expects something like this:
    <genre>Drama/Animerad/Familjefilm/Musikal/Fantasy/Barn</genre>

    or like this (more by the book):
    ....
    <genres>
    <genre>Drama</genre>
    <genre>Animerad</genre>
    <genre>Familjefilm</genre>
    <genre>Musikal</genre>
    <genre>Fantasy</genre>
    <genre>Barn</genre>
    </genres>
    ....

    or like this
    ...
    <genre>Drama</genre>
    <genre>Animerad</genre>
    <genre>Familjefilm</genre>
    <genre>Musikal</genre>
    <genre>Fantasy</genre>
    <genre>Barn</genre>
    ...

    So in your case MP can't determine genres and genre for a movie became
    |Drama|Animerad|Familjefilm|Barn|

    ScreenShot001.jpg


    which is wrong because genres should be listed one by one, not as one line so actually after import we have one big genre as |Drama|Animerad|Familjefilm|Barn| which is <> Barn :).
     
    Last edited:

    emphatic

    Design Group
  • Team MediaPortal
  • August 25, 2006
    3,728
    1,185
    Alingsås
    Home Country
    Sweden Sweden
    • Thread starter
    • Moderator
    • #18
    So, do I have to batch re-write these to change all | to / and that should fix it, or should I suggest this change in the MovPicNFO thread for everyone's interest?

    Thanks, great find!
    Emph
     

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
  • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    Problem is, there is no strong written rules for nfo tags so I tried made nfo import compatible (more or less :)) with XBMC nfo with addition with special MP only tags

    With this (ie for multi genres) you can't miss in MP or XBMC.
    ...
    <genre>Drama</genre>
    <genre>Animerad</genre>
    <genre>Familjefilm</genre>
    <genre>Musikal</genre>
    <genre>Fantasy</genre>
    <genre>Barn</genre>
    ...
     
    Last edited:

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
  • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    Ie nfo sample file for your bambi cartoon should look like (I scraped info form IMDB EN first then saved to new nfo file)

    [collapse]
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <movie>
      <filenameandpath>E:\DummyMovies\Kids Videos\Bambi (1942).mkv</filenameandpath>
      <title>Bambi</title>
      <sorttitle>Bambi</sorttitle>
      <imdb>tt0034492</imdb>
      <language>English</language>
      <country>USA</country>
      <year>1942</year>
      <rating>7.5</rating>
      <runtime>70</runtime>
      <mpaa>G</mpaa>
      <votes>46947</votes>
      <top250>0</top250>
      <studio>Walt Disney Productions</studio>
      <director>James Algar</director>
      <directorimdb>nm0001359</directorimdb>
      <credits>Felix Salten / Perce Pearce</credits>
      <tagline>Walt Disney's multiplane technicolor feature</tagline>
      <outline>Animated film about a young deer, Bambi, growing up in the wild after his mother is shot by hunters.</outline>
      <plot>The animated story of Bambi, a young deer hailed as the 'Prince of the Forest' at his birth. As Bambi grows, he makes friends with the other animals of the forest, learns the skills needed to survive, and even finds love. One day, however, the hunters come, and Bambi must learn to be as brave as his father if he is to lead the other deer to safety.</plot>
      <review>I was staying over at the home of my three-year old niece; after everyone had gone to bed, I found and popped this title in the VCR.  I had only a rough familiarity with the plot (like everyone, I knew Bambi's mother gets killed) and was also aware that "Bambism" has been used as describing a overly sentimental love of wildlife.  Oh wow.  I found that while this movie certainly has a heart for its characters, it is not at all sugarcoated about the realities of animal life.    Consider the following points it makes:  1) Animals do not live in nuclear families.  Bambi lives with his mother only, his presumptive father is off in the background.  2).  Animals often go hungry in the winter.  3).  Male animals must be prepared to fight rivals as a prelude to mating.  4).  Man (here assisted by canine lackeys) is easily the most dangerous threat creatures face.    Rather than putting a Hollywood gloss on animal life, "Bambi" if anything is better than what would be made today.  Remember that the same studio recently put Hercules into a doting nuclear family, the actual circumstances of the hero's birth apparently thought too scandalous for contemporary children to be exposed to (though one presumes ancient Greek children handled them well enough).    Plus when you consider that a large sector of the populace takes a "humanity couldn't possibly be at fault" attitude toward the decimation of animal populations, you know that Point 4). above would today be softpedaled if not entirely neutralized by the addition of sympathetic human characters.  Look what happened with the otherwise excellent TBS production of "Animal Farm."      And the animation!!  The gorgeous, pencil-drawn Impressionistic renditions of the rhythms of the woodlands makes you wonder if modern animators haven't been spoiled by computer graphics.  I'm only sorry I probably won't ever see this film in a theatre, as it was meant to be seen.  As cliche as it may sound, this is a timeless film for all ages.  I cannot praise it highly enough.</review>
      <watched>false</watched>
      <playcount>0</playcount>
      <thumb>Bambi (1942).jpg</thumb>
      <fanart>
        <thumb>Bambi (1942)-fanart.jpg</thumb>
        <thumb>Bambi (1942)-fanart1.jpg</thumb>
        <thumb>Bambi (1942)-fanart2.jpg</thumb>
      </fanart>
      <genre>Animation</genre>
      <genre>Drama</genre>
      <genre>Family</genre>
      <actor>
        <name>James Algar</name>
        <role>Director</role>
        <imdb>nm0019282</imdb>
      </actor>
      <actor>
        <name>Felix Salten</name>
        <role>Writer: from the story by</role>
        <imdb>nm0759041</imdb>
      </actor>
      <actor>
        <name>Perce Pearce</name>
        <role>Writer: story</role>
        <imdb>nm0668998</imdb>
      </actor>
      <actor>
        <name>Hardie Albright</name>
        <role>Adolescent Bambi</role>
        <imdb>nm0017013</imdb>
      </actor>
      <actor>
        <name>Stan Alexander</name>
        <role>Young Flower</role>
        <imdb>nm0018755</imdb>
      </actor>
      <actor>
        <name>Bobette Audrey</name>
        <role>voice uncredited</role>
        <imdb>nm1027883</imdb>
      </actor>
      <actor>
        <name>Peter Behn</name>
        <role>Young Thumper</role>
        <imdb>nm0066951</imdb>
      </actor>
      <actor>
        <name>Thelma Boardman</name>
        <role>Mrs. Quail / Pheasant</role>
        <imdb>nm1028218</imdb>
      </actor>
      <actor>
        <name>Janet Chapman</name>
        <role>voice uncredited</role>
        <imdb>nm0152398</imdb>
      </actor>
      <actor>
        <name>Jeanne Christy</name>
        <role>voice uncredited</role>
        <imdb>nm1036395</imdb>
      </actor>
      <actor>
        <name>Dolyn Bramston Cook</name>
        <role>voice uncredited</role>
        <imdb>nm1028730</imdb>
      </actor>
      <actor>
        <name>Marion Darlington</name>
        <role>Birds</role>
        <imdb>nm0201428</imdb>
      </actor>
      <actor>
        <name>Tim Davis</name>
        <role>Adult Thumper / Adolescent Flower</role>
        <imdb>nm0205561</imdb>
      </actor>
      <actor>
        <name>Donnie Dunagan</name>
        <role>Young Bambi</role>
        <imdb>nm0241760</imdb>
      </actor>
      <actor>
        <name>Sam Edwards</name>
        <role>Adult Thumper</role>
        <imdb>nm0249855</imdb>
      </actor>
      <actor>
        <name>Ann Gillis</name>
        <role>Adult Faline</role>
        <imdb>nm0319268</imdb>
      </actor>
      <actor>
        <name>Otis Harlan</name>
        <role>Mr. Mole</role>
        <imdb>nm0363227</imdb>
      </actor>
      <actor>
        <name>Eddie Holden</name>
        <role>Chipmunk</role>
        <imdb>nm0390187</imdb>
      </actor>
      <actor>
        <name>Sterling Holloway</name>
        <role>Adult Flower</role>
        <imdb>nm0001359</imdb>
      </actor>
      <actor>
        <name>Jack Horner</name>
        <role>voice uncredited</role>
        <imdb>nm0395106</imdb>
      </actor>
      <actor>
        <name>Thelma Hubbard</name>
        <role>Girl Bunny / Quail Mother / Female Pheasant</role>
        <imdb>nm1036576</imdb>
      </actor>
      <actor>
        <name>Cammie King Conlon</name>
        <role>Young Faline</role>
        <imdb>nm0454541</imdb>
      </actor>
      <actor>
        <name>Mary Lansing</name>
        <role>Aunt Ena / Mrs. Possum</role>
        <imdb>nm0487104</imdb>
      </actor>
      <actor>
        <name>Margaret Lee</name>
        <role>Thumper's Mother</role>
        <imdb>nm0497809</imdb>
      </actor>
      <actor>
        <name>Clarence Nash</name>
        <role>Bullfrog</role>
        <imdb>nm0621699</imdb>
      </actor>
      <actor>
        <name>Babs Nelson</name>
        <role>voice uncredited</role>
        <imdb>nm0625161</imdb>
      </actor>
      <actor>
        <name>Sandra Lee Richards</name>
        <role>voice uncredited</role>
        <imdb>nm0724321</imdb>
      </actor>
      <actor>
        <name>Francesca Santoro</name>
        <role>voice uncredited</role>
        <imdb>nm0763903</imdb>
      </actor>
      <actor>
        <name>Fred Shields</name>
        <role>Great Prince of the Forest</role>
        <imdb>nm0793195</imdb>
      </actor>
      <actor>
        <name>Bobby Stewart</name>
        <role>Baby Bambi</role>
        <imdb>nm0829217</imdb>
      </actor>
      <actor>
        <name>John Sutherland</name>
        <role>Adult Bambi</role>
        <imdb>nm0840119</imdb>
      </actor>
      <actor>
        <name>Paula Winslowe</name>
        <role>Bambi's Mother / Pheasant</role>
        <imdb>nm0935514</imdb>
      </actor>
      <actor>
        <name>Elouise Wohlwend</name>
        <role>voice uncredited</role>
        <imdb>nm1033681</imdb>
      </actor>
      <actor>
        <name>Will Wright</name>
        <role>Friend Owl</role>
        <imdb>nm0942926</imdb>
      </actor>
      <trailer>
      </trailer>
    </movie>
    [/collapse]
     
    Last edited:

    Users who are viewing this thread

    Top Bottom