That is not an error I put in so sounds like a possible OS error message, which would explain why the debug mode doesn’t show any problems. Does the name of the playlist has an invalid character like a colon which can’t be converted into a file?
Otherwise, if you would be willing to send me your DB I can try to recreate and see what is going on.
@MovieFan.Plex said:
That is not an error I put in so sounds like a possible OS error message, which would explain why the debug mode doesn’t show any problems. Does the name of the playlist has an invalid character like a colon which can’t be converted into a file?Otherwise, if you would be willing to send me your DB I can try to recreate and see what is going on.
I will send it along, definitely first thought I had was special characters but it worked for my DJ & Tami’s Mix but didn’t work on DJ’s Mix 
I am using Windows 10 if that’s a possible issue.
Found a small bug. Exporting a playlist with a single quote ’ in the name creates an error. Script needs to escape it. Otherwise so far its working well despite me running it against a linux hosted server via a samba share.
Looking for some advice - I really need to do a playlist import from itunes to a non-administrator user which I gather is a feature on your to do list. I’m new to plex sql hacking but if I did a playlist import to the administrator user would it be straight forward for me to write a sql command to change the playlist owner? (Which I’d expect to be a single sql update on the right table/field) Or is that harder than it sounds?
@battle_hamster said:
Found a small bug. Exporting a playlist with a single quote ’ in the name creates an error. Script needs to escape it. Otherwise so far its working well despite me running it against a linux hosted server via a samba share.
Thanks. I found the already. This was the problem with dom above. I sent him a fix and will post the fix here too. I’m away from my computer at the moment.
For the iTunes question, yes you can import it into the admin then change the account id to match the user you want.
Looked easy enough, thought it worth checking with someone who knows their way round the database 
For anyone else interested the table that contains the user to playlist mappings is called metadata_item_accounts.
Here is the revised script that takes into account the apostrophe. Remove the txt from the extension and overwrite the version you have.
I finally got this to work.
I am using the “MovieFan’s Database Tool for Plex v0.3.2 - Library.mscr” file from page 14 of this thread.
I had to manually point the settings.ini to my Synology NAS’s PLEX installation for it to start without an error.
Is there a way to select a location where a database backup would be saved?
And can one select a path where the poster exports are saved?
Currently no. The backup folder is coded into the script. You can edit the script if you’d like to try. Look in the file MovieFan's Database Tool for Plex v0.3.2 - Database.mscr and find the line strBackupLocation = strPath \ "db_backup". Change this last part to the name you want. If you want some totally different folder, change the entire part after the = to the full path you want to use.
For the posters, no. They get saved next to the movie. This allows them to get automatically used the next. Placing the, in another location would not serve this purpose. Did you want to make a single folder of all the images? I can look into adding this but it was not my original goal so I had not planned to allow this.
Thank you, that’s helpful!
Yes, i wanted to make a single folder with all images as a backup and sync this to an ipad photo album, which allows faster browsing and offline access.
Turns out it is easier than I thought. Look in MovieFan's Database Tool for Plex v0.3.2 - Library.mscr and find the following 2 lines.
strSaveToFile = FilePath(strFile) \ FileBase(strFile) & “.jpg”
strSaveToFile = FilePath(strFile) \ FileBase(strFile) & “-fanart.jpg”
ReplaceFilePath(strFile)with the full path you want to use.
strSaveToFile = “D:\MyMoviePosters” \ FileBase(strFile) & “.jpg”
strSaveToFile = “D:\MyMovieBackgrounds” \ FileBase(strFile) & “-fanart.jpg”
The first line is the actual poster, the second is for the background art, if you don’t want them just leave that second line alone.
@sandersoni said:
Yes, i wanted to make a single folder with all images as a backup and sync this to an ipad photo album, which allows faster browsing and offline access.
That’s actually a pretty cool idea.
I periodically go through my library and delete *.jpg, then run MovieFan’s Database Tool and re-extract new images to my file system. But I prefer the images be in each folder with the movie media. I’m going to have to play with extracting the Posters to a different location for use as a non-plex based index though… this idea is intriguing.
Just so I understand, though, I know this is copying the jpg files to the extra folder(s) so you can back them up easier. Is this also changing where Plex is reading them from?
In today’s mode, once I run this and I have the two jpg files I know that they are the files that Plex is looking to based on the name of the file. Does this change that connection? Am I making any sense?
I still wish we could do TV shows (and now music) also. It has taken a long time to curate all of these and I would hate to lose them all.
No, this change above would not impact Plex. It is an alternative method for saving the images. PMS will not see these images so it is a purely backup/non-Plex use solution. You still need to run the script as-is if you want PMS to pick them up on a scan.
I’m working on adding the same ability for tv shows and music. V4 of my tool will have that.
It is purely an extraction… it does not change anything in Plex. It simply looks at the currently selected “Poster” and “Background” images and exports a COPY to your filesystem.
In a perfect world, I would want to be able to delete all the other posters and backgrounds, etc… that are not being used. Kinda “thinning down” the Plex database, so to speak. No sense having 8 possible posters, and 12 possible backgrounds for every movie hanging around… after I’ve made my choice.
And +1 on the TV Series images… that would be nice. Music, not so important to me.
@Plexhilarated said:
In a perfect world, I would want to be able to delete all the other posters and backgrounds, etc… that are not being used. Kinda “thinning down” the database, so to speak. No sense having 8 possible posters, and 12 possible backgrounds for every movie hanging around… after I’ve made my choice.
TOP SECRET !!! CONFIDENTIAL !!!
OMG… OMG… OMG…
Really, really cool.
Thanx. Looking forward to it.
[And making a random donation to someone this Christmas season in your honor. (I know how you are about personal donations)]
I am about to be overwhelmed with joy. My Christmas is complete!!!
Let us know when it is final and can be downloaded. I also will donate to someone in your name!!!
I’m almost ready to release. There is 1 big feature I really wanted to include that has been giving me trouble getting to work right. I’m hoping to get everything sorted by the end of this month.
Happy to beta test anything you need.
