AnsweredAssumed Answered

Migrate timesheets to a new environment

Question asked by JairFloresDC on Jul 27, 2012
Latest reply on Sep 15, 2012 by fpena
Hello,

I've been trying to get some timesheets imported into a new system, I get them out from the old one using the prj_timeperiods_read.xml

Now I can't get them loaded into the new system, all projects are clean as per timeentries, here is an small example of my XOG


<!-- edited with XMLSpy v2011 sp1 (x64) (http://www.altova.com) by TeaM DJiNN (TeaM DJiNN) -->
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">

<Header action="write" externalSource="NIKU" objectType="timeperiod" version="12.1.1.1208"/>

<TimePeriods>


<TimePeriod finish="2012-01-09T00:00:00" openForTimeEntry="false" start="2012-01-02T00:00:00">



<TimeSheets>




<TimeSheet ID="-1" approvedBy="5002001" lastModified="2012-01-20T16:00:00" resourceID="tmember" status="1" submittedBy="5002001" version="1" action="add">





<TimeSheetEntries>






<TimeSheetEntry assignmentEstimate="0" assignmentEstimateForTimePeriod="0" assignmentFinish="2012-01-20T17:00:00" assignmentID="5005014" assignmentPendingEstimate="0" assignmentStart="2012-01-04T08:00:00" internalTaskID="5009199" projectID="PID_2012_0032" projectName="Demonstrate Project 02" roleID="SAP_abap_programmer" taskID="DEF01" taskName="Define Requirements" totalActuals="16">







<DailyActuals>








<Actual actualDate="2012-01-02" amount="0"/>








<Actual actualDate="2012-01-03" amount="0"/>








<Actual actualDate="2012-01-04" amount="4"/>








<Actual actualDate="2012-01-05" amount="4"/>








<Actual actualDate="2012-01-06" amount="4"/>








<Actual actualDate="2012-01-07" amount="4"/>








<Actual actualDate="2012-01-08" amount="0"/>







</DailyActuals>






</TimeSheetEntry>





</TimeSheetEntries>





<Notes/>




</TimeSheet>



</TimeSheets>


</TimePeriod>

</TimePeriods>

<XOGOutput>


<Object type="timeperiod"/>


<Status state="SUCCESS"/>


<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="2982" updatedRecords="0"/>


<Records/>

</XOGOutput>
</NikuDataBus>


And this is the output

<?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Severity>FATAL</Severity>
<Description>XOG-2022: The timesheet you are uploading has time logged against the task Define Requirements under project PID_2012_0032 ((5003349)).</Description>
<Object type="timeperiod"/>
<Status elapsedTime="0.096 seconds" state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="1" totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>



that's very weird because there are no timesheets in the system yet and no actuals for any project, any ideas?

Thanks,
Jair

Outcomes