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.

SDK Use

5 replies [Last post]
Sat, 2010-03-27 00:21
Salman Ahmed
User offline. Last seen 14 years 6 weeks ago. Offline
Joined: 2 Mar 2010
Posts: 54
Groups: Petro-Chem / Oil & Gas
All advanced users of P6 are requested to post their suggestions on the following:

1.SDK - basics.
2.How to load the multiple resources using SDK (Step wise procedure).
3.How to generate S-Curves using SDK (Step wise procedure, like which fields to be selected....)

Thanks a lot in advance.
Top

Replies

Tue, 2010-03-30 19:18
#1
Rodel Marasigan
User offline. Last seen 6 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Salman,
Here is the Primavera SDK Programmer’s Guide

If the link doesn’t work edit the web address by removing (’) from word Programmer’s and type it back. For some reason the format was change and was not recognised by the host.
Top
Sun, 2010-03-28 05:26
#2
D Artagnan
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 19 Sep 2008
Posts: 207
Groups: Civil Engineering, GPC Qatar
From my experience, it’s combination of knowledge in VB, Database Management & Design (SQL) and basic programming. You can study it just by reading however it takes some interest to do that. Basic stuff you start on is with MS Access...
Top
Sat, 2010-03-27 06:10
#3
Rodel Marasigan
User offline. Last seen 6 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Salman,
I’m not sure if there is any practice/ learning materials on programming available in the net. The one I know is taking the course/ classes itself.
Top
Sat, 2010-03-27 04:33
#4
Salman Ahmed
User offline. Last seen 14 years 6 weeks ago. Offline
Joined: 2 Mar 2010
Posts: 54
Groups: Petro-Chem / Oil & Gas
Thank you very much Mr.Rodel,

Can you post/mail any practice/learning material on this.
Top
Sat, 2010-03-27 03:46
#5
Rodel Marasigan
User offline. Last seen 6 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Salman,

SDK is not a simple task to explain. The basic is might be understandable but the rest are requiring deep knowledge in computer programming especially visual basic and SQL. It also required a deep knowledge of Primavera Database structure and tables inside the database. It’s available to use with sample but for the users own risk.
For example: Excel SDK has a sample and basic program to extract and update global data like Project Code, Activity Code, Resource, Rates, Cost Account, Calendar, Notes, Notebooks and etc… but if a user has and advance knowledge on how it works and how to read the program then it can modify, create or write a program to extract and edit data for non global tables such as TASK, TASKRSRC, Relationship, WBS, Cost Account assignment, roles assignment and etc…and manipulate the extract data to create s-curve, cash flow, forecast and etc…

To use the basic Excel SDK (Dictionary.xls)
1) Open the Excel SDK then enter your username and password that you use to open Primavera.
(Note: Primavera SDK should be installed to your computer to use these facilities)
2) If Primavera is installed as standalone and also using external server for the database, Both SDK should be define on (ODBC) Data source.
3) Select the Primavera SDK to use (available only if using multiple database and both SDK are defined on (ODBC) Data source.
4) Select any buttons with label starting Get ???? (any global table you want to view and update)
5) This will direct you to tab correspond to a table that you click on the button.
6) Click the help option (?) and follow the instruction if you need to update the data.
7) If you understand and follow the instruction correctly you should be able to update the data with out any error.

The sample excel SDK can delete, add, modify data on selected global table inside Primavera Database.

No 2 and 3 requests are not possible because as I mention it requires programming knowledge. Even I write the step by step procedure which you will not understand then it’s useless. (Note: SDK had restriction for non global table which can be set using visual basic codes such as (access level and scope level) with out setting these non global tables are not updatable)
Top