<div dir="ltr"><div>Hi,<br></div>I think this should be reported. If there is no reason why a csv should not have column fields name as numbers, then this is a bug, maybe a small bug, but it's a feature that QGIS needs to handle.<br><div class="gmail_extra"><br><div class="gmail_quote">2015-08-06 8:04 GMT+02:00 Zoltan Szecsei <span dir="ltr"><<a href="mailto:zoltans@geograph.co.za" target="_blank">zoltans@geograph.co.za</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hi,<br>
Fine - I did ask for an opinion, and I got one :-)<br>
<br></div></blockquote><div>Then I'll also give mine, for what it's worth.<br><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#FFFFFF" text="#000000">
The CSV files are from South Africa's 2011 Census - as put out by
StatsSA, and exported from SuperCROSS.<br>
In this particular file, the numeric field names are for the "Age
last birthday" of the occupant. (yep, from 0 to 120!!!)<br>
<br>
So in short, I guess there are many, many users of this data - and
for me an unnoticed error/deficiency, is still and error/deficiency.<br>
<br></div></blockquote><div> I do agree with u. I think this should be reported. If there is no reason why a csv should
not have column fields named as numbers (shapefiles does accept this kind of field name so joining csv like this might be allowed), then this is a bug (or feature request?), maybe a
small bug for some of us. We don't all have same skills, what appears easy to handle for someone can be a huge barrier for someone else. And as a community, we should make easy the path for every one.<br>I know there are priorities but reporting an issue doesn't mean that it should be fixed in the day. In QGIS Hub, you'll easily find reports that are there for years. IMO, it's a feature that QGIS needs to handle. Report it and if one day, someone finds enough time and skills to fix it, it'll be done.<br><br></div><div>Regards,<br></div><div>DelazJ<br> <br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#FFFFFF" text="#000000">
Whilst I am not too perturbed because I can get around this issue, I
figured it was my "civic" duty to raise it.<br>
<br>
Cheers for now,<br>
Zoltan<div><div class="h5"><br>
<br>
<br>
<div>On 2015/08/06 07:56, Neumann, Andreas
wrote:<br>
</div>
<blockquote type="cite">
<p>Hi,</p>
<p>In my opinion it is quite "special" to name columns with
integer numbers. Not what the average GIS user would do. In my
own 2-decade GIS career I never had such an issue.</p>
<p>I am not against fixing this issue, but I don't think it is a
serious issue. We have many more important issues in QGIS.</p>
<p>Andreas</p>
<p>On 2015-08-06 07:31, Zoltan Szecsei wrote:</p>
<blockquote type="cite" style="padding:0 0.4em;border-left:#1010ff 2px solid;margin:0">
<div style="margin:0;padding:0;font-family:monospace">Hi Chris,<br>
Thanks for the opinion.<br>
Do I log this as a bug?<br>
<br>
Whilst I am quite happy to write a bash script to parse and
alter my 500 CSV files, I do feel that this is likely a more
serious issue, as it will affect, I assume a lot of, users
that load CSV files to join them to their spatial data.<br>
Maybe the silence on this is because it either goes unnoticed,
or there are many people just doing a work-around.<br>
<br>
Let me know.<br>
<br>
Thanks & regards,<br>
Zoltan<br>
<br>
On 2015/08/05 02:55, Chris Crook wrote:
<blockquote type="cite" style="padding:0 0.4em;border-left:#1010ff 2px solid;margin:0">Hi Zoltan<br>
<br>
I think this could be classed as an error! The source code rejects field names that look like positive numbers (some digits optionally followed by a period and some more digits).<br>
<br>
I can't recall a reason why it should do this. It could be reasonable to require field names to be compatible to database attribute names, but I can't see any need for that within QGIS itself. This can go on a 'to-do' list to fix...<br>
<br>
Cheers<br>
Chris<br>
<br>
<blockquote type="cite" style="padding:0 0.4em;border-left:#1010ff 2px solid;margin:0">-----Original Message-----<br>
From: Zoltan Szecsei [mailto:<a href="mailto:zoltans@geograph.co.za" target="_blank">zoltans@geograph.co.za</a>]<br>
Sent: Tuesday, 4 August 2015 10:27 p.m.<br>
To: <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
Subject: [Qgis-developer] QGIS 2.10.1 Pisa - Read CSV file problem<br>
<br>
Hi,<br>
Using the above version on Win 7 64 bit, I read a CSV file (as attributes only)<br>
stipulating that "first record has field names"<br>
Record 1 is as follows:<br>
"SALnum","SALnam","1","2","3","4","5","6","7","8","9","10+"<br>
<br>
When I open the attribute table, I see that fields 1 & 2 have names SALnum<br>
and SALnam, but the rest are called 'Field_3', 'Field_4' and so on.<br>
<br>
When I edit record 1 of this CSV file to look like:<br>
"SALnum","SALnam","1p","2p","3p","4p","5p","6p","7p","8p","9p","10+p"<br>
<br>
The I get the correct field names (albeit 1p instead of just "1")<br>
<br>
Is this an error, or is there some reason further down the line, that attribute<br>
tables cannot have 'numeric' field names?<br>
<br>
Thanks and regards,<br>
Zoltan<br>
<br>
<br>
--<br>
<br>
===========================================<br>
Zoltan Szecsei PrGISc [PGP0031]<br>
Geograph (Pty) Ltd.<br>
GIS and Photogrammetric Services<br>
<br>
P.O. Box 7, Muizenberg 7950, South Africa.<br>
<br>
Mobile: <a href="tel:%2B27-%E2%81%A083-%E2%81%A06004028" value="+27836004028" target="_blank">+27-83-6004028</a><br>
Fax: <a href="tel:%2B27-%E2%81%A086-%E2%81%A06115323" value="+27866115323" target="_blank">+27-86-6115323</a> <a href="http://www.geograph.co.za" target="_blank">www.geograph.co.za</a><br>
===========================================<br>
<br>
</blockquote>
<br>
This message contains information, which may be in confidence and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately (Phone 0800 665 463 or <a href="mailto:info@linz.govt.nz" target="_blank"></a><a href="mailto:info@linz.govt.nz" target="_blank">info@linz.govt.nz</a>) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ. Thank You.</blockquote>
<br>
-- <br>
<br>
===========================================<br>
Zoltan Szecsei PrGISc [PGP0031]<br>
Geograph (Pty) Ltd.<br>
GIS and Photogrammetric Services<br>
<br>
P.O. Box 7, Muizenberg 7950, South Africa.<br>
<br>
Mobile: <a href="tel:%2B27-%E2%81%A083-%E2%81%A06004028" value="+27836004028" target="_blank">+27-83-6004028</a><br>
Fax: <a href="tel:%2B27-%E2%81%A086-%E2%81%A06115323" value="+27866115323" target="_blank">+27-86-6115323</a> <a href="http://www.geograph.co.za" target="_blank">www.geograph.co.za</a><br>
===========================================<br>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a></div>
</blockquote>
<p> </p>
<div> </div>
</blockquote>
<br>
</div></div><span class="HOEnZb"><font color="#888888"><pre cols="72">--
===========================================
Zoltan Szecsei PrGISc [PGP0031]
Geograph (Pty) Ltd.
GIS and Photogrammetric Services
P.O. Box 7, Muizenberg 7950, South Africa.
Mobile: <a href="tel:%2B27-83-6004028" value="+27836004028" target="_blank">+27-83-6004028</a>
Fax: <a href="tel:%2B27-86-6115323" value="+27866115323" target="_blank">+27-86-6115323</a> <a href="http://www.geograph.co.za" target="_blank">www.geograph.co.za</a>
===========================================</pre>
</font></span></div>
<br>_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br></blockquote></div><br></div></div>