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.

Renumbering Activity IDs from top to bottom

12 replies [Last post]
Alexandre Faulx-B...
User offline. Last seen 1 hour 23 min ago. Offline
Joined: 20 Jan 2003
Posts: 1277

Hello there,

One customer of mine is using P6 6.21; she wants to renumber all the activities in a project from PR1000 onward.

She is not allowed to export the data into Excel and use incremnatl copy there; the P6 V7 "Renumber Activity IDs number" is not available in 6.2

Any brilliant idea?

Thank you in advance

Alexandre

Replies

Khuong Do
User offline. Last seen 3 weeks 19 hours ago. Offline
Joined: 21 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/

kumar s
User offline. Last seen 4 years 8 weeks ago. Offline
Joined: 26 Jan 2010
Posts: 159

alexandre,

It works in 6.2 also..

i have tried it

Alexandre Faulx-B...
User offline. Last seen 1 hour 23 min ago. Offline
Joined: 20 Jan 2003
Posts: 1277

Joe,

thanks for your trick; does it work with 6.2?

Alexandre

Alexandre Faulx-B...
User offline. Last seen 1 hour 23 min ago. Offline
Joined: 20 Jan 2003
Posts: 1277

hello kumar,

lokks great, but does it work with 6.2?

Alexandre

Alexandre Faulx-B...
User offline. Last seen 1 hour 23 min ago. Offline
Joined: 20 Jan 2003
Posts: 1277

Anbin,

thanks for the pdf; very interesting indeed; unfortunately, my client is not allowed to export / import files, including XLS worksheets.

Anbin Ponnith
User offline. Last seen 3 years 48 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158

Hai

http://www.drmcnatty.com/publications/enewsletter/renumbering_activities.pdf

I hope this Link Might Help u.

Regards

Anbin

kumar s
User offline. Last seen 4 years 8 weeks ago. Offline
Joined: 26 Jan 2010
Posts: 159

Alexandre

if you looking for renumbering your activity ID's then here is a easier way...

group all the activities in the way you want your sequence to be.

then go to project details --defaults--auto numbering defaults

activity id prefix---A

actity id suffix---1000

increment ---   10 or 1 or 100

then unclick the  increment actity id based on selected actity.

Go to acitty layout copy  all the activities and paste it.

you can delete the original activities once you get all the actities in your required sequence.

 

 

 

 

 

 

 

 

Jose de BArros
User offline. Last seen 4 years 12 weeks ago. Offline
Joined: 24 Feb 2011
Posts: 3
Groups: None

the Id's Can be changed by adding temp id's on all Id's   A1;A2 etc then start renumbering all your  ID sequences as you required

 

Joe Barros

Alexandre Faulx-B...
User offline. Last seen 1 hour 23 min ago. Offline
Joined: 20 Jan 2003
Posts: 1277

Hello Andy,

I guess the project was built from two different activity listings, maybe one coming from MS Project; the first group of activities are numbered from 1 to 99 or so, with a step of 1; the other group starts with A500 and with a step of 10 goes up to A 1500 or so

I need to renumber all these activities with only one sequence starting with A1000 up to ...

Thanks for your help

Alexandre

Andy Power
User offline. Last seen 6 years 5 weeks ago. Offline
Joined: 30 Aug 2006
Posts: 43
Groups: None

Alexandre

What are the sources of the two ID's?  Have you got an example of an activity, what it's ID's are and what it's new ID should be?

Andy

Alexandre Faulx-B...
User offline. Last seen 1 hour 23 min ago. Offline
Joined: 20 Jan 2003
Posts: 1277

Hello Andy,

unofortunately not; my customer needs to create one sequence from two different IDs sequences, let's say: 1 to 999 and PR 200 to PR 25000

Alexandre

Andy Power
User offline. Last seen 6 years 5 weeks ago. Offline
Joined: 30 Aug 2006
Posts: 43
Groups: None

Alexandre

Are the numbers correct and you;re just looking to add the PR prefix?  If so you could do it through a global change quite easily.

If you are looking to totally renumber all tasks and you can't export to Excel and renumbering manually is out of the question due to the number of activities, the only other thing I can think ot is that I think there was a utility to do this provided by Primavera called RenumberActs, if you have access you may be able to find it on the Oracle support website.  You will need the SDK installed to use it though.  Sorry I can't help further but I have never used it myself.

Andy