Editing the media library DB

[CraigD]

What would be the best way to edit the derby DB? I'm not too familiar with Derby, so I'm looking here to see if anyone has any suggestions. The main reason I want to do this is because I have a few movies that Serviio has got wrong or just can't find and I would like to add/correct them manually.

Thanks.

[will]

The easiest way to do what you want is to correct the file/folder naming for the movies.

If you have check for updates turned on, any changes you make will most likely get overridden if you start playing around in the DB.

What are the file/folder names for the ones that aren't working?

[moltra]

What would be the best way to edit the derby DB? I'm not too familiar with Derby, so I'm looking here to see if anyone has any suggestions. The main reason I want to do this is because I have a few movies that Serviio has got wrong or just can't find and I would like to add/correct them manually.

Thanks.

There is a windows script that should help with your problem, if you are using windows.

http://forum.serviio.org/viewtopic.php?f=17&t=3865

  Code:

This VBs Script (Windows Only) will parse the Serviio.log file looking for films which failed online Metadata lookup with an error... Ie time out/Connection error while querying the online database and will Move them to another folder so they can be reimported to force Metadata Rescan.

Any film found with MetaData lookup errors will be moved from it's current location to <Film Drive>\Temp\Serviio\<subfolders> (Keeping your folder structure). With the films moved to a new folder Serviio will remove the films from the database (about an hour). Once the films have been removed from the database manually copy the films back to their original location to get Serviio to rescan Metadata for just these films.

When run the script will ask for the root path to your films.. IE x:\myfilms it uses this in conjunction with Serviio.log to identify series folders so it can keep the folder structure. Each film with a lookup error will be moved to <Film Drive>\temp\Serviio\<Sub Folders>

This script is designed to enable you to rescan just films which got metadata Errors, so you don't have to rescan all the files and maybe get lookup errors on other films.




[Cerberus]

What would be the best way to edit the derby DB? I'm not too familiar with Derby, so I'm looking here to see if anyone has any suggestions. The main reason I want to do this is because I have a few movies that Serviio has got wrong or just can't find and I would like to add/correct them manually.

Thanks.

There is a windows script that should help with your problem, if you are using windows.

http://forum.serviio.org/viewtopic.php?f=17&t=3865

  Code:

This VBs Script (Windows Only) will parse the Serviio.log file looking for films which failed online Metadata lookup with an error... Ie time out/Connection error while querying the online database and will Move them to another folder so they can be reimported to force Metadata Rescan.

Any film found with MetaData lookup errors will be moved from it's current location to <Film Drive>\Temp\Serviio\<subfolders> (Keeping your folder structure). With the films moved to a new folder Serviio will remove the films from the database (about an hour). Once the films have been removed from the database manually copy the films back to their original location to get Serviio to rescan Metadata for just these films.

When run the script will ask for the root path to your films.. IE x:\myfilms it uses this in conjunction with Serviio.log to identify series folders so it can keep the folder structure. Each film with a lookup error will be moved to <Film Drive>\temp\Serviio\<Sub Folders>

This script is designed to enable you to rescan just films which got metadata Errors, so you don't have to rescan all the files and maybe get lookup errors on other films.




why bother just click recheck video metadata from console.

[CraigD]

2 examples of in correctly or missed files:

Leon (1994).m2ts gets pick up as Lion King

Hangover Part II, The.m2ts doesn't find a match

[will]

2 examples of in correctly or missed files:

Leon (1994).m2ts gets pick up as Lion King

Hangover Part II, The.m2ts doesn't find a match

What are the folders that they are in called?

[CraigD]

Leon is under movies/K-O/

Hangover 2 is under movies/F-J/

[will]

Can you try putting them into named subfolders with the same name as shown on themoviedb to see if that fixes it.

[WildRushSykes]

Leon: The Professional (1994)

The Hangover Part II (2011)

Those are the correct file names

[Cerberus]

come on guys think simple run the files through a file renamer to get correct title and save all the issues.

http://wiki.serviio.org/doku.php?id=therenamer

http://wiki.serviio.org/doku.php?id=filebot

A file renamer is great if the only issue is that there is just trouble finding the name of a standard movie. Sometimes you have to think more complicated though because there are plenty of times that a file renamer won't help. A couple of my examples.

I have Schindler's List as 2 files because it came on 2 DVDs. It is the same movie, so a file renamer would want them to be called the same thing and Serviio will pull the same metadata for both files. It would be nice if I could make a local edit so I know which is Part 1 and which is Part 2.

I have several movies that are made by me/friends (action sports/etc.) It would be nice to actually populate the metadata for these instead of just looking at the file name. And for this type of file I don't think it makes sense to try to update the central database since it isn't a distributed movie.

Those are just a couple of examples where an ability to edit the local metadata would be very handy and a renamer wouldn't really be able to help much.