Update 2022: There is a new solution which actually works! FileDrop is a google sheet extension which let’s you…

1. choose a file from your computer to upload
2. inserts the link to the file into the current cell

In order to use it:

1. go to https://getfiledrop.com and click “install addon”
2. on the spreadsheet you want to use it click extensions -> FileDrop -> Start FileDrop
3. put the focus on the cell you want to add the link
4. drag and drop the file into the sidebar

The file will be uploaded into your google drive into a folder “FileDrop” which you can move to any position of your drive tree. If you want to define the upload location then you need to switch to the paid version.

Alternatively you can use dropspread - but I found dropspread harder to use (it has a few UI quirks)

The old solution, for history reasons. I couldn’t get it to work again, if anyone is interested, I think this stackoverflow answer is pointing into the right direction.

The following setup lets you

So I’ve decided to move my wordpress blogs to tumblr. Although apparently TechCrunch thinks that’s a bad idea. And although Moritz Adler would kill me for that. (Although: He doesn’t have a personal blog and hence has no licence to kill me). Anyway. With tumblr I don’t need to host a blog software myself. And I don’t end up having my blog hacked and then seeing my blog being displayed as a malware site in Chrome/Firefox (happened to me twice). And then with tumblr I create new blogs with subdomains within minutes. Cool stuff. Hail to the cloud, baby!

So here you go: A complete guide how to fully migrate your wordpress blog to tumblr. Including comments and pictures. And still supporting your old url scheme.

Update: I ran into a tool that claims to do a lot for you: import2.com/tumblr. It doesn’t migrate images and 302 redirects. Not sure about comments migration. And it costs 24$. Still, if you can leave out some of the steps below that’d be worth the money. Comments of the author on quora

Jambox is a pretty cool device: The sound quality is very good, it is small, it has a battery. I liked it. Until it broke. It just didn’t play music over bluetooth any more but instead uttered static noise. This seems to be a quite severe production problem as after some internet research I found that many people have devices with the exact same problem. So going down the “Jambox please replace my device” way didn’t sound promising to me. The possibility that the replacement device is broken as well is just too high.

The problem lies in the aux in port. The device thinks there’s an aux cable plugged in and outputs the signal from the aux input when in fact it should play the bluetooth sound.

I bought a Jambox about half a year ago. Sound wise it is great, but apparently it is not very stable, especially after recharging it falls into some state where it only utters static noise. In this state it still plays music over the aux cable, but not any more over bluetooth.

Sometimes I want to print list of dicts as an ascii table, like this:

| Programming Language | Language Type | Years of Experience |
+----------------------+---------------+---------------------+
| python               | script        |                   4 |
| php                  | script        |                   5 |
| java                 | compiled      |                  11 |
| assember             | compiled      |                  15 |

I searched on Google - but without luck.

I’m running a Django-powered site for a closed user group and added a bit of JavaScript magic here and there (mainly Prototype and Tooltip).

I’ve got a django project running which requires you to login to access files.

That means that I have to serve the files via python, like this:

@login_required
def download(request, filename):
  # ... some code specific to my site ...
  response = HttpResponse(mimetype=postUpload.mimetype)
  response['Content-Disposition'] = "attachment; filename=" + original_filename
  response['Content-Length'] = os.path.getsize(filename_path)
  response.write(open(filename_path).read())
  return response

To find out how many percentage a certain process uses the cpu:

For last Webtuesday I gathered a few historic data of the «tag movement» (that got very quiet in the last two years).

Update September, 2007: Thomas Vander Wal wrote a very good roundup on the tag history

I wanted to run a shell command in python without knowing if the shell command is going to exit within reasonable time (adplay that was, sometimes it simply hangs).

Update: the “task” module of Rob Hooft seems to solve this exact problem. At the time I wrote this, the python.net website was down. I leave my solution here just for archive purpose.