Hi.
Link to German thread:
https://forum.team-mediaportal.com/threads/mp2-edit-ein-editor-für-die-mediaportal2-medienbibliothek.129077
In this thread I like to introduce you a tool to edit the MediaPortal2 media library (ML). As there is no "official" way to correct mistakes in the MP2 ML I've started developing this tool. Aside this, MP2-Edit is offering help during migration from MP1 over to to MP2. There is a heavy work going on this not even tiny project, so mistakes, bugs and other glitches are to be expected.
Some notes before to start. As there is no "official" way recently available to access the MP2 database, MP2-Edit is using the SQLite database with "illegal" direct access. No other DB plugins than the default SQLite plugin is working with MP2-Edit. All fanart is stored in a cache on local file system of the MP2 server, so MP2-Edit needs to run on the same machine than the MP2 server itself. And as it needs to access system folders it needs to run with Admin rights. All this is planed to be changed later, but right now it's necessary.
In future MP2-Edit should be able to edit all aspects of the MP2 ML. But this will take a long time until this happens. As a big fan of TV series, I've started with the series part for sure...
This is working in the current version:
Generic management and migration:
A full blown Backup tool is integrated as with version 0.4.0. With this you can do automatic backups triggered by a scheduled task. You can add the schedule, edit and delete it. And you can manually delete or restore backup files to the MP2 server. An extra tool named MP2-Backup is doing the backups invisible and without disturbing the usage of MP2 and/or your PC at all. MP2-Backup also is called every time you close MP2-Edit, just to have your latest work stored...
The task scheduler needs the time in 24 hours format so you have to enter it this way. The time on screen-shot is 7pm. If you set 0 as number of backups to keep then all backups are kept and you are responsible for the disk space your own.
Default settings are do a backup every day of the week at 8pm and keep 7 days of backup...
When you leave MP2-Edit a manual backup is triggered.
You can backup and restore the "watched flags" of your series collection too. As the format of the watched backup is compatible with TVSeries you simply can import your watched flags from TVSeries into MP2. This is done in TVSeries config, tab general:
Here you also can import watched flags from MP2 into TVSeries. As with v 0.5.0 the watched status of the MP2 movies- part can be exported in a similar format. And it's possible to export those flags from MovingPictures, MyFilms and MyVideos too. Later you can import those flags into MP2 ML. But as none of those plugins has an import function similar to TVSeries this is an "one way only" option here for movies.
Media management:
The series part is fully functional. You can edit all series specific data in the MP2 ML. And the fanart management is working too. You can replace unwanted fanart, remove broken files or add missing fanart of all types available (Poster, Banner, Backdrop, Season-Poster, Season-Banner and Episodes-Thumb) ClearArt and similar is not used by MP2 at all today. If this will change, MP2-Edit will add those features too. As with version 0.3.0 the movies part is working too.
And with v 0.5.0 the movieset management also is working.
A full manual will be written later. Some notes for a quick start.
MP2-Edit is installed by an average installer and will find it's home in "C:\Program Files (x86)\Team MediaPortal\MP2-Edit\" (or without the (x86) on 32 bit OS). So nothing special here.
To edit the database it's necessary to stop MP2 server prior to use MP2-Edit.
This normally is no big deal, but if you use TV with MP2 this will interrupt all running recordings and also prevent scheduled recordings from starting. That's why MP2-Edit is asking if it's safe to stop MP2 Server. The start of MP2-Edit can last a while, so a splash-screen is showing what happens under the hood.
After start-up the settings are presented. If you change something here (e.G. the GUI language) you need to restart MP2-Edit to make the changes work.
When you select the tab "series" it will look like this:
For further work it's absolutely necessary that all episodes will have the TVDB ID field filled with proper ID. Due to various circumstances during import it's possible that not all episodes will have this very important data. This can and will lead to errors. An indicator is shown, if a series has at least a single episode without a TVDB ID. If it looks like the screen-shot above, all is good and you can go on with whatever you want to do. But attention, if it's looking like this:
Have a look at the red "X" near the TVDB ID field.
This shows up if a series has at least one episode without TVDB ID and needs to be changed before you can do other work on this series. This is done easily by refreshing the complete series. All episodes will get the TVDB and IMDB ID entered in the corresponding fields. And you can set the whole series as watched or unwatched, if you want. This is selected by the three radio buttons in the south. After clicking on OK all is fine:
No more red "X"...
All other fields are not jet supported by MP2 and are there just for information (read from local file cache) and to fill the space until they become available in MP2. The series name could probably be changed, but then MP2 don't find any fanart and also don't refresh any data on the renamed series. That's why the series name stays untouched. The long field above is meant for a future "sorttitle" filed...
Even less is to be editable if you expand a series tree to get the seasons shown...
Only thing to change here is the watched status. You can set the whole season to watched or unwatched, if you like.
There is more to do if you expand the season to show the episodes info...
Here you can edit the episodes title, the storyplot, the rating and the watched flag. Later can be done in MP2 GUI also, but if you are here, so why not change it too.
If you click on the thumb, you can exchange the thumbnail stored in DB. MP2 generates it's own thumbnails and don't download them from TheTVDB like most other programs. Normally this is the better way, as the TVDB server isn't that much loaded and you got thumbs for every episode. Lots of episodes don't have thumbs online... But sometimes the generation fails. Then you can exchange the thumb here. The original size of the thumbs is 240x135 px. I don't know what's happened if this will be extend a lot...
And now the fanart management. You can reach it by clicking on the big series banner, if you're on series or season level... usage is identical on every section. Only on adding new season fanart you need to select the season belonging to the new fanart. on series specific fanart this is not necessary.
There are three buttons, "Replace", Delete" and "Add new". With replace you can exchange the graphics of as unwanted poster (banner,...) As I'm not able to read or speak Russian, I don't like this poster too much...
If you simply delete this poster, it will be downloaded again on next import. So if you replace it with another image MP2 still "thinks" it's there and don't grab it again... After replacing the Russian poster I like it the better:
Same name, different poster.
Delete is suitable for broken files. You can recognise them easily as the are not shown. To be precise if you select a broken image the previous image is still there. Delete it and hopefully the next download has more success. But you also can replace a broken image like it's done with unwanted, for sure.
And, as you may have thought, "Add new" is to add missing fanart to MP2.
To leave fanart management simply close the window ("x" on top right)...
With v0.3 the movies part is working too.
The sort title field and the fields with "n.a." (not available) are not jet used by MP2. As this will be changing soon, the fields are prepared to be usable instantly after this functionality is added to MP2. Aside this the usage is 99% identical to the series part. To reach the fanart management you need to click on the poster. Aside this the only difference is the watched status. This will be toggled by clicking on the "eye" and is written to the database instantly instead of storing it when pressing "save".
The movieset management is ready as with v 0.5.0
You need to have an eye on the TheMovieDB_ID here, similar to the series part. If you can see a red "x" next to the input field you need to fix this before you can do anything else. If necessary a button to do the fix is shown.
Aside this you can add or remove movies to/from this collection. With the Remove button the marked movie in the middle list will be removed from this set. If you click on add movies a new window pops up with a list of all your movies
As none of the movies recently belonging to this set are removed here you only need to mark the movies you want to add new.
Fanart for moviesets is managed in an identical way to the movies fanart. Click on the poster in the movieset list and the fanart- management window appears.
Recent version is
0.6.2
and can be found in our repo:
https://www.team-mediaportal.com/extensions/mp2-plugins/mp2-edit
I will add new information and new releases as soon as they are available here...
Edit:
New download link as the path in our repository was changed recently
Link to German thread:
https://forum.team-mediaportal.com/threads/mp2-edit-ein-editor-für-die-mediaportal2-medienbibliothek.129077
In this thread I like to introduce you a tool to edit the MediaPortal2 media library (ML). As there is no "official" way to correct mistakes in the MP2 ML I've started developing this tool. Aside this, MP2-Edit is offering help during migration from MP1 over to to MP2. There is a heavy work going on this not even tiny project, so mistakes, bugs and other glitches are to be expected.
Some notes before to start. As there is no "official" way recently available to access the MP2 database, MP2-Edit is using the SQLite database with "illegal" direct access. No other DB plugins than the default SQLite plugin is working with MP2-Edit. All fanart is stored in a cache on local file system of the MP2 server, so MP2-Edit needs to run on the same machine than the MP2 server itself. And as it needs to access system folders it needs to run with Admin rights. All this is planed to be changed later, but right now it's necessary.
In future MP2-Edit should be able to edit all aspects of the MP2 ML. But this will take a long time until this happens. As a big fan of TV series, I've started with the series part for sure...
This is working in the current version:
Generic management and migration:
A full blown Backup tool is integrated as with version 0.4.0. With this you can do automatic backups triggered by a scheduled task. You can add the schedule, edit and delete it. And you can manually delete or restore backup files to the MP2 server. An extra tool named MP2-Backup is doing the backups invisible and without disturbing the usage of MP2 and/or your PC at all. MP2-Backup also is called every time you close MP2-Edit, just to have your latest work stored...
The task scheduler needs the time in 24 hours format so you have to enter it this way. The time on screen-shot is 7pm. If you set 0 as number of backups to keep then all backups are kept and you are responsible for the disk space your own.
Default settings are do a backup every day of the week at 8pm and keep 7 days of backup...
When you leave MP2-Edit a manual backup is triggered.
You can backup and restore the "watched flags" of your series collection too. As the format of the watched backup is compatible with TVSeries you simply can import your watched flags from TVSeries into MP2. This is done in TVSeries config, tab general:
Here you also can import watched flags from MP2 into TVSeries. As with v 0.5.0 the watched status of the MP2 movies- part can be exported in a similar format. And it's possible to export those flags from MovingPictures, MyFilms and MyVideos too. Later you can import those flags into MP2 ML. But as none of those plugins has an import function similar to TVSeries this is an "one way only" option here for movies.
Media management:
The series part is fully functional. You can edit all series specific data in the MP2 ML. And the fanart management is working too. You can replace unwanted fanart, remove broken files or add missing fanart of all types available (Poster, Banner, Backdrop, Season-Poster, Season-Banner and Episodes-Thumb) ClearArt and similar is not used by MP2 at all today. If this will change, MP2-Edit will add those features too. As with version 0.3.0 the movies part is working too.
And with v 0.5.0 the movieset management also is working.
A full manual will be written later. Some notes for a quick start.
MP2-Edit is installed by an average installer and will find it's home in "C:\Program Files (x86)\Team MediaPortal\MP2-Edit\" (or without the (x86) on 32 bit OS). So nothing special here.
To edit the database it's necessary to stop MP2 server prior to use MP2-Edit.
This normally is no big deal, but if you use TV with MP2 this will interrupt all running recordings and also prevent scheduled recordings from starting. That's why MP2-Edit is asking if it's safe to stop MP2 Server. The start of MP2-Edit can last a while, so a splash-screen is showing what happens under the hood.
After start-up the settings are presented. If you change something here (e.G. the GUI language) you need to restart MP2-Edit to make the changes work.
When you select the tab "series" it will look like this:
For further work it's absolutely necessary that all episodes will have the TVDB ID field filled with proper ID. Due to various circumstances during import it's possible that not all episodes will have this very important data. This can and will lead to errors. An indicator is shown, if a series has at least a single episode without a TVDB ID. If it looks like the screen-shot above, all is good and you can go on with whatever you want to do. But attention, if it's looking like this:
Have a look at the red "X" near the TVDB ID field.
This shows up if a series has at least one episode without TVDB ID and needs to be changed before you can do other work on this series. This is done easily by refreshing the complete series. All episodes will get the TVDB and IMDB ID entered in the corresponding fields. And you can set the whole series as watched or unwatched, if you want. This is selected by the three radio buttons in the south. After clicking on OK all is fine:
No more red "X"...
All other fields are not jet supported by MP2 and are there just for information (read from local file cache) and to fill the space until they become available in MP2. The series name could probably be changed, but then MP2 don't find any fanart and also don't refresh any data on the renamed series. That's why the series name stays untouched. The long field above is meant for a future "sorttitle" filed...
Even less is to be editable if you expand a series tree to get the seasons shown...
Only thing to change here is the watched status. You can set the whole season to watched or unwatched, if you like.
There is more to do if you expand the season to show the episodes info...
Here you can edit the episodes title, the storyplot, the rating and the watched flag. Later can be done in MP2 GUI also, but if you are here, so why not change it too.
If you click on the thumb, you can exchange the thumbnail stored in DB. MP2 generates it's own thumbnails and don't download them from TheTVDB like most other programs. Normally this is the better way, as the TVDB server isn't that much loaded and you got thumbs for every episode. Lots of episodes don't have thumbs online... But sometimes the generation fails. Then you can exchange the thumb here. The original size of the thumbs is 240x135 px. I don't know what's happened if this will be extend a lot...
And now the fanart management. You can reach it by clicking on the big series banner, if you're on series or season level... usage is identical on every section. Only on adding new season fanart you need to select the season belonging to the new fanart. on series specific fanart this is not necessary.
There are three buttons, "Replace", Delete" and "Add new". With replace you can exchange the graphics of as unwanted poster (banner,...) As I'm not able to read or speak Russian, I don't like this poster too much...
If you simply delete this poster, it will be downloaded again on next import. So if you replace it with another image MP2 still "thinks" it's there and don't grab it again... After replacing the Russian poster I like it the better:
Same name, different poster.
Delete is suitable for broken files. You can recognise them easily as the are not shown. To be precise if you select a broken image the previous image is still there. Delete it and hopefully the next download has more success. But you also can replace a broken image like it's done with unwanted, for sure.
And, as you may have thought, "Add new" is to add missing fanart to MP2.
To leave fanart management simply close the window ("x" on top right)...
With v0.3 the movies part is working too.
The sort title field and the fields with "n.a." (not available) are not jet used by MP2. As this will be changing soon, the fields are prepared to be usable instantly after this functionality is added to MP2. Aside this the usage is 99% identical to the series part. To reach the fanart management you need to click on the poster. Aside this the only difference is the watched status. This will be toggled by clicking on the "eye" and is written to the database instantly instead of storing it when pressing "save".
The movieset management is ready as with v 0.5.0
You need to have an eye on the TheMovieDB_ID here, similar to the series part. If you can see a red "x" next to the input field you need to fix this before you can do anything else. If necessary a button to do the fix is shown.
Aside this you can add or remove movies to/from this collection. With the Remove button the marked movie in the middle list will be removed from this set. If you click on add movies a new window pops up with a list of all your movies
As none of the movies recently belonging to this set are removed here you only need to mark the movies you want to add new.
Fanart for moviesets is managed in an identical way to the movies fanart. Click on the poster in the movieset list and the fanart- management window appears.
Recent version is
0.6.2
and can be found in our repo:
https://www.team-mediaportal.com/extensions/mp2-plugins/mp2-edit
I will add new information and new releases as soon as they are available here...
Edit:
New download link as the path in our repository was changed recently
Last edited: