Coverting multiple POI's from .vcf to .csv or .gpx.

trapper · Posted: Sun Apr 08, 2018 10:21 pm Post subject:

Thank you both for your replies, sorry for delay in responding - at our Bowls club booze up this evening. I'm TT so quite sober.

I thought you would be able to play with the .csv file but appears not so
I have saved it again to Dropbox and the link is below.

https://www.dropbox.com/s/18rocu3wfzijymb/Bowls%20Club%20locations%202%20%202018.csv?dl=0

Have a play and let me know how it goes.

When you say a bmp picture, roughly what size should it be? Wouldn't POILoader add a generic icon as a destination flag?

Be back tomorrow. Smile

M8TJT · Posted: Sun Apr 08, 2018 11:04 pm Post subject:

Got that but should the club name and address be truncated to 8 characters?

Kremmen · Posted: Mon Apr 09, 2018 5:48 am Post subject:

Done, DropBox download:

https://www.dropbox.com/sh/2num567udd9oqfb/AABsxPbzvDowveAQ_KklXVWwa?dl=0

In there is a Bowls CSV and a Bowls .BMP

I've only converted the top line of the CSV - and one in Northwood, the nearest to me for testing.

You can only have 4 columns.

1) Lat
2) Long
3) Main Heading Description for Nav
4) All other details seperated by a HTML BR line feed. (I can't post HTML tags but the file is obvious)

End result:

No BMP:

My 22x22 BMP:

On the Garmin "Where To" - "Custom POI's" - "Bowls"

Moving forward ......

I assume you will get updated VCF files with new or removed clubs somewhere within.

You are going to have to manually enter the details into your existing CSV file.

To identify the VCF changes, download a program called KDiff:

http://kdiff3.sourceforge.net/

This is a superb program that can identify changes to files. It can identify changes hidden deep within a file and only highlight those changes, even when other data around it isn't now on the same file line.

I use it a lot.
_________________
DashCam:
Viofo A119 V3

M8TJT · Posted: Mon Apr 09, 2018 9:50 am Post subject:

Hi trapper. (Any reference to M.A.S.H. here?)
Ignore my post about truncation. My error Embarassed

I have had a chat with Kremmen this morning about this.
I can easily create an excel macro that re-orders the your .csv data into that required (I've done it before recently) and give you a copy (of the .csv and the macro), but what might be better is that if we could cut out the middle man (your .csv file) and go directly from the source .vcf file(s) to the modified .csv.
I haven't a clue what a .vcf file looks like. Can it/they be loaded into Excel?
Upload it/them and post the link.

trapper · Posted: Mon Apr 09, 2018 11:37 am Post subject:

Gentlemen.
Thank you for taking so much trouble with this, it is really appreciated.

I am struggling to keep up but hope I can give you the details you need.

I use the following Skoda website to generate the vcf file which I then download and add to my Skoda SD card.
http://mydestination.skoda-auto.com/POIs.

The file it generates (As with all the clubs in the dropbox link) looks like this:
https://www.dropbox.com/s/vc3t5h6vfzdeftz/Abbots%20Langley%20BC.vcf.txt?dl=0

I also use this website for some or more accurate locations:
www.findlatitudeandlongitute.com

Kremmen, thanks for the new csv file and the icon, Very Happy

You say I can only have 4 columns but there are 6 shown?

M8TJT,
Quote.
I have had a chat with Kremmen this morning about this.
I can easily create an excel macro that re-orders the your .csv data into that required (I've done it before recently) and give you a copy (of the .csv and the macro), but what might be better is that if we could cut out the middle man (your .csv file) and go directly from the source .vcf file(s) to the modified .csv.
I haven't a clue what a .vcf file looks like. Can it/they be loaded into Excel?
Upload it/them and post the link.
Unquote.

Link as above.
I know roughly what a macro does (Sort of automated instruction I think) but it may be beyond my capabilities Crying or Very sad

Won't know until I try but my motto is KIS or Keep it Simple!
If your suggestion is simple that would be great.

Kremmen · Posted: Mon Apr 09, 2018 1:46 pm Post subject:

You can have as many columns in your Excel file as you like but POILoader will only read the first 4.

I left it at 6 columns but blanked out the data for the 2 clubs I amended.

This means you can put your reference data in cols 5+ in the knowledge that Garmin will ignore it.
_________________
DashCam:
Viofo A119 V3

M8TJT · Posted: Mon Apr 09, 2018 2:01 pm Post subject:

trapper · Posted: Mon Apr 09, 2018 4:58 pm Post subject:

Gentlemen. I am ever so pleased you like a challenge.....
My user name has nothing to do with M.A.S.H, more to do with trapping wind - I am of course referring to sailing and sails!! Long story......

Kremmen · Posted: Mon Apr 09, 2018 5:53 pm Post subject:

Yes it does.

Garmin will use the first 4 columns. ABCD.
_________________
DashCam:
Viofo A119 V3

M8TJT · Posted: Mon Apr 09, 2018 7:03 pm Post subject:

Does the csv that you linked to contain all the data that you wish to 'do'? If so, I'll get on with it.
BTW what version of Excel are you running?

trapper · Posted: Mon Apr 09, 2018 8:51 pm Post subject:

Hi

Kremmen.
Okay, for the satnav I will use the first 4 columns, Lat & Long, Club Name and Post Code. So the actual address will not form part of the Garmin satnav information.

M8TJT.
Correct.
For my car I can include all the details except the phone number on my Skoda satnav as shown on my vcf link and an earlier post on page 1:
Club name. address, and post code plus the geo location. Not bothered about the phone numbers, they are only for use if someone gets totally lost or will not arrive in time. However for the printed info they could come in useful.

I am using MS Office Excel 2010.

trapper · Posted: Mon Apr 09, 2018 9:31 pm Post subject:

M8TJT.
I am not sure what your macro would do, and using KISS logic I think that I could use the Skoda Destination Portal (As previous link) for my car. Then if you can originate a macro to convert the vcf file so that the Garmin unit will work with it as a csv file that would be fab.
I can easily make any changes to the printed list manually. Having had a look at the changes to the new cvf file using only the 4 columns and the address printed as;
19 Langley Rd Access via alley at side of Scouts HQ Hall ?BR? WD5 0EH ?BR? 01923 269086 - May (Okay, will) confuse some of our members.
Do you think this would be a simpler way to end up with what I need?

Ohps, when attempting to preview this post the message appeared that HTML tags are not permitted, I guess they are the < entries that I have now changed to ? and added spaces. Seemed happy that way Wink

M8TJT · Posted: Mon Apr 09, 2018 11:54 pm Post subject:

No. You keep your 'master list' exactly as it is at the mo. My macro copies the data from in into a new sheet, doing all the swapping about etc and sticking in the ?BR? stuff then saving the new sheet as a .csv. Then all you have to do is point POILoader at the new csv and job done.

I'm not sure whether I can take multiple vcf files and get them into Excel.
Excel 2010, just what I am running.

As I have said before, I am totally ignorant about vcf files. Is the vcf file(s) a single file with multiple club data or multiple files with just one club data?
If it's a single file with all the data, please upload it so that I can have a look.

Kremmen · Posted: Tue Apr 10, 2018 4:07 am Post subject:

Trapper

Your question re 'no address info' ...... you obviously haven't seen my post with the pictures and looked at the 2 CSV lines I amended for Northwood and Abbots Langley as examples.

Everything you need to do to get this working 100% is in those 2 lines in the CSV still available for download from my Dropbox.

Until M provides a Macro, all you need to do is amend all the other lines to put the postcode and phone number into column 4 alongside the address, seperated by BR markers and you're good to go.
_________________
DashCam:
Viofo A119 V3

M8TJT · Posted: Tue Apr 10, 2018 8:03 am Post subject:

I've done it. I just need to test and check out the output csv format on my Garmin later today.

	PocketGPS
	Web