Data Import Error while importing data of Employee

ERPNext
1

While i am importing data of Employee, i am getting an error which i am not able to solve.
The error is as follows:
“Error for row (#21) “EMP/0034” : must be string, not datetime.date”
This error is shown for all employees record but none of my row is datetime still getting the error.

2

hi @Varna,
can you share the screenshot of line no 21 of your csv.
i think you have to enter the wrong date format entered.

Thanks

3

@sagar @shraddha
I am not using any date format coloumn
Actually i am updating Employee data so just using 2 column
1.Employee ID
2.Company
PFA of my screenshot

Screenshot (194).png761×393 9.25 KB

4

hello @Varna
read the first line,as share you the screenshot.
please don’t mention the employee series & try it.

Thanks

5

@sagar,
i cant remove the 1st column as i am updating the data & not inserting new data

6

just simulate date format for erpnext

best approach is to enter only record normally, export, fill the rest with same format and import back.

7

@sagar,
I even tried that i exported the data & as it is imported it still getting that error :frowning:

8

It means other errors will follow, in particular, mandatory fields! unless you disable it