How to import Employee Appointment History from Excel?

1. Prepare an Excel worksheet with the below format or download the sample for reference. To get the full list of fields of Appointment History of your version in Excel, press the Export button to export a full list of fields that match your version.

The valid value for [SALARY_BY] is

  • M - Monthly
  • D - Daily
  • H - Hourly
  • N - None

2. Open the Employee Master, click the Import drop down menu, click Import Appointment History and select the Excel file to import.

p.s. For Salary Increment, just prepare the file for import employee master with a column [START_DATE], it is not require to import Appointment History. The Appointment History will be updated automatically. See How to import employee information from Excel?