[Qgis-user] joinning tables

[Szabo Szilard]

Dear Zoltan,
I had this kind of problem when I "hurt" the normal rules of field names
(i.e. using extra long field names bringing them directly from downloaded
TEIR tables); afterI correction them (shortening but I am not sure the
threshold), everything was fine. But You have correct and short field names
... my response is just a case study.

Best regards,
Szilard


2014-01-29 Siki Zoltan <siki at agt.bme.hu>

> Dear James,
>
> thanks for your answer.
> My data are available here:
> http://www.agt.bme.hu/gis/qgis/ods.zip
>
> You can find in the zip  a shapefile (megye_utf-8), and some spreadsheet
> files (ksh.ods, ksh.xlsx, ksh.csv) having the same data. All use utf-8 code
> page.
> Open megye_utf-8 and ksh.ods and make a join using "megye" and "Nev"
> columns. I get NULL data in all joined column.
> If ods or xlsx is not supported on your platform, you can use ksh.csv.
> If you join the two tables using "kod" (integer value) column, the result
> is OK.
> I tested it in 2.1, 1,7 and 1.8 on Linux and in 2.1 on Windows.
>
> Best Regards,
> Zoltan
>
> On Wed, 29 Jan 2014, James Wood wrote:
>
>  Zoltan,I don't know if someone has responded to you about this; I didn't
>> see any list posts. I am not seeing the same issue with textual joins in my
>> QGIS 2.0.1 install. If you want to provide me with your shapefile and your
>> join files, I'll be happy to test here.
>> Best Regards,James
>>
>>  Date: Sat, 25 Jan 2014 20:43:59 +0100
>>> From: siki at agt.bme.hu
>>> To: qgis-user at lists.osgeo.org
>>> CC: qgis-developer at lists.osgeo.org
>>> Subject: [Qgis-user] joinning tables
>>>
>>>
>>> Dear List,
>>>
>>> I got into trouble joining tables in QGIS.
>>> When I try to join shape to a csv, ods or xlsx file using columns with
>>> textual data, it doesn't work. I get only NULL values in the joint
>>> columns.
>>> Using integer values the join works.
>>> Is it a feature or an error?
>>>
>>> Regards,
>>> Zoltan
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>
>>  _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
Dr. Szilard SZABO
associate professor, head of department
Department of Physical Geography and Geoinformation Systems
University of Debrecen
http://www.mendeley.com/profiles/szilard-szabo/
Publications <https://vm.mtmt.hu/search/slist.php?lang=0&AuthorID=10000172>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140129/59b02831/attachment.html>