PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/05/2019 9:06 AM by  Scooter
Converting .prt file to Excel formats
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Scooter
Private
Private
Veteran Member
(119 points)
Veteran Member
Posts:55


Send Message:

--
08/29/2019 3:25 PM
    Thanks for your assistance.
    Scooter
    Private
    Private
    Veteran Member
    (119 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    08/29/2019 3:38 PM
    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?
    Ragu Raghavan
    Private
    Private
    Veteran Member
    (996 points)
    Veteran Member
    Posts:346


    Send Message:

    --
    08/29/2019 3:40 PM
    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

    Greg Moeller
    Private
    Private
    Veteran Member
    (3999 points)
    Veteran Member
    Posts:1423


    Send Message:

    --
    08/29/2019 3:51 PM
    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.
    Scooter
    Private
    Private
    Veteran Member
    (119 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    08/29/2019 4:34 PM
    Greg,
    Before bldxffiles command, do you run a cd (change directory) command where CB185.prt resides? Thanks.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3999 points)
    Veteran Member
    Posts:1423


    Send Message:

    --
    08/29/2019 4:38 PM
    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.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3999 points)
    Veteran Member
    Posts:1423


    Send Message:

    --
    08/29/2019 4:40 PM
    Or I suppose you could specify the path to CB185.prt in place of the period
    Scooter
    Private
    Private
    Veteran Member
    (119 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    08/29/2019 4:40 PM
    Greg,
    For a CSV file, will command create CB185.csv?
    Greg Moeller
    Private
    Private
    Veteran Member
    (3999 points)
    Veteran Member
    Posts:1423


    Send Message:

    --
    08/30/2019 8:55 AM
    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.
    Scooter
    Private
    Private
    Veteran Member
    (119 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    09/05/2019 9:04 AM
    Below worked. Created BN320.csv in print directory .

    System Command node
    bldxffiles -SC BN320.prt

    Thanks to all.
    Scooter
    Private
    Private
    Veteran Member
    (119 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    09/05/2019 9:06 AM
    Ignore previous reply because did not include variables.

    Below worked:
    bldxffiles -SC (jobuser) (print directory for job) BN320.prt
    You are not authorized to post a reply.