Highlighted
Occasional Contributor

Create non-numbered composite hierarchy with List Import where parents and children have same names

Hi Anaplanners,

 

I am struggling with creating a non-numbered list composite hierarchy through List Import. As described in the attached file, a list I am trying to create include a child whose parent has the same name. I could create such a list manually but it failed when I try to create this list via List import from the source module in the file. It is clear that such a list can be created if the list is a numbered one, but I would like to know if there is any solution for non-numbered lists.

Thanks in advance.

 

2 REPLIES 2
Highlighted
Super Contributor

Re: Create non-numbered composite hierarchy with List Import where parents and children have same na

Hi @gregtan 

 

Simple import will not work here for non number list it will always throw an error because already parent with same same exist. so you have to do some trick to achieve the result for Non Number list.

 

Assuming you already have product list.

1. Create a system module where you need one extra line for Fake sub product name, here I have added " - " , you can add whatever you want.

 

Screenshot_156.png

 

2.  Here you need two actions

1) First Action to create a Fake Sub Product, make sure sub product code should be mapped.

Sub Product List before import.

Screenshot_157.png

Sub Product List after import, here you can see items added but with hyphen but have code.

Screenshot_158.png

Import Mapping to create fake sub product.

Screenshot_159.png

 

2). Second action to update the sub product list items, You should update the sub product name based on code.

Screenshot_161.png

Finally you have updated the list and you can get the same parent-child name in the non number list.

Screenshot_160.png

 

 

Hope this helps

Thanks

Akhtar

Highlighted
Occasional Contributor

Re: Create non-numbered composite hierarchy with List Import where parents and children have same na

Thanks, Akhtar

 

What you have proposed could totally work !!!

Thanks, again for you help