Converting a report to CSV

 5 Replies
 1 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
pops
Advanced Member
Posts: 46
Advanced Member

I am running Lawson 10 and running a GL240.  Once the report is completed, I convert it to a CSV file through the print manager and when I open the CSV file, about a third of the way down, the files seems to get corrupted.  Data is missing, shifted, etc.  There are about 6000 rows returned so I know I'm not reaching the row limit of Excel 2010.  Is there another simple way to convert it to a csv without it getting corrupted or is this a bug?

 

Thank you in advance!!

Pops

Deleted User
New Member
Posts: 0
New Member

Hi,

Not sure if this would make a difference but have you tried using the bldxffiles command?  (This may be doing the same thing but just thought I'd mention it).  Here's an example of using the command:

bldxffiles -SC apautojo /lsfprod/law/print/apautojo/ap126-2x/1 AP126.prt

Lenny

pops
Advanced Member
Posts: 46
Advanced Member
Where do I run that command from?
Deleted User
New Member
Posts: 0
New Member
We're AIX so we run it from the Unix command prompt as the command is in $GENDIR/bin. 
pops
Advanced Member
Posts: 46
Advanced Member
We're windows so that won't work.
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!

You can run it from LID as well

You may or may not have to do the command as

%GENDIR%\bin\bldxffiles ......