Your current code is caused to fail by the next inputs: - when the data has null number values.
You can probe it with the examples in: http://www.clicketyclick.dk/databases/xbase/index.shtml.en Now I have a new version of dbf2sql with some bug fixed: - Support MEMO fields. - Support Float Point fields. - Exclude deleted records. - Replace ' with \' in strings. - do all inserts in one transaction. And my script support all examples of above url. My program fixes that the current one does not. El lun, 28-03-2005 a las 00:06 -0500, Bruce Momjian escribió: > Manuel Baena Garca wrote: > > El mi?, 23-03-2005 a las 17:07 -0500, Bruce Momjian escribi?: > > > Are you saying your script has all the functionality of dbf2pg.c? It > > > doesn't seem possible. > > > > No, I'm not saying it. By example, my script doesn't connect to a pg db, > > I prefer to use a pipe. My script has the same objective by a different > > way: "do it as simple as you can". > > It might be simple to code, but having a second program is not simpler > for end-users. We have had no one else complain about xbase conversion > so I am not inclined to add a second program, especially since you did > not say what your program fixes that the current one does not. > > Can you show us exactly what input causes our current code to fail, and > explain why someone with C knowledge can't fix it? >
dbf2sql.pl
Description: Perl program
.TH dbf2sql.pl 7 "March 2005" "dbf2sql.pl 0.5" "PostgreSQL contrib" .SH NAME dbf2sql.pl \- Translate xBase files to SQL statements .SH SYNOPSIS .B dbf2sql.pl .I dbf-file table .SH DESCRIPTION Translate xBase-style .dbf-files to SQL statements (CREATE TABLE and INSERTs). .IP dbf2sql.pl /path/to/file.dbf table .PP .SH AUTHOR Written by Manuel Baena Garcia <[EMAIL PROTECTED]> .SH COPYRIGHT Copyright (c) 2005 Universidad de Malaga. .br This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])