Creating a New POI - 100 Mile SC BBQ
 16 years
|
Ok. The SC BBQ Association has a listing of 24 BBQ establishments that they rate as worth driving/riding 100 miles to get to. So I'm trying to make a POI with them listed. Using Excel and saving as a CVS file
1.Column A put in Longitude.
2.Column B put in Latitude.
3.Column C put in Name.
4.Column D put in address,city,state (abbreviation),zip code and Phone Number. Put commas in per this example.770 Schillinger Rd,Mobile,AL 36695,251-634099
This is an actual example from the file.
-81.3113098 33.9795113 Belly's Southern Pride Bar-B-Q 2508 Augusta Hwy, Lexington, SC 29072, 803-3568284
When I load it on my GPS (Zumo 660) as a CVS I get the location but no address. When I select one it gives me no address but weird thing with proximity and 105 mile speed. It will route to it just fine.
I'm stumped. Thanks in advance for any help.
explain
What do you mean "Location, but no address"?
If you are talking about displaying the list of locations on your GPS when looking a custom poi, all you will see is the name. To get addresses to show ont the list, you need a GPX file.
A CSV (not CVS) file has 3 defined columns, Lon, Lat, POI Name - and that's it. The 4th column where you list the address is an OPTIONAL description field that can contain amost anything.
Illiterate? Write for free help.
Use quotes, and comma delimited, not tabs
The below will work:
-81.3113098,33.9795113,"Belly's Southern Pride Bar-B-Q","2508 Augusta Hwy, Lexington, SC 29072, 803-3568284"
Also, your file is tab delimited. There are no commas between Lat and Lon, etc.
Striving to make the NYC Metro area project the best.
That was just a copy and
That was just a copy and paste from Excel so no commas between fields.
I'll convert to a GPX file and see if it works.
Thanks
In order to see exactly what's wrong...
...we'll need to see the exact contents of the .csv file.
Striving to make the NYC Metro area project the best.
I converted it to a GPX file
I converted it to a GPX file and now have the addresses. When I open one to route to I get a proximity of 1 mile and a speed of 100 MPH which I'd rather not have.
Is there a place where I can upload the comma delimited file?
Whatb did you name the file?
I converted it to a GPX file and now have the addresses. When I open one to route to I get a proximity of 1 mile and a speed of 100 MPH which I'd rather not have.
Is there a place where I can upload the comma delimited file?
If you have a number in the name you will get speed alerts.
Nuvi 2460LMT.
Where are you creating the .gpx file from
Excel? If so, I would scrap that and load in a program that's specific to .gpx files. Many of us here use Extra POI Editor, written by TurboCCC, another member on this forum. Below is the link:
http://turboccc.wikispaces.com/Extra_POI_Editor
It makes POI creation a breeze.
Striving to make the NYC Metro area project the best.
Yup
I converted it to a GPX file and now have the addresses. When I open one to route to I get a proximity of 1 mile and a speed of 100 MPH which I'd rather not have.
Is there a place where I can upload the comma delimited file?
If you have a number in the name you will get speed alerts.
Yup, change the POI filename from 100*********** to something like OneHundred*********** and the 100 mph alert will go away.
.
I converted it to a GPX file and now have the addresses. When I open one to route to I get a proximity of 1 mile and a speed of 100 MPH which I'd rather not have.
Is there a place where I can upload the comma delimited file?
Welcome to the club of those of us who have been "bit" by the "number" demon.
You must be very careful of using a "number" in the name of a POI file. It means something to POI Loader.
So that others reading this thread may learn, here are some pages from POI Loader help.
Creating Custom POI Files
Advanced users can create their own .csv and .gpx data files that include Custom POI lists or TourGuide files.
POI Loader loads all .csv and .gpx data files saved in a particular directory. When creating or downloading Custom POI data files, it is recommended that you save all the data files you want to upload to your device in the same directory.
POI Loader determines whether or not a file contains speed and proximity alert points based on specific criteria. Use the following information to help you create Custom POI files:
If a file name contains a valid speed number or if all records in a file have speed encoded in the name, then all records in the file will include speed and proximity alerts. For example, a data file with the file name "Speed_30" generates speed alerts of 30 mph (or kph, depending on the type of units selected in POI Loader) for each POI in the file.
If the file name contains "redlight", POI Loader assumes all records in the file have proximity alerts with a distance of 400m/0.25 miles.
If a file contains "GATSO," "mobile," "SPECS," "safety," "speed," or "camera," but does not have a speed, POI Loader uses a default alert speed of 0, which means you will always be alerted. You can override this default value by entering the speed in Manual mode.
You can also enter speeds for each POI individually by adding the @ symbol and a number after the name of the POI. For example, a Custom POI named "Ridgeview@25" would create a POI named "Ridgeview" with a 25 mph speed alert.
POI Loader calculates proximity alert distance based on speed. You can enter proximity alert distance for individual Custom POIs in a .gpx file. You can also enter proximity alert distance for all Custom POIs in a data file using Manual mode.
Speed Information
Speed information can be included in the file name or in the names of individual POIs within the file.
POI Loader determines speed information based on the following information, listed from highest to lowest priority:
Speed information included in the name of the individual Custom POI. For example, a POI named "SpeedZone@30" will have an alert speed of 30 regardless of the speed information specified in Manual mode or in the file name.
Speed information entered in Manual mode.
Speed information included in the file name. POI Loader interprets any numbers in the file name as speed information.
"Valid" numbers are up to 124 if using US conventions (feet, MPH) and up to 199 if using metric conventions.
That's it. The file name is
That's it. The file name is "100 Mile SC BBQ"
I'll fix it and reset up my POIs. Thanks everyone for the help.