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 for Global change in P6

8 replies [Last post]
Mon, 2008-08-04 08:29
Girish Batolar
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 17 Jun 2003
Posts: 6
Groups: Petro-Chem / Oil & Gas
Hi

I want to perform a global change in P6. I want to add a charectre in fornt of the Activity ID.

Could some one please suggest me the steps.

Thanks
Top

Replies

Wed, 2008-08-06 07:25
#1
David Forrest
User offline. Last seen 14 weeks 6 days ago. Offline
Joined: 27 Nov 2001
Posts: 104
Groups: Accreditation Editors, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Sarawak Primavera User Group (SPUG)
Did you try edit>replace!!
Top
Tue, 2008-08-05 09:38
#2
Girish Batolar
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 17 Jun 2003
Posts: 6
Groups: Petro-Chem / Oil & Gas
Thanks Guys

Appericiate all the help. Any way found out how to do it the easiest way in 2 minutes by using global change
SubString(Parameter,#,#) function





Top
Tue, 2008-08-05 07:00
#3
Dieter Wambach
User offline. Last seen 7 years 22 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Hi

Why don’t you simply try:
IF: Your condition / filter or leave blank if for all activities
Then: "Activity ID" = X (i.e. the character you want to add) & "Activity ID"

Dieter
Top
Tue, 2008-08-05 06:45
#4
Satya Narayana
User offline. Last seen 10 years 39 weeks ago. Offline
Joined: 29 Apr 2008
Posts: 47
Groups: Civil Engineering
Export along with the relationships, you will have 2 sets of activities when you import back, delete the first set by fitering/sorting.

Hope this works
Top
Tue, 2008-08-05 05:57
#5
Oliver Melling
User offline. Last seen 5 years 4 days ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
Export the project file into excel.

Copy the activity id column into ’column B’ in a new spreadsheet.

In ’column a’ put the prefix you want to put in front of your activity id.

In ’colum c’ type the formula =’column a’&’column b’

Drag this down so that it is done for every activity.

Copy ’column c’ and paste special values back into the exported project file.

Save it, then import back into primavera.
Top
Tue, 2008-08-05 05:51
#6
Girish Batolar
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 17 Jun 2003
Posts: 6
Groups: Petro-Chem / Oil & Gas
Hi Oliver

Thanks but this will not work as i have the logic already defined and by what you are telling me will only create new id in primavera.

I wanted to know the steps for adding a charecter in fornt of the activity ID using Global change.

Can any one give me the steps.

Thanks
Top
Tue, 2008-08-05 03:07
#7
Oliver Melling
User offline. Last seen 5 years 4 days ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
Exoprt the project into excel, change the activity id, then import back into primavera.
Top
Tue, 2008-08-05 03:04
#8
Ronald Romero
User offline. Last seen 1 year 6 weeks ago. Offline
Joined: 13 Nov 2006
Posts: 63
Groups: Civil Engineering
Hi Girish,

try to play around with the given Modify Activity ID’s example of P6. You can you this function to extract text from you Activity ID which are Substring, Rightstring and Leftstring.
Top