Clarity

We are planning to update purge flags for large number of investments(>1500) . Direct DB edit is not an option for us so planned to do it via XOG and script it. 

I need a simple write XML by which i can Update Purge Flag.

Thanks,

Rajesh Reddy

Did a simple test on 13.2.0.472

Used the below xml -

<?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.2.0.472"/>
  <Projects>
    <Project active="false" closed="true" financialStatus="C" lastUpdatedBy="JN1" lastUpdatedDate="2013-11-15T22:02:15" managerResourceID="JN1"
      name="Test 02" openForTimeEntry="false" projectID="PM0000003L">
      <CustomInformation>
        <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
        <ColumnValue name="agile_linked">false</ColumnValue>
        <ColumnValue name="agile_synced">false</ColumnValue>
        <ColumnValue name="sync_detail_inform">N/A</ColumnValue>
        <ColumnValue name="sync_status">pending</ColumnValue>
        <ColumnValue name="cust_region">us_east</ColumnValue>
        <ColumnValue name="obj_status_reporting">NOT_REQUIRED</ColumnValue>
        <ColumnValue name="btm_integration">false</ColumnValue>
        <ColumnValue name="obj_work_status">REQUESTED</ColumnValue>
      </CustomInformation>
      <General addedBy="JN1" addedDate="2013-11-15"/>
      <OBSAssocs complete="false"/>
    </Project>
  </Projects>
</NikuDataBus>

What I changed is marked in BOLD

Just check  in non-prod env first before proceeding

NJ

@NJ thanks for replying

the XML didn't wrk... tried to xog in it showed records updaed 1 but nothing xoged in...

Can u please give me a XML which can change the "purge flag" from yes to --> NO.

Which Clarity version are you on ?

NJ

Version 13.1

Don't see any project level purge or delete attributes/tags in project xml sample file or xsd file. That is excluding subproject.

Martti K.

If you cannot do thatwith XOG and the GEL is an option for you.

Basically you could have that field in a project object based grid portlet or even in the project list and increase the number of row to 50 which would give only 15 pages to edit.

However, that field does not seem to be editable.

Martti K:

"However, that field does not seem to be editable." - if you change the project list to 50 rows then you can "mass-delete" 50 at a time using the check boxes and the 'Mark for Deletion' button.
 

Thanks Dave. The solution is so simple.

Martti K.