Level 1 Importing data into list

amruthasai7979

• I am in Level 1, where as an 4.8.2 Activity I have to import data from Employees.csv into

 

•  

E2 Employees#  numbered list. But while importing it is showing Invalid parent. Please help. I am attaching picture

 

anand.shekhawat

@amruthasai7979 

The mapping seems correct. Kindly check the Department codes in the Department List, it might be missing. Also verify if the Department List is set as a parent of the Employees List.

 

~Anand

anand.shekhawat

@amruthasai7979 

Follow the snip below for setting up the Department list as a parent of Employee list.

 

anand.shekhawat

@amruthasai7979 

Kindly check the department codes. Follow the below snip for reference

~Anand

anand.shekhawat

It seems like you have missed some steps to create the Departments List members. It's Ok you can create it manually, looking at the snip I have shared.

 

~Anand

anand.shekhawat

@amruthasai7979 

So in here you were trying to import the Employees(child) data under departments(parent). Initially while importing the file you had defined the employees list to go and sit under the respective department. But the departments list members were absent, so Anaplan did not find the correct parent under which it should load the Employee data, that is why it threw the error. After when you created the department list members Anaplan was able to locate the correct parent, so the data got loaded with ease. 

I believe there would an import that needs to be done for creating the departments list. In the above case the departments were very few, that is why i advised you to create manually. Suppose the data would have hundreds of entries, it would be difficult as well as error prone, to manually type in the data. So in that case an import from csv would be the best option.

In the end its you who has to decide how to feed the data into the model seamlessly and keeping it error free.

 

I hope i have answered your question.

 

~Anand

 

amruthasai7979

 how to set the department list as parent of employees liat

amruthasai7979

Ok now I got it sir, it's already done, I think that's not the reason here

amruthasai7979

 It is like this sir

anand.shekhawat

@amruthasai7979 

 

Yes that is the reason why you are unable to load the data. The parent hierarchy is completely missing. Kindly create the Department hierarchy list members with the given code. Then run the import in the Employees list. You will get the data loaded correctly.

 

~Anand 

amruthasai7979

So this should be done manually sir?

amruthasai7979

Yes sir, I have skipped that step, now I got this correct, Thank you very very much sir for your patience and for responding

anand.shekhawat

@amruthasai7979 

 

No Worries 🙂 .I am glad, the issue is resolved !

 

~Anand

amruthasai7979

Sir, one last question sir, why did we do this, do we have to do this always manually or do we have to import, what exactly is the logic here because I didn't find it the lessons

amruthasai7979

Got it sir, Thank you