Is it possible to use MDIS to import to hierarchy tables?

[Former Member]

Hello everybody!

Tell me, please,is it possible to import records into hierarchy tables using MDIS?

The imported XML-file looks like this:

<data>

<row>

<NAME>Some Name</NAME>

<DATA_UPD>01.27.2006</DATA_UPD>

<HIER>03000000000\03408000000\03408553000</HIER>

</row>

<row>

...

</row>

</data>

The field HIER in my XML-file contains delimited values to build hierarchy. I tried to import, but MDIS blocks the port with Value Exception.

P.S. I set MDIS Unmapped Value Handling option to "Add" to automatically add missing values to hierarchy table.

Thanks,

Vika

[Former Member · Accepted solution]

Hi!

Jasbir, Dilmit, thanks for your answers!

But while configuring mapping of fields of my XML-file to hierarchy table fields in Import Manager I found an option "Set MDIS Unmapped Value Handling" which can be set to Ignore (default), Add, Map or Fail. If I set this option to Add, it offers to "Add Target Node for Unmapped Values in MDIS Mode". So, I expect that selecting some node shows MDIS to which node it should add all new unmapped values.

The imported XML-file structure looks like this:

<data>

<row>

<NAME>Some Name</NAME>

<DATA_UPD>01.27.2006</DATA_UPD>

<HIER>03000000000\03408000000\03408553000</HIER>

</row>

<row>

...

</row>

</data>

1. I splited HIER field into hierarchy using "Split into Hierarchy" command.

2. Then mapped HIER<Split Hierarchy> field to CODE field of my resulting hierarchy table.

3. Then for CODE field I set "MDIS Unmapped Value Handling" option to Add and chose the node to which add unmapped values.

4. Then I tuned matching fields.

5. Saved the map.

6. Configured port (of type Automatic).

7. Added XML-file to the port.

The result of import (using MDIS) into hierarchy table is that the CODE field is filled with hierarchical values, but all other fields are empty. And MDIS blocks the port with Value Exception.

So, I embarrassed by this: on the one hand, MDIS imports some values and even builds the hierarchy correctly, but from the other hand, the import doesn't finish.

Can anyone explain this to me?

Thanks in advance,

Vika

[Former Member · Accepted solution]

First of all use latest build 5.5.42.98 for all components, some bugs are resolved in this build.

Set Variable Unmapped Value Handling =True, AddNewValue=1 and IgnoreNewValue=0 in mdis.ini.

and also while changing your configuration options in Import Manager. Please save the Map after this.

hope this will help.

BR,

Alok

[Former Member · Accepted solution]

Hi Alok,

Are these variables only for SP6? I can't find any information about them in SP5 documentation.

Thanks,

Vika

[Former Member · Accepted solution]

Sorry Victoria,

Use latest build 5.5.42.98 for all components, some bugs are resolved in this build. Please try with this build, i am sure it will work.

Not in mdis.ini, Go to Configuration option --> Default MDIS handling

Set Variable Unmapped Value Handling =Add,

Automap unmapped Values = Yes

and also while changing your configuration options in Import Manager. Please save the Map after this.

Auto mapping values bug has been fixed in build 5.5.42.84.

Also refer to Note 1110134 - MDM 5.5 SP05 Patch02 Hotfix08 Release

BR,

Alok

Edited by: Alok Sharma on Jan 30, 2008 3:20 PM

[Former Member · Accepted solution]

Hi!

Alok, your advices really helped! It works! Thanks a lot!

I also want to thank everybody who tried to help.

Best regards,

Vika

[Former Member]

Hi Viktoria,

You cant import records in hierarchy table using MDIS because for doing so you have to save your maps and in hierarchy value mapping is not saved. So you cant import the records automatically. And also if you are doing delta uploading, how will the system automatically know where to map the data aur add the data. For that you have to do manuall process only.

I hope I am able to solve your problems.

Regards

Dilmit Kaur Chadha

[Former Member]

hi,

it is possible to import records into Hierarchy tables.

in import manager:

1. in the source hierarchy pane, select HIER and right click, set the delimiter

2. Split into hierarchy

3. Map the source fields to destination fields and value mapping

4. Match records

5. Execute import action

hope this may help you,

regards,

srinivas

[Former Member]

Yes, it will work, but I want to import records into hierarchy table automatically (if it's possible) using MDM Import Server (MDIS).

Thanks for your reply,

Vika

[Former Member]

yes, it is possible but any how you have to change the map first by using Import Manager.

Do some sample testing via Import Manager, Once you get the required result, save the map and use MDIS.

Jasbir Battu