Import from Excel

[Alex]

#19313

How to import attendance from excel sheet

[Vinod Krishnan]

#20373

The attendance can be imported from the excel sheet by following the said procedure.

Save the excel sheet in .csv (MS DOS) format
Select the devices module in the Time registration.
Then ad Device as CSV with IN/OUT.
Then add the path of the file (.csv format) in the Import file
Then save the settings.
After that refresh the communicator.
The data must have been imported to the Attendance module.
Go to the Attendance and check.
If the attendance data is not there in the Attendance module.
Please Clear Data and Import Data. Close all the windows and check the Attendance  again.
Whoops the attendance data will be there.

Please find the sample format of the excel file

---

Attachments:

[Author]

Posts