Clarity

Is there a way to update project data without sending allocations? I tried that and it deletes existing allocations using XOG. We have thousands of projects that need to be updated.

In the gel script you should xog out the entire project, make the changes to the nodes and attributes and send the entire xog back in. Try that for one project and see if that works.
This is not a recommended approach -- but if there are a few custom attributes which need to be updated, do it through SQL statement. Anything OOB, should be updated through XOG if possible.

XOG will not normally remove any data unless you specifically ask it to (complete/completed="true" flag) (and even then only for certain data).

So you should just be able to update what you want at project level (subject to the minimum required attributes for XOG) with a minimal piece of XML.

--

If you are not seeing this, then perhaps post your XML here?

Hi Dave,

This is how my xog file looks. we are looking to update project roles for around 56000 resources on the project and we have a lot of allocations. This file deletes all allocation information- is there a way to just update the project roles without xogging out the complete project and xogging the whole project back in. We have thousands of projects.

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="13.1.0.0248"/>
<Projects>
<Project projectID="prjid" name="prjname">
<Resources>
<Resource projectRoleID="projmgr"
resourceID="abc" >
</Resource>
</Resources>
</Project>
</Projects>
</NikuDataBus>

Check this -

<?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.1.0.0248" action="read" objectType="project" externalSource="NIKU">
<!-- you change the order by simply swap 1 and 2 number in the name attribute -->
<args name="order_by_1" value="name"/>
<args name="order_by_2" value="projectID"/>
<args name="include_tasks" value="false"/>
<args name="include_dependencies" value="false"/>
<args name="include_subprojects" value="false"/>
<args name="include_resources" value="false"/>
<args name="include_baselines" value="false"/>
<args name="include_allocations" value="false"/>
<args name="include_estimates" value="false"/>
<args name="include_actuals" value="false"/>
<args name="include_custom" value="false"/>
<args name="include_burdening" value="false"/>
</Header>
<Query>
<!--
<FilterByCustomInfo name="project_billability" criteria="EQUALS">proj bill</FilterByCustomInfo>
<FilterByCustomInfo name="first_bill_date" criteria="BETWEEN">1999-01-07,2002-07-01</FilterByCustomInfo>
<FilterByCustomInfo name="project_risk" criteria="EQUALS">Medium</FilterByCustomInfo>
<FilterByCustomInfo name="profitable_project" criteria="EQUALS">true</FilterByCustomInfo>
<FilterByCustomInfo name="owner" criteria="EQUALS">last</FilterByCustomInfo>
-->
<Filter name="projectID" criteria="EQUALS">project_code</Filter>
<!--
<Filter name="projectID" criteria="EQUALS">test</Filter>
<Filter name="active" criteria="EQUALS">true</Filter>
<Filter name="approved" criteria="EQUALS">true</Filter>
<Filter name="closed" criteria="EQUALS">false</Filter>
<Filter name="approvedForBilling" criteria="EQUALS">false</Filter>
<Filter name="start" criteria="BETWEEN">1999-01-07,2001-01-15</Filter>
<Filter name="finish" criteria="EQUALS">Customer</Filter>
<Filter name="lastUpdatedDate" criteria="EQUALS">2002-01-26T11:42:03</Filter>
<Filter name="resourceID" criteria="EQUALS">jsmith</Filter>
<Filter name="trackMode" criteria="EQUALS">2</Filter>
-->
</Query>
</NikuDataBus>


NJ

In the Project Write XML, use allocations as <allocations/>; this should work fine.