Delete Activity Relationship

Try RA/ Excel Utilities. Easy like magic.

Regards,
Rodel

Is there any keyword for activity relationship to delete from Excel import option?.

Yes...just type D on the last column/ delete flag on all activity relationship you need to delete.

Cheers,
Rodel

I have introduced another column (DELETE) in Excel(before that i exported the successor relationship from Tools->ProjectUtility) next to the REL column, then typed D under the DELETE column but nothing happens in the P3 when i import that file. Could you please help me further?.

Sorry Dayanidhi,

I’m thinking of P3e on Export where "D" is the delete flag. You should be using "S" instead of "D" in P3.1 to delete activity relationship.

Below are the step to make the things clear.


To delete data in Lotus 1-2-3 or dBASE

Follow these steps to delete the activity ID, resource name or designator, cost account, or relationship type from a spreadsheet or dBASE file; delete or modify all other types of data directly.

1) Export the data to be deleted from P3.
2) Create a new column in Lotus 1-2-3 or add a new field in dBASE. The column or field width must be at least one character. The specific location in the file is unimportant.
3) Name the range Delete using the Range Name command in Lotus 1-2-3, or name the field Delete in dBASE.
The field must be designated as a text range name in Lotus 1-2-3 and as a character field in dBASE.
4) Specify the one-character code in the newly added column or field to delete specific activity data. Leave the cell or field blank for any activities that are unchanged or that contain new or updated data.

A - deletes all data for that activity ID.
R - deletes resources for that activity ID.
L - deletes log records for that activity ID.
S - deletes the relationship for that activity ID.

5) Add any new data to replace the deleted data items. To add or delete relationship types, the activity ID, successor, and relationship type must also exist in the file. Change the relationship lag only if a lag value not equal to zero already exists.

Note: If you are using DBF extension make sure to include into the range name "Database" the column that you added otherwise you will lose your data when save back to DBF extension.

Hope this help. Please let me know the result so I can help you further.

Regards,
Rodel

Dear Rodel,

Thanks a lot for your extensive help and it works very well. I struggled a lot before due to unable to recall the reserve letter/word "S". and thanks for your additional information on "A","R" and "L".

Cheers!!!

Daya

No worries mate, that what PP are for!

I don’t know if this works in other versions but in in Primavera version 5.0 you just select all the activities where you want to remove the relationships, you copy them and paste them in the same project. When you click paste the screen appears with what you want to paste, so you deselect relationships and click ok.
Then you get a copy of all your activities but without the relationships. Now you can delete the original activities that still have relationships.

Good luck.

Export it into primavera P5 you can revomed it easily. then i suggest to leave p3 it will become obsolete soon