Map selected fields to file definition - SmartPlant Foundation - IM Update 48 - Help - Hexagon

The column names of the database can be mapped to the file definition, thereby enabling a Data Capture user to import files into the database.

• If more than one file with the same name result into a single document, the modified date is taken into consideration and the files are attached as different versions to the document.

• If the class definition configured for a document is SPFNDocumentMaster, the attached file is set to master. This master file can be processed for content extraction.

1. In the Tables pane, select a table. The column names of the selected table are displayed in the Table Properties pane.

2. In the Table Properties pane, select one or more check boxes beside the column names to include them in the query.

3. Click Map Selected Fields to map the selected fields to the existing database properties. By default, Name, Description, and Class ID are mapped.

4. In the Map Selected Fields pane, select a complex object from the mapping class list. The business objects defined in the property lists module are displayed in the mapping class list.

5. In the Selected Fields pane, select a column to enable the Mapping Field pane. The Selected Fields pane displays all the selected fields and the custom properties.

6. Set Map Type as the File Def.

7. Select an attribute from the File Attribute list. The File Attribute list displays the File Name and File Path attributes.

8. Type the file path of the file in the File Directory box if you have selected File Path as the file attribute.

9. Click Save.