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

[Alexandre Neto]

This might be the plugin you are talking about:

https://plugins.qgis.org/plugins/SpreadsheetLayers/

A dom, 10/07/2016, 13:16, Richard Duivenvoorde <rdmailings at duif.net>
escreveu:

>
> @paolo: which plugin are you thinking of?
> Because for exampe xytools can open odt and excel, but via python, while
> the idea here is to be able to load whatever (table) format ogr is able
> to load. And not only given and x,y field but also a column containing
> wkt polygons (as the csv-provider does that already)...
> This would for example also work for a dbf containg x,y values
>
> @mattias: mm, if I load a strict csv table (be it csv or excel),
> containing an x and y column, according to this blogpost:
> http://www.opengis.ch/2015/12/10/geometry-generator-symbology/
> I should be able to select a geometry generator in styles.. but with a
> table the styles is ... empty :-(
>
> Tried to make a geometry using vectorcalc, but it will not 'morph' the
> layer from a table (icon) in a geometry/point icon and the points (I
> tried: make_point)
>
> I am aware that this is probably readonly, but that is ok I think.
>
> Regards,
>
> Richard
>
> On 09-07-16 11:44, Matthias Kuhn wrote:
> > 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
> >
> >
> >
> > _______________________________________________
> > 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

-- 
Alexandre Neto
---------------------
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160710/4f4ae1f4/attachment-0001.html>