Problem importing dBase IV files

[Gabriele Gamba]

Hello Tom,

I'm trying to use DBConvert to convert a bunch of .DBF + .MDX files but
I have no luck.  Using "file" I get:

$ file FORME.DBF
FORME.DBF: dBase IV DBF, 274 records * 36, update-date 105-2-16, with
index file .MDX

but when I try to open FORME.DBF in DBConvert, it complains with "Cannot
read file beyond EOF (File is empty or corrupt)".

But "file" sees 274 rows in the .DBF and if I open it with a text editor
I see values. Any idea?   Can it be not a dBase IV file?

Thanks a lot for any suggestion!

Gabriele

[Tom van Breukelen]

Hello Gabriele,

You could try the PACK command to remove records from the .DBF table that were previously marked as deleted by the DELETE command.

Another option is to attach a copy of your .DBF file so that I can have a look at it

Best regards,
Tom

[Gabriele Gamba]

Thank you Tom, you are too kind! I attach here a .DBF as example. The .MDX is included, also if it is not necessary if I understand well.

[Tom van Breukelen]

Hi Gabriele,

I've found the problem. The DBF file was created with dBase Version 7. It uses a slightly different format than the older dBase versions that are supported by DBConvert. I will add dBase 7 support on my TODO list for early next year.

Best regards,

Tom

[Gabriele Gamba]

Hi Tom, thanks a lot! I'll wait for the next version, thank you again and all the best.

Gabriele

[Tom van Breukelen]

Hi Gabriele,
I've just uploaded version 6.9 of DBConvert which supports dBase version 7.

Best regards, Tom

P.S.: Merry Christmas and a Happy New Year

[Gabriele Gamba]

Hi Tom,

thank you, I'm downloading it just now.

Happy New Year to you too, as I'm too late for Christmas greetings!

[Gabriele Gamba]

Thanks a lot Tom, new version worked fine!