Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Creating bulk activities from excel import

No replies
Hamza BENOUFIR
User offline. Last seen 13 weeks 1 day ago. Offline
Joined: 22 Jan 2020
Posts: 12
Groups: None

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

Hamza BENOUFIR
User offline. Last seen 13 weeks 1 day ago. Offline
Joined: 22 Jan 2020
Posts: 12
Groups: None

Hello Rodel,

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

Rodel Marasigan
User offline. Last seen 2 days 12 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699

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.