Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Even Rouault]

On vendredi 5 octobre 2018 17:00:12 CEST Michael Treglia wrote:
> I'll file a bug when I can deal with an issue logging into the issue
> tracker system, but if somebody else can do it quickly and beats it to me,
> just report back. Thanks all!

Done as https://issues.qgis.org/issues/20040
I'm working on a fix

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Michael Treglia]

I'll file a bug when I can deal with an issue logging into the issue
tracker system, but if somebody else can do it quickly and beats it to me,
just report back. Thanks all!

On Fri, Oct 5, 2018 at 4:29 PM Michael Treglia  wrote:

> Alright - I get the exact same issue in the nightly dev version.  I
> thought it might have been because I didn't have a primary key in the
> postgis table, but had the same issue for a table that did have a primary
> key.
>
> On Fri, Oct 5, 2018 at 4:16 PM Luigi Pirelli  wrote:
>
>> exactly
>>
>> Luigi Pirelli
>>
>>
>> **
>> * LinkedIn: https://www.linkedin.com/in/luigipirelli
>> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
>> * GitHub: https://github.com/luipir
>> * Mastering QGIS 2nd Edition:
>> *
>> https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
>> * Hire me: http://goo.gl/BYRQKg
>>
>> **
>>
>>
>> On Fri, 5 Oct 2018 at 22:12, Michael Treglia  wrote:
>>
>>> Just to clarify, if installing via OSGeo4w, use QGIS-Dev: QGIS Nightly
>>> build of the development branch (3.3.0-88)?
>>>
>>>
>>>
>>> On Fri, Oct 5, 2018 at 4:08 PM Luigi Pirelli  wrote:
>>>
 may you check with master? 3.2 is at end of life.

 tnx

 Luigi Pirelli


 **
 * LinkedIn: https://www.linkedin.com/in/luigipirelli
 * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
 * GitHub: https://github.com/luipir
 * Mastering QGIS 2nd Edition:
 *
 https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
 * Hire me: http://goo.gl/BYRQKg

 **


 On Fri, 5 Oct 2018 at 21:59, Michael Treglia 
 wrote:

> Whoops! Forgot the key information:
> (Running on Windows 7 Pro x64)
>
> QGIS version
>
> 3.2.3-Bonn
>
> QGIS code revision
>
> 9b176802e5 
>
> Compiled against Qt
>
> 5.9.2
>
> Running against Qt
>
> 5.9.2
>
> Compiled against GDAL/OGR
>
> 2.2.4
>
> Running against GDAL/OGR
>
> 2.2.4
>
> Compiled against GEOS
>
> 3.6.1-CAPI-1.10.1
>
> Running against GEOS
>
> 3.6.1-CAPI-1.10.1 r0
>
> PostgreSQL Client Version
>
> 9.2.4
>
> SpatiaLite Version
>
> 4.3.0
>
> QWT Version
>
> 6.1.3
>
> QScintilla2 Version
>
> 2.10.1
>
> PROJ.4 Version
>
> 493
>
> On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia 
> wrote:
>
>> Hi All,
>>
>> Just checking if others are observing something similar:
>> * I was writing data to gpkg files from a postgis database.from the
>> Database Manager. (e.g., select a layer from the PostGIS database and hit
>> the "export to file" button at the top.
>> * The resulting gpkg layer loses data in a column towards the left,
>> but all of the headings are maintained. Thus, data are shifted to the 
>> left
>> one column from a certain point on, and the last column has NULLs.
>>
>> If writing into an existing gpkg file, dragging and dropping the
>> layer from the PostGIS db into the gpkg file and selecting appropriate
>> options in the dialogue box that pops up does not have that issue.
>>
>> I'm still trying to see exactly what's going on, but figured I'd see
>> if this is something others are experiencing (or if it's already been
>> reported).
>>
>> Mike
>>
>> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Michael Treglia]

Alright - I get the exact same issue in the nightly dev version.  I thought
it might have been because I didn't have a primary key in the postgis
table, but had the same issue for a table that did have a primary key.

On Fri, Oct 5, 2018 at 4:16 PM Luigi Pirelli  wrote:

> exactly
>
> Luigi Pirelli
>
>
> **
> * LinkedIn: https://www.linkedin.com/in/luigipirelli
> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
> * GitHub: https://github.com/luipir
> * Mastering QGIS 2nd Edition:
> *
> https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
> * Hire me: http://goo.gl/BYRQKg
>
> **
>
>
> On Fri, 5 Oct 2018 at 22:12, Michael Treglia  wrote:
>
>> Just to clarify, if installing via OSGeo4w, use QGIS-Dev: QGIS Nightly
>> build of the development branch (3.3.0-88)?
>>
>>
>>
>> On Fri, Oct 5, 2018 at 4:08 PM Luigi Pirelli  wrote:
>>
>>> may you check with master? 3.2 is at end of life.
>>>
>>> tnx
>>>
>>> Luigi Pirelli
>>>
>>>
>>> **
>>> * LinkedIn: https://www.linkedin.com/in/luigipirelli
>>> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
>>> * GitHub: https://github.com/luipir
>>> * Mastering QGIS 2nd Edition:
>>> *
>>> https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
>>> * Hire me: http://goo.gl/BYRQKg
>>>
>>> **
>>>
>>>
>>> On Fri, 5 Oct 2018 at 21:59, Michael Treglia  wrote:
>>>
 Whoops! Forgot the key information:
 (Running on Windows 7 Pro x64)

 QGIS version

 3.2.3-Bonn

 QGIS code revision

 9b176802e5 

 Compiled against Qt

 5.9.2

 Running against Qt

 5.9.2

 Compiled against GDAL/OGR

 2.2.4

 Running against GDAL/OGR

 2.2.4

 Compiled against GEOS

 3.6.1-CAPI-1.10.1

 Running against GEOS

 3.6.1-CAPI-1.10.1 r0

 PostgreSQL Client Version

 9.2.4

 SpatiaLite Version

 4.3.0

 QWT Version

 6.1.3

 QScintilla2 Version

 2.10.1

 PROJ.4 Version

 493

 On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia 
 wrote:

> Hi All,
>
> Just checking if others are observing something similar:
> * I was writing data to gpkg files from a postgis database.from the
> Database Manager. (e.g., select a layer from the PostGIS database and hit
> the "export to file" button at the top.
> * The resulting gpkg layer loses data in a column towards the left,
> but all of the headings are maintained. Thus, data are shifted to the left
> one column from a certain point on, and the last column has NULLs.
>
> If writing into an existing gpkg file, dragging and dropping the layer
> from the PostGIS db into the gpkg file and selecting appropriate options 
> in
> the dialogue box that pops up does not have that issue.
>
> I'm still trying to see exactly what's going on, but figured I'd see
> if this is something others are experiencing (or if it's already been
> reported).
>
> Mike
>
> ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
 Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Luigi Pirelli]

exactly

Luigi Pirelli

**
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS 2nd Edition:
*
https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
* Hire me: http://goo.gl/BYRQKg
**


On Fri, 5 Oct 2018 at 22:12, Michael Treglia  wrote:

> Just to clarify, if installing via OSGeo4w, use QGIS-Dev: QGIS Nightly
> build of the development branch (3.3.0-88)?
>
>
>
> On Fri, Oct 5, 2018 at 4:08 PM Luigi Pirelli  wrote:
>
>> may you check with master? 3.2 is at end of life.
>>
>> tnx
>>
>> Luigi Pirelli
>>
>>
>> **
>> * LinkedIn: https://www.linkedin.com/in/luigipirelli
>> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
>> * GitHub: https://github.com/luipir
>> * Mastering QGIS 2nd Edition:
>> *
>> https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
>> * Hire me: http://goo.gl/BYRQKg
>>
>> **
>>
>>
>> On Fri, 5 Oct 2018 at 21:59, Michael Treglia  wrote:
>>
>>> Whoops! Forgot the key information:
>>> (Running on Windows 7 Pro x64)
>>>
>>> QGIS version
>>>
>>> 3.2.3-Bonn
>>>
>>> QGIS code revision
>>>
>>> 9b176802e5 
>>>
>>> Compiled against Qt
>>>
>>> 5.9.2
>>>
>>> Running against Qt
>>>
>>> 5.9.2
>>>
>>> Compiled against GDAL/OGR
>>>
>>> 2.2.4
>>>
>>> Running against GDAL/OGR
>>>
>>> 2.2.4
>>>
>>> Compiled against GEOS
>>>
>>> 3.6.1-CAPI-1.10.1
>>>
>>> Running against GEOS
>>>
>>> 3.6.1-CAPI-1.10.1 r0
>>>
>>> PostgreSQL Client Version
>>>
>>> 9.2.4
>>>
>>> SpatiaLite Version
>>>
>>> 4.3.0
>>>
>>> QWT Version
>>>
>>> 6.1.3
>>>
>>> QScintilla2 Version
>>>
>>> 2.10.1
>>>
>>> PROJ.4 Version
>>>
>>> 493
>>>
>>> On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia 
>>> wrote:
>>>
 Hi All,

 Just checking if others are observing something similar:
 * I was writing data to gpkg files from a postgis database.from the
 Database Manager. (e.g., select a layer from the PostGIS database and hit
 the "export to file" button at the top.
 * The resulting gpkg layer loses data in a column towards the left, but
 all of the headings are maintained. Thus, data are shifted to the left one
 column from a certain point on, and the last column has NULLs.

 If writing into an existing gpkg file, dragging and dropping the layer
 from the PostGIS db into the gpkg file and selecting appropriate options in
 the dialogue box that pops up does not have that issue.

 I'm still trying to see exactly what's going on, but figured I'd see if
 this is something others are experiencing (or if it's already been
 reported).

 Mike

 ___
>>> Qgis-user mailing list
>>> Qgis-user@lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Michael Treglia]

Just to clarify, if installing via OSGeo4w, use QGIS-Dev: QGIS Nightly
build of the development branch (3.3.0-88)?



On Fri, Oct 5, 2018 at 4:08 PM Luigi Pirelli  wrote:

> may you check with master? 3.2 is at end of life.
>
> tnx
>
> Luigi Pirelli
>
>
> **
> * LinkedIn: https://www.linkedin.com/in/luigipirelli
> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
> * GitHub: https://github.com/luipir
> * Mastering QGIS 2nd Edition:
> *
> https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
> * Hire me: http://goo.gl/BYRQKg
>
> **
>
>
> On Fri, 5 Oct 2018 at 21:59, Michael Treglia  wrote:
>
>> Whoops! Forgot the key information:
>> (Running on Windows 7 Pro x64)
>>
>> QGIS version
>>
>> 3.2.3-Bonn
>>
>> QGIS code revision
>>
>> 9b176802e5 
>>
>> Compiled against Qt
>>
>> 5.9.2
>>
>> Running against Qt
>>
>> 5.9.2
>>
>> Compiled against GDAL/OGR
>>
>> 2.2.4
>>
>> Running against GDAL/OGR
>>
>> 2.2.4
>>
>> Compiled against GEOS
>>
>> 3.6.1-CAPI-1.10.1
>>
>> Running against GEOS
>>
>> 3.6.1-CAPI-1.10.1 r0
>>
>> PostgreSQL Client Version
>>
>> 9.2.4
>>
>> SpatiaLite Version
>>
>> 4.3.0
>>
>> QWT Version
>>
>> 6.1.3
>>
>> QScintilla2 Version
>>
>> 2.10.1
>>
>> PROJ.4 Version
>>
>> 493
>>
>> On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia 
>> wrote:
>>
>>> Hi All,
>>>
>>> Just checking if others are observing something similar:
>>> * I was writing data to gpkg files from a postgis database.from the
>>> Database Manager. (e.g., select a layer from the PostGIS database and hit
>>> the "export to file" button at the top.
>>> * The resulting gpkg layer loses data in a column towards the left, but
>>> all of the headings are maintained. Thus, data are shifted to the left one
>>> column from a certain point on, and the last column has NULLs.
>>>
>>> If writing into an existing gpkg file, dragging and dropping the layer
>>> from the PostGIS db into the gpkg file and selecting appropriate options in
>>> the dialogue box that pops up does not have that issue.
>>>
>>> I'm still trying to see exactly what's going on, but figured I'd see if
>>> this is something others are experiencing (or if it's already been
>>> reported).
>>>
>>> Mike
>>>
>>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Luigi Pirelli]

may you check with master? 3.2 is at end of life.

tnx

Luigi Pirelli

**
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS 2nd Edition:
*
https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
* Hire me: http://goo.gl/BYRQKg
**


On Fri, 5 Oct 2018 at 21:59, Michael Treglia  wrote:

> Whoops! Forgot the key information:
> (Running on Windows 7 Pro x64)
>
> QGIS version
>
> 3.2.3-Bonn
>
> QGIS code revision
>
> 9b176802e5 
>
> Compiled against Qt
>
> 5.9.2
>
> Running against Qt
>
> 5.9.2
>
> Compiled against GDAL/OGR
>
> 2.2.4
>
> Running against GDAL/OGR
>
> 2.2.4
>
> Compiled against GEOS
>
> 3.6.1-CAPI-1.10.1
>
> Running against GEOS
>
> 3.6.1-CAPI-1.10.1 r0
>
> PostgreSQL Client Version
>
> 9.2.4
>
> SpatiaLite Version
>
> 4.3.0
>
> QWT Version
>
> 6.1.3
>
> QScintilla2 Version
>
> 2.10.1
>
> PROJ.4 Version
>
> 493
>
> On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia  wrote:
>
>> Hi All,
>>
>> Just checking if others are observing something similar:
>> * I was writing data to gpkg files from a postgis database.from the
>> Database Manager. (e.g., select a layer from the PostGIS database and hit
>> the "export to file" button at the top.
>> * The resulting gpkg layer loses data in a column towards the left, but
>> all of the headings are maintained. Thus, data are shifted to the left one
>> column from a certain point on, and the last column has NULLs.
>>
>> If writing into an existing gpkg file, dragging and dropping the layer
>> from the PostGIS db into the gpkg file and selecting appropriate options in
>> the dialogue box that pops up does not have that issue.
>>
>> I'm still trying to see exactly what's going on, but figured I'd see if
>> this is something others are experiencing (or if it's already been
>> reported).
>>
>> Mike
>>
>> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Michael Treglia]

As a quick follow-up - it seems like maybe the first numeric or integer
column gets assigned to an FID column, but the original column name stays
there with all values from other numeric/integer columns ending up
apparently shifted over to the left one, because there's an extra column.

On Fri, Oct 5, 2018 at 4:01 PM Michael Treglia  wrote:

> Whoops! Forgot the key information:
> (Running on Windows 7 Pro x64)
>
> QGIS version
>
> 3.2.3-Bonn
>
> QGIS code revision
>
> 9b176802e5 
>
> Compiled against Qt
>
> 5.9.2
>
> Running against Qt
>
> 5.9.2
>
> Compiled against GDAL/OGR
>
> 2.2.4
>
> Running against GDAL/OGR
>
> 2.2.4
>
> Compiled against GEOS
>
> 3.6.1-CAPI-1.10.1
>
> Running against GEOS
>
> 3.6.1-CAPI-1.10.1 r0
>
> PostgreSQL Client Version
>
> 9.2.4
>
> SpatiaLite Version
>
> 4.3.0
>
> QWT Version
>
> 6.1.3
>
> QScintilla2 Version
>
> 2.10.1
>
> PROJ.4 Version
>
> 493
>
> On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia  wrote:
>
>> Hi All,
>>
>> Just checking if others are observing something similar:
>> * I was writing data to gpkg files from a postgis database.from the
>> Database Manager. (e.g., select a layer from the PostGIS database and hit
>> the "export to file" button at the top.
>> * The resulting gpkg layer loses data in a column towards the left, but
>> all of the headings are maintained. Thus, data are shifted to the left one
>> column from a certain point on, and the last column has NULLs.
>>
>> If writing into an existing gpkg file, dragging and dropping the layer
>> from the PostGIS db into the gpkg file and selecting appropriate options in
>> the dialogue box that pops up does not have that issue.
>>
>> I'm still trying to see exactly what's going on, but figured I'd see if
>> this is something others are experiencing (or if it's already been
>> reported).
>>
>> Mike
>>
>>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Potential Bug in writing gpkg from database manager?

[Michael Treglia]

Whoops! Forgot the key information:
(Running on Windows 7 Pro x64)

QGIS version

3.2.3-Bonn

QGIS code revision

9b176802e5 

Compiled against Qt

5.9.2

Running against Qt

5.9.2

Compiled against GDAL/OGR

2.2.4

Running against GDAL/OGR

2.2.4

Compiled against GEOS

3.6.1-CAPI-1.10.1

Running against GEOS

3.6.1-CAPI-1.10.1 r0

PostgreSQL Client Version

9.2.4

SpatiaLite Version

4.3.0

QWT Version

6.1.3

QScintilla2 Version

2.10.1

PROJ.4 Version

493

On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia  wrote:

> Hi All,
>
> Just checking if others are observing something similar:
> * I was writing data to gpkg files from a postgis database.from the
> Database Manager. (e.g., select a layer from the PostGIS database and hit
> the "export to file" button at the top.
> * The resulting gpkg layer loses data in a column towards the left, but
> all of the headings are maintained. Thus, data are shifted to the left one
> column from a certain point on, and the last column has NULLs.
>
> If writing into an existing gpkg file, dragging and dropping the layer
> from the PostGIS db into the gpkg file and selecting appropriate options in
> the dialogue box that pops up does not have that issue.
>
> I'm still trying to see exactly what's going on, but figured I'd see if
> this is something others are experiencing (or if it's already been
> reported).
>
> Mike
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user