Invalid Parent when Importing into List

Hi!

 

I have this list called Strategic Customer. I have a module based off this list called Strategic Customer Details. the parent hierarchy of this list is Strategic Account Owners. In the module, I have a line item to choose a different Strategic Account Owner for a Strategic Customer. The choose new SAM line item is format Strategic Account Owners list. When I import this into the Strategic Customer list to change the parent of the strategic customer i want to change, it gives me an invalid parent error. Any ideas on how to fix this error? Capture3.PNGCapture1.PNGCapture.PNG

Best Answer

  • Is this a numbered list? i suggest that you import the "code" of the parent instead of the name. In below case, instead of having the line item "Choose New SAM", have another line item called "New SAM Code", get the code of the selected SAM and use this line item in your import. 

Answers

  • Are you using codes for the import?

    Normally this happens if the code or name of the parent is the same as the child.  

    It is best to try and keep the children codes different from the parent codes if possible

    One trick is to add the two codes together to create a unique parent-child code

    Hope that helps

    David

  • This worked! Thank you!
  • When importing into a list, you get an Invalid Parent error. Assuming the file has correctly identified the parent, which of the following could be a valid reason for that error? Select all that apply, then click Submit. List has multiple items rolling up to the same parent List is in grid view vs. tree view when importing Parent Hierarchy list has not been populated yet Parent Hierarchy is set to the wrong list Parent Hierarchy is set to the wrong format