Why do I get "No matchs found"

 

I've been working on a POI for electrical suppliers and I can't seem to get it to work. I see the file when I go to extras on my nuvi 205 but when I go to open it I get "No Matchs Found". Any Ideas? I've tried
using Excel and Notepad with no luck. Here is the data I'm using.

41.519291,-81.666481,"Leff Electric, 1163 E 40th St.Cleveland, OH 44114-3894 , 216-432-9881",-,
41.418037,-82.141579,"Leff Electric, 42307 North Ridge Road Elyria, OH 44035-1130 , 440-324-5483",-,
41.663769,-81.372887,"Leff Electric, 7520 Clover Avenue, Suite 7 Mentor, OH 44060-5200 , 440-946-5448",-,
41.319649,-81.83567,"Leff Electric, 12925 Pearl Road Strongsville, OH 44136-3425 , 440-572-8188",-,
41.265385,-80.800529,"Leff Electric, 1230 North River Road Warren, OH 44483-2353 , 330-372-3344",-,
41.12627,-80.711304,"Leff Electric, 1090 North Meridian Road Youngstown, OH 44509-1015 , 330-799-1366",-,
41.319649,-81.83567,"Leff Electric, 12925 Pearl Road Strongsville, OH 44136-3425 , 440-572-8188",-,
41.265385,-80.800529,"Leff Electric, 1230 North River Road Warren, OH 44483-2353 , 330-372-3344",-,
41.12627,-80.711304,"Leff Electric, 1090 North Meridian Road Youngstown, OH 44509-1015 , 330-799-1366",-,

Can anyone see anything wrong. Notepad produced this file from my input information. I have also seen an error noting a problem on line 2. I have no idea what could be wrong.

Your coordinates are reversed

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"," "

--
MrKenFL- "Money can't buy you happiness .. But it does bring you a more pleasant form of misery." NUVI 260, Nuvi 1490LMT & Nuvi 2595LMT all with 2014.4 maps !

.

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.

,-, and Lon/Lat

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,

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2019.30 CN NA NT maps | Magellan Meridian Gold

I justn put the locations in

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.

YES!!!!!

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

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

--
Frank Nuvi 3597LMT 37.322760, -79.511267

.

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.

Having fun now

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 smile

Line Breaks

rdstang01 wrote:

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 smile

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

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2019.30 CN NA NT maps | Magellan Meridian Gold

I'll give that a try. Thank

I'll give that a try. Thank you

Address Display

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

Gary A wrote:
rdstang01 wrote:

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 smile

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

It worked great!! Thx