Assign resources to the same activity more then once

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

To contribute my two cents,

Open the XER file in a text or notebook editor, then search for the "TASKRSRC" table. Copy all the data from this table into an Excel sheet. In Excel, modify the column for "role_id" and assign a sequential number to each row in that column. Once completed, copy the modified table back into the XER file, replacing the original "TASKRSRC" table. After importing the modified XER file, you will see all your resources properly assigned. By assigning unique values to each row, the system will create different assignments during the import.

Best regards,

JM

@Luca

Thanks, for this post back in 2009. I've successfully used this trick while updating changes to my baseline. Cheers!

Luca



Not if you’ll choose the option "Update existing" for resource assignments.



Regards

Dieter

Hi

is doing, there is a trick to avoid this



if you apply a different cost account for each of the resoruce assignment they will remain, otherwise when import back the XER you will have only one



Hope this help



Luca

Valerii



In the user-manual (PMRefMan.pdf) there is Chapter 6 for Export/Import of data. Your item is in the part "Importing Projects" --> "Import Project Options" --> check for the resource assignments and choose the same option as mentioned there.



Good luck!

Dieter