Calculated Columns

Hi,

Up to know we have used Microsoft Office Project’s OLEDB Provider to extract project data from MPP files. We are currently looking at possibilities of replacing this dated interface with something like Aspose.Tasks.

I’m having difficulty to extract some calculated task columns from the Aspose.Tasks API e.g. Confirmed, Cost Variance, CPI, CVP, Duration Variance, EAC etc. Perhaps I missed it, but I couldn’t find anything in the product documentation.

Also, are there perhaps any documentation available that maps the MSP OLEDB task fields to those of the Aspose.Tasks API?

Any assistance would be appreciated.

Hi,


Thank you a lot for interest to our product!

You can find a full list of supported fields in Aspose.Tasks documentation here, (see, for example, Task’s class members here). Please note that not all fields for all formats are supported now, see the information in the fields descriptions.

Also, please note, that reading data from MS Project 2003/2007/2010 XML and MPP files is only supported, we are going to add MPD (Access and MS SQL) files support in Q1’2011.

Our object model is close to MS Project XML Data Interchange schema (see it here) and has some difference from MS Project ODBC and Automation data structures.

You can find additional product information on the our product page as well as links to the documentation and demos.