Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Tolga]

ISSUE 1: Bug
There is a problem  in "copy a MC view and paste to excel" scheme. If some fields contain newline characters (i.e. in lyrics or notes), the field continues in the first field of the next row and the table structure is lost. The same problem occurs in exporting the playlist to a comma delimitted format.

The solution may be to replace the newline's with another character.

ISSUE 2: Question

I know you can export to excel using XML. There was a bug there; with a recent fix, excel can open MC generated XML, but you get a table with three columns (#,fieldname, value). Does anyone know a way to use some excel tricks to transform that information to a conventional table format?

[KingSparta]

>> The same problem occurs in exporting the playlist to >> a comma delimitted format.
yep you can't have them in there or a few other chrs

[gkerber]

Yeah, and never ever, put a | char in any field, since that's the delimiter in the delimited output.

I struggled to figure out why a program I wrote was failing after switching to MC9, then I actually looked at the delimited file and found newline chars in the data, which really screws up a line oriented read.....