I have recently been working on a job with a client who gets their data from county data. The county data is contained in .dbf files. Every year the data is updated and my client will get a CD/DVD from someone containing the county data in .dbf format. Now the problem is that my systems have been developed to work entirely off of MySQL (that is not going to change) and I will not be working with this particular client in the future when he gets these annual data updates. So I need a PHP/Python/Ruby script that will convert the .dbf to MySQL once he has uploaded the pertinent .dbf files. All I need, is pointers to correct sources. I don't mind having to do a lot of coding. I just have absolutely no clue where to start. Thanks.
Gerbiler 1 Junior Poster in Training
Recommended Answers
Jump to PostFrom the linked site
You can run the program in a batch mode using command line interface. Besides, it includes a DLL which you can use from your own application.
This would imply you may be able to run this as a utility from your own script and then run …
Jump to PostPerhaps you can provide the client a small utility program they could run on their end against the new files to convert and upload the data to your server, assuming they are running a Windows OS.
Jump to PostNot a script, but looks like free service - can't swear to it.
http://www.whitetown.com/converter/online/
They send you an email with a link to the converted db from 10Mb max dbf.
But this may be promising:
http://webscripts.softpedia.com/script/Database-Tools/dbf-Converter-1794.html
freeware php script …
All 10 Replies
almostbob 866 Retired: passive income ROCKS
http://3d2f.com/programs/18-270-dbf-to-sql-download.shtml mAY HELP
woz gunna edit the text and put the capslock off, but didnt
Gerbiler 1 Junior Poster in Training
This doesn't solve the problem. I wanted a PHP/Python/Ruby script that could do this automatically for my client. I can't use the command line version, because I don't have a windows box, I have a linux box.
Ezzaral 2,714 Posting Sage Team Colleague Featured Poster
From the linked site
You can run the program in a batch mode using command line interface. Besides, it includes a DLL which you can use from your own application.
This would imply you may be able to run this as a utility from your own script and then run the result script within My
SQL to generate the data.
Perhaps you should read more closely before replying so rudely to someone who was merely offering a suggestion to solve your problem.
Gerbiler 1 Junior Poster in Training
whoops, I forgot to say that I am working on a linux box, not a windows. Sorry about that. I edited my answer.
almostbob 866 Retired: passive income ROCKS
runs very nicely under php, on apache, in my application immediately after the uploaded dbf is verified for structure.
Gerbiler 1 Junior Poster in Training
Sorry, as soon as I saw that it was an exe rather than a php script I immediately wrote it off. Didn't realize that you could use it in a php script. The problem is that I don't have a windows box to run EXEs or DLLs. Thanks for the prompt response.
Ezzaral 2,714 Posting Sage Team Colleague Featured Poster
Perhaps you can provide the client a small utility program they could run on their end against the new files to convert and upload the data to your server, assuming they are running a Windows OS.
Gerbiler 1 Junior Poster in Training
Yeah, I could. But my client is on Mac OS X 1.5, Tiger not Windows. And even if they were on Windows, I couldn't guarantee that it would stay that way. A PHP script that is platform independent would be a lot better.
diafol
Not a script, but looks like free service - can't swear to it.
http://www.whitetown.com/converter/online/
They send you an email with a link to the converted db from 10Mb max dbf.
But this may be promising:
http://webscripts.softpedia.com/script/Database-Tools/dbf-Converter-1794.html
freeware php script transforms dbf to mysql
Ujube 4 Newbie since 2003
Check Out Convert MS Access to Mysql [ODBC Filtering] with Php
http://www.ssdecimal.com/ms-access-converter-mysql-odbc-filtering-with-php/
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.