Home » Creating POI files

Creating Excel Uploads for Garmin

 
Tue, 01/02/2007 - 9:19pm

Is there an easy way to enter the carrage return on Column 4 information so the address wraps around correctly? I am using a Nuvi660 and have a lot of lines that I am trying to format correctly. I would perfer not doing this by hand. I know of the "Alt Enter" trick and think that there should be some way to program it!! -Thx Paul

‹ Distant Differences Changing the distance for a speed or redlight alert ›
Fri, 01/12/2007 - 2:00pm

concatenate

If you have an existing database file saved as a CSV file, you can use Excel's 'concatenate' function to combine separate address, city, state, zip, and phone number columns into one 'comments' column that the POI loader program will translate to POI comments, complete with line breaks. It's tricky - because you have to include quotation marks in front of the first field you are concatenating as well as at the end of the last field so the POI Loader will format the 'comments' with the line breaks when it uploads.

--
*Keith* MacBook Pro *wifi iPad(2012) w/BadElf GPS & iPhone6 + Navigon*