Dogberry2;484145 Wrote: > 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.
Hi, That looks good, looks what I am after, but way above my league to understand, good you can add what you want exported to a file, I would like Artist/Track/Album/Duration, will try to read up about it... Cheers Jay -- JayLaFunk ------------------------------------------------------------------------ JayLaFunk's Profile: http://forums.slimdevices.com/member.php?userid=30179 View this thread: http://forums.slimdevices.com/showthread.php?t=71265 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
