[Loadstone] Loadstone Digest, Vol 46, Issue 7

Shawn Kirkpatrick shawn at loadstone-gps.com
Fri Apr 9 00:25:30 BST 2010


I'm still not sure what you mean by an ansi format file. Ansi can refer to 
many things, a terminal type, key codes, and probably other things. Do you 
mean unicode as the character set? If the file was for new zealand then I 
doubt it would have any special characters in it and probably doesn't need 
converting. This of course would depend on what generated the file.
The upload error is an easy one, the userid of the points in the file 
doesn't match your userid. This will result in the error you're getting.

On Fri, 9 Apr 2010, Kennydog wrote:

> Hi,
> 
> The reason I asked about ANSI was that I had a large 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. 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".]
> I am able to navigate with the points, but wondered why I am not able to
> upload them if I have added some more points to that file. If I do it in
> the database I created myself, then I can update it and upload it with no
> worries.
> 
> Thanks for any help with this!
> 
> 
> 
> On 8/04/2010 11:00 p.m., loadstone-request at loadstone-gps.com wrote:
>
>  Send Loadstone mailing list submissions to
> 	loadstone at loadstone-gps.com
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://www.loadstone-gps.com/mailman/listinfo/loadstone
> or, via email, send a message with subject or body 'help' to
> 	loadstone-request at loadstone-gps.com
> 
> You can reach the person managing the list at
> 	loadstone-owner at loadstone-gps.com
> 
> 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 <hurrikenny at slingshot.co.nz>
> To: loadstone at loadstone-gps.com
> Subject: [Loadstone] Converter question
> Message-ID: <4BBD8778.8040509 at slingshot.co.nz>
> Content-Type: text/plain; charset="us-ascii"
> 
> An HTML attachment was scrubbed...
> URL: <http://www.loadstone-gps.com/pipermail/loadstone/attachments/20100408/a4dd9072/attachment-0001.html>
> 
> ------------------------------
> 
> Message: 2
> Date: Thu, 8 Apr 2010 01:17:07 -0700 (PDT)
> From: Shawn Kirkpatrick <shawn at loadstone-gps.com>
> To: loadstone at loadstone-gps.com
> Subject: Re: [Loadstone] Converter question
> Message-ID: <Pine.LNX.4.64.1004080116170.29848 at odyssey.shawnk.ca>
> 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:
>
> 
>
>  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
> 
> 
>
> 
>
>  ------------------------------
> 
> _______________________________________________
> Loadstone mailing list
> Loadstone at loadstone-gps.com
> http://www.loadstone-gps.com/mailman/listinfo/loadstone
> 
> 
> End of Loadstone Digest, Vol 46, Issue 7
> ****************************************
>
>  No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 9.0.801 / Virus Database: 271.1.1/2797 - Release Date: 04/08/10 06:32:00
>
> 
> 
> 
>


More information about the Loadstone mailing list