Bulk update Meal Allowance Rates (from Award Positions)

To update your Meal Allowance Rates from your Award Positions, you can bulk export the rates to a .csv, make your changes and re-import to update.

1. Navigate to the sidebar to open the main menu > Import/ Export > CSV Import.

Snag_b87e06b.png

6. Click the 'Select Import Type' dropdown and choose Award Position Meal Allowance Rates (From Export).

7. Click Export All Award Position Meal Allowance Rates.

Snag_bbcd936.png

8. This will export a .csv with  the following fields:

  • Award ID (read only - do not update)
  • Award name (read only - do not update)
  • Classification (read only - do not update)
  • Position name (read only - do not update)
  • Day (read only - do not update)
  • Type (read only - do not update)
  • Hours (read only - do not update)
  • Pay
  • Charge
  • Record ID (read only - do not update)

Update the pay and charge rates in the .csv as required, and save as a new file ready to import. Do not remove any columns, just update rates as needed. 

11. To import the updated rates, navigate to the sidebar to open the main menu > Import/ Export > CSV Import.

 

Snag_b87e06b.png

6. Click the 'Select Import Type' dropdown and choose Award Position Meal Allowance Rates (From Export).

7. Click Choose File, and find the updated csv you have saved. 

9 Click Import CSV.

You will see a loading bar if the upload is working. Otherwise you might receive an error if there is something wrong with the file e.g. not formatted correctly.

Snag_bc14a0d.png

10. Once correctly imported, you can go into the Awards & Agreements  to check your changes have applied.