Resource Xog preparation

·         Replace "" to "

·         Replace "

·         Replace

" to

·         Convert to XML in notepad++

·         Remove if there Is no value for terminationDate=""  (Reason: XOg will through error)

·         Remove if there is no value for hireDate="" (Reason: XOg will through error)

·         Top of the file include

o   http://www.w3.org/2001/XMLSchema-instance

" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_resource.xsd">

o  

o  

·         Bottom of the file include

o  

o  

·         Include regular expression to search for hiredate to replace UAT date or production date.

Findwhat: hireDate=(............)                  

Replace: hireDate="2016-05-17"

·         Replace trackmode to clarity after upload of actuals

o   Findwhat:trackMode="Clarity"

o   Replace:trackMode="None"

·         Keep dummy email

o   Replace @ts.com to @ts_123.com

Remove : Primary role id, availability 

Department wrong will not work 

Location not linked with department will not work 

Manager id blank will work 

·         Replace & to &

User (Convert from XLS to XML)

·         Replace "" to "

·         Replace "

·         Replace

" to

·         Convert to XML in notepad++

·         Keep dummy email

o   Replace @philips.com to @philips_123.com

·         Top of the file include

o   http://www.w3.org/2001/XMLSchema-instance

" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd">

o  

o  

·         Bottom of the file include

o  

o  

Read Multiple values through XOG

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
  <Header version="13.2.0.472" action="read" objectType="project" externalSource="NIKU">
    <args name="include_tasks" value="true"/>
</Header>
  <Query>
      <Filter name="projectID" criteria="OR">Bala123,Bala1234</Filter>
  </Query>
</NikuDataBus>


OR is differentiating factor to retrieve multiple values.

Reading and Writing XOG using Windows Client in Clarity 13

1. Install windows installer for XML gateway

2.after installing you can find the installer created bin folder.

3. configure input xml and output xml in the properties file 

Note: You can specify multiple input file, but only one out put file.

4. Execute below command 

XOGGING different way in clarity

1. Xog UI Client (Which is not applicable after 13.2)
2. XOG Client (Windows and you can use below two command )
      1. XOG Command
      2. Run command
3. XOG Logger

Custom object XOG

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

  <Header version="8.0" action="read" objectType="customObjectInstance" externalSource="NIKU"/>

  <CustomObjectInstanceQuery>

    <Filter name="objectCode" criteria="EQUALS">z_interfaceconfig</Filter>

    <Filter name="instanceCode" criteria="OR">00005234</Filter>

  </CustomObjectInstanceQuery>

</NikuDataBus>

Object code : Object ID

Instance code = instance of the id

Project Upload Using XOG in Clarity

Project Upload Using XOG.

prj_projects_read
prj_projects_write

These two XOG need to use for XOG ing the project in to clarity.

We were facing one issue in one of the attribute called "proj_lifecycle_legd"

Error

Validation failure. Attribute: proj_lifecycle_legd. Cause: range

This is caused due to the length of the attribute in development and finally increased and got worked.

Happy coding 

Bala

Retrieving Multiple Roles through XOG out

<div dir="ltr" style="text-align: left;" trbidi="on"&rt; <div dir="ltr" style="text-align: left;" trbidi="on"&rt; <br /&rt; <nikudatabus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nonamespaceschemalocation="../xsd/nikuxog_read.xsd"&rt;</nikudatabus&rt;<br /&rt;   <br /&rt; <header action="read" externalsource="NIKU" objecttype="role" version="7.5"&rt;</header&rt;<br /&rt;   <query&rt;</query&rt;<br /&rt;  <filter criteria="OR" name="resourceId"&rt;CMS0001,CMS0002,BGUM_FO,APMDPASS,CMS0003,BGUM_US_Rolename,BGUM_US Rolename,CMS0004,CMS0005,CMS0071,CMS0006,CMS0007,CMS0066,CMS0008,CMS0009,CMS0010,CMS0011,CMS0012,CMS0013,CMS0014,CMS0015,CMS0016,CMS0017,CMS0018,CMS0019,PMD04599,CMS0020,CMS0021,CMS0022,CMS0023,ggggg,CMS0024,CMS0025,MS0026,CMS0068,CMS0027,CMS0028,CMS0029,CMS0030,CMS0031,CMS0032,CMS0033,CMS0034,CRS17157,CMS0035,MCS09573,CMS0036,CMS0063,CMS0037,CMS0038,CMS0067,CMS0039,CMS0062,CMS0040,CMS0070,CMS0041,CMS0042,CMS0043,CMS0044,CMS0045,CMS0069,CMS0046,CMS0047,CMS0048,CMS0049,CMS0050,CMS0051,CMS0052,CMS0053,CMS0054,CMS0055,CMS0056,CMS0057,CMS0058,CMS0059,CMS0060,CMS0072,CMS0061</filter&rt;<br /&rt;   </div&rt; <br /&rt; <br /&rt; Note: Don't give any gap in between resourceid.<br /&rt; <br /&rt; Happy Coding.</div&rt;