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 <[email protected]> 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 <[email protected]>
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 <[email protected]>
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: [email protected]
To: [email protected]
CC: [email protected]
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
