Connecting Primavera SDK database using Excel
In the Open Standard
Anbin PonnithMember for 17 years 4 months
- Created
- 1
- 4
0
Dear All,
I tried connecting Primavera SDK Database using Excel external data.After connecting in the "query wizard" I am not able to select a particular project in the column area.
How can we filter a separate project..
With Thanks & Regards,
Anbin Ponnith
I tried connecting Primavera SDK Database using Excel external data.After connecting in the "query wizard" I am not able to select a particular project in the column area.
How can we filter a separate project..
With Thanks & Regards,
Anbin Ponnith
1 reply
Oldest first- 0Emma Seaton ·Hi, you need to know the Unique ID for the project. Do a query on the proj_id/proj_short_name within the PROJECT table and you should (hopefully) be able to identify which project you should filter on once you’ve connected to the data. Then using this UID you can then pull in the activities and associated data. It may help to root out the Physical Schema. This came with the on-disk documentation with P3e 4.1, and should in theory be on the P5 disk too...
Hope that’s of some help... I used this to connect to the MS SQL Database that the PMDB is using on my local machine. Haven’t been able to get onto the server version as yet.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?