Re: [GNUe] Reports from DBF Files (2)

[Karl M. Joch]

Karl M. Joch wrote:

> Hello,
>
> Reinhard Mueller wrote:
>
>> Hello,
>>
>> it's very nice to see you here on this list, and I've always wanted to
>> thank you for creating the FreeBSD ports for GNUe!
>>
>
> Not a problem, I am really interested in GNUE so I was interested to 
see it working on FreeBSD.
>
>> Am Mit, den 25.08.2004 schrieb Karl M. Joch um 1:06:
>>
>>> Trying to create some reports on FreeBSD from Clipper/DBF Files.
>>
>>
>>
>>
>> The dbf dbdriver for gnue is based on an external python dbf library
>> which also has to be installed.
>>
>> Our project member Jan Ischebeck has has created this driver, and AFAIK
>> noone else of the gnue team has ever used it. Unfortunately, we haven't
>> heard from Jan lately, as he seems to be busy with real life.
>>
>> We have tried to find out what external python dbf library he has used,
>> and all we found out is that it's *not* http://www.fiby.at/dbfpy/ :-(
>>
>> Maybe Jan sees this mail and can help us. Or maybe somebody else has
>> managed to make dbf run.
>>
>> If you really think it would be wort the effort, we could also create a
>> new driver that is based on the fiby module mentioned above. For this,
>> it would be interesting how others see the need for a dBase compatible
>> dbdriver for GNUe.
>>
>> Thanks,
>
>
>
> I searched and found 3 things:
>
> http://schwinger.harvard.edu/~mspal/pystuff/dbf.txt
> http://mail.python.org/pipermail/python-list/2001-July/053128.html
> http://lists.maptools.org/pipermail/shapelib/2004-May/000076.html
>
> it looks ilke to me that the first one could be the neccecary module. 
I will try it soon, but finally this one has no support for index files. 
In the first step i would like to add some reports to an very old 
application we are running. without indexes dbf access makes no real 
sence. I still havnt found the time to start moving away from 
Clipper/Harbour. Application is very complex :-( .
>
>

imported dbf.py from schwinger.harvard.edu to /sur/local/lib/python.2.3

module itself works:

thon 2.3.4 (#2, Jun 19 2004, 00:27:41)
[GCC 3.3.3 [FreeBSD] 20031106] on freebsd5
Type "help", "copyright", "credits" or "license" for more information.

>>>>>> import dbf
>>>>>> db = dbf.dbf('/tmp/kunden.dbf')
>>>>>> db.open()
>>>>>> from string import strip
>>>>>> for k in db:


... print "%s, %s" % (strip(k[1]), strip(k[2]))
  File "<stdin>", line 2
    print "%s, %s" % (strip(k[1]), strip(k[2]))
        ^
IndentationError: expected an indented block

>>>>>> for k in db: print "%s, %s" % (strip(k[1]), strip(k[2]))


...
J, 0002001
N, 0004001
N, 0004002
N, 0004003
N, 0049999
N, 0050000
J, 0050001
N, 0010000
N, 0010001
N, 0010002

>>>>>>

But again error. I am not very familiar with Python and there is a todo
note in connections.py regarding DataObject and Static definition.

DB000: Traceback (most recent call last):
DB000:   File
"/usr/local/lib/python2.3/site-packages/gnue/designer/base/MenuBar.py",
line 143, in <lambda>
DB000:     lambda event, l=self.instance, e=action, x=eventdata:
l.dispatchEvent(e, **x))
DB000:   File
"/usr/local/lib/python2.3/site-packages/gnue/common/events/EventController.py",
line 111, in dispatchEvent
DB000:     handler(event)
DB000:   File
"/usr/local/lib/python2.3/site-packages/gnue/designer/base/Instance.py",
line 581, in __OnConnectTo
DB000:     tempDO = self.connections.getDataObject(conn, 'object')
DB000:   File
"/usr/local/lib/python2.3/site-packages/gnue/common/datasources/GConnections.py",
line 292, in getDataObject
DB000:     connection = self.getConnection(connection_name)
DB000:   File
"/usr/local/lib/python2.3/site-packages/gnue/common/datasources/GConnections.py",
line 245, in getConnection
DB000:     'Connection')
DB000:   File
"/usr/local/lib/python2.3/site-packages/gnue/common/apps/plugin.py",
line 168, in find
DB000:     raise LoadError, (name, result)
DB000: gnue.common.apps.plugin.LoadError: Cannot load plugin dbf
DB000: The following plugins failed:
DB000: * gnue.common.datasources.drivers.dbf.dbf: NameError: name
'DataObject' is not defined
DB000: