RE: FileMaker Pro Schema Export?
From: Chuck Payne [EMAIL PROTECTED] Question are you want to take your data from Filemaker to Excel? No, I want to just go from FileMaker to MySQL, period. Forever. End of story. rantI'm tired of paying FileMaker Tax every year. (The version upgrade went from $149 to $199 this year.) I'm tired of fighting my way through endless sequences of modal dialogs, to do something that should be one line of SQL. I'm tired of the high-cost (and subsequent upgrade churn) of third party tools that are necessary for things as trivial as parsing strings or putting up custom dialogs. I'm tired of the baroque and resource-hungry way you have to put live content on a website./rant After spending several days searching for something on the Internet, I spent a whole day trying to make a general solution. I now have a script that will generate a skeleton CREATE TABLE command that I then go tune up by hand. My script traverses the table for each Text or Number column, and attempts to dimension it properly based on data in the table. I then go back and change some VARCHARs to TEXT, INTS to other numerics as needed, etc. and add PRIMARY KEY, KEY, and FULLTEXT statements It's still quicker to simply key-in schemas for smaller tables, but this has helped port a few really wide tables. The next task is to chop those into suitable 2nd normal form bits that can be JOINed as needed... :-( I'd post the script here, except you need an expensive third-party plug-in to get textual scripts IN or OUT of FileMaker! :-( I'd be glad to import the script into an empty database for anyone interested. Since FileMaker doesn't have variables, you'll have to add a few globals to your table to make it work. -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FileMaker Pro Schema Export?
On Tuesday, October 1, 2002, at 10:25 24h, Jan Steinman wrote: From: Chuck Payne [EMAIL PROTECTED] Question are you want to take your data from Filemaker to Excel? No, I want to just go from FileMaker to MySQL, period. Forever. End of story. If you export a FileMaker database using 'Merge' you get a delimited text file with the first row being the column names. A program could be created to use this first row as column names to create a table. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FileMaker Pro Schema Export?
Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FileMaker Pro Schema Export?
I never actually looked into it. There are so many work arounds I need to do in FileMaker that I just redesign the tables in MySQL. If there isn't a FileMaker converter, I'm sure there is a DBF converter. You can just save you FileMaker databases as DBF and then convert them. On Monday, September 30, 2002, at 09:14 AM, Jan Steinman wrote: Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: FileMaker Pro Schema Export?
Question are you want to take your data from Filemaker to Excel? Because what I had to do was re-create the tables in MySQL then out putting the data to cvs table. Making sure the data was divide by a command, then I use mysqladmin or you can use phpMyAdmin import it into you MySQL. If that what you are doing. I might be able to help a little. Chuck Payne Magi Design and Support Account Protect by ASK! -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 2:52 PM To: Jan Steinman Cc: [EMAIL PROTECTED] Subject: Re: FileMaker Pro Schema Export? I never actually looked into it. There are so many work arounds I need to do in FileMaker that I just redesign the tables in MySQL. If there isn't a FileMaker converter, I'm sure there is a DBF converter. You can just save you FileMaker databases as DBF and then convert them. On Monday, September 30, 2002, at 09:14 AM, Jan Steinman wrote: Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php