INTERACT FORUM

More => Old Versions => JRiver Media Center 27 for Windows => Topic started by: tdot on March 19, 2021, 10:52:01 am

Title: Export Playlist in CSV + UTF-8
Post by: tdot on March 19, 2021, 10:52:01 am

I am creating a pseudo integration process between MC & Tidal. 

I want to sync playlist with Tidal.  I am using Soundiiz to help me achieve this.

I want to export playlist in CSV format because it gives me all the tags with headers.  However it does not UTF-8 compliant.  If I use the M3U8 Playlist option, it does not give me all the tags since there is no extended option.

What can I do?

Title: Re: Export Playlist in CSV + UTF-8
Post by: zybex on March 19, 2021, 11:05:03 am

You can just switch to Details view (text columns), select all, CTRL+C, and paste into Excel.
Then Save-as UTF8 CSV.

Title: Re: Export Playlist in CSV + UTF-8
Post by: tdot on March 19, 2021, 12:37:34 pm

I experimented with it in the last hour.  Stupid Soundiiz only imports well with M3U.

I am pretty stuck here.

Title: Re: Export Playlist in CSV + UTF-8
Post by: zybex on March 19, 2021, 01:11:43 pm

Well... one way is to build your M3U lines with an expression.
Add an Expression column or field with this:

Code: [Select]

#EXTINF:Math(int([duration,0])),[Artist] - [Name]
#EXTALB:[Album] ([Year])
#EXTART:[Album Artist]
#EXTGENRE:Replace([Genre],;,/,/ )
[filename]


Make sure to add an extra blank line at the bottom.
Now you have a field with the individual M3U segments. You can now:
- copy all info to excel
- select just the column in excel containing the M3U text, CTRL+C it
- paste into Notepad++ (or other editor supporting UTF8)
- slap an #EXTM3U at the top
- remove the extra double-quotes that Excel added
- save as .m3u

Not simple, but not too hard either. You can add other tags with more info as needed, but you'll have to research what works.

Title: Re: Export Playlist in CSV + UTF-8
Post by: tdot on March 19, 2021, 01:45:22 pm

Quote from: zybex on March 19, 2021, 01:11:43 pm

Well... one way is to build your M3U lines with an expression.
Add an Expression column or field with this:

Code: [Select]

#EXTINF:Math(int([duration,0])),[Artist] - [Name]
#EXTALB:[Album] ([Year])
#EXTART:[Album Artist]
#EXTGENRE:Replace([Genre],;,/,/ )
[filename]


Make sure to add an extra blank line at the bottom.
Now you have a field with the individual M3U segments. You can now:
- copy all info to excel
- select just the column in excel containing the M3U text, CTRL+C it
- paste into Notepad++ (or other editor supporting UTF8)
- slap an #EXTM3U at the top
- remove the extra double-quotes that Excel added
- save as .m3u

Not simple, but not too hard either. You can other other tags with more info as needed, but you'll have to research what works.

It works like a charm!  Thanks so much.