Clarity

  • 1.  Updating existing record with XOG

    Posted Mar 26, 2018 02:49 PM

    I am very new to XOG and I am trying to update fields in a record with new values.  See code below

     

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
    <Header version="12.0" action="write" objectType="project" externalSource="NIKU" />
    <Projects>
    <Project fromTemplate="Test" projectID="123403269" name="Ability to Repay Alignment" start="2017-12-29T00:00:00" finish="2018-05-10T17:00:00" budgetCostStart="2017-12-29T00:00:00" budgetCostFinish="2018-05-10T17:00:00" plannedCostStart="2017-12-29T00:00:00" plannedCostFinish="2018-05-10T17:00:00" entityCode="Corporate"  >
    <CustomInformation>
    <ColumnValue name="client">1234 - Wash</ColumnValue>
    <ColumnValue name="finance">Testing</ColumnValue>
    </CustomInformation>
    <General addedBy="admin" addedDate="2018-03-26"/>
    <OBSAssocs>
    </OBSAssocs>
    </Project>

    </Projects>
    </NikuDataBus>

     

    We are getting no errors it says

    1 record inserted

    Total 1

    Updates 0

     

    Any help would be appriciated



  • 2.  Re: Updating existing record with XOG
    Best Answer

    Posted Mar 26, 2018 03:59 PM

    The message is saying that a new record was created, that is no update.

    That suggest that the project ID and name were not correct.

    Read the project out to verify them.

    When I do updates  I just write the required fields and the field to updated.

    For project the required attributes in an update are

     

      <Project     projectID="zproject"     name="zproject">

     

    You can also leave

    " addedDate="2018-03-26"

    out as the system will generate that.



  • 3.  Re: Updating existing record with XOG

    Posted Mar 29, 2018 06:04 PM

    urmas - thanks for your help we managed to get the update to work.