Create/edit delimited upload profile

The Create/Edit Delimited Upload Profile Page includes the following four sections:

Note: Whether many of the fields listed below display on the page depends on how you have configured related properties values.

The Create/Edit Fixed Width Upload Profile page includes the following four sections:

Upload Profile Information

Profile Name

The name of the upload profile

Date Format

The format of dates contained within files that are to be uploaded using the profile.

Field Delimiter
(Delimited formats only)

The character used to separate fields within files that are to be uploaded using the profile. The following delimiters are available:

  • Asterisk: *
  • Semi-Colon: ;
  • Comma: ,
  • Tilde: ~
  • Pipe: |
  • Tab (character not displayed)
Number of Header Rows

Define the number of lines to ignore when importing a file. For example, if the first line is a header, you don't have to remove it from your file before you import it - you can just choose to skip the first row.

Duplicate File Check

Indicates whether the system allows or prevents uploaded files from being uploaded again during a certain number of days (specified in a property file).

A selected check box indicates that the system checks for duplicate files then reject duplicates.

Profile Access

Indicates whether the profile can be accessed by other users:

  • Private – Only the creator of the profile can see the profile and initiate uploads based on it.
  • Public – Other users in the same corporation and with the required user entitlements for Upload have access to the profile.

Default Values

Transaction Type

Select a default transaction type from these options:

  • Issue (Issue Add and Issue Delete)
  • Cancel (Void Add and Void Delete)
Note: Depending on how you configure property values associated with transaction types, you can choose to show or hide any of the values above.
Bank

Type the name of the default financial institution

Account Number

Type the default account number

Issue Date

Type the date the check was issued in the mm/dd/yyyy format, or select this date from the calendar.

Transaction Type Mapping

Each transaction in an upload issue file must include transaction codes, which Universal Online Banker requires in order to correctly interpret the transaction type. The Transaction Type Mapping section of the upload profile associates each of the four basic transaction types with a specific transaction code. The transaction types are:

  • Issue (issue add and issue delete )
  • Cancel (void add and void delete)

Any issues file uploaded with the profile must use these codes.

Note: Depending on how you configure property values associated with transaction types, you can choose to show or hide any of the values above.

Upload Profile Fields

The Available list includes these fields that can be added to the profile:

Note: If a Type, Account, or Issue Date value is entered in the Default Values Transaction fields, the corresponding Field Start and Field Width fields are not required.
  • Transaction Type
  • Bank
  • Account Number
  • Check Number
  • Issue Date
  • Check Amount
  • Reference
  • Payee
  • User Defined 1, 2, 3

The Selected list includes the fields that are presently in the profile.

Field/ Option Description
Move Selected (right arrow) From the Available list, select a field that you want to add to the profile, and click the Move Select right arrow.
Note: Use the CTRL key to select multiple non-adjacent items, and the SHIFT key to select multiple adjacent items.
Move All (right arrow) To add all Available fields to the profile at one time, click the Move All right arrow.
Move Selected (left arrow) From the Selected list, select the field that you want to remove from the profile, and click the Move Selectedleft arrow.
Note: Use the CTRL key to select multiple non-adjacent items, and the SHIFT key to select multiple adjacent items.
Move All (left arrow) To remove all fields from the profile at one time, click the Move All left arrow.
Up button
Down button After all fields have been added to the Selected area, use the Up and Down buttons to set the order of the fields so that they match exactly the order of the fields in the files to be uploaded.
Note: How the fields on this page are displayed is based on a properties setting. In addition:
  • An asterisk (*) indicates that a field is required for the selected profile type.
  • A plus (+) indicates fields that have a default value option and are required if no default is selected.

    For example, if a value is entered in the Transaction Type, Account Number, or Issue Date fields, then the corresponding Field Start and Field Width fields are not required.

    You may or may not see the plus (+) indicator, depending on how this field is configured.