Linux

ZK spreadsheet is an online spreadsheet which enables users to import and export excel files and edit excel files within the browser. This can be thought to be similar to Google Spreadsheet. Only that it is open source and can be installed on your own server. Another very similar open source product which I came across was Sheetster but the setup was not very straight forward and also I was not really impressed with the UI and functionality.

After spending almost a day in trying to configuring my dd-wrt router as an OpenVPN client and reading many complicated guides, I found a really simple way to configure OpenVPN. It is necessary that you have optware set up on your router. For setting up Optware, kindly read Optware, The Right Way.

There is one feature I often missed in linux console - deleting to Trash. I often do a 'rm -rf' and then suddenly realize that I have accidentally deleted something which I shouldn't have. From now on, I needn't worry because I have started using trash-cli, a command line interface to the freedesktop.org trashcan. This small utility provides commands to delete and restore files from the console.

I often find it difficult to use 'scp' program because I don't know the exact path to the directory in the destination server and I do not find 'sftp' program very useful because it does not support recursive downloads. Here are two programs which offer recursive downloads over sftp protocol:

1. psftp provided by package putty-tools

# psftp user@server
psftp> get -r directory_to_download
psftp> put -r directory_to_upload