Time Reporting Periods Question

[Arunachalam Angusamy]

Hello Everyone, 

Is there a way that I can create a weekly time reporting periods in excel and upload in Clarity ?

[Debroop Dasgupta]

Hello Arunachalam, 

You will have to convert the excel into the acceptable XOG format for creating a time period. Please review the sample xml file for reading time periods (prj_timeperiods_read.xml) to get a sample write XML. Add attributes for creating the time period and the scale and then do a mapping with your excel. Here is a sample XML write file for creating a single weekly time period: 

<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.7.0.212" />
<TimePeriods>
<TimePeriod finish="2020-04-12T00:00:00" openForTimeEntry="true" start="2020-04-06T00:00:00" create="true" scale="weekly" />
</TimePeriods>
</NikuDataBus>

Now, some very important guidance: 

• Please test on a lower environment before you run your XOG on production. 
• Any mistakes in creating time periods can prove very costly (if found later). So, please thoroughly review the Start and End Dates of all periods created to ensure they have been correctly created. 

Thanks,
Regards,

Debroop

[Martti Kinnunen]

Why would you want to do that?
Do you fully understand how easy it is and little effort it takes to create them manually?
See
https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?GroupId=1747&MessageKey=d2d7c5e4-4475-4ec6-88dc-b9aaa3316442&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer&ReturnUrl=%2fenterprisesoftware%2fcommunities%2fcommunity-home%2fdigestviewer%3fCommunityKey%3d7f0cbca3-5f93-4d44-a369-1a8ce98f5578

[David Morton]

Creating weekly time reporting periods is a IMPORTANT system setup, it is also a TRIVIAL thing to do in the system.

Why anyone would think it is a useful thing to have an automated interface to do is confusing to me.

(please refer to the other thread linked by Martti)