Clarity

Expand all | Collapse all

XOG - I can not get all the custom fields

  • 1.  XOG - I can not get all the custom fields

    Posted 02-12-2019 08:55 AM

    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>


  • 2.  Re: XOG - I can not get all the custom fields

    Posted 02-12-2019 09:02 AM

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

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



  • 3.  Re: XOG - I can not get all the custom fields

    Posted 02-12-2019 02:41 PM

    Which data type is it?



  • 4.  Re: XOG - I can not get all the custom fields

    Posted 02-14-2019 08:51 AM

    The custom field is in the ODF_CA_INV table



  • 5.  Re: XOG - I can not get all the custom fields

    Posted 02-13-2019 05:23 AM

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



  • 6.  Re: XOG - I can not get all the custom fields

    Posted 02-14-2019 08:52 AM

    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"



  • 7.  Re: XOG - I can not get all the custom fields

    Posted 02-14-2019 11:34 AM

    You can't.

     

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



  • 8.  Re: XOG - I can not get all the custom fields

    Posted 02-14-2019 02:59 PM

    and populate null vales with default.