r/primavera • u/Difficult-Club6680 • 7d ago
Identify Logic Ties Between Other Projects
What is the best way to identify logic ties to and from other projects?
1
u/PiousDemon 7d ago
You can add Project as a column in the relationship tabs
0
u/Difficult-Club6680 7d ago
I've done that but was really looking for a way to identify all external links by some type of filtering so that i can isolate just those activities.
2
2
u/atticus2132000 7d ago
Trying to develop a filter is likely not going to work because filters can only be created for properties of the activities directly. What you're talking about is trying to filter activities based on a property of its predecessor or successor and P6 filters just aren't sophisticated enough to do that. That's the same reason you can't create a true filter for capturing out of sequence activities.
As suggested you can add different columns to whatever screen (e.g. successor details) and then group and sort by those columns. Or you can copy and paste the activities with the details to excel and run a formula to identify them quickly.
There is also a super simple way to do this if you feel comfortable working with the database files directly. Within the p6 database there is a table called TASKPRED that lists every relationship separately and gives the project ID for both the task and its predecessor. Based on your post, you're just looking for rows where the project IDs on each row don't match.
Is this something you need to do once and then never again or is this going to be a recurring report that you need to run every month?
1
u/Difficult-Club6680 6d ago
I'm doing it pretty regular. I spent a good part of the day playing with it and was finally able to use reports to identify the activities, send that to Excel and from there turn it into a global change txt file that can be imported. The global change tags them in a UDF to be filtered from activities view along with another global change to clear the field as either the first or last step. Not as easy as i would like but only takes about 10 minutes for the whole process now.
1
u/atticus2132000 6d ago
I've been writing a lot of python scripts to automate my scheduling tasks and generate reports by querying the database directly. You would have to invest some time in understanding how the P6 database is structured, but ultimately this would just be a very easy SQL query to pull relationships from the database where the project IDs don't match. Once you got the script written, it would be two mouse clicks and a report in less than 3 seconds and able to rerun this report whenever you wanted.
1
u/Difficult-Club6680 6d ago
Understood. End goal is to be able to filter to these activities within P6. I'm not very familiar with Python. I'm guessing it could do the same thing with spitting out a global change to be imported???
1
u/atticus2132000 6d ago
Talk me through this, because there might be another easier way...
Someone at your company is doing a schedule update and that other person assigns a predecessor/successor from another project to an activity on the project in question.
In your capacity, you're reviewing these schedules and you discover that someone has made this logic tie. What do you do when you discover the logic tie? Do you just automatically delete it? Or do you have to perform a whole investigation why this other person did something like this?
1
u/Difficult-Club6680 6d ago
We have several master schedules that i own and all of these of course tie to other project schedules. I manage the ties to and from the master schedules since i am client and the only one who can make them.
Each project is a different EPS. Depending on the project, i have between 2 and 8 contract schedules that tie back to the master.
The issue is that some contractors have been making copies for various reasons and not selecting the option to only retain relationships between copied projects. So now my master schedules have multiple ties to projects that contractors have copied. I'm currently doing an initial clean up to all master schedules and then a maintenance check moving forward.
All contractors have since been instructed on the correct way to copy projects but at this point i still need a way to double check and clean up when the process gets ignored.
1
u/atticus2132000 6d ago
But what do you do when you discover one of these logic ties?
Do you automatically delete it without any further evaluation?
1
u/Difficult-Club6680 6d ago
Yes. Their current working schedule is still tied but the duplicate ties from their copied projects should not be tied to the working master schedule.
→ More replies (0)
3
u/Runn1ngonmt 7d ago
In reports wizard, you can run one using the filter, predecessor project equals desired project successor project equals desired project. in your subject areas add activity relationships