Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise 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.

Import Activity Codes

5 replies [Last post]
Mon, 2005-04-25 03:56
Philip Richards
User offline. Last seen 15 years 22 weeks ago. Offline
Joined: 7 Jan 2004
Posts: 29
Groups: None
Can anyone please advise if it is possible to import Activity Codes to P3, from say an .XLS spread sheet.
Top

Replies

Thu, 2005-04-28 01:56
#1
Philip Jonker
User offline. Last seen 15 years 48 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi All,

Frank’s suggestion is very valid. Build up a standard coding structure, which will work for most projects, and transfer this coding structure to new projects. The only code which changes, is normally the breakdown of areas, what I normally do if the area breakdown is already in excel, is to copy paste it to P3. This takes a few minutes, and does not require extra software, and it is simplistic. There is obviously always going to be the odd code to be added to your standard structure, do these as you find a need for them. This can be done in companies, and helps especially where multi-project scheduling is used.

A useful thing is to print this standard coding structure in a large format, and put it on your wall, so that when you need to do a filter, you can straightaway, see the codes you require. Standard coding strucrtures are also useful, that in time you will get to know them of by heart.

Regards
Top
Wed, 2005-04-27 01:49
#2
Frank Borcherdt
User offline. Last seen 7 years 46 weeks ago. Offline
Joined: 3 May 2001
Posts: 88
Groups: None
You can also Transfer (button in Data, Activity Codes window) if the same coding structure has been used on another P3 project.
Top
Mon, 2005-04-25 09:52
#3
Dayanidhi Dhandapany
User offline. Last seen 3 years 31 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
use ACTIVITY.XLS file from P3 Ra file, that would be easy to get activity codes from P3 file or set activity codes in P3 file. Leave me your email id for further action...................
Top
Mon, 2005-04-25 06:08
#4
Jaco Stadler
User offline. Last seen 18 years 2 weeks ago. Offline
Joined: 8 Sep 2004
Posts: 299
Groups: None
Files That is Used to Import Activity Codes & Description Are.

D:\P3WIN\Samples\EXCEL\Activity

If You require to do the Codes on an activity lvl just export them to wk1 do the changes and reinport them. (Assighning codes to activity)
Top
Mon, 2005-04-25 03:59
#5
Steven Oliver
User offline. Last seen 11 years 50 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
There are some spreadsheets supplied with the P3 cd’s which can do this.


HTH


Top