Importing excel into p6 Using activities with multiple resources

Member for

16 years 3 months

not sure what you mean by resource type but if you are saying that you have two DIFFERENT resource names with the same type or resource such as LABOR I do not see how this is possible.

However if you are saying that you have 2 of the SAME resource names with the same type of resource such as labor then go to Projects directory 

make sure that your project is highlighted

click on Resources and at the bottom right make under Resource Assignments sure that Resources can be assigned to the same activity more than once is NOT checked.

Member for

21 years 4 months

Zolton

Many thanks for your response, having gone through your check list it appears to have worked!

I can now import multiple resources against individual back in from excel now as long as the resource types are different.

The only issue now is it still doesnt work if the resource type is the same.

 

However, your solution has provided me with a possible alternative way, so many thanks Zoltan.

Member for

16 years 3 months

make sure that you have the rights to import resources

make sure that the duration is not zero

make sure that calcualte costs from units is NOT checked

when importing ONLY import resorce ASSIGNMNETS becasue the resource is already there 

Member for

13 years 2 months

Sometimes I have also faced this trouble especially with new assignments. So I used to ensure all of the resources are assigned to all activities and keep budget labour unit as zero. 

Later we can update the budgeted labor units based on the weight factor and this we can import. Sometime this will also not work properly; then just re-import the same few times.

The activities with zero budgeted labor can be removed at later stage.