Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Automatic Activity ID

9 replies [Last post]
Aymen BEN YOUSSEF
User offline. Last seen 10 years 34 weeks ago. Offline
Joined: 4 Aug 2008
Posts: 23
Groups: None
Hi everybody,

Is it possible in P3 to give automatic activity ID according to WBS for exemple, I checked in activity codes but I can’t find a solution.

Thanks for your collaboration,

Replies

Farid Arab
User offline. Last seen 7 years 11 weeks ago. Offline
Joined: 20 Jul 2008
Posts: 12
Hi,

there is a method that I present it here.
do following steps
1)at first rename your activity Ids from 1 to ....
2)then go to global change and clik add
3)if "ACT" "GT" "0" then
"ACT" "EQ" "WBS" "&" "ACT"
then click Run
That’s it all

in case of that you have to change a large number of activity ids you can import your file to excel then change it and again import it to p3. in this case the whole process takes about 3 minutes
Rick Aquino
User offline. Last seen 14 years 30 weeks ago. Offline
Joined: 6 Apr 2005
Posts: 48
Hi Arnold,

Yes i’m talking to activity ID, THANK YOU again

my two cents.

Rick
Arnold Puy
User offline. Last seen 10 years 18 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Rick,

If you are talking about the Activity ID of the Activity Name then Go to Project Detail --> Defaults Tab --> Auto-numbering Defaults:

Activity ID Prefix = FO000 up to 20 Alpha-Numerical
Activity ID Suffix = must be between 0 to 999999
However, you cannot input 0 first then followed by 1, instead 1 followed by 0
Increment = 1, 2, 3......10 depending on your requirements

Do not forget to mark the checkbox next to "Increment Activity ID based on selected activity.

HTH

Arnold
Rick Aquino
User offline. Last seen 14 years 30 weeks ago. Offline
Joined: 6 Apr 2005
Posts: 48

Hi Arnold,

How about in P6, How can set-up the the id?

Thanks
Arnold Puy
User offline. Last seen 10 years 18 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147

You’re Welcome Ben..

Aymen BEN YOUSSEF
User offline. Last seen 10 years 34 weeks ago. Offline
Joined: 4 Aug 2008
Posts: 23
Groups: None
Mr Arnold,

Thank you very much for this precious informations, this is what I was looking for, this tip will help me so much for my next schedule.

Regards,
Arnold Puy
User offline. Last seen 10 years 18 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Ben,

You are talking about the SUBP (Sub-Project) from Activity Codes under Activity ID. Well, You must create by your own. First you have to create a Project group. You can also do this without creating project group. Let say Foundation, your prefix Act ID FO & then followed by 0010. So your Act ID became FO0010.

If you will go to Activity Codes --> Activity ID --> Codes, "Name" you can rename, "Lenght" depend on you 2,3,4 whatever, when done tick refresh, all Activity ID with Prefix FO will be under the Foundation. Under Value, you can find out FO will come out automatically then you can name under Description as Foundation.

Now, you can use this Codes to a certain level and assign this to your activities. Try this exercise..

HTH.

Arnold
Aymen BEN YOUSSEF
User offline. Last seen 10 years 34 weeks ago. Offline
Joined: 4 Aug 2008
Posts: 23
Groups: None
Thank you Albert for answering me, but what I need is to put for example two letters at the starting of the activity id according to certain logic for example WBS, Department, Responsibility...
In activity code there’s some settings about activity id but I don’t understand their utility.
Thanks,
Albert Balogo
User offline. Last seen 10 years 33 weeks ago. Offline
Joined: 9 Jun 2008
Posts: 44
Hi Ben,

For P3 Programme its always requiring your basis for activity ID, So meaning you need to encode the first activity ID then press arrow down. if you want to change the setting go to tools, option, activity inserting then change the default number.