Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Assign resources to the same activity more then once

4 replies [Last post]
Valerii Buturlakin
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 25 May 2009
Posts: 10
Hi!

I assigned one resource several times to the same activity. When I do export/import (xer-file) several assignments disappear and stay only one. Why? In resource assignments settings I marked that resource can be assigned to the same activity more then once.

Best regards,

Valerii.

Replies

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Jose Manuel Marti...
User offline. Last seen 6 weeks 18 hours ago. Offline
Joined: 28 May 2024
Posts: 1
Groups: None

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

Ben Fleury
User offline. Last seen 7 years 47 weeks ago. Offline
Joined: 19 May 2014
Posts: 5
Groups: None

@Luca

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

Dieter Wambach
User offline. Last seen 7 years 31 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Luca

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

Regards
Dieter
Luca Basile
User offline. Last seen 9 years 42 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
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

Dieter Wambach
User offline. Last seen 7 years 31 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
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