Category Archives: Mac

Extract All Email Addresses from Outlook

I was looking for a solution to extract a list of all emails I have ever used or emailed through outlook. It might be helpful for you too. This what I ended up doing:

a) Export email and contacts into an olm file (Mac). I was using Outlook 2011. This is a binary compressed format. I selected Email and Contacts.

b) Use StuffItExpander to extract the olm to a readable XML structure. Just install StuffItExpander and drag the olm file on to it. You end up with a parsable directory structure including all files in xml format.

c) I could not find a solution to recursively parse the mess, so I decided to merge all xml files form all subdirectories into one big file:

$ find /path/to/directory/ -name *.xml -print0 | xargs -0 -I file cat file > merged.file

d) Extract all email addresses from the merged file into a file:

$ perl -wne'while(/[\w\.\-]+@[\w\.\-]+\w+/g){print "$&\n"}' merged.file | sort -u > output.txt

e) You will be surprised how many lines this file will have. Check the output.txt containing all unique extracted email addresses from outlook. The list needs to be cleaned. There will be a lot of invalid or temporary emails you need to go through manually.

Have fun with your list.

Sync Your Stuff to S3

This is a receipe how I save stuff to S3 from my Mac:

1.) Signup with S3: http://aws.amazon.com/s3/ (check pricing!). This will give you access to the AWS Management Console.

2.) Create a Bucket: This can be done via the AWS Management console. If you are not familiar with the concept of ‘buckets’ check-out the S3 documentation. Simply put, it is a virtual storage device that has a fixed geographical location.

3.) Go to ‘Security Credentials’ in your account settings in the AWS Management console and create an accesskey.

4.) Download JetS3t. You then have the following directory on your Mac:
/Applications/jets3t-0.7.3

Open the Terminal and change into the bin directory:
$ cd bin;

Create a file named synchronize.properties there:
$ nano synchronize.properties;
and save the following content using your keys from step 3:

accesskey=XXXXXXXXXXXXXXXXXXXX
secretkey=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

5.) To sync the contents in the path /Users/marco/MySyncStuff with the bucket myBucketName use this command:
$ ./synchronize.sh UP myBucketName /Users/marco/MySyncStuff/ –properties synchronize.properties;

Of course you can create as many buckets as you like and script and schedule your data syncs now from here as you wish. Use the command
$ ./synchronize.sh –help
to see what the synchronize.sh else has on offer.

6.) Browsing buckets: JetS3t has its own S3 browser. To start and use it do the following:

$ cp cockpitlite.sh cockpitlite.command;
$ ./cockpitlite.command &;

You should see the Java coffee cup on your task bar. Use your keys to log in and browse your buckets.

You can also use the free S3 Browser for Mac.

Synergy – Many Computers, one Keyboard

Some days ago I saw some colleagues using more than >2 computers with one keyboard and one mouse, dragging the mouse across multiple screens with different operating systems and using the clipboard accross them. Wow!

This is done with a tool named Synergy. Here is my setup with Windows XP and Mac OSX:

4 Screens, 2 Operating Systems connected via Synergy

I did the following to make it work:

  • I installed Synergy on my windows box (the 2 screens on the left) .
  • Started Synergy and started it as the ‘server’.
  • I configured the server with screens named like the IP-Addresses of the machines I wanted to use and defined which machine with its screens are on the left and which ones are on the right. This defines where the mouse cursor transfers to the next screen. I also used alias names for the screens.
  • Started Synergy on the server (Windows).
  • Then I downloaded Synergy for Mac OSX.
  • My MacBook is also attached to a 2nd Mac-screen (no. 3 in the picture). In this setup this one is optional. I had it lying around, so I used it.
  • The configuration has to be saved manually in the file synergy.conf. I used some aliases in order to avoid trouble.
  • Now I started the Synergy-client on the MacBook with “/Users/Shared/synergy-1.3.1/synergyc -f mmm” from the command line.
  • Problems with the connection are shown on the server and on the client and can easily be fixed with the documentation on the synergy website.

You will find all you need to know on http://synergy2.sourceforge.net

A good tutorial: http://www.elsniwiki.de/index.php/Main/SynergyKonfigurieren