Prev
Next
Forums Integration / Customization S3 Customization/Development

How do I generate CSV output from batch program?

 6 Replies
 1 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Woozy
Veteran Member
Posts: 709
Veteran Member
3/9/2011 2:31 PM
    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
    Basic Member
    Posts: 8
    Basic Member
    3/9/2011 2:54 PM
      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
      Veteran Member
      Posts: 709
      Veteran Member
      3/9/2011 3:28 PM
        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
        Veteran Member
        Posts: 476
        Veteran Member
        3/9/2011 4:05 PM
          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
          Veteran Member
          Posts: 709
          Veteran Member
          3/9/2011 4:19 PM
            Thanks Ragu!  Very helpful.

            I learn something new every day.
            Kelly Meade
            J. R. Simplot Company
            Boise, ID
            PD
            Veteran Member
            Posts: 58
            Veteran Member
            12/19/2017 6: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
              Veteran Member
              Posts: 58
              Veteran Member
              12/20/2017 2:59 PM

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

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