PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/29/2016 3:22 PM by  Greg Moeller
Converting a report to CSV
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
pops
Systems Analyst
Private
Advanced Member
(85 points)
Advanced Member
Posts:39


Send Message:

--
09/29/2016 1: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
    Private
    Private
    Veteran Member
    (128 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    09/29/2016 1: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
    Systems Analyst
    Private
    Advanced Member
    (85 points)
    Advanced Member
    Posts:39


    Send Message:

    --
    09/29/2016 2:01 PM
    Where do I run that command from?
    Leonard Courchaine
    Private
    Private
    Veteran Member
    (128 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    09/29/2016 2:05 PM
    We're AIX so we run it from the Unix command prompt as the command is in $GENDIR/bin. 
    pops
    Systems Analyst
    Private
    Advanced Member
    (85 points)
    Advanced Member
    Posts:39


    Send Message:

    --
    09/29/2016 2:09 PM
    We're windows so that won't work.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    09/29/2016 3:22 PM

    You can run it from LID as well

    You may or may not have to do the command as

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

    You are not authorized to post a reply.