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.


    • Related Articles

    • OS to Enterprise Data Migration Tool

      Please find the deployment guide from the link OS to Enterprise Migration - Deployment Guide.

    • CCS Pay Rate Update

      CCS Pay Rate Update Client requests to update Pay Rates for their employees from time to time. As this was a frequent requirement a custom script was written to do this task to avoid the manual work. Client's requirement is to update the Pay Rates of ...

    • Opensource Demo Instance Upgrade

      Upgrading Opensource Demo Environment Details DB Name: demo_opensource Host: db Codebase: /var/www/html/OHRMStandalone/DEMO/opensource-demo74.orangehrmlive.com Server: Faith The above config values can be found on <root>/lib/confs/Conf.php file. ...

    • How to change encrypted mysql password in databases.yml

      Updating any encrypted database password of database.yml files can be done following the below steps. Login to Support repo and check out 'db-password-encrypt' task from below path.  ...

    • Add doner in Gender Links instance

      Gender Links is a custom client. There can be a configuration request to "Add Doner", This needs to be added from the back end 1. Backup the database backup_db /var/www/html/OHRMStandalone/PROD/genderlinks/ 2. Insert the below query INSERT INTO ...