Setting attribute value to NULL

[former_member257552]

Hi,

We’re doing a set-up of automatic import of .txt file to MDM. We have created a mapping file to map the data in the .txt file to the fields in Catalog_Items table in MDM. Some of the data in the .txt file are mapped to attributes created under Categories table in taxonomy mode.

The automatic import works fine until we encounter a scenario in which the input file contains a record to update the attributes of an existing record in MDM to NULL.

For example:

A record with category ABC has an attribute dimension set to '10x10 PER' and an attribute weight set to 93.000 in MDM. We would like to remove the value '10x10 PER' and 93.000 so the input file contains an update for this record to set the dimension and weight to NULL.

In Import Manager, we set the NULL Interpretation of each attribute to ‘Overwrite’ (currently the default configuration option for NULL interpretation is to ignore) and save this setting to be reflected in the mapping file. Then we do automatic import of the input file using MDIS.

When we check the record in Data Manager after the import, weight is empty but dimension still contains '10x10 PER'.

It seems that setting the NULL interpretation of the attributes to 'Overwrite' works for attribute Weight which is of type Numeric but it doesn’t work for the attribute Dimension which are of type ‘Text’.

In Data Manager, we can manually remove the dimension value by clicking the 'Del' keyboard button.

Is there any way to update text attribute value of a record to NULL using automatic import ?

Thank you in advance

Mehdi

[Former Member]

Hi Mehdi,

Have you got any solution for this problem?

We are currently facing this same issue and have referred note:1973926 .

We are currently at MDM 7.1 SP09 pack so not sure if this defect is corrected in our current version.

We have all the attribute type as Text and the values are not getting set a blank in DataManager.

If you can help us it would be much appreciated.

Thanks

SCN User