dBase III support

[koljenovic]

• Python version: 3.9.5
• Operating System: Linux *** 5.11.0-18-generic #19-Ubuntu SMP Fri May 7 14:22:03 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

Description

dBase III with/without memo (version byte 0x83/0x03) errors out at Dbf instantiation with:

ValueError: dbf fields definition is corrupt, fields start does not match.

What I Did

I will try dBase integration.

[frankyxhl]

Hi,

Can you share you example DBF file?

[koljenovic]

Sample file attached.

dbase_error_210623.tar.gz

[koljenovic]

Please note fields.parse declaration:

dbfpy3/dbfpy3/fields.py

Line 66 in 41e519a

def parse(cls, string, ignore_errors=False):

and invocation from the header constructor:

dbfpy3/dbfpy3/header.py

Line 156 in 41e519a

field = DbfFields.parse(data, pos)

There is a parameter/argument mismatch here, also pos should have nothing to do with header offseting, so I believe it to be used incorrectly in this case. After fixing the parse invocation to exclude pos and deleting:

dbfpy3/dbfpy3/header.py

Lines 157 to 161 in 41e519a

	if pos != field.start:
	raise ValueError(
	'dbf fields definition is corrupt, '
	'fields start does not match.'
	)

headers get to parse just fine, but using a file that contains data records another error gets raised when record.py starts parsing the data:

ValueError: ('Record deleted flag error ({})', 0)

I'll try to dig further, I suspect it might have something to do with offsetting as well.

[frankyxhl]

dBase III file format might be a little different:

https://www.clicketyclick.dk/databases/xbase/format/dbf.html#DBF_NOTE_6_SOURCE

[lyx0723]

  您的邮件我已收到，祝您生活愉快！