How do I generate CSV output from batch program?
Last Post 03/09/2011 10:19 AM by Woozy. 4 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Resolved
WoozyUser is Offline
Private
Private
Veteran Member
(1124 points)
Veteran Member
Posts:414
Woozy

Send Message:Send Private Message

--
03/09/2011 08: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

    DB2-AIX
    LSF 9.0.1.11, S3 Apps 9.0.1.7, PFI 9.0.1, LBI
    Landmark 9.2.5, LTM 3.4.2.8, IPA 9.2.4
    Landmark 10.1.1.6, TM 10.2, IPA 10 (Upgrade in-process)
    isln_boyUser is Offline
    Private
    Private
    Basic Member
    (24 points)
    Basic Member
    Posts:8
    isln_boy

    Send Message:Send Private Message

    --
    03/09/2011 08: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
    WoozyUser is Offline
    Private
    Private
    Veteran Member
    (1124 points)
    Veteran Member
    Posts:414
    Woozy

    Send Message:Send Private Message

    --
    03/09/2011 09: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

    DB2-AIX
    LSF 9.0.1.11, S3 Apps 9.0.1.7, PFI 9.0.1, LBI
    Landmark 9.2.5, LTM 3.4.2.8, IPA 9.2.4
    Landmark 10.1.1.6, TM 10.2, IPA 10 (Upgrade in-process)
    Ragu RaghavanUser is Offline
    Private
    Private
    Veteran Member
    (704 points)
    Veteran Member
    Posts:244
    Ragu Raghavan

    Send Message:Send Private Message

    --
    03/09/2011 10: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




    WoozyUser is Offline
    Private
    Private
    Veteran Member
    (1124 points)
    Veteran Member
    Posts:414
    Woozy

    Send Message:Send Private Message

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

    I learn something new every day.
    --------------------------------------
    Kelly Meade
    J. R. Simplot Company
    Boise, ID

    DB2-AIX
    LSF 9.0.1.11, S3 Apps 9.0.1.7, PFI 9.0.1, LBI
    Landmark 9.2.5, LTM 3.4.2.8, IPA 9.2.4
    Landmark 10.1.1.6, TM 10.2, IPA 10 (Upgrade in-process)
    You are not authorized to post a reply.