1. copy the project that has all of the cost codes
2. create a dummy activity in the project that has all of the cost codes and assign ALL of the cost codes to that dummy activity
3. delete all other activitiies
4. export that project with the 1 activity to an xer file
5. open the project that you want all of the cost codes in and import the xer file
6. during the import process select add to existing
7. in the next part of the import process select modify and check do not import for all items except the 1st section for activity and import the one activity project inot the other project
8. now delete the dummy activity in the opened project
P6 treats data ina databse not as files, so if you consider that the same Activity ID can exist in multiple projects, then there must be something in the database that create a unique value for each activity. In the case of P6 - projects, project ID's and the corresponding WBS ID are all stored in the same data table and by requiring each activity ID to have a corresponding WBS ID is how that uniqueness is obtained.
The easiest solution to your problem would be to use Excel's Search and Replace field to modify the WBS ID column in your import file such that the PROJECT ID/WBS ID matches the new project you are going to import into.
Member for
16 years 3 monthstry this1. copy the project
try this
1. copy the project that has all of the cost codes
2. create a dummy activity in the project that has all of the cost codes and assign ALL of the cost codes to that dummy activity
3. delete all other activitiies
4. export that project with the 1 activity to an xer file
5. open the project that you want all of the cost codes in and import the xer file
6. during the import process select add to existing
7. in the next part of the import process select modify and check do not import for all items except the 1st section for activity and import the one activity project inot the other project
8. now delete the dummy activity in the opened project
Member for
12 years 5 monthsThanks - both of you for both
Thanks - both of you for both answers.
Member for
16 years 3 monthsdepends on what version you
depends on what version you are using. If you have a 32 bit machine with p6 on it you can import the cost codes suing an excel spreadsheet.
or you can use sdk
Member for
20 years 6 monthsJohn, P6 treats data ina
John,
P6 treats data ina databse not as files, so if you consider that the same Activity ID can exist in multiple projects, then there must be something in the database that create a unique value for each activity. In the case of P6 - projects, project ID's and the corresponding WBS ID are all stored in the same data table and by requiring each activity ID to have a corresponding WBS ID is how that uniqueness is obtained.
The easiest solution to your problem would be to use Excel's Search and Replace field to modify the WBS ID column in your import file such that the PROJECT ID/WBS ID matches the new project you are going to import into.