Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Converting a report to CSV

 5 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
pops
Advanced Member
Posts: 46
Advanced Member
9/29/2016 5:32 PM

    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

    Leonard Courchaine
    Veteran Member
    Posts: 55
    Veteran Member
    9/29/2016 5:57 PM

      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
      9/29/2016 6:01 PM
        Where do I run that command from?
        Leonard Courchaine
        Veteran Member
        Posts: 55
        Veteran Member
        9/29/2016 6:05 PM
          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
          9/29/2016 6:09 PM
            We're windows so that won't work.
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
            9/29/2016 7:22 PM

              You can run it from LID as well

              You may or may not have to do the command as

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