Is anyone creating a "Old Navy" Poi for the US. I started getting the locations, so far I am A - C on states.
I don't have excel, (I'm a very simple person) but I have notepad. Before I go too far I wanted to know is anyone doing one?
Since nobody responded, I'll keep going. So far I have locations for Alabama thru New Jersey. Since I don't have excel, I'll be using notepad. So it will probably take me some time to figure out how to get it in csv format. (And, Yes I have read the FAQ's & did searches) but without a written example that pertains to my exact poi, it makes no sense.
Everyone have a great week!
DC, to change a Notepad file (with its .txt suffix) to an Excel file (with its .csv suffix) couldn't be easier. Just rename it. Yup, rename it. If the file's name now is oldnavy.txt, just rename it to oldnavy.csv and viola! it's an Excel file.
Since I don't have excel, I'll be using notepad. So it will probably take me some time to figure out how to get it in csv format. But without a written example that pertains to my exact poi, it makes no sense.
In other words:
I put this address in gpsverifier.com:
COLONIAL PROMENADE, 300 Colonial Promenade Parkway,ALABASTER, AL 35007 205-620-1730
It came back as:
33.230583,-86.80304,"COLONIAL PROMENADE, 300 Colonial Promenade Parkway,ALABASTER, AL 35007 205- 620-1730",-,
Is that the correct format? I already have the file as csv format. Do I need to add any quotes or take away any spaces?
I want it to read on my nuvi:
300 Colomial Promenade Parkway
Alabaster, Al 35007
Or is that too much info for such a little space
You need to have the longitude first and the latitude second, so change the position of those in your data.
Then separate the name "Colonial Promenade" from the address. And then get rid of the "-" in the last column so you end up with four distinct sets of data separated by commas.
And don't put the name in all caps unless that's how you want it to show up on your GPS unit.
-86.80304,33.230583,"Colonial Promenade","300 Colonial Promenade Parkway,Alabaster, AL 35007 205-620-1730"
Didn't think note pad could do it, But with the advice of simply changing it to .CSV works well and couldn't be easier,
Thanks for the info
terms | privacy | contactCopyright © 2006-2020