Import error (parent item has a child item that is in a different list)

Maxime.Schaller
Occasional Contributor

Import error (parent item has a child item that is in a different list)

Hi all,

I'm getting the following error in one of my import:

 

Import into Hub_0_Product_Group Marketing L8 # list failed: Parent item has a child item that is in a different list:
You can only add a child to a parent item, if any existing children of that parent item belong to the same list.

 

Do you have any tip/advice to detect and fix the root cause of the issue ?

I'm struggeling on that.

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHeathcote
Community Boss

Re: Import error (parent item has a child item that is in a different list)

Have you tried using a numbered list? 

If so, and the error persists it would appear that you are trying to create a parallel hierarchy.

 

Create a duplicate second hierarchy using the desired parents and children ( this parallel hierarchy will contain a duplicate parent and the second child )

 

Create a mapping module which maps the two hierarchies using the parallel hierarchy's child list as the dimension and the primary hierarchy's parent list as a list formatted line item. Establish the relationship between parent and child and use this mapping when creating aggregation using the parallel hierarchy.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

5 REPLIES 5
DavidSmith
Master Anaplanner/Community Boss

Re: Import error (parent item has a child item that is in a different list)

Does the code used in the child also exist in one of the parent lists?

David

Maxime.Schaller
Occasional Contributor

Re: Import error (parent item has a child item that is in a different list)

Hi David,

Thank you for your reply 🙂

 

The parent list is a subset and I was importing items outside this subset into the child list. After having updated the source to export only items part of this subset it's working.

 

Maxime

DavidSmith
Master Anaplanner/Community Boss

Re: Import error (parent item has a child item that is in a different list)

Excellent - Glad you got it sorted
ChrisHeathcote
Community Boss

Re: Import error (parent item has a child item that is in a different list)

Have you tried using a numbered list? 

If so, and the error persists it would appear that you are trying to create a parallel hierarchy.

 

Create a duplicate second hierarchy using the desired parents and children ( this parallel hierarchy will contain a duplicate parent and the second child )

 

Create a mapping module which maps the two hierarchies using the parallel hierarchy's child list as the dimension and the primary hierarchy's parent list as a list formatted line item. Establish the relationship between parent and child and use this mapping when creating aggregation using the parallel hierarchy.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

Maxime.Schaller
Occasional Contributor

Re: Import error (parent item has a child item that is in a different list)

Thanks Chris, I'll try this if I face this problem again