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
