PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/20/2017 9:59 AM by  PD
How do I generate CSV output from batch program?
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Woozy
Private
Private
Veteran Member
(3478 points)
Veteran Member
Posts:704


Send Message:

--
03/09/2011 9:31 AM
    We use an external scheduler to launch S3 batch jobs from the command line using wtsubmit or jqsubmit.  After the jobs finish, we want to retrieve the .csv file from the $LAWDIR/print directory, but these files don't appear to exist until a user opens Print Manager and clicks the "Create CSV" button, which our automated scheduler can't do.

    Is there a way for us to trigger the creation of the CSV file from the command line, or some other way to make this happen?

    The programs we are running are mostly "canned" Lawson programs, so we don't want to modify them.

    I'd appreciate any thoughts or suggestions.  Thanks!

    Kelly
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    isln_boy
    Private
    Private
    Basic Member
    (24 points)
    Basic Member
    Posts:8


    Send Message:

    --
    03/09/2011 9:54 AM
    The command bldxffiles will do this.

    The Lawson KB# 556561 details how to run bldxffiles from a command line to create a CSV file

    bldxffiles -SC Username PathtoPrintFile PrintFileName
    Woozy
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    03/09/2011 10:28 AM
    Great! Thanks isln_boy!

    So, here's an interesting question. When I run batch programs on our DEV server the CSV is being created automatically when the batch program is run. However, in PROD they are not being created automatically. Is there a setting somewhere that controls this for the whole environment?
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Ragu Raghavan
    Private
    Private
    Veteran Member
    (863 points)
    Veteran Member
    Posts:301


    Send Message:

    --
    03/09/2011 11:05 AM
    Lawson System Foundation: Automatic generation of xml and csv files when running reports

    Article ID:5114030


    Description:
    How do I set my Lawson System Foundation (LSF) 9.0 system to automatically generate Extensible Markup Language (xml) and Comma-Separated Value (csv) files when I run reports?

    Resolution:
    In LAWDIR/system/rpt.cfg, set the following variables:

    RUNTIME_XML_ENABLE ON
    RUNTIME_CSV ON
    RUNTIME_XML ON

    Then stop IBM WebSphere Application Server (WAS), stoplaw, startlaw, and start WAS. The csv and xml files will be generated automatically.

    For more information on the rpt.cfg file, please see KB article 550786.

    Additional Information:

    Keywords:
    xml csv lsf rpt.cfg


    Related Knowledge Base documents
    Article ID: 550786 Configuring Report Options




    Woozy
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    03/09/2011 11:19 AM
    Thanks Ragu!  Very helpful.

    I learn something new every day.
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    PD
    Systems Integration Specialist
    Private
    Advanced Member
    (56 points)
    Advanced Member
    Posts:28


    Send Message:

    --
    12/19/2017 1:43 PM

    I have read and followed this post with the related KB 1202695 but I am getting an error message:

    "Error while processing .dtl file GetDtlFileInfo Returned Status = 1 - .dtl File was Not Found".

    The dtl file is located in the folder with the prt file (cloud based).....what might I be doing wrong?

    bldxffiles -SC 382396 D:\lsenv\law\lsapps\print\INFORBC_382396\pr295-all\1  PR295

    PD
    Systems Integration Specialist
    Private
    Advanced Member
    (56 points)
    Advanced Member
    Posts:28


    Send Message:

    --
    12/20/2017 9:59 AM

    Found the answer, remove lsapps from the path---

    bldxffiles -SC 382396 D:\lsenv\law\print\INFORBC_382396\pr295-all\1  PR295

    You are not authorized to post a reply.