would like to have the job submitted create the .prt file and pdf report but want to have the csv file as will to use for the excel file that requested as well.
You can use %GENDIR%inldxffiles to convert the prt file to csv and not have to run the job twice.
bldxffiles -SC <user> <print file dir> <out file name>
Hi c, try this with the attached file. Make a copy named PR275.cfg, and set the runtime csv parameter to "on." Place the file in source file folder where the rest of the PR275 source code resides. Then try running your PR275 and see if it creates both a prt and a cav for you in the print folder. We set up this file so long ago that I can't remember whether we had to recompile the program or not, but I don't think we did.
UPDATE: I cannot upload the file to this thread, not sure why. So I have included this screen shot of the file's text, which shows all the spaces and carriage returns, to help you type one up yourself. Copy this, set RUNTIME_CSV to ON, name it PR275.cfg, and store it in the prsrc folder with the PR275 source code.
This is the added node I tried by creating a .bat file with the bldxffiles command and then executing with a syscmd node but i get error below:
Activity name:CreateCSVbldxff id:4 started @ 03/06/2021 10:33:47.712 PM Executing on S3 - http://infor10.kdhcd.local... CreateCSVbldxff_errorCode = 8 CreateCSVbldxff_informationCode = 0 CreateCSVbldxff_returnMessage = File Access CreateCSVbldxff: Failed with error com.lawson.bpm.db.model.helper.LawsonDBException: javax.xml.bind.UnmarshalException: unexpected element (uri:"">http://www.w3.org/1999/xhtml", local:"html"). Expected elements are <{}Request>,<{}ServerStatus>,<{}Status>,<{}Url>,<{}dbRmiHostName>,<{}dbRmiPortNum>,<{}init-param>,<{}localDb>Nested exception:javax.xml.bind.UnmarshalException: unexpected element (uri:"">http://www.w3.org/1999/xhtml", local:"html"). Expected elements are <{}Request>,<{}ServerStatus>,<{}Status>,<{}Url>,<{}dbRmiHostName>,<{}dbRmiPortNum>,<{}init-param>,<{}localDb> at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallingContext.handleEvent(UnmarshallingContext.java:740)
I currently have it creating the pdf report and they also want an excel spreadsheet so if I change to csv I will be able to convert to excel but would need to create the pdf as well. Either way I will need to versions of same report.
the cfg file I pasted in above will create both files.
oh, ok, then thanks, i will try that then, I misunderstood and thought it was changing to csv.
Greg's solution would work; however you have a problem on your LSF server. The flow attempted to connect to your LSF RMI Server and was unable to get a result from https://<yourlsfserver/bpm/daservlet.The remote system command gets the LSF RMI Server host/port from daservlet ... then remotely executes the command through rmi on the lsf server. Since daservlet failed to return .. it couldnt connect to LSF.
