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