PSI - Statusing Web Service - Update results not as expected

20 martie 2012 15:25

Hello!

I'm trying to update Status information on assignments via Statusing Web Service (PSI). Problem is, that the results are not as expected. I'll try to explain what I'm doing in detail:

Two cases:

1) An assignment for the resource exists on specified tasks. I want to report work actuals (update status).

2) There is no assignment for the resource on specified tasks. I want to create the assignment and report work actuals.

I have one task in my project (Auto scheduled, Fixed work). Resource availability of all resources is set to 100%. They all have the same calendar.

Task Name	Duration	Start	Finish	Predecessors	Resource Names	Work
Task 31 - Fixed Work	12,5 days?	Thu 14.03.13	Tue 02.04.13		Resource 1	100 hrs

In case one I execute an UpdateStatus with the following ChangeXML

<Changes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Proj ID="a8a601ce-f3ab-4c01-97ce-fecdad2359d9">
<Assn ID="d7273a28-c038-486b-b997-cdb2450ceef5" ResID="8a164257-7960-4b76-9506-ccd0efabdb72">
<Change PID="251658250">900000</Change>
</Assn>
</Proj>
</Changes>

Then I call a SubmitStatusForResource

client.SubmitStatusForResource(new Guid("8a164257-7960-4b76-9506-ccd0efabdb72"), null, "auto submit PSIStatusingGateway");

The following entry pops up in approval center (which looks alright at this point):

Approval Type - Name - Update Type - Resource - Send Date - Total - % Complete - Remaining
Status Update - Task 31 - Task update - Resource 1 - 3/20/2012 - 15h - 15% - 85h

Update in Project (still looks fine):

Task Name	Duration	Start	Finish	Predecessors	Resource Names	Work	Actual Work	Remaining Work
Task 31 - Fixed Work	12,5 days?	Thu 14.03.13	Tue 02.04.13		Resource 1	100 hrs	15 hrs	85 hrs

Then second case is executed:
First I create a new assignment...

client.CreateNewAssignmentWithWork(
                            sName: Task 31 - Fixed Work,
                            projGuid: "a8a601ce-f3ab-4c01-97ce-fecdad2359d9",
                            taskGuid: "024d7b61-858b-40bb-ade3-009d7d821b3f",
                            assnGuid: "e3451938-36a5-4df3-87b1-0eb4b25a1dab",
                            sumTaskGuid: Guid.Empty,
                            dtStart: 14.03.2013 08:00:00,
                            dtFinish: 02.04.2013 15:36:00,
                            actWork: 900000,
                            fMilestone: false,
                            fAddToTimesheet: false,
                            fSubmit: false,
                            sComment: "auto commit...");

Then I call the UpdateStatus again:

<Changes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Proj ID="a8a601ce-f3ab-4c01-97ce-fecdad2359d9">
<Assn ID="e3451938-36a5-4df3-87b1-0eb4b25a1dab" ResID="c59ad8e2-7533-47bd-baa5-f5b03c3c43d6">
<Change PID="251658250">900000</Change>
</Assn>
</Proj>
</Changes>

And finally the SubmitStatusForResource again

client.SubmitStatusForResource(new Guid("c59ad8e2-7533-47bd-baa5-f5b03c3c43d6"), null, "auto submit PSIStatusingGateway");

This creates the following entry in approval center:
Status Update; Task 31 - Fixed Work; New reassignment request; Resource 2; 3/20/2012; 15h; 100%; 0h

I accept it and update my project:

Task Name	Duration	Start	Finish	Predecessors	Resource Names	Work	Actual Work	Remaining Work
Task 31 - Fixed Work	6,76 days?	Thu 14.03.13	Mon 25.03.13		Resource 1;Resource 2	69,05 hrs	30 hrs	39,05 hrs

Task Usage:

Task Name	Work	Start	Finish	Actual Work	Work	Remaining Work
Task 31 - Fixed Work	69,05 hrs	Thu 14.03.13	Mon 25.03.13	30 hrs	69,05 hrs	39,05 hrs
Resource 2	15 hrs	Thu 14.03.13	Fri 15.03.13	15 hrs	15 hrs	0 hrs
Resource 1	54,05 hrs	Thu 14.03.13	Mon 25.03.13	15 hrs	54,05 hrs	39,05 hrs

And I really don't get, why the new work would be 69,05 hours. I'd like to know how I must set my values when updating status to get results that I expect:

Task Name	Work	Start	Finish	Actual Work	Work	Remaining Work
Task 31 - Fixed Work	69,05 hrs	Thu 14.03.13	Mon 25.03.13	30 hrs	65 hrs	35 hrs
Resource 2	15 hrs	Thu 14.03.13	Fri 15.03.13	15 hrs	15 hrs	0 hrs
Resource 1	54,05 hrs	Thu 14.03.13	Mon 25.03.13	15 hrs	50 hrs	35 hrs

I really would appreciate some help. This makes me want to rip my hair out!

Thanks in advance

Brigitte

PS: Forgot to say that I'm working with MS Project Server 2010 and MS Project Professional 2010

Editat de Brigitte Goessler 20 martie 2012 15:27
Editat de Brigitte Goessler 20 martie 2012 15:29
Editat de Brigitte Goessler 20 martie 2012 15:30

Toate mesajele

21 martie 2012 12:52

0

Hm... seems that could narrow down this odd (at least for me) behaviour a bit... it looks like it has something to do with the order I approve the updates. I'll post again, when I confirmed my suspicions.
- Mesaj
- Citare