Converting .prt file to Excel formats

Adding Topic details: We have a BN report created in our Process Flow. How can we convert .prt file to Excel format? Found bldxffiles command. Anybody done this before?

do you mean convert to csv ? Use the webrun node, check the "Infor Lawson" URL type and the call below in the "web program" field: (example is of a RQ500 report converted to csv)

servlet/Report?action=CSV&jobname=(jobname)

<!--rq500JobName-->

&file=(printfolder(/(userid)/(jobname)/1/RQ500.prt&REPORT_OWNER=userid

We use bldxffiles all the time in our processes, but not in IPA, although I bet it would work there as well. bldxffiles -SP . CB185.prt Will convert the CB185.prt file into a PDF file in the present directory (*Note the period) We'd just have to replace teh -SP with -SC to convert into a csv file which can be opened in Excel.

Greg, Before bldxffiles command, do you run a cd (change directory) command where CB185.prt resides? Thanks.

We do, yes. We also specify the whole path to bldxffiles as well.. not sure if this is necessary or not.... we've always specified the whole path and not tested without it.

Or I suppose you could specify the path to CB185.prt in place of the period

Greg, For a CSV file, will command create CB185.csv?

I believe so, but you'd have to try it out. Sometimes Windows is weird and/or case-sensitive with Infor/Lawson so it may come out as CB185.CSV and you may or may not have to account for that in your flow.

Below worked. Created BN320.csv in print directory . System Command node bldxffiles -SC BN320.prt Thanks to all.

Ignore previous reply because did not include variables. Below worked: bldxffiles -SC (jobuser) (print directory for job) BN320.prt