Dave,
Yeah it must not work for custom objects. I can read them out and then write them back in with the new values. Just wanted to see if there was an easier way. I heard that there was some kind of gel tag you could include that would tell the custom object instances not to overwrite what values were already in there. I'll try to more clearly explain what I'm doing....
Here is the output of a write via the xog client:
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">
<Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="13.3.0.286"/>
<customObjectInstances objectCode="prj_inst_rights">
<instance instanceCode="00000006" objectCode="prj_inst_rights">
<CustomInformation>
<ColumnValue name="prj">
<Value>5003758</Value>
<Value>5006985</Value>
<Value>5007196</Value>
<Value>5007404</Value>
<Value>5010853</Value>
<Value>5087751</Value>
<Value>5106745</Value>
<Value>5180747</Value>
<Value>5183769</Value>
<Value>5184769</Value>
<Value>5210744</Value>
<Value>5210749</Value>
<Value>5236751</Value>
<Value>5237763</Value>
<Value>5238745</Value>
<Value>5238746</Value>
<Value>5238747</Value>
<Value>5239744</Value>
<Value>5253768</Value>
<Value>5254782</Value>
</ColumnValue>
There are multiple values for the column name "prj".
In my gel script, I just include the new value to add to the prj column, and it was my understanding it would just insert a new record into that column.
<gel:parse var="update_prj_inst_rights">
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">
<Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="13.3.0.286"/>
<customObjectInstances objectCode="prj_inst_rights">
<instance instanceCode="${ir_unique_code}" objectCode="prj_inst_rights">
<CustomInformation>
<ColumnValue name="prj">
<Value>${prj_id}</Value>
</ColumnValue>
<ColumnValue name="assign">false</ColumnValue>
<ColumnValue name="res">${prj_mgr_racf}</ColumnValue>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
<ColumnValue name="name">${ir_unique_code}</ColumnValue>
<ColumnValue name="code">${ir_unique_code}</ColumnValue>
<ColumnValue name="page_layout">odf.prj_inst_rightsFrame</ColumnValue>
<ColumnValue name="odf_period_start"/>
<ColumnValue name="odf_period_end"/>
</CustomInformation>
<OBSAssocs complete="false"/>
</instance>
</customObjectInstances>
</NikuDataBus>
</gel:parse>
Everytime I run my gel script, it takes the value for prj_id and overwrites whatever values were previously stored in the prj column. Does that make more sense? Thanks!