deleting selected relationships
In the Open Standard
Gün GöksuMember for 21 years 6 months
- Created
- 2
- 1
0
Hello, :)
I have a big amount of activities that each have a certain amount of relationships.
basically I would like to delete a whole set of relationships.
How do I do it?
any way of exporting all of the successor relationships to dbf and creating a new column with DELETE and choseing which to delete? but I want to leave the rest of the relationships as is. (there is a lot of it).
for example export of P3SUC.DBF:
ACT SUC LAG REL
L0001.CS05 L0001.CS06 0 FS
L0001.CS05 L0001.CS16 0 FS
L0002.CS05 L0002.CS06 0 FS
L0002.CS05 L0002.CS16 0 FS
L0003.CS05 L0003.CS06 0 FS
L0003.CS05 L0003.CS16 0 FS
L0004.CS05 L0004.CS06 0 FS
L0004.CS05 L0004.CS16 0 FS
becoming:
ACT SUC LAG REL DELETE
L0001.CS05 L0001.CS06 0 FS D
L0001.CS05 L0001.CS16 0 FS
L0002.CS05 L0002.CS06 0 FS D
L0002.CS05 L0002.CS16 0 FS
L0003.CS05 L0003.CS06 0 FS D
L0003.CS05 L0003.CS16 0 FS
L0004.CS05 L0004.CS06 0 FS D
L0004.CS05 L0004.CS16 0 FS
import back and voila??
so basically I want to remove a set of relationships leaving the rest and the activities alone.
anyone can show me a way? c’ause I can add new relationships with import. but cant delete.
Thank you. :)
Gün. :)
I have a big amount of activities that each have a certain amount of relationships.
basically I would like to delete a whole set of relationships.
How do I do it?
any way of exporting all of the successor relationships to dbf and creating a new column with DELETE and choseing which to delete? but I want to leave the rest of the relationships as is. (there is a lot of it).
for example export of P3SUC.DBF:
ACT SUC LAG REL
L0001.CS05 L0001.CS06 0 FS
L0001.CS05 L0001.CS16 0 FS
L0002.CS05 L0002.CS06 0 FS
L0002.CS05 L0002.CS16 0 FS
L0003.CS05 L0003.CS06 0 FS
L0003.CS05 L0003.CS16 0 FS
L0004.CS05 L0004.CS06 0 FS
L0004.CS05 L0004.CS16 0 FS
becoming:
ACT SUC LAG REL DELETE
L0001.CS05 L0001.CS06 0 FS D
L0001.CS05 L0001.CS16 0 FS
L0002.CS05 L0002.CS06 0 FS D
L0002.CS05 L0002.CS16 0 FS
L0003.CS05 L0003.CS06 0 FS D
L0003.CS05 L0003.CS16 0 FS
L0004.CS05 L0004.CS06 0 FS D
L0004.CS05 L0004.CS16 0 FS
import back and voila??
so basically I want to remove a set of relationships leaving the rest and the activities alone.
anyone can show me a way? c’ause I can add new relationships with import. but cant delete.
Thank you. :)
Gün. :)
2 replies
Oldest first- 0Raja Izat Raja Ibrahim ·hi gun,
as my experience, using import /export as u know :
1. make new file (project abcd)....(with no activity)
2. export the genuine activity / relation to spreadsheet.
3. import activity into new file.
4 for the relation u can find the activity u want and mark it to include in and delete the rest ...(by using find from spreadsheet application)
Example : Find or Sort L0001 until L0004....(the rest u can delete.
5. then import the relation to ..(project abcd)
just like that...cheers - 0Gün Göksu ·ok. I understand.
But I will end up with a new set of project files at the end.
the schedule is already mature. there are plenty of resources and the budget is working and the file size is considerably large.
I would like to find a way to work on the actual project. I dont want to have to create a new set of schedule and transfer everything to it. moreover I will have to do it more than once.
maybe combining your answer to the info on a previous tread
http://www.planningplanet.com/forum/forum_post.asp?Cat=2&Top=12799
(dealing with deleting the ????REL.P3 file and replacing it)
but there must be some more straightforward and clean way to do this.
I am also trying to do the least by hand because it is very prone to errors.
thank you very much for reply though.
Gün. :)
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?