.com Solutions Inc. - FmPro Migrator Files

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.

	FmPro Migator VFP Code Converter FmPro Script Diff SQLite Diff Screenshot Toolbar Printer Maintainer