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.

Programming in P6

2 replies [Last post]
Tue, 2010-06-01 04:23
Alexander Douglas
User offline. Last seen 14 years 48 weeks ago. Offline
Joined: 30 May 2010
Posts: 4
Groups: None
Rodel,

Thanks a lot for your advise, i will work on it, may i have your personal email id (if you don;t mind) plz as i do not visit planning planet often?

May you guide me if there is any way of programming in p6 with d2k or vb or oracle dbms?

how do we link excel to p6?

Do we have any way to link excel in p3 as well?

please advise.
Top

Replies

Tue, 2010-06-01 06:15
#1
Rodel Marasigan
User offline. Last seen 15 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Alexander,
P6 Database is Open Database. You can use any open database connectivity(ODBC) software to communicate with P6 Database. You can use any language like Visual Basic, Oracle, SQL, Foxpro, Borland C++, C Language, Dbase, MS Access, Excel, etc…
The most popular that commonly used are VB, MS Access, Excel, SQL and Oracle. P6 is using SQL Database server or Oracle server depends which one is selected during installation.
P4 to P5 are using Interbase Database while P3 is using Btrieve database and can use VB language and ODBC connectivity.
P3 & P5 to P6 release SDK using VB language in programming and have there sample SDK utilities on Primavera CD using MS Access and Excel. For P6 you can find under SDK folder Activity6.xls & Directory6.xls and for P3 under Util folder you can find MS Access SDK sample program, Activity.xls, Project.xls, Spread.xls, etc…
Below link is the Programmer’s Guide using SDK, General Tables & Fields for P6.
Programmer’s Guide (Note: If the link don’t work delete punctuation mark (’) between (programmer’s) and retype again. For some reason the font format change)
General Tables & Fields
Top
Tue, 2010-06-01 04:42
#2
Mike Testro
User offline. Last seen 21 weeks 4 days ago. Offline
Joined: 14 Dec 2005
Posts: 4420
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Alexander

You can make contact with Rodel via the PP private message service.

it is not a good idea to post your private email in the open forum.

Best regards

Mike Testro
Top