Hi.
I added the /k and got below screen shot
Ok. According to this latest screen shot, the script and SQL statement ran fine and according to your previous screenshot, it did not return any results. Try the script again, after you see this latest DOS screen, the results should be saved in the windows clipboard. Open up a notepad window and just hit paste. This will show you what the script returned as a result. If it is anything other then blank, Please PM me the result so I can take a look as that would be a bug.
Looks great! Can you share the icons and process?
Hey Barry,
Here are all the icons:
Feel free to reference them directly via HTTP. They are stored on my Community server and it's going to be alive for a few years to come lol.
As for the process, I honestly don't know how to answer this one. I just used Photoshop. The albums I obtained from my existing Plex library, I was so lazy that I literally used the snipping tool that comes with Windows. Since they are so small, you really can't see the JPG artifacts. I also think I stuck with a specific size, not sure how I came up with it but it should be 200x200 px PNG-24.
The Silicon Valley and Royksopp ones I simply grabbed their logo, and cut out their photo and faded it in, placed the logo on top and called it a day. The text and icons I used the Roboto font library and I have my endless collection of shapes that I have purchased and collected over 16+ years of using Photoshop. You can make your own shapes, also download lots for free if you search on Google. Android provides a great starter kit, it also provides the font Roboto, free of charge.
Hope this helps!
Just getting round to changing the library icons :)
Can you give me an example of "HTML formatted" text for the image location?
Thanks!
I need to change that. Pms no longer supports local files only files from the internet. To add that, just copy the url to the image you want to use and paste that into the box.
Script is back. See first post.
Thanks MovieFan for including the Export functionality for the database tables
I am having difficulties running the script.
I have created a folder: C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan
In that folder I have all the scripts and exe files and ini file as well as a copy of the PMS database
C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\com.plexapp.plugins.library.db C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MortScript.exe C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0 - Collection.mscr C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0 - Database.mscr C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0 - Library.mscr C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0 - Other.mscr C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0 - Playlist.mscr C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0 - User.mscr C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0.exe C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0.mscr C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\setting.ini C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\sqlite3.exe
The setting.ini file looks like this:
# MovieFan's Database Tool for Plex v0.3.0[database]
location=C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\com.plexapp.plugins.library.db[command]
location=C:\Windows\System32\cmd.exe[sqlite3]
location=C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\sqlite3.exe[plex]
location=C:\Program Files (x86)\Plex\Plex Media Server\Plex Media Server.exe[setting]
debug=True
I run the exe file by double clicking on it in explorer window
C:\Users\Plex\AppData\Local\Plex Media Server\MovieFan\MovieFan's Database Tool for Plex v0.3.0.exe
I get the menu of 8 items to choose from. Only options 7 and 8 work. Options 1 to 6 fail to display the submenus and just go back to displaying the menu
This is running on windows 7 Pro 64-Bit SP1
I am running it in my admin user account which is different from the non-admin plex account
Any idea what it might be ?
Sorry, i forgot to mention this in my instructions. Right click the mortscript.exe and run as administrator. This registers the extension with the program. It does not have to be the default program but does need to be registered.
wow - that did the trick ! I had registered it before but not as administrator !
Thank you so much - i now have my 20 csv files with just one click !
Whilst the exports to csv files work ok and the files are generated with valid contents, when i then close the command line window where it ran the SQlite3 export, i then get a dialogue box indicating errors. The db_export.log file has
Error exporting accounts... Error exporting directories... Error exporting library_sections... Error exporting media_items... Error exporting media_part_settings... Error exporting media_parts... Error exporting media_streams... Error exporting metadata_item_accounts... Error exporting metadata_item_settings... Error exporting metadata_item_views... Error exporting metadata_items... Error exporting metadata_relations... Error exporting play_queue_generators... Error exporting play_queue_items... Error exporting play_queues... Error exporting plugin_prefixes... Error exporting plugins... Error exporting section_locations... Error exporting taggings... Error exporting tags...
But i don;t think there are any errors in the export. I will look closely tomorrow
wow - that did the trick ! I had registered it before but not as administrator !
Sorry for multiple posts - I am surprised you need to run as afministraror when my whole plex media server environment which does database backups by butler can do it all without admin rights
The only reason to run as admin is to register the extension properly. After that i don’t think it runs as admin for normal use.
The error handling is very simple. It just looks if the file was created. Could be a race condition where the file is still writing when it does it’s check. I’ll look into making that check more rebust to avoid this potential.
Still having issues with movie-fanart.jpg files not getting created, even though the log file says it did.
Bug found, I think. Check your PM.
Yes, thank you... all is working well now.
how to work it? i can't open .exe
You need to pick the version of the program (mortscript.exe) you want to use 32-bit (PC) or 64-bit (PC64) from those directory and put it into this folder. Then right click on it and run as administrator. Then you can run the script exe file.
just found this! will have a play this weekend!
nice one!
