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.

Resource importing and exporting from P6 to Spreadsheet

6 replies [Last post]
vivek t
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 15 Jan 2015
Posts: 5

Hi,

Is there any way I can export the assigned resources to activities from Primavera Programme to excel and then import the same resources on a modified programme with similar set of activities and quantities rather then assigning each resource individually to all the activities again. Please help.

Replies

Raymund de Laza
User offline. Last seen 31 weeks 6 days ago. Offline
Joined: 23 Nov 2009
Posts: 762

Yes.

Project A:

Activity X = Description Abc

Activty Y = Description 123

Activity Z = Description xyz

 

Project B:

Activty 1 =Description Abc = Activity X

Activty 2= Description 123 = Activty Y

Activity 3= Description xyz = Activity Z

 

Do the workaround in excel to create it.

vivek t
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 15 Jan 2015
Posts: 5

Thank you all. Thats helpful. Could you guys help me with some more things. The Activity IDs in the old program does not match with the Activity IDs in the updated programme. Rather then changing each activity ID, do I have any option of doing all the activity ID changes in one step?

vivek t
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 15 Jan 2015
Posts: 5

Thank you all. Thats helpful. Could you guys help me with some more things. The Activity IDs in the old program does not match with the Activity IDs in the updated programme. Rather than changing each activity ID, do I have any option of doing all the activity ID changes in one step?

Raymund de Laza
User offline. Last seen 31 weeks 6 days ago. Offline
Joined: 23 Nov 2009
Posts: 762

Yes.

Project A:

Activity X = Resource abc

Activty Y = Resource 123

Activity Z = Resource xyz

 

Project B: Modified

Activty X =Resource abc

Activty Y= Resource 123

Activity Z= Resource xyz

Do the workaround in excel to create it.

Kannan CP
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Vivek,

1.Make a copy of the existing programme in the same system and do the required modifications in activites and WBS.

2. If you want to have separate resource identification for the new project, follow the below mentioned steps (i hope it will work)

a. Export the existing file and import it(during import, put "insert new" for the resources in the modification area)

b. It will create a new set of resources similar to the existing project, and add some project ids for each resource.

 

Regards

Kannan

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

yes you can do this 

1. first you have ot make sure that the same activity numebrs exist in P6 in the schedule that you want to import into.

2. you will need to change the WBS name from the exported file to match the name of WBS for the new wbs to import into.

3. The same resource must exist in the resource dictionary. If it is on the same machine then not an issue.