Import of Activities/WBS

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.

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

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

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 a lot Santhosh..

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.