search cancel

Cannot update task start and finish date using Clarity PPM XOG

book

Article ID: 187297

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

We need to update start and finish dates on tasks using XOG and the XOG below does not work, the dates do not change.

This is the update message after executing the XOG:
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">  <Header action="write" externalSource="NIKU" objectType="project" version="6.0.11"/>
<Projects>
<Project name="project01" projectID="prj01">
<Tasks>
<Task name="task1" taskID="task1" outlineLevel="1" start="2018-01-03T00:00:00" finish="2019-11-15T00:00:00"/>
</Tasks>
</Project>
</Projects>
</NikuDataBus>

XOG Results:
- No error is recorded
- The XOG output states SUCCESS and correct number of updated Records:
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="project"/>
  <Status elapsedTime="0.437 seconds" state="SUCCESS"/>
  <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="1"/>
  <Records/>
</XOGOutput>

Environment

CA PPM APPLICATION

Resolution

Try using the OOTB XOG template called "prj_projects_read.xml" and with it you can attempt to update start and finish dates on tasks with the fields provided in the OOTB XML template files that are required to be able to create tasks by XOG.

Additional Best Practices:
- When updating Tasks dates with Assignments, don't forget to update Assignments dates too.
- You may need to include other required fields like TaskLabor and ResourceID (For reference here is the our documentation on the OOTB XML templates - XOG Schema, Sample XML Files, and Special Characters.)
  <Tasks>
    <Task name="task1" taskID="task1" outlineLevel="1" start="2020-03-25T17:00:00" finish="2020-03-26T17:00:00">
     <Assignments>
      <TaskLabor finish="2020-03-26T17:00:00" lastUpdatedBy="admin" lastUpdatedDate="2020-03-23T14:12:47" resourceID="user1">
      </TaskLabor>
     </Assignments>
    </Task>  
  </Tasks>

Communities - Cannot update task start and finish date using XOG