https://issues.qgis.org/https://issues.qgis.org/favicon.ico2011-07-18T15:41:09ZQGIS Issue TrackingQGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=252582011-07-18T15:41:09Zspringmeyer -dane@dbsgeo.com
<ul></ul><p>I also meant to mention that when "a value" is imported the quotes are not stripped, as they should be. It is my understanding that quoted strings should be representing string literals so keeping the quotes after import is wrong.</p> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=267802011-12-09T07:36:53ZPaolo Cavallinicavallini@faunalia.it
<ul><li><strong>Category</strong> set to <i>C++ Plugins</i></li><li><strong>Pull Request or Patch supplied</strong> set to <i>No</i></li></ul> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=277992011-12-16T13:11:57ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Target version</strong> set to <i>Version 1.7.4</i></li></ul> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=285962012-01-16T16:01:25ZChris Crookccrook@linz.govt.nz
<ul><li><strong>Affected QGIS version</strong> set to <i>master</i></li><li><strong>Crashes QGIS or corrupts data</strong> set to <i>No</i></li></ul><p>Definitely an issue with CSV import! The workaround for the moment is to OGR CSV format (with a VRT file) which works just fine. Will have a look at fixing this in delimited text plugin.</p> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=285982012-01-16T19:39:59Zspringmeyer -dane@dbsgeo.com
<ul></ul><p>Chris Crook wrote:</p>
<blockquote>
<p>Definitely an issue with CSV import! The workaround for the moment is to OGR CSV format (with a VRT file) which works just fine. Will have a look at fixing this in delimited text plugin.</p>
</blockquote>
<p>Hey, thanks for commenting. I've used the VRT method and was looking for a one-step approach for novice users. I ended up solving things (for my purposes) in Mapnik by writing my own CSV plugin. So, +1 to improving this feature, but at least my original usecase is not longer critical.</p> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=310352012-04-16T04:28:54ZPaolo Cavallinicavallini@faunalia.it
<ul><li><strong>Target version</strong> changed from <i>Version 1.7.4</i> to <i>Version 1.8.0</i></li></ul> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=345342012-09-04T09:59:15ZPaolo Cavallinicavallini@faunalia.it
<ul><li><strong>Target version</strong> changed from <i>Version 1.8.0</i> to <i>Version 2.0.0</i></li></ul> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=367612012-10-29T07:22:58ZGiuseppe Sucamelibrush.tyler@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>Fixed in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/230bbfb459f807a645fa3edbbc44b1012177bdfb" title="use plain delimiter if one delimiter only was selected (partially fix #4091)">230bbfb459f807a645fa3edbbc44b1012177bdfb</a>.</p> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=367622012-10-29T07:33:44ZGiuseppe Sucamelibrush.tyler@gmail.com
<ul><li><strong>% Done</strong> changed from <i>0</i> to <i>50</i></li><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li><li><strong>Assignee</strong> deleted (<del><i>Chris Crook</i></del>)</li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>Low</i></li></ul><p>Whether you choose only one delimiter from the "selected delimiter" list it is internally converted to "plain delimiter", so now it works also quoted strings (see <a class="issue tracker-1 status-5 priority-4 priority- closed" href="https://issues.qgis.org/issues/6013" title="Delimited text provider/plugin doesn't work as expected with quoted strings containing the delimi... (Closed)">#6013</a>).</p>
<p>If more delimiters are choosen from the "selected delimiters" list it still uses the "regexp delimiter" and it doesn't parse qouted strings.</p>
<p>The newline problem (quoted strings on more lines are not parsed) is still there, whatever delimiter you're using.</p> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=368242012-11-02T10:12:33ZChris Crookccrook@linz.govt.nz
<ul></ul><p>I have an update for the delimiter plugin which fixes the newline and comma issues, but it also requires an update to the plugin dialogue which I haven't had time to complete yet. Basically the approach I am considering is to use a couple of alternative parsers - one for regexp, one for plain whitespace, and one for fixed delimiters such as CSV. I'm thinking the dialog could then be a bit simpler (for the user), with an initial selection of parser type (which could include preset types, such as Excel CSV, tab delimited), and then options displayed according to the type of delimiter set.</p>
<p>One development issue that makes this difficult is that both the data provider plugin and the options need to access the same parsing code, but they are different compilation modules, so I haven't figured where to put the common code, or whether to just replicate it.</p> QGIS Application - Bug report #4091: Create layer from delimited text (csv) does not work properly for quoted stringshttps://issues.qgis.org/issues/4091?journal_id=402012013-04-15T15:44:59ZChris Crookccrook@linz.govt.nz
<ul><li><strong>Status</strong> changed from <i>Reopened</i> to <i>Closed</i></li></ul><p>Fixed for 2.0 at commit fab2c57478f67be01a9ac91f0ce27a1f739d0501</p>