A long while ago I wrote myself some nice SQL queries with which I generated lists of my movies & stuff out of my collection in Plex via the file MyVideos34.db. Just now I took a look at that file again and it appears to be completely empty. What happened here? Is there any way I can do cool things like export lists of my movies or of the TV show episodes I watched in the last month - or is Plex now being secretive?
This might help you:
http://hybridlogic.co.uk/code/standalone/plex-export
I attached my own version of the files that also exports the Collections
What you have to do is install php.
Then edit the cli.php file and change this section:
/ Set-up<br />
plex_log('Welcome to the Plex Exporter v'.$plex_export_version);<br />
$defaults = array(<br />
'plex-url' => 'http://192.168.0.200:32400',<br />
'data-dir' => 'plex-data',<br />
'thumbnail-width' => 150,<br />
'thumbnail-height' => 250,<br />
'sections' => 'Movies, Tv Shows',<br />
'sort-skip-words' => 'a,the,der,die,das'
Here you need to change the IP Address, and modify the "sections" to include the sections you want. If no section is selected, all are exported.
Then you will need to run the cli.php script. It will populate the plex-data folder with the necessary info.
Once done, run the index.html file in a browser [s]and you should have all you need (and probably more)[/s] you should have most of what you need but might have to tweak it a bit to get the more detailed stuff. I love this thing
;-)
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
