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

SINCowboy

Portal Member
September 3, 2015
15
6
Home Country
United States of America United States of America
Country flag
OK, let's start checking for the error.

In my Database, the information in the VolumeLabels is as I described, literally the Windows Hard Drive volume name (regardless of whether it is on the client pc or NAS), No good way to map it to path because in a few cases I have different paths on same drive. Another issue I had is that my Database did not map exactly as yours (fields/columns in a different order), so pulling information by column number led to incorrect information.

I found a workaround to the above by simply manually replacing the info in the VolumeLabel field with the correct path data (from ImportPathes table) and by creating a new database with the columns reordered to match your mapping, giving me partial success. The TVShow.nfo (Series information) is correctly written and the TVShow fanart/etc. is correctly copied; HOWEVER: I am having issues with the episode information.

I discovered that the episode data retrieved (season and episode numbers) don't match the local episodes, so that either the information written to the episode nfo file is for the wrong episode (correct series but wrong episode, ex: episode 7x7 has data from episode 2x1) or the app crashes (I assume because it is attempting to retrieve non-existent information)

I found the code that is causing my problem and have been attempting to modify/rewrite some of the Autoit code that does the season/episode matching of the local_episode and online_episode tables but I still need to wrap my head around the syntax and function of some of the Autoit code (specifically how to build a new array from the online_episode table that matches Series, Season, Episode)
 
Last edited:

SINCowboy

Portal Member
September 3, 2015
15
6
Home Country
United States of America United States of America
Country flag
But about columns having other order, that I have yo think about.

It may not be an issue for others, I have a database that goes back to early MP1 builds that has been updated over the years and I assume there have been many changes to the fields/column order - there is probably a way to map it using row 0 field names... but I just found it easier to make a temp database with field order that matched yours than try to recode.

The second part sounds like I may have done some error.

I *think* there is a bug in the array building (ex: $aTVSeriesGetSeriesOnlineEpisodes - which gets ALL the episodes but the row info doesn't necessarily match the local episodes array the way it is being referenced) but as I mentioned in my first post, my coding skills are decades old and rusty so I'm not positive. Once I am more comfortable with Autoit maybe I will figure it out. (I was thinking of building a new single line array each time an episode nfo file is written to specifically match the local episode)

[Update:] Actually, I realized I don't need to do a multi variable search. Both online_episodes and local_episodes already have a combination ID field. So, I just matched that, seems to work correctly. After I have some coffee I will finish coding.
 
Last edited:

SINCowboy

Portal Member
September 3, 2015
15
6
Home Country
United States of America United States of America
Country flag
raffe,
[edited] I finished some code modifications which fixes the problems I had (wrong episode information issue/crashes) and has some other bug fixes and additions. Later, I may also look at a method to fix the problem if columns are ordered differently. If you are interested in seeing my changes perhaps I can PM you the code (or you can tell me how to send you the changes). I've never code collaborated with anyone so I don't know anything about Github commits, etc.
 
Last edited:

raffe

Portal Pro
March 28, 2008
249
71
Country flag
I have same limited knowledge about Github etc., seems like we both have similar decades old and rusty coding skills ;-) I will try to check how Github works and get back.

EDIT:
Easiest I think is this way:
1. Create an account at Gitlab
2. When you have clicked the link to now our project in Gitlab, click the link Wed IDE (up to the right)
3. On the left side, click on the file you want to change.
4. Then you can, as an example to replace the whole code, select all code in Gitlab (maybe after selecting even hit delete if you want) and copy the whole of your code from Autoit and paste to Gitlab (now only your fixed code is in Gitlab).
5. On the left side, click Commit...
6. It shows what changes you have done, compared to what was there before.
7. If everything seems OK, on the left side click Stage & Commit

After that I can go to MPTVserAndMovPic2MP2nfo.au3 · master · Raffe / MPTVSeries and MovingPictures to MP2 · GitLab and click History to see the new code and learn what was improved :)

In the au3 file we should also remember to update:
Row 17: Version, come up with something that feels right
Row 19: Add new row under change log with info about new version
Row 21: In a new row, add you to the credits

In the README.md update the same. Version, change log & credits
 
Last edited:

joEhSuper

MP Donator
  • Premium Supporter
  • June 2, 2011
    977
    537
    Home Country
    Austria Austria
    Country flag
    Hi @raffe !
    Just found this nice tool - I wasn't happy with MovPicNfo.
    A few question: Ezample Movie & .nfo wich was created by your tool

    1586685700538.png


    1.
    It seems that a lot of fields (most?!?) are not assigned correctly:confused:

    2. If the asset would be correct ;), would it write more than 1 Genre - and when i try to import again, would it give me again alle the Genres.
    Most nfo - scrapers have problem with that:unsure:
     

    Attachments

    • Taxi 2 (2000).zip
      1.6 KB · Views: 0

    raffe

    Portal Pro
    March 28, 2008
    249
    71
    Country flag
    What version of MPTVserAndMovPic2MP2nfo and MediaPortal do you use? My nfo looks like this
    <?xml version="1.0" encoding="UTF-8"?>
    <movie>
    <title>Taxi</title>
    <set> </set>
    <part>1</part>
    <rating>6.8</rating>
    <votes>20008</votes>
    <year>1998</year>
    <plot>In Marseilles (France), skilled pizza delivery boy Daniel who drives a scooter finally has his dreams come true. He gets a taxi license. Caught by the police for a huge speed infraction, he will help Emilien, a loser inspector who can't drive, on the track of German bank robbers, so he doesn't lose his license and his dream job.</plot>
    <tagline> </tagline>
    <runtime>86</runtime>
    <mpaa> </mpaa>
    <language>French</language>
    <id>tt0152930</id>
    <imdb>tt0152930</imdb>
    <director>|Gérard Pirès|</director>
    <studios> </studios>
    <playcount>1</playcount>
    <genre>Action</genre>
    <genre>Comedy</genre>
    <genre>Crime</genre>
    <actor>
    <name>Samy Naceri</name>
    </actor>
    <actor>
    <name>Frédéric Diefenthal</name>
    </actor>
    <actor>
    <name>Marion Cotillard</name>
    </actor>
    <actor>
    <name>Manuela Gourary</name>
    </actor>
    <actor>
    <name>Emma Wiklund</name>
    </actor>
    <actor>
    <name>Bernard Farcy</name>
    </actor>
    <actor>
    <name>Georges Neri</name>
    </actor>
    <actor>
    <name>Guy Quang</name>
    </actor>
    <actor>
    <name>Maurice Murcia</name>
    </actor>
    <actor>
    <name>Sabine Bail</name>
    </actor>
    </movie>
     
    Last edited:

    joEhSuper

    MP Donator
  • Premium Supporter
  • June 2, 2011
    977
    537
    Home Country
    Austria Austria
    Country flag
    V 1.0 :unsure:

    where can I download the latest Version? :notworthy::ROFLMAO:
    1586694896463.png
     

    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
    657
    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
    654
    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
    407
    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
    1K
    • 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
    980
    Top Bottom