Skip to content

Renumbering Activity IDs from top to bottom

Alexandre Faulx-BrioleMember for 23 years 8 months
Created
12
5
0

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

12 replies

Oldest first
  1. 0
    Andy Power ·

    Alexandre Are the numbers

    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

  2. 0
    Alexandre Faulx-Briole ·

    Hello Andy,unofortunately

    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

  3. 0
    Andy Power ·

    Alexandre What are the

    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

  4. 0
    Alexandre Faulx-Briole ·

    Hello Andy,I guess the

    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

  5. 0
    Jose de BArros ·

    the Id's Can be changed by

    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

  6. 0
    Kumar S ·

    Alexandre if you looking for

    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.

     

     

     

     

     

     

     

     

  7. 0
    Anbin Ponnith ·

    Hai http://www.drmcnatty.com/

  8. 0
    Alexandre Faulx-Briole ·

    Anbin,thanks for the pdf;

    Anbin,

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

  9. 0
    Alexandre Faulx-Briole ·

    hello kumar,lokks great, but

    hello kumar,

    lokks great, but does it work with 6.2?

    Alexandre

  10. 0
    Alexandre Faulx-Briole ·

    Joe,thanks for your trick;

    Joe,

    thanks for your trick; does it work with 6.2?

    Alexandre

  11. 0
    Kumar S ·

    alexandre, It works in 6.2

    alexandre,

    It works in 6.2 also..

    i have tried it

  12. 0
    Khuong Do ·

    Hi,I write an article

    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/

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?