Error on importing data onto employee details module

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

Accepted answers

All comments

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.

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!