You may import file attachments via the File Import utility. This page describes the way in which you prepare a structure on the file system of the server where you will place the files to be loaded into the ExtraView database. This structure must be accessible by the ExtraView application server. The image and document files will be loaded from there into ExtraView - either into the database or onto a part of the file system maintained by ExtraView, dependent on the value of the behavior setting ATTACHMENT_REPOSITORY_OPT.
Attachment metadata may be specified using similar metadata entries as for importing image and document fields. The attachments are specified in the import file by using the data dictionary name ATTACHMENT as a mapped field, and defining the file name as the value for that column. The remaining metadata entries that can be used are optional, and are defined as follows:
These metadata fields may be set from the row data that describes the attachment to be imported.
To set the metadata field, the associated dictionary fields, named EVFI_xxx are used to define a column where the metadata values exist.
These field names may be chosen in the File Import Utility to indicate where the metadata values in the row(s) reside. Note that only one set of metadata per row may be specified, and hence importing more than one image/document per row will not permit metadata values unique to the different fields. Import document and image fields is similar to importing file attachments. You may view the example on that page as a model on how to use this feature.
You may import multiple attachments for a single issue, by delimiting the attachment metadata within the appropriate fields. The delimiter used is defined by the behavior setting named DEFAULT_TEXT_REPORT_DELIMITER. Normally, this is a colon character. For example, the EVFI_FILE_NAME field for an issue may contain:
This implies three separate attachments are going to be uploaded. Similarly, use delimited text in fields such as EVFI_ALT_TEXT to provide separate descriptions for each of the attachments.
Attachments may be imported using either the INSERT option or the UPDATE option of the File Import utility.
The validation operation of the File Import function performs the following tests on imported images and documents:
The same validation tests are done on the import operation. Validation errors will cause the import of that row to fail. Other rows are not affected, unless they also have errors.