Export all Google Sheets to csv

I had a Google Apps spreadsheet with around 40 sheets. Wanted to export them to csv. Unfortunately Google only lets you export one sheet at a time. Here's a script that exports all sheets in a spreadsheet to csv To use, click on tools --> script editor. Then create a new blank…

Approaches to JSON internationalisation (i18n)

I needed to create an API that is capable of serving objects with strings in more than one language. Let me present the problem with an example. Lets assume that we have a web app or a mobile client that wants to get information about coffee shops around the city. Also,…

Export mongodb collections to csv without specifying fields

Sometimes you might want to export your Mongodb database in csv format. If you have many collections, it can be a bit of a hassle since mongoexport requires you to specify each field you want to be exported with the --fields attribute and you have to do it for each…

i18n for Node + Express

In this post i'm going to demonstrate a simple way to add multi language support to a node + express project. Simple server Lets start with a simple server: We first require express, then we tell express where to look for our templates files. In this case I used ejs as the template…

חתונה אזרחית בגיברלטר

התחתנו כמו רבים וטובים בטקס אזרחי בארץ. תיכננו ירח דבש בספרד ועל הדרך חשבנו שיהיה נחמד להתחתן בגיברלטר כדי שנוכל להירשם בארץ כנשואים. למה גיברלטר ? נמצא בדרום ספרד, באזור שבו רצינו לטייל. מאד מקלים על התהליך. לא יקר מדיי. טקס באנגלית, פחות בלאגן בתרגום. סה”כ היה קליי קלות, באמת. אז הנה הפרטים. מסמכים דרושים תמצית רישום של…

How to create a clearable autocomplete dropdown with AutoCompleteTextView

I wanted to create a nice search box with autocomplete results dropdown in the ActionBar. I could have used the SearchView widget but I didn't want to create a searchable activity and all the necessary overhead. Instead I used a more lightweight approach with AutoCompleteTextView. I'll explain here the steps…