Issues when running "Import into PostGIS" in batch mode

[qgib]

Author Name: Giovanni Manghi (@gioman)
Original Redmine Issue: 15097
Affected QGIS version: master
Redmine category:processing/qgis
Assignee: Victor Olaya

---

• when selecting layers from filesystem and the table name is left blank, to leave the tool use the input vector as name, then the absolute path of the input vector is used as table name
• "table to import parameter" is filled with "none" when the tool is opened, and there is the suggestion to leave it blank to use the layer name. But then if the user leave "none" this word is used as table name.
• "none" is used also as default for the "primary key field", if the user leave it then "none" is used as name for the PK column
• compared to the tool in DB Manager it seems to miss the source/destination CRS parameters

---

• 15097.mp4 (Reinhard Reiterer)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

the "none" issues are a regression since 2.8.*

---

• priority_id was changed from Normal to Severe/Regression
• fixed_version_id was changed from Future Release - High Priority to Version 2.16

[qgib]

Author Name: Reinhard Reiterer (Reinhard Reiterer)

---

To me, this is a really important issue. I've uploaded a screencast for documentation purposes.

---

• 10338 was configured as 15097.mp4

---

• 15097.mp4 (Reinhard Reiterer) - screencast

[qgib]

Author Name: Victor Olaya (@volaya)

---

These should be fixed already.

The only thing not fixed is your last suggestion about the dest crs, since that is a feature request. Also it would change the syntax of the algorithm, so it cannot be added to this next release. We should wait until 3.0

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Hi Victor, thanks for the fixes. I see still two issues:

1. when the table name is left blank, once imported the table in Postgis has also the ".shp" in its name. I think is necessary to strip the extensions from inputs names.

2. if the field for primary key is left blank the tool gives an error

Error importing to PostGIS Creation of data source "public"."aaa" failed: ERROR: syntax error at or near "," LINE 1: CREATE TABLE "public"."aaa"(, PRIMARY KEY () ) ^

I would suggest to fill this field out of the box with a default like "gid" or just "id".

[qgib]

Author Name: Victor Olaya (@volaya)

---

Fixed in changeset "e58177cf9e360021618d6029821cbc8416496cff".

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

the latest build of master on osgeo4w is 979d619 that does not contain the latest commits, among the others the latest patch for this ticket. So I applied the patch manually but at that point the tool returns "Error importing to PostGIS Creation of data source "schema_name"."" failed: ERROR: zero-length delimited identifier at or near """" LINE 1: CREATE TABLE "schema_name".""(gid serial, PRIMARY KEY (gid) ) ^" but I soon realized that this error is also shown without the patch. At this point from "master_2" I downloaded the whole Processing folder and placed in plugins folder in .qgis2: no more error but also "missing parameter value: Table to import..." when leaving the table name blank. The "primary key field" seems fixed.

---

• status_id was changed from Closed to Reopened

[qgib]

Author Name: Victor Olaya (@volaya)

---

Fixed in changeset "e55d1923fc08900864f7ef02866cca0a2e11cc15".

---

• status_id was changed from Reopened to Closed

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

@volaya @alexbruy
tested the latest master_2

"missing parameter value: Table to import..."
when leaving the table name blank (both batch and normal use)

---

• status_id was changed from Closed to Reopened
• fixed_version_id was changed from Version 2.16 to Version 2.18

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Fixed in changeset "271e67e37b781260d889778e97064efae72a0b15".

---

• status_id was changed from Reopened to Closed