Import Customer Direct Debit Details

---

The Import Customer Direct Debit Details feature enables import of cash, banking, or direct debit detail from a comma delimited or tab delimited file. An import wizard, which guides you through the various entry fields and forms.

Load Template

An import template (with the extension .ipt) saves the import settings, enabling you to perform multiple imports without having to re-enter the detail. Navigate to the import template. The import template loads and you can update the import settings.

Source File

Navigate to the source file you are about to import. You can use any ASCII file for import.

File Type

Select one of:

• Delimited: The source file contains characters, which indicates the individual import fields. Use these delimiters:, Tab | Space
• Fixed Width: Columns are separated using the column size entered.

Start import at row

Enter the row number from which the import should start. The source file may — for example, have a header record as row 1. In that case, start the import from row 2.

Replace existing records

Select this option to update existing direct debit detail in Greentree Desktop. If you select this option, the matching AR customer's direct debit detail is replaced with the detail contained in the import file.

Columns Available

This column lists all fields that are available for import. If your source file contains additional columns, use the unused column to skip these columns during import. Contact support if you require import of additional fields.

Columns to Import/Order of Columns

This column contains by default all the mandatory import fields. Select all the import fields you require from the Columns Available list. These columns are added to the Columns to import list upon selection.

Click the up and down arrows to change the sequence of import fields. The Source file columns are imported to the fields in the Columns to Import.

Note: Columns to Import and Use Direct Debit are boolean fields. You import file needs to contain the values True or False for these import fields.

Column Delimiters

Select this to import a delimited file:

• Column Separator - The source file contains characters, which indicates the individual import fields. These characters are called delimiters. Select the delimiter for the file to import from the dropdown list.
• Quote Enclosed Column Data - Select this option if quotes (" or ') exist in the import file to indicate text fields. For example, text enclosed in quotes may include commas, which form part of the text. These commas are not considered a column delimiter.

Column Breaks

You have selected to import a file of fixed width. The Column Breaks table displays all the import fields, together with their length. You can edit the Start and Length columns.

Preview of file

This table displays a preview of how the source file is imported, enabling you to verify correctness before you proceed. The table contains the Columns to Import as column headings. The records to be imported display in each column.

Data Formats

This table displays each column to be imported, and the type and format of each import field.

Data Preview

This table displays a final preview of the columns and the data to be imported per column.

---