...
Note that in the event a file of the same name already exists in the 'Not Processed' folder structure the newly rejected file is renamed with a number in brackets i.e. 1234;Scanned PO;PO 1234(1).pdf
These files will need to be manually attended to.
...
Config.ini
...
The Config.ini file is optional. If you are attaching files to record types in the standard manner and the file name's first 'field' the area of the file name before the first ; (semicolin) is the normal RelatedRecordID for that file type, then you wont need a Config.ini file.
The Config.ini is a TAB delimited file. However Commas cannot be used in this file, substituted for a pipe ( | ) character if required.
A resonable level of SQL is required to configure the Config.ini file correctly.
The Config.ini file is used to interpret another 'Unique' field on the related record type's table and resolve to the normal RelatedRecordID. For example when attaching files to a Person (People table) record the normal RelatedRecordID is PersonID, however you could use the Config.ini file to allow the PersonID in the file name to be replaced with another unique field from the People table such as Employee Number instead.
To do this example above a line in the Config.ini file would need to look like the following:
Person SELECT People.PersonID FROM People WHERE People.EmployeeNo = '{1}'
To use Employee Number on timesheets instead of PersonID as well, add the following line to the Config.ini file:
Timesheet SELECT People.PersonID FROM People WHERE People.EmployeeNo = '{1}' Null