Archive for February, 2009|Monthly archive page

Importing into Google Contacts from a CSV

I’ve spent far too much time trying to import my phonebook into Google Contacts from a .csv file, for my new G1.  Google have done an uncharacteristically poor job of their import function (at least as far as plain CSV files go, I haven’t tried the other options).  I eventually worked out the format by creating a dummy contact and exporting it to CSV.  I’m posting it here because I couldn’t find a decent description from searching the web.

Here are the columns from my exported contact:

  • Name
  • E-mail
  • Notes
  • Section 1 – Description
  • Section 1 – Email
  • Section 1 – IM
  • Section 1 – Phone
  • Section 1 – Mobile
  • Section 1 – Pager
  • Section 1 – Fax
  • Section 1 – Company
  • Section 1 – Title
  • Section 1 – Other
  • Section 1 – Address

And similar fields for Section 2.  The thing I didn’t immediately realise is that each section corresponds to different types of contacts.  Section 1 is Work, Section 2 is Home/Personal.  I presume section 3 would be Other but I didn’t have any data in there.  More importantly, the name of the section has to be in the description field, so Section 1 – Description has to contain the string “Work”, Section 2 – Description “Personal” (not “Home”!), etc.  Once you know that it’s all quite easy, but it’s not obvious at all.

So an example line would be:

<name>,<primary email>,,Work,,,<work #>,,,,,,,,Personal,,,<home #>,<mobile #>,,,,,,

Surely Google can get an intern or someone to improve the usability of this, or at least improve the documentation!

Top 10 NY Beer Bars

Here’s my top 10 NY beer bars (again in no particular order):

  • The Ginger ManMidtown East. Probably the best beer bar in Manhattan, huge selection of draught beer and bottles and decent bar food.  Only downside is it gets very crowded with the after-work crowd.
  • Spuyten DuyvilWilliamsburg, Brooklyn. Looks more like an antiques shop than a bar from the outside.  Quite out of the way (from my point of view anyway) on a fairly nondescript street in Brooklyn.  Extremely good beer selection, with a lot of quite rare beers, including some cask beer with proper hand pumps, which you very rarely get in the US.
  • d.b.a. – East Village.  Great beer selection, good atmosphere, a bit cramped if the garden out the back isn’t open.  They seem to have a location in Brooklyn as well now.
  • Peculier Pub – Greenwich Village.  Studenty dive bar, but really great.  Very good beer selection, dodgy decor…  Not sure why they don’t spell it ‘peculiar’.
  • Zum Schneider – East Village.  Great German beer house and restaurant.   Lots of decent German draught beer (mostly Bavarian), and great food.  Also do a lot of events (e.g. Oktoberfest) which are very popular.
  • Burp Castle – East Village.  “Temple of Beer Worship” – they used to have bartenders dressed as monks.  They don’t do that any more, but they do sometimes tell people to be quiet if the noise level is too high for proper beer contemplation.  Very good selection of Belgian beers, as well as others.
  • Hop Devil Grill/Belgian Room – East Village.  Decent array of American craft and Belgian beer (the Belgian Room is/was next door but I think they might have redesigned since I last went).
  • Vol de Nuit – West Village.  Cool Belgian beer lounge, fairly small with moody red lighting.  Good frites!
  • Loreley – Lower East Side.  German brauhaus, very good food and good beer (including Kölsch!).
  • Blind Tiger Ale House – Greenwich Village. Great selection of draught (including some cask ale) and bottled beers, both American and international.  Gets very busy but worth it.

Honourable mentions (can’t be bothered to track down links!):

  • Stout NYC – Sports bar with good beer range, near Penn Station.
  • House of Brews – several locations.   Good draughts.
  • David Copperfields – Upper East
  • Heartland Brewery – several locations.  Micro-brewery.
  • Good World Bar and Grill – Lower East Side.  Swedish.
  • Valhalla – Midtown.  Good beer range.