The FmPro Migrator CGI-General folder tab contains fields
for entering Field-specific parameters which will be used to generate
Perl CGI scripts for the migrated database. FmPro Migrator generates
Perl CGI scripts for each layout of the FileMaker database, and enables
the developer to specify Field-specific parameters for the fields located
on each individual layout. This feature permits a developer to configure
a field with one set of validation parameters within the Perl CGI scripts
generated for one layout, and to use different validation parameters
within the Perl CGI scripts generated for the same field when it is
used on a different layout.
field: Display As
The default value for the Display As field content is the modified name
of the FileMaker database field. The modified name of each FileMaker
field represents a name which does not contain spaces or special characters
which would prevent it from being used as the name of a database column.
The modified name may not be suitable for display on a web page therefore
this field provides a way to change the displayed name of each field.
The Auto-Enter menu enables auto-enter values similar to the method
implemented by FileMaker. Fields may contain Auto-Enter Creation Time,
Creation Date, Data, Modification Date, Modification Time, Perl Calculation
or Serial Number. The Auto-Enter Creation Date/Time parameters are only
used when new records are created. The Auto-Enter Modification Date/Time
parameters are only used when a record is updated, not when it is created.
The Auto-Enter Data parameter is a static value consisting of text or
numbers which is entered upon record creation or modification. The static
Data value needs to be entered into the "Result =" field.
The Perl Calculation parameter is used during record creation and updating.
The Perl code for the calculation needs to be entered into the "Result
=" field and does not need to be terminated with a ";".
Tip: For situations in which differing behavior is required for database
record creation vs updating scripts, two different FileMaker layouts
could be created. One layout would be used for inserting records and
the other layout could be used for updating records. The insert data
layout could be configured with one set of Auto-Enter options compared
to the options used for the update data layout.
field: Result =
This field is used for additional parameter specifications based upon
the value selected for the Auto-Enter menu. If using the Auto-Enter
Data or Auto-Enter Perl Calculation, the appropriate values or Perl
code need to be entered into this field. The Perl calculation may make
use of any existing Perl variables which have already been declared
in the output script at the time the Auto-Enter directives are processed.
Any syntax errors in the entered Perl code will cause the CGI script
to stop running (script processing errors can be found in the web server
menu: Display Value
The two options for this menu are None and From Value List. If the From
Value List menu item is selected, the values for the value list should
be entered into the Value List Items field. Value List items are used
to build Submit, Query and Delete HTML pages.
field: Value List Items
If the "From Value List" option is selected in the Display
Value List menu, the value list items should be entered in this field.
menu: Validate Data Entry
The options for this menu include None, Not Empty, Characters Only,
Numbers Only (allowing - . e and
E characters in addition to numbers), Integers Only, Numbers
and Characters Only and Email Address. These validation options are
checked during Submit and Update form processing.
field: Validate Numeric Range Low
If validation of a numeric range is required, the lower range should
be entered into this field.
field: Validate Numeric Range High
If validation of a numeric range is required, the higher range should
be entered into this field.
field: Number of Characters Min
If a minimum number of characters must be entered into the field, the
minimum number should be entered into this field.
field: Number of Characters Max
If a maximum number of characters should not be exceeded for the field,
this maximum number should be entered into this field.
field: Custom Validation Text
A standard generic error message is generated for each validation test.
However a custom error text message may be specified within this field
in order to override the standard message. This message will be displayed
for each validation error which occurs for the field. The text entered
within this field should be terminated by an HTML <BR> command.
All other HTML commands may be included as well.