1 ACCEPTED SOLUTION
Accepted Solutions
Alright, lets make the following:
- first make sure that your employee list has codes, so Anaplan will match the employee codes in your source file(Eg: 1,2,3...) to the actual employee list (Note: this does not seem to be an error so far). If you do not have codes in your employee list, then use names (Column 1 in your source file).
- also, make sure that all the line items in your target module are properly formatted, so they can host the type of data you want to load into them. (Eg: text, list, number, date...) (Note: this does not seem to be an error so far). In case of doubt make them all "text" except for numbers, dates or booleans.
Points 1 and 2 perhaps are not really needed in your case, but is better to err on the side of caution and I would recommend you to double check them anyways. Now:
- In your third tab in the data mapping window (called "SYS08 Employee Details Line Items") select the option "map items manually".
- After selecting "map items manually" you will be able manually map the missing fields: Employees, Country and Department as per indicated on the picture below.
- additionally, choose an option called "ignore unmapped items". Select it in order to ignore all the source items that won't be mapped to a line item of your target module. Seems like the only ignored source field will be "Active?" for now.
- Finally, for the "date" formatted line items, click the boxes highlighted below to make sure that the date format in your source file is recognised by Anaplan
After following these steps, I do not think you will run into new errors.
Could you please attach a pic of the mapping you have used in the line item tab? Here:
Thanks
Alright, lets make the following:
- first make sure that your employee list has codes, so Anaplan will match the employee codes in your source file(Eg: 1,2,3...) to the actual employee list (Note: this does not seem to be an error so far). If you do not have codes in your employee list, then use names (Column 1 in your source file).
- also, make sure that all the line items in your target module are properly formatted, so they can host the type of data you want to load into them. (Eg: text, list, number, date...) (Note: this does not seem to be an error so far). In case of doubt make them all "text" except for numbers, dates or booleans.
Points 1 and 2 perhaps are not really needed in your case, but is better to err on the side of caution and I would recommend you to double check them anyways. Now:
- In your third tab in the data mapping window (called "SYS08 Employee Details Line Items") select the option "map items manually".
- After selecting "map items manually" you will be able manually map the missing fields: Employees, Country and Department as per indicated on the picture below.
- additionally, choose an option called "ignore unmapped items". Select it in order to ignore all the source items that won't be mapped to a line item of your target module. Seems like the only ignored source field will be "Active?" for now.
- Finally, for the "date" formatted line items, click the boxes highlighted below to make sure that the date format in your source file is recognised by Anaplan
After following these steps, I do not think you will run into new errors.
