Product: ImportOmatic
Description: This solution describes how to resolve the Error: Invalid Institution ID: Institution ID
Environment: All
Versions: All
Answer:
This error occurs when importing bank information and the Institution ID does not match the required format.
The Institution ID must be 8-digits long.
If the Institution ID should have leading zeros, sometimes Excel will strip these leading zeros, resulting in a number that is less than eight digits.
A Regular Expression dictionary can be used to pad the number out to eight digits.
Create an Excel spreadsheet with the following values:
The Institution ID must be 8-digits long.
If the Institution ID should have leading zeros, sometimes Excel will strip these leading zeros, resulting in a number that is less than eight digits.
A Regular Expression dictionary can be used to pad the number out to eight digits.
Create an Excel spreadsheet with the following values:
- Highlight the three columns and copy
- Right click in the white space under Replacement Value and choose Paste values from Excel
- Save the dictionary
- Apply the dictionary to the field with the Institution ID