hi all,

does anyone know of a method or way to convert a .sql file or .csv file into dbase for foxpro in php written converts.

I can write code to convert to about anything, but not what he needs, lol.

Thanks, In advance!

Describe the task. I am totally sure that you do not need to "convert .sql file". Maybe you need to export data from mysql to dbase? Why don't you simply select the data from mysql and insert it into dbase within a script?

exactly what I want.

a php script that will take data in a mysql (sql) database, and export to dbase for foxpro. That is to the T, what he wants.

Right now, he is exporting with my own written CSV exporter from mysql, in which once he has exported he has to either 1 open it in excel and save it as a XLS which I can export for him and then to foxpro, or he imports it into Microsoft Access, and converts it into dbase and then into foxpro.

So, just looking for if there's a php script or coding that will convert from mysql query to dbase file encoding. ??? know of anything! I have yet to find something and not a soul who would know. They say, change your ways and such!, can't do it with this client, he stuck on his ways. (we have one client that way).

PS> phpmyadmin, does not do that type of convertion so it's out of the picture for use.

no one else knows, or knows someone who knows. lol!

I never used dbase in the laste 15 years, so I could not say.

did you checked the php dbase documentation?
Does it apply to the current products, or ols one ?
http://www.php.net/manual/en/ref.dbase.php

There is no support for indexes or memo fields. There is no support for locking, too. Two concurrent web server processes modifying the same dBase file will very likely ruin your database.
We recommend that you do not use dBase files as your production database. Choose any real SQL server instead; » MySQL or » Postgres are common choices with PHP. dBase support is here to allow you to import and export data to and from your web database, because the file format is commonly understood by Windows spreadsheets and organizers.

Now that info was helpful!, I will go through the documentation and see if some of it can help me out here. lol!, it aint a end of world emergency for my client, just he would like it if I could do this, and means more business and mula, so I am out looking for anwers. Thank You for your reply!

Originally Posted by cwboaze

So, just looking for if there's a php script or coding that will convert from mysql query to dbase file encoding.

If you have the skill to write your own CSV export writer, you're capable of easily doing the same for DBF. Just look up the format spec and a few hours later you'll be good to go.

Or, if by .SQL files you mean a lot of DML insert statements, run them against an Access database and run an export? That's less direct and more process intensive than simply writing DBF files from code, tho.

that is one thing he does right now, he takes my either (.sql or .csv) export (hand wrote it), and take it to access then converts it to dbase. and then he's into his foxpro software.

do you have any links to come specs on the format, I mean u can name pretty much name a file any extension, just the software opening it has to support it. so writing to .dbase or whatever extension it is, and the formatted needed. Yeah!, that would do!, and would defintely lead to a good test flatform for him, to lead to a development stage peice.

thanks for your advice!

You know Excel can write dbf files, too, right? It sounds as if you're using Excel to get the data into Access, currently, so it's possible to save one step. On that note, Access supports the notion of linked tables, so, if you've got an ODBC driver and a machine that can reach your MySQL database, you can skip the whole import export thing, and simply run a query from within Access and export the results.

That said, it's been many years since I've ever looked at dbf in any shape or form. But I do remember using QBasic code to read and write dbf files directly. If you've never used QBasic, it's a more primitive language than VB. If that was possible, a smart guy and an hour with a modern language like PHP should result in a slick ETL application.

Here's something that seems to cover up to dBase V, which is probably the last version before it died on the vine?

http://www.geocities.com/geoff_wass/...FAQ/qformt.htm

thanks for the info!, I will keep u updated on how it comes out!, don't know if it would be worth writing a program to offer others to use to convert files into .DBF by api or other means, lol. Never know!