missing data while exporting-importing

Dear all,

During either the export or import process from P6 in xer file, a substantial amount of the resources data (MHRS) is lost.That happens even when I reimport the file to my database.

When I copy – paste the schedule everything is ok. I assume that the problem is in the import since the export in excel is successful.

Any ideas?

regards

W
william chee 👤 Member for 12 years 5 months

try this, go to edit>user preferences>resource analysis and SELECT "Preserve the unit, duration and unit/time for existing assigments" and try to reimport the datas again.

R
Rachel Dorota 👤 Member for 12 years 6 months

Oliver,

in that project I have not assigned the same resource more than once in the same activity (no shifts) and I checked also the box in the bottom right and it is ticked "Resources can be assigned to the same activity more than once''.

regards

R
Rafael Davila 👤 Member for 22 years 3 months

But how you solve the issue when you need to use the same resource on the same activity but on different shifts.

Say 10 carpenters from Monday to Friday while 20 carpenters on Saturdays because on Saturdays they will be available to work on the activity while during the regular week they will work on other activities? Of course there are many other reasons you might have to recur to multiple assignments. It might be than on same shift some of the same resource work full time while others work half time on the activity and the rest of the day on other activities. This type of assignments happen every day. 

O
Oliver Melling 👤 Member for 19 years 1 month

If you have a resource assigned to the same activity multiple times, when you import the XER it only recognises the first assignment and therfore missess any others. Consequently the manhours when imported will be less.

Several companies i have done work for only allow planners to assign a resource once to an activity for this very reason. On the resources tab when in the Project screen, there is a tick box in the bottom right to toggle the ability to assign multiple resources.

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts