Skip to content
ProjectControls.com
Oracle Primavera - PM6

Assign resources to the same activity more then once

In the Open Standard
Valerii ButurlakinMember for 17 years 4 months
Created
19
15
0
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.
Save Follow Follow forum Report
Reply New topic

19 replies

Oldest first
  1. 0
    Dieter Wambach ·
    #1
    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
    Report
  2. 0
    Luca Basile ·
    #2
    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

    Report
  3. 0
    Dieter Wambach ·
    #3
    Luca

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

    Regards
    Dieter
    Report
  4. 0
    Ben Fleury ·
    #4

    @LucaThanks, for this post

    @Luca

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

    Report
  5. 0
    Jose Manuel Martinez Mejia ·
    #5

    To contribute my two

    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

    Report
  6. 0
    Jose Manuel Martinez Mejia ·
    #6

    To contribute my two

    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

    Report
  7. 0
    Jose Manuel Martinez Mejia ·
    #7

    To contribute my two

    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

    Report
  8. 0
    Jose Manuel Martinez Mejia ·
    #8

    To contribute my two

    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

    Report
  9. 0
    Jose Manuel Martinez Mejia ·
    #9

    To contribute my two

    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

    Report
  10. 0
    Jose Manuel Martinez Mejia ·
    #10

    To contribute my two

    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

    Report
  11. 0
    Jose Manuel Martinez Mejia ·
    #11

    To contribute my two

    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

    Report
  12. 0
    Jose Manuel Martinez Mejia ·
    #12

    To contribute my two

    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

    Report
  13. 0
    Jose Manuel Martinez Mejia ·
    #13

    To contribute my two

    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

    Report
  14. 0
    Jose Manuel Martinez Mejia ·
    #14

    To contribute my two

    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

    Report
  15. 0
    Jose Manuel Martinez Mejia ·
    #15

    To contribute my two

    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

    Report
  16. 0
    Jose Manuel Martinez Mejia ·
    #16

    To contribute my two

    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

    Report
  17. 0
    Jose Manuel Martinez Mejia ·
    #17

    To contribute my two

    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

    Report
  18. 0
    Jose Manuel Martinez Mejia ·
    #18

    To contribute my two

    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

    Report
  19. 0
    Jose Manuel Martinez Mejia ·
    #19

    To contribute my two

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?