Skip to content
ProjectControls.com
Oracle Primavera - PM6

Resource assignment Importing

In the Open Standard
Shaun ChewMember for 10 years 10 months
Created
5
2
0

Hello everyone,

i have an issue when importing resource assignments, if i export an excel file with activities and resource assignment data and adjust the budgeted labour units  ln the TASKRSRC tab and then import the excel file the units in p6 will be modified and it works fine. alternatively if i create my own excel file, (not modifying one that has been exported) instead of it modifying the budgeted units it creates an additional resource assignment to the activity and the existing assignment remains the same.

would appreciate any help on this, thanks

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    David Kelly ·
    #1

    Are you importing the Cost

    Are you importing the Cost Account in your excel sheet? It is part of the index for the resource assignment table.

    Report
  2. 0
    Zoltan Palffy ·
    #2

    to fix this go to Projects

    to fix this go to Projects Directory on left make sure that your project is open and make sure that it is highlighted

    Click on the Resources tab at the bottom and on the right on the bottom under Resource Assignments make sure that 

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

    Report
  3. 0
    Shaun Chew ·
    #3

    Hi David,Yes i am importing

    Hi David,

    Yes i am importing the 'Cost Account ID' Column, this column seems to be a mandatory column when exporting. however i am leaving this field blank.

    would this make a difference in my issue? thanks

    Report
  4. 0
    David Kelly ·
    #4

    Shaun,I always, only, import

    Shaun,

    I always, only, import date from Excel into P6 using the template I have exported. If you build a spreadsheet by hand, if it is not spelt perfectly, you could get the error you describe. I think that the import is not successfully identifying the Cost Control field, so creates a dupli cat rather than uodates the existing.

    Report
  5. 0
    Zoltan Palffy ·
    #5

    yep best bet is to do one

    yep best bet is to do one activity and export it and use this as a templte to import it. The only thing is you must know what fields that you need to export

    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?