Upload Employee Data

The upload employee data functionality allows you to upload the data of all the employees in your company in one go through CVS file upload.

It is important to upload the basic details of all the employees of the company to use the Empxtrack system. The basic details include details such as the names, email Id, employee numbers, gender and date of joining of employees.

The Upload employee data allows you to upload the basic details of the employees.  The employees can update the other details after logging  in to the system.

To upload employee data, you need to:

  1. Log into the system.
  2. Go to Settings ->Employee Records Settings-> Upload Employees.

    The Upload Employee Data page appears, as shown in Figure 1.

  3. Click icon from the step one mentioned on the page as  Download data the file to identify the upload format.

     Figure 1

    The download window that allows you to save the employee data format file on your computer appears, as shown in Figure 2.

  4. Click OK.

    The file will be downloaded on your computer.

     Figure 2

    The Opening <import master> page may or may not appear in your browser because its appearance depends on your browser version and your browser settings. If you do not see this dialog box appearing, you can save the target file on your computer and then change the extension of the file to .csv. To know more about saving the import file on your computer, click Save .CSV File.

    You can now open the file in MS Excel. To know how to open the file in MS Excel, click Open .CSV File.

    Once the .csv file is downloaded, you have the format in which the data needs to be put. You can now put the salary structure information in the file, as shown in Figure 3.

    Figure 3

  5. Ensure that dates that you provide, appear in the format mentioned in the .csv file.

    If dates do not appear in desired format then right-click the date cell(s) in which you are providing dates and then select the correct date format so that date appears in <MM/DD/YYYY> format, as shown in Figure 4.

    Figure UpSalStr-8

    Figure 4

    Upload the CSV File

    Once you have added the data of all the employees in the csv file, you can upload the file to Empxtrack system.

    To upload the file, you need to:

  6. Browse the .CSV file from your computer in which you have put data.

  7. Click Upload button appearing next to Upload the same file here text box, as shown in Figure 5.

    Figure 5


    The fields of the CSV file appear with dropdowns having the field name suggested, as shown in Figure 6.

  8. Deselect the non-mandatory  field names for the fields for which you have not provided information or don’t want to upload information of those fields even if the CSV file has data for those fields and then click Go.


    Figure 6

    The data that you have uploaded through CSV file appears for you to check and confirm upload, as shown in Figure 7.

    Figure 7

    The upload status for each record appears, as shown in Figure 8.

     Figure 8

Click on each of these links to know more about them: