Rather than playing around with the M3U text files and having to do a
lot of reformatting, I go right to the server database, using the MySQL
Query Browser. That way I can pull the individual fields, export the
results to a spreadsheet, and format and print (or email to friends) a
readable playlist, including the artist and album each track is pulled
from. I'm not currently at my personal PC where my queries are saved,
but I think the query I use is pretty much like this:
Code:
--------------------
/* Query to get the tracks in all playlists */
select cast(t2.title AS char(100)) AS "Playlist",
pl.position + 1 AS "Track Number",
cast(tr.title AS char(100)) AS "Song Title",
if(al.compilation = 1, "Various Artists", cast(co.name AS char(100))) AS
"Artist",
cast(al.title AS char(100)) AS "Album Title",
tr.url AS "File Path"
from tracks t2,
playlist_track pl,
tracks tr,
albums al,
contributor_track ct,
contributors co
where t2.content_type = "ssp"
and pl.playlist = t2.id
and tr.url = pl.track
and al.id = tr.album
and ct.track = tr.id
and ct.role = 1
and co.id = ct.contributor
order by 1, 2
--------------------
This gives me the information I want, broken out by playlist name, and
with a little formatting in Excel I can print something like:
Code:
--------------------
Playlist: Messin' Around
Track: Song: Artist: Album:
1 Hypnotized Fleetwood Mac Mystery To Me
2 Rub Me Raw Warren Zevon The Wind
3 Rack 'Em Up Jonny Lang Lie To Me
4 Elmira St. Boogie Danny Gatton Hot Rod Guitar
5 Turn It Up Todd Snider Songs For The Daily Planet
6 Mess Around Ray Charles Greatest Hits
7 : : :
8 : : :
--------------------
The query can be modified to include things like year and genre, if you
like. In any case, it saves me the trouble of having to format full-path
file names down into just song titles and artists, and lets me fill in
other information as desired. I run this periodically (if I've added new
playlists, or made significant changes) and export it to a spreadsheet
that has the proper formatting already set up; that way it's handy when
I need it.
--
Dogberry2
------------------------------------------------------------------------
Dogberry2's Profile: http://forums.slimdevices.com/member.php?userid=18883
View this thread: http://forums.slimdevices.com/showthread.php?t=71265
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
