8.0

Figure 19. Setting up export to a database in the Export Settings dialog box

Now specify to which tables and table columns of the database the field values of the document are to be

exported. To do so, click Setup Fields Mapping...

The left-hand part of the Field Mapping dialog box (Figure 20) contains a list of document sections and

fields. In the right-hand section, specify the corresponding tables and fields of the database. If the

database already contains tables for data export, in the Field Mapping dialog box select a database table

for each section and a database table column for each document field.

If the database does not contain tables for document export, you can create such tables automatically by

clicking Create Tables Automatically. When you click this button, the program will create tables

whose structure is ideal for export. Table rows will be assigned to the corresponding document fields.

Fields groups, fields with multiple instances, document tables, and sections are exported to separate

database tables. Two keys are used to link the parent table with child tables: the Primary key and the

Foreign key. In the parent table, a Primary key is assigned to each entry, while in a child table a Foreign

key containing the value of the corresponding Primary key is assigned to each entry. The keys are

automatically added where necessary. You need only specify to which field the key must be exported.

The Show linked columns option is selected by default. If this option is not selected, the lists of

available table columns in the right-hand side of the tree will not contain columns whose export has

already been set up.