Regarding poi verifier??

It sounds like you're talking about POI Verifier. What it indicates is you probably have the longitude and latitude reversed for Garmin's Custom POI format. It should look similar to this:
-96.731369,32.960720,Name,Description

Make sure you have the longitude first. POI Verifier has an option to swap longitude and latitude; so if this is your problem, just check this option and the coordinates should be arranged correctly.

Check the info available at http://www.PoiVerifier.com

If you're still having problems, send me a copy of your POI file and I'll help you with it.

RT

yes sir, i meant poi verifier... i'm very novice with this but i believe i had longitude first? I'll double check when I get home tomorrow night after work. It sounds like that is likely the case though doesn't it (reversed).

I'll let you know... Thanks for the help...

Kerry in Dallas

Don't forget to use the negative sign with the number on the longitude or you will get that problem.

Ray

That's true as far as the longitude is concerned; but the latitude for every entry is also incorrect (unless the negative sign is entered on the latitude instead of the longitude). This would indicate coordinates swapped, or possibly not using the decimal format for the coordinates. And then there is also the possibility of totally incorrect coordinates. The example I gave has coordinates for Richardson, TX; so they should be able to check theirs against it. Watching the negative sign is a good point, raybonz. It will be interesting to see what is found.

RT

I had forgotten to use the longitude, latitude, name, info format... my bad...

Actually, I'm using poi harvester to harvest and output all "finds" into a .csv file on my desktop within a 30 mile radius of my home. For instance I made a file called "bodyshops" because I'm in the wrecker business and searched and retrieved all bodyshops in the 30 mile radius. The problem is that it generates soooooooo many duplicates that it's overwhelming to have to go back in manually and remove them line by line after using poi verifier.

The "bodyshops" file is about 1100 lines long, is there a way to automatically delete duplicates? or 1 of the 2 duplicates?

Thanks,
Kerry

If you put the file in excel, you should be able to sort your data by the third column (or any other column).

Remember (most important) to select ALL DATA in the file. If you do not have all your data selected when you do a sort it will only do the area or column and not keep all your horizontal data correct.

So highlight A:1 to D:1100 or whatever and then go to data / sort and choose your column with the business name in it. It may not catch them all, but will be a good start.

Daniel

Actually, as long as you only have a single cell selected, Excel will sort the entire file. It's when you have more than one cell selected, or a single row selected for example, that it will only sort the selected area.

That is true as long as you have something in every column. If there is a completely blank column, it will stop at the preceding column.

That is why I put a space in the first line of any column if there is more data in columns after it.

If any off the Longitude & Latitude is outside of the US Like Canada For Example or Hawaii Poi Verifier will give you that error message unless you check the box for Canada Or World