transfer text document/xls document to OV2 file

[linrew]

hi

i have found a text document with walmart locations on it

does anybody know how to transfer this to ov2 formatt

the document has this data on it

38.919506,-77.226799,Wal-Mart- I-66:47 7412 Stream Walk Ln (Located to ZIP)
36.843859,-81.502353,Wal-Mart1I-81;47 1193 N Main St (Located to Block)
30.451374,-91.243474,Wal-MartI-10:151 2808 Court St (Located to Block)

other than that i have an XLS document with addresses only(walmart) is it possible to transfer this to ov2

any ideas or help would be appreciated

please be aware that i have no idea how to do this so i will need an idiots guide

many thanks

linrew :D

[linrew]

sorry i forgot i also have a LOC file with florida waypoints on it (something to do with expertgps)

any ideas

linrew :D

[rkm_hm]

If you download the free POI Converter program from http://rjdavies.users.btopenworld.com/html/poiconverter.html, it's relatively easy.

Basically you need either an Excel spreadsheet or comma delimited text file with one store location in each row. Each entry needs to be in Longitude, Latitude, Name order. [Your data appears to have lat/long rather thab long/lat - so you'll need to swap the first two columns.
You'll then have to decide how to present the location of each store - because that's what will show on TTG's screen when you browse them. If ZIP is sufficient, what you already have is fairly close. However, if you want to display City/neighbourhood, you'll have to find a way of importing that into your spreadsheet before creating the .ov2 file. Either way, I assume that you will create a file called Wallmart.ov2 - which will show up on TTG as a POI category called "Wallmart" - so you don't need or want the word "Wallmart" to appear in each individual entry. You can use Excel's search and replace function to replace each reference to Wallmart with (nothing).

Once you have created your .ov2 file on your PC, you need to connect TTG to the PC using the USB cable. The PC should then see TTG as an external USB mass storage device. Using Windows Explorer, copy the .ov2 file to the folder on TTG's SD card which holds the map of your country or region.

Then, with TTG in navigation mode, you can say Navigate to POI - and select Wallmart from the displayed categories, and it will give you a list, starting with the nearest to your current location.

If you want Wallmart locations to show up when you browse the map, you'll need to create a 22x22 bit icon and call it Wallmart.bmp (assuming the .ov2 file is Wallmart.ov2) and you'll need to 'enable' the Wallmart category from the Change Preferences/Maintain POI menu.

HTH.
_________________
Roger
TomTom via135

Satmap Active 10+ v1.50 with full UK 1:50k map and 1:25k/1:10k County maps of Hampshire & Warwickshire

[linrew]

hi

sorry im being a bit of a dipstick here

i have downloaded the POI converter

i have used excel to swap the coloums from lat/long to long/lat and saved the file as walmartpoi

but when i open poi converter and goto open and choose walmartpoi it gives an error message saying "the data must be on worksheet points" the same message comes up when i goto append and choose walmartpoi

i assume i have done something wrong but no idea what

i would be greatfull if anyone has any ideas as to what i am doing wrong

linrew

[rkm_hm]

Look at the program's built-in Help - and read the section on using Excel spreadsheets. It explains that, for POIs, you need to give the sheet (not the file) the name "Points" - and it tells you what column headings you need to use.

Personally, I've always found it easier to save the spreadsheet as a .csv file - and then use this as input to POI Converter rather than the original spreadsheet.
_________________
Roger
TomTom via135

Satmap Active 10+ v1.50 with full UK 1:50k map and 1:25k/1:10k County maps of Hampshire & Warwickshire

[Pocketgps]

The data needs to look like below

-5.35235, 50.20901, "Your Description Here"

Within reason you can put whatever discription between the "" but don't make it to long

Just use NotePad, then save it with a .asc file extension, then use This Program

Just install it, then on the Tools - Batch menu just select the directories, and the format you require and its done.

[linrew]

many thanks

i think its sorted now

just got to get my USA maps to test it (still got to order them)

i have walmart and costco pois if any one wants to try them

again many thanks

linrew :D :D :D

We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?.
Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!