Dave, I figured out how do both create and update timesheet using XOG:
To create a timesheet where no timesheet exists in the time period - Put in “-1” in the timesheet id field. The action needs to be “add”. Version is 1. Status is “0”
To update actuals in a timesheet - Put in the timesheet id into the timesheet id field. The action needs to be “replace”. Version and Status will be based on what is specified in the prtimesheet table.
We will be applying this logic to prepopulate STAT holidays.
Here is the script that I applied:
<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">
<Header version="6.0.11" action="write" objectType="timeperiod" externalSource="NIKU"/>
<TimePeriods>
<TimePeriod finish="2010-11-06T00:00:00" start="2010-10-31T00:00:00">
<TimeSheets>
<TimeSheet ID="-1" resourceID="resourceid" version="1" action="add" status="0">
<TimeSheetEntries>
<TimeSheetEntry projectID="STAT" assignmentEstimate="0" assignmentPendingEstimate="0" assignmentID="5001606" assignmentStart= "2010-10-24T00:00:00" chargeCodeID="NONITD" assignmentFinish="2010-10-31T00:00:00" taskID="~rmw">
<DailyActuals>
<Actual actualDate="2010-10-24" amount="1"/>
<Actual actualDate="2010-10-31" amount="2"/>
<Actual actualDate="2010-11-01" amount="3"/>
<Actual actualDate="2010-11-02" amount="4"/>
<Actual actualDate="2010-11-03" amount="5"/>
<Actual actualDate="2010-11-04" amount="6"/>
<Actual actualDate="2010-11-05" amount="7"/>
</DailyActuals>
</TimeSheetEntry>
</TimeSheetEntries>
<Notes>
<NoteData noteText="test” createdBy="resourceid" createdTime="2010-11-05T16:52:18" category="NoteCat"/>
</Notes>
</TimeSheet>
</TimeSheets>
</TimePeriod>
</TimePeriods>
</NikuDataBus>