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.

global change ACT ID

7 replies [Last post]
Sun, 2006-08-27 09:20
Gün Göksu
User offline. Last seen 15 weeks 6 days ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
hello everybody.

I need some quick help here.

our contractor decided to change the naming convention of the activity codes.

please advice how I can change the ACT ID codes using global change (export import wont do as everything is linked and resourced).

I want to change the ACT codes first two letters from SP to SJ.

thank you
Top

Replies

Thu, 2006-08-31 05:18
#1
Frank Borcherdt
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 May 2001
Posts: 88
Groups: None
Gun,

The increment option is part of paste, so you could cut (or copy if you want the original activities to remain) and then paste with the external relationships option set.

Hope this helps.

Top
Thu, 2006-08-31 11:26
#2
Gün Göksu
User offline. Last seen 15 weeks 6 days ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
thank you very much for your replys. :)

the problem is there is a SJ sub project already.

thus it will be elegant to copy the SP sub project to a main project and change the SP to SJ then?

how do we move a sub project to be a main project?

I guess it can only be done if and when it is the only subproject that project group has? I couldnt copy the sub to main what I tried. guess a good nights sleep will solve the issue. :)

All of this comes out from the fact that I have some hammocks that I use to compair some key activities to the ones the client issues. I set the client program as target and just get to see the difference graphically in the grantt chart and if need be I consider changing the arrangement of someof my activities to comply.

Their activities where all starting with SJ. then they desided to split their schedule. the ones I use got renaimed to SP. and the SJ’s left got useless, and they are gettin in the way.

sounds familiar?


many many thanks to all who have replied. I have understood that my understanding of the Global Change needs some working on. and I try to use it more often now.

Gün. :)
Top
Wed, 2006-08-30 21:50
#3
Jaime Linchangco
User offline. Last seen 16 years 30 weeks ago. Offline
Joined: 16 Jul 2001
Posts: 29
Groups: None
Hi Gun,

Since your SP represent a Subproject, create first a new Subproject with Project ID of "SJ"

Then, at Global change, type the ff:

Then,

&A EQ LEFT(ACT,3)
&B EQ SJ & &A
ACT EQ &B

That should solve the problem now.

Cheers!

Jaime

Top
Thu, 2006-08-31 10:53
#4
Andrew Podolny
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Hello Gun

It’s pretty common situation when you need to
rearrange ACT ID.
Here the way I used to do this:
1. Create Custom Activity Data Item (TYPE=S, LENGTH=10)
for instance NWID.
2. Export Activity ID and Activity Custom Data Items to any format (I prefer DBF).
3. Open exported file either by Excel / Lotus or Access and apply new activity ID’s for column ’NWID’ (be aware of LENGTH<=10).
4. Save the file
5. Import back to P3 and make sure you’ve got the right NWID
6. Run Global Change ACTID=NWID
7. Rerun filter
8. Enjoy

Best regards,
Andrew
Top
Mon, 2006-08-28 10:38
#5
David Moses
User offline. Last seen 12 years 49 weeks ago. Offline
Joined: 20 Oct 2004
Posts: 122
Groups: Petro-Chem / Oil & Gas
Hi there,

If previous one does not work, please try this one;


If: (select your activities)

Then:

ACT EQ SJ & LTRIM(ACT)

I hope this helps
Top
Sun, 2006-08-27 19:44
#6
Tansel Kermen
User offline. Last seen 7 years 44 weeks ago. Offline
Joined: 6 May 2001
Posts: 5
Groups: Petro-Chem / Oil & Gas
SELAM / HELLO

global change

then
ACT EQ "SJ" & RIGHT(ACT,8)

That can be useful, I hope.
Top
Mon, 2006-08-28 12:40
#7
Gün Göksu
User offline. Last seen 15 weeks 6 days ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
thank you both for your replies.

the problem is a little bit more complex than I thought.

first of all your answers didnt work right away. the reason for that I found quite quickly.

the program I was trying to change the act id’s first two letters to "SJ" from "SP" was unsuccessfull because this prog was a sub prog (read PROG ID =SP). I had to create a dummy program just to be able to restore the sub prog (first time sent as subprog).

I hope you still follow me. I have had the idea of copying the prog to a new subprog with the prog Id set to SJ. It worked. but its not pretty.

your answers are not applicable when the program has a "Prog Id". is there a way to change the Prog Id of a subprog to any 2 letter? with the act codes.




since I am playing with global change. I cant see a way to change some act code fitting a criteria to another incremental act code. without export & loosing links. am I asking too much from P3?

thank you




Top