Fidelity Bank Business Online Banking User Guide

105

Importing Participants Using a CSV File Add entries to a template by importing a comma-separated values (CSV) text file. Each line in the file must contain the following fields in the order listed: • Participant Name: 1 to 22 characters; required • Participant Nickname: 1 to 40 characters; required • Participant Institution Name: 1 to 22 characters; required for new participants only • Participant Routing Number: 9 digits; required • Participant Account Number: 1 to 17 characters; required • Participant Account Type: Checking, Savings, or Loan; required • Participant Status: Active or Hold; required • Participant Group: 0 to 40 characters • Participant Discretionary Data: 0 to 2 characters • Amount: Number with no dollar sign; required • Hold: TRUE or FALSE; defaults to FALSE if unspecified • Prenote: TRUE or FALSE; defaults to FALSE if unspecified • Addenda: 0 to 80 characters Please make note of the following requirements: • The first line in the file must contain valid data; the file must not contain a header record. • If any field contains a comma, the entire field must be enclosed in double quotation marks (for example, “1,234.56”). • If any required fields are missing, the file will be rejected. If a field is not required, a blank value can be provided. • If a nickname matches an existing participant but the other fields do not match that participant’s existing information, the file will be rejected. If a participant with the given nickname does not exist, it will be added to the system.

ACH: Adding Participants to a Template