<p dir="ltr">This might be the plugin you are talking about:</p>
<p dir="ltr"><a href="https://plugins.qgis.org/plugins/SpreadsheetLayers/">https://plugins.qgis.org/plugins/SpreadsheetLayers/</a></p>
<br><div class="gmail_quote"><div dir="ltr">A dom, 10/07/2016, 13:16, Richard Duivenvoorde <<a href="mailto:rdmailings@duif.net">rdmailings@duif.net</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
@paolo: which plugin are you thinking of?<br>
Because for exampe xytools can open odt and excel, but via python, while<br>
the idea here is to be able to load whatever (table) format ogr is able<br>
to load. And not only given and x,y field but also a column containing<br>
wkt polygons (as the csv-provider does that already)...<br>
This would for example also work for a dbf containg x,y values<br>
<br>
@mattias: mm, if I load a strict csv table (be it csv or excel),<br>
containing an x and y column, according to this blogpost:<br>
<a href="http://www.opengis.ch/2015/12/10/geometry-generator-symbology/" rel="noreferrer" target="_blank">http://www.opengis.ch/2015/12/10/geometry-generator-symbology/</a><br>
I should be able to select a geometry generator in styles.. but with a<br>
table the styles is ... empty :-(<br>
<br>
Tried to make a geometry using vectorcalc, but it will not 'morph' the<br>
layer from a table (icon) in a geometry/point icon and the points (I<br>
tried: make_point)<br>
<br>
I am aware that this is probably readonly, but that is ok I think.<br>
<br>
Regards,<br>
<br>
Richard<br>
<br>
On 09-07-16 11:44, Matthias Kuhn wrote:<br>
> Hi,<br>
><br>
> I think there are already 2 possibilities to show x,y /wkt or other<br>
> geometries for any kind of layers<br>
><br>
> * Geometry generators<br>
><br>
> * Virtual layers (no expert, but I guess that's possible)<br>
><br>
> So at least read-only this should be straightforward, read-write maybe<br>
> with virtual layers (?).<br>
><br>
> Matthias<br>
><br>
> On 07/09/2016 11:34 AM, Raymond Nijssen wrote:<br>
>> Great idea! ;)<br>
>><br>
>> Question is where to implement it in the GUI. It overlaps the<br>
>> functionality in the delimited text reader. Like pointing to the x and y<br>
>> columns or choosing a column containing wkt.<br>
>><br>
>> Maybe it could be a 2 steps process? Step 1 is importing any table and<br>
>> step 2 is creating a spatial layer from it. But we would loose the quick<br>
>> "Add delimited text layer" functionality.<br>
>><br>
>> Any ideas?<br>
>><br>
>> @Paolo, which plugin can do this? XyTools?<br>
>><br>
>> Regards,<br>
>> Raymond<br>
>><br>
>><br>
>><br>
>><br>
>> On 09-07-16 11:14, Paolo Cavallini wrote:<br>
>>> Agreed. There is a plugin doing this, but of course having it as a<br>
>>> standard function is desirable.<br>
>>> Thanks for raising this.<br>
>>><br>
>>> Il 9 luglio 2016 12:00:38 EEST, Richard Duivenvoorde<br>
>>> <<a href="mailto:rdmailings@duif.net" target="_blank">rdmailings@duif.net</a>> ha scritto:<br>
>>><br>
>>> Hi Devs,<br>
>>><br>
>>> Raymond Nijssen had an (I think) intriguing idea:<br>
>>><br>
>>> QGIS can open different types of table-data: dbf, excel etc etc<br>
>>><br>
>>> But if the excel contains an x,y,wkt column, you have to save it to<br>
>>> csv/tsv first, to be able to use the delimited-text-provider to open it<br>
>>> as a layer.<br>
>>><br>
>>> His idea: can't we use the delimited-text-provider for all tables that<br>
>>> are open in QGIS immediately?<br>
>>><br>
>>> Had a look into the code<br>
>>><br>
>>> <a href="https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.cpp#L583" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.cpp#L583</a><br>
>>><br>
>>> which 'just' looks like a QTextStream:<br>
>>><br>
>>> <a href="https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.h#L352" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.h#L352</a><br>
>>><br>
>>> And<br>
>>> according to this:<br>
>>> <a href="https://forum.qt.io/topic/63310/how-to-save-a-treeview-as-csv-file-in-qt" rel="noreferrer" target="_blank">https://forum.qt.io/topic/63310/how-to-save-a-treeview-as-csv-file-in-qt</a><br>
>>><br>
>>> It is easy to create a textstream from QModel (in which we have the data<br>
>>> I think???)...<br>
>>><br>
>>> So Question:<br>
>>> - (to devs): would this indeed be doable/easy?<br>
>>> - (to UI's): should the Delimited Text File dialog be updated then (or<br>
>>> only with a 'open excisting table button'?<br>
>>> - should we rename the provider to 'table' provider.<br>
>>><br>
>>> Comments/Opinions?<br>
>>><br>
>>> Regards,<br>
>>><br>
>>> Richard Duivenvoorde<br>
>>> ------------------------------------------------------------------------<br>
>>><br>
>>> Qgis-developer mailing list<br>
>>> <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
>>> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
>>> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
>>><br>
>>><br>
>>> --<br>
>>> Paolo Cavallini<br>
>>> <a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">www.faunalia.eu</a> <<a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">http://www.faunalia.eu</a>><br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> Qgis-developer mailing list<br>
>>> <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
>>> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
>>> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
>>><br>
>> _______________________________________________<br>
>> Qgis-developer mailing list<br>
>> <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
>> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
>> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
><br>
> --<br>
> Matthias Kuhn<br>
> OPENGIS.ch - <a href="https://www.opengis.ch" rel="noreferrer" target="_blank">https://www.opengis.ch</a><br>
> Spatial • (Q)GIS • PostGIS • Open Source<br>
><br>
><br>
><br>
> _______________________________________________<br>
> Qgis-developer mailing list<br>
> <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
><br>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote></div><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature"><div dir="ltr"><div>Alexandre Neto</div><div>---------------------</div><div>@AlexNetoGeo</div><div><a href="http://sigsemgrilhetas.wordpress.com">http://sigsemgrilhetas.wordpress.com</a></div><a href="http://gisunchained.wordpress.com">http://gisunchained.wordpress.com</a><br></div></div>