Export PO15 data?

 8 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
lakilester
New Member
Posts: 2
New Member
    Our organization does not allow procurement templates to be locked using PO15.3. Is there a way to export PO15.1 data to Excel or another program in the event that a template gets deleted (which has happened before)?
    Amanda Valcik
    Advanced Member
    Posts: 28
    Advanced Member
      You can use the add-ins to download them into an Excel file
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
        I would run PO215 and export as a csv file or query the PROCTEMP and PROCTEMPLN tables with Addins or Crystal.
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        David Williams
        Veteran Member
        Posts: 1127
        Veteran Member
          You could also do a dbdump of the table. Lot's of options.
          David Williams
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
            We dump via query wizard for the major system upgrades. I can share the dme if you need it. (it doesn't recognize the .dme extension when I try to attach it here.) 

            But for the few times someone's deleted something they shouldn't have, I've restored the template from our test server.  We're usually within a few months and the templates don't change often enough to be completely off.  The few changes that have to be redone are just part of the "NEVER CLICK DELETE IN PROD" lesson.
            lakilester
            New Member
            Posts: 2
            New Member
              Thanks so much for the responses! I'm running a fairly bare-bones version of Lawson, so I can get as far as PO215 but cannot seem to figure out how to export the report that is run into a .csv file.
              David Williams
              Veteran Member
              Posts: 1127
              Veteran Member
                CSV should be one of your view options when you open the report (like PDF). If you don't see the option then your system admin may not have made it available.
                David Williams
                Greg Moeller
                Veteran Member
                Posts: 1498
                Veteran Member
                  If you have command line access....

                  $GENDIR/bin/bldxffiles -SC username job-dir PO215.prt

                  Will create a csv file from the PO215.prt run by username ... I think it will plop it into the job-dir along side the prt file.
                  Kat V
                  Veteran Member
                  Posts: 1020
                  Veteran Member
                    In Portal, when the job is finished and appears in Print Manager, there should be a create csv option when you view the report. In Smart Office, it's under tools not actions.