Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to remove pred & succ relationships with IMPORT ?

6 replies [Last post]
Fri, 2006-10-06 05:05
Nicolas Berger
User offline. Last seen 12 years 12 weeks ago. Offline
Joined: 12 Jun 2006
Posts: 46
Groups: Petro-Chem / Oil & Gas
Hi guys, I made an EXPORT to EXCEL and made all changes into EXCEL for a result of removing around 200 redundant relationships which created loops... Actually it seems that the deletion of relationships are not taken into account. Thanks by advance
Top

Replies

Mon, 2006-10-09 01:48
#1
Nicolas Berger
User offline. Last seen 12 years 12 weeks ago. Offline
Joined: 12 Jun 2006
Posts: 46
Groups: Petro-Chem / Oil & Gas
Yes thanks it works well ;-)
Top
Sun, 2006-10-08 18:47
#2
Jaime Linchangco
User offline. Last seen 15 years 49 weeks ago. Offline
Joined: 16 Jul 2001
Posts: 29
Groups: None
Hi Nicolas,

My reply is incomplete.

Step 5, save the file and then import it to your schedule.

That’s it. Done.

Jaime

Top
Sun, 2006-10-08 18:45
#3
Jaime Linchangco
User offline. Last seen 15 years 49 weeks ago. Offline
Joined: 16 Jul 2001
Posts: 29
Groups: None
Hi Nicolas,

Good day! Yes, there’s an easy and effective way of deleting those unwanted relationship.

Follow these steps to delete specific relationship right inside your Excel (dbf or Lotus 123).

1). Export the successors relationship
2). Create a new column "in-between" the data columns.
3). Name the new column at Row 1 as DELETE
4). Type letter S at this new column to all those Activity
that’s causing your loop or those "unwanted" links.

If you want further details about this very useful steps, go to Help menu, and search "Delete data in Lotus 1-2-3 or dBASE.

Cheers Mate!

Jaime
Top
Sun, 2006-10-08 04:56
#4
Christian Adrian ...
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
If the suggested steps doesn’t seem to give you the result you expected then doing the conventional way would be the best way... that is to run and print a report of looping activities and then modify it one by one...

Cheers...
Top
Sat, 2006-10-07 02:51
#5
Nicolas Berger
User offline. Last seen 12 years 12 weeks ago. Offline
Joined: 12 Jun 2006
Posts: 46
Groups: Petro-Chem / Oil & Gas
Understand, but there is no command in Global change for deletion of relationships...
Top
Fri, 2006-10-06 23:17
#6
Gün Göksu
User offline. Last seen 2 years 33 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
they are not taken into account.

quickest way to do this is this:

0. BACKUP!
1. export all of the relationships.
2. edit the relationships file as you like.
3. delete all relationships with global change.
4. import the relationships.


Top