Where is the playlist data/file for Music Station?

[riodejaneiro]

Hi all,

I'm wondering if I can open and edit Music Station's playlist data in a different way than the Music Station GUI.
Does anyone know where the data/file is located and how to edit it.

What happened to me:
I use a TS-220 and set Music Station to play a playlist every morning using the built-in alarm function. Since I wanted to listen to different music every day, I created playlists like "Monday", "Tuesday", "Wednesday"... and set them to play on the corresponding day (the "Monday" playlist should play on every Monday morning).

Trouble is that, Music Station is too slow to create, edit, and organise music files to or within a playlist. If it's possible to open and edit playlist data in a different way (and much more efficient way) I would like to try.

What I have done:
To find the config data/file, I logged in my QNAP using SSH client and found that /share/[first volume]/.system/ has MyDB. Apparently this is the main database file to store multimedia file's metadata. I also found that this is in a sqlite3 format. But I could not find "playlist" data..
I grepped "Music Station" throughout QNAP but nothing returned.

Thank you in advance

Rio de Janeiro de Rio

[riodejaneiro]

I'm still struggling but want to share some discoveries.

As I suspected, MyDB is the main database for media file. I used sqlite (/usr/bin/sqlite3) to open the file. There are many tables that cleary relate to media files. One of the tables says "playlistTable"! This is it!

But the table seems a bit complecated.

These are the headers of playlistTable:
iPlaylistId|cPlaylistName|cFileName|iDirId|ProtectionStatus|DateCreated|DateModified|iFileSize|mime|dlna_pn|comment|owner|playlistType|expiration|Config|ScannedFlag|InvalidFlag|AttrFlag

There may be a long way to go..

Rio de Janeiro de Rio

[Mickie-Dee]

I'm wondering where playlist files are located as well. Does anyone know?

[riodejaneiro]

Hi all,

I finally found it.
/share/[first volume]/.system/MyDB
This is the database where playlists and everything have been stored.
Of the database, the "playlistTable" table contains information on the playlists while basic info on music files are in the "songTable." You also need to check the "playMediaTable" to configure own playlist from a way other than the Music Station's GUI interface.

I'm writting scripts to automatically generate playlists based on specified genres by day and time using PHP. Although I won't publish the script (I'm very beginner) I may be able to give some advice if someone wants.

To see the inside of the database, you should copy it first by "cp /share/[first volume]/.system/MyDB [your_location]" then open and edit with software for SQLite3 for example SQLiteSpy.

Cheers!

[TheBad]

Hello riodejaneiro

I would be very interest how to edit the playlist.
Thank to your previous answer I was able to locate the playlist.

Sadly I was not lucky when I tried to open them. I used SQLiteSpy but there a lot of unrecognized chars.
Is it possible to open the file under Windows 7 without doing any conversion?

If your php-scirpt is now in a stable state I would also be happy to get it.

Greetings.

[johnson407]

That's the mariadb files. You can connect to it via port 3310 with login root/qnapqnap

[TheBad]

Are you sure that username and password are correct.
I try to establish a ODBC Conntection from my Windows 7 computer and I cannot log in.

Error message : [ma-1.0.6]Access denied for user 'root'@192.168.xxx.xxx' (using password: YES)

[johnson407]

that's what I find in the scripts /etc/init.d/QMediaService.sh

[TheBad]

I had a look at the scripts as well and found out that there is a second user read with pw read. This one is working.
How can I start the script which creates the user root?
Should I be able to do this with phpmyadmin as well?

[homebody1966]

not sure if this is relevant, but...
how do i add music playlists to plex?
i was able to create a music library, but it didn't include the playlists