Why do I get "No matchs found"

41.519291,-81.666481 should be

-81.666481,41.519291 for one thing

Total line should read

-81.666481,41.519291,"Leff Electric, 1163 E 40th St.Cleveland, OH 44114-3894 , 216-432-9881"," "

In a Custom POI file, the longitude needs to be in the first column and the latitude in the second.

So, unless these locations are in Antarctica, you need to swap the first two columns.

What is the purpose of the ,-, at the end of each line? That is basically creating 5 fields for each POI entry and may cause a problem for POI Loader. I'm not sure because I've never created an entry formatted like that.

But your big problem is that you have the lat/lon reversed. The first entry for example, should be:

-81.666481,41.519291,

I justn put the locations in at google maps and it produced the rest. Thanks for all your replies I'm going to change things around and see what happens.

I switched the lat/lon and it worked. You guys are the best. I wonder why Google switched them around? Oh well, it's fixed now thanks to you guys.

Google reported them correctly. Garmin format requires them in the opposite order.

Glad you got it sorted out.

Just a piece of information so you understand what is happening with the data so that you can make it work in the future.

Google didn't "switch them around".

In the normal world, geographic coordinates are always expressed as "latitude, longitude".

For some unknown reason, in the Garmin Custom POI specification, the order is reversed. This is the only application where you will see them reversed to my knowledge.

So if you are are geocoding, you will likely always need to swap the columns so that the longitude is first for Custom POI files.

Thx all. I'm getting the hang of it. I'm not to happy with the way my adresses are displayed on my unit. I will post it in the projects forum. Thx again all

Sounds like you may want to try line breaks in the address field. If you open the file with Excel and use the Alt-Enter key sequence, you can make it display like this:

Leff Electric
1163 E 40th St. [Alt-Enter]
Cleveland, OH 44114-3894 [Alt-Enter]
216-432-9881

I'll give that a try. Thank you

To make the address display in a better format you can use a character return. Beware that in some units, character returns are not handle too well in POI files.

For example use the following address line in Excel:

-81.666481,41.519291,"Leff Electric, 1163 E 40th St., Cleveland, OH 44114-3894 , 216-432-9881",-,,

(1) Select the whole document and merge all text
(2) Replace " , " with "," and ", " with ","
(3) Move data to columns at the ","
(4) Delete the column that contains -
(5) Remove the "'s
(6) Concatenate the name, address, city, state zip, and phone number with the CONCATENATE command
(7) Insert CHAR(10) where you want a line break

Suppose the data starts in A1 and ends in G1 as defined below:

A1
-81.666481
B1
41.519291
C1
Leff Electric
D1
1163 E 40th St.
E1
Cleveland
F1
OH 44114-3894
G1
216-432-9881

The command to concatenate the data would be as follows:

concatenate(C1,char(10),D1,char(10),E1,", ",F1,char(10),"Phone: ",G1)

The result should be as follows:

Leff Electric
1163 E 40th St.
Cleveland, OH 44114-3894
Phone: 216-432-9881

Good luck!!!

It worked great!! Thx