[Qgis-user] joinning tables

[Siki Zoltan]

Dear Szilard,

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).
Which version and platform do you use?
I didn't test it on 64 bit Windows.

Regards,
Zoltan

On Wed, 29 Jan 2014, Szabo Szilard wrote:

> 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>
>