Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

ahhhh help needed urgently!! links between projects!

3 replies [Last post]
John Sims
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 2 Jun 2011
Posts: 49
Groups: None

I am a planner for the engineering department of a utlity company, i have been working on putting in dependancy links between my engineering plan and another plan which is used for all construction works.

The planner on the construction works has made a copy of his construction plan and now made that the live plan, the construction programme where all my links are going to has now been made inactive, this now making all my links fail.

Is there is quick fix for this, can i somehow swap project id numbers so my links go on to the new construction live plan?

Your help is much needed...thanks in advance!

 

John

 

 

Replies

John Sims
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 2 Jun 2011
Posts: 49
Groups: None

Thanks to you both for replying, in the end i went about this the long hard way and put in new links....

I'm not that confident with exporting data yet and being these projects are very important i didnt want to mess either of them up.

I will take your replys for future use and practice on some dummy projects to build my confidence.

 

Thanks again!

 

John

Anning Sofi
User offline. Last seen 3 years 18 weeks ago. Offline
Joined: 22 Jan 2012
Posts: 89
Groups: None

Another method would be to open your Engineering programme. Create an excel export file "Activity Relationships",

ensuring that you have this fields:

Predecessor

Successor

Relationship Type

Predecessor Project

Successor Project

Predecessor Activity Status

Successor Activity Status

Predecessor Activity Name

Successor Activity Name

Lag

 

When you have created the export file, using excel's Find and Replace, change the old construction plan Project name to the name of the New Construction Plan project name in the fields "Predecessor Project, Successor Project" wherever applicable. Make blank the Predecessor Activity Status, Successor Activity Status by just deleting the values therein, so that no change in the status will be made during the import process.

Import back the revised excel Activity Relationship file to the your engineering plan programme.

Sandy Matheson
User offline. Last seen 8 years 15 weeks ago. Offline
Joined: 22 Sep 2004
Posts: 57

This should work although a bit convoluted.

I assume the activity ID in both construction projects is identical?

In your old construction project change all the activity IDs with a common prefix or suffix (replace all)

Then open all 3 projects together and merge them under one overall WBS, i.e all in the same project (maintaining the links between your engineering and old construction projects). 

Then export to excel the relationships between the engineering and old construction project.

In excel change the construction activity IDs in successor column to remove the common prefix, i.e. the ID now matches the new construction project ID.

Now import the relationships into the combined project.   You can then split the projects again through the WBS view.

Note you cannot export links betwen separate projects.

Give it a try