Where are playlists located?

Discussion about anything that might be of interest to MediaMonkey users.

Moderator: Gurus

johandenver

Where are playlists located?

Post by johandenver » Wed Dec 14, 2005 3:15 am

Hi!

Is it possible to move a created custom playlist from one computer to another? Sort of like exporting it?
Are they actually files I can copy or is it embedded in MM?

/Johan

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto » Wed Dec 14, 2005 4:48 am

They are stored in the database I believe. There are however scripts for exporting to a number of different filetypes including PLS and M3U.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

johandenver

Post by johandenver » Wed Dec 14, 2005 4:57 am

Yes, I tried exporting it but then it just exports the songs in a playlist and not the playlistconfiguration itself, which is what I want. :)
The problem is that when I reinstall MM sometimes, my playlists all vanish and there seems to be no way to backup them up.
I don't want to use a backup of the MM-database unless I'm forced to.
I like the whole installation to be as "fresh" as possible :P

/Johan

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto » Wed Dec 14, 2005 5:59 am

Maybe somone could write a script to export the relevant database table and another to import them. Would take more SQL knowledge than I have though. And playing with the database directly is not a wise idea.

What information do these scripts fail to export/import?
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

johandenver

Post by johandenver » Wed Dec 14, 2005 6:42 am

It fails to export the information about how the playlist is set up.
I'd like to be able to export the criterias of an autoplaylist to another
computer without having to create it all over again.
The only info that comes from an export is what songs match the criterias but that's not really the information I want.

Lets say I create an autoplaylist searching for all songs with a rating of 4 and higher within the genres pop & rock.
It would be great to just be able to do "Save as" and get a file to import on another computer to do a similar search on that database.
When you have 30 different autoplaylists it can be kind of annoying having to create them all over again when MM have to be reinstalled.

Maybe this is something for the wishlist then?

/Johan

onkel_enno
Posts: 2146
Joined: Fri Jan 14, 2005 1:45 am
Location: Germany
Contact:

Post by onkel_enno » Wed Dec 14, 2005 7:00 am

@Johan
If you deinstall MM, the playlists will still remain. They aren't deleted.
They are saved within My Documents\My Music\MediaMonkey\MediaMonkey.mdb.
If you really want to backup the palylists, then you should backup this file.
SansaMonkey - for SanDisk Sansa and Rockbox Users

Please no PMs for Questions which should be asked in the Forum. Thx

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto » Wed Dec 14, 2005 7:36 am

johandenver wrote:I don't want to use a backup of the MM-database unless I'm forced to. I like the whole installation to be as "fresh" as possible :P
@onkel_enno: Where are the criteria saved? I couldn't find them in the database. Which table?
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

onkel_enno
Posts: 2146
Joined: Fri Jan 14, 2005 1:45 am
Location: Germany
Contact:

Post by onkel_enno » Wed Dec 14, 2005 8:52 am

Open the Table Playlists and resize the field Querydata - not in width but in height -> Surprise :lol:

If you don't want to backup the whole library (thx trixmoto for the hint) then I'm sure trixmoto will create a script the saves them for you in a textfile or so :wink:
SansaMonkey - for SanDisk Sansa and Rockbox Users

Please no PMs for Questions which should be asked in the Forum. Thx

johandenver

Post by johandenver » Wed Dec 14, 2005 9:00 am

If trixmoto could do that I would be very grateful.
But I would also need and script that could import the textfile then
otherwise it would be of little use.
Thanks for your time, both of you.

/Johan

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto » Wed Dec 14, 2005 9:26 am

That is quite surprising! :) My logic had taken me to that field, but when I extended it width-ways and found nothing I gave up - silly me!

If you could provide me with the SQL statements onkel_enno I would be happy to create the script. I might be ok with the "select" statement, but definitely not happy with creating the "insert" (is it?) statement.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

Steegy
Posts: 3452
Joined: Sat Nov 05, 2005 7:17 pm
Location: Belgium
Contact:

Post by Steegy » Wed Dec 14, 2005 9:31 am

I don't want to sound "lazy" or something, but isn't it much easier to just export the Playlists table from the MM database to a new database?
This can then easily be imported or "pasted" back.

Cheers
Steegy
Extensions: ExternalTools, ExtractFields, SongPreviewer, LinkedTracks, CleanImport, and some other scripts (Need Help with Addons > List of All Scripts).

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto » Wed Dec 14, 2005 9:55 am

This is a very good point. In Access if you right-click on the "Playlists" table you can select "Export" from the context-menu.

Then you'd click "File, Get External Data, Import" to import the saved file.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

onkel_enno
Posts: 2146
Joined: Fri Jan 14, 2005 1:45 am
Location: Germany
Contact:

Post by onkel_enno » Thu Dec 15, 2005 1:38 am

What if johandenver has no MS Access?

For me, I would only backup the .mdb and everything is fine.

@trixmoto

Code: Select all

Insert Into Playlists (Playlistname, IsAutoPlaylist, QueryData) Values ('Huhu', 1, "[Common]
QueryVersion=1
...")
8)
SansaMonkey - for SanDisk Sansa and Rockbox Users

Please no PMs for Questions which should be asked in the Forum. Thx

johandenver

Post by johandenver » Thu Dec 15, 2005 7:10 am

I do not have MS Acess :-)

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto » Mon Dec 19, 2005 11:48 am

I'm sorry but I can't work out how to get the textdata itself out of the database.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

Post Reply