INTERACT FORUM

Please login or register.

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

Author Topic: export playlist  (Read 2484 times)

phalanthus

  • Galactic Citizen
  • ****
  • Posts: 461
export playlist
« on: March 11, 2012, 06:21:33 pm »

 :'( :'( :'( :'(
.txt file as an option seems to have disappeared
any reason why or am i mistaken ?
Logged

Scolex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1116
  • Cheers
Re: export playlist
« Reply #1 on: March 11, 2012, 08:18:30 pm »

text file  (CSV delimited) is an option for me.
Which version are you using? Are you doing this through right click or the file menu?

The below is from the 17.0.95 update (related?)
8. Changed: The text output in the Export Playlist tool creates standard CSV output (RFC 4180 compliant).
Logged
Sean

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: export playlist
« Reply #2 on: March 11, 2012, 08:23:11 pm »

Quote
17.0.95 (2/24/2012)

8. Changed: The text output in the Export Playlist tool creates standard CSV output (RFC 4180 compliant).
Logged
The opinions I express represent my own folly.

phalanthus

  • Galactic Citizen
  • ****
  • Posts: 461
Re: export playlist
« Reply #3 on: March 11, 2012, 08:41:05 pm »

rather irritating
i used it to add track listings to RateYourMusic

why
why
why
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: export playlist
« Reply #4 on: March 11, 2012, 08:44:46 pm »

There were some fields that were multi-line (eg. bookmark), and not quoted properly, so spreadsheets failed to import them.  The "pipe"-separated fields "standard" was not well-defined or robust enough to handle MCs fields.

I requested the change, and Matt was concerned about breakage.  Focus blame my way...
Logged
The opinions I express represent my own folly.

Scolex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1116
  • Cheers
Re: export playlist
« Reply #5 on: March 11, 2012, 08:49:05 pm »

phalanthus I am puzzled by your "why why why"
it is still there it was just some formatting changes to comply with the standard used by programs like excel
Logged
Sean

phalanthus

  • Galactic Citizen
  • ****
  • Posts: 461
Re: export playlist
« Reply #6 on: March 11, 2012, 09:06:12 pm »

phalanthus I am puzzled by your "why why why"
it is still there it was just some formatting changes to comply with the standard used by programs like excel

don't be puzzled !!

"The "pipe"-separated fields "standard" was not well-defined or robust enough to handle MCs fields" [from MrC]

The "pipe"-separated fields was exactly what i wanted - it is now useless from my point of view
i will revert to MediaCenter prior to 17.0.95 - very irritating
Logged

phalanthus

  • Galactic Citizen
  • ****
  • Posts: 461
Re: export playlist
« Reply #7 on: March 11, 2012, 09:11:35 pm »

have reverted to 17.0.91 - maybe JRiver will look at this ??
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42372
  • Shoes gone again!
Re: export playlist
« Reply #8 on: March 11, 2012, 09:25:35 pm »

Text output now conforms to RFC 4180 (standard CSV).

This is a good change in my opinion, and any reasonable parser should accept CSV.
Logged
Matt Ashland, JRiver Media Center

phalanthus

  • Galactic Citizen
  • ****
  • Posts: 461
Re: export playlist
« Reply #9 on: March 11, 2012, 09:36:48 pm »

 ?

not sure i totally understand this but there is nothing to stop me also installing MediaCenter 16 as well which will do what i want
Logged

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: export playlist
« Reply #10 on: March 12, 2012, 02:45:28 am »

I share your pain on this one.  I hate changes that come out of the blue (who doesn't?), even if they are for the best in the long run (conformity) and this one caused me a lot of short term problems.  The pipe delimited format should have been retained as a separate option to allow those that rely it on continued smooth processing.

Not sure how you used the txt files, but I was able to update my processing scripts to handle the CSV format so, at least until the next unexpected change, I am back to full functionality with my external processing.







Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: export playlist
« Reply #11 on: March 12, 2012, 12:58:17 pm »

phalanthus, mark_h: it is fairly trivial to convert from one format to another.  Is there something you're both doing that makes this difficult?  Do you need some help in your process?
Logged
The opinions I express represent my own folly.

Scolex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1116
  • Cheers
Re: export playlist
« Reply #12 on: March 12, 2012, 03:22:12 pm »

As an example of what MrC is talking about I just converted a MC 17 csv (comma delimited) export to be identical to  MC 16 txt export (pipe delimited) in a matter of seconds in Notepad++
I was curious as to the format difference and it is just the pipes vs commas and the MC 16 format has some extra delimiters (see below)

MC 16
Code: [Select]
|Name|Artist|Album|Track #|Length|File Type|
|Helpless|Metallica|The $5.98 E.P. Garage Days Re-Revisited|1|6:36|flac|
|The Small Hours|Metallica|The $5.98 E.P. Garage Days Re-Revisited|2|6:40|flac|

MC 17
Code: [Select]
Name,Artist,Album,Track #,Length,File Type
Helpless,Metallica,The $5.98 E.P. Garage Days Re-Revisited,1,6:36,flac
The Small Hours,Metallica,The $5.98 E.P. Garage Days Re-Revisited,2,6:40,flac

Just as an FYI the playlist in question had 1420 files in it.
Logged
Sean

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Re: export playlist
« Reply #13 on: March 12, 2012, 08:26:39 pm »

Quote
As an example of what MrC is talking about I just converted a MC 17 csv (comma delimited) export to be identical to  MC 16 txt export (pipe delimited) in a matter of seconds in Notepad++

Perhaps if you were to explain how, I could figure out how to do so with UltraEdit. :-\
Logged

Scolex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1116
  • Cheers
Re: export playlist
« Reply #14 on: March 12, 2012, 11:29:25 pm »

Here is how I did it with Notepad++

Step 1:  (this adds the pipe at the beginning and end of each line)
search>replace
find what        \n
replace with   |\n|
check           extended, regular expression, whatever it says in UltraEdit
Replace all

step 2 (replaces all commas with pipes)
find what         ,
replace with     |
uncheck          extended, ...
replace all

Conversion is complete other than adding 1 pipe to the beginning of the first line.

PS I you have any commas in any of the fields you export there will be an additional step if you don't want to loose them.
I would explain that step but I can't remember the escape syntax for commas in csv off of the top of my head.
Logged
Sean

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: export playlist
« Reply #15 on: March 13, 2012, 02:51:55 am »

I'm already done with converting.  Using notepad et al is out of the question - it has to be done with scripts.  Every week I dump multiple playlists from MC for processing with a whole bunch of scripts that relied on the pipe delimited format.  Every one of them was broken by the change and required modifying.  It wasn't a big problem, just very unwelcome, as I had to change my Sunday morning plans to accommodate the change.

JRiver need to remember that people actually use their software and that unannounced changes have consequences...

Logged

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: export playlist
« Reply #16 on: March 13, 2012, 02:54:39 am »

PS I you have any commas in any of the fields you export there will be an additional step if you don't want to loose them.
I would explain that step but I can't remember the escape syntax for commas in csv off of the top of my head.

And this is exactly what I hit.  In my entire database I have ZERO pipes within fields, but I have plenty of commas and these broke my initial conversion attempts.  The complexity of parsing CSV isn't as simple as it first seems.  But as has been noted elsewhere, many programming languages now have libraries for handling the conversion for you.
Logged

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Re: export playlist
« Reply #17 on: March 13, 2012, 03:05:19 am »

Quote
I you have any commas in any of the fields you export there will be an additional step if you don't want to loose them.

This is what I wasn't sure how to handle, plus the fact memo fields would include line breaks. No problem, I was just curious if my fancy text editor would handle it. I can do whatever I might want to do in Excel.
Logged

phalanthus

  • Galactic Citizen
  • ****
  • Posts: 461
Re: export playlist
« Reply #18 on: March 13, 2012, 03:50:01 am »

my fix is to run MC15 in tandem
Logged
Pages: [1]   Go Up