Import a Template in the Insurance Importer (Insurance Module)

Overview

The Insurance module allows you to manage a list of insurances and rates in your portal and assign these to jobs, occupations, workplaces or customers.

This module is not enabled in portals by default. For more information on enabling this feature in your portal, please contact our Support Team.

If you need to, you can update insurances in bulk by importing a template. 

Import a Template in the Insurance Importer

First, go to Config > Payroll > Insurances > click the  in the top right corner > 'Export Re-Import Template CSV.

Make the relevant changes to the file you exported, then you can import it back into Astute.

1. Go to Config > Payroll > Insurance Importer and click Continue.

2. From the Import Insurances screen, click Choose File and select the updated version of the .csv to upload.

3. Click Validate.

The data will be validated and you will see a message confirming the success of the import in the Validation Results screen.

Error Validation

If the upload fails during validation, you will see a list of errors in the Validation Results screen, identifying both the row and the error that has occurred.

Some common validation error messages are:

File headers missing in uploaded file	One or more of the preset file headers in the downloaded template have been removed
Invalid file headers in uploaded file	One or more of the preset file headers in the downloaded template have been changed
Additional file headers in uploaded file	One or more columns have been added to the downloaded template
Expected columns in file missing. Please check the uploaded file.	One or more columns have been removed from the downloaded template
Row X: Number of characters in <<field header>> exceeds permissible limit.	The field length in a specified row has been violated
Only CSV files are supported for insurance importer. Please upload insurances in a CSV file	The format of the file being uploaded is not a .csv

The validation will also read each row in the file for errors, checking or field length and the total number of rows being imported.

Please provide a <<field header>>	A specified mandatory field is missing.
Invalid date format for Start Date (YYYY-MM-DD) OR Invalid date format for End Date (YYYY-MM-DD)	The Start Date or End Date has not been entered with the format YYYY-MM-DD.
Invalid date provided for Start Date OR Invalid date provided for End Date	The date that has been entered in the specified field is invalid
Date cannot be less than <<date>>	The date that has been entered is earlier than the current date. Start Dates cannot be backdated for insurances.
Number of characters in <<field name>> exceeds permissible limit (X)	The number of characters entered in a specified field is greater than the number of allowable characters, X
Number of characters in <<field name>> has not reached permissible limit (X)	The number of characters entered in a specified field is less than the number of allowable characters, X
Provided Insurance ID is invalid	An insurance ID that has been entered does not exist and therefore cannot be updated
Provided region does not exist in the system	The value in the Region field is invalid for the portal
Provided end date must be after provided start date	The End Date that has been entered falls before the Start Date.
Cannot validate state because region is invalid	The value in the Region field is invalid, preventing the system from validating the state that has been entered
Provided state does not belong to the provided region	The state entered is not a valid state for the set region

Complete the Insurance Import

You will receive a confirmation message on-screen when there are no validation errors, and you will be able to continue with the import by clicking Import.

Once the data has been imported into your portal, you’ll see a summary of the number of items that have been processed in the upload. You can also select ‘Import More’ if you have other items to import. This will direct you to the Config > Payroll > Insurance Importer screen.