XOG - I can not get all the custom fields

[Ricardo Fernandez]

I am using prj_projects_read.xml with the configuration mentioned below.
But I can not get a specific custom field.
I can see many custom fields without problems, but not the one I'm looking for.
I can not establish the reasons why the custom field is not exported.

Could you give me an idea of how I should focus my search to solve this problem?

 

 

<?xml version="1.0" encoding="UTF-8"?>
-<NikuDataBus xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
-<Header externalSource="NIKU" objectType="project" action="read" version="6.0.11">
<!-- you change the order by simply swap 1 and 2 number in the name attribute -->
<args value="projectID" name="order_by_1"/>
<args value="name" name="order_by_2"/>
<args value="false" name="include_tasks"/>
<args value="false" name="include_dependencies"/>
<args value="false" name="include_subprojects"/>
<args value="false" name="include_resources"/>
<args value="false" name="include_baselines"/>
<args value="false" name="include_allocations"/>
<args value="false" name="include_estimates"/>
<args value="false" name="include_actuals"/>

<!-- MODIFICADO -->
<args value="true" name="include_custom"/>
<!-- MODIFICADO -->

<args value="false" name="include_burdening"/>
</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">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>

[David Morton]

Is the custom field a project-custom field or a investment-custom field?

(just a GUESS, but might be the "problem")

[Deactivated User]

Which data type is it?

[Ricardo Fernandez]

The custom field is in the ODF_CA_INV table

[Fabio Cresta]

Even check that te field you need to export has a value. XOG does not export empty custom fields.

[Ricardo Fernandez]

Surely it's about that Fabio.
The field was created with null value.
How can I do a XOG so that all the custom fields (those in the ODF_CA_INV table) have a value, for example "OK"

[David Morton]

You can't.

 

You can have a default value (eg "OK") for custom fields though.

[Deactivated User]

and populate null vales with default.