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,
Best Answer
-
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.
2
Answers
-
Does the code used in the child also exist in one of the parent lists?
David
0 -
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
3 -
Excellent - Glad you got it sorted0
-
Thanks Chris, I'll try this if I face this problem again
0 -
Hi Maxime,
I am also getting the same error and i am using the sub set as a parent but didn't got what you did to solve the issue can you guide me what you did?
0 -
@Maxime.Schaller Thank you so much for this post! We had a similar subset parent issue and managed to resolve after reading this.
0 -
i am facing the same issue, but in my case this error is happening only in deployed models where as in "standard mode" dev model, it is creating list members without parents.
0 -
I am getting this error, and it took me a while to process the problem and the solve from this thread so I'm going to re-word in the way I understood it to potentially help folks out in the future.
The issue here was that I was trying to import children into a list whose parent hierarchy is a subset, but some of the parents in my data source existed in the list, but outside that subset.
So I have a list called "Site" with a subset called "ssSite". The list I am trying to import into is "Site Specialty", whose parent hierarchy is "ssSite".
Site (subset ssSite)
Site Specialty (parent ssSite)
This error popped up when I tried to import an item into "Site Specialty" whose parent exists in "Site" but NOT in "ssSite".
I used Rob Marshall's method to create a property for "ssSite" in a "Site" properties module to key off of for my source view, and filtered out any children whose parents are NOT in "ssSite".
0
