MovieFan's Database Tool for Plex

No I don’t have a video, but if you tell me what function you want, I can provide screenshots with instructions.

First things first: Thank you for all you have done with this script. It provides some much needed basic functionality (playlist importing) and some much appreciated advanced functionality.

I use MediaMonkey to manage my actual music and am pretty meticulous about my organization. I tried importing 2 playlists (that were exported from MediaMonkey), one with 61 tracks and the other with 1927. When I imported them through the script it imported 60 tracks and 1914 respectively. I enabled the debugging on the script and looked through the files but I didn’t see anything jumping out.

I tracked down the missing song on the smaller playlist just to see what is going on and it is in plex with the same path. It seems that the script drops the first entry (possibly to avoid issues importing a header?) I saw this reported elsewhere in the thread but didn’t see anything in response. No big deal there, that is an easy fix.

For the larger playlist I am guessing it is something with tracks missing from my Plex library. There are appx 200 of 33,000 tracks missing from Plex (vs MediaMonkey) and it may be that the tracks are part of those. All the files in that particular playlist are mp3 and m4a.

I guess the TL;DR version is me wondering if there is a way to see which files failed on the import?

Thank for the feedback. Skipping the first song is not something I’m able to reproduce so I have no idea what could be causing that issue. 1 other person did report something like that before but I never was able to track down the cause.

Right now the script will spit out a list of the files that did import, but not of the ones that got missed. I should add that to help with troubleshooting.

I’m still working on a revised version of my scripts and this one imports the playlist slightly differently so hopefully it will not have the problem of skipping the first song. I’ll add this extra logging for the missed files too. Thanks for the idea.

Beautiful! Again, thank you for you time on this and thank you for the insanely quick response!

At the risk of getting greedy I thought I would throw out one more feature request since it has been annoying the hell out of me and seems like it might be within the scope of this project.

It drives me bananas that I can’t create a playlist as my primary user and share it to a managed user. I have a locked down primary that includes all the fun stuff the wife and I don’t want others seeing. We have another managed account that we do most all of our viewing/listening from outside the bedroom. I saw someone on another thread mention that they were able to change the owner of a playlist in the sqlite db and that worked. I’m not sure where the db is and I’m not great with that sort of thing or I would jump in and do it.

Feel free to tell me to piss off if I am just being greedy :slight_smile:

That feature is in the update already. Anything else?

Wow, that’s two in two days that I have posted that you have pointed out are already there. After this one I may revoke my access to the forums for a bit :slight_smile:

I just looked at the script again and didn’t see it in there. Do you know where it is? I am on version 0.3.2 which as far as I could find is the newest.

Thanks again for all your help!

Sorry, by update I meant the new update I am working on, which I haven’t released yet. I’m still stuck on 1 feature which has prevented me from releasing it.

Ahhhhh that makes more sense.

I’ll just sit tight and hold on.

Thanks!

Thank you so much for this tool. Can’t believe that many of the options isn’t available on the Advanced Tab in Plex/Web. Great work.

I cannot understand your install instructions, am I just stupid?

@MovieFan.Plex, is this tool still worked on? I know its been awhile but it looks like pieces are breaking in it and was wondering if it will see any attention. For instance, changing added date to release date corrupts my DB each time.

I have a new version I’ve been working on for a while now. Just haven’t had time to finish it. I’m not aware of anything that would have changed how that function works. I’ll take a look and see if I can put in a quick fix.

@MovieFan.Plex said:
I have a new version I’ve been working on for a while now. Just haven’t had time to finish it. I’m not aware of anything that would have changed how that function works. I’ll take a look and see if I can put in a quick fix.

no problem, im happy testing out a beta release as well. Its the most used functionality of the tool (for me) and I just finished re-ripping about 600 movies and its burning me to see movies from the 80’s in my recently added hahaha.

any luck finding anything @MovieFan.Plex? Also, is there any log I can do, or possibly send you my previous and then corrupted DB to help locate the issue.

I tested that feature a few times and I am not having any issues. It’s possible that you have a bad date field that is being copied over that is causing the issue. I did not put in any checks to make sure the date is valid. Let me add in something to do that check and see if that works better for you.

@MovieFan.Plex said:
I tested that feature a few times and I am not having any issues. It’s possible that you have a bad date field that is being copied over that is causing the issue. I did not put in any checks to make sure the date is valid. Let me add in something to do that check and see if that works better for you.

cool and thanks, just let me know when to grab and test! :slight_smile:

Replace the library.mscr with the one in this zip file.

@MovieFan.Plex said:
Replace the library.mscr with the one in this zip file.

thanks, same issue unfortunately. I can PM you my DB if you would like.

@don.alcombright said:

@anon18523487 said:
Replace the library.mscr with the one in this zip file.

thanks, same issue unfortunately. I can PM you my DB if you would like.
Yes please. I’m not sure why the db would be getting corrupted.