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

[SINCowboy]

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)

 

[raffe]

OK, now I understand. Then I would use Function DriveGetDrive and Function DriveGetLabel to populate the folders list and it would work better.

But about columns having other order, that I have yo think about.

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

 

[SINCowboy]

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.​

 

[SINCowboy]

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.

 

[raffe]

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

 

[SINCowboy]

I have same limited knowledge about Github etc., seems like we both have similar decades old and rusty coding skills ;-)

2 old farts trying to code, huh?

Easiest I think is this way:
1. Create an account at Gitlab

OK, done. I will PM you with some questions​

 

[joEhSuper]

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

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

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

 

[raffe]

What version of MPTVserAndMovPic2MP2nfo and MediaPortal do you use? My nfo looks like this

Spoiler: nfo

<?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>

 

[joEhSuper]

V 1.0

where can I download the latest Version?

 

[joEhSuper]

<genre>Action</genre>
<genre>Comedy</genre>
<genre>Crime</genre>

... and when you use this nfo for importing/scraping in MovingPictures you get ALL THREE Genres?