ms project report exports time incorrectly

Discuss problems installing or using TrackStudio.

ms project report exports time incorrectly

Postby TimPigden » Fri Feb 17, 2012 9:35 pm

A task that has 7 hours allocated to it it trackstudio is exported with time as:

<Duration>PT0H0M7S</Duration>

Obviously it ought to be
<Duration>PT7H0M0S</Duration>
TimPigden
 
Posts: 36
Joined: Fri Feb 17, 2012 4:45 pm

Re: ms project report exports time incorrectly

Postby admin » Fri Feb 17, 2012 11:03 pm

TimPigden wrote:A task that has 7 hours allocated to it it trackstudio is exported with time as:

<Duration>PT0H0M7S</Duration>

Obviously it ought to be
<Duration>PT7H0M0S</Duration>


ok, will check.
Maxim Kramarenko (mailto: maximkr@trackstudio.com)
TrackStudio - Hierarchical Bug & Issue Tracking Software
http://www.trackstudio.com
admin
Site Admin
 
Posts: 8148
Joined: Thu Jan 01, 1970 3:00 am
Location: Smolensk, Russia

Re: ms project report exports time incorrectly

Postby admin » Wed Feb 22, 2012 5:00 pm

Hmm, duration is the difference between 2 days, please check ActualCost.
Maxim Kramarenko (mailto: maximkr@trackstudio.com)
TrackStudio - Hierarchical Bug & Issue Tracking Software
http://www.trackstudio.com
admin
Site Admin
 
Posts: 8148
Joined: Thu Jan 01, 1970 3:00 am
Location: Smolensk, Russia

Re: ms project report exports time incorrectly

Postby TimPigden » Wed Feb 22, 2012 5:58 pm

ActualCost is 3600000 - but that's going into a cost field in any case, which doesn't make sense. This is what you are exporting for a 1 hour task

<Task>
<UID>4</UID>
<ID>4</ID>
<Name>test task</Name>
<Type>0</Type>
<IsNull>0</IsNull>
<Contact>Tim Pigden</Contact>
<WBS>1.1.2</WBS>
<OutlineNumber>1.1.2</OutlineNumber>
<OutlineLevel>3</OutlineLevel>
<Priority>500</Priority>
<Start>2012-02-22T13:22:00</Start>
<Duration>PT0H0M24S</Duration>
<DurationFormat>5</DurationFormat>
<Work>PT0H0M0S</Work>
<ResumeValid>0</ResumeValid>
<EffortDriven>0</EffortDriven>
<Recurring>0</Recurring>
<OverAllocated>0</OverAllocated>
<Estimated>0</Estimated>
<Milestone>0</Milestone>
<Summary>0</Summary>
<Critical>1</Critical>
<IsSubproject>0</IsSubproject>
<IsSubprojectReadOnly>0</IsSubprojectReadOnly>
<ExternalTask>0</ExternalTask>
<StartVariance>0</StartVariance>
<FinishVariance>0</FinishVariance>
<WorkVariance>0</WorkVariance>
<FreeSlack>0</FreeSlack>
<TotalSlack>0</TotalSlack>
<FixedCost>0</FixedCost>
<FixedCostAccrual>3</FixedCostAccrual>
<PercentComplete>0</PercentComplete>
<Cost>7200000</Cost>
<OvertimeCost>0</OvertimeCost>
<OvertimeWork>PT0H0M0S</OvertimeWork>
<ActualStart>2012-02-22T13:22:00</ActualStart>
<ActualDuration>PT0H0M0S</ActualDuration>
<ActualCost>3600000</ActualCost>
<ActualOvertimeCost>0</ActualOvertimeCost>
<ActualWork>PT0H0M0S</ActualWork>
<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
<RegularWork>PT3600H0M0S</RegularWork>
<RemainingDuration>PT0H0M24S</RemainingDuration>
<RemainingCost>0</RemainingCost>
<RemainingWork>PT0H0M0S</RemainingWork>
<RemainingOvertimeCost>0</RemainingOvertimeCost>
<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
<ACWP>0</ACWP>
<CV>0</CV>
<ConstraintType>0</ConstraintType>
<CalendarUID>-1</CalendarUID>
<LevelAssignments>0</LevelAssignments>
<LevelingCanSplit>0</LevelingCanSplit>
<Hyperlink>http://localhost:8888/TrackStudio/task/316</Hyperlink>
<HyperlinkAddress>http://localhost:8888/TrackStudio/task/316</HyperlinkAddress>
<IgnoreResourceCalendar>0</IgnoreResourceCalendar>
<Notes>Task #316&#xD;
this is description</Notes>
<HideBar>0</HideBar>
<Rollup>0</Rollup>
<BCWS>0</BCWS>
<BCWP>0</BCWP>
<EarnedValueMethod>0</EarnedValueMethod>
<ActualWorkProtected>PT0H0M0S</ActualWorkProtected>
<ActualOvertimeWorkProtected>PT0H0M0S</ActualOvertimeWorkProtected>
</Task>
</Tasks>
<Resources>
<Resource>
<UID>1</UID>
<ID>1</ID>
<Name>Tim Pigden</Name>
<IsNull>0</IsNull>
<Group>Administrator</Group>
<EmailAddress></EmailAddress>
<MaxUnits>1</MaxUnits>
<PeakUnits>1</PeakUnits>
<OverAllocated>0</OverAllocated>
<CanLevel>0</CanLevel>
<Work>PT0H0M0S</Work>
<RegularWork>PT0H0M0S</RegularWork>
<OvertimeWork>PT0H0M0S</OvertimeWork>
<ActualWork>PT0H0M0S</ActualWork>
<RemainingWork>PT0H0M0S</RemainingWork>
<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
<PercentWorkComplete>0</PercentWorkComplete>
<StandardRateFormat>3</StandardRateFormat>
<Cost>0</Cost>
<OvertimeRateFormat>3</OvertimeRateFormat>
<OvertimeCost>0</OvertimeCost>
<CostPerUse>0</CostPerUse>
<ActualCost>0</ActualCost>
<ActualOvertimeCost>0</ActualOvertimeCost>
<RemainingCost>0</RemainingCost>
<RemainingOvertimeCost>0</RemainingOvertimeCost>
<WorkVariance>0</WorkVariance>
<CostVariance>0</CostVariance>
<SV>0</SV>
<CV>0</CV>
<ACWP>0</ACWP>
<Notes></Notes>
<BCWS>0</BCWS>
<BCWP>0</BCWP>
<IsGeneric>0</IsGeneric>
<IsInactive>0</IsInactive>
<IsEnterprise>0</IsEnterprise>
<ActualWorkProtected>PT0H0M0S</ActualWorkProtected>
<ActualOvertimeWorkProtected>PT0H0M0S</ActualOvertimeWorkProtected>
</Resource>
</Resources>
<Assignments>
<Assignment>
<UID>0</UID>
<TaskUID>4</TaskUID>
<ResourceUID>1</ResourceUID>
<ActualCost>0</ActualCost>
<ActualWork>PT3600H0M0S</ActualWork>
<Cost>0</Cost>
<Delay>0</Delay>
<OvertimeWork>PT0H0M0S</OvertimeWork>
<RemainingWork>PT0H0M0S</RemainingWork>
<Start>2012-02-22T13:22:00</Start>
<Units>544320</Units>
<Work>PT3600H0M0S</Work>
</Assignment>
</Assignments>

You will see that the work is set to 3600 Hours in the assignment - which it doesn't like. Also Actual work on assignment is wrong
But in the task you are setting the ActualCost to 3600000 - which is a money field and you are setting ActualWork to zero.

I think it's just wrong and needs proper testing your end. Which version of MS Project has this been tested against?
TimPigden
 
Posts: 36
Joined: Fri Feb 17, 2012 4:45 pm

Re: ms project report exports time incorrectly

Postby Petr » Thu Apr 19, 2012 12:17 pm

Hello
Can you help us with this question?
Actually I don't have enough experience with MS and another developer who did this code too. For this reason we used an ActualCost field like spend time.
So can you tell us what field more appropriate for this aim?

Kind regards
Стань Java программистом с www.job4j.ru
Petr
 
Posts: 2929
Joined: Wed Aug 12, 2009 4:38 pm


Return to TrackStudio Support

Who is online

Users browsing this forum: No registered users and 6 guests

cron