INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Tolga on May 10, 2003, 04:14:55 pm

Title: problem in exporting to excel
Post by: Tolga on May 10, 2003, 04:14:55 pm

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?

Title: Re: problem in exporting to excel
Post by: KingSparta on May 10, 2003, 04:21:51 pm

>> 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

Title: Re: problem in exporting to excel
Post by: gkerber on May 11, 2003, 05:54:51 pm

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.....