FAQ-worthy info on description length limits and phone numbers

 

This post addresses using custom POI files with multi-line descriptions and phone numbers in TomTom, and addresses how to get it all to display and how to make sure the number dials properly. If this info is already available on this board, I apologize (my search didn't find similar info).

In importing custom POI's from this board, I noticed some limitations of the ov2 format for TomTom 6 PDA version (that may or ma not apply to other models).

First, multi-line descriptions don't work in TomTom, so if a CSV uses multiple lines, you only get the last one. You can fix this in Excel. For example, if the CSV uses two lines, enter this in cell E1:

=C1&" "&D1

then copy that formula to all cells down the column. Next highlight the column and copy, "paste special" to column F, and select "Values." This column will now be the text from the first two columns.

If the description has phone numbers and you want to be able to dial them, you need a > symbol in front of each number. This can generally be accomplished with a Find & Replace (say, of a semicolon or a slash). You may want to add the country code (+1) to the beginning of each number too (depending on how your phone dials).

Finally, you want to make sure no descriptions are over 63 characters. Descriptions over 63 characters suffer two problems:

1. They don't display beyond the 63rd character.
2. The phone number won't dial. This is the big issue, IMO.

You can find out if cell C1 has too many characters by using the formula

=LEN(C1)

You can then paste this formula down a column, sort by that column, and see which descriptions need to be edited.

Once all descriptions are columns are combined and the resulting cells are 63 characters are less, you can remove any extra columns and save the file as an XML for use in POIEdit(I couldn't get Excel-modified CSV files to work in POIEdit).

Good info

Thanks ardbeg for taking the time to make this post!

Miss POI, could you please consider incorporating ardbeg's post as a FAQ if you haven't already done so? Thanks! smile

Mike

--
Freedom isn't free...thank you veterans! Heard about the tests to detect PANCREATIC CANCER? There aren't any! In Memoriam: #77 NYPD-SCA/Seattle Mike/Joe S./Vinny D./RTC...and God bless Donald Trump!

On my list

Yes I will be doing that over the weekend;)

I get to play preschool teacher today in our youngest daughters school, so I will not be getting much more work done today.
I also have a note to make this one a faq also http://www.poi-factory.com/node/11040

Miss POI

Teacher teacher

miss poi wrote:

Yes I will be doing that over the weekend;)

I get to play preschool teacher today in our youngest daughters school, so I will not be getting much more work done today.
I also have a note to make this one a faq also http://www.poi-factory.com/node/11040

Miss POI

Thanks Miss POI...you deserve 2 apples today! wink

Mike

--
Freedom isn't free...thank you veterans! Heard about the tests to detect PANCREATIC CANCER? There aren't any! In Memoriam: #77 NYPD-SCA/Seattle Mike/Joe S./Vinny D./RTC...and God bless Donald Trump!