Export

[ajaxStardust]

This is a very nice app. Thank you!

Would you happen to have anything (or recommendation) for how to Export Plex playlists w/out a paid subscription?

Thank you!

[dakusan]

If you are running your own plex server there are good plugins that I've heard can do this kind of thing WebTools looks like it can. Webtools also has an unofficial plugin store.

I personally use an sqlite3 query of the following to dump my entire database, but that doesn't really answer your question on playlists. But a similar query could be made for playlists. sqlite3 ~/AppData/Local/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db 'SELECT file, title, MDI."index", hints FROM media_parts AS MP INNER JOIN media_items AS MI ON MI.id=MP.media_item_id INNER JOIN metadata_items AS MDI ON MDI.id=MI.metadata_item_id;' >> OUTPUT_FILE

The code in this project should have the information on the database tables for playlists.

I don't have more offhand than that.

[ajaxStardust]

Greetings!

Thank you very much for your reply. I found a few tools but no success yet (see https://github.com/darrylwhitmore/PlexMusicPlaylistExporter - it's in C# and I don't have Visual Studio. tried CSC.exe which threw an error, and I enquired there. He gave me instructions. etc. haven't had time yet)

If I knew where the data is (the songs in the playlist), I'm sure I could extract it using regular expressions or something? I looked through I've looked in C:\Users\my_name\AppData\Local\Plex Media Server\Logs , but I can't determine if there's anything there that I could use. It looks serialized, or encoded somehow and there's so much info; metadata. i'm probably looking at the wrong files...

Are you saying the Plex playlists are already stored in an SQLite database, or that's specific to your application? (sorry.) I'm decent w/ SQL, so that might be my route if I can find the database.

[ respondent removed garbage text from this post @a ]

------ Original Message ------ From "Jeffrey Riaboy" @.> To "dakusan/PlexPlaylistImporter" @.> Cc "ajaxStardust" @.>; "Author" @.> Date 10/10/2022 5:31:30 AM Subject Re: [dakusan/PlexPlaylistImporter] Export (Issue #21)

If you are running your own plex server there are good plugins that I've heard can do this kind of thing WebTools https://github.com/ukdtom/WebTools.bundle looks like it can. Webtools also has an unofficial plugin store.

I personally use an sqlite3 query of the following to dump my entire database, but that doesn't really answer your question on playlists. But a similar query could be made for playlists. sqlite3 ~/AppData/Local/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db 'SELECT file, title, MDI."index", hints FROM media_parts AS MP INNER JOIN media_items AS MI ON MI.id=MP.media_item_id INNER JOIN metadata_items AS MDI ON MDI.id=MI.metadata_item_id;' >> OUTPUT_FILE

The code in this project should have the information on the database tables for playlists.

I don't have more offhand than that.

— Reply to this email directly, view it on GitHub https://github.com/dakusan/PlexPlaylistImporter/issues/21#issuecomment-1273037942, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWO26CCKYKK65RW3TQR5FADWCPO7FANCNFSM6AAAAAARAZCXZE. You are receiving this because you authored the thread.Message ID: @.***>

[dakusan]

All Plex database data, including playlists, are stored in sqlite3 databases. If you run my importer and extract the queries it uses, you will have all you need to create an export query. I've tested WebTools and it works well.

[ajaxStardust]

Thank you for the reply. This is what I get when I try to run the code, based on the the README.md file:

PS C:\Portable\_temp_\PlexPlaylistImporter-master> python setup.py py2exe
Traceback (most recent call last):
  File "C:\Portable\_temp_\PlexPlaylistImporter-master\setup.py", line 2, in <module>
    import py2exe
ModuleNotFoundError: No module named 'py2exe'

any idea what i might be doing wrong? i do have python3 on my system.

also tried:

Path
----
C:\Python310

PS C:\Python310> cd "C:\Portable\_temp_\PlexPlaylistImporter-master\"
PS C:\Portable\_temp_\PlexPlaylistImporter-master> C:\Python310\python.exe setup.py py2exe
Traceback (most recent call last):
  File "C:\Portable\_temp_\PlexPlaylistImporter-master\setup.py", line 2, in <module>
    import py2exe
ModuleNotFoundError: No module named 'py2exe'

[dakusan]

You're trying to compile it, when all you need to do is run it. I also have an executable version available at https://www.castledragmire.com/ProjectContent/Plex_Playlist_Importer/PlexPlaylistImporter_Binary.1.1.0.0.zip