.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 - MySQL Files Title

FmPro Migrator Demo Available for download...

FmPro Migrator generates 5 - 19 output files to facilitate the conversion of FileMaker Pro databases to MySQL database tables. These files provide for a direct ODBC/perl dbd::mysql data transfer of all data including large text field and Container field JPEG data into MySQL 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. Click on the link to the example filename to see the output file generated by FmPro Migrator. 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_mysql1.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, MySQL column name, MySQL 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 MySQL 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 MySQL table for the FileMaker data.
Notes: The MySQL DBA should review and update the DDL code within this file prior to creating the table. The MySQL VARCHAR column widths should be reduced to the maximum size actually used within the FileMaker Pro database file.
contact_management_fmpro_to_mysql_xfer_odbc1.pl
[EE Edition feature]

This Perl program copies all of the records from the FileMaker Pro database, then inserts the records into the MySQL database. Large text fields (over 255 characters) are written to Text columns and FileMaker Pro Container field data is written to LongBLOB columns.
Requirements:
Perl DBI module
Perl DBD::ODBC module reads data from FileMaker
Perl DBD::mysql module writes data into MySQL
MySQL software 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.

Database Connections:
FileMaker ODBC DSN Name:
contact_management_fmp_dsn
MySQL Connection: database=test:host=g4.dotcomsolutionsinc.net:port=3306

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_mysql_xfer_odbc21.pl
[EE Edition feature]

EXAMPLE NOTES: This program provides an example of reading a binary file specified by a filepath for insertion into MySQL. This code will require customization for the FileMaker database being converted.
This Perl program copies all of the records from the FileMaker Pro database, then inserts the records into the MySQL database. Large text fields (over 255 characters) are written to Text columns and FileMaker Pro Container field data is written to LongBLOB columns.
Requirements:
Perl DBI module
Perl DBD::ODBC module reads data from FileMaker
Perl DBD::mysql module writes data into MySQL
MySQL software 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.

Database Connections:
FileMaker ODBC DSN Name:
contact_management_fmp_dsn
MySQL Connection: database=test:host=g4.dotcomsolutionsinc.net:port=3306

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 MySQL database.
contact_management_fmpro_export_image1.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_mysql_submit_form.zip
[Enterprise Edition feature]
This HTML submit page POSTs information to the example_submit1 CGI script. The fmpro_migrator_mysql_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_mysql_query_form.zip
[Enterprise Edition feature]
This HTML query page POSTs information to the example_query1 CGI script. The fmpro_migrator_mysql_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_mysql_update_form.zip
[Enterprise Edition feature]
This HTML update page POSTs information to the example_update1 CGI script. The fmpro_migrator_mysql_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_mysql_delete_form.zip
[Enterprise Edition feature]
This HTML update page POSTs information to the example_delete1 CGI script. The fmpro_migrator_mysql_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 Display Record 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