Feature request #4778

Import of multiple shapefiles in PostGIS

Added by Paolo Cavallini about 8 years ago. Updated over 4 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:14633

Description

See SPIT

History

#1 Updated by Paolo Cavallini about 8 years ago

Already possible, by dragging & dropping multiple files, and also from file system. Only limitation: from file system all files should be in the same folder. Close it?

#2 Updated by Giovanni Manghi about 7 years ago

  • Project changed from 27 to QGIS Application

#3 Updated by Giovanni Manghi about 7 years ago

  • Category set to DB Manager

#4 Updated by Giovanni Manghi about 7 years ago

  • Assignee deleted (Giuseppe Sucameli)

#5 Updated by Giovanni Manghi almost 7 years ago

Paolo Cavallini wrote:

Already possible, by dragging & dropping multiple files, and also from file system. Only limitation: from file system all files should be in the same folder. Close it?

there are limitations when compared to SPIT:

it does not allow to choose shapes from different folders

for each dropped shapefile it asks the import parameters, while with SPIT the parameters are all defined before starting update, making it the only real way to import more than a hand full of vectors

the import operation in DB Manager is very slow when compared to d&d in QGIS browser and SPIT

#6 Updated by Paolo Cavallini almost 6 years ago

  • Subject changed from Import of multiple shapefiles to Import of multiple shapefiles in PostGIS

#7 Updated by Paul Kanelli almost 5 years ago

When creating a table using the "DB Manager" the "Create table" window stays open after finishing. That's quite usefull when creating more than one table. Using the "Import layer/file" tool to import a shapefile the "Import vector layer" window is closing and all settings get lost after the import. So adding several shapefiles sharing similar settings is really a pain.

#8 Updated by Giovanni Manghi almost 5 years ago

Paul Kanelli wrote:

When creating a table using the "DB Manager" the "Create table" window stays open after finishing. That's quite usefull when creating more than one table. Using the "Import layer/file" tool to import a shapefile the "Import vector layer" window is closing and all settings get lost after the import. So adding several shapefiles sharing similar settings is really a pain

There are alternatives in the Processing toolbox where any tool can be run in batch mode. There you you will find an ogr based tool that is several times faster than db manager.

#9 Updated by Jürgen Fischer almost 5 years ago

Giovanni Manghi wrote:

There are alternatives in the Processing toolbox where any tool can be run in batch mode. There you you will find an ogr based tool that is several times faster than db manager.

And there is SPIT.

#10 Updated by Paul Kanelli over 4 years ago

SPIT doesn't create spatial indices and 'geom' is the last column of all. I prefer 'geom' at the second position after 'gid'. The QGIS-Geo-Algorithm 'Import into PostGIS' doesn't support sequences for the primary key columns.

#11 Updated by Médéric RIBREUX over 4 years ago

  • Status changed from Open to Feedback

Hello, bug triage...

now "that SPIT has been removed":#b39e6d176000fea3d5eaf6cc0b8f7b0f9c5df3dd, how do we do to import multiple shapefiles into PostGIS ?

#12 Updated by Paolo Cavallini over 4 years ago

  • Resolution set to fixed/implemented
  • Status changed from Feedback to Closed

With Processing

Also available in: Atom PDF