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.
-
In the Tables pane, select a table. The column names of the selected table are displayed in the Table Properties pane.
-
In the Table Properties pane, select one or more check boxes beside the column names to include them in the query.
-
Click Map Selected Fields to map the selected fields to the existing database properties. By default, Name, Description, and Class ID are mapped.
-
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.
-
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.
-
Set Map Type as the File Def.
-
Select an attribute from the File Attribute list. The File Attribute list displays the File Name and File Path attributes.
-
Type the file path of the file in the File Directory box if you have selected File Path as the file attribute.
-
Click Save.