dbf-File import and sorting

, ,
1

Hallo everyone :blush:,
I want to import a dbf-file in Dynamo with the aim to creat attributes and fill them with values from the dbf-file. The dbf is an export file from the german software SIB-Bauwerke. Is it mainly used the manage the construction and maintainance of infrastructure buildings like bridges.

The dbf-file is in my opinion a whole desaster. I have no idea how to manage it properly. There are alot of unreadable symbols and the attributes and values are not sorted it the right way. Especially, because there are more attributes than values, due to the fact that not every attribute in SIB-Bauwerke is filled with information. The file (opend with a text editor) is shown in the image:

image

Now here are my questions:

(1) Which function or node would you recommend for reading dbf files like this?
(2) How can I delete “unreadable” values?
(3) How would you manage missing values?

I’m relatively new to dynamo. Would be nice if you explain the things in an easy way. :smiling_face:

2

image
image1268×368 22.3 KB

I recognized the image is not properly readable, so here an second image :smiling_face:

3

Hello @ulbrich.lisa, welcome to the forum.
I think you can open the DBF file in Excel.
that would make your task a bit easier.

4

Hello Marcel,
if I open it in Excel, it looks like this:

image
image1897×219 11.4 KB

I don’t know how to handle the symbols, which can not be read. :frowning:

5

Can you post the dbf file if permitted?
(if its too big, send it to yourself with WeTransfer and post the link in the email you recieve here.)