Import Customer Direct Debit Details

Use this form to import of cash, banking, or direct debit detail from a comma delimited or tab delimited file.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Load Template

An import template (with the extension .ipt) saves the import settings, enabling you to do multiple imports without needing 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 text file for import.

File Type

Select:

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. 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 you can import. If your source file contains additional columns, use the unused column to skip these columns during import. Contact MYOB support if you require import of additional fields.

Columns to Import/Order of Columns

This column contains 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 and their lengths. 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 import display in each column.

Data Formats

This table displays each column to import, 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.

Output Options

Select one of these options to indicate which processing you require when an error occurs during import:

Do not log to file: The import aborts as soon as an error occurs.
Log to file: The import continues regardless of errors. An error file and a log file are created.
The error file contains all records in error. You can update these records by opening the .bad file in Excel as a comma delimited file, and use it for the next import.
The log file contains details on the import, such as number of records imported.

Save Template

You can save your import settings as a template (with the extension .ipt). You can load the template on your next import, saving manual entry.

Navigate to the directory in which to save the import template. Enter a name for the template and save it.