Hello,
I have a code to import data from MPP a file. Everything works fine except for one thing: all data is loaded correctly, but sometimes the resource assignment daily effort hours are not correct.
Here is pertinent part of my code (this is done for everyone of the tasks of the project, loaded from the MPP file), where I use timePhasedData:
private void loadResourceAssignments(final Workpackage task,
final ResourceAssignmentCollection assignments,
final Map<Long, ProjectResource> allResourcesUniqueIdMap)
throws SystemAlertException {
LOG.info("Loading Resource Assignments... WP ID = " + task.getId());
for (com.aspose.tasks.ResourceAssignment assignment : assignments) {
if (assignment.get(Asn.RESOURCE).get(Rsc.UID) != null) {
ProjectResource resource = allResourcesUniqueIdMap.get(
assignment.get(Asn.RESOURCE).get(Rsc.UID).longValue());
ProjectWorker worker = new ProjectWorker();
worker.setWorkpackage(task);
worker.setProjectResource(resource);
com.aspose.tasks.Duration work = assignment.get(Asn.WORK);
if (work != null) {
worker.setEffortValue(work.toDouble());
worker.setEffortType(getEffortType(work.getTimeUnit()));
}
com.aspose.tasks.Duration remainingWork = assignment.get(Asn.REMAINING_WORK);
if (remainingWork != null) {
worker.setDone(remainingWork.toDouble() == 0);
}
List allocationMap = new ArrayList();
TimephasedDataCollection timePhasedDataList =
assignment.getTimephasedData(assignment.get(Asn.START),
assignment.get(Asn.FINISH), TimephasedDataType.AssignmentWork);
if (timePhasedDataList != null){
for (TimephasedData timePhasedData : timePhasedDataList) {
Date timePhaseDay = timePhasedData.getStart();
ProjectWorkerAllocation allocation =
checkIfAllocationMapContainsDayAllocation(allocationMap,
timePhaseDay);
// If specific day allocation doesn't exist create a new one
if (allocation == null) {
allocation = new ProjectWorkerAllocation();
allocation.setDate(timePhaseDay);
allocation.setProjectWorker(worker);
allocation.setRate(0D);
allocationMap.add(allocation);
}
// Save work per day in minutes
allocation.setAllocation(getDayAllocationInMinutes(
timePhasedData.getValue()));
}
worker.setAllocationMap(allocationMap);
}
projectDAO.persist(worker);
}
}
}
I'm only considering the start date of the timePhasedData, since I want to save the effort hours for every day of the assignment.
So, what I get with this code is: for some projects the daily effort hours are persisted OK in the data base, but for others, I get wrong data.
I did some debugging and there is something wrong happening with the timePhasedData: instead of getting the list of all days between the start day and the end day of the resource assignment, some of the days (with effort hours in the MPP) are missing from the list.
I thought then that maybe the timePhasedData statement:
TimephasedDataCollection timePhasedDataList =assignment.getTimephasedData(
assignment.get(Asn.START),assignment.get(Asn.FINISH), TimephasedDataType. AssignmentWork);
was wrong, so I tried this statement instead:
TimephasedDataCollection timePhasedDataList = assignment.getTimephasedData();
With this change, there is now no missing day in the list of timePhaseData, but now I get repeated days in the list. I notice that for some cases I can simply add the effort hours of timePhaseData for the same day and the total was in fact the effort hour total present in the MPP file (for example for 2016/4/19 - in the MPP it has 8 hours - I got two timePhaseData with 3h36 and 4h24, respectely), but the problem was that for other repeated days I got also repeated effort hours (for example for 2016/4/4 - in the MPP it has 8 hours - I got two timePhasedData with 8 hours both, so adding them would get me 16 hours for that day, what is completly wrong).
So, am I doing something wrong here? Can you help me, please?