Re: [Qgis-user] Problem Importing Shapefile to PostgreSQL

2007-04-15 Thread Jack Morris

Martin,

I have solved the problem!

First, I tried importing the majrivers shape file from the 
"qgis_sample_data" folder and that worked fine. I noted that all the 
file names in that folder are lower case and with no spaces. I, on the 
other hand, have picked up (from windoze, no doubt) the habit of using 
"plain english" file names, ie, Caps as appropriate and spaces within 
multi-word names. I went back and changed all my file names to single, 
lower case names and now they import just fine. Apparently, either the 
Import Tool or PostgreSQL does not like "plain english" names. 
Apparently SQL does not allow white space within object names unless the 
name is quoted. I need to remember this in the future!


I will still enter a ticket about improving error reporting in the 
Import Tool :-) .


Jack



Martin Dobias wrote:

Hi,

please report your problem to our bug tracking system and attach (or
link) also the shapefile you're trying to import.
https://svn.qgis.org/trac

Btw. yes, error reporting in the import tool is poor, that might be
another ticket :)

Martin

On 4/14/07, Jack Morris <[EMAIL PROTECTED]> wrote:

I am having problems importing shape files from QGIS to PostgreSQL using
the Import Tool.

I am using Ubuntu Edgy, PostgreSQL 8.1.4.

I have successfully, I think, installed PostGIS and can see, using
pgAdmin III, that I have added to my database: 14 Casts, and under
Schemas>public: 9 Aggregates, 328 Functions, 17 Operators, 2 Tables
(geometry_columns and spatial_ref_sys) and 7 Types. I can successfully
connect to my database from the Import Tool as "postgres", but when I
try to import a shape file I get:

"Problem inserting features from file: (path to shape file)"

No other explanation!!!

Jack
___
Qgis-user mailing list
Qgis-user@lists.qgis.org
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user





___
Qgis-user mailing list
Qgis-user@lists.qgis.org
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user


[Qgis-user] Re: Qgis-user Digest, Vol 14, Issue 9

2007-04-15 Thread serhad akkoc

On 4/15/07, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:


Send Qgis-user mailing list submissions to
   [EMAIL PROTECTED]

To subscribe or unsubscribe via the World Wide Web, visit
   http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
or, via email, send a message with subject or body 'help' to
   [EMAIL PROTECTED]

You can reach the person managing the list at
   [EMAIL PROTECTED]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Qgis-user digest..."


Today's Topics:

  1. Problem Importing Shapefile to PostgreSQL (Jack Morris)
  2. Re: Problem Importing Shapefile to PostgreSQL (Jack Morris)
  3. Re: Problem Importing Shapefile to PostgreSQL (Martin Dobias)


--

Message: 1
Date: Sat, 14 Apr 2007 10:15:32 -0500
From: Jack Morris <[EMAIL PROTECTED]>
Subject: [Qgis-user] Problem Importing Shapefile to PostgreSQL
To: [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I am having problems importing shape files from QGIS to PostgreSQL using
the Import Tool.

I am using Ubuntu Edgy, PostgreSQL 8.1.4.

I have successfully, I think, installed PostGIS and can see, using
pgAdmin III, that I have added to my database: 14 Casts, and under
Schemas>public: 9 Aggregates, 328 Functions, 17 Operators, 2 Tables
(geometry_columns and spatial_ref_sys) and 7 Types. I can successfully
connect to my database from the Import Tool as "postgres", but when I
try to import a shape file I get:

"Problem inserting features from file: (path to shape file)"

No other explanation!!!

Jack


--

Message: 2
Date: Sat, 14 Apr 2007 11:27:55 -0500
From: Jack Morris <[EMAIL PROTECTED]>
Subject: Re: [Qgis-user] Problem Importing Shapefile to PostgreSQL
To: [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Corrections/additions to my first post:

qgis version is 0.8.0
PostgreSQL version is 8.1.8
PostGIS is 1.1.2
Additional Items added to "database">schemas>public: one Trigger
Function [cache_bbox()] and two Operator Classes ("btree_geometry_ops"
and "gist_geometry_ops")

Jack



--

Message: 3
Date: Sun, 15 Apr 2007 12:18:25 +0200
From: "Martin Dobias" <[EMAIL PROTECTED]>
Subject: Re: [Qgis-user] Problem Importing Shapefile to PostgreSQL
To: "Jack Morris" <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Message-ID:
   <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi,

please report your problem to our bug tracking system and attach (or
link) also the shapefile you're trying to import.
https://svn.qgis.org/trac

Btw. yes, error reporting in the import tool is poor, that might be
another ticket :)

Martin

On 4/14/07, Jack Morris <[EMAIL PROTECTED]> wrote:
> I am having problems importing shape files from QGIS to PostgreSQL using
> the Import Tool.
>
> I am using Ubuntu Edgy, PostgreSQL 8.1.4.
>
> I have successfully, I think, installed PostGIS and can see, using
> pgAdmin III, that I have added to my database: 14 Casts, and under
> Schemas>public: 9 Aggregates, 328 Functions, 17 Operators, 2 Tables
> (geometry_columns and spatial_ref_sys) and 7 Types. I can successfully
> connect to my database from the Import Tool as "postgres", but when I
> try to import a shape file I get:
>
> "Problem inserting features from file: (path to shape file)"
>
> No other explanation!!!
>
> Jack
> ___
> Qgis-user mailing list
> [EMAIL PROTECTED]
> http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
>


--

___
Qgis-user mailing list
[EMAIL PROTECTED]
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user


End of Qgis-user Digest, Vol 14, Issue 9


___
Qgis-user mailing list
[EMAIL PROTECTED]
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user


Re: [Qgis-user] Problem Importing Shapefile to PostgreSQL

2007-04-15 Thread Martin Dobias

Hi,

please report your problem to our bug tracking system and attach (or
link) also the shapefile you're trying to import.
https://svn.qgis.org/trac

Btw. yes, error reporting in the import tool is poor, that might be
another ticket :)

Martin

On 4/14/07, Jack Morris <[EMAIL PROTECTED]> wrote:

I am having problems importing shape files from QGIS to PostgreSQL using
the Import Tool.

I am using Ubuntu Edgy, PostgreSQL 8.1.4.

I have successfully, I think, installed PostGIS and can see, using
pgAdmin III, that I have added to my database: 14 Casts, and under
Schemas>public: 9 Aggregates, 328 Functions, 17 Operators, 2 Tables
(geometry_columns and spatial_ref_sys) and 7 Types. I can successfully
connect to my database from the Import Tool as "postgres", but when I
try to import a shape file I get:

"Problem inserting features from file: (path to shape file)"

No other explanation!!!

Jack
___
Qgis-user mailing list
[EMAIL PROTECTED]
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user


___
Qgis-user mailing list
[EMAIL PROTECTED]
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user