Making Custom POI Line Breaks Work with nuvi 350
17 years
|
At this time no forced line breaks are displayed in the POI’s comments column when using the nuvi 350. I figured out a workaround until Garmin fixes this issue …. modifying the POI file by changing the ‘ASCII Control Character for Linefeed’ to ‘HTML’s Tag for Linebreak’. Here’s a step-by-step procedure to do this using Excel 2002 (Other versions should be similar.).
Open the POI.csv file with Excel, then follow these directions:
1. Verify the NUM LOCK light on the keyboard is on.
2. Select column D by clicking on the column D header until the column is highlighted.
3. Click on the EDIT menu and click REPLACE
4. Click on the REPLACE tab.
5. Verify the cursor is in the FIND WHAT: window. Do not click in this window, it may change the ‘find’ parameters. If the cursor is not in the FIND WHAT window, restart Excel.
6. Here’s the trick. (NOTE: Nothing will be displayed in the FIND WHAT window when performing this step, but the ASCII code will be entered.) Hold the ALT key down while typing 010 using the numerical keyboard (must use the numerical keypad). Then release the ALT key.
7. Click in the REPLACE WITH window and type these four characters exactly like this: <br>
8. Click REPLACE ALL
9. Click OK, then CLOSE
10. Now save it any way you prefer. I saved mine with an underscore in front on the name so I could preserve the original file. i.e. _PoiName.csv)
I wrote a small Excel macro to do this with a push of a Hot Key. If anyone is interested in this, I’ll post the code.
It would be interesting to know if the nuvi 360 and nuvi 660 have this same line break problem.
See also
Excel macro
Yes, please post. Do you know what affect the fix has when viewed on other devices that do not exhibit this problem?
Garmin Nüvi 265WT,Software Ver. 7.00, City Navigator North America NT 2010.30
Nuvi 350 Line Feeds
I guess I consider this more of a 'workaround' than a fix. Don't know what this modification will do on other GPS's, and I'm hoping Garmin will eventually have a fix for us; so that's why I rename the modified file and retain the original. I'd like to hear from other nuvi's, as when as other GPS users who don't have this line-break problem.
Here's the macro code. In Excel you should be able to go to TOOLS, MACRO and create a macro, then paste this in. Select the macro OPTIONS button and enter the hot key you want.
Good luck.
------------------
Sub ConvertPoisTo_nuvi350()
'
' ConvertPoisTo_nuvi350 Macro
' Macro recorded 2/2/2007 for nuvi350.
'
' Keyboard Shortcut: Ctrl+Shift+R
'
Columns("D:D").Select
Selection.Replace What:="" & Chr(10) & "", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
<br>
Nice trick retiredtechnician
For the other curious minds:
I tried it with my c550. It didn't provide a line return, just displayed the <br> on the gps screen
........Garmin StreetPilot c550 / Nüvi 765...........
Linebreaks on nuvi
Thanks, lsmonop. Sure appreciate your feedback.
Would like to know if other nuvi's besides the 350 have this 'line break not displaying' problem.
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
Linebreaks
R_T
I will try this on the campground file I have and prepare for the C340 and let you know how it goes.
3/1/2007 - 11:06
I was not able to insert a line break. I did follow your instructions. For your info, I am using Office Pro XP.
I do have a technique to batch insert [CR]s in large .csv files. It works very well, the resultant [CR] is the same as one entered with the use of an "alt [CR]". I use this technique to change the location of the [CR] from one column to another and change the format.
As soon as I test the process some more using different types of files and formats, I will post it.
Jim
Linebreaks on nuvi
R_T
I will try this on the campground file I have and prepare for the C340 and let you know how it goes.
3/1/2007 - 11:06
I was not able to insert a line break. I did follow your instructions. For your info, I am using Office Pro XP.
I do have a technique to batch insert [CR]s in large .csv files. It works very well, the resultant [CR] is the same as one entered with the use of an "alt [CR]". I use this technique to change the location of the [CR] from one column to another and change the format.
As soon as I test the process some more using different types of files and formats, I will post it.
Jim
If you have a nuvi you may be interested in this program to convert standard linebreaks to ones the nuvi recognizes. It changes the standard LF/CR to 'br' enclosed in arrows. It also corrects some common errors in csv files and alerts the user of others. Here's a link to the post:
http://www.poi-factory.com/node/1844
Thanks.
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
Linebreaks on nuvi
r_t thanks,
I did down load your beta file the other day. Although I do not have a nuvi, I have a c340, I found that it is excellent in finding problems in .csv files, and I use it to find those errors. In my next post, Federal & State Campgrounds, unload (in progress) I found 3 errors, one was a long, lat error and the other two were missing fields. With out your verification program I would have never found them until someone called them to my attention.
You did a great job of programing.
Jim