Re: [Qgis-developer] QGIS 2.10.1 Pisa - Read CSV file problem
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:zolt...@geograph.co.za] Sent: Thursday, 6 August 2015 5:32 p.m. To: Chris Crook; 'Qgis-developer@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:zolt...@geograph.co.za] Sent: Tuesday, 4 August 2015 10:27 p.m. To: Qgis-developer@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 i...@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 i...@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. --
Re: [Qgis-developer] Certificate update QGIS servers
On 06-08-15 21:44, Nyall Dawson wrote: Dash is showing this too: http://dash.orfeo-toolbox.org/index.php?project=QGIS That's not even hosted by us... Nope, and has nothing to do with us either... https://dash.orfeo-toolbox.org/index.php (not only when you try to visit via httpS) shows this sign too I've sent an email to kitware the makers of dash Regards, Richard ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Certificate update QGIS servers
On 06-08-15 22:45, Andreas Neumann wrote: So Richard - could you try to follow the Webmaster Tools link and see if we can get more information? Did that. Does NOT give any information... It seems to have something to do with using httpS when visiting https://www.qgis.org because visiting https://qgis.org is ok... My quess is/was that we had/have spam links in our wiki, but as said, Google gives you the possibility to list the tainted url's... but that list is emtpy :-( I've asked for a new 'review' now from Google. Which can take up 24 hours they say... The other thing to check is if the very recent certificate updates maybe trigger this warning? mmm, should not be the case, I think it is a coincident that Matthias check/found this. But I even reverted the certificate now (you should see that it is still valid until 18-10-15), but according to Google we are still tainted... Let's see what the which verdict is given by Google-UberMaster after their review ... Regards, Richard Duivenvoorde ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Certificate update QGIS servers
Hi Richard, Thank you for dealing with this very annoying issue. It is easy to ruin a good reputation, but not so easy to gain one. And it is especially annoying if such warnings to not provide enough meaningful information to fix such warnings. Andreas On 2015-08-07 10:26, Richard Duivenvoorde wrote: On 06-08-15 22:45, Andreas Neumann wrote: So Richard - could you try to follow the Webmaster Tools link and see if we can get more information? Did that. Does NOT give any information... It seems to have something to do with using httpS when visiting https://www.qgis.org [1] because visiting https://qgis.org [2] is ok... My quess is/was that we had/have spam links in our wiki, but as said, Google gives you the possibility to list the tainted url's... but that list is emtpy :-( I've asked for a new 'review' now from Google. Which can take up 24 hours they say... The other thing to check is if the very recent certificate updates maybe trigger this warning? mmm, should not be the case, I think it is a coincident that Matthias check/found this. But I even reverted the certificate now (you should see that it is still valid until 18-10-15), but according to Google we are still tainted... Let's see what the which verdict is given by Google-UberMaster after their review ... Regards, Richard Duivenvoorde ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer [3] Links: -- [1] https://www.qgis.org [2] https://qgis.org [3] http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] very slow on creating a new empty spatialite db
On Fri, 07 Aug 2015 16:43:11 +0200, Ing. Pierluigi De Rosa wrote: Dear all, I'm experiencing than when I create a new empty spatialite from qgis it takes long time to do it. snip - sql = 'SELECT InitSpatialMetadata()' Hi Pierluigi, InitSpatialMetadata() will insert about 5,000 rows into the spatial_ref_sys table. SQLite is a full ACID DBMS, so performing so many INSERTs outside a TRANSACTION will certainly be a very slow operation. solution #1: --- sql = 'BEGIN; SELECT InitSpatialMetadata(); COMMIT;' solution #2: sql = 'SELECT InitSpatialMetadata(1);' both solutions have the same identical effect: in the first case you'll explicitly define a Transaction in your own SQL code. in the second case by passing to InitSpatialMetadata() a TRUE argument you'll authorize this function to silently handle an internal Transaction. bye Sandro ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
[Qgis-developer] very slow on creating a new empty spatialite db
Dear all, I'm experiencing than when I create a new empty spatialite from qgis it takes long time to do it. Here belo is the code I tried: --- # -*- coding: utf-8 -*- from qgis.core import * import qgis.utils from pyspatialite import dbapi2 as db import timeit start = timeit.default_timer() dbase='/home/pierluigi/Scrivania/db.sqlite' conn = db.connect(dbase) cur = conn.cursor() sql = 'SELECT InitSpatialMetadata()' cur.execute(sql) conn.commit() stop = timeit.default_timer() print stop - start --- If i run this code my pc start swapping so much and to prepare the empty db (the total variable) it takes 722.3559 sec or better ABOUT 12 MINUTES!!! Of course the same is if I just save a layer into spatialite format. Why is this happens? Is there a work around for my code to speed up che db creation? I'm running qgis on ubuntu 14.04, qgis 2.8 LTS from launchpad unstable repo. Thanks Pierluigi -- Ing. Pierluigi De Rosa (PhD) Studio Associato GFOSSERVICES Presso CAMPUS Via F.lli Cairoli 25 - 06127 Perugia (PG) fax: 075 7823038 cel: 3497558268 web: www.gfosservices.it skype: pierluigi.derosa ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer