[Qgis-user] joinning tables

[Siki Zoltan]

Dear James,

thanks for your answer.
I used Save as in QGIS to convert the shape attributes from ISO-8859-2 to 
UTF-8. If the code page of the joinded tables are different, QGIS uses the 
code page of the joint table.

Regards,
Zoltan

On Wed, 29 Jan 2014, James Wood wrote:

> Zoltan and Szilard,
>
>
>
> 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?
> Best Regards,
> James
>
>
>
>
> On Wed, Jan 29, 2014 at 3:19 AM, Siki Zoltan <siki at agt.bme.hu> wrote:
>
>> 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>
>>>
>>>  _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>