GPSVisualiser Format
Fri, 06/22/2007 - 1:08pm
 |
 18 years
|
On a lark, I created my first POI file a couple of days ago - JoAnn Fabric Stores in Oregon - for my wife. I used GPSVisualizer to send the addresses to Yahoo, and used the output as the starting point for the POI file. The first time I fed the data into POILoader, though, I discovered that the Long/Lat values were reversed. Thus began a tedious cut/paste session.
There were several other cut/paste sessions that followed, but those were more for me than out of necessity.
Am I missing something?
b_f
.
Am I missing something?
Nope. Not missing a thing - you're doing what we've all done...but using Excel, swapping columns in the spreadsheet is easy for me...
*Keith* MacBook Pro *wifi iPad(2012) w/BadElf GPS & iPhone6 + Navigon*
Line Breaks Make it Tough
OK, glad I wasn't missing something obvious.
Swapping columns in Excel is easy, but a CSV file with line breaks (address formatting, phone numbers, hours of operation, etc.) doesn't lend itself to that type of manipulation.
Skip nuvi 660
Swapping columns in csv with line breaks
I've done it.
First, you take the output of the geocoder, and paste it into a spreadsheet - swap the columns, then, insert a new column after the 'Name' field, wich will be the 'description' field for the Garmin csv format - and in this column, you can use a concatenate function to combine remaining adress, city, state, and phone numbers from the other columns...and with the concatenate function, you can insert line breaks where needed.
*Keith* MacBook Pro *wifi iPad(2012) w/BadElf GPS & iPhone6 + Navigon*