.com Solutions Inc. - logo  
Products - Header Buttons
.
FmPro Script Diff bullet item 7b FmPro Layout Diff bullet item 7b FmPro Migrator bullet item 7b CGIScripter
.
.
.

.
.

FmPro Migrator - Graphical Interface - Title Graphic

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.

.

FmPro Migrator CGI Fields Folder tab - 28K

.

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.

menu: Auto-Enter
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 error.log file).

menu: Display Value List
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.


hline

. .

.

. .
 
 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact