MSP Automatic unique number generator

B
Bob Foden 👤 Member for 18 years 8 months
Planning, Scheduling & Programming Discussion
B
Bob Foden 👤 Member for 18 years 8 months
· Permalink

Hi Alan,



Just found a "problem" with this. The unique ID is fine when you open up just the one project but if you open up a plan and then insert another plan then the unique ID’s in the inserted plan change out of all recognition. They are still unique but appear to bear no resemblance to their namesake when the solitary plan is opened. Any ideas (again) ?



regards



Bob

B
Bob Foden 👤 Member for 18 years 8 months
· Permalink

Hi Alan,



No I wasn’t aware of that so thanks. This could be just the ticket!!!



Cheers



Bob

A
Alan Phillips 👤 Member for 20 years 10 months
· Permalink

Hi Bob,

I don’t know if you are aware that there is a field in MSP which is called "unique ID" and that it automatically generates a unique ID number for every activity / task that is added to your schedule. This number cannot be changed. You could therefore add a text field prior to this field for the text part of your unique number and then have the unique id field next to it to show an overall Unique alphanumeric number. Hope this helps. Kind Regards Alan

B
Bob Foden 👤 Member for 18 years 8 months
· Permalink

Thanks for your response Darren. At least I can now take some comfort in the fact that there wasn’t a simple solution that I was missing. I shall now wait to see if there are any "kind souls" out there !!!



Bob

D
Darren Kosa 👤 Member for 18 years 3 months
· Permalink

Hi Bob



I initially thought using the WBS code mask would be the most sensible place to start, but I don’t think it will stay within the alphanumeric format you specified.



Each level of granularity would add another suffix rather than increase incrementally, so I think you’re stuck with the text fields unfortunately.



There probably isn’t a way to do this with the standard MS Project package, however, there might a kind soul on the forum who could fashion you a visual basic macro that will suit your purpose.



Alas I’m not smart enough to help in this area, but let me know if you find anything as I’m intrigued to see if you can do this in MSP.



Regards,



Darren

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