Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
MacFixer, the iPhone, iPod, and iPad specialists
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Coverting multiple POI's from .vcf to .csv or .gpx.
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Coverting multiple POI's from .vcf to .csv or .gpx.
Goto page Previous  1, 2, 3, 4, 5, 6  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs)
View previous topic :: View next topic  
Author Message
trapper
Regular Visitor


Joined: Jun 04, 2005
Posts: 128
Location: Radlett, Hertfordshire

PostPosted: Sun Apr 08, 2018 10:21 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Sun Apr 08, 2018 11:04 pm    Post subject: Reply with quote

Got that but should the club name and address be truncated to 8 characters?
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 6737
Location: West London & Reading

PostPosted: Mon Apr 09, 2018 5:48 am    Post subject: Reply with quote

Thumbs Up

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.
_________________
Satnav:
Garmin DS61 LMT-D (In the car)
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Mon Apr 09, 2018 9:50 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
trapper
Regular Visitor


Joined: Jun 04, 2005
Posts: 128
Location: Radlett, Hertfordshire

PostPosted: Mon Apr 09, 2018 11:37 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 6737
Location: West London & Reading

PostPosted: Mon Apr 09, 2018 1:46 pm    Post subject: Reply with quote

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.
_________________
Satnav:
Garmin DS61 LMT-D (In the car)
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Mon Apr 09, 2018 2:01 pm    Post subject: Reply with quote

trapper wrote:
Thank you for taking so much trouble with this, it is really appreciated.
No problem. K and I like a challenge.
Quote:
I use the following Skoda website to generate the vcf file which I then download and add to my Skoda SD card.
I am not familiar with vcf files. Does it provide a separate vcf file for each individual club? If so, how dis you generate the csv filke from them?
Quote:
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?
K has answed that one above. Only 4 for the Garmin, but you can concatenate more by using a tag.
Quote:
I know roughly what a macro does (Sort of automated instruction I think) but it may be beyond my capabilities
If we can get it workred out, I will write the macros for you.
Quote:
my motto is KIS or Keep it Simple!
The full story is KISS. Keep it simple stupid. Very Happy
Back to top
View user's profile Send private message
trapper
Regular Visitor


Joined: Jun 04, 2005
Posts: 128
Location: Radlett, Hertfordshire

PostPosted: Mon Apr 09, 2018 4:58 pm    Post subject: Reply with quote

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......

Quote:

I am not familiar with vcf files. Does it provide a separate vcf file for each individual club? If so, how dis you generate the csv file from them?

I use the vcf files in my Skoda with it's satnav system. I do the Excel spreadsheet using any details I can find, by hand. Then add the Geo info from the vcf or the website as above. I saved this .xls file as a csv file and then tried to import it into POILoader, hence my thread here when it all went a bit wrong.

Quote:

I know roughly what a macro does (Sort of automated instruction I think) but it may be beyond my capabilities
If we can get it workred out, I will write the macros for you.


That would be very handy.

Quote:

The full story is KISS. Keep it simple stupid.


Yeah, but I did not want you to think I was referring to either of you Exclamation

Quote:

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.


I print the club details list in A4 Landscape, with a copy on the right so two copies on one page. I cut it in half so have two copies of A5 for our members. I would think I can still use the csv file with the first two columns hidden. Does it matter to Garmin if these are hidden or not? I can of course unhide them if needed.
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 6737
Location: West London & Reading

PostPosted: Mon Apr 09, 2018 5:53 pm    Post subject: Reply with quote

Yes it does.

Garmin will use the first 4 columns. ABCD.
_________________
Satnav:
Garmin DS61 LMT-D (In the car)
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Mon Apr 09, 2018 7:03 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
trapper
Regular Visitor


Joined: Jun 04, 2005
Posts: 128
Location: Radlett, Hertfordshire

PostPosted: Mon Apr 09, 2018 8:51 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
trapper
Regular Visitor


Joined: Jun 04, 2005
Posts: 128
Location: Radlett, Hertfordshire

PostPosted: Mon Apr 09, 2018 9:31 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Mon Apr 09, 2018 11:54 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 6737
Location: West London & Reading

PostPosted: Tue Apr 10, 2018 4:07 am    Post subject: Reply with quote

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.
_________________
Satnav:
Garmin DS61 LMT-D (In the car)
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Tue Apr 10, 2018 8:03 am    Post subject: Reply with quote

I've done it. I just need to test and check out the output csv format on my Garmin later today.
Back to top
View user's profile Send private message







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs) All times are GMT + 1 Hour
Goto page Previous  1, 2, 3, 4, 5, 6  Next
Page 2 of 6

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB 2.0.11 © 2001 phpBB Group
phpBB port v2.1 based on Tom Nitzschner's phpbb2.0.6 upgraded to phpBB 2.0.4 standalone was developed and tested by:
ArtificialIntel, ChatServ, mikem,
sixonetonoffun and Paul Laudanski (aka Zhen-Xjell).

Version 2.1 by Nuke Cops 2003 http://www.nukecops.com

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
20.115 (30 Nov 22)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







Terms & Privacy


GPS Shopping