Filename |
Features |
contact_management_instructions1.txt |
This file contains the setup, usage and
troubleshooting instructions for FmPro Migrator. |
contact_management_report_oracle1.txt |
Contact_Management.fp5 Database Structure
Report. This report file includes summary and detail information
for the structure of the source FileMaker Pro database file. This
info includes a listing of each field, field type, Oracle column
name, Oracle column type, field entry validation parameters, calculation
formulas, listing of scripts, relationships
and field info by layout. |
contact_management_report1.txt |
Contact_Management.fp5
Database Structure Report - Generic Version. This report file includes
summary and detail information for the structure of the source FileMaker
Pro database file. This version of the report is a generic version
of the Database Structure Report which does not include Oracle migration
related information.This version of the report is useful for situations
in which the report is used solely for documentation purposes. |
contact_management_create_table1.sql |
This sql
script creates the Oracle user, tablespace and table for the FileMaker
data.
Notes: The Oracle DBA should review and update the DDL code within
this file prior to creating the tablespaces, table, sequence, and
trigger. The sequence start value (if implemented) should be one
increment higher than the highest record in the FileMaker Pro database
file. The Oracle VARCHAR2 column widths should be reduced to the
maximum size actually used within the FileMaker Pro database file.
CLOB/BLOB datatype columns may be stored within locally managed
tablespaces with Oracle 9.2.0. Otherwise, a dictionary managed tablespace
should be used. |
contact_management_fmpro_to_oracle_xfer_odbc1.pl
[Enterprise Edition feature] |
This Perl program copies all of the records from the FileMaker
Pro database, then inserts the records into the Oracle database.
Large text fields (over 4000 characters) are written to CLOB columns
and FileMaker Pro Container field data is written to BLOB columns.
Requirements: Perl DBI module
Perl DBD::ODBC module [reads data from FileMaker and writes data
into Oracle] Oracle client software and Oracle ODBC driver must
be installed on the computer running this program. FileMaker ODBC
driver.
FileMaker must be running in Multi-User mode with the Local and
Remote Data Access Companions enabled. The ODBC Max Text Length
parameter needs to be increased from 255 to 65000. The name of
the FileMaker database must not contain spaces or special characters.
Oracle Requirements:
Oracle 8.1.6 (or higher) is required in order to use bind variables
containing more than 4000 bytes with LOB columns. Oracle 9.2 is
required in order to store LOBs in locally managed tablespaces
and/or use the auto-allocate storage parameter.
ODBC DSN Names:
FileMaker DSN Name: contact_management_fmp_dsn
Oracle DSN Name: contact_management_ora_dsn
Due to the lack of a FileMaker Pro ODBC
driver for FileMaker 5.5/6.0 on MacOS X- this program must be
run on a Windows server at the present time. The FileMaker Pro
database however may reside on MacOS X, 8.x/9.x or Windows.
|
contact_management_fmpro_to_oracle_xfer_odbc21.pl |
EXAMPLE NOTES: This program provides an example of reading a
binary file specified by a filepath for insertion into Oracle.
This code will require customization for the FileMaker database
being converted. This program provides a work-around for the situation
with Container field data being changed by FileMaker Pro depending
upon the hosting platform.
This Perl program copies all of the records from the FileMaker
Pro database, then inserts the records into the Oracle database.
Large text fields (over 4000 characters) are written to CLOB columns
and FileMaker Pro Container field data is written to BLOB columns.
Requirements: Perl DBI module
Perl DBD::ODBC module [reads data from FileMaker and writes data
into Oracle] Oracle client software and Oracle ODBC driver must
be installed on the computer running this program. FileMaker ODBC
driver.
FileMaker must be running in Multi-User mode with the Local and
Remote Data Access Companions enabled. The ODBC Max Text Length
parameter needs to be increased from 255 to 65000. The name of
the FileMaker database must not contain spaces or special characters.
Oracle Requirements:
Oracle 8.1.6 (or higher) is required in order to use bind variables
containing more than 4000 bytes with LOB columns. Oracle 9.2 is
required in order to store LOBs in locally managed tablespaces
and/or use the auto-allocate storage parameter.
ODBC DSN Names:
FileMaker DSN Name: contact_management_fmp_dsn
Oracle DSN Name: contact_management_ora_dsn
Due to the lack of a FileMaker Pro ODBC
driver for FileMaker 5.5/6.0 on MacOS X- this program must be
run on a Windows server at the present time. The FileMaker Pro
database however may reside on MacOS X, 8.x/9.x or Windows.
|
contact_management_fmpro_max_fieldsize1.pl
[Enterprise Edition feature] |
This Perl
program reads all of the data from the FileMaker database then produces
a report showing the maximum amount of data stored within each field.
This info is used to provide guidance when sizing the column widths
in the Oracle database. |
contact_management_fmpro_image_export1.pl
[Enterprise Edition feature] |
This Perl program exports the JPEG image
data from the specified FileMaker container field to the specified
output directory. |
example_instructions.txt
[Enterprise Edition feature]
|
This file contains
the setup, usage and troubleshooting instructions for the Perl CGI
scripts generated by FmPro Migrator Enterprise Edition. |
|
This HTML submit page POSTs
information to the example_submit1 CGI script. The fmpro_migrator_oracle_submit_form.zip
file includes example Perl code files, HTML files and flowchart
files in gif, png and VISIO formats for the Submit Form. |
example_submit1
[Enterprise Edition feature] |
This Perl
program accepts web submitted form data, provides data validation
and auto-enter processing, then writes the entered data into the
database. |
example_query1.html Query
Form Flowchart
fmpro_migrator_oracle_query_form.zip
[Enterprise Edition feature] |
This HTML query page POSTs information
to the example_query1 CGI script. The fmpro_migrator_oracle_query_form.zip
file includes example Perl code files, HTML files and flowchart
files in gif, png and VISIO formats for the Query Form. |
example_query1 Sample
Query List
[Enterprise Edition feature] |
This Perl
program processes web queries which are displayed as a list of query
results retrieved from the database. |
example_display_record1 Sample
Display Record
[Enterprise Edition feature] |
This Perl program accepts
the primary key value passed in the URL then retrieves and displays
this one record from the database. If the cnum parameter is passed
to this script in the URL, then this script simply passes the GIF
or JPEG image data to the browser. |
example_update1.html Update
Form Flowchart
fmpro_migrator_oracle_update_form.zip
[Enterprise Edition feature] |
This HTML
update page POSTs information to the example_update1 CGI script.
The fmpro_migrator_oracle_update_form.zip file includes example
Perl code files, HTML files and flowchart files in gif, png and
VISIO formats for the Update Form. |
example_update1 Sample
Update List
[Enterprise Edition feature] |
This Perl program processes
web queries which are displayed as a list of query results retrieved
from the database. |
example_update_record1 Sample
Update Record
[Enterprise Edition feature] |
This Perl
program accepts the primary key value passed in the URL then retrieves
and displays this one record from the database with updatable fields.
If the cnum parameter is passed to this script in the URL, then
this script simply passes the GIF or JPEG image data to the browser. |
example_update_record_validate1
[Enterprise Edition feature] |
This Perl program accepts web submitted
form data from the update script, provides data validation then
updates the specified record in the database. |
example_delete1.html Delete
Form Flowchart
fmpro_migrator_oracle_delete_form.zip
[Enterprise Edition feature] |
This HTML
update page POSTs information to the example_delete1 CGI script.
The fmpro_migrator_oracle_delete_form.zip file includes example
Perl code files, HTML files and flowchart files in gif, png and
VISIO formats for the Delete Form. |
example_delete1 Sample
Delete List
[Enterprise Edition feature] |
This Perl program processes
web queries which are displayed as a list of query results retrieved
from the database. |
example_delete_record_display1 Sample
Delete Record
[Enterprise Edition feature] |
This Perl
program accepts the primary key value passed in the URL then retrieves
and displays this one record from the database. If the cnum parameter
is passed to this script in the URL, then this script simply passes
the GIF or JPEG image data to the browser. |
example_delete_one_record1
[Enterprise Edition feature] |
This Perl program accepts the primary
key value passed in via an HTTP POST then deletes that one record
from the database. For security reasons the primary key column name
is hard coded into this script. Also, the referer URL must match
the delete_record_display script - or the record will not be deleted. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|