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.

P3 - Gobal Change Command

7 replies [Last post]
Thu, 2006-07-13 23:27
Fannie CHOW
User offline. Last seen 6 years 41 weeks ago. Offline
Joined: 17 Jan 2006
Posts: 16
Groups: Women in Planning & Scheduling (WiPS)
Hello, all Planners,

Nice to meet you all here.

I need to trim down the Activity ID length from 10 Charaters to 6 Charaters. I tried to use the Gobal Change Command but it’s not success. Cos I want to make partial change on original activity ID. I don’t want to make a separate programme again.

Any expert can share their experinece?

Thanks in advance.

Cheers,
Fannie

Top

Replies

Thu, 2006-07-20 01:03
#1
Fannie CHOW
User offline. Last seen 6 years 41 weeks ago. Offline
Joined: 17 Jan 2006
Posts: 16
Groups: Women in Planning & Scheduling (WiPS)
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
Top
Sun, 2006-07-16 10:45
#2
Giannis Kostis
User offline. Last seen 18 years 7 weeks ago. Offline
Joined: 23 May 2005
Posts: 11
Groups: None
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 !
Top
Sat, 2006-07-15 03:12
#3
Fannie CHOW
User offline. Last seen 6 years 41 weeks ago. Offline
Joined: 17 Jan 2006
Posts: 16
Groups: Women in Planning & Scheduling (WiPS)
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
Top
Fri, 2006-07-14 16:05
#4
george stewart
User offline. Last seen 9 years 2 weeks ago. Offline
Joined: 22 Oct 2002
Posts: 20
Groups: None
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
Top
Fri, 2006-07-14 02:23
#5
Praves Suppa
User offline. Last seen 8 weeks 1 day ago. Offline
Joined: 16 May 2006
Posts: 40
Groups: None
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
Top
Fri, 2006-07-14 01:14
#6
Fannie CHOW
User offline. Last seen 6 years 41 weeks ago. Offline
Joined: 17 Jan 2006
Posts: 16
Groups: Women in Planning & Scheduling (WiPS)
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
Top
Fri, 2006-07-14 00:19
#7
Praves Suppa
User offline. Last seen 8 weeks 1 day ago. Offline
Joined: 16 May 2006
Posts: 40
Groups: None
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
Top