<div dir="ltr"><font color="#000000" face="Times New Roman" size="3">
</font><p style="background:white;margin:0in 0in 0pt;line-height:normal"></p><span style="color:rgb(34,34,34);font-family:"Arial","sans-serif";font-size:7pt"><p style="background:white;margin:0in 0in 0pt;line-height:normal">
<font color="#000000" face="Times New Roman" size="3">
</font></p><p style="background:white;margin:0in 0in 0pt;line-height:normal"><span style="color:rgb(34,34,34);font-family:"Arial","sans-serif";font-size:10pt">Zoltan and Szilard,</span></p><p style="background:white;margin:0in 0in 0pt;line-height:normal">
<font color="#000000" face="Times New Roman" size="3">
</font></p><p style="background:white;margin:0in 0in 0pt;line-height:normal"><span style="color:rgb(34,34,34);font-family:"Arial","sans-serif";font-size:10pt"> </span></p><p style="background:white;margin:0in 0in 0pt;line-height:normal">
<font color="#000000" face="Times New Roman" size="3">
</font></p><div style="background:white;margin:0in 0in 6.75pt;line-height:normal"><span style="color:rgb(34,34,34);font-family:"Arial","sans-serif";font-size:10pt">I
have tested Zoltan's data with my installation of QGIS 2.0.1 on Windows 7 x64.
I am seeing the same problem with the original data. When I re-create some of
the rows in a new Libre Office spreadsheet (Budapest, Vas, Zala), the join
works fine. When I add Békés that row fails in the join. Maybe there is an issue with the UTF-8 encoding in the shapefile?</span></div><div style="background:white;margin:0in 0in 6.75pt;line-height:normal"><span style="color:rgb(34,34,34);font-family:"Arial","sans-serif";font-size:10pt">Best Regards,</span></div>
<div style="background:white;margin:0in 0in 6.75pt;line-height:normal"><span style="color:rgb(34,34,34);font-family:"Arial","sans-serif";font-size:10pt">James</span></div><p style="background:white;margin:0in 0in 0pt;line-height:normal">
<font color="#000000" face="Times New Roman" size="3">
</font><br></p></span><p style="background:white;margin:0in 0in 0pt;line-height:normal"></p><font color="#000000" face="Times New Roman" size="3">
</font></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jan 29, 2014 at 3:19 AM, Siki Zoltan <span dir="ltr"><<a href="mailto:siki@agt.bme.hu" target="_blank">siki@agt.bme.hu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Dear Szilard,<br>
<br>
to tell you the truth all spreadsheet files were created by libre office, I was able to open all as a vector layer (without grapics).<br>
Which version and platform do you use?<br>
I didn't test it on 64 bit Windows.<div class="HOEnZb"><div class="h5"><br>
<br>
Regards,<br>
Zoltan<br>
<br>
On Wed, 29 Jan 2014, Szabo Szilard wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
Dear Zoltan,<br>
<br>
To tell the truth I do not know what is happening.<br>
I am not able to read this file normally. CSV's first does not become a<br>
field-header (I checked with my previous csv-s and they work); I created a<br>
new CSV using MS Office 2010 but the results was the same.<br>
XLSX also was wrong, values became NULL in the table (but had the right<br>
header ...).<br>
<br>
I will continue in the afternoon ...<br>
<br>
Best wishes,<br>
<br>
Szilard<br>
<br>
<br>
2014-01-29 Siki Zoltan <<a href="mailto:siki@agt.bme.hu" target="_blank">siki@agt.bme.hu</a>><br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
Dear Szilard,<br>
<br>
thank your case study.<br>
DBF file limits column names to 10 characters.<br>
First I thought special Hungarian characters cause the problem, but using<br>
only English ABC I got the same result.<br>
Did you try to join my tables?<br>
Did you get false result using textual columns?<br>
<br>
Best Regards,<br>
Zoltan<br>
<br>
<br>
On Wed, 29 Jan 2014, Szabo Szilard wrote:<br>
<br>
Dear Zoltan,<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
I had this kind of problem when I "hurt" the normal rules of field names<br>
(i.e. using extra long field names bringing them directly from downloaded<br>
TEIR tables); afterI correction them (shortening but I am not sure the<br>
threshold), everything was fine. But You have correct and short field<br>
names<br>
... my response is just a case study.<br>
<br>
Best regards,<br>
Szilard<br>
<br>
<br>
2014-01-29 Siki Zoltan <<a href="mailto:siki@agt.bme.hu" target="_blank">siki@agt.bme.hu</a>><br>
<br>
Dear James,<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
<br>
thanks for your answer.<br>
My data are available here:<br>
<a href="http://www.agt.bme.hu/gis/qgis/ods.zip" target="_blank">http://www.agt.bme.hu/gis/<u></u>qgis/ods.zip</a><br>
<br>
You can find in the zip a shapefile (megye_utf-8), and some spreadsheet<br>
files (ksh.ods, ksh.xlsx, ksh.csv) having the same data. All use utf-8<br>
code<br>
page.<br>
Open megye_utf-8 and ksh.ods and make a join using "megye" and "Nev"<br>
columns. I get NULL data in all joined column.<br>
If ods or xlsx is not supported on your platform, you can use ksh.csv.<br>
If you join the two tables using "kod" (integer value) column, the result<br>
is OK.<br>
I tested it in 2.1, 1,7 and 1.8 on Linux and in 2.1 on Windows.<br>
<br>
Best Regards,<br>
Zoltan<br>
<br>
On Wed, 29 Jan 2014, James Wood wrote:<br>
<br>
Zoltan,I don't know if someone has responded to you about this; I didn't<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
see any list posts. I am not seeing the same issue with textual joins<br>
in my<br>
QGIS 2.0.1 install. If you want to provide me with your shapefile and<br>
your<br>
join files, I'll be happy to test here.<br>
Best Regards,James<br>
<br>
Date: Sat, 25 Jan 2014 20:43:59 +0100<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
From: <a href="mailto:siki@agt.bme.hu" target="_blank">siki@agt.bme.hu</a><br>
To: <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
CC: <a href="mailto:qgis-developer@lists.osgeo.org" target="_blank">qgis-developer@lists.osgeo.org</a><br>
Subject: [Qgis-user] joinning tables<br>
<br>
<br>
Dear List,<br>
<br>
I got into trouble joining tables in QGIS.<br>
When I try to join shape to a csv, ods or xlsx file using columns with<br>
textual data, it doesn't work. I get only NULL values in the joint<br>
columns.<br>
Using integer values the join works.<br>
Is it a feature or an error?<br>
<br>
Regards,<br>
Zoltan<br>
______________________________<u></u>_________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/qgis-user</a><br>
<br>
<br>
</blockquote>
______________________________<u></u>_________________<br>
<br>
</blockquote>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/qgis-user</a><br>
<br>
<br>
</blockquote>
<br>
<br>
--<br>
Dr. Szilard SZABO<br>
associate professor, head of department<br>
Department of Physical Geography and Geoinformation Systems<br>
University of Debrecen<br>
<a href="http://www.mendeley.com/profiles/szilard-szabo/" target="_blank">http://www.mendeley.com/<u></u>profiles/szilard-szabo/</a><br>
Publications <<a href="https://vm.mtmt.hu/search/slist.php?lang=0&AuthorID=" target="_blank">https://vm.mtmt.hu/search/<u></u>slist.php?lang=0&AuthorID=</a><br>
10000172><br>
<br>
<br>
</blockquote></blockquote>
<br>
<br>
-- <br>
Dr. Szilard SZABO<br>
associate professor, head of department<br>
Department of Physical Geography and Geoinformation Systems<br>
University of Debrecen<br>
<a href="http://www.mendeley.com/profiles/szilard-szabo/" target="_blank">http://www.mendeley.com/<u></u>profiles/szilard-szabo/</a><br>
Publications <<a href="https://vm.mtmt.hu/search/slist.php?lang=0&AuthorID=10000172" target="_blank">https://vm.mtmt.hu/search/<u></u>slist.php?lang=0&AuthorID=<u></u>10000172</a>><br>
<br>
</blockquote>
______________________________<u></u>_________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/qgis-user</a><br>
</div></div></blockquote></div><br></div>