[solved] Export tool and import support from MP-TVSeries & Moving Pictures to MP2 (1 Viewer)

raffe

Portal Pro
March 28, 2008
249
71
Country flag
That is the latest version. Yes, that is how <genre> should work, see that also <actor> is similar. Maybe it is something about language or maybe you have a different database compared to mine?

EDIT 1: I think your database must be different from mine. All these seem wrong:
Code:
  <rating>Daniel ist der rasanteste Taxifahrer Marseilles, weswegen er auch seinem Schwiegervater in spe auf die Schnelle aushelfen muss. Der hochrangige französische General hat nämlich völlig die Ankunft des japanischen Verteidigungsministers vergessen. Am Flughafen eingetroffen, muss Daniel seiner Fahrkünste wegen dem hohen Besuch gleich noch eine polizeichlich entwickelte Anti-Terror-Limousine vorführen. Was dabei keiner ahnt: Yakuzas haben es auf Leib und Leben des fernöstlichen Staatsmannes abgesehen und liegen bereits im Hinterhalt.</rating>
  <votes>|ARP Sélection|TF1 Films Production|</votes>
  <year>2000-03-23 23:00:00Z</year>
  <tagline>Deutsch|Français|日本語</tagline>
  <runtime>|paris, france|yakuza|police operation|special unit|</runtime>
  <mpaa>|Action|Kom├╢die|</mpaa>
  <id>6.2</id>
  <studios>C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\MovingPictures\Covers\Thumbs\{Taxi.Taxi-2000} [1139013602].jpg</studios>
  <genre>2000</genre>
EDIT 2: Check the content of your database at C:\ProgramData\Team MediaPortal\MediaPortal\database\movingpictures.db3 , maybe with the tool here: DB Browser for SQLite
Compare your tables with mine, see from row 2096 here MPTVserAndMovPic2MP2nfo.au3 · master · Raffe / MPTVSeries and MovingPictures to MP2
First column is 0, the next 1 and so on.
 
Last edited:

joEhSuper

MP Donator
  • Premium Supporter
  • June 2, 2011
    977
    536
    Home Country
    Austria Austria
    Country flag
    Thanks for your help @raffe !
    Sadly I'm absolutly not familiar to that db stuff :whistle::unsure::notworthy:

    So you're talking about this - right? -->
    1586775681229.png


    This is what I can find in my MovPic DB (I'm so proud that I found this :ROFLMAO::D)
    1586776129276.png


    OK... do I unserstand right: e.g. Genre:

    Your table: <Genre> has id 08
    My table: id 08 is <release date> <Genre> would be id 10

    :ROFLMAO:OMG:ROFLMAO: how could this happen :eek:

    MovingPictures: 1.8.4.1.
    Mediaportal: 1.24
     

    raffe

    Portal Pro
    March 28, 2008
    249
    71
    Country flag
    If you count id as 0, title as 1 and so on. Then your genre is 9, and mine 8. It seems like until actors, our is the same, then they differ. After summary, they are even more different. This is my table
    Skärmklipp.JPG

    I don't know why they are different, but we (you) can fix this. First step is to make a table of what is right for you. Complete the info in the table here under, add what columnt numbers are right by your database after "Your = ":
    Code:
    ;~ XML use          TABLE         COLUMN               
    ;~ Info             local_media   Your =           (old = 0  id                 1799)
    ;~ Info             movie_info    Your =           (old = 0  id                 1584 (via 1799 & local_media__movie_info table)
    ;~ *<title>         movie_info    Your =           (old = 1  title              2 Fast 2 Furious
    ;~ *<sorttitle>     movie_info    Your =           (old = 3  sortby             2 fast 2 furious
    ;~ *<originaltitle>
    ;~ *<set>           movie_info    Your =           (old = 28 collections        (multiple XML (or |?)) The Fast and the Furious
    ;~ *<part>         local_media    Your =           (old = 6 part               1
    ;~ *<rating>        movie_info    Your =           (old = 13 score              5.2
    ;~ *<votes>         movie_info    Your =           (old = 14 popularity         243
    ;~ *<year>          movie_info    Your =           (old = 07 year               2003
    ;~ *<plot>          movie_info    Your =           (old = 12 summary            Former cop Brian O'Conner...
    ;~ *<tagline>       movie_info    Your =           (old = 11 tagline            2Cool
    ;~ *<runtime>       movie_info    Your =           (old = 16 runtime            107
    ;~ *<mpaa>          movie_info    Your =           (old = 09 certification      PG-13
    ;~ <certification>  movie_info    Your =           (old = 09 certification      PG-13
    ;~ *<language>      movie_info    Your =           (old = 10 language           (multiple XML or |?) English
    ;~ *<id>            movie_info    Your =           (old = 17 imdb_id            tt0322259
    ;~ *<imdb>          movie_info    Your =           (old = 17 imdb_id            tt0322259
    ;~ *<director>      movie_info    Your =           (old = 04 directors          (multiple XML or |?) |Benny Chan|Hanna Saw|
    ;~ *<studios>       movie_info    Your =           (old = 26 studios            (multiple XML) |DreamWorks Animation|Bullwinkle Studios|
    ;~ *<playcount>     user_movie_settings Your =           (old = id = movie_info_id) column 3 - watched
    ;~ *<genre>         movie_info    Your =           (old = 08 genres             (multiple XML) |Action|Crime|Thriller|
    ;~ *<actor><name>   movie_info    Your =           (old = 6  actors             (multiple XML) |Paul Walker|Tyrese Gibson|
    This is the hard part. Do this very carefully and accurately, then the rest will be easy (y)
     

    emphatic

    Design Group
  • Team MediaPortal
  • August 25, 2006
    3,618
    1,103
    Alingsås
    Home Country
    Sweden Sweden
    Country flag
    Excuse me if this has already been addressed, but why is this a 64 bit application? My Mediaportal 1 installation is on a 32 bit system, as the program is 32bit. Now it's telling me I can't run it. Or should I copy over the databases from my HTPC to a 64 bit system?

    Kinda counter intuitive?
    Emph
     

    raffe

    Portal Pro
    March 28, 2008
    249
    71
    Country flag
    Excuse me if this has already been addressed, but why is this a 64 bit application? My Mediaportal 1 installation is on a 32 bit system, as the program is 32bit. Now it's telling me I can't run it. Or should I copy over the databases from my HTPC to a 64 bit system?

    Kinda counter intuitive?
    Emph
    I am just an ordinary user, just like you. I made an unofficial tool that I needed, and then I shared it here. You kinda grateful?

    If you want a 32-bit version, you can easily compile it yourself with the provided file MPTVserAndMovPic2MP2nfo.au3 at Files · master · Raffe / MPTVSeries and MovingPictures to MP2

    Here is a guide on how to install:
    1. From AutoIt Downloads - AutoIt , get and run "AutoIt Full Installation"

    During installation I choose
    * "Use native x64 tools". HERE, you should choose whatever you like ;-)
    * "Edit the script".
    * Choose "Components".
    * Choose standard "Install location"

    2. Get and install "AutoIt Script Editor" from AutoIt Script Editor Downloads - AutoIt

    * Choose all standard alternatives.

    Here you can read more about installation (until ”Download pop-up example”): AutoIt Tutorial - AutoIt Download, Install and Write Your First AutoIt Script to Handle Windows Pop-up

    A video of installation:


    3. Here is info about the easiest way to compile to x86 (32-bit):


    4. Get sqlite3.dll for 32-bit
    Here Function _SQLite_Startup they say that you can get the 32-bit dll from Index of /autoit3/pkgmgr/sqlite . It is easiest if you just rename it to sqlite3_x64.dll and have it in the same folder as the exe you compiled. But you can also use the name sqlite3.dll, if you edit the script to use that name before compiling the script if you prefer:

    Some video tutorials: https://www.youtube.com/playlist?list=PL4Jcq5zn02jKpjX0nqI1_fS7mEEb5tw6z

    Hello world tutorial: Tutorial - HelloWorld

    More tutorials: Tutorials - AutoIt Wiki
     
    Last edited:

    emphatic

    Design Group
  • Team MediaPortal
  • August 25, 2006
    3,618
    1,103
    Alingsås
    Home Country
    Sweden Sweden
    Country flag
    Sad to see you replied so late, I've long since moved from 32bit to 64bit, so you've gone through all that trouble to help me for nothing. Thanks anyway.

    Emph
     

    Users who are viewing this thread

    Similar threads

    I will see what I can do to make it better. ;)
    I will see what I can do to make it better. ;)
    I tried migrating from MP1 to MP2 for the second time today. I've found that the movie importer doesn't seem to pick up on a number...
    Replies
    4
    Views
    622
    Yes, kicked in and updated several items this morning.:)
    Yes, kicked in and updated several items this morning.:)
    I know there have been problems with the TVDB api and for me both Moving Pictures and MP-TV Series plugins are no longer working in...
    Replies
    2
    Views
    581
    Afternoon guys, As the title implies, I have my movies and series organised using tiny media manager and as of an update to tMM (maybe 6 months ago) it now includes keyart.jpg as a downloadable media file. My folders include. poster.jpg banner.jpg etc. and keyart.jpg After an import, for me, MP2 displays the keyart.jpg as the...
    Afternoon guys, As the title implies, I have my movies and series organised using tiny media manager and as of an update to tMM...
    Afternoon guys, As the title implies, I have my movies and series organised using tiny media manager and as of an update to tMM...
    Replies
    0
    Views
    364
    Hi Lehmden Please forgive me for not making things clear, and ny the way, it's not you, your English is absolutely perfect. Europe ALWAYS puts us to shame when it comes to language because in UK "Education" we spend so long learning how wonderful the UK and its monarchy is we don't have time to learn the more important and useful...
    Hi Lehmden Please forgive me for not making things clear, and ny the way, it's not you, your English is absolutely perfect. Europe...
    Hi I am trying MP2 and getting on very well, finding the system more logical and very smooth now. The setup and configuration all...
    Replies
    10
    Views
    966
    • Sticky
    We are proud to present MediaPortal 2.3.2 MediaPortal 2.3.2 is a full-blown media center software that addresses the most common user requirements out of the box. Aside from its support for Live TV and Radio, it offers a complete media server for music, movies, and TV shows. Info is automatically downloaded from various sources to...
    We are proud to present MediaPortal 2.3.2 MediaPortal 2.3.2 is a full-blown media center software that addresses the most common...
    We are proud to present MediaPortal 2.3.2 MediaPortal 2.3.2 is a full-blown media center software that addresses the most common...
    Replies
    0
    Views
    848
    Top Bottom