Import GL Trans Tree Information

---

Use the Import GL Tree Information feature to setup transaction trees for GL Accounts in bulk. The import contains the list of Accounts and indicators to set the Transaction Tree as Available and if available, as mandatory or optional.

The import updates one specific tree at a time. Selecting the transaction tree is part of the steps contained in the import wizard. The GL Tree import is performed from a file, such as comma delimited .csv or tab delimited .txt files.

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 will be loaded. You can update the import settings.

Source File

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

File Type

Select one of these:

• Delimited: The source file contains characters, which indicates the individual import fields. You can use these delimiters:, Tab | Space
• Fixed Width: Columns are separated using the column size entered. You can change column size on this form.

Start import at row

Enter the row number from which the import should commence. The source file may for example have a header record as row 1, in which case you will commence import from row 2.

Replace existing records

Select this option to have existing records updated with the information 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 compulsory 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. Use the up and down arrows to maintain the sequence of import fields. The Source file columns will be imported to the fields as specified in the Columns to Import list.

Available and Mandatory are Boolean fields. You must have one of these values in your import file: true /false/True/False/0/1.

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 referred to as delimiters. Select the delimiter for the file you want to import from the dropdown list.
• Quote Enclosed Column Data: Select this option if quotation marks exist in the import file to indicate Text fields. For example, Quote enclosed text 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. The Start and Length columns can be maintained.

Preview of file

This table gives a preview of how the source file will be imported, allowing 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, as well as the Type and Format of each import field.

Data Preview

This table gives a final Preview of the columns and the data to be imported per column.

Transaction Tree

This field lists all the Trees authorised for use by GL Accounts. Select the Transaction Tree that the import is for. Greentree runs through all the GL Accounts contained in the import file and updates the Available and Mandatory options for each Account, for the selected Transaction Tree.

Output Options

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

• Do not log to file: The import will abort as soon as an error occurs.
• Log to file: The import will continue regardless of errors. An Error file and a log file will be created.
• The Error file contains all records in error. Note that you can update these records as required (open the .bad file in Excel as a comma delimited file) and use 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 where you want to save the Import Template. Enter a name for the template and save it.

---