I created a WBS in P6 (8.3 VERSION) exported to a spread sheet as activities settings. then copied the list of activities from another excel file to this spread sheet and specify the WBS name and WBS code for each acvtivity.
While importing it back to P6, i could see all the activities, but not arranged under any specific WBS as above (but only under main Project WBS)
Is there any option to import the WBS also for the activities.
Also, is there any option to change the relationship between activities quickly, for eg: from activity A, there are 50 activities as successor with FS relation. How the relationship can be changed to SS+5 in a easy way.
Regards
Kannan
Kannan,
>there any option to change the relationship between activities quickly, for eg: from activity A, there are 50 activities as successor with FS relation. How the relationship can be changed to SS+5 in a easy way.
You can do this trick:
a) Change activity A to a milestone, and keep existing logic.
b) Add activity B with the original duration of activity A. Add B (SS+5) -> A dependency.
Don't forget to add another successor to 'B' as it will have an Open End - no activity depending on the completion of activity B.
Thanks a lot Santhosh..
In the XLS Worksheet that you export relationships too, you'll see there is a column titled "Delete"
If you type in "Delete" into a cell in that column, then that entire row's relationships will be deleted upon import. So if you have an existing FS relationship, you first need to delete that row, then create a new row to create the new relationship you want.
Thanks Santhosh,
While importing back the new activity relationship, both the existing and new relationships are noticed in P6.
Is any settings only to replace and not to duplicate.
Regards
Kannan
Thanks Santhosh,
While importing back the new activity relationship, both the existing and new relationships are noticed in P6.
Is any settings only to replace and not to duplicate.
Regards
Kannan
Thanks Santhosh,
for activity relationship, i changed FS to SS+LAG in the spreadsheet. While importing to P6, both the relationships are noticed- existing FS and new SS+LAG.
Any settings to replace it rather than duplicating.
Regards
Kannan
Thanks Santhosh,
for activity relationship, i changed FS to SS+LAG in the spreadsheet. While importing to P6, both the relationships are noticed- existing FS and new SS+LAG.
Any settings to replace it rather than duplicating.
Regards
Kannan
Thanks Santhosh,
for activity relationship, i changed FS to SS+LAG in the spreadsheet. While importing to P6, both the relationships are noticed- existing FS and new SS+LAG.
Any settings to replace it rather than duplicating.
Regards
Kannan
Thanks Santhosh,
for activity relationship, i changed FS to SS+LAG in the spreadsheet. While importing to P6, both the relationships are noticed- existing FS and new SS+LAG.
Any settings to replace it rather than duplicating.
Regards
Kannan
Kannan,
Check that the correct WBS has been included- remeber the project ID is the root of the WBS so if you're copying the WBS name from another project, it cannot have the same ID.
You can export/import relationshps by selecting the "Activity Reltionships" option when exporting to XLSX from P6. This will be a seperate tab to actvities as the data exists in a different data table in the P6 database.