Reset VLV reference in extension via import

[martin_schffler]

I have an extension that contains two fields that are a reference to a value list.

What value do I have to import to reset these VLV references to their initial (i.e. blank) state?

[former_member224222 · Accepted solution]

Hi Martin,

If you are doing a CSV import, you can try to use the <NULL> token.  Literally put that text in the column of your extension field(s) and the corresponding member will be set to its uninitialized value.  It sounds like this is what you want to do.

Hope that helps.

Rob

[Former Member · Accepted solution]

Hello,

Not sure if related may I ask your help, when I'm uploading the enterprise workbook(companies tab).

I am getting the following error for time_zone. - Problem is this is a required field.

The TIME_ZONE field has this as note: References the DISPLAY_NAME field of a Value List Value for type 16 (ODP_TIME_ZONE)

# Record 1. Warning: An error was encountered in column TIME_ZONE which had the value (GMT+10:00) Brisbane: The specified value for field TIME_ZONE was not found in the list of values: (GMT+10:00) Brisbane

# Failed: object 1: This field is required and must have a valid value. [TIME_ZONE].

Do I have to set custom values in :

value_list_types

value_list_values

Then use that custom value and put it into the TIME_ZONE field in the companies tab?

Is there another way to skip this error?

Would really appreciate the help.

[Former Member]

Hi Piyush,

You can search the Reference guide to get the attribute id if it is standard field.

.For External Ids of custom fields you can search them in Extension Definition under setup. There you can search it using the display Name.

Hope this helps.

Kumud

[Former Member]

Hi Martin,

Do you mean that you have an extension field of value list type has a value(selected from its drop down) and you want to reset the value to blank or none. You can achieve this by writing script.

Sample script is like this:

valueListHomeBean=IBeanHomeLocator.lookup(session, ValueListTypeIBeanHomeIfc.sHOME_NAME);

        valueList= valueListHomeBean.findByExternalId("XXX");//external id of the Extension field

        valueBeanList = valueList.getCollnValueListValue();

        for(int i=0;i<valueBeanList.size();i++)

        {

            valueBean=  valueBeanList.get(1);//change the index as per your requirement which is none in value lists

            doc.getExtensionField("XXX").set(valueBean.getLocalizedObjectReference());

        }   

Hope this helps you to resolve your issue.

Regards,

Kumud

[Former Member]

Hi Kumud ,

How to get the external Id of the extension field ?

I am trying to fetch the value of display name of the value list value field , but its giving error . I can fetch the DisplayNameID of the value list value in the extension field.

Please suggest .

Regards,

Piyush Srivastava