Power users - edit Plex database directly
Posted 24 August 2010 - 03:17 PM
For those of a daring disposition, you can use an SQLite compatible database tool to edit these databases directly. I had a look around and there are a number of such tools (for Mac) some of which are commercial, but I found Navicat Lite to a be a reasonable free tool which you can download here http://www.navicat.c...d/download.html
As an example, I used it to edit some already scraped (via IMDB) movies which due to a bug in an earlier version of the scraper did not include the film year. Rather than rescraping them all with a fixed version of the scraper, I was able to use Navicat to edit the records in the database and fill in by hand the missing year. You could also use this to manually enter film plot text - not all entries on IMDB have such text.
The Plex database is at the following path
Posted 24 August 2010 - 06:33 PM
But always remember, editing this way is not supported, and you should always back up before you try anything.
Posted 26 August 2010 - 12:15 PM
I have used that (and the XBMC version) but they do not provide access to the Year field.
Try this one: http://forums.plexap...7-plexdbeditor/
It allows to edit the data without understanding the structure of Plex' database and sql.
Navicat Lite does not need a lot of SQL knowledge, it is just a matter of clicking and editing. You don't need to create SQL search strings like some other tools.
Posted 01 May 2013 - 05:01 AM
I tried all the suggestions on this page, none of them give you any power at all over genre editing.
This one is the best: http://www.eagleware...plexeditor.aspx
I'm running the most current Plex Server on my mac, and ran Plex Editor 1.4 on Windows 7 via VMWare.
The Plex database on a mac is here:
~/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
but on the VMWare (Windows) side it looks like this:
\\vmware-host\Shared Folders\MAC-USER-ACCT-NAME\Library\Application Support\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db
(assuming you set up folder sharing in VMWare)
Watch the video for the editor tool, it helps a lot.
Posted 08 January 2014 - 10:49 PM
Why does the Plex Editor only show the movies library and not things like TV Shows and music? Am I missing something or is that in another database? I've got some incorrectly flagged songs and I can't seem to correct them no matter what I've tried.
- ccarbaugh likes this
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users