How to correct validation issues

This quick guide will walk you through the two methods you can use to correct validation issues directly in the Integrated Rate Management (IRM) interface.

Method 1 - Edit directly within the cell

When to use: if you only have a couple of one-off errors that are quick fixes.

How to use:

1. Get taken to the cells with errors by clicking the 'Find error' button
2. Then, you can edit directly within the table to correct the mistake.
3. Simply press 'enter' to save the change, and the validation status will update immediately.

Method 2 - Use 'Find and Replace'

When to use: If you have systematic errors repeated throughout the file e.g. the same typo appearing multiple times. Use this tool for bulk correction (e.g. wrong port code used) is the most time efficient way for you to proceed.

How to use:

1. Click the 'Find & Replace' button, which opens up a box on the right
2. Enter the incorrect field in 'Find' and the correct field in 'Replace with'
3. The system will tell you how many cells will change, click 'Replace All' to apply the changes

Review and submit

Lastly, verify all issues are resolved by checking that no red highlighted cells remain, review any yellow warnings (optional to fix), and confirm all blue auto-corrections are acceptable.

Once all of the critical (red) validation issues are resolved, the 'Complete import' button becomes active. Then you can proceed to processing your rates into Integrated Rate Management.

You will receive a confirmation message when upload is complete.