Add a File Import Map

To add a file import map:

1. Select the Administration tab.  Choose File Mapping from the options displayed.

2. The File Mapping Summary is presented.  The list contains records which represent the file mappings currently set up on the system.  If this is the first file mapping to be set up, the list will be empty.

3. Click to display the Issue Import File Layout page.

4. In the Import Definition Name field, enter a name for the mapping being set up.  Since this mapping may be called for use by someone other than yourself, be sure to choose a name that clearly defines the type of mapping, and will be easily identified by others.

5. Click at the right of the Import Definition Type field to display the list of available Type names.  Click on the appropriate option for this mapping.  Valid values include:
   
   MT103 - Money Transfer
   CCD+ - Corporate to Corporate ACH Credit and/or Debit with or without addenda
   CIE+ - Customer Initiated Entry with or without addenda
   PPD+ - Pre-authorized Debit or Credit with or without addenda
   TEL - Telephone Initiated Entry
   WEB - Web Initiated Entry
   XCK - Destroyed Check Entry
   Child Support - Child Support Payment
   RCK - Re-presented Check Entry
   ENR - Automated Enrollment
   TAX - Electronic Tax Payment
   NOC - Notification of Change
   RET - ACH Return
   IAT - International ACH Payment
   POSITIVEPAY - Checks Issued
   CTX - Corporate Trade Exchange, payment
   
   
   Format Section

6. Select the format of the file(s) to be imported using this mapping by click the radio button next to the appropriate value.  Valid values include:
   
   Delimited - field size determined by a field separator (comma, tab, semi-colon, etc.)
   Fixed-width - field size static, based on position and length

NACHA - National Automated Clearing House Association proprietary format, ACH transfers only.  This format does not require a file layout to be set up.  Its format is recognized by the system.

Date Format Section

7. If the Delimited or Fixed-width option was selected, choose the format used for identifying the date in files being imported using this map.  Click the radio button next to the appropriate field, either mm/dd/yyyy or yyyymmdd
   
   Amount Format Section

8. If the Delimited or Fixed-width option was selected, choose the format used when identifying the dollar amount in the files being imported using this map.  Click the radio button next to the appropriate field, either 100.00 (explicit decimal) or 10000 (implied decimal)

9. Click to access the next steps in the process.  
   
   
   If the Delimited option was the format chosen, the Delimited Field Assignment page is displayed.
   
   Field Delimiter Section

10. Selected the Field Delimiter (character or value used as field separators) used in files imported using this map by clicking the appropriate radio button next to the appropriate option.  Valid options include:
    
    Comma
    Semicolon
    Tab
    Space
    Other
    
    If Other is the option selected, enter the value that represents that delimiter in the field provided.

11. In the Text Quotation Character field,  enter the value that is used to identify text in import files.  Punctuation (comma, semicolon, colon, etc.) used within text surrounded by Text Quotation Characters is ignored (as field delimiters/separators) during the import process.  For example, if in files being imported using this map, text is surrounded by quotation marks, enter quotation marks ("") in this field.
    
    
    End-of-line Delimiter Section

12. Click the box next to the end of line identifier used in files imported using this mapping.  Values include:
    
    Smart - EOL can be CR, LF, or CR/LF - End of line delimiter can be carriage return, linefeed, or both carriage return and linefeed
    CR/LF - Carriage Return and Linefeed - End of line delimiter is carriage return and linefeed
    CR - Carriage Return ONLY - End of line delimiter is carriage return only
    TAB - Tab Character - End of line delimiter is tab character
    LF - Linefeed ONLY - End of line delimiter is line feed only
    Other Character - End of line delimiter is something other than the selections available above

13. If the option selected is Other Character, enter that character in the field provided.
    
    
    Import Line Offset Section

14. In the Start From Line field, enter the line number that indicates where the system should begin looking for data in files imported using this mapping.  For example, the first line of the file may be comprised of header/title information.  The second line may be blank.  The data that is to be imported begins on line 3.  In this example, the value that would be entered in the Start From Line field would be 3.
    
    
    Field Layout Section
    
    In this section of the page, you will tell the system where (field position - within the file, or default value - the mapping field provided) the information for each data element to be found.

15. Click at the right of the From field to indicate:
    
    Default - Information for this data element is found in the Default Value field
    File - Information for this data element is found in the Field indicated
    Ignore - Ignore this data element during import

16. If Default is the selected location, indicate that value in the Default Value field.
    If File is the selected location, indicate the field number in the field provided (Field)
    If Ignore is the selection, the system will not look for this data element

17. Repeat this process for each of the Transaction Field Names listed.  When finished, click Save to add this mapping to the system.

18. If in step # 6, the Fixed-width option was the format chosen, the Fixed-width Field Assignment page is displayed.
    
    
    End-of-line Delimiter Section

19. In the Line width field, enter the value that represents the total number of actual data character positions (excluding end-of-line characters) in each line of files imported using this map.

20. Click the box next to the end of line identifier used in files imported using this mapping.  Values include:
    
    Smart - EOL can be CR, LF, or CR/LF - End of line delimiter can be carriage return, linefeed, or both carriage return and linefeed
    CR/LF - Carriage Return and Linefeed - End of line delimiter is carriage return and linefeed
    CR - Carriage Return ONLY - End of line delimiter is carriage return only
    TAB - Tab Character - End of line delimiter is tab character
    LF - Linefeed ONLY - End of line delimiter is line feed only
    Other Character - End of line delimiter is something other than the selections available above

21. If the option selected is Other Character, enter that character in the field provided.
    
    
    Import Line Offset Section

22. In the Start From Line field, enter the line number that indicates where the system should begin looking for data in files imported using this mapping.  For example, the first line of the file may be comprised of header/title information.  The second line may be blank.  The data that is to be imported begins on line 3.  In this example, the value that would be entered in the Start From Line field would be 3.

23. In the Start From Character Position field, indicate the character position at which column 1 begins.  For example, if column one begins in position 1 of the start from line, enter 1 (one) in the Start From Character Position field.  If column begins in character position 26, enter that number in the field.
    
    File Layout Section
    
    In this section of the page, you will tell the system where (field position - within the file, or default value - the mapping field provided) the information for each data element to be found.

24. Click at the right of the From field to indicate:
    
    Default - Information for this data element is found in the Default Value field
    File - Information for this data element is found in the Field indicated
    Ignore - Ignore this data element during import

25. If Default is selected, indicate that value in the Default Value field.   This default value will be used as the field value for each imported record.
    If File is the selected location, indicate (in the Starting Position field), the start position in each record that the specified data element is to be found.  In the Length field, enter the maximum length of that field.
    If Ignore is the selection, the system will not look for this data element in the file being imported.

26. Repeat this process for each of the data elements listed.  When finished, click Save to add this mapping to the system.