Attachment import

To import attachments along with the inspection data, such as images from a CCTV inspection, add the attachment files to the same location as the Access middleware database. You must also add records for the attachments to the import tables in the database.

For example, the Neztek Sewer Mains template uses two tables in the Access database to import attachment data: SRCEATTACH for inspection attachments, and SRCEIMAG for observation attachments.

The attachments must be linked to the correct inspections and observations. For example, the INSPNO or INSPKEY column in the SRCEATTACH table links each attachment to a new inspection in the NEWSCTV table or an existing inspection in the SRCESCTV table. These links exist only within the Access database.

Only the attachment file name and location are needed to determine where the attachment can be found. The attachment file path can be relative or absolute.

Note: Absolute directory paths are only supported in an on-premises environment.

The import template might also include mappings for the attachment title and description. If there is no mapping for these fields, then the attachment file name is used for both the title and the description by default.