We are asked to import Emloyees.csv into SYS08 Employee Details and I am unable to get the names in the list to match on the names in the employees list that I already have in. I checked and I have the data type as "Text" listed within the SYS08 module, and the .csv has the data in that column listed as "General". I also tried changing that to "Text"; neither work. I can do it manually but it will take a long time.
Is there something I'm missing or should consider?
Solved! Go to Solution.
in the first tab, Mapping, which field are you using to map the Employee ? You should be using the code, not the name.
Thanks for the response. Here are some more screenshots:
This first one shows the mapping that corresponds to the screenshot from the original post.
This second one, I believe, follows how you are implying I should be mapping.
This third one shows what I see when I use the Mapping set up from the second screenshot. It still doesn't seem to be working.
What am I missing? Thanks in advance!
#E2 Employee is a number list, so we can't use the name for mapping. We should use code for the import.
Your mappings are right, please download the file again and try to load it.
Here is a screenshot of my employee list, where you can see that each employee does have a code associated with them. Do you recommend that I clear out this list and attempt to repopulate it?
That appears to have done the trick - good catch. Here is a screenshot of what it looks like now that it has successfully uploaded and matched the codes: