Has your question already been answered?

Get a quicker response; before you post, why not search to see if it has already been answered

P6 Activities with Steps Name / Status Export

2 replies [Last post]
sam dsoza
User offline. Last seen 3 days 20 hours ago. Offline
Joined: 20 Jun 2006
Posts: 40
Groups: None

Hi 

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.

TIA

Replies

sam dsoza
User offline. Last seen 3 days 20 hours ago. Offline
Joined: 20 Jun 2006
Posts: 40
Groups: None

Alexandre,

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.

Thanks

Sam

Alexandre Faulx-B...
User offline. Last seen 2 days 3 hours ago. Offline
Joined: 20 Jan 2003
Posts: 1208

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

Alexandre