Tag Archives: google

Exporting your Google Stars to CSV or KML

I’m part of the Google Local Guides and a question came up amongst our cohort about being able to export your Stars from Google maps into something useful you can then import elsewhere. For example being able to import by Name, longitude and latitude would allow you to import into Google My Maps.

You can visit Google Bookmarks and download an html file of your bookmarks, but it’s a relatively useless Netscape Bookmark format. So to convert this to a useful CSV file I’ve devise this linux script using sed and awk:

CSV Export

for i in `sed -ne 's/.*\(http[^"]*\).*/\1/p' < GoogleBookmarks.html`; do curl -sL $i | awk '{split($0,a,"[")}; {split(a[21],b,","); printf b[2]}; {split(a[4],c,","); print ",",c[2],",",c[3]}' | sed 's/\"//g' | sed 's/\]//g' | awk '!/, , /' >> googbook.csv; done
This will output the Name, Longitude and Latitude to a CSV file.

To spit out the full address too use the following:

for i in `sed -ne 's/.*\(http[^"]*\).*/\1/p' < GoogleBookmarks.html`; do curl -sL $i | awk '{split($0,a,"[")}; {split(a[21],b,","); printf b[2]; printf "\",\""; printf b[3]; printf b[4]}; {split(a[4],c,","); print ",",c[2],",",c[3]}' | sed 's/\]//g' | awk '!/\",\", ,/' >> googbook.csv;; done;

KML Export

Visit http://gexport.somee.com/ upload your GoogleBookmarks.html file and then download the KML file (easy peasy).

Google+ For the Win!

Last month Google+ introduced Collections https://plus.google.com/collections/welcome
A devilishly simple way to group your posts by topic.

When you create a Collection you set the audience, so you can have private collections for posts on a topic to share with a particular audience, or you can have public collections that anyone can follow.

This is a brilliant move on Google’s part. Users can follow topic from a user, rather than every little thing they posts. It’s so simple to share with a collection too, so it’s a win for those posting the content.

Another win is that posts by content are so reader friendly that the take up on followers is very good.

Google+ is becoming my favourite place to post stuff to now, and a great place for a Global community instead of just posting stuff amongst your friends and family. The Internet is the world, not just the people you already know.

I hope more and more of you come round to Google+, and if you don’t, well you’ll be missing out but you won’t be missed, there’s a whole world of people out there.


Windows 8 Browsers in Modern UI aka Metro Mode

browser iconsSince getting my Nexus 10 I used my laptop less and less. It largely comes out for research activities which involve a lot of switching between apps or browser windows or typing heavy activities where a keyboard is preferable to a touch screen, and I don’t lose half the screen to the keyboard.

Metro, sorry, Modern UI

I upgraded my laptop to Windows 8 not long before getting my Nexus 10. I’ve got used to most things with the Modern UI and some apps being Desktop apps, however after change Google Chrome to launch in Metro/Modern UI mode I noticed that Internet Explorer was then opening on the desktop instead of in the Modern UI. I changed this back, but then Chrome opened in Desktop mode.
Seemingly the browser that is the default browser and opens http(s) links is the one that opens in the Modern UI.

Just One Browser?

I’m very surprised by Microsoft to be so small minded to think that users will only use one browser and so will be happy with just one opening in Modern UI. As someone who does some web design and troubleshooting of html and css I regularly use the main four browsers. I seems my choice to have all with the same experience is to set all to open in the desktop mode. Surely that’s not what Microsoft wants.

Google Hangouts Firewall Ports

Our firewall was configured as per Google’s documentation to allow the Google Hangouts nee Talk client and the Android Google Hangouts app to connect. but to no avail.
With a little bit of troubleshooting I found that an additional port needed to be opened too. So here’s the firewall ports you need to open for Google Talk:

  • 80 TCP
  • 443 TCP
  • 19302 – 19309 TCP and UDP
  • Additional Ports for various clients
    Ports Clients
    5222, 5223, 5224 XMPP clients
    5228 and 5229 Android phones
    5269 XMPP federation

This information was taken from  Optimize your network for Hangouts

I hope that helps some of you out there.