Level 1 Importing data into list
- 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
Best Answers
-
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
https://in.linkedin.com/in/anand-shekhawat-35645486
0 -
Follow the snip below for setting up the Department list as a parent of Employee list.
https://in.linkedin.com/in/anand-shekhawat-35645486
0 -
https://in.linkedin.com/in/anand-shekhawat-35645486
0 -
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
https://in.linkedin.com/in/anand-shekhawat-35645486
0 -
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
https://in.linkedin.com/in/anand-shekhawat-35645486
0
Answers
-
how to set the department list as parent of employees liat
0 -
Ok now I got it sir, it's already done, I think that's not the reason here
0 -
It is like this sir
0 -
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
https://in.linkedin.com/in/anand-shekhawat-35645486
0 -
So this should be done manually sir?
0 -
Yes sir, I have skipped that step, now I got this correct, Thank you very very much sir for your patience and for responding
0 -
https://in.linkedin.com/in/anand-shekhawat-35645486
0 -
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 lessons0
-
Got it sir, Thank you0