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.

Automatic Running Number for Activity Id

3 replies [Last post]
Ir. P. Jaya Chandar
User offline. Last seen 11 years 27 weeks ago. Offline
Joined: 13 Apr 2009
Posts: 14
Dear P6 Experts,

Is there any easier or straight forward way to re-number the activity ids so that at the end of the schedule development process, we will have a properly sequenced running numbers? At times, we do insert additional activities in between other activities and the end result is a non sequential id numbers.

I noticed that the only way to change the activity id running numbers in bulk is by exporting it out to excel, changing the running numbers there and importing back to P6.

Is there anyway to use global change to automate the running numbers?

Thanks

Replies

Khuong Do
User offline. Last seen 2 years 17 weeks ago. Offline
Joined: 22 Feb 2010
Posts: 118
Groups: None

Hi,

I write an article regarding How to Renumbering Activity ID in Primavera P6. 

Kindly read it here : https://doduykhuong.wordpress.com/2016/05/27/renumbering-activity-id-in-primavera-p6/

Ir. P. Jaya Chandar
User offline. Last seen 11 years 27 weeks ago. Offline
Joined: 13 Apr 2009
Posts: 14
Thanks Dieter. Good that Version 7 included the feature.


Cheers.

Jaya
Dieter Wambach
User offline. Last seen 7 years 14 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Jaya

In P6 Version 7 there is such a feature "Renumber Activity ID’s".

Out of P6 Help:
Auto-Number renumbers selected activity IDs based on the sort order of activities in the activity table. The first activity in the sort order is renumbered using the values you type in the Prefix and Suffix text fields. The remaining selected activities are renumbered using the same suffix and prefix, and they are incremented using the value you type in the Increment Value text field. If P6 detects that it would renumber a selected activity ID to an activity ID that already exists, exclusive of those you selected, then the Duplicates dialog box appears. You use that dialog box to enter another activity ID. (end of quotation)
With older versions just the way via EXCEL.

Regards
Dieter