Skip to content

Importing XLS Causing Resource Assignment Duplication

Ryan JarreauMember for 8 years 8 months
Created
3
2
0

I'm exporting resource assignments from P6 to Excel, updating budgeted units, actual units, and at completion units, then importing and Excel sheet into P6. Once the import is complete, I noticed that the resource has been updated based on my import, and a second resorce has been added and given budgeted units based on units per time that do not match the updated resource. Can anyone give me some insite on what's happening here please? Thanks in advance. 

3 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    The software is onyl doing

    The software is onyl doing what you are telling it to do you are telling it to import the resource and is did it wil do it over and over and over agin if you tell it to. You can also tell it to NEVER assign the resouce to the same activity more than once.

    here is how

    go to the projects directory and make sure that your project is highlighted

    then select show on bottom then project details 

    now go to the Resources tab in the lower right under Resource Assignments

    make sure that Resources can be assigned to the same activity more than once is NOT checked. 

  2. 0
    David Kelly ·

    You should alwasy export and

    You should alwasy export and import the cost account along with the rest of the resource assignment information, even if you do not use it, as it is part of the index for the assigment.  If you don't you are likley to duplicate

  3. 0
    Zoltan Palffy ·

    not ture David I import and

    not ture David I import and export without cost account ALL the time. Just throw the switch off and you will never get duplicates.

    just because you have a cost code does NOT mean you cant duplicate the resource and the cost code.  

    You can have the cost code in there twice. But not if you throw the switch 

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?