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.

Imports to Activity Codes in P5

4 replies [Last post]
Wed, 2008-04-02 13:52
Glenn Douglas
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 22 Apr 2006
Posts: 39
Groups: Petro-Chem / Oil & Gas
Hi all,

Is it possible to import a list of codes from say ’Excel’ straight to the Activity Codes?
Or do I have to manually input them?
(there are hundreds & I’d like an easy option if there is one).

Cheers
Top

Replies

Tue, 2008-04-08 13:02
#1
DANG CORP
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
As to my previous post,

i do this alot too, and the place i am currently working,
managers changes there code assignment monthly too!

but not to worry, i ask them to do it in excel, and i import them directly, and easily.

so check this out David and friends,
it can create code fast and directly, instead of doing so many loops to get the code in.


http://www.dangcorp.com/toolbox.aspx

Vu Dang
Top
Thu, 2008-04-03 01:56
#2
David Kelly
User offline. Last seen 2 years 17 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
You must get the Dictionary.xls version you need from the Primavera Tech support site. This uses the SDK to update activity code dictionaries directly form Excel. Its not perfect - the SDK is a bit flaky - but it sure beats typing.
Top
Wed, 2008-04-02 16:51
#3
Glenn Douglas
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 22 Apr 2006
Posts: 39
Groups: Petro-Chem / Oil & Gas
Niek,

Thanks for that i’ll give it a go in the morning.

Glenn
Top
Wed, 2008-04-02 16:48
#4
Niek Zonneveld
User offline. Last seen 2 years 33 weeks ago. Offline
Joined: 17 Mar 2005
Posts: 188
Groups: None
Glenn,

You can do this through outline codes in MS Project (providing that you are not using 2007)

- create an outline field in MSP ("act-code", for instance)
- define a code mask for "act-code" in MSP and allow for new codes by default
- copy/paste from Excel (using a dummy task for each code)
- save the mpp, close MSP
- Import the mpp into P5/P6

H.T.H.

Niek.
Top