Re: dbf2pg improvements (password, charset convertions,etc.) - Mailing list pgsql-patches

    Hello.

> -------- Original Message --------
> Subject: Re: [PATCHES] [Fwd: dbf2pg improvements (password, charset
> convertions,etc.)]
> Date: Thu, 3 May 2001 15:17:01 -0400 (EDT)
> From: Bruce Momjian <pgman@candle.pha.pa.us>
> To: ivan@pilasnet.com
> CC: pgsql-patches@postgresql.org
>
> Well, if you contacted the author and didn't get a reply, you can send
> them over here and we can include them in 7.2.
    I tried to contact the author but in one case the server didn't exist,
then tried another address and it said that there was a problem with
relaying, etc..
    So, it is not that the author didn't reply, it is just that it didn't
received the email... I hope it agrees with my changes.
    Well, I have sent a tarball and a patch last time, but it seems that
you didn't notice.
    Now I am attaching a tarball with a little fix regarding dates.
    You can upload that tarball as it is or maybe removing the "_ivan"
filename part, that depends if you want to have a version alongside the
original version or replacing the 3.0 version with this new version.
    Thanks very much and I hope this new version proves usefull to others,
now lets go and convert that old .DBF based databases to PostgreSQL!


> >       Hello.
> >       Well, I cannot contact the original author so I send this here as my
> > last resort.
> >       This is regarding a program you distribute in the "contrib" directory
> > of your FTP server, the program is called "dbf2pg".
> >       I have made some usefull changes that I want to share, see the rest of
> > the email for more information.
> >       Please, tell me if I have to do anything else to update that program,
> > especially if this is not the correct place to send this email (and if
> > so, sorry!, I am trying to help), any other comments are appreciated.
> >       Take in account that I am not subscribed to this mailing list, so
> > please send me a copy of the emails!
> >       Thanks and goodbye.
> >
> > -------- Original Message --------
> > De: Ivan Baldo <ivan@servidor.pilasnet.com.uy>
> > Asunto: [Fwd: dbf2pg improvements (password, charset convertions, etc.)]
> > Para: boekhold@tibco.com
> >
> >       Hello.
> >       I sent you an email to your old account and it bounced, I hope this is
> > your new email address.
> > P.s.: dbf2pg should have your new email address and possibly a list of
> > changes, also the manpage points to an old version (2.0).
> > P.s.2: if you accept the changes, PostgreSQL people should get the new
> > version, and btw., where is the official location for this program?
> >
> > -------- Original Message --------
> > De: Ivan Baldo <ivan@servidor.pilasnet.com.uy>
> > Asunto: dbf2pg improvements (password, charset convertions, etc.)
> > Para: boekhold@cindy.et.tudelft.nl
> >
> >       Hello.
> >       First of all, thanks for dbf2pg!!!
> >       We will start to use it here soon.
> >       I taken it from the Postgres site, in a "contrib" directory somewhere,
> > it had version 3.0.
> >       I am sending you a traball of my version of the full source and a patch
> > with the differences.
> >       You can see that there is in it an "ivan.txt" file, you can delete this
> > file, it is just for your (and my own) information.
> >       For your convenience, here is a bit of that file:
> >
> > SUMMARY OF CHANGES:
> > - dbf2pg.c::isinteger()
> >         - tried to optimize it.
> > - dbf2pg.c::usage()
> >         - cosmetic changes, some options added.
> > - dbf2pg.c::main()
> >         - support for '-W' flag for asking user password.
> >         - support for '-U username' flag to specify user name.
> > - dbf2pg.c::do_inserts()
> >         - if the user didn't specify a transaction block size, then set
> > it to be
> >           all the records.
> > - dbf2pg.c
> >         - fixed handling of date, also, there's no need for '-a' option
> > anymore.
> >         - support for charset conversion through options '-F
> > charset_from' and
> >           '-T charset_to', using standard Unix "iconv" support.
> > - dbf2pg.1
> >         - removed references to msql.
> >         - updated a bit (should be checked since I am not a manpage
> > expert).
> >
> > MISC NOTES:
> > - behaviour regarding errors, warnings and informations should be
> > normalized,
> >   I suggest stderr for errors and stdout for anything else.
> >
> > -- END OF ivan.txt --
> >
> >       If you are not the correct person to contact, please, tell me who can I
> > contact or what can I do then, since this changes could be usefull for
> > the world and it is good to share them.
> >
> >       Well, I will wait for your reply, goodbye!
> > P.s.: I have tested this on SuSE Linux 7.0 only, should be tested on
> > more platforms!
>
> [ application/x-gzip is not supported, skipping... ]
>
> [ application/x-gzip is not supported, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: 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
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
> 19026