<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18854"></meta>
<meta name="SKYPE_FRAMEID" content="UKSDOXEVME"></meta>
<meta id="skype_v3_tb_marker_id" name="SKYPE_PARSING_HAS_FINISHED" content="metacontent"></meta>
</head>
<body>
<div align="left"><br />
Ok</div>
<div align="left"> </div>
<div align="left">I will try to give you as much information as possible.</div>
<div align="left">I run pgAdmin 1.10.1 installed with oneclick installer to postgresql 8.4.2</div>
<div align="left"> </div>
<div align="left">What I see now and I don't know the importance of is that I have 1.10.0 Beta2 installed too.</div>
<div align="left">I removed that directory and get the same result, but havene't restarted the box yet.</div>
<div align="left"> </div>
<div align="left">I downloaded the file </div>
<div align="left"><a href="http://www.postgis.org/download/windows/pg84/experimental/postgis/postgis-pg84-binaries-1.5svn.zip">http://www.postgis.org/download/windows/pg84/experimental/postgis/postgis-pg84-binaries-1.5svn.zip</a></div>
<div align="left"> </div>
<div align="left">copied the files to </div>
<div align="left">C:\Programfiler\PostgreSQL\8.4</div>
<div align="left">notice the norwegiean folder name "Programfiler" instead of "Program files"</div>
<div align="left"> </div>
<div align="left">I created a template database as described in readme with bat file.</div>
<div align="left"> </div>
<div align="left">then created a dataase named pg15 from that template</div>
<div align="left"> </div>
<div align="left">I edited pgbin-path under options to pgAdmin to point to this postgresql installation bin fiolder. Before it pointed to my home compiled installation.</div>
<div align="left"> </div>
<div align="left">Then I copied that lines into the ini-file as described in readme, and the plugin showed up as expected.</div>
<div align="left"> </div>
<div align="left">in pgAdmin I mark the new database and open the plugin</div>
<div align="left">All connection properties looks fine. </div>
<div align="left">I open file dialog and choose a file. ( I have tried more than the one attached but I send it anyway)</div>
<div align="left">change SRID to 32633</div>
<div align="left">when I run the import I get the earlier decribed error-message.</div>Connection: user=postgres password=postgres port=5433 host=localhost dbname=pg15<br />
Destination: public.vegen<br />
Source File: D:\Askprosjekt\test\vegen<br />
Shapefile type: Arc<br />
Postgis type: LINESTRING[2]<br />
Invalid SRID for geography type: 7f79<br />
Shapefile import failed.<br />
<div align="left"> </div>
<div align="left">It seems like it only wants geography.</div>
<div align="left"> </div>
<div align="left">I have removed the gid-field, that's why the new path to the file vegen.shp</div>
<div align="left"> </div>
<div align="left"> </div>
<div align="left">If I instead try running with SRID -1 I get the error Regina just posted a ticket about with the window exploding with the progressbar out to the right of the screen.</div>
<div align="left"> </div>
<div align="left">If I try another database on the same server, then I still got the same problem if I change the SRID but I get this message if I run with SRID -1 (the explosion is not happening)</div>
<div align="left"> </div>
<div align="left">Connection: user=postgres password=postgres port=5433 host=localhost dbname=pg14<br />
Destination: public.vegen<br />
Source File: D:\Askprosjekt\test\vegen<br />
Shapefile type: Arc<br />
Postgis type: LINESTRING[2]<br />
Failed SQL was: SET CLIENT_ENCODING TO UTF8;<br />
SET STANDARD_CONFORMING_STRINGS TO ON;<br />
BEGIN;<br />
CREATE TABLE "public"."vegen" (gid serial PRIMARY KEY,<br />
"start" int4,<br />
"stop" int4,<br />
"aske" int4,<br />
"the_geom" geography(LINESTRING,4326));</div>
<div align="left">Failed in pgui_exec(): ERROR: type "geography" does not exist<br />
LINE 8: "the_geom" geography(LINESTRING,4326));<br />
^</div>
<div align="left">Shapefile import failed.<br />
</div>
<div align="left"> </div>
<div align="left"> </div>
<div align="left">So I tried to change encoding under options</div>
<div align="left">I don't get this encoding things but I tried both UTF8 and win1252 and both tries crashed the plugin with a kindly asked messege of sending an error report to microsoft</div>
<div align="left"> </div>
<div align="left">I'll go sleeping for a couple of more hours</div>
<div align="left"> </div>
<div align="left">Hope this helps</div>
<div align="left"> </div>
<div align="left">Nicklas</div>
<div align="left"><br />
2009-12-25 Paul Ramsey wrote:<br />
<br />
Can you give us the file you used and an *exact* set of steps?<br />
>thanks,<br />
>P<br />
><br />
>On Thu, Dec 24, 2009 at 4:29 PM, Nicklas Avén<br />
>
<nicklas.aven@jordogskog.no></nicklas.aven@jordogskog.no> wrote:<br />
>> Hallo<br />
>><br />
>> I have not tried the shapeloader GUI before because of the compiling<br />
>> problems in windows.<br />
>> Now I tried it.<br />
>> It looks great, but I had some problems.<br />
>><br />
>> Just before I sent this I found that the result was very different when<br />
>> running as standalone see bottom of mail<br />
>><br />
>> 1) If I change SRID from -1 to 32633 I get following error:<br />
>> Connection: user=postgres password=postgres port=5433 host=localhost<br />
>> dbname=pg15<br />
>> Destination: public.vegen<br />
>> Source File: D:\Askprosjekt\vegen<br />
>> Shapefile type: Arc<br />
>> Postgis type: LINESTRING[2]<br />
>> Invalid SRID for geography type: 7f79<br />
>> Shapefile import failed.<br />
>> I have not asked for geography and not checked it or changed anything else<br />
>> under options.<br />
>> I see if I try SRID -1 too, that it asks for values in long lat range.<br />
>><br />
>> 2) If I get any error, for instance the above, when I open dialog for<br />
>> choosing shapefile it doesn't filter for shapefiles anymore and shows all<br />
>> files.<br />
>><br />
>> 3) If I try to load with srid -1 it totally flips. The progress bar seems to<br />
>> extend the window of the loader GUI out to the left as showed in attached<br />
>> picture.<br />
>><br />
>> 4) As seen on the picture there is also some error happening probably<br />
>> because the shapefile already contains a gid column.<br />
>><br />
>><br />
>> Environment is<br />
>> windows XP<br />
>> postgresql 8.4.2<br />
>> postgis is the experimental build from 23 dec<br />
>> ran loader GUI as plugin to pgAdmin. Getting connection properties<br />
>> automatically worked perfect :-)<br />
>><br />
>><br />
>><br />
>> When I tried as standalone it worked very good. The only thing that seems<br />
>> unstable in standalone is that when first file is loaded the shape file<br />
>> filter doesn't work when I open the file dialog for the next file.<br />
>><br />
>> I haven't done those tests very thoroughly so I can have missunderstood<br />
>> something, but this was what I got.<br />
>><br />
>> /Nicklas<br />
>><br />
>> _______________________________________________<br />
>> postgis-devel mailing list<br />
>> postgis-devel@postgis.refractions.net<br />
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel<br />
>><br />
>><br />
>_______________________________________________<br />
>postgis-devel mailing list<br />
>postgis-devel@postgis.refractions.net<br />
>http://postgis.refractions.net/mailman/listinfo/postgis-devel<br />
><br />
></div>
</body>
</html>