Activity ID Number Renumbering

Dear All,

I have completed the schedule and i have added so many additional activities who has differenet Activity number. 

Started with A1000 and Ends with A11506 etc.

Now i want to Renumber the Activity ID with same activities sequence displayed. I followed this Youtube method (https://www.youtube.com/watch?v=S1ynA1wRwuc) and it works on small project but not in my current project. I mean it renumbered the ID but sequence is wrong. Activities ID is spreading in all other categories.

 

S
Santosh Bhat 👤 Member for 21 years 1 month

You can use XLS IMPORT to populate a Text User Defined Field with the new ID's you want to use, then run a Global Change to replace the ID's with the values in the UDF. Just make sure all the UDF values are unique.

Z
Zoltan Palffy 👤 Member for 16 years 10 months

you will lhave to add the sequence into consideration in the global change

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