Skip to content
ProjectControls.com
Oracle Primavera - PM6

Connecting to PrimaveraSDK via Open Office

In the Open Standard
Steve EidenMember for 22 years 1 month
Created
6
3
0
Ive been able to access info in P3ec using PrimaveraSDK.xls, Impexp.exe, and several of the other xls utilities provided with P3ec. And I’ve read the SDK HTML manual which encourages using MS Access ADO for connection. My question is can OpenOffice be used to query the database and make real-time changes? Thanks in advance

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Bernard Ertl ·
    #1
    You should be able to use VBA to access the ADO interface from Microsoft Office applications and make changes in "real" time. Our eTaskMaker software is exporting estimates/schedules to P3e[/c] using the ADO interface and it works fine.

    Bernard Ertl
    InterPlan Systems - eTaskMaker Project Planning Software
    Report
  2. 0
    Steve Eiden ·
    #2
    Bernard
    I used to employ import/export and copy/paste from P331 into Excel - doing a variety of things from data analysis to resource loading - to make reports that weren’t possible in P331 or to re-import tagged tasks for filtering. Most only took minutes. Is the VBA/ADO using the SDK connection the best bet for import/export? Thanks...
    Report
  3. 0
    Bernard Ertl ·
    #3
    I have not explored the alternatives, but the ADO interface works well enough for me. :)

    Bernard Ertl
    InterPlan Systems - eTaskMaker Project Planning Software
    Report
  4. 0
    Dang Corp ·
    #4
    "Is the VBA/ADO using the SDK connection the best bet for import/export? Thanks..."


    from past implementation,
    yes, VBA/ADO is absolutely the answers for what you needed to do.

    Vu
    Report
  5. 0
    Ray Messinger ·
    #5
    Where did you find "PrimaveraSDK.xls".

    I can’t find it.
    Report
  6. 0
    Steve Eiden ·
    #6
    PrimaveraSDK.xls is on the Documetation disk that comes with P3ec under the support tab


    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?