If you are receiving the above error this means one of the Columns in the Text files aren't correctly mapped in the data link.
Once a Datalink record has been set up, you can specify the Datalink details and the criteria for importing transactions from the target text file into your accounts system.
Please use the following to make sure the data link is correctly setup.
From the Define Datalinks window, select the Datalink you have just created and click on the Datalink Items icon on the toolbar.
This opens the Datalink Details window. Determine the file location - the Text File Location can be entered manually or chosen by browsing using the button to the right-hand side of the field.
When browsing, the default directory will be that set on the Datalink window. The rest of the window will be the same as when using an ODBC datalink except:
The Data Selection Criteria and the Mark as Completed tables do not contain Enclose checkboxes. The Enclose option is used to enclose values in quotation marks thus making them text fields. It is not required here as the file only contains text fields.
The Test SQL command button on the toolbar will be disabled.
The facility to right-click on a field name to obtain a list of values will only be available for small text files.
Files with an extension of .csv will be assumed to be formatted as comma-separated variables, and those with an extension of .txt will be assumed to be tab-delimited.
Determine the number of columns - whenever a new file is selected, the option First line contains column names will be selected by default.
The first line will be read to determine the column names. If you de-select the option, the first 200 lines will be read in order to determine the maximum number of columns, these will be allocated names COL1, COL2, ... , COLn.
Select the Unique ID - select the column that contains the update table primary key, allowing Transaction Broker to update records.
This field lists the column names from the specified text file or COL1 - COLn if the file does not contain column names.
Sort fields - clicking on this will open a window enabling you to select up to 4 fields on which to sort. By default, they are sorted in ascending order, but you can select Descending to change this sort of criteria.
Once this datalink is set up, you should no longer receive this error