Clarity

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

Hi All,

Anyone have any ideas here for Jair?

Thanks!
Chris

Are the resource, task and project open for time entry?

Everything is open for timeentry, the weird thing is the message:

<Description>XOG-2022: The timesheet you are uploading has time logged against the task Define Requirements under project PID_2012_0032 ((5003349)).</Description>

Like if there were existing actuals on the projects, but there aren't, not even a single timesheet or transaction.

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

So the timeshee ID indicates it is new
while approvedBy, LastModified and submittedBy indicate that it is already approved in the the system
and status indicates it is already submitted.

Are trying to create the timesheet and enter actuals at the same time

That does not sound right

Have you searched this forum?
XOG - (adjustment timesheets)
10044560

Martti K.

Jair,
You are not going to be able to extract timesheet data from one environment and just xog in to another as the internal task ids, plus assignment ID's will not match.
i think your approach is incorrect. We have done several timesheet migrations in the past, and the methodology that you have chosen, is the most difficult in my opinion.
if you plan to use your aproach, i recomend that you utilize XSLT to transform the ID's from the source to the target.
i would recomend that you generate the timesheet xog files dynamically from the source via a query.
Cheers,
Federico