QGIS » QGIS Application

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?

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

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.

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.

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.

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.