Map including spliting operation dosen't work in MDM Import Server

[Former Member]

Hi All,

I met a problem with MDM Import Server when using a map file with spliting operation in it, although I can use it in MDM import manager to load data successfully. The error in log file is like this:

-

---

Record Matching...

Importing Lookup...

One or more attribute values are invalid.

One or more attribute values are invalid.

One or more attribute values are invalid.

One or more attribute values are invalid.

Import Failed!

-

---

The spliting in my map is: I split field "Category" into category1 and category2 with space " ". e.g. value "Trousers M" is splitted into "Trousers" and "M" . Then I map category1 to category and category2 to size.

I tried to delete this spliting and just map "Category" to "Category" then it works well for Import Server.

Is it the bug of MDM import server? can anyone give me a explaination?

Thanks! Bin

[Former Member]

Under Configuration Options of the Import Manager,

check the values for

<b>Default Batch Handling</b>

AutoMap Unmapped Values = Yes

Unmapped value Handling = Add/Ignore/Fail.

Set the values according to your needs.

Make sure that the data source is updatable as well.

[Former Member]

What is the data type of the field?

[Former Member]

Hi Harrison

the field type is text