Creating bulk activities from excel import

Hello,



It's a bit a basic importing question.

I want to create a bulk duplicate activities in P6. The original activities contain two resources that I want to split for the sake of reporting and leveling. Will creating new lines in excel import suffice to add them in P6?

Example:



Current:

Act ID       -       Act Name                  -      Res IDs

A0001       -      Activity 1                    -      Res1, Res2



Target:

Act ID       -       Act Name                  -       Res IDs       -     Remark

A0001       -      Activity 1                    -      Res1

DUPA0001 -      Activity 1 - DUPLICATE  -      Res2           -     Created by excel import



You can suggest another ethod of doing this.



Thanks in advance

H
Hamza BENOUFIR 👤 Member for 6 years 4 months

Hello Rodel,



That is actually easier and simpler, and I haven't thought of it. Thank you!

R
Rodel Marasigan 👤 Member for 19 years 7 months

You can filter the activity you want to duplicate (with two resources) and simply copy and paste, then delete the resources in the resource assignment module. That's the quickest method.

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