If the link doesn’t work edit the web address by removing () from word Programmers and type it back. For some reason the format was change and was not recognised by the host.
From my experience, its 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...
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. Its 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)
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
Salman,
Here is the Primavera SDK Programmer’s Guide
If the link doesn’t work edit the web address by removing () from word Programmers and type it back. For some reason the format was change and was not recognised by the host.
From my experience, its 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...
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.
Thank you very much Mr.Rodel,
Can you post/mail any practice/learning material on this.
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. Its 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)