File Attachment Columns

Three EIM table columns must be populated in order to import file attachments. The following information describes these columns and uses the attachment file budget99.doc as an example.

Column Description Example

FILE_NAME

This column requires the root filename of the file attachment.

FILE_NAME=”budget99”

FILE_EXT

This column requires the extension type of the file attachment (DOC, XLS, or TXT).

FILE_EXT="doc"

FILE_SRC_TYPE

This column requires the value "FILE" or the rows cannot be imported.

FILE_SRC_TYPE="FILE"

You can also use these columns to define hyperlinks, as shown in the following information.

Column Setting

FILE_NAME

Set to actual URL

FILE_EXT

NULL

FILE_SRC_TYPE

‘URL’