Skip to content

How to remove pred & succ relationships with IMPORT ?

Nicolas BergerMember for 20 years 4 months
Created
6
3
0
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

6 replies

Oldest first
  1. 0
    Gün Göksu ·
    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.


  2. 0
    Nicolas Berger ·
    Understand, but there is no command in Global change for deletion of relationships...
  3. 0
    Christian Adrian De Vera ·
    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...
  4. 0
    Jaime Linchangco ·
    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
  5. 0
    Jaime Linchangco ·
    Hi Nicolas,

    My reply is incomplete.

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

    That’s it. Done.

    Jaime

  6. 0
    Nicolas Berger ·
    Yes thanks it works well ;-)

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?