Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 07:39 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 02:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 12:17 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.