CB Statement Import Designer

CB Statement Import Designer - Definition tab

Navigator > Setup > Cash Book > Statement Import Designer

You can create or modify an import definition for bank statements downloaded via online banking, and specify how to extract data from the bank file. This definition can be used to import statements by pressing the Import button from CB Bank Reconciliation. Sample import definitions are provided for all major New Zealand banks. You can setup a new definition or modify an existing definition.

Warning: Save new or modified import definitions under a new name as the definitions provided are updated when a Server Installation is performed.

Definition tab

Control the specifications for the import and the MaxBasic code for the import file.

Input Format

Select the import file type.

Note: If your file contains embedded line-feed characters within fields, as can occur in CSV files saved from MS Excel, you should select User Delimited with the default delimiter Chr(13) & Chr(10).

CSV/Tab Delimited CRLF Terminated	Comma separated value file or Tab delimited file, with lines terminated by Carriage Return Line Feed (CRLF) characters. Fields are optionally enclosed in quotation marks (" "), and are separated by commas or the Tab CHR(9) character. Record terminators do not consider quotes.
CSV/Tab Delimited LF Terminated	Comma separated value file or Tab delimited file, with lines terminated by a Line Feed (LF) character. Fields are optionally enclosed in quotation marks (" "), and are separated by commas or the Tab CHR(9) character. Record terminators do not consider quotes.
CSV/Tab Delimited Any Terminator	Comma separated value file or Tab delimited file, with lines terminated by either Line Feed (LF), Carriage Return (CR) or Carriage Return Line Feed (CRLF) characters. Fields are optionally enclosed in quotation marks (" "), and are separated by commas or the Tab CHR(9) character. Record terminators do not consider quotes.
ASCII Fixed Widths	Fixed width ASCII file. Fields are located at fixed positions across each line of the import file.
User Delimited	The Separator and Terminator selections become available. Separator - the character(s) that separates the fields. Defaults to ",". Terminator - the character(s) that separates the lines. Defaults to CRLF Chr(13) & Chr(10).
Excel Worksheet	The Excel Worksheet selection becomes available, and defaults to the first worksheet. Select the sheet from your workbook. Note: Do not use apostrophes (') in worksheet names, as this can cause problems.

Test Import File

Select the import file name. This is used while designing the import definition so data is available to preview.

Add Line Type (Alt+Y)

Delete Line Type (Alt+D)

Insert a new line type tab or delete the last line type tab. Include one line type for each type of data line in the import file.

For Each Line Code

The code that determines the line type for the import file and executes the relevant line type.

Code Editor

Objects include:

Bank Account

Fields from the Bank Account record.

Company

Contains details of the Company name and address.

StatementHead

Fields from the Statement Header.

StatementLine

Fields from the Statement Line.

System

Fields from the System record.

SystemUser

Fields from the System User record.

User

Fields from the User record.

Note: See Import Functions for functions specific to the Import Designer.

Buttons

View Data... (Alt+W)

Preview the data in the import file, based on the line type that has the focus (Line Type 1 by default). You can check you have specified the data fields correctly.

Breakpoint (Alt+B)

Set a code breakpoint on the current line. Click again to toggle to clear the breakpoint. You can also click to the right of a line to set or clear a breakpoint.

Hover the mouse over a breakpoint, then right-click to make a breakpoint unavailable, or access the Breakpoint Properties.

If a condition has been set for a breakpoint, it will be shown when you hover over the breakpoint.

Check Code (Alt+C)

Ensure the code entered in the code editor compiles correctly without the need to import a statement.

Load... (Alt+L)

Load a saved definition for use in the CB Bank Reconciliation form. If you modify one of the supplied definitions, save under a new name so it is not overwritten when you install an Accredo update.

Save... (Ctrl+S)

Save the code as a definition for use in the CB Bank Reconciliation form.

In This Section

CB Statement Import Designer - Line Type tabs

CB Statement Import Designer - After Import tab

CB Statement Import Designer - Comment tab