Renumbering Activity IDs from top to bottom

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

K
kumar s 👤 Member for 16 years 4 months

alexandre,

It works in 6.2 also..

i have tried it

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Anbin,

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

K
kumar s 👤 Member for 16 years 4 months

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.

 

 

 

 

 

 

 

 

J
Jose de BArros 👤 Member for 15 years 3 months

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

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

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

A
Andy Power 👤 Member for 19 years 9 months

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

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

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

A
Andy Power 👤 Member for 19 years 9 months

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts