P6 Activities with Steps Name / Status Export

S
sam dsoza 👤 Member for 19 years 11 months

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

S
sam dsoza 👤 Member for 19 years 11 months

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

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts