Using an Existing Database
If you use an existing database, make sure the tables are in the following formats:
Library table
Key |
Type |
Description |
Text (32) |
Short name to identify a library set. This relates a name to a path where the rest of the tables reside. |
|
Text (50) |
|
|
Text (255) |
MRL library path |
FormGroupKeys table
Key |
Type |
Description |
Text (3) |
For example, 001 = key 1 (such as company), 002 = key 2 (such as line of business). |
|
Text (30) |
Key name used in the FormGroups table. |
GlobalRecipients table
Key |
Type |
Description |
Text (30) |
Short recipient name. |
|
Text (50) |
Longer description. |
|
Text (20) |
Used in some print sorting. |
|
Number |
Unique ID. Used to link recipients. |
FormGroups table
Key |
Type |
Description |
Text (30) |
Such as a company. Must be an entry in the FormGroupKeys table where KeyType = 001. |
|
Text (30) |
Such as a line of business. Must be an entry in the FormGroupKeys table where KeyType = 002. |
|
Text (30) |
Such as a recipient. Not yet supported. When supported, this value must be a name in the GlobalRecipients table. |
|
Number |
Unique ID. Used to group forms within the Forms table |
Forms table
Key |
Type |
Description |
Number |
Key from the FormGroups table |
|
Text (30) |
||
Date/time |
||
Text (50) |
|
|
Text (20) |
|
|
Text (20) |
Reserved for future use. |
|
Number |
Unique ID. Used to group sections in the Images table. |
Images table
Key |
Type |
Description |
Number |
Key from the Forms table. |
|
Number |
The order within the form. |
|
Text (30) |
The section name. |
|
Date/time |
|
|
Text (50) |
The section description. |
|
Text (20) |
|
|
Text (20) |
Reserved for future use. |
|
Number |
Unique ID. Used to group fields in the Fields table. |
LinkedRecipients table
Key |
Type |
Description |
Number |
Contains 0=image, 1=form, 2=group |
|
Number |
Form_ID, or Image_ID, or Group_ID |
|
Number |
The key from the GlobalRecipients table. |
|
Number |
|
Fields table
Key |
Type |
Description |
Number |
0=image, 1=form, 3=form set |
|
Number |
0=global, else, Form_ID or Image_ID |
|
Text (32) |
|
|
Text (20) |
|
|
Text (20) |
|
|
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.
© Copyright 2020, Oracle and/or its affiliates. All rights reserved. Legal notices.