Feature request #3067
Support DBF table as datasource
Status: | Closed | ||
---|---|---|---|
Priority: | Low | ||
Assignee: | nobody - | ||
Category: | Data Provider | ||
Pull Request or Patch supplied: | Resolution: | wontfix | |
Easy fix?: | No | Copied to github as #: | 13127 |
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
History
#1 Updated by Giovanni Manghi about 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
#2 Updated by Giovanni Manghi almost 14 years ago
- Resolution set to wontfix
- Status changed from Open to Closed
Also DBF has been dropped from Ms Office already in MS Office 2007. Reopen if necessary.
#3 Updated by Jürgen Fischer almost 14 years ago
DBFs can be added as geometryless layers.
#4 Updated by Markus Neteler almost 14 years ago
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
#5 Updated by Jürgen Fischer almost 14 years ago
Replying to [comment:4 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 refers to OpenOffice. And as said we support DBF. It's just that the delimited text provider doesn't.
#6 Updated by Giovanni Manghi almost 14 years ago
Replying to [comment:5 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.