Attendance Data Import From Excel Sheet

[bobby]

#19241

Hi,

Can I import attendance data from excel sheet to Lenvica HRMS?

Regards,
Booby

[Rijo Pappachan]

#20071

Hi Bobby,

You can import attendance data from excel sheet to Lenvica HRMS.

Location: Time Registration > Device

Add new device with device selection as ‘CSV with IN/OUT’. See the screenshot attached.

You can download a sample excel import sheet from the link below,
http://lenvica.in/downloads/Attendance%20Import%20Template.csv

Hope this helps.

Regards,

Rijo

---

Attachments:

[nithin]

#20072

Hi,

What to do after the browsing of excel file? Is there any button or something to initiate the communication with the excel file?

Regards,

Nithin

[Rijo Pappachan]

#20073

Hi Nithin,

Follow one of the below,
1. Right click on the Lenvica HRMS Communicator icon and click 'Refresh Communicator'
  You can find it in the task bar icons. See the screenshot attached.

2. Close the Lenvica HRMS Communicator process from the task manager then restart Lenvica HRMS

Regards,
Rijo

---

Attachments:

[bobby]

#20074

Hi,

How can I come to know whether the data has imported or not? Where can I see the imported punch details?

Regards,
Bobby

[Rijo Pappachan]

#20075

Hi Bobby,

You can see the communication status in 'Communicator History'.
Location: Time Registration > Communicator History

You can view the punch details from Raw Punch report.
Location: Time Registration > Time Registration Reports > Raw Punch

Regards,
Rijo

[sidharth]

#20076

Some points to be noted

1- check weather the date format of your excel file is exactly same as that of the software. If not we have to check the date format of the entire column and match it with the date format of the software and the server or remote PC in which the database file is kept.

2- check weather while importing, the file is been opened or not. If it is opened try an import after closing the file which is minimized in the taskbar

3- ensure that the file format which is saved is a .csv file

4- try matching proper fields you want in the software to the fields in the excel file

[muneer]

#20077

Hi,

The Lenvica HRMS update from 3.8.44 you can directly import attendance data to attendance screen.
Please do the following things to import attendance

1. Update your Lenvica HRMS into version: 3.8.44 or above
2. click the 'External Import' icon in the 'Attendance' module
3. Select format
4. choose the File
5. Select the fields from import file and match it with a field in the system
6. Click Finish.

Note: If you want to edit or over right current data please clear the current data and use this import.

Import Format

Employee Id Employee Name Attendance Type Begin Time Begin Date End Time End Date
001                         John                        Work Time              09:00       02/02/2016   18:00     02/02/2016
002                         Joe                       Casual Leave     09:00       02/02/2016       18:00     02/02/2016

Note: File should be save in .csv format. The attendance types should exactly match with the types in the software

[muneer]

#20078

Hi,

Find the attached document for download the import format.

Note: Save this file as .csv format before import

Thanks,
Muneer

---

Attachments:

[Author]

Posts