Is it possible to XOG Time Reporting periods in 13.3 version of CA Clarity ?
Is it possible to XOG Time Reporting periods in 13.3 version of CA Clarity ?
Hi SiddiqSyed,
Unfortunately, I don't have 13.3 version of CA Clarity.
In 15.3 version, there is sample xml file for time periods.
Please search prj_timeperiods_read.xml sample file in <XOG installed directory>/xml directory.
I think it maybe also provided in 13.3 version.
It will return large xogout, so please use Filter as following.
<Filter name="start" criteria="BETWEEN">2017-01-01, 2017-01-31</Filter>
<Filter name="resourceID" criteria="EQUALS">******</Filter>
Regards,
Shoichi
Hi Shoichi_Sugawara,
Let me thank you first for your reply.
We already tried with the prj_timeperiods_read.xml file. But no luck.
Regards,
Siddiq
Hi Siddiq,
Please check ADMINISTRATION->Project Management->Time Reporting Periods.
You will find existing time periods which status is Open.
ex) If there is time period for Start Date = 2017/12/18, you will be able to use xogout it by using the following xml.
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="6.0.11" action="read" objectType="timeperiod" externalSource="NIKU"/>
<Query>
<Filter name="start" criteria="EQUALS">2017-12-18</Filter>
</Query>
</NikuDataBus>
Regards,
Shoichi
Hi Shoichi,
When we followed the above procedure, the write file as below without any records.
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd"><Header action="write" externalSource="NIKU" objectType="timeperiod" version="13.3.0.286"/>
<TimePeriods>
</TimePeriods>
<XOGOutput> <Object type="TimePeriods"/> <Status state="SUCCESS"/> <Statistics insertedRecords="0" failureRecords="0" totalNumberOfRecords="0" updatedRecords="0"/> <Records/>
</XOGOutput>
</NikuDataBus>
Read file
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="6.0.11" action="read" objectType="timeperiod" externalSource="NIKU"/>
<Query>
<Filter name="start" criteria="EQUALS">2017-12-18</Filter>
</Query>
</NikuDataBus>
Hi Siddiq,
Could you view time period data of 2017-12-18 in ADMINISTRATION->Project Management->Time Reporting Periods.
If it is not there, xog will not bring it.
Your Read file shows below data in my environment.
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">
<Header action="write" externalSource="NIKU" objectType="timeperiod" version="15.3.0.200"/>
<TimePeriods>
<TimePeriod finish="2017-12-25T00:00:00" openForTimeEntry="true" start="2017-12-18T00:00:00"/>
</TimePeriods>
<XOGOutput>
<Object type="TimePeriods"/>
<Status state="SUCCESS"/>
<Statistics insertedRecords="0" failureRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>
I hope it is helpful for your investigation.
Regards,
Shoichi
Just wondering again...
Even though the file name is prj_timeperiods_read.xml I think that it really does not read time reporting periods but timeentries. That is if there are no timeentries no results. If there are timeentries for that time reporting period the timesheets with their timeentries will be read.
My recollection is that the time reporting periods cannot be XOGed in v13.3
urmas wrote:
.....That is if there are no timeentries no results....
Ahh but Shoichi posted the result XML from his read, and there is an 'empty' Time Period in there....?
--
You could try a date range in the XOG read (as per the sample XML read file);
<Filter name="start" criteria="BETWEEN">2017-21-01, 2017-12-31</Filter>
I did not get any results if there were no timesheets. EDIT That is not like Shoichi
If there was a saved time sheet in the period and that had a task on it with not time entered (saved with daily zeros and zero weekly total) it would show up in results.
Hmmm yes ; just actually tried it rather than guessing and I agree with you ; the read needs to bring back a timesheet as well to get any data. Wonder how Shoichi got those results then (fixed in a later version perhaps?)
Apparently it has been changed (and of course documented in Change and impact guide)
In 15.3 I do get the same as Shoichi
Time reporting periods
With input file
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="6.0.11" action="read" objectType="timeperiod" externalSource="NIKU"/>
<Query>
<!-- <Filter name="start" criteria="EQUALS">2017-12-18</Filter> -->
<Filter name="start" criteria="BETWEEN">2017-10-30, 2017-12-31</Filter>
</Query>
</NikuDataBus>
I get output
<Header action="write" externalSource="NIKU" objectType="timeperiod" version="15.3.0.200"/>
<TimePeriods>
<TimePeriod finish="2017-11-06T00:00:00" openForTimeEntry="true" start="2017-10-30T00:00:00"/>
<TimePeriod finish="2017-11-13T00:00:00" openForTimeEntry="true" start="2017-11-06T00:00:00"/>
<TimePeriod finish="2017-11-20T00:00:00" openForTimeEntry="true" start="2017-11-13T00:00:00"/>
<TimePeriod finish="2017-11-27T00:00:00" openForTimeEntry="true" start="2017-11-20T00:00:00"/>
<TimePeriod finish="2017-12-04T00:00:00" openForTimeEntry="true" start="2017-11-27T00:00:00"/>
<TimePeriod finish="2017-12-11T00:00:00" openForTimeEntry="true" start="2017-12-04T00:00:00"/>
<TimePeriod finish="2017-12-18T00:00:00" openForTimeEntry="true" start="2017-12-11T00:00:00"/>
<TimePeriod finish="2017-12-25T00:00:00" openForTimeEntry="true" start="2017-12-18T00:00:00"/>
<TimePeriod finish="2018-01-01T00:00:00" openForTimeEntry="true" start="2017-12-25T00:00:00"/>
</TimePeriods>
<XOGOutput>
<Object type="timeperiod"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
<Records/>
</XOGOutput>
Those are timeperiods with no timesheets.
If there is a timeseet (even without any tasks of timeentries just opened in the GUI) I get also data relative to that
<Header action="write" externalSource="NIKU" objectType="timeperiod" version="15.3.0.200"/>
<TimePeriods>
<TimePeriod finish="2017-12-18T00:00:00" openForTimeEntry="true" start="2017-12-11T00:00:00"/>
<TimePeriod finish="2017-12-25T00:00:00" openForTimeEntry="true" start="2017-12-18T00:00:00">
<TimeSheets>
<TimeSheet ID="5002003" lastModified="2017-12-19T19:50:11" resourceID="kinnunenad" status="0" version="1">
<TimeSheetEntries/>
<Notes/>
</TimeSheet>
</TimeSheets>
</TimePeriod>
</TimePeriods>
<XOGOutput>
<Object type="timeperiod"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>
Hi
Clarity 13.X doesn't support to create the time periods through XOG Operation. It supports from clarity 14.x onward.
Thanks
Senthil
I did not get any results if there were no timesheets. EDIT That is not like Shoichi
If there was a saved time sheet in the period and that had a task on it with not time entered (saved with daily zeros and zero weekly total) it would show up in results.