Clarity

When i want to xog in some data attributes of resource through a gel script, it does not update the records.

Please find below the gel script used with xml script:

Select CMN.USER_NAME ,CMN.FIRST_NAME,CMN.LAST_NAME,SRM.EXTERNAL_ID,srm.email,srm.unique_name

                    from cmn_sec_users cmn, srm_resources srm

                    where CMN.ID=SRM.USER_ID

                    and cmn.user_name='${row_cc[6]}'

                     </sql:query>

                    <core:forEach items="${xog_res.rowsByIndex}" trim="true" var="xog_res">

                    <gel:log> through query '${xog_res[1]}'</gel:log>

                    <gel:log> ${xog_res[4]} ${xog_res[0]} ${xog_res[5]}""${xog_res[2]}""${xog_cc}" </gel:log>

                    <gel:log> xogging the found records of the resources</gel:log>

                    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_resource.xsd"><Header action="write" externalSource="NIKU" objectType="resource" version="14.2.0.237"/>

                    <Resources>                                   

                    <Resource externalId="${xog_res[3]}" resourceId="${xog_res[5]}" username="${xog_res[0]}">                   

                    <PersonalInformation emailAddress="${xog_res[4]}" firstName="${xog_res[1]}" lastName="${xog_res[2]}"/>                       

                    <OBSAssocs complete="false">                       

                    <OBSAssoc id="CCOBS" name="SC_Cost Center" unitPath="${xog_cc}"/>

                    </OBSAssocs>                   

                    </Resource>

                    </Resources>

                   </NikuDataBus>

Please let me know the reason behind this

Regards,

Jerish

The code you have posted does not "do" a XOG write?

(some example XOG from GEL files are in the Gel.zip file attached to the FAQ thread ; CA Clarity General Discussion - FAQs  )

David,

I am unable to find the zip file you mentioned.

can you please let me know where do i go wrong in my script provided.? As the same xog in file if run plainly executes and updated the data.

But when placed in script the script does not throw error..also the data is not updated too..

So i am unable to analyse as to where it has gone wrong.

Regards

Jerish

Also the <gel:parse> is included now in the syntax tag

If you go to that FAQ thread and look at the first post (the big long FAQ post) - at the bottom there is an attachment.

This link might work too ; https://communities.ca.com/servlet/JiveServlet/download/2297925-48932/Gel.zip

--

Your "script" is not passing the XML to XOG, - i.e. your script "does nothing" other than write some lines to the log file. There is a lot of missing code.