Activity id increment

Oracle Primavera - PM6
A
Anbin Ponnith 👤 Member for 17 years
· Permalink

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

A
Arnold Puy 👤 Member for 19 years 2 months
· Permalink

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

A
Anbin Ponnith 👤 Member for 17 years
· Permalink

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

A
Arnold Puy 👤 Member for 19 years 2 months
· Permalink

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


A
Anbin Ponnith 👤 Member for 17 years
· Permalink

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.

A
Arnold Puy 👤 Member for 19 years 2 months
· Permalink

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

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts