[Qgis-developer] QGIS 2.10.1 Pisa - Read CSV file problem

[Zoltan Szecsei]

Hi Chris,
Good on you.
I logged it yesterday (#13187).
Do you get to mark it as "fixed"?
For the sake of a snail-trail, it's probably better than me just 
withdrawing it?

I completed the job I was doing, by parsing the csv files in bash (I 
moved the job over to my linux setup - I only use the Windows version 
for 'quickies'), so for now I am not in a hurry for this - but if I get 
another request for the job I was doing, I'll just pull the code and 
build it on my system.

Thanks again for seeing the bigger picture.

Regards,
Zoltan

On 2015/08/07 00:32, Chris Crook wrote:
> Hi Zoltan
>
> I've removed this constraint on field names from the QGIS code - this will apply in the next release of QGIS.  So no need to raise a bug.  If you do want to (or have other issues/feature requests) information about how to do so is at http://qgis.org/en/site/getinvolved/development/index.html#bugs-features-and-issues.  Feedback from the user community is certainly encouraged.
>
> Until the next release though you may have to write a script to deal with the files (or live with the replaced field names).
>
> As to the silence - who knows!  Certainly this hasn't been raised to my knowledge, and the "feature" has been there a couple of years now.  I think if many users were affected this would have come up sooner, but great that you have raised it.
>
> Cheers
> Chris
>
>
>> -----Original Message-----
>> From: Zoltan Szecsei [mailto:zoltans at geograph.co.za]
>> Sent: Thursday, 6 August 2015 5:32 p.m.
>> To: Chris Crook; 'Qgis-developer at lists.osgeo.org'
>> Subject: Re: [Qgis-developer] QGIS 2.10.1 Pisa - Read CSV file problem
>>
>> Hi Chris,
>> Thanks for the opinion.
>> Do I log this as a bug?
>>
>> 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.
>> Maybe the silence on this is because it either goes unnoticed, or there are
>> many people just doing a work-around.
>>
>> Let me know.
>>
>> Thanks & regards,
>> Zoltan
>>
>> On 2015/08/05 02:55, Chris Crook wrote:
>>> Hi Zoltan
>>>
>>> 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).
>>> 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...
>>> Cheers
>>> Chris
>>>
>>>> -----Original Message-----
>>>> From: Zoltan Szecsei [mailto:zoltans at geograph.co.za]
>>>> Sent: Tuesday, 4 August 2015 10:27 p.m.
>>>> To: Qgis-developer at lists.osgeo.org
>>>> Subject: [Qgis-developer] QGIS 2.10.1 Pisa - Read CSV file problem
>>>>
>>>> Hi,
>>>> Using the above version on Win 7 64 bit, I read a CSV file (as
>>>> attributes only) stipulating that "first record has field names"
>>>> Record 1 is as follows:
>>>> "SALnum","SALnam","1","2","3","4","5","6","7","8","9","10+"
>>>>
>>>> When I open the attribute table, I see that fields 1 & 2 have names
>>>> SALnum and SALnam, but the rest are called 'Field_3', 'Field_4' and so
>> on.
>>>> When I edit record 1 of this CSV file to look like:
>>>>
>> "SALnum","SALnam","1p","2p","3p","4p","5p","6p","7p","8p","9p","10+p"
>>>> The I get the correct field names (albeit 1p instead of just "1")
>>>>
>>>> Is this an error, or is there some reason further down the line, that
>>>> attribute tables cannot have 'numeric' field names?
>>>>
>>>> Thanks and regards,
>>>> Zoltan
>>>>
>>>>
>>>> --
>>>>
>>>> ===========================================
>>>> Zoltan Szecsei PrGISc [PGP0031]
>>>> Geograph (Pty) Ltd.
>>>> GIS and Photogrammetric Services
>>>>
>>>> P.O. Box 7, Muizenberg 7950, South Africa.
>>>>
>>>> Mobile: +27-83-6004028
>>>> Fax:    +27-86-6115323     www.geograph.co.za
>>>> ===========================================
>>>>
>>> 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 info at linz.govt.nz) 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.
>>
>> --
>>
>> ===========================================
>> Zoltan Szecsei PrGISc [PGP0031]
>> Geograph (Pty) Ltd.
>> GIS and Photogrammetric Services
>>
>> P.O. Box 7, Muizenberg 7950, South Africa.
>>
>> Mobile: +27-83-6004028
>> Fax:    +27-86-6115323     www.geograph.co.za
>> ===========================================
>
> 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 info at linz.govt.nz) 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.

-- 

===========================================
Zoltan Szecsei PrGISc [PGP0031]
Geograph (Pty) Ltd.
GIS and Photogrammetric Services

P.O. Box 7, Muizenberg 7950, South Africa.

Mobile: +27-83-6004028
Fax:    +27-86-6115323     www.geograph.co.za
===========================================