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.

Primavera P6 Software Development KIt (SDK)

1 reply [Last post]
Mon, 2012-10-15 11:51
FR L
User offline. Last seen 12 years 35 weeks ago. Offline
Joined: 14 Oct 2012
Posts: 3
Groups: None

Hello All;

I have installed Pruimavera P6 Version 8.2 Standalone on my laptop & Configured the database.

Then I Run the setup again and chose "change"

After this i selectd The "Software development kit installation"

Then I Configured the database again named "PMSDK"

I selected the user name as  "pubprm$pm" & Entered the same password that i entered during primavera installation (Prima123Vera).

Now "PmSDK" is also configured successfully.

Now I am Getting 2 data base "PMDB & PMSDK" when I run P6.

I followed these all steps through a tutorial 7 Did not do by own.

Now the issue is that what to do next to connect Primavera to excel. (I have the utility files for SDK but in those files I am not able to work)

Can anyone clear me the concept for using SDK.

 

Regards

Top

Replies

Thu, 2012-10-18 10:11
#1
Andre Greyvenstein
User offline. Last seen 12 years 18 weeks ago. Offline
Joined: 1 Jun 2009
Posts: 3
Groups: None

I am new to the whole P6 experience, just installed v8.2 myself. I used to use RA with P3 extensively, and therefor starting with P6 my first interest was on how to access the data 'throught the kitchen door'

I dont quite understand the intended concept behind what the call the SDK (Software Development kit). I did some setups on different machines with different settings, some with and some without the SDK. It seems to me that installing the SDK does nothing more but create a database alias to connect to an existing database - so where does Sortware Development come in? I achieved exactly the same by NOT installing the SDK, but create Data Connections through the Control Panel (in Windows 7: Control panel> Administrative Tools> Data Sources (ODBC)). I managed to then access the data from Excel by using ADODB.Connection & ADODB.Recordset objects in VBA.

I am using 3 Databases at the moment - 1 on my local machine, 1 on the server at my work site and 1 on our head office servers. I can read (and write) data to any of the 3 by changing the database name (or alias), with or without intalling the SDK.

To answe you question on the use of the SDK: the way I use it is by writing my own code in VBA. To do this you need some knowledge of Visual Basic Programming as well as a basic knowledge of using SQL.

Not knowing what your intentions are with this and how you want to use it, just keep in mind when writing your own code: Reading (SQL Select) is easy and safe, changing/updating (SQL Update) gets a bit more tricky and dangerous. Adding data (SQL Insert) is VERY dangerous.

Regards

Andre

Top