global change ACT ID

SELAM / HELLO

global change

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

That can be useful, I hope.

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

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

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

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.

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

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. :)