<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><font face="Tahoma" size="2"> Zoltan,</font><p><font face="Tahoma" size="2">Just doing some testing with your shapefile: I was going to test this join error after importing the original megye_utf-8.shp into a SpatiaLite database, however it won't recognize it when I specify UTF-8 on import via the spatialite-gui (load shp error:Invalid character sequence). This leads me to think there might be something going on with your shapefile. So, I created a new shapefile (specifying UTF-8 encoding) and loaded the polygons from the original, minus the 'Nev' field values. Then I manually added some of those values back in (Budapest, Vas, Zala, Fejér and Békés). I had previously created a new ods file with some of the spreadsheet values for the same areas (also UTF-8 encoded). With the new shapefile and the new ods loaded into QGIS Desktop, all of the records join correctly via the text join whether they have accents or not.</font><p><font face="Tahoma" size="2"></font> <p><font face="Tahoma" size="2">I would recommend trying to recreate your shapefile to be sure of the UTF-8 encoding and go from there.</font><p><font face="Tahoma" size="2"></font> <p><font face="Tahoma" size="2">Best Regards,</font><p><font face="Tahoma" size="2">James</font><p><BR><div>> Date: Wed, 29 Jan 2014 22:27:13 +0100<br>> From: siki@agt.bme.hu<br>> To: jwood911@gmail.com<br>> CC: qgis-user@lists.osgeo.org<br>> Subject: Re: [Qgis-user] joinning tables<br>> <br>> Dear James,<br>> <br>> thanks for your answer.<br>> I used Save as in QGIS to convert the shape attributes from ISO-8859-2 to <br>> UTF-8. If the code page of the joinded tables are different, QGIS uses the <br>> code page of the joint table.<br>> <br>> Regards,<br>> Zoltan<br>> <br>> On Wed, 29 Jan 2014, James Wood wrote:<br>> <br>> > Zoltan and Szilard,<br>> ><br>> ><br>> ><br>> > I have tested Zoltan's data with my installation of QGIS 2.0.1 on Windows 7<br>> > x64. I am seeing the same problem with the original data. When I re-create<br>> > some of the rows in a new Libre Office spreadsheet (Budapest, Vas, Zala),<br>> > the join works fine. When I add Békés that row fails in the join. Maybe<br>> > there is an issue with the UTF-8 encoding in the shapefile?<br>> > Best Regards,<br>> > James<br>> ><br>> ><br>> ><br>> ><br>> > On Wed, Jan 29, 2014 at 3:19 AM, Siki Zoltan <siki@agt.bme.hu> wrote:<br>> ><br>> >> Dear Szilard,<br>> >><br>> >> to tell you the truth all spreadsheet files were created by libre office,<br>> >> I was able to open all as a vector layer (without grapics).<br>> >> Which version and platform do you use?<br>> >> I didn't test it on 64 bit Windows.<br>> >><br>> >><br>> >> Regards,<br>> >> Zoltan<br>> >><br>> >> On Wed, 29 Jan 2014, Szabo Szilard wrote:<br>> >><br>> >> Dear Zoltan,<br>> >>><br>> >>> To tell the truth I do not know what is happening.<br>> >>> I am not able to read this file normally. CSV's first does not become a<br>> >>> field-header (I checked with my previous csv-s and they work); I created a<br>> >>> new CSV using MS Office 2010 but the results was the same.<br>> >>> XLSX also was wrong, values became NULL in the table (but had the right<br>> >>> header ...).<br>> >>><br>> >>> I will continue in the afternoon ...<br>> >>><br>> >>> Best wishes,<br>> >>><br>> >>> Szilard<br>> >>><br>> >>><br>> >>> 2014-01-29 Siki Zoltan <siki@agt.bme.hu><br>> >>><br>> >>> Dear Szilard,<br>> >>>><br>> >>>> thank your case study.<br>> >>>> DBF file limits column names to 10 char<br>> acters.<br>> >>>> First I thought special Hungarian characters cause the problem, but using<br>> >>>> only English ABC I got the same result.<br>> >>>> Did you try to join my tables?<br>> >>>> Did you get false result using textual columns?<br>> >>>><br>> >>>> Best Regards,<br>> >>>> Zoltan<br>> >>>><br>> >>>><br>> >>>> On Wed, 29 Jan 2014, Szabo Szilard wrote:<br>> >>>><br>> >>>> Dear Zoltan,<br>> >>>><br>> >>>>> I had this kind of problem when I "hurt" the normal rules of field names<br>> >>>>> (i.e. using extra long field names bringing them directly from<br>> >>>>> downloaded<br>> >>>>> TEIR tables); afterI correction them (shortening but I am not sure the<br>> >>>>> threshold), everything was fine. But You have correct and short field<br>> >>>>> names<br>> >>>>> ... my response is just a case study.<br>> >>>>><br>> >>>>> Best regards,<br>> >>>>> Szilard<br>> >>>>><br>> >>>>><br>> >>>>> 2014-01-29 Siki Zoltan <siki@agt.bme.hu><br>> >>>>><br>> >>>>> Dear James,<br>> >>>>><br>> >>>>>><br>> >>>>>> thanks for your answer.<br>> >>>>>> My data are available here:<br>> >>>>>> http://www.agt.bme.hu/gis/qgis/ods.zip<br>> >>>>>><br>> >>>>>> You can find in the zip a shapefile (megye_utf-8), and some<br>> >>>>>> spreadsheet<br>> >>>>>> files (ksh.ods, ksh.xlsx, ksh.csv) having the same data. All use utf-8<br>> >>>>>> code<br>> >>>>>> page.<br>> >>>>>> Open megye_utf-8 and ksh.ods and make a join using "megye" and "Nev"<br>> >>>>>> columns. I get NULL data in all joined column.<br>> >>>>>> If ods or xlsx is not supported on your platfo<br>> rm, you can use ksh.csv.<br>> >>>>>> If you join the two tables using "kod" (integer value) column, the<br>> >>>>>> result<br>> >>>>>> is OK.<br>> >>>>>> I tested it in 2.1, 1,7 and 1.8 on Linux and in 2.1 on Windows.<br>> >>>>>><br>> >>>>>> Best Regards,<br>> >>>>>> Zoltan<br>> >>>>>><br>> >>>>>> On Wed, 29 Jan 2014, James Wood wrote:<br>> >>>>>><br>> >>>>>> Zoltan,I don't know if someone has responded to you about this; I<br>> >>>>>> didn't<br>> >>>>>><br>> >>>>>> see any list posts. I am not seeing the same issue with textual joins<br>> >>>>>>> in my<br>> >>>>>>> QGIS 2.0.1 install. If you want to provide me with your shapefile and<br>> >>>>>>> your<br>> >>>>>>> join files, I'll be happy to test here.<br>> >>>>>>> Best Regards,James<br>> >>>>>>><br>> >>>>>>> Date: Sat, 25 Jan 2014 20:43:59 +0100<br>> >>>>>>><br>> >>>>>>> From: siki@agt.bme.hu<br>> >>>>>>>> To: qgis-user@lists.osgeo.org<br>> >>>>>>>> CC: qgis-developer@lists.osgeo.org<br>> >>>>>>>> Subject: [Qgis-user] joinning tables<br>> >>>>>>>><br>> >>>>>>>><br>> >>>>>>>> Dear List,<br>> >>>>>>>><br>> >>>>>>>> I got into trouble joining tables in QGIS.<br>> >>>>>>>> When I try to join shape to a csv, ods or xlsx file using columns<br>> >>>>>>>> with<br>> >>>>>>>> textual data, it doesn't work. I get only NULL values in the joint<br>> >>>>>>>> columns.<br>> >>>>>>>> Using integer values the join works.<br>> >>>>>>>> Is it a feature or an error?<br>> >>>>>>>><br>> >>>>>>>> Regards,<br>> >>>>>>>> Zoltan<br>> >>>>>>>> _______________________________________________<br>> >>>>>>><br>> > Qgis-user mailing list<br>> >>>>>>>> Qgis-user@lists.osgeo.org<br>> >>>>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user<br>> >>>>>>>><br>> >>>>>>>><br>> >>>>>>>> _______________________________________________<br>> >>>>>>><br>> >>>>>>> Qgis-user mailing list<br>> >>>>>> Qgis-user@lists.osgeo.org<br>> >>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user<br>> >>>>>><br>> >>>>>><br>> >>>>>><br>> >>>>><br>> >>>>> --<br>> >>>>> Dr. Szilard SZABO<br>> >>>>> associate professor, head of department<br>> >>>>> Department of Physical Geography and Geoinformation Systems<br>> >>>>> University of Debrecen<br>> >>>>> http://www.mendeley.com/profiles/szilard-szabo/<br>> >>>>> Publications <https://vm.mtmt.hu/search/slist.php?lang=0&AuthorID=<br>> >>>>> 10000172><br>> >>>>><br>> >>>>><br>> >>>>><br>> >>><br>> >>> --<br>> >>> Dr. Szilard SZABO<br>> >>> associate professor, head of department<br>> >>> Department of Physical Geography and Geoinformation Systems<br>> >>> University of Debrecen<br>> >>> http://www.mendeley.com/profiles/szilard-szabo/<br>> >>> Publications <https://vm.mtmt.hu/search/slist.php?lang=0&AuthorID=<br>> >>> 10000172><br>> >>><br>> >>> _______________________________________________<br>> >> Qgis-user mailing list<br>> >> Qgis-user@lists.osgeo.org<br>> >> http://lists.osgeo.org/mailman/listinfo/qgis-user<br>> >><br>> ><br></div> </div></body>
</html>