I think the Topic explains about everything ;)

If Plex doesn't implement this, I'm working on a work-around you might be interested in. https://forums.plex.tv/topic/120292-m3u-playlist-converter/

Hi Moviefan, good idea to get going - i checked your files, problem is my box runs on Debian Linux ;) I also tried the sqllite DB, but there is no table "playlists", so i am really curious where plex stores my playlist i created for testing.... if i could find where it is, i would just hack togeth…

I’m away from my computer so i don’t have the exact madness but playlists are a combination of 3 tables. Metadata_items which hold the name, (something)_generated is the actual list, and (something)_accounts is what shows on the webapp.

Thanks a lot - that helped ;) To select all entries of a playlist you would use: select pqg.playlist_id , pqg.id , mi.title , mi.original_title , d.path , mp.file from play_queue_generators pqg join metadata_items mi on mi.id = pqg.metadata_item_id join media_items m on m.metadata_i…

That is based on an algorithm that uses the timestamp. I found that plex doesn't really use it that i can tell so i just put the string up to the //. You also need the created at and updated at values. Those are required values. Edit: You don't need the directories table. Just use the file column…

Here it comes, tested on my box. No responsibility at all! You need PHP on your box with enabled SQLite support (enter php -i | grep sqlite) - if nothing is shown: apt-get install php5-sqlite So if everything is installed, you can create this script (just create it somewhere on your server). …

Nice work. Only comment is regarding the order field. That field has a 7 digit precision so it maxes out at 9,999,000 (9,999 songs in the playlist). Not sure why Plex uses multiples of 1,000. I got rid of the extra zeros so my list allows 9,999,999 songs to be included. I could have just gotten…

Thanks - the 1000 steps could be sort of space for later user-based reshuffling... even though it is not the nicest approach ;)

Yeah. It is just easier to resort the entire list.

Add music folders to a playlist or create playlist from folder

Feature Suggestions

Topic		Replies	Views
Ability to add a whole folder to playlist Feature Suggestions playlists	2	86	February 18, 2023
Creating playlists / adding items to playlists Dev/API Corner other-dev	2	120	December 21, 2019
[HowTo] Create Playlists Tips, Tricks & How-Tos tipstricks	59	84829	July 25, 2024
Music Playlists - playlist files location and formats query Metadata & Adding Files playlists	1	311	June 6, 2021
Music Collection or playlist from folder Metadata & Adding Files	2	60	September 22, 2024

Add music folders to a playlist or create playlist from folder

Related topics