Page 1 of 1

Library management

PostPosted: Sun Apr 08, 2012 5:15 pm
by impulse
Hi all,

I am new using serviio. It's the best DLNA/upnp server I have tried :)

I am thinking... is there any way to manage my library? I mean, edit movies/series metadata, etc. If not, there is any API that allows do it?

Thanks in advance.

Re: Library management

PostPosted: Sun Apr 08, 2012 5:22 pm
by will
Not to edit individual items. Do you have specific items with incorrect metadata? A lot of the time adjusting the naming to match the two online databases that are used fixes it. Otherwise, you can supply XBMC .nfo files to provide additional metadata.

Re: Library management

PostPosted: Sun Apr 08, 2012 5:42 pm
by impulse
Hi will, thanks for your reply.

Yes, some specific items have been solved by changing its name, but, for example, i have a TV Show that is been marked like a Film, Serviio is getting the name and cover correctly, but i see one item by episode like all of them were films.

I will take a look to the XBMC .nfo files.

Re: Library management

PostPosted: Sun Apr 08, 2012 6:31 pm
by moltra
there is also a file renamer that gets the correct name from the respective databases.

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

Re: Library management

PostPosted: Tue Apr 10, 2012 1:37 pm
by impulse
Yes, but I was thinking in something like, for example, Plex does, you can manage your movies and tv shows library through a web interface. You don't need to rename the file, you can just select a movie and tell the server that he is wrong and the correct movie is something else. I guess it changes the database according to this without need to rename files.

I know yet that this functionality does not exists, but I could be interested in develop it if would exists an available API through which to do it.

Cheers.

Re: Library management

PostPosted: Thu May 03, 2012 7:00 pm
by Sinbios
I'm also having problems with library metadata and every time the question comes up the answer seems to be renaming all the files. However I have my own naming conventions and would prefer not to change the filenames just so Serviio could parse them. Since the metadata is stored in a SQL database it should be easy to implement some extra functionality to manage the library.

Re: Library management

PostPosted: Thu May 03, 2012 8:34 pm
by zip
Sinbios wrote:it should be easy to implement some extra functionality to manage the library.

Potentially, but there are over 110 open tickets ATM, so I'm pretty busy :-)

You can have XBMC organize your metadata and then import them.

Re: Library management

PostPosted: Thu Sep 20, 2012 7:45 pm
by Fincher
I am looking for the same kind of tool. I have a movie library of about 500 movies and a quick scan shows that a large portion of them were misidentified. I realize that the is likely because my naming scheme wasn't amenable to searching, but some are ridiculously wrong. An example.

My file: PATCH_ADAMS.m4v

Metadata Match: 101 Dalmations II- Patch's London Adventure

I could adjust the filenames, but that is a bit guess and test and daunting for the number of files that I need to edit. I would prefer if I could just go in and edit the metadata myself. This would be especially handy for movies that I want to keep in my library that I created myself and therefore they would never occur in the database.

Even something like impulse mentioned where we could choose the appropriate entry in the online database.

Until then, help with editing the actual database would be greatly appreciated.

Re: Library management

PostPosted: Thu Sep 20, 2012 8:04 pm
by TheLaGmAn
Here is how i manually modified the DerbyDB, it was just a test so i grabbed the first DerbyDB IDE i could find, it is kind of a pain but it does the job,

grab NetBeans IDE 7.2 (the version that says that have the derby embeed, i think it was the java eee -the bigger in size or 2nd-)
grab java if u dont already have it (http://www.oracle.com/technetwork/java/ ... index.html)

once NB is installed, create a new project, then window > services to open the services window, then right click to databases and add new connection.
add the driver file (in my case program files\java\jdk 1.7.0.07\db\lib\derby.jar)
write in the db location the serviio library\db folder
test connection > should succed, create

from there u have the (APP) media_item table in which it stores all the files, with the title name ,season number, episode number, and type of file (movie or series) and if its a series, u have to look for the id or create it in the table series

remember to first make a backup of the DB and stop the serviio service manually so u can access the DB

Re: Library management

PostPosted: Thu Sep 20, 2012 8:21 pm
by Fincher
Thanks for that TheLaGmAn!

Also, if it helps the developers, check out the file renamer FileBox. I have been having limited luck with using it to rename the files in my collection to assist in finding them in the database, but it gives a great example of the interface that I would love to see for Serviio. Basically, it takes the file, searches an online database that you choose, then gives you all the close matches. From there you can choose the movie that is correct. Pretty handy!