Recent changes to bugs

#17 Add support for the extended fields

2015-08-09T08:52:43.225000Z

I cannot, sorry. It was the file of my client.

#17 Add support for the extended fields

2015-08-09T04:01:39.240000Z

Please, can you provide an example data file?

#10 Method isDeleted on linux

2015-08-09T03:43:15.235000Z

status: open --> closed-invalid
Group: --> -

#19 Error when trying to access dbf file entries

2015-08-09T03:39:31.101000Z

status: pending --> closed

#17 Add support for the extended fields

2015-07-08T11:40:47.249000Z

As I remember it helped me to work with this by adding 2 classes as workaround. File 'fields.py':

class DbfVarCharacterFieldDef(DbfFieldDef):
    """Definition of the character field."""

    typeCode = "V"
    defaultValue = ""

    def decodeValue(self, value):
        """Return string object.

        Return value is a ``value`` argument with stripped right spaces.

        """
        return value  # .rstrip(" ")

    def encodeValue(self, value):
        """Return raw data string encoded from a ``value``."""
        return str(value)[:self.length].ljust(self.length)

class DbfCharacterNameFieldDef(DbfFieldDef):
    """Definition of the character field."""

    typeCode = "0"
    defaultValue = ""

    def decodeValue(self, value):
        """Return string object.

        Return value is a ``value`` argument with stripped right spaces.

        """
        return value.rstrip(" ")

    def encodeValue(self, value):
        """Return raw data string encoded from a ``value``."""
        return str(value)[:self.length].ljust(self.length)

#17 Add support for the extended fields

2015-07-08T07:17:20.072000Z

Am I right in thinking this is the cause of the error...

Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "c:\python27\lib\site-packages\dbfpy\dbf.py", line 138, in init
self.header = self.HeaderClass.fromStream(self.stream)
File "c:\python27\lib\site-packages\dbfpy\header.py", line 128, in fromStream
_fld = fields.lookupFor(_data[11]).fromString(_data, _pos)
File "c:\python27\lib\site-packages\dbfpy\fields.py", line 473, in lookupFor
return _fieldsRegistry[typeCode]
KeyError: '0'

#19 Error when trying to access dbf file entries

2015-06-05T09:11:14.145000Z

Actually it was enough to just add ignoreError to the Dbf construction. Thank you!

Solution:
from dbfpy import dbf
db=dbf.Dbf("Belgium_Pipelines.dbf", ignoreErrors=True)

#19 Error when trying to access dbf file entries

2015-06-05T05:16:59.206000Z

Hi Alexander

Thank you for your answer. So what do I have to change to make it work? I don't understand why I get this error when calling the rows... I mean I am not writig anything in the fields yet at this part of de code. I just try to iterate over them

-------- Ursprüngliche Nachricht --------
Von: alexander smishlajev a1s@users.sf.net
Datum: 05.06.2015 05:29 (GMT+01:00)
An: "[dbfpy:bugs]" 19@bugs.dbfpy.p.re.sf.net
Betreff: [dbfpy:bugs] #19 Error when trying to access dbf file entries

That is DBF notion of Numeric Overflow. A value that was put in that field is bigger than field width would allow.

You may pass ignoreErrors=True to your Dbf() constructor, and then you should get Dbf.INVALID_VALUE instead of exception.

[bugs:#19]http://sourceforge.net/p/dbfpy/bugs/19 Error when trying to access dbf file entries

Status: open
Group: -
Created: Thu Jun 04, 2015 06:47 PM UTC by Thomas Frei
Last Updated: Thu Jun 04, 2015 06:47 PM UTC
Owner: nobody

I'm trying to use dbfpy to change the entries of an existing dbf file (see attachment). For this I'd like to read out the columns of the file, edit them and write them back into the file. Unfortunately, when I try to access the entries I always get an error: "ValueError: invalid literal for int() with base 10: '****' "

I'm doing the following:
from dbfpy import dbf db=dbf.Dbf("Belgium_Pipelines.dbf", readOnly=False, new=False)
Line_Name=db[1]
Flow_Direction=db[5]

Why isn't that working? I also tried to set up an iterator with: for rec in db, but I get the same error.

Thank you for your help

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/dbfpy/bugs/19/https://sourceforge.net/p/dbfpy/bugs/19

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/https://sourceforge.net/auth/subscriptions

#19 Error when trying to access dbf file entries

2015-06-05T03:29:54.626000Z

status: open --> pending

#19 Error when trying to access dbf file entries

2015-06-05T03:29:21.044000Z

That is DBF notion of Numeric Overflow. A value that was put in that field is bigger than field width would allow.

You may pass ignoreErrors=True to your Dbf() constructor, and then you should get Dbf.INVALID_VALUE instead of exception.