INTERACT FORUM

Please login or register.

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

Author Topic: problem in exporting to excel  (Read 843 times)

Tolga

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 438
problem in exporting to excel
« 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?


Logged

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Re: problem in exporting to excel
« Reply #1 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
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

gkerber

  • Guest
Re: problem in exporting to excel
« Reply #2 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.....
Logged
Pages: [1]   Go Up