What File Format To Import a FileMaker Database Into MySQL?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

What File Format To Import a FileMaker Database Into MySQL?

Postby GreenWay2 » 23. January 2011 05:28

Have a simple, flat file database that is being maintained in FileMaker Pro 10.

Want to import it into MySQL. The MySQL database will be the data source for a PHP-based dynamic website.

Do not expect to need to transfer data from MySQL back to FileMaker Pro.

FileMaker can export the file as:
Tab-Separated Text format -- .tab or .txt
XML format -- .xml
Microsoft Excel format -- .xls or .xlsx
Comma-Separated Text format -- .csv or .txt
HTML Table format -- .htm
Merge format -- .mer
(FileMaker Pro format -- .fp7)

Field contents include:
text (as much as 10 Kbytes per field, will contain commas)
integers (up to a value of 1,000,000)
dates

Would one of the file formats above work well when imported into MySQL? If several are good, is one preferred for importation into MySQL?


Thanks in advance for your help.

XAMPP Lite 1.7.3
XP Pro, SP 3
GreenWay2
 
Posts: 7
Joined: 18. December 2010 23:28

Re: What File Format To Import a FileMaker Database Into MyS

Postby Sharley » 23. January 2011 06:53

Go to http://localhost/phpmyadmin and click on the Import button then down under the section Format of imported file click on the drop box for supported import formats and see if one fits the bill.

Best wishes.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: What File Format To Import a FileMaker Database Into MyS

Postby xfsgpr » 23. January 2011 06:53

I have used CSV file formats using the following command:

Code: Select all
load data local infile 'uniq.csv' into table tblUniq
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(uniqName, uniqCity, uniqComments)


Do you what fields you have in your DB?

phpMyAdmin can also do it for you automatically so it is worth giving it a try. MySQL can import almost anything these days.
xfsgpr
 
Posts: 27
Joined: 20. August 2009 21:45

Re: What File Format To Import a FileMaker Database Into MyS

Postby Sharley » 23. January 2011 07:29

Here are a couple of search result links that may help.

Google 1
Google 2

Good luck and best wishes
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: What File Format To Import a FileMaker Database Into MyS

Postby GreenWay2 » 23. January 2011 23:03

Thanks for the very helpful replies.

Exported the database from FileMaker as a Tab-delimited file. Thought to import it into MySQL using ‘LOAD DATA... INFILE‘ from the mysql command line.

From the XAMPP Control Panel, clicked on Shell and got the window with the ‘#’ prompt.

At the # prompt, entered ‘mysql’ and got
‘ERROR 1045 (28000): Access denied for user ‘ODBC’@localhost’ (using password: NO)’

How to get to the mysql command line, so as to use LOAD DATA... INFILE?



The fields in the database include:
text with commas
text with ‘/’ and other special characters from URLs
dates
integers up to a value of 1,000,000

Thnaks again for your help.
GreenWay2
 
Posts: 7
Joined: 18. December 2010 23:28

Re: What File Format To Import a FileMaker Database Into MyS

Postby Sharley » 23. January 2011 23:15

At the # prompt, entered ‘mysql’ and got
‘ERROR 1045 (28000): Access denied for user ‘ODBC’@localhost’ (using password: NO)’

Try
Code: Select all
mysql -u root
or use phpMyAdmin to Import your file and unless you are very familiar with the CLI or have lots of spare time, PMA will be much quicker and you can see and manipulate your databases in the easy to use GUI - much improved over the years and now my preferred interface.

Best wishes.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: What File Format To Import a FileMaker Database Into MyS

Postby GreenWay2 » 24. January 2011 02:19

The command line window says, ‘Welcome to the MySQL monitor.’ Neat!

Like your point about the CLI being a demanding approach and took a look at phpMyAdmin and it’s import screen.

For ‘Format of imported file’ it offers the choices
DocSQL and SQL.

I may be missing something important... How use phpMyAdmin to import files exported from FileMaker, say as tab-delimited or XML formats? If I read the screen correctly, those formats will not be imported...

Thanks for your very timely help.
GreenWay2
 
Posts: 7
Joined: 18. December 2010 23:28

Re: What File Format To Import a FileMaker Database Into MyS

Postby Sharley » 24. January 2011 02:58

You created a database?

You created a Table?

Go to the database Structure page and select the Table.

Click on Import and locate the .csv file to import.
Down at the bottom you should now see:
CSV
CSV Using LOAD DATA
SQL

Select the option best suited.

Fill in the form presented...

...need I go further and spoil all your fun? :D

More help here if needed.

So as you can see, phpMyAdmin will only show certain items within certain pages when correct criteria has first been met - so some trial and error may be required when expected results are not forthcoming.


BTW, I find the phpMyAdmin Documentation (Gobbledygook) to be somewhat of a heavy read.
We do try and respond quickly to support requests as we know from experience that users are just itching to be going in a forward direction ASAP and frustration seems to only generate even more problems. ;)

Good luck and my very best wishes.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: What File Format To Import a FileMaker Database Into MyS

Postby GreenWay2 » 27. January 2011 22:44

Great! Thanks!

Had gotten to the import screen in phpMyAdmin but not selected the CSV file to import. So, as you say, the screen only showed DocSQL and SQL as file type choices....

Wound up using ‘CSV using LOAD DATA’.

You’re quite right about people being ready to do the next great thing but not having the needed piece of information to get there. I very much appreciate your pointing the way.

Thanks again for your very clear and timely help.

Best regards.
GreenWay2
 
Posts: 7
Joined: 18. December 2010 23:28


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 114 guests