ReportSchema

Introduction

In the new version of ops admin task estimates are added to the timesheet reports. Here is a description of the report that is returned by the ops project webservices, for further processing via xsl by ops admin.

Description

The main element is REPORT, with two child elements: ESTIMATE DATA and vevents.

ESTIMATE DATA has a PROJECT child element for every project mentioned in the vevents. PROJECT has a

• NAME
• GUID
• 0 or many QUOTE TASK

QUOTE TASK has a

• NAME
• ESTIMATE in minutes (may be empty)
• 0 or many =IMPLEMENTATION TASK=s

IMPLEMENTATION TASK has a NAME and TODO and TOTAL estimates in minutes (may be empty).

vevents has 0 or many vevent children, each vevent has the following elements:

• DURATION in minutes
• OWNER
• PROJECT-NAME
• CREATED
• LAST-MODIFIED
• DTSTAMP
• UID
• SUMMARY
• PRIORITY
• CLASS
• DTSTART
• DTEND
• X-LIC-ERROR
• X-OPS-PROJECTTASK
• X-OPS-PROJECTID
• X-OPS-DECLARABLE
• X-OPS-DECLARABLE-DURATION (new)

NB after DeclarableAsPercentage X-OPS-DECLARABLE is an integer [0,100], it was a boolean before. The X-OPS-DECLARABLE-DURATION element is new as of the DeclarableAsPercentage story.

Example

<?xml version="1.0" encoding="UTF-8"?>
<REPORT>
   <ESTIMATE_DATA>
      <PROJECT>
         <GUID> D89136D0-1410-0AAC-FB85-BD3A583A7A73</GUID>
         <NAME> Func Intern</NAME>
         <QUOTE_TASK>
            <NAME> Func Intern</NAME>
            <ESTIMATE> 36000000</ESTIMATE>
            <IMPLEMENTATION_TASK>
               <NAME> intern overleg</NAME>
               <TODO> 60</TODO>
               <TOTAL> 120</TOTAL>
            </IMPLEMENTATION_TASK>
            <IMPLEMENTATION_TASK>
               <NAME> onderhoud pand</NAME>
               <TODO />
               <TOTAL />
            </IMPLEMENTATION_TASK>
         </QUOTE_TASK>
      </PROJECT>
   </ESTIMATE_DATA>
   <vevents>
      <vevent>
         <DURATION> 150</DURATION>
         <OWNER> Dexter Cartoon</OWNER>
         <PROJECT-NAME>Func Intern</PROJECT-NAME>
         <CREATED> 20100206065335</CREATED>
         <LAST-MODIFIED> 20100208064047</LAST-MODIFIED>
         <DTSTAMP> 20100206065335</DTSTAMP>
         <UID> uuid1170784686818</UID>
         <SUMMARY> dexter says:eclipse</SUMMARY>
         <PRIORITY> 0</PRIORITY>
         <CLASS> PUBLIC</CLASS>
         <DTSTART> 20071207013000</DTSTART>
         <DTEND> 20071207040000</DTEND>
         <X-LIC-ERROR> No value for STATUS property. Removing entire property:</X-LIC-ERROR>
         <X-OPS-PROJECTTASK> onderhoud werkplek</X-OPS-PROJECTTASK>
         <X-OPS-PROJECTID> D89136D0-1410-0AAC-FB85-BD3A583A7A73</X-OPS-PROJECTID>
         <X-OPS-DECLARABLE>100</X-OPS-DECLARABLE>
         <X-OPS-DECLARABLE-DURATION>150</X-OPS-DECLARABLE-DURATION>
      </vevent>
   </vevents>
</REPORT>

---

Discussion

-- IvanaCace - 30 Oct 2008