wise-coders / dbf-jdbc-driver

DBF & FoxPro JDBC Driver | DbSchema DBF Designer
https://dbschema.com/databases/dbf-management-gui.html
Other
23 stars 15 forks source link

Are memo fields supported? #9

Closed jeremyross closed 1 year ago

jeremyross commented 1 year ago

When I connect to a dbf+fpt file, I see that large varchar columns are created for the memo field, but the data doesn't seem to be imported. All records have null for memo fields.

wise-coders commented 1 year ago

Memofields are supported. There could be an issue with certain versions of the DBF file. Could you please send us a sample DBF file ( something simple, to test ).

jeremyross commented 1 year ago

Unfortunately the data is all confidential, so I can't share.

The data file is a .DBF file, and the memo file has the same name as the data file, but with the extension .FPT. Is this what is expected?

jeremyross commented 1 year ago

Just tried renaming the .FPT file to .DBT, then nuked and reinitialized everything, but same result.

jeremyross commented 1 year ago

Info from file system:

> file mbrleav.DBT 
mbrleav.DBT: FoxPro FPT, blocks size 64, next free block index 3653, field type 1, field length 99
jeremyross commented 1 year ago

FPT files are a little different than DBT. Do you know if FPT files are supported?

wise-coders commented 1 year ago

We use this library to read the DBF files:

com.github.albfernandez:javadbf:1.14.0

Probably you already saw it.

Best regards, Dragos Pruteanu

On Thursday, July 27, 2023 at 6:30:57 PM, DaveDevelop wrote:

FPT files are a little different than DBT. Do you know if FPT files are supported? — Reply to this email directly, [1] view it on GitHub, or [2] unsubscribe. You are receiving this because you commented.Message ID:

[1] https://github.com/wise-coders/dbf-jdbc-driver/issues/9#issuecomment-1653960055 [2] https://github.com/notifications/unsubscribe-auth/AOL52YZ22QWWUUVSK42GFEDXSKJR7ANCNFSM6AAAAAA2ZBJ7EA