[Qgis-user] joinning tables

[James Wood]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140129/e8ac133c/attachment.html>