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.

FS vs SS

4 replies [Last post]
Wed, 2020-10-21 23:50
irfan morkoc
User offline. Last seen 3 years 25 weeks ago. Offline
Joined: 8 Mar 2013
Posts: 10
Groups: None

Hi,

I need to change my relationship from FS to SS. When I try to do this via excel P6 keeps the FS relation. How can I remove the FS relations when I import the excel file. I want only SS relations.

Many thanks for your support.

Top

Replies

Thu, 2020-10-22 13:37
#1
Zoltan Palffy
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

glad it worked for you

Top
Thu, 2020-10-22 13:38
#2
Zoltan Palffy
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

glad it worked for you

Top
Thu, 2020-10-22 10:51
#3
irfan morkoc
User offline. Last seen 3 years 25 weeks ago. Offline
Joined: 8 Mar 2013
Posts: 10
Groups: None

Bian, Thank you very much. It works.

Top
Thu, 2020-10-22 07:50
#4
Bian Mutang Tagal
User offline. Last seen 1 year 29 weeks ago. Offline
Joined: 12 Jun 2014
Posts: 28
Groups: Building Information Modelling, GPC Malaysia, Sarawak Primavera User Group (SPUG)

Hi Irfan,

Remember up to four types of relationships can be added between two activities, and an Excel import in P6 is always to update the project file. So we have to follow the steps below:

  1. Export out the .XLS file from P6 with the activity relationship tab.
  2. In the activity relationship tab, filter only activities that you want to change FS to FF. Delete the other activity rows.
  3. Copy all the relevant activity rows and paste below.
  4. Go back the first set of relevant activity rows and in the delete tab type "d".
  5. Go back to copied set of relevant activity and change activity relationships from FS to SS.
  6. Save and close .XLS file.
  7. Import into P6 and F9 to verify and check relationship tab in Activity Details.

Please refer to the following video demo https://imgur.com/u0Pezy8

Top