Re: [PHP] import dbf files

2007-05-12 Thread Richard Lynch
On Fri, May 11, 2007 8:23 am, Bosky, Dave wrote:
> My goal is to be able to import dbf files into MySQL on a nightly
> basis.
>
> Can I enable dbase support by uncomment the dbase extension entry in
> the
> php.ini file or is there more to it?

On Windows, assuming you have the dbase DLL matching your PHP version
in the extensions directory, that's almost all there is to enabling
dbase, I presume -- that's how all the other extensions work...

You also have to re-start Apache, or IIS, or the whole machine,
depending on what you are running and how MS feels that day.

> Are there any working examples available that read and import dbf
> files?

Can you export dbf to something like CSV or tab-delimited?

There are usually stock tools for that, which are efficient and
well-tested.

Importing a CSV or tab-delimited is also stock/easy/efficient/robust.

-- 
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] import dbf files

2007-05-11 Thread Robert Cummings
On Fri, 2007-05-11 at 09:23 -0400, Bosky, Dave wrote:
> My goal is to be able to import dbf files into MySQL on a nightly basis. 
> 
> Can I enable dbase support by uncomment the dbase extension entry in the
> php.ini file or is there more to it?

Check the output generated by the phpinfo() function. Check in the
extensions area if sbase support is included. If not, then you'll need
to get the extension and activate it.

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php