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.

How to change the Activity ID of a group of activities?

7 replies [Last post]
Thu, 2007-08-16 01:49
Pranab Kumar Deb
User offline. Last seen 3 years 38 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
Dear All ,
How to change the activity ID of a group of activities in faster manner and not by manually for all the activities.
I tried with import/export but the problem is that the activities where i change the activity ids comes in as new acivities.
Please advice.
regards
deb
Top

Replies

Wed, 2007-08-22 01:30
#1
Pranab Kumar Deb
User offline. Last seen 3 years 38 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
thanks daniel , ferdinand and dattareya
it was a great help
regards
deb
Top
Mon, 2007-08-20 22:33
#2
Daniel Limson
User offline. Last seen 5 years 31 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None
There is another way of doing it by copy and paste. Select auto increment and delete the ones you want to change. The only problem here is you will loose the relationship outside of the group you copied and pasted.

Cheers
Daniel
Top
Mon, 2007-08-20 03:34
#3
Ferdinand U.
User offline. Last seen 7 years 26 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
example change A100000000 to B200000000

global change

if ACT CN A1
then ACT EQ B2 & right(ACT,8)

run
Top
Fri, 2007-08-17 23:06
#4
Pranab Kumar Deb
User offline. Last seen 3 years 38 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
Hello Ferdinand and Dattatreya ,
can you please list in more details the procedure.
regards
deb
Top
Thu, 2007-08-16 06:13
#5
DATTATREYA PADHARTHI
User offline. Last seen 6 years 12 weeks ago. Offline
Joined: 18 Apr 2003
Posts: 90
Groups: Petro-Chem / Oil & Gas, Regional Representatives
Pranab,

Use the Global Change; if you want to change a charecter/s in the middle, extract all charecters before that lot and also extract all charecters after that lot and save as a temporary variable. then use the concatenate function.
Cheers
Dattatreya
Top
Thu, 2007-08-16 03:05
#6
Pranab Kumar Deb
User offline. Last seen 3 years 38 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
Hello Ferdinand,
Thanks for your reply can please elaborate how to use this function.
regards
deb
Top
Thu, 2007-08-16 01:54
#7
Ferdinand U.
User offline. Last seen 7 years 26 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
try global change using the &T1 function &..
Top