Forum Sponsor:

Oracle Construction and Engineering (formerly Primavera) is transforming the world by helping organizations plan, build, and operate critical assets with on-premise and cloud-based project portfolio management solutions.  Learn more about Oracle Construction and Engineering...

We wish a warm welcome to the find people who are offering the ScheduleReader™ application. We hope to add more interesting news here shortly.

Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P6 Activities with Steps Name / Status Export

2 replies [Last post]
sam dsoza
User offline. Last seen 15 weeks 5 days ago. Offline
Joined: 20 Jun 2006
Posts: 55
Groups: None


I would like to export activities with steps including step names and status of steps in to excel spreadsheet. While Actiivty steps export provides infor about steps completed, in progress, etc. I am looking more on the lines of exporting activities with activity steps listed in separate rows in a spreadsheet. Can this be done in P6?

Secondly, I have relationships tha hover from one wbs to another - is there anyway to identify activities where relationshop move from one L2 WBS to another.



sam dsoza
User offline. Last seen 15 weeks 5 days ago. Offline
Joined: 20 Jun 2006
Posts: 55
Groups: None


Thanks for your comment.

It seems that "activity steps" export to excel feature was available in prior version. Not sure, if this feature was removed or its just that I cannot find it.

I am not sure if  I follow your recomendation correctly but I will give it a shot. Its worth trying.



Alexandre Faulx-B...
User offline. Last seen 5 hours 46 min ago. Offline
Joined: 20 Jan 2003
Posts: 1235

Hello Sam,

I do not find a way to answer your first question; exporting the 4 fields relating to steps only exports the number of steps in each category;

to identify activities having a relationshio with an activity being in a different WBS node, you could use a Global Change to concatenate the Successor / Predecessor ID with the WBS in a user defined text field, and insert this UDF in the activities table