<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="+2">Hi,<br>
<br>
The reason I asked about ANSI was that I had a large </font><big><big>list
of points (in ANSI format) for various parts of New Zealand. After I
had changed the ANSI file into UTF-8 format, and moved it onto my
phone, I was able to use those points. If I then bookmarked (while in
that same database) it would recognise it. Then however, if I wanted to
upload my points for that day, to the pointshare exchange, I could not
upload my points. It said something about a DB Error: constraint
violation. </big></big>insert into point
(name,latlong,accuracy,satellites,priority,id,userid)
values('TUKAPA ST,COWLING RD',SetSRID(GeomFromText('POINT(174.0534781
-39.0881484)'), 4326),'2','0','2','898277685','838') [nativecode=ERROR:
insert or update on table "point" violates foreign key constraint
"userid_fkey"
DETAIL: Key (userid)=(838) is not present in table "webauth_users".]<br>
<big><big>I am able to navigate with the points,<big> </big>but
wondered why I am not able to upload them if I have added some more
points to that file</big>.</big> <big><big>If I do it in the database
I created myself, then I can update it and upload it with no worries. </big></big><br>
<br>
<big><big>Thanks for any help with this!<br>
<br>
</big></big><br>
<br>
On 8/04/2010 11:00 p.m., <a class="moz-txt-link-abbreviated" href="mailto:loadstone-request@loadstone-gps.com">loadstone-request@loadstone-gps.com</a> wrote:
<blockquote
 cite="mid:mailman.5.1270724401.23062.loadstone@loadstone-gps.com"
 type="cite">
  <pre wrap="">Send Loadstone mailing list submissions to
        <a class="moz-txt-link-abbreviated" href="mailto:loadstone@loadstone-gps.com">loadstone@loadstone-gps.com</a>

To subscribe or unsubscribe via the World Wide Web, visit
        <a class="moz-txt-link-freetext" href="http://www.loadstone-gps.com/mailman/listinfo/loadstone">http://www.loadstone-gps.com/mailman/listinfo/loadstone</a>
or, via email, send a message with subject or body 'help' to
        <a class="moz-txt-link-abbreviated" href="mailto:loadstone-request@loadstone-gps.com">loadstone-request@loadstone-gps.com</a>

You can reach the person managing the list at
        <a class="moz-txt-link-abbreviated" href="mailto:loadstone-owner@loadstone-gps.com">loadstone-owner@loadstone-gps.com</a>

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


Today's Topics:

   1.  Converter question (Kennydog)
   2. Re:  Converter question (Shawn Kirkpatrick)


----------------------------------------------------------------------

Message: 1
Date: Thu, 08 Apr 2010 19:36:24 +1200
From: Kennydog <a class="moz-txt-link-rfc2396E" href="mailto:hurrikenny@slingshot.co.nz">&lt;hurrikenny@slingshot.co.nz&gt;</a>
To: <a class="moz-txt-link-abbreviated" href="mailto:loadstone@loadstone-gps.com">loadstone@loadstone-gps.com</a>
Subject: [Loadstone] Converter question
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:4BBD8778.8040509@slingshot.co.nz">&lt;4BBD8778.8040509@slingshot.co.nz&gt;</a>
Content-Type: text/plain; charset="us-ascii"

An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://www.loadstone-gps.com/pipermail/loadstone/attachments/20100408/a4dd9072/attachment-0001.html">&lt;http://www.loadstone-gps.com/pipermail/loadstone/attachments/20100408/a4dd9072/attachment-0001.html&gt;</a>

------------------------------

Message: 2
Date: Thu, 8 Apr 2010 01:17:07 -0700 (PDT)
From: Shawn Kirkpatrick <a class="moz-txt-link-rfc2396E" href="mailto:shawn@loadstone-gps.com">&lt;shawn@loadstone-gps.com&gt;</a>
To: <a class="moz-txt-link-abbreviated" href="mailto:loadstone@loadstone-gps.com">loadstone@loadstone-gps.com</a>
Subject: Re: [Loadstone] Converter question
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:Pine.LNX.4.64.1004080116170.29848@odyssey.shawnk.ca">&lt;Pine.LNX.4.64.1004080116170.29848@odyssey.shawnk.ca&gt;</a>
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

Ansi? That's a standard that can apply to a lot of different things. Can you 
be a lot more specific? What kind of file format are you thinking of?

On Thu, 8 Apr 2010, Kennydog wrote:

  </pre>
  <blockquote type="cite">
    <pre wrap="">Hi,

Do you know of, (or can you create) an ANSI to loadstone converter?
Also, can it be like the osm to loadstone one (where it can convert the
initial user id to your own user id)? so you can download it and
re-upload it, (in case you come across some more points in that format).
Eg UTF-8  is what I normally use, but if I say came across a ansi file
and want to do the same thing so it can be used, and added to by others
in Loadstone.

Thanks



    </pre>
  </blockquote>
  <pre wrap="">

------------------------------

_______________________________________________
Loadstone mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Loadstone@loadstone-gps.com">Loadstone@loadstone-gps.com</a>
<a class="moz-txt-link-freetext" href="http://www.loadstone-gps.com/mailman/listinfo/loadstone">http://www.loadstone-gps.com/mailman/listinfo/loadstone</a>


End of Loadstone Digest, Vol 46, Issue 7
****************************************</pre>
  <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>

No virus found in this incoming message.
Checked by AVG - <a class="moz-txt-link-abbreviated" href="http://www.avg.com">www.avg.com</a> 
Version: 9.0.801 / Virus Database: 271.1.1/2797 - Release Date: 04/08/10 06:32:00

  </pre>
</blockquote>
</body>
</html>