Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Convert File Maker to SQL Database
Name: dlublink Date: December 27, 2003 at 11:56:36 Pacific OS: NA CPU/Ram: NA
Comment:
Hi.
I have a a 200 megabyte FileMaker Database that I need to convert to SQL so that it can be used on a PHP website. It contains some graphics (which is part of why it is soo big.) Is there any quick way to convert it to SQL without having to pay FileMaker for their program?
Also It would be nice if I could extract the graphics and have the file name be the primary key from the field they were pulled from.
Name: anonproxy Date: December 27, 2003 at 21:45:03 Pacific
Reply:
FileMaker has an ODBC interface, correct? Use a script (maybe in PHP) to pull the data from FileMaker and dump it into the other database. Example here. Write your SQL queries and wrap your script code around them.
"extract the graphics and have the file name be the primary key from the field they were pulled from."
Do this while you are transfering the data or after. I suppose it would be more straightforward to alter the data after you have made the conversion.
It's usually best to simply use the vendor software for this task unless you have a good idea of what you are doing. In the end buying the software may actually save you time, hence money.
Summary: hi guys,I wonder if you could help me out please! am trying to connect to sql database and I want to generate reports of the data stored.Could some one help me out with the code If you ignore the Basi...
Summary: I am currently running a Visual FoxPro database on a Netware 4.11 server. The latest version of the software that uses the FoxPro database will no longer support Novell. I will be purchasing a new W...
Summary: that's the update batch file....but still not working...it stops running on the "for /f "tokens=*" %%i in (D:\MyImport\Dirlist.txt)" and it gave me the message: the syntax of the command is incorrect"...