Converting .prt file to Excel formats

 10 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Scooter
Veteran Member
Posts: 83
Veteran Member
    Thanks for your assistance.
    Scooter
    Veteran Member
    Posts: 83
    Veteran Member
      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
      Veteran Member
      Posts: 475
      Veteran Member
        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
        Veteran Member
        Posts: 1498
        Veteran Member
          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
          Veteran Member
          Posts: 83
          Veteran Member
            Greg,
            Before bldxffiles command, do you run a cd (change directory) command where CB185.prt resides? Thanks.
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
              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
              Veteran Member
              Posts: 1498
              Veteran Member
                Or I suppose you could specify the path to CB185.prt in place of the period
                Scooter
                Veteran Member
                Posts: 83
                Veteran Member
                  Greg,
                  For a CSV file, will command create CB185.csv?
                  Greg Moeller
                  Veteran Member
                  Posts: 1498
                  Veteran Member
                    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
                    Veteran Member
                    Posts: 83
                    Veteran Member
                      Below worked. Created BN320.csv in print directory .

                      System Command node
                      bldxffiles -SC BN320.prt

                      Thanks to all.
                      Scooter
                      Veteran Member
                      Posts: 83
                      Veteran Member
                        Ignore previous reply because did not include variables.

                        Below worked:
                        bldxffiles -SC (jobuser) (print directory for job) BN320.prt