pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feeddbf2pg, visual foxpro and other nonsense
6+ messages / 6 participants
[nested] [flat]
* dbf2pg, visual foxpro and other nonsense
@ 2002-07-09 17:27 Mike McCormac <MikeM@jcmh.org>
0 siblings, 3 replies; 6+ messages in thread
From: Mike McCormac @ 2002-07-09 17:27 UTC (permalink / raw)
To: pgsql-interfaces
i've been importing older foxpro tables (x-base files) into postgresql
with much success using dbf2pg... however, visual foxpro files don't
seem to work i just get an error.
does anyone know of any successful means of importing this data
directly? our backend application is built in java... are there any
good solutions with JDBC??
this is relatively urgent, so if anyone who replies can CC me at this
email, i'd be much appreciated.
thanks,
mike
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: dbf2pg, visual foxpro and other nonsense
@ 2002-07-10 15:19 Jeremy Buchmann <jeremy@wellsgaming.com>
parent: Mike McCormac <MikeM@jcmh.org>
2 siblings, 0 replies; 6+ messages in thread
From: Jeremy Buchmann @ 2002-07-10 15:19 UTC (permalink / raw)
To: Mike McCormac <MikeM@jcmh.org>; +Cc: pgsql-interfaces
On Tuesday, July 9, 2002, at 10:27 AM, Mike McCormac wrote:
> i've been importing older foxpro tables (x-base files) into postgresql
> with much success using dbf2pg... however, visual foxpro files don't
> seem to work — i just get an error.
>
> does anyone know of any successful means of importing this data
> directly? our backend application is built in java... are there any
> good solutions with JDBC??
>
You can copy the Foxpro tables to text and then copy them into Pg.
The problem is, Foxpro likes to make its data "dirty" by surrounding text
with quotes, inserting newlines for no reason and things like that, so
you may need to write a script or something that strips all that crap
out.
Have fun.
--Jeremy
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: dbf2pg, visual foxpro and other nonsense
@ 2002-07-12 18:14 Darko Prenosil <darko.prenosil@finteh.hr>
parent: Mike McCormac <MikeM@jcmh.org>
2 siblings, 0 replies; 6+ messages in thread
From: Darko Prenosil @ 2002-07-12 18:14 UTC (permalink / raw)
To: Mike McCormac <MikeM@jcmh.org>; pgsql-interfaces
On Tuesday 09 July 2002 16:27, Mike McCormac wrote:
> i've been importing older foxpro tables (x-base files) into postgresql
> with much success using dbf2pg... however, visual foxpro files don't
> seem to work i just get an error.
>
> does anyone know of any successful means of importing this data
> directly? our backend application is built in java... are there any
> good solutions with JDBC??
>
> this is relatively urgent, so if anyone who replies can CC me at this
> email, i'd be much appreciated.
>
> thanks,
> mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Are You FoxPro programmer ?
If Yes, write simple program that reads table by table and generate PostgreSQL
CREATE TABLE and INSERT INTO expressions. Save the file and execute it with
psql. Before about a year i did wrote such conversion program. If you need
it, let me know and I'll try to find it.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: dbf2pg, visual foxpro and other nonsense
@ 2002-07-25 23:44 kklein <kklein@ix.netcom.com>
parent: Mike McCormac <MikeM@jcmh.org>
2 siblings, 0 replies; 6+ messages in thread
From: kklein @ 2002-07-25 23:44 UTC (permalink / raw)
To: Mike McCormac <MikeM@jcmh.org>
If you have the Visual Foxpro IDE, you can convert a VFP .dbf to a
FoxDOS format using the command COPY TO filename FOX2X, then use dbf2pg
on the resulting file.
Mike McCormac wrote:
> i've been importing older foxpro tables (x-base files) into postgresql
> with much success using dbf2pg... however, visual foxpro files don't
> seem to work -- i just get an error.
>
> does anyone know of any successful means of importing this data
> directly? our backend application is built in java... are there any
> good solutions with JDBC??
>
> this is relatively urgent, so if anyone who replies can CC me at this
> email, i'd be much appreciated.
>
> thanks,
> mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: dbf2pg, visual foxpro and other nonsense
@ 2006-04-08 20:52 marian beier <marianbeier@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: marian beier @ 2006-04-08 20:52 UTC (permalink / raw)
To: pgsql-interfaces
I could not find any final solution for converting Visual FoxPro dbf
files to postgress.
If somebody has a script, or a new version of dbd2pg, which works with
this dbf files, please let me know ASAP. I'm running FreeBDS, and found
dbf2pg, in databases/postresql81-server/work/contrib
I would need a similar tool to runn it in a script from crond, so a
"COPY TO filename FOX2X" would not help me too much.
Thank you, Marian.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: dbf2pg, visual foxpro and other nonsense
@ 2006-04-08 21:25 Joshua D. Drake <jd@commandprompt.com>
parent: marian beier <marianbeier@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Joshua D. Drake @ 2006-04-08 21:25 UTC (permalink / raw)
To: marian beier <marianbeier@gmail.com>; +Cc: pgsql-interfaces
marian beier wrote:
> I could not find any final solution for converting Visual FoxPro dbf
> files to postgress.
> If somebody has a script, or a new version of dbd2pg, which works with
> this dbf files, please let me know ASAP. I'm running FreeBDS, and found
> dbf2pg, in databases/postresql81-server/work/contrib
> I would need a similar tool to runn it in a script from crond, so a
> "COPY TO filename FOX2X" would not help me too much.
> Thank you, Marian.
Use ODBC to connect to Foxpro and link to PostgreSQL :)
Joshua D. Drake
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-04-08 21:25 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-09 17:27 dbf2pg, visual foxpro and other nonsense Mike McCormac <MikeM@jcmh.org>
2002-07-10 15:19 ` Jeremy Buchmann <jeremy@wellsgaming.com>
2002-07-12 18:14 ` Darko Prenosil <darko.prenosil@finteh.hr>
2002-07-25 23:44 ` kklein <kklein@ix.netcom.com>
2006-04-08 20:52 Re: dbf2pg, visual foxpro and other nonsense marian beier <marianbeier@gmail.com>
2006-04-08 21:25 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox