Opened 14 years ago

Closed 14 years ago

Last modified 14 years ago

#3067 closed enhancement (wontfix)

Support DBF table as datasource

Reported by: jhelebrant Owned by: nobody
Priority: minor: annoyance Milestone: Version 1.6.0
Component: Data Provider Version: 1.5.0
Keywords: DBF table, shapes, vector, data source Cc: neteler
Must Fix for Release: No Platform: All
Platform Version: Awaiting user input: no

Description

Hi, I am sorry, but this is essential thing for me. Almost all GIS sw support DBF files to be loaded and then converted to shapes. We have a plenty of DBF and use them in various sw from OSS like SAGA to commercial ones. For QGIS, I always have to convert it to CSV and modify, as OOo adds " to the file as text field separator and also uses "," instead of "." (in Czech environment). With DBF I never had a problem so it would be very useful if QGIS could also load DBF tables without any conversion.

regards

Jan

Change History (6)

comment:1 by lutra, 14 years ago

In OO you can easily change the separator symbol and don't use the '"' to wrap values.

When saving to CSV just check the "edit filter setting" checkbox.

Said this I don't see any reason to support this format to import x/y tables: just export DBFs files as csv.

If you have bunch of them you can do convert them with a batch job: there are a ton of applications that can do this under windows. Under linux you probably would like to do the job with a few lines script. Example:

http://avi.alkalay.net/2010/08/convert-dbf-to-csv-on-linux-with-perl-and-xbase.html

comment:2 by lutra, 14 years ago

Resolution: wontfix
Status: newclosed

Also DBF has been dropped from Ms Office already in MS Office 2007. Reopen if necessary.

comment:3 by jef, 14 years ago

DBFs can be added as geometryless layers.

comment:4 by neteler, 14 years ago

Cc: neteler added

I hope that the unfortunate decision of Microsoft to drop DBF from MS Office 2007 is not dictating what QGIS offers - OpenOffice for example has DBF support and also SHAPE files have DBF as table format.

Markus

in reply to:  4 ; comment:5 by jef, 14 years ago

Replying to neteler:

I hope that the unfortunate decision of Microsoft to drop DBF from MS Office 2007 is not dictating what QGIS offers

I think most of us, don't care what M$ does.

OpenOffice for example has DBF support and also SHAPE files have DBF as table format.

You know that the above OO(o) refers to OpenOffice. And as said we support DBF. It's just that the delimited text provider doesn't.

in reply to:  5 comment:6 by lutra, 14 years ago

Replying to jef:

It's just that the delimited text provider doesn't.

yes, this is what I meant. Does not make sense add dbf support in the "add delimited text" plugin (and just there), as every office package can handle CSVs, having as sources DBFs or any other type of spreadheet table.

Note: See TracTickets for help on using tickets.