#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 , 14 years ago
comment:2 by , 14 years ago
Resolution: | → wontfix |
---|---|
Status: | new → closed |
Also DBF has been dropped from Ms Office already in MS Office 2007. Reopen if necessary.
follow-up: 5 comment:4 by , 14 years ago
Cc: | 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
follow-up: 6 comment:5 by , 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.
comment:6 by , 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.
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