INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Export Playlist in CSV + UTF-8  (Read 635 times)

tdot

  • Recent member
  • *
  • Posts: 34
Export Playlist in CSV + UTF-8
« 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?
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2567
Re: Export Playlist in CSV + UTF-8
« Reply #1 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.
Logged

tdot

  • Recent member
  • *
  • Posts: 34
Re: Export Playlist in CSV + UTF-8
« Reply #2 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.
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2567
Re: Export Playlist in CSV + UTF-8
« Reply #3 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.
Logged

tdot

  • Recent member
  • *
  • Posts: 34
Re: Export Playlist in CSV + UTF-8
« Reply #4 on: March 19, 2021, 01:45:22 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.
Logged
Pages: [1]   Go Up