Please recommend a POI editor for Mac (Solved)

Kremmen · Posted: Wed Feb 01, 2017 2:18 pm Post subject:

Yep

As long as the problem elements/characters are known then a VBA Macro can sort that.

It looks like column 3 data needs the quotes removing, but before that, if the data in column 3 has a comma between the quotes then that needs sorting.

The joy of coding
_________________
DashCam:
Viofo A119 V3

Privateer · Posted: Fri Feb 03, 2017 7:10 pm Post subject:

Before I go down the route of identifying the rows without commas, which therefore possibly may need to be encased with double quotes, I have temporarily added commas just for testing.

I'm using the following online POI Editor: http://www.POIEditor.com

Now the next problem that I've encountered is two fold:

1. Characters with accents are substituted with other characters, e.g.:

Portelet Bay Café becomes Portelet Bay CafÃ©
Samarès Manor, St Clement becomes SamarÃ¨s Manor, St Clement

2. Apostrophe S ('s) is substituted with \'s, e.g.:

Bonny's Country Garden becomes Bonny\'s Country Garden

I've saved the .csv file as "CSV UTF-8 (Comma delimited) (.csv) " format as that is the only format that sets to cope with accented characters. I then save the .csv file as Line breaks = Windows (CRLF) and Encoding = Unicode (UTF-8, with BOM) using TextWrangler.

Unfortunately, I've not used http://www.POIEditor.com with my Windows PC so I don't know if it correctly converts a Windows .csv file with characters that have accents and Apostrophes correctly.

Could somebody with a Windows PC please try converting a test .csv file to an .ov2 file?

Kremmen · Posted: Fri Feb 03, 2017 7:56 pm Post subject:

Typical

Last knockings on a Friday Rolling Eyes

I reckon if you have 2 examples as a sort of 'before' CSV (presumably the example you've just posted) and 'after' OV2 requirement I can see if I can work something out.

Will have to be Monday now though.
_________________
DashCam:
Viofo A119 V3

Oldboy · Posted: Fri Feb 03, 2017 7:56 pm Post subject:

I copied your text into a csv file. Converted the csv with MakeOV2 and the OV2 file opened in POIEdit as below.

_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1140

pcaouolte · Posted: Fri Feb 03, 2017 8:01 pm Post subject:

Converted your sample file using the online POI Editor: http://www.POIEditor.com and a Windows PC.

When the file is uploaded to the online editor the accents are displayed correctly but the apostrophe gets a backslash in front of it.

When the online editor saves an ov2 file the accents and the apostrophe in the ov2 file all appear correctly.
_________________
Paul

Privateer · Posted: Sun Feb 05, 2017 9:46 pm Post subject:

Kremmen · Posted: Mon Feb 06, 2017 6:01 am Post subject:

PM sent.

I'm fairly sure something can be done in a VB.Net program. After all, it just looks like 3 fields that need manipulating.

Anything I do of course will be Windows based and I only have access to the 'ClickOnce' installer that I reckon will only install on a Windows PC.

Having said that though, the base EXE may work on its own with a Mac to Windows utility.

Looking at this spec though, all the details have quotes and they mention an existing 'makeov2.exe' that does the job for you.

https://www.tomtom.com/lib/doc/TomTomTips/index.html?introduction.htm

Then 'Creating Content' - 'Creating POI Sets' - 'by converting a list of locations'
_________________
DashCam:
Viofo A119 V3

Kremmen · Posted: Thu Feb 09, 2017 9:40 am Post subject:

Cracked it - but - I've only got Windows.

1) Make sure the xlsx data is all changed to Lucida Console, Courier doesn't work.

2) Save the file as bog standard .csv (not tried the specific DOS or MAC csv options available in my Office version)

3) CMD.EXE

4) In CMD type in "chcp 65001" that changes the code page to unicode

5) Run MakeOV2.exe against the file.

In the final OV2 data café hasn't been changed to the A and copyright mark.

Email sent with xlsx, csv and OV2 files.
_________________
DashCam:
Viofo A119 V3

Privateer · Posted: Sun Feb 19, 2017 9:12 pm Post subject:

Problem solved (I think Wink

)

TextEdit

I have discovered that the Mac TextEdit program can be set to save a file as UTF-8, which you need to be able to use diacritics (i.e. accents on characters, e.g. à, á, ç, è, é, etc). This is done in TextEdit, by:

Preferences… | Open and Save | Plain Text File Encodeing, Saving Files is set to "Unicode (UTF-8)"

GPSBabel

I first tried GPSBabel a few weeks ago. For some reason I don't think that I installed it correctly on the Mac - we'll call this operator error! Wink

Well, yesterday, I tried again and the installation of GPSBabel worked.

After a few false starts, I discovered that the GPSBabel input file format needs to be set to "Universal csv with field structure in first line"

The process - basic

I'm now able to use diacritics in my POI names. I can also include telephone numbers in my POI details, however I'm trying to determine whether I can include telephone numbers via GPSBabel or if I need to use a longer method to do so. Therefore, for the time being, I'm not including telephone numbers for TomTom .ov2 files. The process is:

1. Create an MS Excel .xlsx spreadsheet with columns headings: Longitude (column A); Latitude (column B); Name (column C). If you do want phone numbers in your TomTom .ov2 file then in column C and right at the end of the name of the POI, add the Greater Than Sign followed by telephone in international format. Save file as .xlsx file. This is your master file.

2. Use MS Excel to open .xlsx master file and save as .csv file. This is your input file.

3. Open .csv file in TextEdit and then save file. This should convert the input file to UTF-8 format.

4. Launch GPSBabel and point to the .csv file as the input, with input format as "Universal csv with field structure in first line" and the output file as "TomTom POI file (.ov2)"

5. Copy the .ov2 to your TomTom device in the usual manner.

NB: I still have made sure that all of my POI names are encased in "double quotes" by adding a comma to the name. I will try without commas at some point.

I prefer to keep the POI name and POI telephone number in separate columns. I do have an Excel function that concatenates the two columns IF there is telephone number. I haven't discussed that function here as the function and method is a bit fiddly and I'm hoping that I can get GPSBabel to do it which would make the process and therefore the instructions much easier.

As you will gather, I have much more testing to do but I'm hoping to come up with a solution that uses Excel spreadsheet as a master file which can then be converted to a .csv file which can then be converted to not just TomTom .ov2 file but to any SatNav format by GPSBabel.

You may be able to use another spreadsheet instead of MS Excel but that may or may not work.

The reason that I wish to use Excel .xlsx as the master file is that you can see things neater and the formatting is kept.

Finally, I would like to thank everybody especially (in no particular order): abre, MaFt, M8TJT, Kremmen, pcaouolte, and Oldboy for all of your help. Thanks guys.

p.s. When I have things working as I want and I've done all of the testing, I'll do another write up.

Regards,
_________________
Robert.
iPhone 6s Plus, iOS 14.0.1: iOS CamerAlert v2.0.7
TomTom GO Mobile iOS 2.3.1; TomTom (UK & ROI and Europe) iOS apps v1.29
Garmin Camper 770 LMT-D

Kremmen · Posted: Mon Feb 20, 2017 4:53 am Post subject:

From my brief testing I found the change to Unicode to be the key. But that was running through a Windows command prompt.
_________________
DashCam:
Viofo A119 V3

	PocketGPS
	Web