Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
MacFixer, the iPhone, iPod, and iPad specialists
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - POIedit - Why Longitude before Lattitude ?
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

POIedit - Why Longitude before Lattitude ?

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs)
View previous topic :: View next topic  
Author Message
dastardly
Occasional Visitor


Joined: Apr 11, 2004
Posts: 26
Location: Kent - UK

PostPosted: Thu Jun 10, 2004 7:00 pm    Post subject: POIedit - Why Longitude before Lattitude ? Reply with quote

Hi folks, maybe I'm coming at this from the wrong angle but things aren't quite as as easy as I hoped they'd be.... Rolling Eyes

1. I'm making several POI files by taking NGRs (converting them on 'Locations 1.12' on psion 5mx) and plotting them as Latt/Long on Fugawi UK to check that they are correct. I then ouput these waypoints as a txt file. Then I change the extension to asc.

2. When I open this file under POI Edit the columns are the wrong way round - ie, it shows Longitude before Lattitude, so....

3. I save it as an xml file, then open Excel and swap the two columns round. I save the file, BUT now when I try to open it under POI Edit it won't open. (Checking the original xml file, it opens fine under POI Edit)

So my questions to the panel are,
Does anyone know how to swop the columns easily in POI edit, or
Does anyone know what I'm doing wrong under excel.

(The tedious work-round on this is to edit the text file - But there are several hundred coordinates to do !! :x )

TIA
John
_________________
ipac 2210, Integral 128Mb, Haicom 303E CF (& TT wired), Fugawi, TT3 & POI Warner
Nuvi 610T on my motorbike
Tomtom 720 in my car
Back to top
View user's profile Send private message Visit poster's website
Oldie
Pocket GPS Moderator
Pocket GPS Moderator


Joined: 22/11/2002 13:33:48
Posts: 992
Location: Surrey, UK

PostPosted: Fri Jun 11, 2004 7:34 pm    Post subject: Reply with quote

The TomTom Navigator ASCII file data format is

Longitude, Latitude, "Name"

so that is why lots of programs that read data from text files put the entries that way round. I do the same in my programs.

What is the format of your basic data, before you starts swapping things around?
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Oldie
Pocket GPS Moderator
Pocket GPS Moderator


Joined: 22/11/2002 13:33:48
Posts: 992
Location: Surrey, UK

PostPosted: Sat Jun 12, 2004 6:36 am    Post subject: Reply with quote

If you create a text file (.ASC) with entries in the following format

NGR, "Description"

then you can use my program POIConverter to create a TomTom Navigator overlay. The latest version is in the Programs area on http://rjdavies.users.btopenworld.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
dastardly
Occasional Visitor


Joined: Apr 11, 2004
Posts: 26
Location: Kent - UK

PostPosted: Sat Jun 12, 2004 7:26 am    Post subject: Reply with quote

Oldie wrote:
If you create a text file (.ASC) with entries in the following format

NGR, "Description"

then you can use my program POIConverter to create a TomTom Navigator overlay.


OK thanks. Thumbs Up I'll do what you say with the NGR conversion on the next batch of coordinates.

Also I see that your lovely programme also handles .xls format, so I shall try doing that with the existing files and see if I can make it happen.

I'll let you know how I get on but right now I'm going to bed (just finished the night shift Zzzzzzzzz Crying )

Many thanks
John
_________________
ipac 2210, Integral 128Mb, Haicom 303E CF (& TT wired), Fugawi, TT3 & POI Warner
Nuvi 610T on my motorbike
Tomtom 720 in my car
Back to top
View user's profile Send private message Visit poster's website
dastardly
Occasional Visitor


Joined: Apr 11, 2004
Posts: 26
Location: Kent - UK

PostPosted: Mon Jun 14, 2004 8:52 am    Post subject: Reply with quote

Oldie wrote:
What is the format of your basic data, before you start swapping things around?


I exported the coordinates from Fugawi as a .txt file, and then changed the extension to .asc




However, I've got it sorted now Happy I did everything I described in top post but this time saved the POIedit output in .xls format, rather than .xml - and it all works beautifully.

Many thanks for your help,
John
_________________
ipac 2210, Integral 128Mb, Haicom 303E CF (& TT wired), Fugawi, TT3 & POI Warner
Nuvi 610T on my motorbike
Tomtom 720 in my car
Back to top
View user's profile Send private message Visit poster's website







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs) All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
22.034 (27 Mar 24)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







© Terms & Privacy


GPS Shopping