Summary
I'm building a dashboard that reads MS Project (.mpp) files using MPXJ. I need to access task-level time-phased cost data (monthly cost breakdown), similar to VBA's Task.TimeScaleData() method.
Currently, MPXJ only provides time-phased data at the ResourceAssignment level:
ResourceAssignment.getTimephasedCost()
ResourceAssignment.getTimephasedActualCost()
ResourceAssignment.getTimephasedBaselineCost(int)
The Problem
For budget tasks (tasks without resource assignments), there is no way to get time-phased cost data in MPXJ, even though:
- MS Project stores this data at the task level
- VBA can read it via
Task.TimeScaleData(StartDate, EndDate, pjTaskTimescaledCost, pjTimescaleMonths)
This causes my dashboard to show ~40% of the values compared to a VBA-based Excel export.
Request
Would it be possible to add task-level time-phased cost methods to the Task class?
For example:
Task.getTimephasedCost()
Task.getTimephasedActualCost()
Task.getTimephasedBaselineCost(int baselineNumber)
Questions
- Does MPXJ read task-level time-phased data from MPP files but not expose it?
- If not, is this data stored in a known location in the MPP binary format?
- Would you be open to a contribution that adds this functionality?
Environment
- MPXJ Version: 15.0.0
- File Format: MPP (MS Project 2019)
- Access Method: Python via JPype
References
Thank you for maintaining this excellent library!
Summary
I'm building a dashboard that reads MS Project (.mpp) files using MPXJ. I need to access task-level time-phased cost data (monthly cost breakdown), similar to VBA's
Task.TimeScaleData()method.Currently, MPXJ only provides time-phased data at the
ResourceAssignmentlevel:ResourceAssignment.getTimephasedCost()ResourceAssignment.getTimephasedActualCost()ResourceAssignment.getTimephasedBaselineCost(int)The Problem
For budget tasks (tasks without resource assignments), there is no way to get time-phased cost data in MPXJ, even though:
Task.TimeScaleData(StartDate, EndDate, pjTaskTimescaledCost, pjTimescaleMonths)This causes my dashboard to show ~40% of the values compared to a VBA-based Excel export.
Request
Would it be possible to add task-level time-phased cost methods to the
Taskclass?For example:
Task.getTimephasedCost()Task.getTimephasedActualCost()Task.getTimephasedBaselineCost(int baselineNumber)Questions
Environment
References
Thank you for maintaining this excellent library!