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.

Help with External links

8 replies [Last post]
Thomas Nicholson
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 4 Oct 2006
Posts: 87
Groups: None

Afternoon all, 

I have inherited a project which has links to multiple external projects within the same database.  Given that on the relationship tab of the activity details I can see the project ID the link comes from but i can't find a report that will tell me this in bulk and i've tried exporting to excel but then it claims there are no external links at all.

is there a report I can run or some way of showing me all my links and what projects they've come from rather than going through each activity one by one?

 

Cheers all, 

 

Thom

Replies

Santosh Bhat
User offline. Last seen 51 weeks 2 days ago. Offline
Joined: 15 Apr 2005
Posts: 381

If you need to list external relationships, read this article, it inlcudes a report that can be uploaded to your P6 database

 

Listing P6 Inter-Project Relationships | Australasian Project Planning (austprojplan.com.au)

shirin khazei
User offline. Last seen 2 years 36 weeks ago. Offline
Joined: 16 Aug 2019
Posts: 2
Groups: None

Hi, I have one xer file needs to be imported to the existing one in Primavera . The WBS for both of them is the same things but my customer sends met he xer file under a new Project ID every time . This does not allow me to use existing file . I have to import xer to the current one as  I have linked it to some other external projects. I was wondering if there is a soultion for my probelm -Thanks 

Zoltan Palffy
User offline. Last seen 4 days 31 min ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

thats why I gave you 3 options

thats becasue there is not one in global tools but you can make your own activity code then use a global change to populate the code

then you can filter for the code only 

Steven Auld
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Sep 2017
Posts: 126

Thanks Zoltan.

Didn't think about the reports - looked in the Global Change to look to set a flag, but couldn't find it there.

Thom,

Zoltan's option would be easier than the one I suggested.

Regards,

Steven

Zoltan Palffy
User offline. Last seen 4 days 31 min ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

you have 3 options listed from hardest to easiest 

option #1

1. create an activity code call it linked and set the values up to all of the projects that are linked to this project you can is the project is as the value code.

2. add a column for the code called linked

3. run this filter

filter any

where

external early start is not eqaul to (then leave the value blank)

or

where external early finish is not eqaul to (then leave the value blank)

now you have the list of activities that are linked

in the predecessor and or successor window right click and select customize (either the predecessor and or succssor window)

and from the left expand the General category and select Project ID

now go thru each activity that you filtered and in the predecessor window or the successor window look at the Project ID and see which one does not match your project id.

now in the linked column select the same project id as in the predecessor and or successor window

option #2 run a report 

create a new report on the right select Wizard then next

on the left and right hand side in the Subject Ares both should only have Activity Relationships (select Next)

in the Configure Selected Subject Areas it should only be Activity Relationships 

click on Columns and select 

predecessor project

Activity id (Predecessor ID)

Activity Name (Predecessor Name)

Successor Project

Activity ID (Successor ID)

Activity Name (successor Name)

Relationship Type

Critical

Driving

Lag

select Apply

select next

name the report

then run the report

option #3

I can send you the report and you can import the already made report into your report area. 

 

 

Steven Auld
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Sep 2017
Posts: 126

Thom,

Just had a look at v 16.2 & it only shows the relationship type as the additional details compared to your version, which wouldn't help anyway.

I have a couple of projects that have links between them & the only way I have been able to find them in P6 was to open the relevant projects & look for relationship lines between the projects (group by project).

I have had a look in the Global Changes & it does not list an option to see the Relationship Project ID.

Without being able to export the file as an XER, I am struggling to find out how to identify the links to projects within the same database. External Projects that are not in the database show up as an External Early Start or External Early Finish in P6, but if the link is to a project within the same database then this does not show up.

The only way I can think of at present is to open up your project & show the Predecessor column in the table.

Make sure that there are no filters applied to your project then select all & copy & paste into an excel sheet.

In Excel, use the Text to Columns tool in the Data Tab to split all the Predecessors out into separate columns - use the comma as the separator. Depending on the number of relationships for each activity will now give you all the columns.

Insert a column just after the Activity ID column & in this column use the =TRIM(A2) function, where A2 is the first Activity ID in your list. Fill this down for all the activities then select this column & copy & paste as values. - I have used Column B in the formula below for this new column.

For the first column of Predecessors, Insert a column to the Right & enter the formula =IF(C2<>"",COUNTIF($B$2:$B$300,TRIM(C2)),"") - where the Activity ID column you have just created is in column B - I have used the Rows 2 to 300 as an example, so change this based on the number of rows you have in the excel file. C2 is the first Predecessor Column & Row that you want to check for - This will depend on what columns you had showing when you copied from P6. Copy this formula down for all activitiy rows.

Repeat this for each column of Predecessors that was generated by the Text to Column, changing the cell referenced by C2 above to the correct column you are checking against. You should just be able to copy the entire column then Insert the Copied Column just after the next Predecessor Column.

In these calculated columns, any Activity ID that is not in the list will be shown as a 0, if the activity id is in the list then it will show as a 1. If there is no Predecessor in the column for a selected activity, then it will show as a blank cell to enable you to see only the ones that are relevant.

For each of the Predecessor Columns, Filter for Values of 0, these should be the activities that are not in your current plan & can be checked in Primavera.

Repeat the above using the Successor column.

This should work, unless there are activities in the other Project with the same Activity ID.

A bit of a chew for something that should be straight forward, but should give you what you are looking for.

Hope this helps.

Regards,

Steven

Thomas Nicholson
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 4 Oct 2006
Posts: 87
Groups: None

Hi Steven, 

Thanks for the offer unfortunately it has sensitive information included so it's a secure system and we can't import or export from it.

We're still using 8.2 believe it or not.  

Thanks again for the kind offer.

 

Thom

Steven Auld
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Sep 2017
Posts: 126

Thom, If it is something that you would be able to send me as an XER file, then I should be able to run a report pretty quickly.

I have a custom application that should be able to give you an excel report showing the projects & activity ID’s for the external relations.

Some of the newer versions of Primavera have the ability to show additional relationship information, but not sure what version you are running.

Regards,

Steven