search

gacarrillor / AppendFeaturesToLayer

QGIS Processing plugin to add an algorithm for upserting features from a source vector layer to an existing target vector layer.
23 stars 4 forks source link

Conversion between a String attribute of a Geopackage and a JSON field of PostgreSQL #24

Open NicolaPx opened 9 months ago

NicolaPx commented 9 months ago

I tried to add some features from a geopackage into a PostGIS layer. A txt field formatted as a json field is not imported in the PostGIS json field. If we tried to import using the copy and past function in Qgis, the import correctly works.

gacarrillor commented 9 months ago

Thanks for the report, we'll have a look at it.

gacarrillor commented 9 months ago

I gave this a try. It's true that the plugin does not transfer a String field value into a JSON field. However, that's also the case with the QGIS Copy&Paste functionality (at least from GPKG to GPKG layers).

Screen-cast on QGIS master (v.3.35):

string_to_json

Please let me know which QGIS version are you using and upload a screen-cast/screenshot or some sample data.

gacarrillor commented 9 months ago

I've added some tests for both QGIS 3.28.x and 3.34.x, which are current and next LTRs. (See #25 and #27)

Summary: