Importing a Bank File

To import bank files, you must have access to the following directories under ~\eFrameNET\Environment\companyname\BackgroundProcesses:

• ~\Bank File Import\In

• ~\Bank File Import\Done

• ~\Bank File Import\Logs

• ~\Bank File Import\Errors

  Note

  Contact IDI to be given access.

  A file import processor monitors the directory specified below and processes files deposited in it.

  ~\eFrameNET\Environment\companyname\BackgroundProcesses\Bank File Import\In

File Format

The bank import file you create must be a comma-delimited, plain text file. Each record must be on a separate line and contain the ABA Routing Number and Bank Name.

Validation/Processing

Each row in the file is validated and processed separately. The following validations are performed on each row in the file:

• At least one comma must exist. This allows for commas in Bank Names.

• The first field (all characters up to but not including the first comma) is considered the ABA Routing Number. It must be exactly nine digits in length.

• All characters after the first comma are considered the Bank Name and must be one or more characters in length. Bank Names greater than 50 characters are truncated. If a blank Bank Name is specified, an error is reported.

  If any of the above validations fail for a row, the row is written to a log file and no further processing of the row will occur. Processing will continue with the next row in the file, if one exists.

Adding a New Bank Record to the Table

For each valid row in the file, if the specified ABA Routing Number does not exist in the Bank table, a new bank record is added using the ABA Routing Number and Bank Name from the row.

Changing the Bank Name

If the ABA Routing Number exists, the Bank Name of the existing record is updated with the Bank Name specified in the file.

Processed Files

Once all rows in the file have been processed, the file is moved to the ~\Bank File Import\Done directory. If the file cannot be processed, then it is moved to the ~\Bank File Import\Errors directory.

Log File

A log file resides in the ~\Bank File Import\Logs directory. Rows that do not pass validation are written to this log file. In addition, several statistics are captured and reported, such as the number of records added and the number of records updated.