You are here: Available Utilities > F > FDT2DB > Using an Existing Database

Using an Existing Database

If you use an existing database, make sure the tables are in the following formats:

Library table

Key

Type

Description

LibraryName

Text (32)

Short name to identify a library set. This relates a name to a path where the rest of the tables reside.

LibraryDescription

Text (50)

 

LibraryPath

Text (255)

MRL library path

FormGroupKeys table

Key

Type

Description

KeyType

Text (3)

For example, 001 = key 1 (such as company), 002 = key 2 (such as line of business).

KeyName

Text (30)

Key name used in the FormGroups table.

GlobalRecipients table

Key

Type

Description

RecipName

Text (30)

Short recipient name.

RecipDescription

Text (50)

Longer description.

RecipCode

Text (20)

Used in some print sorting.

Recip_ID

Number

Unique ID. Used to link recipients.

FormGroups table

Key

Type

Description

GroupName1

Text (30)

Such as a company. Must be an entry in the FormGroupKeys table where KeyType = 001.

GroupName2

Text (30)

Such as a line of business. Must be an entry in the FormGroupKeys table where KeyType = 002.

GroupName3

Text (30)

Such as a recipient. Not yet supported. When supported, this value must be a name in the GlobalRecipients table.

Group_ID

Number

Unique ID. Used to group forms within the Forms table

Forms table

Key

Type

Description

Group_ID

Number

Key from the FormGroups table

FormName

Text (30)

 

FormEffectiveDate

Date/time

 

FormDescription

Text (50)

 

FormOptions

Text (20)

 

FormRevInfo

Text (20)

Reserved for future use.

Form_ID

Number

Unique ID. Used to group sections in the Images table.

Images table

Key

Type

Description

Form_ID

Number

Key from the Forms table.

FormSequence

Number

The order within the form.

ImageName

Text (30)

The section name.

ImageEffectiveDate

Date/time

 

ImageDescription

Text (50)

The section description.

ImageOptions

Text (20)

 

ImageRevInfo

Text (20)

Reserved for future use.

Image_ID

Number

Unique ID. Used to group fields in the Fields table.

LinkedRecipients table

Key

Type

Description

RecipScope

Number

Contains 0=image, 1=form, 2=group

Referring_ID

Number

Form_ID, or Image_ID, or Group_ID

Recip_ID

Number

The key from the GlobalRecipients table.

RecipCopyCount

Number

 

Fields table

Key

Type

Description

FieldScope

Number

0=image, 1=form, 3=form set

Referring_ID

Number

0=global, else, Form_ID or Image_ID

FieldName

Text (32)

 

FieldType

Text (20)

 

FieldFormat

Text (20)

 

FieldLength

Number

 

INI options

Also, if you use an existing database and the tables are already created, make sure you have these INI options set up:

< ODBC_FileConvert >
            
            FrmGrpKy = FormGroupKeys
            
            GlbRec   = GlobalRecipients
            
            FrmGrps	 = FormGroups
            
            LnkRcps	 = LinkedRecipients

These are necessary because some types of databases do not like tables with long names.