Update of user defined Field (UDF) based on another UDF
In the Open Standard
Neil DeavilleMember for 19 years
- Created
- 16
- 10
0
I have an Excel spreadsheet which has two columns which relate to UDF’s on activities in Primavera.
The first column is a unique number which is already in Primavera (a unique reference to a pipe), the second is a corresponding value (the length of the pipe).
I need an easy way to update the length of the pipe in Primavera, by linking to the pipe reference in the spreadsheet.
The easiest way that I can see to do this is to export to Excel at project level, update the export spreadhseet via a lookup to my external spreadsheet and then import.
This will be very time consuming as my overall project is split over many Primavera projects, and only one Primavera project can be imported at a time.
I could update the database direct, although I am loathe to do this.
Is there a way to do this through the API?
I’m using Primavera 5
Apologies if this has already been covered, it seems like quite a simple request.
Thanks
Neil
The first column is a unique number which is already in Primavera (a unique reference to a pipe), the second is a corresponding value (the length of the pipe).
I need an easy way to update the length of the pipe in Primavera, by linking to the pipe reference in the spreadsheet.
The easiest way that I can see to do this is to export to Excel at project level, update the export spreadhseet via a lookup to my external spreadsheet and then import.
This will be very time consuming as my overall project is split over many Primavera projects, and only one Primavera project can be imported at a time.
I could update the database direct, although I am loathe to do this.
Is there a way to do this through the API?
I’m using Primavera 5
Apologies if this has already been covered, it seems like quite a simple request.
Thanks
Neil
16 replies
Oldest first- 0Rodel Marasigan ·Neil,
You can use ODBC or SDK to update your PMDB database in one go. It requires knowledge on database and use update query by linking your Excel spreadsheet to PMDB database table. You need 2 tables in PMDB database which are UDFTYPE table that identify the Users define type/ name/ projects and UDFVALUE table where all the values are stored.
Hope this help,
Rodel
- 0Andrew Podolny ·Hi Neil.
My honest opinion - the API & SDK way is much more complicated than Import / Export exercises. I did same routine tasks for my P3 projects - pipe #, batch #, length, heat # were imported through DBF using MS Access quite easily. P5 - in case you have several projects - just open it at once and export UDF to Excel then you will have 3 key fields in your exported spreadsheet - Project ID, WBS ID, Activity ID - just update the UDF from your external source and import back to P5.
Regards,
Andrew - 0K D ·Hi Neil.
Primavera have a macro tool to "Get Activity UDF" and "Set Activity UDF". This was programmed on Excel so it can connect to database and export data to excel sheet. After update on excel ,click "Set Activity UDF", it will update data in database.
You can download this free tool at Primavera POINT website as long as you’re still on maintenance.
Thanks - 0Alex Wong ·Dear All,
I been facing the same issues daily importing/exporting data and decided to take on challenge myself to ease the pain. I had comes up with a easy to use program to modify data within P5/P6. After testing it to the death I would like to share with everyone.
If you are interested please send me a PM and I will send you a copy of the program within next few weeks
Regards
Alex
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?