Hierarchy data loading through import manager.

[Former Member]

Hi Experts,

i updating the hierarchy data i am able to updating the code only not the Name, hierarchy table have two fields 1) hierarchy code 2)hierarchy desc both are disply fields

I did partion as AA, BBand CC(import manager), but the code only comming whenever import, how to map the name also for loading the hierarchy data. please help me on this

source file as like EXCEL:

AA AA Nm BB BB Nm CC CC Nm

13 SOAP 45 TOOTHPASTE 56 BRESH

17 BRAND 57 JEANS 78 MENS

19 FOOD 37 VEG 67 NON VEG

The upper level is AA code & Name

the second level is BB & Name

the Lowest level is CC &Name

Thanks,

Bhupal.

Edited by: bhupal reddy on May 24, 2011 9:03 AM

Edited by: bhupal reddy on May 24, 2011 9:10 AM

[Former Member · Accepted solution]

Hello Bhupal

I found strange Import manager behaviour during hierarchy import,

if hierarchy has more than one field in level like in your case.

in that case

i'm loading(add new nodes) hierarchy in three passes

1) loading 1-st level

2) loading 2-nd level

3) loading 3-ed level

Better solution for work with hierarchies(rename, copy-paste nodes) is Data Manager.

Import manager we are using for initial loading or mass updating only.

Regards

Kanstantsin Chernichenka

[Former Member]

Isuue closed

[Former Member]

Hi Bhupal

In the source file you have mentioned 3 columns for Name. How can you map 3 source fields into 1 target MDM field which is Description/Name for Hierarchy node.

I think you need to modify the excel file used for loading.

Also as far as I remeber we can not use Name/Description field for hierarchy table as a matching field.

Hope this helps-Ravi