Employee Data Import

[bobby]

#19244

Hi,

Can I import employee details from excel sheet? If yes, is there any particular format required for this?

Bobby

[Rijo Pappachan]

#20079

Hi Bobby,

You can import employee details from excel sheet using ‘import’ feature of employee module. 
Location: Employee > Import

Please note the below points when you prepare the document,
1. The import excel document should be in .csv format
2. Employee ID, First Name, Department, Location, Date of Joining are mandatory and it should be filled in the import excel document.
3. Date of joining should be in the format DD/MM/YYYY or MM/DD/YYYY and it should be same as the system date format.
4. Location and department names should be same as in Employer module if it’s already filled.

You can download a sample excel import document from the link below,
http://lenvica.in/downloads/Sample%20Employee%20Import%20Data.csv

Alternatively you can get an import document template from the ‘Import’ folder of Lenvica HRMS installation folder.

Go through the link below to see a video of import process,
http://lenvica.in/how-to-import-employees-from-a-file/

Hope this helps!

Regards,
Rijo

[bobby]

#20080

Hi Rijo

Thanks for your swift reply. I’m getting an error message in the import wizard screen. The message is “Invalid value for field 'Department': 'information System and Administration'”
Please help me on this.

Thanks,
Bobby

[Rijo Pappachan]

#20081

Hi Bobby,

The problem is because of the department name exceeded it’s allowed character limit. The department name should not exceed 30 characters. Space is also treating as a character.

Below are the character limit of few fields,
First Name- 50, Middle Name- 50, Last Name- 50, Department- 30, Location- 50, Address 1- 50, Address 2- 50, Designation- 50

Hope this helps!

Regards,
Rijo

[bobby]

#20082

Thanks. It worked fine.

Bobby

[Payal Sharma]

#20083

Rijo,

Is there any limit to the number of employees to be maintained in one excel file.

I have 3000 employees all over in five branches. Would it work if I make one excel sheet including all employees. Will I be able to import that to the Lenvica HRMS here in my headoffice.

Payal,
Mulund.

[Rijo Pappachan]

#20084

Hi Payal,

You can import 'n' number of employee details, if you are using 'Professional' or 'Enterprise' edition. The Lite edition supports 30 employees only.

Regards,

Rijo

[Author]

Posts