Skip to content

Creating bulk activities from excel import

Hamza BENOUFIRMember for 6 years 8 months
Created
2
2
0

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

2 replies

Oldest first
  1. 0
    Hamza BENOUFIR ·

    Hello Rodel, That is

    Hello Rodel,

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

  2. 0
    Rodel Marasigan ·

    You can filter the activity

    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.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?