Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Copying activities to existing projects

9 replies [Last post]
Mon, 2007-04-09 01:01
Terry White
User offline. Last seen 12 years 18 weeks ago. Offline
Joined: 8 Feb 2004
Posts: 39
Groups: None
My work follows a standard series of Activities for each project. I copy activities to create new ones, but I need to change the Client name on each activity. Is there a way of doing this across all the activities at the same time ?
Top

Replies

Thu, 2007-04-19 06:54
#1
Terry White
User offline. Last seen 12 years 18 weeks ago. Offline
Joined: 8 Feb 2004
Posts: 39
Groups: None
Thanks Paul for this information. Its a useful tool and will allow me as you say to slip in extra projects into my plan as and when I need to.
Top
Wed, 2007-04-18 20:59
#2
Paul Winthrop
User offline. Last seen 10 years 16 weeks ago. Offline
Joined: 20 Mar 2007
Posts: 4
Groups: None
Hi Terry,

Have you tried using fragnets? There is a text replace function when you "retrieve" a fragnet which will let you replace a placeholder in the activity description with any text you wish.

An easy way to update activity codes is to add the activity code column to your layout, enter the code in the first activity and then use Edit, "fill cell" to update the others.

Regards,

Paul
Top
Sun, 2007-04-15 12:50
#3
Benj Aquino
User offline. Last seen 15 years 34 weeks ago. Offline
Joined: 17 Oct 2006
Posts: 8
Groups: None
Hi Mr. Rodel. May I request a copy of the tool you are referring to? Here’s my email - brennjz23@yahoo.com. Thanks a lot.
Top
Tue, 2007-04-10 13:45
#4
Kristian Gargullo...
User offline. Last seen 40 weeks 4 days ago. Offline
Joined: 12 Mar 2007
Posts: 12
Groups: None
Hi Mr. Rodel,

Would you be so kind to share that same file with me. I’m quite eager to try this tool also. Please send it to kristiangargullo@zamilsteel.com

tnx.

kristian

Top
Mon, 2007-04-09 23:03
#5
Pranab Kumar Deb
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
Hello Rodel i also needed a copy if possible send to deb.icd@tajnet.com
regards
deb
Top
Mon, 2007-04-09 07:51
#6
Terry White
User offline. Last seen 12 years 18 weeks ago. Offline
Joined: 8 Feb 2004
Posts: 39
Groups: None
Hi Rodel

I’ve sent the details via PM. Thanks a lot.

Terry
Top
Mon, 2007-04-09 07:27
#7
Rodel Marasigan
User offline. Last seen 17 weeks 5 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Terry,

P3 has no capability of changing activity codes by selecting all activities like MSProject. The easiest way is to have a unique identification on your Activity ID so you can have a reference when you change it globally or export your activities into dbf or wk1 format which ever you’re preferred to use and open to excel program change it from their, then export it back to P3. An alternative way is using RA excel utilities that you can found in your P3 installation disk. If you need a copy, gave me your email address so I can email it to you.

Regards,
Rodel
Top
Mon, 2007-04-09 07:06
#8
Terry White
User offline. Last seen 12 years 18 weeks ago. Offline
Joined: 8 Feb 2004
Posts: 39
Groups: None
Thanks Rodel

I’ve worked out how to copy a series of Activities across, but when it comes to changing the Resp field, is there a way of selecting all the lines to be changed to a different person rather than doing each individual line ?

Thanks

Terry
Top
Mon, 2007-04-09 07:02
#9
Rodel Marasigan
User offline. Last seen 17 weeks 5 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Terry,

There are so many ways of doing it. You can use global change, export/import utilities and RA excels Utilities which all will do a good job for you. It all depends on which you are comfortable with.

Regards,
Rodel
Top