.com Solutions Inc. - logo  
Products - Header Buttons
.
FmPro Migator bullet item 7b VFP Code Converter bullet item 7b FmPro Script Diff bullet item 7b SQLite Diff bullet item 7b Screenshot Toolbar bullet item 7b Printer Maintainer
.
.
.
. .

 

 

. .

 

...
.

Fmpro Migrator - Oracle Files Title

FmPro Migrator Demo Available for download...

FmPro Migrator generates 5 - 19 output files to facilitate the migration of FileMaker Pro databases to Oracle database tables. These files provide for a direct ODBC data transfer of all data including large text field and Container field data into Oracle tables. FmPro Migrator Enterprise Edition also generates Perl CGI files providing a web-based interface to the migrated data (including images). This page provides descriptions of the generated output files, links to sample files created by FmPro Migrator and flowcharts for Perl CGI script processing. These migration scripts were produced from the FileMaker supplied Contact Management.fp5 and Asset Management.fp5 template files. Click on the link to the example filename to see the output file generated by FmPro Migrator.

.

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.
example_submit1.html                   Submit Form Flowchart
fmpro_migrator_oracle_submit_form.zip
[Enterprise Edition feature]
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.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

 

.

hline

. .

.

 

. .

 

 

 

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

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact