<div dir="ltr">Dear Zoltan,<div><br></div><div>To tell the truth I do not know what is happening.</div><div>I am not able to read this file normally. CSV's first does not become a field-header (I checked with my previous csv-s and they work); I created a new CSV using MS Office 2010 but the results was the same. </div>
<div>XLSX also was wrong, values became NULL in the table (but had the right header ...).</div><div><br></div><div>I will continue in the afternoon ...</div><div><br></div><div>Best wishes,</div><div><br></div><div>Szilard</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-01-29 Siki Zoltan <span dir="ltr"><<a href="mailto:siki@agt.bme.hu" target="_blank">siki@agt.bme.hu</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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 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<div><div class="h5"><br>
<br>
On Wed, 29 Jan 2014, Szabo Szilard wrote:<br>
<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
Dear Zoltan,<br>
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 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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Dear James,<br>
<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 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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
see any list posts. I am not seeing the same issue with textual joins in my<br>
QGIS 2.0.1 install. If you want to provide me with your shapefile and 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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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>
</blockquote>
<br>
______________________________<u></u>_________________<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>
</blockquote>
<br>
<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></div></div>
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>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><font size="1">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/profiles/szilard-szabo/</a></font><span style="padding-right:16px;width:16px;height:16px"></span><br><a href="https://vm.mtmt.hu/search/slist.php?lang=0&AuthorID=10000172" target="_blank"><font size="1">Publications</font></a><br>
<br>
</div>