If you use an existing database, make sure the tables are in the following formats:
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 |
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. |
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. |
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 |
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. |
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. |
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 |
|
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 |
|
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 2012, Oracle and/or its affiliates. All rights reserved. Legal notices.