[Qgis-developer] morph delimited-text-provider to generic table-provider?

[Matthias Kuhn]

Hi,

I think there are already 2 possibilities to show x,y /wkt or other
geometries for any kind of layers

 * Geometry generators

 * Virtual layers (no expert, but I guess that's possible)

So at least read-only this should be straightforward, read-write maybe
with virtual layers (?).

Matthias

On 07/09/2016 11:34 AM, Raymond Nijssen wrote:
> Great idea! ;)
>
> Question is where to implement it in the GUI. It overlaps the
> functionality in the delimited text reader. Like pointing to the x and y
> columns or choosing a column containing wkt.
>
> Maybe it could be a 2 steps process? Step 1 is importing any table and
> step 2 is creating a spatial layer from it. But we would loose the quick
> "Add delimited text layer" functionality.
>
> Any ideas?
>
> @Paolo, which plugin can do this? XyTools?
>
> Regards,
> Raymond
>
>
>
>
> On 09-07-16 11:14, Paolo Cavallini wrote:
>> Agreed. There is a plugin doing this, but of course having it as a
>> standard function is desirable.
>> Thanks for raising this.
>>
>> Il 9 luglio 2016 12:00:38 EEST, Richard Duivenvoorde
>> <rdmailings at duif.net> ha scritto:
>>
>>     Hi Devs,
>>
>>     Raymond Nijssen had an (I think) intriguing idea:
>>
>>     QGIS can open different types of table-data: dbf, excel etc etc
>>
>>     But if the excel contains an x,y,wkt column, you have to save it to
>>     csv/tsv first, to be able to use the delimited-text-provider to open it
>>     as a layer.
>>
>>     His idea: can't we use the delimited-text-provider for all tables that
>>     are open in QGIS immediately?
>>
>>     Had a look into the code
>>
>>     https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.cpp#L583
>>
>>     which 'just' looks like a QTextStream:
>>
>>     https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.h#L352
>>
>>     And
>>     according to this:
>>     https://forum.qt.io/topic/63310/how-to-save-a-treeview-as-csv-file-in-qt
>>
>>     It is easy to create a textstream from QModel (in which we have the data
>>     I think???)...
>>
>>     So Question:
>>     - (to devs): would this indeed be doable/easy?
>>     - (to UI's): should the Delimited Text File dialog be updated then (or
>>     only with a 'open excisting table button'?
>>     - should we rename the provider to 'table' provider.
>>
>>     Comments/Opinions?
>>
>>     Regards,
>>
>>     Richard Duivenvoorde
>>     ------------------------------------------------------------------------
>>
>>     Qgis-developer mailing list
>>     Qgis-developer at lists.osgeo.org
>>     List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>     Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>>
>> -- 
>> Paolo Cavallini
>> www.faunalia.eu <http://www.faunalia.eu>
>>
>>
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
Matthias Kuhn
OPENGIS.ch - https://www.opengis.ch
Spatial • (Q)GIS • PostGIS • Open Source

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160709/9f383c92/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160709/9f383c92/attachment-0001.sig>