Re: dbf2pg improvements (password, charset convertions,etc.)

Yep, I got it, and it is sitting in the "Outstanding Patches" page at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will add this one there too.

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

[ application/x-gzip is not supported, skipping... ]

-- 
  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

I will keep this and apply to 7.2 soon.

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

[ application/x-gzip is not supported, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
  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

I have added dbf2pg into the official PostgreSQL CVS tree under
/contrib/dbase. It will appear in 7.2.

I removed the ivan.txt file, created a new Makefile, and updated a few
things.

Thanks.

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

[ application/x-gzip is not supported, skipping... ]

-- 
  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