P3 - Gobal Change Command

Hello Fannie,

I assume that you are going to trim the length Of Activity Id from 10 to 6 Characters..
Let’s try to use function on Global Change by this condition..

DATAITEM | CRITERIOR | DATAITEM/VALUE

ACT | EQ | LEFT(ACT,6)


PLS BACK UP FILE BEFORE U DO OR CHECK THE TRIAL RUN BEFORE EXECUTE IT.

GOOD LUCK :-)

Praves

Hi, Praves.

Thank you for your suggestion.

can I trim Activity ID like that

WCB.1.100 >>> WCB1100 by Global change Command, too?

Cheers,
Fannie

Hi Fennie,

WCB.1.100 >>> WCB1100 by Global change Command, too?

As per yr ACT Id hierachy I think u might take a little bit time to type the condition in Gloable change by..

VAR1 EQ SS(ACT,1,3)
VAR2 EQ SS(ACT,4,1)
VAR3 EQ SS(ACT,6,3)

VAR4 EQ VAR1 & VAR2
ACT EQ VAR4 & VAR3

But the problem is that u will have no room to put these data in Global Change

You might create CDI and store value for VAR1, VAR2 and VAR3

then you will be able to fulfill above equations

Good Luck

:-)

Praves

Change WCB.1.100


--------------------------------------------------------------------------------
WCB.1.100 >>> WCB1100 by Global change Command, too?

The easy way to do this is to export the program to Excel, highlight the I.D. column. Go to find and delete "." then import the complete programme back.

Sorry if this is not in detail but am on holiday and do not have a copy of P3 with me.

If you do not know how to do this repost and ask for advice from Forum members.

regards,

Geo

Hi George and Praves,

yes.I tried to export to Excel and import again. However, some links were disconnected. I have check one by one and can not compare with original target programme cos’s the activity ID was changed.

Thank you for your suggestion.

I’m only doing it one by one.

Have a nice holiday.

Cheers,
Fannie

Hello Fannie,

FIRST OF ALL BACKUP YOUR PROJECT.

Add a new custom data item with name NID (New ID) as a character. Then go to tools>project utilities>export, add a new and export "Activity ID" and "Activity custom data items" in WK1 format.

Then open the file with MS excel and copy the values from ID column to NID column, change them and then import the file in P3.

Finally run global change to assign the new ID’s from the custom data item (Activity ID EQ NID).

I ’ve just tested and works !

Hi, Giannis Kostis

thank you.

I already tried. Export the data, such as ID, description and logic....Bla Bla. Establish a new programme by import that data.

unfortunely, few work sequnanec links are discounted. Work is failed. Eventually, I made it one by one.

Thanks & Cheers,
Fannie