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.

Re-number Activities

11 replies [Last post]
Fri, 2003-11-28 02:13
Phillip Witherington
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 28 Nov 2003
Posts: 9
Groups: None
Hi,

How can I have P3 automatically renumber all the activities in my schedule, after adding new activities.

thanks,
Phil Witherington
Top

Replies

Wed, 2003-12-10 03:14
#1
Jorge Taguinod
User offline. Last seen 2 years 21 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Philip,

Steven’s solution is guaranteed to work. I’ve used it several times.

Jorge
Top
Tue, 2003-12-02 12:05
#2
Phillip Witherington
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 28 Nov 2003
Posts: 9
Groups: None
Alphons,

You are correct. There are many ways to solve this problem. This is an aspect of P3 I like very much...differnent ways to solve the same problem.

thanks for your help,
Phil
Top
Tue, 2003-12-02 10:49
#3
Forum Guest
User offline. Last seen 2 years 30 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
Hello Phil,

You can see that if you are creative there are several solutions to the problem, all three of them work fine without loss of relations.

Regards Alphons
Top
Mon, 2003-12-01 13:09
#4
Steven Oliver
User offline. Last seen 11 years 24 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Not if you do all the work within P3, as the process copies/pastes the relationships at the same time.

Where you can get mixed up is with Activity Codes, which is why I recommend removing any organisation before copy/paste.

Also, remember that the Activity ID acts as the index for any target plan and that by changing the id, you will lose any index to the target.

Aside from that as you say, works just fine.
Top
Mon, 2003-12-01 13:00
#5
Phillip Witherington
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 28 Nov 2003
Posts: 9
Groups: None
Steven,

Your method is the easiest (for me) of the ones suggested in this thread. It worked just fine.

On my schedule of about 150 activities, I did not lose any relationships between activities.

Some of the other posts indicated relationslips could be lost by re-numberilng. Have you had that experience?

Again, thanks for the help.
Phil
Top
Mon, 2003-12-01 08:54
#6
Steven Oliver
User offline. Last seen 11 years 24 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Why not Edit, Select All, Copy, Paste , Auto Increment.

Then delete all of the original activities.

Remember to remove any organisation bands from the layout.

If you wished to, you could keep a copy of your original ID in a Custom Activity Field, using Glaobal Change

"Custom Field" = Actid.

Top
Mon, 2003-12-01 08:46
#7
MK TSE
User offline. Last seen 3 years 48 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Except global change, I don’t think there ia a quick way to solve it.
Top
Sat, 2003-11-29 09:15
#8
Bhuvaneswaran Vel...
User offline. Last seen 5 years 50 weeks ago. Offline
Joined: 28 May 2003
Posts: 19
Groups: None
May be using fragnet also we can do the same :
1st step : Store the activities as fragnet.
2nd step : Delete the activities.
3td step : Now Retrive the fragnet with autonumbering or with prefix or suffix id. Even numbering individual activities is also possible.

Note : Please take a back-up always.

Regards.,

Top
Fri, 2003-11-28 21:54
#9
MK TSE
User offline. Last seen 3 years 48 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Remind to double check the linkage is still exist or not.
Top
Fri, 2003-11-28 07:24
#10
Phillip Witherington
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 28 Nov 2003
Posts: 9
Groups: None
Thanks for the quick response, Alphons.

I will try your suggestions.

thanks,
Phil
Top
Fri, 2003-11-28 02:30
#11
Alphons Bruns
User offline. Last seen 1 year 24 weeks ago. Offline
Joined: 24 Jan 2002
Posts: 23
Groups: Petro-Chem / Oil & Gas
Hello Philip,

First of all why would you like to renumber. If you thought over the setup of your planning it wouldn’t be necessary.

There are several possibility’s but be carefull, the activity ID is unique and is related to all the information in a task.

Best you do is
- make a copy of your project and then
- make a character custom data Item with 10 positions, call it ACTN (Activity ID New)
- make an export to a *.WK1 file from your ACT ID and ACTN
- Renumber now in excel or lotus under the coloumb ACTN the new ACT ID
- Import this file and the new ACT ID’s are in the custom data Item.
- Now make a global change to replace your ACT ID with ACTN.

Regards Alphons
Top