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.

Import excel data to Activity code value

7 replies [Last post]
Mon, 2008-06-02 07:12
Ranish KT
User offline. Last seen 36 weeks 6 days ago. Offline
Joined: 30 Jan 2003
Posts: 28
Groups: GPC Qatar, Petro-Chem / Oil & Gas
How to transfer/import excel data (Code and description) to activity code Value in P6.

I have about 5000+ itesm to be added as value for one of the activity codes.

Regards

Ranish
Top

Replies

Sun, 2011-06-19 14:43
#1
Joros Burgondy
User offline. Last seen 10 years 50 weeks ago. Offline
Joined: 14 Nov 2005
Posts: 31
Groups: GPC Qatar

Hi David,

Can you elaborate what is SDKU60 , refer to prim10191, I have done it one by one, so please if there is another way in doing much faster and save time please share.

 

Many Thanks,

Joros

Top
Sun, 2011-06-19 12:12
#2
Alhasan Abdalla
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 21 Apr 2011
Posts: 13
Groups: None

here is the link for the latest sdks

activity6x.xls , dictionary6v7.xls , wbs.xls , project.xls

http://www.eh.com.au/software.html

Regards

Top
Sun, 2011-06-19 12:12
#3
Alhasan Abdalla
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 21 Apr 2011
Posts: 13
Groups: None

here is the link for the latest sdks

activity6x.xls , dictionary6v7.xls , wbs.xls , project.xls

http://www.eh.com.au/software.html

Regards

Top
Wed, 2008-06-04 10:49
#4
David Kelly
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
you need Dictionary?.XLS from the Primavera Knowledge base. Loads any codes except wbs. you need P3 for that
Top
Tue, 2008-06-03 20:09
#5
Alex Wong
User offline. Last seen 11 years 21 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Marshall

That’s is one of many ways to importing code to the system.

Using SDK, API, Import/Export, Third Party integration tools are just few other ways to do what is original ask for.

Each solution of course is different, in terms of time / effort / cost.

HTH

Alex
Top
Tue, 2008-06-03 12:37
#6
Marshall Zewe
User offline. Last seen 12 years 10 weeks ago. Offline
Joined: 11 Mar 2008
Posts: 3
Groups: None
I think that the only way to do what you are asking is to add the codes to the P3 dictionary, create a dummy job using one of those codes, and then import the P3 job into P6. All of the codes will be there (might need to be re-arranged). I have done this once before (I think...). Someone else please correct me if this is not right.
Top
Mon, 2008-06-02 07:56
#7
David Forrest
User offline. Last seen 9 weeks 2 days ago. Offline
Joined: 27 Nov 2001
Posts: 104
Groups: Accreditation Editors, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Sarawak Primavera User Group (SPUG)
Try the SDKU60 , refer to prim10191.
Top