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

9 replies [Last post]
Sun, 2008-06-01 03:33
Jineesh Dath
User offline. Last seen 9 years 19 weeks ago. Offline
Joined: 20 Aug 2007
Posts: 16
Groups: None
Is there any way to change the activity ID without having to copy and paste the whole thing again? For eg. the activity ID which I have now is ’EBXXXXXXX’ and I want to change it to ’MWXXXXXXX’. Please let me know how to do it.

Thanks
Top

Replies

Mon, 2011-01-10 12:18
#1
Paul Bradley
User offline. Last seen 1 year 33 weeks ago. Offline
Joined: 7 Oct 2009
Posts: 11
Groups: Civil Engineering

If you can't edit your activity IDs then you probably don't have sufficient rights.  Speak to your administrator or login with an admin password.

Top
Mon, 2011-01-10 12:18
#2
Paul Bradley
User offline. Last seen 1 year 33 weeks ago. Offline
Joined: 7 Oct 2009
Posts: 11
Groups: Civil Engineering

If you can't edit your activity IDs then you probably don't have sufficient rights.  Speak to your administrator or login with an admin password.

Top
Sun, 2011-01-09 23:52
#3
REJI JACOB
User offline. Last seen 13 years 16 weeks ago. Offline
Joined: 12 Nov 2010
Posts: 2
Groups: None

I have tried to copy and paste avtivities for changing activity ID's to a new sequence with respect to activity dates. But unfortunately the Sequence of activities did not change...

For example;

Before       After the process 

A1020       AD2020

A1030       AD2030

A1070       AD2070

A1050       AD2050

            Why this is happening like this? Means, why A1070 renumber to AD2070 instead of the seaquencial, AD2050??

Any help?? I am using P6 v6.2

Top
Thu, 2008-06-05 07:06
#4
David Podmore
User offline. Last seen 12 years 16 weeks ago. Offline
Joined: 26 Apr 2006
Posts: 74
Groups: None
Glen,

There is a "seat-of-the-pants" method if your feeling brave.

Make a copy of your programme - Just in case!

Set "Auto Numbering Defaults to...
Prefix "Z" (or any you wish)
Suffix "10000" (or any you wish)
Increment "10" (or any you wish)

Now select all tasks you want renumbering (all if that’s the case) and copy task, paste task selecting all paste options including "only between copied tasks" for logic.

You should now have a programme twice as big as before; twins in fact in all but tasks ID. Filter out the old tasks by ID and delete them. Bish Bash Bosh, what is left is the original programme but renumbered.

Only takes a few mins so have a go and see if you get what you expect.

The only downside is that any external logic links will be broken.
Top
Tue, 2008-06-03 03:27
#5
Alex Wong
User offline. Last seen 11 years 5 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Activity ID is no longer as important now. you can certainly export to excel, mod the ID and import it back

HTH

Alex
Top
Mon, 2008-06-02 15:41
#6
Glenn Douglas
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 22 Apr 2006
Posts: 39
Groups: Petro-Chem / Oil & Gas
Hi all,

just going off on a tangent slightly.

I have just taken over a plan which has been developed but not baselined yet.
The activity ID’s are all over the place and I would like to re-number them from the say 100000 and going down in 10’s (100010, 100020 and so on) can this be done without upsetting all the logic?

Thanks in advance.
GED
Top
Mon, 2008-06-02 07:53
#7
David Forrest
User offline. Last seen 29 weeks 1 day ago. Offline
Joined: 27 Nov 2001
Posts: 104
Groups: Accreditation Editors, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Sarawak Primavera User Group (SPUG)
Go to Edit, Replace and select ID column. Enter change xxx to yyy
Top
Sun, 2008-06-01 05:03
#8
Andrew Dick
User offline. Last seen 8 years 15 weeks ago. Offline
Joined: 14 Feb 2007
Posts: 295
Groups: Regional Representatives, The GrapeVine
Jineesh,
If the xxxxxxx part of your activity ID is the same length then you will be easily able to execute a global change; Similar to this;

Where ’Activity ID starts with ’EB’
Then Activity ID = ’MW’ + Right String,Activity ID, n’

Where n = the number of characters counting from the right of the activity ID to the first character after the original ’EB’

eg. EBxxxxxx (n=5) changes to MWxxxxx.

Have a couple of trys witin an inert project to get it staright in your mind what you need to do, but it is entirely possible. I make sure that I set my ID’s up in a manner where I can conduct this change as required, because I’ve come across some PM’s that like their activity ID’s to be related to someone or something.

Andy
Top
Sun, 2008-06-01 04:16
#9
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Jineesh
Try the Global Change (Tools --> Global Change --> click on the "Help" button. There is good information, so you should be able to use it.
If then you’ll have any questions, don’t hesitate to ask again.
Regards
Dieter
Top