Max columns in Excel

 

In creating my poi, I put the lat/lon in columns A & B.
I then put Name of the location in column C. I then put the address of the location in column D. I would like to put the telephone number in column E, which I did but it does not display when I open the poi in my Garmin nuvi 360. How can I accomplish what I want to do?

Number of Fields in CSV File

Normally a GPSr can handle 4 separate fields of data, and your 1st 3 fields are correct. ( some models only recognize 3 fields, sorry ) In the 4th, you can provide a lot of information there ( just don't put any commas there or POILoader will stop at the first comma found ) and the GPSr will display all of it.

I've seen some .CSV files with over 200 characters in the 4th field and the GPSr displays it via the "More" button.

HTH
dd

Comma

drdevo wrote:

( just don't put any commas there or POILoader will stop at the first comma found ) and the GPSr will display all of it.
dd

Ooooh, glad I read this. I've been building a file that includes commas in the address field

--
Garmin Etrex Vista, Streetpilot 2610, GPSMap 60Csx, Nüvi 750, Colorado 400t, Nüvi 3790t

commas

I have used commas in the address field successfully by putting quotes around the field.
ex.
"Orlando, FL"

--
Nuvi 350

Number of fields

I use four columns and found that using quotation marks around the commas and one trailing space works fine.

--
Nuvi 350 - North Carolina - I'm not a native Southerner but I got here as fast as I could!

More button

drdevo wrote:

I've seen some .CSV files with over 200 characters in the 4th field and the GPSr displays it via the "More" button.

POI Loader writes column 4 csv data to the description field of the gpi (which belongs on Page 2 - Nüvi 3xx is a notable exception). However, in the absence of any address/phone/email info, the unit outputs the description on Page 1 instead. Unless, of course, it won't fit - then it outputs it twice, once on Page 1 (where any html formatting is ignored) and again on Page 2, where any html formatting gets rendered properly.

So, for a laugh - try putting the following in column 4 of a csv file

". <-150 odd spaces-> <font color=RED>Hello World - this is Page 2</font>"

The 150 spaces overflows the front page (but obviously doesn't print). On Page 2, standard html rules apply and the 150 spaces are reduced to a single space.

You should end up with a MORE button and the message Hello World etc, in red when you press it.

(This doesn't work on the Nüvi 3xx series - it only has one Page). Also the Nüvi 6xx series are a bit awkward - I don't think "spaces" work, it might have to be a printing character.

--
------------------------ Phil Hornby, Stockport, England ----------------------               http://GeePeeEx.com - Garmin POI Creation made easy           »      

If you use Excel to create the CSV

jeffa62 wrote:

I have used commas in the address field successfully by putting quotes around the field.
ex.
"Orlando, FL"

If you use Excel to create the CSV, it will put the quotation marks around the fields that need them.

--
><> Glenn <>< Garmin nüvi 2598

Try This

Look at my seven-eleven.csv file. Take a look at col D (click on col D and you'll see what I am taling about). It has 4 rows in it for each column. I have found that if you do it this way, the address shows up on line 1, city on line 2 and phone on line 3, hours on line 4, and so forth. It works on my Garmin 680.

Also, I am not sure that you can't use commas in col D. Look at my caves.csv file and you will see I have used commas. On my Garmin, it treats the commas as just another character for col D. The difference in the way I did it above and with caves is by putting the whole address on one line, you are letting the unit control how many characters go on one line. On my 680 it will put about 26 characters on a line and go to the next line. If you put too much information on col D, it will overflow to another page and you will see the "more" below to get to it.

--
Larry - Nuvi 680, Nuvi 1690, Nuvi 2797LMT

POI Loader Help

Read the 'help' info in POI Loader, it will answer most all of your csv POI file questions. Incidently, in the first post, it was stated "I put the lat/lon in columns A & B" For Garmin POIs, the longitude is the first column, latitude in the second column.

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."

Took your suggestion...and

ahsumtoy wrote:

Look at my seven-eleven.csv file. Take a look at col D (click on col D and you'll see what I am taling about). It has 4 rows in it for each column. I have found that if you do it this way, the address shows up on line 1, city on line 2 and phone on line 3, hours on line 4, and so forth. It works on my Garmin 680.

Also, I am not sure that you can't use commas in col D. Look at my caves.csv file and you will see I have used commas. On my Garmin, it treats the commas as just another character for col D. The difference in the way I did it above and with caves is by putting the whole address on one line, you are letting the unit control how many characters go on one line. On my 680 it will put about 26 characters on a line and go to the next line. If you put too much information on col D, it will overflow to another page and you will see the "more" below to get to it.

I don't have a problem with the format. However, the coordinates on five locations I checked were way off. Two examples;

yours -83.485305,35.84753,Forbidden Caverns

should be closer to...

-83.34615,35.90451 ...(these coords took me to the parking lot this summer)

or
yours -97.439561,29.497992,Inner Space Cave

should be closer to these
-97.687936,30.607921 this particular cave in Georgetown Tx actually is under I-35, your listed coords are about 65 miles east of I-35 and 80miles south of Georgetown (all as the crow flies)

You may want to recheck your coords.

--
........Garmin StreetPilot c550 / Nüvi 765...........

Try this for lines in column D

You can force data in column D to show up on a new line by holding down the Alt key and hitting Enter (Alt\Enter).

Using Excel, In Column D, type the address, then Alt\Enter, type the City State and Zip code, then Alt Enter, then type the phone number. Don't forget to save the file in CVS format.

The address data in column D will up in two rows with the phone number in the third.

Garmin Nuvi 680

Not with nüvi 350/360

CBRDan wrote:

You can force data in column D to show up on a new line by holding down the Alt key and hitting Enter (Alt\Enter).

This does not work for the nüvi 350 or 360 (which Guyd indicated he had) as they do not accept standard linebreaks. They have to be converted to <br>, thus the reason for POI Verifier which does this automatically. We discovered this way back in the beginning of 2007; and although Garmin has verified this problem, they still have not addressed it.

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."