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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
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 Send Private Message
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