• View Page Source

• Recent Changes
  Page Index
  About
  SystemInfo
  

  IT_slab_2010
  UndefinedPages
  

How to import employees from an Excel spread sheet?#

This option will enable a quick upload of information of many employees from an Excel spread sheet. The application expects the data in the excel sheet to be in the pre-defined format. Prepare the data in the prescribed format before importing.

Follow these steps to import the information:

1. Click on Employee tab > Import Employees button to open the Excel Import dialog
2. Browse to the appropriate file (example:D:\payrolldata\add_emp.xls)
3. Click on upload file to transfer the excel file to the server. This will create a new employee from the data available in each row of the excel sheet.
4. Upon clicking on Upload file button, you will be asked for a confirmation on mapping the details of the data that needs to be imported. If the data is in the prescribed format, the importer will automatically map the information.
5. Click on Import button to proceed.
6. Incase there are any master values found in excel, which are not present in the database, you can add them using 'Add New' option or you can select the existing master using the 'Remap to' option.
7. Click on Import button after making the necessary selections.
8. A log message on the status of import will be shown after completion. Please read this log to check the status of data transfer.