Opened 18 years ago

Closed 17 years ago

Last modified 15 years ago

#186 closed bug (fixed)

SPIT - Importing shape files always fails with some shapefiles

Reported by: michael.dearmas@… Owned by: g_j_m
Priority: major: does not work as expected Milestone:
Component: SPIT Version: 0.8
Keywords: Cc: lami@…, venturato@…
Must Fix for Release: No Platform: All
Platform Version: Awaiting user input: no

Description

I haven't been able to import Shape files not even once. I always get the error message:

Problem inserting features from file: <filename>

Attachments (4)

Accomodation.shp​ (1.2 KB ) - added by oyama.k@… 18 years ago.
Points of Attraction
Attraction.shp​ (1.5 KB ) - added by Oyz 18 years ago.
bad_vector.tar.gz​ (15.0 KB ) - added by cavallini@… 17 years ago.
vector not working with SPIT
good_vector.tar.gz​ (14.6 KB ) - added by cavallini@… 17 years ago.
vector working with SPIT

Download all attachments as: .zip

Change History (16)

comment:1 by g_j_m, 18 years ago

Does this still happen with the 0.8 preview release? If so, can you attach an example .shp file that you can't import?

comment:2 by g_j_m, 18 years ago

A duplicate ticket with some more details is #304

comment:3 by g_j_m, 18 years ago

I've added more information to the 'Problem inserting from file' message, so if you can try the latest version of qgis from svn and let us know what the error message is now, that'd help...

comment:4 by g_j_m, 18 years ago

It has been noted in the Qgis forum that some of the problems in using spit may be to do with postgis not being installed in the database. Qgis now checks for this when importing shapefiles.

by oyama.k@…, 18 years ago

Attachment: Accomodation.shp​ added

Points of Attraction

by Oyz, 18 years ago

Attachment: Attraction.shp​ added

comment:5 by anonymous, 18 years ago

Must Fix for Release: → No

Hey Guys

I have been importing shapefiles into PostGIS using ogr2ogr and shp2pgsql in past 6 months and i works well. Now I've been trying a user friendly way of importing a shapefile into PostGIS by using SPIT but it fails. I used Quantum 0.7.4 and 0.8.0 preview version but all I get is

Problem inserting feature from file: "shapefile path"

Can you guys help me pls

Thanks

Oyz

comment:6 by murray.richardson@…, 17 years ago

I have the same proble on Windows XP with QGIS version 0.7.4. I can load shapefiles into postgis using shp2psql and display them in qgis. The same shapefiles cannot be loaded using the SPIT plugin.

Has anyone resolved this issue?

Thanks

Murray

comment:7 by gsherman, 17 years ago

Milestone: → Version 0.8.1 Release
Version: 0.7 → 0.8

comment:8 by g_j_m, 17 years ago

The example files are missing the .shx and .dbf files. Please attache them too. Thanks.

comment:9 by cavallini@…, 17 years ago

Cc: lami@… venturato@… added
Platform: Windows → All
Platform Version: XP SP2
Summary: SPIT - Importing shape files always fails → SPIT - Importing shape files always fails with some shapefiles

In fact it fails with some shp, not with others. 2 samples attached. Apparently it depends on some values of the "cat" column missing from the dbf (they are shown as 0 in the good vector, as missing in the bad one)

by cavallini@…, 17 years ago

Attachment: bad_vector.tar.gz​ added

vector not working with SPIT

by cavallini@…, 17 years ago

Attachment: good_vector.tar.gz​ added

vector working with SPIT

comment:10 by g_j_m, 17 years ago

Owner: changed from gsherman to g_j_m

comment:11 by anonymous, 17 years ago

Resolution: → fixed
Status: new → closed

Fixed in Release 0.8 branch (r6391) and in head (r6392).

comment:12 by (none), 15 years ago

Milestone: Version 0.8.1

Milestone Version 0.8.1 deleted

Note: See TracTickets for help on using tickets.