Clarity

  • 1.  Bulk update of API Attribute ID

    Posted Sep 17, 2018 11:15 AM

    We have about 100s of custom attributes and we are going to use New UI in couple of months now I see that API Attribute ID needs to be set for each custom attribute to be able to configure it on blueprint.  well, the edit and save action on such attribute takes about 5-10 minutes and that is for one environment (dev)we have to repeat it on various objects and environments before going live so looking for easy option to set the api ids

     

    We are on-premise so looking for any possible option through backend even if unsupported.



  • 2.  Re: Bulk update of API Attribute ID

    Posted Sep 20, 2018 02:43 AM

    Hi Suhas,

     

    One possible option is to execute the update command on the database (UNSUPPORTED SOLUTION).

     

    You can list down all attributes API id in excel sheet and develop the query. Once the query executes, flush all the caches to reflect the changes. 

    Please try this on Dev environment first for few attributes.

     

    Please note this is unsupported by CA.

     

    Regards

    Shubham



  • 3.  Re: Bulk update of API Attribute ID
    Best Answer

    Posted Sep 21, 2018 11:08 AM

    You just repeated the question in different words.

     

    We found OOTB and supported way. That is to XOG the attributes. Thanks to Augustin_Samraj

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_contentPack.xsd">
      <Header action="write" externalSource="NIKU" objectType="contentPack" version="15.5.0.225"/>
      <contentPack update="true">
        <objects>
          <object code="project" dwEnabled="true" dwTrendEnabled="true" entityCodeAttribute="entity" fiscalPeriodTypeAttribute="odf_period_type"
            pageInstanceType="SRM_PROJECTS" pageLayoutAttribute="page_layout" periodEndAttribute="odf_period_end" periodStartAttribute="odf_period_start"
            raiseEvents="true" source="niku.com" update="true">

            <nls description="The Project Object" languageCode="en" name="Project"/>
          <customAttribute code="obj_request_type" dataType="string" apiAlias="objrequesttype"></customAttribute>