Changing Activity ID’s via Excel

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.

We are currently running 6.2.1 so my only choice is via excel, but my concern is that Primavera will create new activities instead of just replacing the activity id.

I can run a simple test to figure out if this is the case. Thanks for the guidance.

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

Arnold,
What I ultimately trying to accomplish is to move activities from one schedule into a new schedule with a slightly different WBS. I have both projects open and am in the WBS view. I am copying small sections of the WBS from the old schedule and pasting it into the new schedule.

When I do this sometimes I am loosing some of my logic because the original Activity ID’s were longer than 20 characters. Now I must shorten all of the activities to 20 characters so that I can copy the WBS from my existing project into the new project.

I hope this makes sense.

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

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

Hi Arun,

The answer is Yes.

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 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

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,

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

Regards,

Arnold

Arnold,
Sorry for the delay in responding...I have been away on holiday. I have finished the work that I was asking for guidance on.

What I did to accomplish the work was to export all of my engineering activities out of my old schedule into excel. In excel I created new activity id’s for the activities and then created an import file for my new project. I imported the activities then the relationships into the new project. Once I had all the activities and relationships in the new schedule I was able to group them into the proper WBS by showing the WBS column and using the fill down feature.

Thanks for your help.

Matt

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 arnold where are you?

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 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 primavera6@live.com 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

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