[Qgis-user] joinning tables

[Szabo Szilard]

Dear Zoltan,

To tell the truth I do not know what is happening.
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.
XLSX also was wrong, values became NULL in the table (but had the right
header ...).

I will continue in the afternoon ...

Best wishes,

Szilard


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

> Dear Szilard,
>
> thank your case study.
> DBF file limits column names to 10 characters.
> First I thought special Hungarian characters cause the problem, but using
> only English ABC I got the same result.
> Did you try to join my tables?
> Did you get false result using textual columns?
>
> Best Regards,
> Zoltan
>
>
> On Wed, 29 Jan 2014, Szabo Szilard wrote:
>
>  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>
>>
>>


-- 
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/c1baa7f1/attachment.html>