Changing Activity ID’s via Excel

Hi,



If you are using P6.2.1 like me, then you don’t have the Renumbering tool option. I use several functions of P6 to change Activity ID’s and plus excel export-import.



1-) Create a User Defined Field like ACT NO or something like that.

2-) Then Global Change function-Copy all the Activity ID information to this recently created User Defined Field. (0r you can skip this one and do it on excel manually.)

3-) Export activity information to excel including the user defined field.

4-) Modify the user defined field the way you prefer (the new ID numbering system.) If you have hundreds or thousands of activities, this may come in handy. You can use excel’s functions, formulas etc. to create the new ID system.

5-) Import the excel back and overwrite the user the defined field, with the new ID numbering system values.

6-) Global change again but in reverse this time, copy the user defined field info to Activity ID.



I know it takes some time to do it. But this is the only reliable method I know right now. I hope it is a useful info for you.



Regards,



Ahmet

Hi Rola,



Sorry for the late reply, I am busy with my monthly report.



1. Try to create UDF and do it in excel. Actually, it is quite a long procedure. If it is ok for you to send me at [email protected] your .xer file and I’ll fix for you.



2. It is ok to stick with WBS numbering.



3. In my perspective, it is ok to use any constraints but try to avoid the overuse of it.



Regards,



Arnold

Did you try using Formulas?



With Spider Project I created a user defined field then entered my new activities IDs in this field. Then using a formula Code(Activity ID)= New user field I could change the IDs, cells left blank made no change in activity ID.



Yes all software work differently but maybe this could help.



Best regards,

Rafael

hi arnold where are you?

Arnold

lets say the last activity no. was A1200 then i added a new activity in the middle of the WBS so it got A1210 with pred. lets say A1000 and a succ. A1010.

i need to renumber all of them .

another question do I have to creat ID with letters of WBS such as EM10 or is it ok to stick with primavera numbering ?

Another one can we submitt a time schedule with constraints no manodatory , say start on or before, for example?

thank you so much.

Hi Rola,



Can you cite an example if what Activity ID you want to modify.



Regards,



Arnold

hi arnold

i made a schedule , and after i finished i decided to add more activities. the numbers are not in any kind of order so i want to renumber them , i used excel but it add a new activity, and i don’t know if i can do using global change since i don’t know how to write the stamtement, although i

i have seen changing activity in the global change but i don’t know how to write the user defined feild.

thanks

Hi Rola,



With P6.2.1 you can change your Activity ID using global change.



With P6 v7 you can change this using the "Renumber Activity IDs".



Tell me what you really need and I will guide what to do.



Regards,



Arnold

when you export it to excel and change then import it back,

p6 adds a new activity but without the relations so what should we do?

Hi Arun,



The answer is Yes.



Regards,



Arnold

Dear Friends



I have a Query .I agreee with changing Activity IDS through Excel.But When we r changing the Activity will the change reflect in relations also????

For Example





A100 Block work GF relation A200 Block work FF



If Iam Changing the Activity ID to BK100 & BK200 will it reflect?????



With regards

Arun.V

Dear Friends



I have a Query .I agreee with changing Activity IDS through Excel.But When we r changing the Activity will the change reflect in relations also????

For Example





A100 Block work GF relation A200 Block work FF



If Iam Changing the Activity ID to BK100 & BK200 will it reflect?????



With regards

Arun.V

Matt,



I thought you will only change your Activity ID. If you copy only a certain level of WBS from your old project to the new project, the logic will naturally disappear.



There is a workaround to do that. If you can send me only a portion of your schedule in .xer format, I will show how to do that.



Just tell me what Activity ID you required and explain what else do you need.



Regards,



Arnold

Hi Matt,



Welcome to Planning Planet.



Why not try to use global change. Can you tell us or can you cite an example so that I can tell what and how to do it?



Regards,



Arnold

if you are using P6.7 you can use the "Renumber Activity Tool" ---> right click ---> renumber activity, better than using excel.



otherwise, use SDK (activity.xls), export all activities then change it in the excel and import it back again. Press F5 afterwards.