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
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.
Member for
16 years 3 monthsyep 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
Member for
21 yearsShaun,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.
Member for
9 years 10 monthsHi 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
Member for
16 years 3 monthsto 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.
Member for
21 yearsAre 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.