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 increment

7 replies [Last post]
Mon, 2009-06-08 08:44
Anbin Ponnith
User offline. Last seen 8 years 22 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
How to increment or change the activity id while copying and pasting in P6.
Top

Replies

Tue, 2009-06-09 07:46
#1
Arnold Puy
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community

You are welcome.

Top
Tue, 2009-06-09 07:20
#2
Anbin Ponnith
User offline. Last seen 8 years 22 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Thanks a lot sir,

Its working..

I ve thought of doing it in P3 and then import to P6.

But now I have got the Solution.

Thanks & Regards,

Anbin
Top
Tue, 2009-06-09 07:01
#3
Arnold Puy
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Anbin,

Try this.

If Activity id contains P1-ST1-S1

Then:

user_text1 = LeftString(Activity ID,3)
user_text2 = SF1 & SubString(Activity ID,7,12)
Activity ID = user_text1 & user_text2

Let me know if you have done it.

Regards,

Arnold
Top
Tue, 2009-06-09 06:13
#4
Anbin Ponnith
User offline. Last seen 8 years 22 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Thanks Sir,

I have listed my activity id as P1-ST1-S1-01....etc till 70
P1 for Phase 1
ST1 for Students Housing
S1 - Stage 1

Now while incrementing for next phases and other housings I followed your first advice and I have done it.

When I tried to modify it If suppose I have to change the Code ST1 as SF1 ,I tried with global Change I could not do it.

I used as,
If Activity id contains P1-ST1-S1
Then,
Activity id eq P1-SF1-S1.

Its comitting change only for the first one ie,P1-ST1-S1-01
and others 02,03 .. remains the same.


I tried with user defined field also..

Regards,

Anbin
Top
Tue, 2009-06-09 05:58
#5
Arnold Puy
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Anbin,

It is possible. There are lot of approach and steps you can perform.

1. Filter first all the group of activities prior to perform global change. In this case, no need for you to utilize the If statement.
2. Use only the LeftString, RightString & SubString Parameters and the operator of "&".

Cite an example and I will tell you how.

Regards,

Arnold

Top
Tue, 2009-06-09 03:30
#6
Anbin Ponnith
User offline. Last seen 8 years 22 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Thanks Sir,

Changing the Activity id globally wheather its possible?

I ve tried with different (If then Statements),But error occurs.

How to Modify activity id only for some particular group of activities.
Top
Mon, 2009-06-08 09:32
#7
Arnold Puy
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Anbin,

First of all welcome to Planning Planet.

Go to project details --> defaults tab, under auto-numbering defaults, change the activity prefix, suffix and increment depending on your requirements.

Untick the checkbox next to "Increment Activity ID based on selected activity".

Go back to activities window and start copying and pasting.

Regards,

Arnold
Top