The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Bulk export of Work Plans

Highlighted
mcx
Occasional Advisor

Bulk export of Work Plans

Would like to know if anyone knows a way to export multiple, or all, work plans.  We can export one at a time from within workplan, but are looking for a way to expor them in batch mode.  Surprisingly I don't see a "Work Plan" report out of the box.  I am looking for  way to do this with little or no coding or development.  The data doesn't have to be pretty; a raw dump into a spreadsheet is fine.

 

We are running PPMC 8.0

 

Thanks,

 

Bob

 

 

 

1 REPLY
dirkf
Honored Contributor

Re: Bulk export of Work Plans

Hi Bob,

 

Don't see anything OOTB...

 

including root- and subtasks?

WithOUT, you can export pm_work_plans table according to data model guide.

WITH, you will have to create a query using in addition the pm_tasks-table.

Both contain the work_plan_id you can then order by.

 

No work, no fun - you'll to create at least that query... ;-)

 

Attached you'll find the data model guide for version 8.

Hope this helps.

 

Best regards,

dirk

 

- kudos always welcome -

//Add this to "OnDomLoad" event