Antw: Re: [Qgis-user] Questions on CSV plugin & UTF8, or dbf to spatial.

Asmus Harder Harder at lehmann-partner.de
Tue Oct 25 07:48:00 PDT 2011


If you work from an MS-Access database, you can use the eVis-plugin to
draw the table as points. 
 
Have a look at
http://biodiversityinformatics.amnh.org/open_source/evis/documentation.php#d0e715

I don't know if this solve your problem with characters ...
But so you don't have to export your data to another file.
 
Regards,
Asmus Harder

2011/10/25 Koos Hagg <hagg.koos at gmail.com>:
> Hi Everyone,
>
> Is there a way to force the Delimited text plugin to read/process
UTF8
> encoded .csv's?
>
> I am working with Vietnamese characters, which display fine encoded
UTF8.
> Working from an access database, I export my queries/tables/whatever
and
> save them as a csv, in UTF8 with OpenOffice. That works fine. If I
then open
> my csv with notepad++ or similar, the characters are preserved-
great! But
> when I bring the file in with the Delimited text plugin, the
characters are
> messed up. Why is this? how can I fix it?
>
> Alternatively:
> I can save the tables I want as dbf, which actually load nicely into
QGIS as
> a table, no problems with characters. My tables have Lat & Long
columns.
>
> How can I tell QGIS to draw points/create a spatial layer based on
those 2
> columns? Is there a plugin for that that I have missed?
>
> Right now my work-around is to load both a csv and a dbf, and then
join the
> dbf to the csv points layer, and save as shapefile, deleting the
fields that
> are no good. It works but it is a little cumbersome.
>
> Thanks!
> Koos Hagg
>
> Oh, using QGIS 1.8+ on Windows 7 (64 bit)

LEHMANN +  PARTNER
DIE STRASSENGUTACHTER
LEHMANN + PARTNER GmbH, Schwerborner Straße 1, D-99086 Erfurt
Telefon: +49 (0) 361 51804 300   Fax: +49 (0) 361 51804 399
E-Mail: info at lehmann-partner.de   Internet:
http://www.die-strassengutachter.de
Geschäftsführer: Dr. Dirk Ebersbach, Jens Morawietz
Amtsgericht: Jena HRB 100220  USt-IdNr.: DE 160 115 425
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111025/2683ba62/attachment.html>


More information about the Qgis-user mailing list