Jump to content


Photo

Power users - edit Plex database directly


  • Please log in to reply
7 replies to this topic

#1 John Lockwood

John Lockwood

    Dedicated Member

  • Members
  • PipPipPip
  • 450 posts
  • Location: London,UK

Posted 24 August 2010 - 03:17 PM

Plex 0.8 at least (can't comment on Plex 0.9 which is not yet out) uses the same SQLite databases as XBMC. SQLite is a widely used database format, for example Apple use it themselves on the iPhone as well.

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

~/Library/Application Support/Plex/userdata/Database/MyVideos34.db

#2 fhb

fhb

    Dedicated Member

  • Members
  • PipPipPip
  • 365 posts
  • Location: Germany

Posted 24 August 2010 - 03:46 PM

Try this one: http://forums.plexap...7-plexdbeditor/
It allows to edit the data without understanding the structure of Plex' database and sql.
RenameandMove: 0.9.2 (15.09.2012)
German Plugin "Mediatheken": alpha

#3 Raindancing

Raindancing

    Plex Star

  • Members
  • PipPipPipPipPipPip
  • 1533 posts
  • Location: Austin, Texas, USA

Posted 24 August 2010 - 06:33 PM

I've also used Base and MesaSQLite, both of which have trial versions which work just fine for those who just want to get in and change a little data here and there.

But always remember, editing this way is not supported, and you should always back up before you try anything.

#4 John Lockwood

John Lockwood

    Dedicated Member

  • Members
  • PipPipPip
  • 450 posts
  • Location: London,UK

Posted 26 August 2010 - 12:15 PM

Try this one: http://forums.plexap...7-plexdbeditor/
It allows to edit the data without understanding the structure of Plex' database and sql.

I have used that (and the XBMC version) but they do not provide access to the Year field.

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.

#5 drp

drp

    Newbie

  • Members
  • Pip
  • 1 posts

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.



#6 johnwilson

johnwilson

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 11 June 2013 - 01:28 AM

I’ve just release an updated PlexEditor for Windows v2.0 with a new updated resizable interface and many new features.

 

More information and download at: http://www.eagleware...plexeditor.aspx

 

John Wilson

Eagleware Websites



#7 tymbrwlf

tymbrwlf

    Member

  • Members
  • PipPip
  • 13 posts

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.



#8 pappabees

pappabees

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 18 March 2014 - 10:55 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.

 I don't see an answer to this yet.  Has anyone found out how to make Plex Editor show Music.  I would love to edit the Genres in the Music database and get rid of all the crap in there






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users