[mythtv-users] mythmusic - export playlist to m3u

[Jeremy Jones]

On Sun, Jan 19, 2014 at 6:38 AM, Warpme <warpme at o2.pl> wrote:

> On 17/01/14 05:15, Jeremy Jones wrote:
>
>> Does anyone have a script that will export all mythmusic playlists to m3u
>> files? If not a script does anyone have some pointers on how one might
>> retrieve the info from the database to create such a script?
>>
>> Thanks,
>>
>> Jeremy
>>
>>
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>
> Jeremy,
> At some point in time I develop simple solution for backup/restore
> MythMusic playlists (and also for dumping playlist songs files to dir for
> creatng USB key with music to play them in car). Idea is to:
> -dump playlist to m3u (backup)
> -load m3u and store it as MythMusic playlist (restore playlist when i.e
> You rebuild whole music DB - so songs IDs are different)
>
> For dumping playlist pls look on attached .sh script.
> For converting m3u to playlist - pls look on attached php script (You can
> this script into mythweb root dir and launch in web browser).
>
> Hope it helps!.
>
>
> Just took a look at the script and was hoping you could answer a couple of
questions:
1) I noticed that you commented out the line to populate MYTHHOST:

#MYTHHOST=$(grep DBHostName <"$MYTHCONFDIR/mysql.txt" | awk -F= '{print
$2}')

How can it work if that is commented out?

2) I'm not so comfortable with the sql from bash, and I really need a
script that will loop through all playlists instead of just the one. If
that is trivial and someone wants to add that, please email it out.
 Otherwise, I'll probably try to use the python bindings instead and see if
I can put something together.

Thanks for the two examples.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140119/1b9e8057/attachment.html>