Chelton Custom Salary Upload Task

Chelton Custom Salary Upload Task

Chelton Custom Salary Upload Task

As the client has some customisation on their Salary screen the usual Bulk Uploader will not work, when the usual Uploader is used all Salary History records are truncated. Hence, a custom script has been created to Bulk Upload salary information while keeping the Salary History intact.

Attached below is the guide that can be used by the SE to complete the task. An IC needs to be involved to prepare the data sheet as required by the script and the SE needs to run a task from the backend.

GUIDE

Referring to the above guide firstly the SE need to run the below command which outputs the HEADERS of the template file. A template file has been attached here too for convenience.
php symfony orangehrm:salaryHistoryUpload
The output of running the command is as follows. This column headers need to be added to a CSV file and needs to be shared with an IC to complete the sheet. 



Once all the required data is filled the CSV file needs to be placed in any location and running the following command will upload the data to the system.
php symfony orangehrm:salaryHistoryUpload --filePath="/var/www/html/OHRMStandalone/TEST/chelton/symfony/salaryData/salary.csv"  --traceSalaryData=0
The parameter traceSalaryData is used to capture if the History record is needed or not. 0 means to keep the data (not delete), 1 means delete the Salary History records. Ideally this will always be 0.

Once the task is run you should get an output as follows with the successes and failed records. The below shows all the records have been successfully uploaded. The failed cases may be shown specifically which you will have to verify with the IC.



IMPORTANT POINTS TO NOTE
  1. The Effective Date columns need to be filled with the data format Y-M-D (2024-03-01)
  2. Removing column headers such as Car Allowance, Other Allowance will fail the script execution. These columns needs to be there as a default entry and the relevant components needs to be added with data if an employee has such records. If an employee has these components and and empty value is uploaded then those data may delete.
  3. Additionally to the above, the Car Allowance and Other Allowance records can be left blank if an employee does not have such data. ONLY the column headers are mandatory. But if data exists then the IC is responsible to add the relevant data on the sheet.
  4. The Amount values (salary values) column should be filled ONLY in digits (decimal places are accepted). The value 35,650.02 is not accepted by the task due to the comma (,), hence the IC should be made aware that the expected value is 35650.02.
Attachments
  1. chelton_salary_uploader.csv - This file is the template file which can be shared with the IC to get the master data. Running the above mentioned command will get you this information.
  2. chelton_salary_uploader_master_date.csv - This file can be used to verify the data values and fill the information by referring to this sheet.