Import employee data issue

1

I’m importing employee data from google sheet, But naming series creating issue, while I’ve set the naming series in system and also in google sheet.

In system I’ve set following series:
HR-EMP-.###
SRI-.###

and my sheet data is:

|ID|Series|First Name|Company|Status|Gender|Date of Birth|Date of Joining|
|3|SRI-003|KAMAL CHOUHAN|Sri Sales|Active|Male|1/1/2000|1/1/2020|

2

error is:
Values must be one of HR-EMP-.###,SRI-.###

3

Hi,

you cannot set it because it’s a primary (increment) key so please you can only enter series in excel/google sheet like HR-EMP-.### or SRI-.###.

And the record will automatically create a series with numbers in import time.

Thanks.

4

Okay Thank you so much, This worked for me.