Export PO15 data?

 8 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
lakilester
New Member Send Private Message
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 Send Private Message
Posts: 28
Advanced Member
You can use the add-ins to download them into an Excel file
JonA
Veteran Member Send Private Message
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 Send Private Message
Posts: 1127
Veteran Member
You could also do a dbdump of the table. Lot's of options.
David Williams
Kat V
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.