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.

Activity Codes - Project

5 replies [Last post]
Mon, 2010-07-26 18:59
Deepak Jain
User offline. Last seen 11 years 15 weeks ago. Offline
Joined: 14 Jan 2006
Posts: 31
Groups: Petro-Chem / Oil & Gas
Hi all,

What would be the quickest way (excel import etc..) of creating a Activity Code - Project level code dictionary in P6v7 comprising around 500 elements ?

Thanks in advance,
Deepak
Top

Replies

Tue, 2010-07-27 00:38
#1
Rodel Marasigan
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Deepak,
You need to install SDK first on your machine where Primavera is installed. It is an option that can select when installing Primavera (CD1). Once installed you can use excel SDK to set Project Activity Code.
Top
Tue, 2010-07-27 00:15
#2
Deepak Jain
User offline. Last seen 11 years 15 weeks ago. Offline
Joined: 14 Jan 2006
Posts: 31
Groups: Petro-Chem / Oil & Gas
Thanks again Rodel. Could you please explain how to configure Excel SDK to have this import functionality ?
Top
Mon, 2010-07-26 23:21
#3
Rodel Marasigan
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Deepak,
If your task is to define activity codes then you need excel SDK otherwise you need to do it manually.
Top
Mon, 2010-07-26 22:13
#4
Deepak Jain
User offline. Last seen 11 years 15 weeks ago. Offline
Joined: 14 Jan 2006
Posts: 31
Groups: Petro-Chem / Oil & Gas
Thanks Rodel. Your solution seems to be valid only when activity coding is defined and you want to assign it at Activity level. Apparently, I need a solution to create this coding dictionary (>500 coding elements) before it’s assigned. The access path would be

Enterprise > Activity Codes > Project

You can built this manually, but i can’t figure out how to import it from excel..



Top
Mon, 2010-07-26 20:57
#5
Rodel Marasigan
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Deepak,
If you can identify the activity by filter or sorting then Ctrl+e (fill function) is enough but if not then excel Export/Import function might be appropriate.
Top