File Attachments Tab

Use the File Attachments tab to extract files referenced within or associated with a row of extracted data and include it in an Archive or Extract File. You can attach multiple files to each row in a table.

file attachments tab

The extracted file is “attached” to an extracted database row by three pseudocolumns within the Archive or Extract File. The pseudocolumns are:

File Attachment List

Use the File Attachment List to provide details for each attached file. Each row in the list represents a file that is attached to the extracted data. The arrow icon column indicates the selected row.

Column Prefix
The prefix used to name the pseudocolumns in the Archive or Extract File. Each prefix must be unique to the table.
Trigger Column
The name of a column that controls processing of the file attachment. Click the grid cell to obtain a list of eligible columns in the table. (Only a CHAR, VARCHAR, NCHAR, and NVARCHAR can serve as a trigger column.) Leave blank to indicate that no trigger applies. Optional.
Stop if File Not Found
Processing if a file is not found. Select the check box to stop processing or clear to continue.
Delete File
Deletion of attached file during Delete Processing. Select the check box to delete the file after the associated row is successfully deleted or clear to continue.
Use Default Search Paths
Select the check box to search the default paths for the attachment or clear to search the file Search paths. If selected, you must enter one or more paths in Default File Paths; if cleared, you must enter one or more paths in File Search Paths.
File Search Paths
One or more paths to search for the file, separated by a semicolon. Paths are searched in the order listed. Once the file is found, any remaining paths are not searched. Use the browse button to select paths.

File Name Parts

The file name for the attachment selected in File Attachment List. The name is generated by concatenating values from listed columns with any literals you enter.

You must enter each literal or column name in order on a separate row, enclosing literals in quotes and selecting column names from a drop down list of CHAR, VARCHAR, NCHAR, and NVARCHAR columns in the table.

The name resulting from concatenating the values and literals is combined with the search path(s) in order to locate the appropriate file. For example, if you provide the column name USERID and the literal “.txt” as file name parts, Optim™ searches for and attaches the first file named 123.txt that is located in a designated search path when processing a database row with the value ‘123' in the USERID column.

Default File Paths

One or more paths, separated by a semicolon. These paths are the default search paths for any attachments to any table referenced in the Access Definition and are searched if Use Default Search Paths is selected in the File Attachment List for any file. Paths are searched in the order listed. Once the file is found, any remaining paths are not searched. Use the browse button to select paths.

Short Cut Menu Commands

Use the following commands from the File Attachments List and the File Name Parts list.

Remove
Remove the selected row.
Remove All
Remove all rows from the list.

File Attachment Specifications Identified

A File Attachment icon file attachment icon in the Table Specifications column on the Access Definition Editor table List indicates that File Attachment specifications are defined for the table.