Import of Activities/WBS

Member for

14 years 2 months

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.

Member for

17 years 4 months

Thanks a lot Santhosh..

Member for

20 years 6 months

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.

Member for

17 years 4 months

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

Member for

17 years 4 months

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

Member for

17 years 4 months

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

Member for

17 years 4 months

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

Member for

17 years 4 months

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

Member for

17 years 4 months

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

Member for

20 years 6 months

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.