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.

Activity ID

17 replies [Last post]
Tue, 2009-06-16 09:59
Carlos Arana
User offline. Last seen 5 years 34 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
Is there a way in Primavera P3 to change an Activity’s ID??
Top

Replies

Sun, 2010-01-24 03:59
#1
harzelli bouasria
User offline. Last seen 4 years 27 weeks ago. Offline
Joined: 15 Oct 2008
Posts: 42
Groups: Petro-Chem / Oil & Gas
hi Osama
i have already this problem, osama try to copy your activities and then paste them with external relationships but don’t forget to change ID (Auto-increment).
i hope this can help you

good luck
Top
Sun, 2010-01-24 01:07
#2
Osama Warid
User offline. Last seen 9 years 31 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
Greetings
Thanks for all replies
Rafael
This is the best to do it quickly but for sure there will be some information will be lost
Akhtar
This will change part of the ID, if you can to change completely it will be perfect,
The problem that I face is how to make the new ID take the sequence
Jvito
If we have 4000 activity * 5 sec to change each item this will take around 1 working day. This if I follow the mentioned method

Regards,
Top
Sat, 2010-01-23 08:15
#3
Jovito Amande
User offline. Last seen 6 years 45 weeks ago. Offline
Joined: 29 Dec 2009
Posts: 5
Groups: None


If you are running already your program, CLOSE it first, then Open Again but dont forget to check the EXCLUSIVE..

sure you can now edit or change your activity id as you like.
Top
Thu, 2010-01-21 07:11
#4
Akhtar Khan
User offline. Last seen 10 years 23 weeks ago. Offline
Joined: 3 Dec 2009
Posts: 9
Groups: None
Hi,
To change Act Id thru Global Change u should use Global change function Left(Act,XX) or Right(Act,XX) where XX is the no.of digits u want to retain.e.g ACT ID is 1234567890
use Global Change Formaula
ACT EQ ABC & Right(ACT,7)
The result will be ABC4567890.

Using this type of Global Change u can change ur Act Id is just few mins.

Top
Fri, 2010-01-15 23:54
#5
Shah. HB
User offline. Last seen 19 weeks 4 days ago. Offline
Joined: 25 Nov 2008
Posts: 773
Groups: GPC Malaysia, GPC Qatar, Planning, Claims & Contracting, TILOS
Hi
You can also do using global change

use F1 help mode and search for global change and scroll down where you will come across functions like Ltrim and Rtrim and many other .Check that it would helpful to you
Top
Fri, 2010-01-15 18:35
#6
Rafael Davila
User offline. Last seen 1 day 20 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Osama,

One option might be:

First backup your job, then try selecting all activities and follow with a Copy and Paste, the software will ask you for the rules to change ID’s. Then delete "old" activities.

Make sure all data copied correctly; don’t know what will happen with period actual and other data.

If you copy and paste separate groups you might lose the links between activities spanning separate groups so it is important you copy all at once unless willing to manually check on missing links.

In Spider Project I can change my activities ID’s by importing a CSV file that can be generated from almost any text editor, word processor, spreadsheet and database application, maybe someone else can provide you with a clue on how to do this in P3.

Good luck,
Rafael
Top
Fri, 2010-01-15 13:40
#7
Osama Warid
User offline. Last seen 9 years 31 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
Greetings
The mentioned method to change Act. ID one by one. Are there any method to change it all in one time?
regards
Top
Fri, 2010-01-15 05:42
#8
Shah. HB
User offline. Last seen 19 weeks 4 days ago. Offline
Joined: 25 Nov 2008
Posts: 773
Groups: GPC Malaysia, GPC Qatar, Planning, Claims & Contracting, TILOS
@ lot
you r welcome
Top
Fri, 2010-01-15 05:27
#9
lot villaflor
User offline. Last seen 14 years 13 weeks ago. Offline
Joined: 11 Jan 2010
Posts: 15
Groups: GPC Malaysia, Petro-Chem / Oil & Gas

Hi Shahul

Thanks for sharing info.
Top
Fri, 2010-01-15 04:16
#10
Shah. HB
User offline. Last seen 19 weeks 4 days ago. Offline
Joined: 25 Nov 2008
Posts: 773
Groups: GPC Malaysia, GPC Qatar, Planning, Claims & Contracting, TILOS
Hi lot

In general each organisation have their own style of naming activity ID’s. I trust there in no particular codes in general for all.Basically naming Ids depends on individual idea for easy identification of respective activities
Top
Fri, 2010-01-15 03:33
#11
lot villaflor
User offline. Last seen 14 years 13 weeks ago. Offline
Joined: 11 Jan 2010
Posts: 15
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Is there’s a " planners code" or "planners guide" in naming/placing activity ID?

Best Regards.

lot
Top
Fri, 2009-06-26 12:19
#12
Rafael Davila
User offline. Last seen 1 day 20 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
You can Change Activity ID within a project without Exclusive Access, this is another option.

Please follow the link.

http://www.htcprojectcontrols.com/TTB2003-1.pdf

Perhaps Carlos had a wrong value for ExclForActIDEdit line, default should be 1.

To change WBS titles go to Data>WBS and change titles at will.

Best Regards,
Rafael

Top
Mon, 2009-06-22 13:37
#13
Henry John Bormate
User offline. Last seen 14 years 13 weeks ago. Offline
Joined: 15 Jun 2009
Posts: 7
Groups: None
Hi Harzelli!

I have the same query with Carlos, I tried the step you mentioned ( File => Open => "tick" exclusive & open the file i want to edit the activity ID) but still the ID is in uneditable mode, can you help me please.

Another thing is, I want to change the title of my WBS, is their also a way to do that?

Thnx & more power...
Top
Tue, 2009-06-16 12:08
#14
Carlos Arana
User offline. Last seen 5 years 34 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
Thanks for sharing the wisdom
Top
Tue, 2009-06-16 11:52
#15
harzelli bouasria
User offline. Last seen 4 years 27 weeks ago. Offline
Joined: 15 Oct 2008
Posts: 42
Groups: Petro-Chem / Oil & Gas
hi
exclusive mean the total control of the project (in case of multiuser cession).
Top
Tue, 2009-06-16 11:47
#16
Carlos Arana
User offline. Last seen 5 years 34 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
WOW!
Thanks!
Now, what does that "exclusive" means?
Top
Tue, 2009-06-16 11:17
#17
harzelli bouasria
User offline. Last seen 4 years 27 weeks ago. Offline
Joined: 15 Oct 2008
Posts: 42
Groups: Petro-Chem / Oil & Gas
hi
yes there is
flow these steps:
File===> Open, here Check (tick) exclusive box, and open your project.
now you can change the activity’s ID.

Top