Problems loading database

Discussion in 'My Films' started by styrsven, October 21, 2017.

  1. styrsven

    styrsven Portal Pro

    Joined:
    January 6, 2013
    Messages:
    115
    Likes Received:
    26
    Gender:
    Male
    Ratings:
    +51 / 1
    Home Country:
    Sweden Sweden
    Show System Specs
    I have been looking at returning to myfilms for some time, so I started experimenting with it. With 6.1.3.1470 the long standing issue of not being able to create a catalog from scratch was fixed, so I thought I would give it another try.
    I scanned my collection, that have .nfo files created by TMM. Moving pictures and Kodi have no problems with loading the the files. All the files were scanned, but selecting the "View Movies" tab in the AMC Updater gives this:
    upload_2017-10-21_7-47-50.png
    If i quit AMC Updater and start "MyFilms setup" and push "Save" i get this:
    upload_2017-10-21_7-53-35.png
    And pushing Ok gives this:
    upload_2017-10-21_7-55-24.png
    If I manually edit the catalog file and remove the problematic file from the catalog another file gets reported as the source of the problem.
    I have tried to build the program to run a debug session, but I fail at compiling it (I'm much more at home in a unix/linux environment).



    I wonder if someone wants to have a look at this issue?

    upload_2017-10-21_7-47-50.png upload_2017-10-21_7-53-35.png upload_2017-10-21_7-55-24.png upload_2017-10-21_7-47-50.png upload_2017-10-21_7-53-35.png upload_2017-10-21_7-55-24.png
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. styrsven

    styrsven Portal Pro

    Joined:
    January 6, 2013
    Messages:
    115
    Likes Received:
    26
    Gender:
    Male
    Ratings:
    +51 / 1
    Home Country:
    Sweden Sweden
    Show System Specs
    After some time, I have started to experiment with myfilms again. Using the nfo grabber (as I always do) and the same version of myfilms as above, i have found that at scanning the database I get entries like this
    Code (Text):
    1. <Movie Number="1" Checked="False" MediaType="HDD" Source="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).mkv" Date="2015-02-01" Rating="6.4" OriginalTitle="¡Tre amigos!" TranslatedTitle="¡Tre amigos!" FormattedTitle="¡Tre amigos!" Director="John Landis" Country="Amerikas Förenta Stater" Category="Komedi, Västern" Year="1986" Length="99" Actors="Steve Martin (Lucky Day), Chevy Chase (Dusty Bottoms), Martin Short (Ned Nederlander), Alfonso Arau (El Guapo), Tony Plana (Jefe), Patrice Martinez (Carmen), Jorge Cervera Jr. (Bandito #1), Kai Wulff (German), Abel Franco (Papa Sanchez), Fred Asparagus (Bartender), Jon Lovitz (Morty), Joe Mantegna (Harry Flugleman), Philip Gordon (Rodrigo), Michael Wren (Cowboy), Gene Hartline (Silent Movie Bandito), William B. Kaplan (Silent Movie Bandito), Sophia Lamour (Silent Movie Senorita), Santos Morales (Telegrapher), Phil Hartman (Sam), Tino Insana (Studio Guard), Craig Berenson (Telegram Delivery Boy), Joshua Gallegos (Bar Patron), Norbert Weisser (German's Friend), Brian Thompson (German's Other Friend), Hector Elias (Pedro), Hector Morales (Carlos), Betty Carvalho (Mama Sanchez), Benita Telles (Rosita), Dyana Ortelli (Juanita), Humberto Ortiz (Pablo), Candy Castillo (Bandito #2), Jeff O'Haco (Bandito #3), Loyda Ramos (Conchita), Carl La Fong (Tortoise), Randy Newman (Singing Bush), Rebecca Ferratti (Señorita Kissing Ned), Cosmo Mata (Man in Bar), Brinke Stevens (Actress in Silent Movie), Tom Tangen (Stagecoach Passenger)" URL="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).nfo" Description="Tre arbetslösa stumfilmsskådespelare får ett gig: de ska åka till en mexikansk by för att spela westernhjältar. Vad de inte vet är att deras motspelare, banditerna, är riktiga." VideoFormat="AVC" VideoBitrate="4730" AudioFormat="AC3" AudioBitrate="448" Resolution="1280x720" Framerate="50.000" Languages="engelska, spanska, tyska" Size="3667" Disks="1" Picture="pictures\¡Three Amigos!.jpg" MediaLabel="" Subtitles="" Producer="" Comments="">
    If I edit all the entries like this (I remove the empty attributes at the end of these very long lines) :
    Code (Text):
    1. <Movie Number="1" Checked="False" MediaType="HDD" Source="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).mkv" Date="2015-02-01" Rating="6.4" OriginalTitle="¡Tre amigos!" TranslatedTitle="¡Tre amigos!" FormattedTitle="¡Tre amigos!" Director="John Landis" Country="Amerikas Förenta Stater" Category="Komedi, Västern" Year="1986" Length="99" Actors="Steve Martin (Lucky Day), Chevy Chase (Dusty Bottoms), Martin Short (Ned Nederlander), Alfonso Arau (El Guapo), Tony Plana (Jefe), Patrice Martinez (Carmen), Jorge Cervera Jr. (Bandito #1), Kai Wulff (German), Abel Franco (Papa Sanchez), Fred Asparagus (Bartender), Jon Lovitz (Morty), Joe Mantegna (Harry Flugleman), Philip Gordon (Rodrigo), Michael Wren (Cowboy), Gene Hartline (Silent Movie Bandito), William B. Kaplan (Silent Movie Bandito), Sophia Lamour (Silent Movie Senorita), Santos Morales (Telegrapher), Phil Hartman (Sam), Tino Insana (Studio Guard), Craig Berenson (Telegram Delivery Boy), Joshua Gallegos (Bar Patron), Norbert Weisser (German's Friend), Brian Thompson (German's Other Friend), Hector Elias (Pedro), Hector Morales (Carlos), Betty Carvalho (Mama Sanchez), Benita Telles (Rosita), Dyana Ortelli (Juanita), Humberto Ortiz (Pablo), Candy Castillo (Bandito #2), Jeff O'Haco (Bandito #3), Loyda Ramos (Conchita), Carl La Fong (Tortoise), Randy Newman (Singing Bush), Rebecca Ferratti (Señorita Kissing Ned), Cosmo Mata (Man in Bar), Brinke Stevens (Actress in Silent Movie), Tom Tangen (Stagecoach Passenger)" URL="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).nfo" Description="Tre arbetslösa stumfilmsskådespelare får ett gig: de ska åka till en mexikansk by för att spela westernhjältar. Vad de inte vet är att deras motspelare, banditerna, är riktiga." VideoFormat="AVC" VideoBitrate="4730" AudioFormat="AC3" AudioBitrate="448" Resolution="1280x720" Framerate="50.000" Languages="engelska, spanska, tyska" Size="3667" Disks="1" Picture="pictures\¡Three Amigos!.jpg">
    This edited version is usable without any problem.
    I can think of a number of workarounds/fixes:
    • I can write an xslt transform that runs as a postprocessor that filters away empty attributes
    • I can probably set AMC to not import the attributes that are sometimes (or almost always) empty
    • Maybe there is something in the nfo grabber that can be done
    • or maybe the code can be updated to handle this in a more elegant way.
    I think I need to tell that the current number of films are 2587, so it could be that this issue need some size of the database to show itself.
    Any comments?
     
  4. styrsven

    styrsven Portal Pro

    Joined:
    January 6, 2013
    Messages:
    115
    Likes Received:
    26
    Gender:
    Male
    Ratings:
    +51 / 1
    Home Country:
    Sweden Sweden
    Show System Specs
    I finally worked around this by downloading msxsl.exe from microsoft and put it in my catalog catalog, together with the attached xsl and bat files. I then configured AMCU to run the bat file as post-processing (under the Options tab). I anyone plan to reuse this you have to edit the bat file, as my catalog file name is hardcoded in it.
     

    Attached Files:

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!