Import Excel - Unique Resource Ids

Hi!

I'm having the opposite problem, I'm trying to update the Remaining Units / Time on my already existing resources. I do an export, update and then import. But when I try to import it says that:

Error: Cannot assign the same resource: RSRC XXXX ... more than once.

But I don't want to add a resource, I want to update the existing one. Any ideas on this one? Much appreciated!

-B

make sure that calaculate budget form units is not checked if it is run a global change to change ot from yes to no then import the excel file. 

OMG,

it's been 2 years and I cannot solve this issue, (i.e. when I try to update my resources it says I cannot "assign the same resource more than once"; but I'm not trying to add it twice, just update the existing one). I googled it and voila! I get back to my old question, haha.

Thanks for the idea Zoltan, but I have all "Calculate costs from units" unticked and still didn't work. I know the issue must be on the resource level since I don't get the error on ALL resources, just some, and so far it seems random.

Anyone else out there with this error?

-B

it will import the same resource twice go to the projects directory make sure that your project is highlighted 

go to the resources tab on the lower right under Resource Assignment make sure that Resources can be assigned to the same activity more than once IS CHECKED 

If you are importing from Excel, does the original excel export include the Resource Assignments option (TASKRSRC on generated excel sheet)?

To update resource units I include the Activities & Resource assignment options of the excel export options, with Original Duration and Budgeted Units included in the Resource Assignment options.

Update the Duration & Units in the TASKRSRC tab of the generated excel file against each resource for the activitiy - remember that the number for these values needs to be a text value & not a number format - by default numbers will be shown aligned to the right, whilst text will show on the left of the cell.

By updating the Resource Assignments in the excel file it should now allow you to import the new resources, although will still have issues if duplicate resources are assigned to the same activity, as only 1 will get updated unless there is a different cost account or role assigned as mentioned below.

If you were just showing the budgeted units against the activity (TASK) table & updating this value, then it will not import the updated values & will show an error message on import, as the budgeted units needs to be allocated to each resource.

Hope this helps,

Steven

please list the fields that you are exporting what columns ? I think you are missing a few that you need for impoting 

also in the PROJECTS directory under your project what are your settings under the calculations tab 

also make sure that you have the admin rights to update this 

Hi Steven, Zoltan,

I do have the TASKRSRC tab in the excel file. I am actually not updating the field in the excel file, just exporting to "save" the remaining units and then reimporting to set them back after I schedule and move my data date.

I have my resources in Level of Effort activities. For example, John Doe was budgeted to be in the project 100%, but now we know he will only be 90% for the remaining of the project:

Resource    Budgeted Units/Time     Remaining Units/Time

John Doe    100%                          90%

When I do my monthly updates, BEFORE f9'ing, I export the resources. When I f9, John Doe's remaining goes up to 91.48%, 87.17%, or something crazy like that because of the changes in the schedule. But it shouldn't matter, after I f9, I import my exported file and update back to 90%.

OK, this was working just fine, and then suddenly it stopped working, not it says that John Doe cannot be assigned twice.

To make it more strange John Doe gives me the mistake but Jane Doe updates just fine. Both resources are as far as I can see identical.

The columsn I'm exporting are:

Activity ID, (*) Activity Status, Resource ID, Role ID, Cost Account ID, Remaining Units time (%), (') Budgeted Units Time (%)

I don't update any of these columns. Should I add more columns?

In the Calculations tab I have selected "Substract Actual from At Completion" and "Link actual to date and actual this period units and costs"; everything else is unselected.

But since I get this error in some resources and not all, wouldn't this be a problem on the resource level?

-B

Steven that is correct.

mark look at the john doe resource see what is different on thsi on from all of the others

make sure that CALCULATE COST FROM RESOURCES IS NOT CHECKED.

Hi Steven,

you are correct, the duration type is set to "Fixed Duration & Units", this is due to company's procedure, that's why we created this little procedure (of export, update schedule, import) which should, in theory, work just fine and solve the issue... but now it's not working and we are looking into redefining the procedure but in the meantime all projects are set like this.

Zoltan, all resources have "calculate cost from resources" unchecked.

I have added ALL columns to check what's different on the resources and all I could find is that some have the option "Auto Compute Actuals" checked and some have not (on activity level this is set to be unchecked); however, those that have it cheked and not does not correlate with those that are updated and those that give the error.

I think I have ran put of options here :/

-B

Thx Zoltan,

I have checked this checkbox, and indeed it added the resources twice, but I don't want the resource to be added twice (therefore, I deleted the second instance), I only want the remaining units/time of the already existing resource to be updated from an excel file that I have previously exported. But this is what is giving me the error and would not let me update the resources that are already there.

I hope this makes sense, any other ideas? Thx!

-B

Thx Zoltan,

I have checked this checkbox, and indeed it added the resources twice, but I don't want the resource to be added twice (therefore, I deleted the second instance), I only want the remaining units/time of the already existing resource to be updated from an excel file that I have previously exported. But this is what is giving me the error and would not let me update the resources that are already there.

I hope this makes sense, any other ideas? Thx!

-B

if you are using A LOE you need to make sure that you assign a resource curve to the resource for each activity

They all have a linear curve.

-B

Thanks Steven,

this is what i ended up doing and it worked... thanks for the reply!

-B