Error on importing data onto employee details module

Hemang

Hi,

I am trying to import data onto employee details module. It is a numbered module. I have attached three screen shots, 1. How it should be. 2. How it is and 3. the mapping which I have done.

Please can anyone help?

how it should be.jpg

how it is.jpg

mapping.jpg

devrathahuja

Hi @Hemang ,
Can you also add the screenshot of the line items tab in the mapping?

lokeshm

@Hemang clear the code names and make it blank before you import and check whether using text format or date format for the start date line item .

Unknown

This content has been removed.

Hemang

Hi Devrath,

Thank you for your reply. please find attached the screenshot for mapping. When I select column headers for Employee details and go to employee details tab to map manually the target column is blank, I have attached the screenshot.

Mapping tab.jpg

Target item.jpg

Hemang

Hi Lokesh,

Thank you. If I make code blank it is showing error?

devrathahuja

Hi @Hemang ,
Clear the code line item & then reimport it without mapping any column from the file to that line item as you can fetch the code using the formula - code(item(____))

Hemang

Hi @devrathahuja,

removing code line item is not showing any values for column headers? If I have understood you correctly, please?

Without code line item.jpg

devrathahuja

Hi @Hemang ,
Map the employee code to the employees column & in the 2nd tab where you map the line items do not map anything to the "CODE" line item.

Hemang

Hi @devrathahuja,

Thank you and really sorry but I am sure I am making some error I have mapped E2 Employee with code and the second column if I leave it as blank it is showing error?

leave 2nd column blank.jpg

devrathahuja

@Hemang - 2nd option you can select column headers & then in the mapping of these columns, leave the code line item mapping blank.

Hemang

@devrathahuja - working now, thank you so much.

Unknown

This content has been removed.