Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Activity ID Number Renumbering

2 replies [Last post]
Muhammad Saqib
User offline. Last seen 4 years 28 weeks ago. Offline
Joined: 25 Oct 2018
Posts: 35
Groups: None

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.

 

Replies

Santosh Bhat
User offline. Last seen 51 weeks 1 day ago. Offline
Joined: 15 Apr 2005
Posts: 381

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.

Zoltan Palffy
User offline. Last seen 3 days 7 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

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