From: | Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr> |
---|---|
To: | "Robert Fitzpatrick" <robert(at)webtent(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Converting from dbase |
Date: | 2003-04-05 22:33:47 |
Message-ID: | 200304052233.47824.darko.prenosil@finteh.hr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Saturday 05 April 2003 17:18, Robert Fitzpatrick wrote:
> > I suppose You are familiar with some "DBase" tool like
> > Fox, Clipper etc..
>
> No, but I'll look into it if my current approach doesn't resolve the
> issue.
>
> > (otherwise where did You get those DBF files?).
>
> These are .dbf files from a program a customer is using called ABRA
> (www.abra.com), it is an HR/Payroll software. We are developing their
> Intranet with PHP/PostgreSQL and want to see if we can build a
> PostgreSQL function or PHP class to import or convert regularly and
> maybe even create triggers to check updated PG tables for information
> that came from the dbf files. Flexibility would be great.
>
> > If the language You are using apparent to be Fox, I can
> > try to find this
> > code and send to You.
>
> Appreciated, the current approach has not panned out, yet.
>
> > However, there is "dbase" source from contrib dir (7.2
> > version of postgres).
> > You will probably need to change the Makefile.
>
> This is what I'm trying to use and would like to use, dbf2pg. Do you
> know where I can find docs on this or what to change in Makefile?
Here is a stand-alone Mekefile. All You have to do is show
where are postgreSQL includes(libpg-fe.h) and libpq.so.
Change the first two lines of Makefile:
libpq_include = /usr/local/pgsql/include
libpq_lib = /usr/local/pgsql/lib
Other settings should be good enough(Depends on which platform You are using).
Attachment | Content-Type | Size |
---|---|---|
dbf2pg.tar.gz | application/x-tgz | 25.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2003-04-05 23:25:07 | Re: dbmirror revisions |
Previous Message | Ian Barwick | 2003-04-05 20:19:14 | Re: functions |