Re: [QGIS-Developer] Appending text data to a geopackage

2018-10-27 Thread Paolo Cavallini 
Right, obrigado Alex.


Il 10/26/2018 11:11 AM, Alexandre Neto ha scritto:
> Hi Paolo,
>
> After loading  the text as a delimited text layer, If the attributes
> are formatted exactly as the destination table, you can GDAL's Import
> vector into PostGIS database processing tool, which contains an
> "append" option.
>
> Alexandre Neto
>
> Paolo Cavallini mailto:cavall...@faunalia.it>>
> escreveu no dia sexta, 26/10/2018 às 09:48:
>
> yes, thanks. aa bit of a hack, I wish we could have a cleaner
> solution; thanks a lot for the suggestion.
>
> all the best.
>
>
> Il 10/24/2018 10:08 PM, Marco Bernasocchi ha scritto:
>>
>> Import the new text as csv in qgis anc copy paste it to the gpkg
>> layer?
>>
>> ciao
>>
>> On 10.10.18 16:18, Paolo Cavallini wrote:
>>>
>>> Hi Carlo,
>>>
>>> I think I didn't explain my problem well: I have new data coming
>>> as text, and I'm looking for an easy way of appending these to
>>> an existing gpkg table.
>>>
>>> Thanks.
>>>
>>>
>>> Il 10/10/2018 02:30 PM, Carlo A. Bertelli (Charta s.r.l.) ha
>>> scritto:
 What about working on a geometric view with properly configured
 rules while on PostgresSQL or with a trigger on other DBMSs
 (SQLite too)? It seems the easiest way to avoid the shell.
 Maybe there could even be a way with a virtual file based on
 internal SQLite... Just a thought...
 c

 On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini
 mailto:cavall...@faunalia.it>> wrote:

 Hi all,

 I have a simple problem for which I cannot find a simple
 solution: I
 have a table in a gpkg, and I have to add often data coming
 from text.
 Ideally I'd like to paste the text as a new record, having
 it parsed
 automatically. Currently this only seems possible from an
 SQL shell.
 Anything I'm overlooking?

 All the best, and thanks.

 -- 
 Paolo Cavallini - www.faunalia.eu 
 QGIS.ORG  Chair:
 http://planet.qgis.org/planet/user/28/tag/qgis%20board/


 ___
 QGIS-Developer mailing list
 QGIS-Developer@lists.osgeo.org
 
 List info:
 https://lists.osgeo.org/mailman/listinfo/qgis-developer
 Unsubscribe:
 https://lists.osgeo.org/mailman/listinfo/qgis-developer



 -- 
 
 --
 Carlo A. Bertelli
    Charta servizi e sistemi per il territorio e la storia
 ambientale srl
           Dipendenze del palazzo Doria,
           vc. alla Chiesa della Maddalena 9/2 16124      Genova
 (Italy)
           tel./fax +39(0)10 2475439  +39 0108566195
   mobile:+39 393 1590711
 
    e-mail: berte...@chartasrl.eu
       http://www.chartasrl.eu
 
 --



>>>
>>> -- 
>>> Paolo Cavallini - www.faunalia.eu 
>>> QGIS.ORG  Chair:
>>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>>>
>>> ___
>>> QGIS-Developer mailing list
>>> QGIS-Developer@lists.osgeo.org
>>> 
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> -- 
>> Marco Bernasocchi
>> QGIS.org Co-chair
>> ma...@opengis.ch 
>> +41 (0)79 467 24 70 
>>
>> OPENGIS.ch Logo 
>>
>>
>> ___
>> QGIS-Developer mailing list
>> QGIS-Developer@lists.osgeo.org
>> 
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
> -- 
> Paolo Cavallini - www.faunalia.eu 
> QGIS.ORG  Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org 
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
> -- 
> Alexandre Neto
> -
> @AlexNetoGeo
> http://sigsemgrilhetas.wordpress.com
>

Re: [QGIS-Developer] Appending text data to a geopackage

2018-10-26 Thread Alexandre Neto 
Hi Paolo,

After loading  the text as a delimited text layer, If the attributes are
formatted exactly as the destination table, you can GDAL's Import vector
into PostGIS database processing tool, which contains an "append" option.

Alexandre Neto

Paolo Cavallini  escreveu no dia sexta, 26/10/2018
às 09:48:

> yes, thanks. aa bit of a hack, I wish we could have a cleaner solution;
> thanks a lot for the suggestion.
>
> all the best.
>
> Il 10/24/2018 10:08 PM, Marco Bernasocchi ha scritto:
>
> Import the new text as csv in qgis anc copy paste it to the gpkg layer?
>
> ciao
> On 10.10.18 16:18, Paolo Cavallini wrote:
>
> Hi Carlo,
>
> I think I didn't explain my problem well: I have new data coming as text,
> and I'm looking for an easy way of appending these to an existing gpkg
> table.
>
> Thanks.
>
> Il 10/10/2018 02:30 PM, Carlo A. Bertelli (Charta s.r.l.) ha scritto:
>
> What about working on a geometric view with properly configured rules
> while on PostgresSQL or with a trigger on other DBMSs (SQLite too)? It
> seems the easiest way to avoid the shell. Maybe there could even be a way
> with a virtual file based on internal SQLite... Just a thought...
> c
>
> On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini 
> wrote:
>
>> Hi all,
>>
>> I have a simple problem for which I cannot find a simple solution: I
>> have a table in a gpkg, and I have to add often data coming from text.
>> Ideally I'd like to paste the text as a new record, having it parsed
>> automatically. Currently this only seems possible from an SQL shell.
>> Anything I'm overlooking?
>>
>> All the best, and thanks.
>>
>> --
>> Paolo Cavallini - www.faunalia.eu
>> QGIS.ORG Chair:
>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>>
>>
>> ___
>> QGIS-Developer mailing list
>> QGIS-Developer@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
>
> --
> --
> Carlo A. Bertelli
>Charta servizi e sistemi per il territorio e la storia ambientale srl
>   Dipendenze del palazzo Doria,
>   vc. alla Chiesa della Maddalena 9/2 16124  Genova (Italy)
>   tel./fax +39(0)10 2475439  +39 0108566195
> <+39%20010%20856%206195>  mobile:+39 393 1590711 <+39%20393%20159%200711>
>e-mail: berte...@chartasrl.eu  http://www.chartasrl.eu
> --
>
>
>
>
> --
> Paolo Cavallini - www.faunalia.euQGIS.ORG 
> Chair:http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
>
> ___
> QGIS-Developer mailing listqgis-develo...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
> --
> Marco Bernasocchi
> QGIS.org Co-chair
> ma...@opengis.ch
> +41 (0)79 467 24 70 <+41794672470>
>
> [image: OPENGIS.ch Logo] 
>
>
> ___
> QGIS-Developer mailing listqgis-develo...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> --
> Paolo Cavallini - www.faunalia.euQGIS.ORG 
> Chair:http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
Alexandre Neto
-
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Appending text data to a geopackage

2018-10-26 Thread Paolo Cavallini 
yes, thanks. aa bit of a hack, I wish we could have a cleaner solution;
thanks a lot for the suggestion.

all the best.


Il 10/24/2018 10:08 PM, Marco Bernasocchi ha scritto:
>
> Import the new text as csv in qgis anc copy paste it to the gpkg layer?
>
> ciao
>
> On 10.10.18 16:18, Paolo Cavallini wrote:
>>
>> Hi Carlo,
>>
>> I think I didn't explain my problem well: I have new data coming as
>> text, and I'm looking for an easy way of appending these to an
>> existing gpkg table.
>>
>> Thanks.
>>
>>
>> Il 10/10/2018 02:30 PM, Carlo A. Bertelli (Charta s.r.l.) ha scritto:
>>> What about working on a geometric view with properly configured
>>> rules while on PostgresSQL or with a trigger on other DBMSs (SQLite
>>> too)? It seems the easiest way to avoid the shell. Maybe there could
>>> even be a way with a virtual file based on internal SQLite... Just a
>>> thought...
>>> c
>>>
>>> On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini
>>> mailto:cavall...@faunalia.it>> wrote:
>>>
>>> Hi all,
>>>
>>> I have a simple problem for which I cannot find a simple solution: I
>>> have a table in a gpkg, and I have to add often data coming from
>>> text.
>>> Ideally I'd like to paste the text as a new record, having it parsed
>>> automatically. Currently this only seems possible from an SQL shell.
>>> Anything I'm overlooking?
>>>
>>> All the best, and thanks.
>>>
>>> -- 
>>> Paolo Cavallini - www.faunalia.eu 
>>> QGIS.ORG  Chair:
>>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>>>
>>>
>>> ___
>>> QGIS-Developer mailing list
>>> QGIS-Developer@lists.osgeo.org
>>> 
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>>>
>>>
>>> -- 
>>> --
>>> Carlo A. Bertelli
>>>    Charta servizi e sistemi per il territorio e la storia ambientale
>>> srl
>>>           Dipendenze del palazzo Doria,
>>>           vc. alla Chiesa della Maddalena 9/2 16124      Genova (Italy)
>>>           tel./fax +39(0)10 2475439  +39 0108566195  mobile:+39 393
>>> 1590711
>>>    e-mail: berte...@chartasrl.eu      
>>> http://www.chartasrl.eu
>>> --
>>>
>>>
>>>
>>
>> -- 
>> Paolo Cavallini - www.faunalia.eu
>> QGIS.ORG Chair:
>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>>
>> ___
>> QGIS-Developer mailing list
>> QGIS-Developer@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> -- 
> Marco Bernasocchi
> QGIS.org Co-chair
> ma...@opengis.ch 
> +41 (0)79 467 24 70 
>
> OPENGIS.ch Logo 
>
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Appending text data to a geopackage

2018-10-24 Thread Marco Bernasocchi 
Import the new text as csv in qgis anc copy paste it to the gpkg layer?

ciao

On 10.10.18 16:18, Paolo Cavallini wrote:
>
> Hi Carlo,
>
> I think I didn't explain my problem well: I have new data coming as
> text, and I'm looking for an easy way of appending these to an
> existing gpkg table.
>
> Thanks.
>
>
> Il 10/10/2018 02:30 PM, Carlo A. Bertelli (Charta s.r.l.) ha scritto:
>> What about working on a geometric view with properly configured rules
>> while on PostgresSQL or with a trigger on other DBMSs (SQLite too)?
>> It seems the easiest way to avoid the shell. Maybe there could even
>> be a way with a virtual file based on internal SQLite... Just a
>> thought...
>> c
>>
>> On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini
>> mailto:cavall...@faunalia.it>> wrote:
>>
>> Hi all,
>>
>> I have a simple problem for which I cannot find a simple solution: I
>> have a table in a gpkg, and I have to add often data coming from
>> text.
>> Ideally I'd like to paste the text as a new record, having it parsed
>> automatically. Currently this only seems possible from an SQL shell.
>> Anything I'm overlooking?
>>
>> All the best, and thanks.
>>
>> -- 
>> Paolo Cavallini - www.faunalia.eu 
>> QGIS.ORG  Chair:
>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>>
>>
>> ___
>> QGIS-Developer mailing list
>> QGIS-Developer@lists.osgeo.org
>> 
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>>
>>
>> -- 
>> --
>> Carlo A. Bertelli
>>    Charta servizi e sistemi per il territorio e la storia ambientale srl
>>           Dipendenze del palazzo Doria,
>>           vc. alla Chiesa della Maddalena 9/2 16124      Genova (Italy)
>>           tel./fax +39(0)10 2475439  +39 0108566195  mobile:+39 393
>> 1590711
>>    e-mail: berte...@chartasrl.eu      
>> http://www.chartasrl.eu
>> --
>>
>>
>>
>
> -- 
> Paolo Cavallini - www.faunalia.eu
> QGIS.ORG Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-- 
Marco Bernasocchi
QGIS.org Co-chair
ma...@opengis.ch 
+41 (0)79 467 24 70 

OPENGIS.ch Logo 
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Appending text data to a geopackage

2018-10-10 Thread Paolo Cavallini 
Hi Carlo,

I think I didn't explain my problem well: I have new data coming as
text, and I'm looking for an easy way of appending these to an existing
gpkg table.

Thanks.


Il 10/10/2018 02:30 PM, Carlo A. Bertelli (Charta s.r.l.) ha scritto:
> What about working on a geometric view with properly configured rules
> while on PostgresSQL or with a trigger on other DBMSs (SQLite too)? It
> seems the easiest way to avoid the shell. Maybe there could even be a
> way with a virtual file based on internal SQLite... Just a thought...
> c
>
> On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini  > wrote:
>
> Hi all,
>
> I have a simple problem for which I cannot find a simple solution: I
> have a table in a gpkg, and I have to add often data coming from text.
> Ideally I'd like to paste the text as a new record, having it parsed
> automatically. Currently this only seems possible from an SQL shell.
> Anything I'm overlooking?
>
> All the best, and thanks.
>
> -- 
> Paolo Cavallini - www.faunalia.eu 
> QGIS.ORG  Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org 
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
>
> -- 
> --
> Carlo A. Bertelli
>    Charta servizi e sistemi per il territorio e la storia ambientale srl
>           Dipendenze del palazzo Doria,
>           vc. alla Chiesa della Maddalena 9/2 16124      Genova (Italy)
>           tel./fax +39(0)10 2475439  +39 0108566195  mobile:+39 393
> 1590711
>    e-mail: berte...@chartasrl.eu      
> http://www.chartasrl.eu
> --
>
>
>

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Appending text data to a geopackage

2018-10-10 Thread Carlo A. Bertelli (Charta s.r.l.) 
What about working on a geometric view with properly configured rules while
on PostgresSQL or with a trigger on other DBMSs (SQLite too)? It seems the
easiest way to avoid the shell. Maybe there could even be a way with a
virtual file based on internal SQLite... Just a thought...
c

On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini 
wrote:

> Hi all,
>
> I have a simple problem for which I cannot find a simple solution: I
> have a table in a gpkg, and I have to add often data coming from text.
> Ideally I'd like to paste the text as a new record, having it parsed
> automatically. Currently this only seems possible from an SQL shell.
> Anything I'm overlooking?
>
> All the best, and thanks.
>
> --
> Paolo Cavallini - www.faunalia.eu
> QGIS.ORG Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer



-- 
--
Carlo A. Bertelli
   Charta servizi e sistemi per il territorio e la storia ambientale srl
  Dipendenze del palazzo Doria,
  vc. alla Chiesa della Maddalena 9/2 16124  Genova (Italy)
  tel./fax +39(0)10 2475439  +39 0108566195  mobile:+39 393 1590711
   e-mail: berte...@chartasrl.eu  http://www.chartasrl.eu
--
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer