# PlexDBEditor

**URL:** <https://forums.plex.tv/t/plexdbeditor/3245>\
**Category:** Dev/API Corner\
**Tags:** other-dev\
**Created:** [December 28, 2009, 5:45pm UTC](https://forums.plex.tv/t/plexdbeditor/3245 "2009-12-28T17:45:16Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![someone](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/someone/32/381_2.png) [@someone](https://forums.plex.tv/u/someone)\
**Post date:** [December 28, 2009, 5:45pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/1 "2009-12-28T17:45:16Z")

</div>

Small tool to modify some of the scraped data
Hi,  
  
I started working on a small tool which lets you modify some of the data in Plex' database... because maybe the scraper didn't work exactly as you wanted :)  
  
If you want to test it you should backup your movie database in \*\*~/Library/Application Support/Plex/userdata/Database/MyVideos34.db\*\*, but I don't expect any bigger problems.  
  
It has been tested under OSX 10.5 and 10.6.  
  

[http://img402.imageshack.us/img402/9488/plexdbeditor07.jpg](http://img402.imageshack.us/img402/9488/plexdbeditor07.jpg)

  
  

[http://img704.imageshack.us/img704/8022/plexdbeditor2.jpg](http://img704.imageshack.us/img704/8022/plexdbeditor2.jpg)

  
  
Just unzip the attached file and copy it to your application folder. There's also a modified version available for XBMC.  
  
\*\*Attention:\*\* Plex 0.9 probably will be available in the not too distant future, DON'T use this tool with it, it will have a new database. I'll provide a new version when Plex 0.9 is out.

---

<div class="post-metadata">

**Author:** ![El\_Massman](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/el_massman/32/75_2.png) [@El\_Massman](https://forums.plex.tv/u/El_Massman)\
**Post date:** [December 28, 2009, 6:38pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/2 "2009-12-28T18:38:48Z")

</div>

this looks awesome. will give it a test right away. thank you. one question, would you consider adding genre support? i’ve been looking for something to quickly add the genre ‘HD’ so i can browse films by HD only and this looks perfect.   
  
  
  
thanks again,   
  
  
  
marc

---

<div class="post-metadata">

**Author:** ![smoldersonline](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/smoldersonline/32/127_2.png) [@smoldersonline](https://forums.plex.tv/u/smoldersonline)\
**Post date:** [December 28, 2009, 7:10pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/3 "2009-12-28T19:10:34Z")

</div>

Gave it a quick spin and this is indeed awesome!! Just tested on a (shared) userdata setup and works like a charm, brilliant. Agree with El Massman that it would even be better with genre support.  
  
  
  
Thanks a lot for sharing.

---

<div class="post-metadata">

**Author:** ![El\_Massman](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/el_massman/32/75_2.png) [@El\_Massman](https://forums.plex.tv/u/El_Massman)\
**Post date:** [December 28, 2009, 7:24pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/4 "2009-12-28T19:24:04Z")

</div>

Tested. Works like a dream. Blazing fast! Really nice work.

---

<div class="post-metadata">

**Author:** ![tanousjm](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tanousjm/32/216_2.png) [@tanousjm](https://forums.plex.tv/u/tanousjm)\
**Post date:** [December 29, 2009, 4:35am UTC](https://forums.plex.tv/t/plexdbeditor/3245/5 "2009-12-29T04:35:30Z")

</div>

I’m having trouble getting changes to save. For example, I’ve edited the plot of a movie, clicked “Save Changes,” closed the DB Editor, opened Plex and the changes are not there. When I reopen the editor, the changes are also gone. Am I missing anything?  
  
  
  
But, otherwise, this is such a great app! I’ve been manually editing .nfo files which has been a huge pain. An app like this would be a dream. Thank you so much!

---

<div class="post-metadata">

**Author:** ![someone](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/someone/32/381_2.png) [@someone](https://forums.plex.tv/u/someone)\
**Post date:** [December 29, 2009, 8:21pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/6 "2009-12-29T20:21:58Z")

</div>

Currently working on the genre support…

> [@](#):
>
> I'm having trouble getting changes to save. For example, I've edited the plot of a movie, clicked "Save Changes," closed the DB Editor, opened Plex and the changes are not there. When I reopen the editor, the changes are also gone. Am I missing anything?  
>   
> But, otherwise, this is such a great app! I've been manually editing .nfo files which has been a huge pain. An app like this would be a dream. Thank you so much!

  
I think I know what the problem is, will be fixed in the next version.

---

<div class="post-metadata">

**Author:** ![vdubeau](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/vdubeau/32/619_2.png) [@vdubeau](https://forums.plex.tv/u/vdubeau)\
**Post date:** [January 3, 2010, 1:46am UTC](https://forums.plex.tv/t/plexdbeditor/3245/7 "2010-01-03T01:46:24Z")

</div>

If you allow them to add new genre then you have to make sure you add it to the genre table.

---

<div class="post-metadata">

**Author:** ![someone](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/someone/32/381_2.png) [@someone](https://forums.plex.tv/u/someone)\
**Post date:** [January 3, 2010, 10:40am UTC](https://forums.plex.tv/t/plexdbeditor/3245/8 "2010-01-03T10:40:13Z")

</div>

> [@](#):
>
> If you allow them to add new genre then you have to make sure you add it to the genre table.

  
I do, I do :)

---

<div class="post-metadata">

**Author:** ![marklight](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/marklight/32/190_2.png) [@marklight](https://forums.plex.tv/u/marklight)\
**Post date:** [January 3, 2010, 6:02pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/9 "2010-01-03T18:02:51Z")

</div>

This is such a great little app. Thanks!

---

<div class="post-metadata">

**Author:** ![korey](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/korey/32/10_2.png) [@korey](https://forums.plex.tv/u/korey)\
**Post date:** [January 3, 2010, 6:55pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/10 "2010-01-03T18:55:10Z")

</div>

Nice work!  
  
  
  
how about having the option to delete a record in the database.  
  
  
  
Thanks!

---

<div class="post-metadata">

**Author:** ![someone](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/someone/32/381_2.png) [@someone](https://forums.plex.tv/u/someone)\
**Post date:** [January 3, 2010, 7:33pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/11 "2010-01-03T19:33:14Z")

</div>

**Update:**  
  
  
  
New version with genre support. I also fixed a bug where the changes were not saved.  
  
  
  
The link can be found in the first post.  
  
  
  
@Korey: I’ll think about it. Would be easy to implement, but as this is also possible in Plex I’m not sure if really necessary

---

<div class="post-metadata">

**Author:** ![nicofieu](https://avatars.discourse-cdn.com/v4/letter/n/8dc957/32.png) [@nicofieu](https://forums.plex.tv/u/nicofieu)\
**Post date:** [January 3, 2010, 8:25pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/12 "2010-01-03T20:25:26Z")

</div>

wow, this is the app i’ve been waiting for months to arrange my collection correctly by genre !  
  
  
  
just one question, could you add the option to delete a genre ? Cause I think there are way tooo much genre over there…just an idea 😉  
  
  
  
congrats for the app !

---

<div class="post-metadata">

**Author:** ![sgraham884](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sgraham884/32/206_2.png) [@sgraham884](https://forums.plex.tv/u/sgraham884)\
**Post date:** [January 3, 2010, 8:49pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/13 "2010-01-03T20:49:48Z")

</div>

Great app!!  
  
  
  
Any possibility of allowing paste function? Would be nice not having to type the entire plot.  
  
Thanks!

---

<div class="post-metadata">

**Author:** ![someone](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/someone/32/381_2.png) [@someone](https://forums.plex.tv/u/someone)\
**Post date:** [January 3, 2010, 10:04pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/14 "2010-01-03T22:04:36Z")

</div>

> [@](#):
>
> Great app!!  
>   
> Any possibility of allowing paste function? Would be nice not having to type the entire plot.  
> Thanks!

  
Don't know what you mean, you just have to click with the right mouse button into the plot field and select "Paste"... or press CMD+V

---

<div class="post-metadata">

**Author:** ![sgraham884](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sgraham884/32/206_2.png) [@sgraham884](https://forums.plex.tv/u/sgraham884)\
**Post date:** [January 3, 2010, 10:19pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/15 "2010-01-03T22:19:09Z")

</div>

> [@](#):
>
> Don't know what you mean, you just have to click with the right mouse button into the plot field and select "Paste"... or press CMD+V

  
  
Strange, CMND+V won't work but the right click does so all's good. Thanks for the quick reply.

---

<div class="post-metadata">

**Author:** ![someone](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/someone/32/381_2.png) [@someone](https://forums.plex.tv/u/someone)\
**Post date:** [January 3, 2010, 10:56pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/16 "2010-01-03T22:56:34Z")

</div>

> [@](#):
>
> Strange, CMND+V won't work but the right click does so all's good. Thanks for the quick reply.

  
Ah, you're right... CMD+V really doesn't work, I thought it does. Support will be added in the next version.

---

<div class="post-metadata">

**Author:** ![nicofieu](https://avatars.discourse-cdn.com/v4/letter/n/8dc957/32.png) [@nicofieu](https://forums.plex.tv/u/nicofieu)\
**Post date:** [January 6, 2010, 8:36am UTC](https://forums.plex.tv/t/plexdbeditor/3245/17 "2010-01-06T08:36:46Z")

</div>

Hi Someone  
  
  
  
if I look at your printscreen on the first post I can see no more dans 20 movie genre…I have about 200 !   
  
  
  
Did you do something to delete some genre ? Could you add this option easely on your app ?  
  
  
  
Thx a lot  
  
  
  
cheers

---

<div class="post-metadata">

**Author:** ![phunkysai](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/phunkysai/32/82952_2.png) [@phunkysai](https://forums.plex.tv/u/phunkysai)\
**Post date:** [January 6, 2010, 3:51pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/18 "2010-01-06T15:51:44Z")

</div>

Very cool of you to do this! Great seeing people create little third party apps for Plex!

---

<div class="post-metadata">

**Author:** ![fanden](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@fanden](https://forums.plex.tv/u/fanden)\
**Post date:** [January 7, 2010, 1:31pm UTC](https://forums.plex.tv/t/plexdbeditor/3245/19 "2010-01-07T13:31:32Z")

</div>

Great work! Do you think something like this will be in the .9 update of Plex? This is the kind of tool we need!  
  
  
  
Would it be possible to add import/export of database between Dvdpedia and PlexDBEditor? I use Dvdpedia to manage my movie collection, and would love to sync it with Plex.

---

<div class="post-metadata">

**Author:** ![vdubeau](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/vdubeau/32/619_2.png) [@vdubeau](https://forums.plex.tv/u/vdubeau)\
**Post date:** [January 8, 2010, 2:19am UTC](https://forums.plex.tv/t/plexdbeditor/3245/20 "2010-01-08T02:19:00Z")

</div>

You stole my idea 😃 , I was planning on writing a DB editor myself. I’ve been mapping out the database when I get time.

[Next page](https://forums.plex.tv/t/plexdbeditor/3245.md?page=2)
