Skip to main content

How to miss a flight (and spend a day at the airport)

Last week on wednesday my fiancée had to fly back from Frankfurt to Toronto with the 10am flight with Air Canada. To be able to spend more time together we decided to take the train from Freiburg at 5:54am instead of going by car. Usually the train arrives at 8am which gives you plenty of time to check in and go to the gate - but not this time. A few minutes before we would of arrived at the Airport there was an announcement that they have problems with the second part of the train and we had to stop at a very small train station. First the made everyone from the second part of the train to the first part. After trying to disconnect the second part there was a second announcement that it wouldn't work and everyone should go out of the train (it was about -10 degrees outside) and wait for the next train that should stop in about 10 minutes. It was the first time in my life that I had to go out of a train jumping out of the train since the platform was ways too short for the train.
After standing in the freezing cold for about 10 minutes the next ICE arrived. It was booked out already so it took a while for everyone to fit in. We were just going to start again when there was an anouncment again, this time they called for a doctor or medic, someone had a stroke. It took at least 30 minutes till they would bring the person away and we could start again. We ended up arriving at the Frankfurt Airport with about 100 minutes delay on a 120 minutes drive, of course my fiancée missed her flight.
At the ticket-counter from Air Canada we found out that we weren't the only ones missing the flight. Because of bad weather other people missed there connection flights too so the next flight at 5pm was overbooked already and they could only give Sarah only a stand-by boarding pass for it so we had to wait and sit around at the airport for a couple hours. At the gate at 4pm Sarah found out that there were about 25 other people on the waiting list, trying to get one of the 3 free seats. Of course it turned out she wouldn't get one. Going back the couting we got served from the same person helping us already in the morning and again she could put Sarah only on a waiting list.
So we picked up the luggage again, stayed over night in a cheap hotel and went back to the airport again at 7am. At least this time we where lucky and after talking to different people they could give us a seat and Sarah could fly to Toronto. Whenever I went to take the train home it was cancelled - how ironic.

PS: I decided to write future blog post in english. It is too confusing if I keep switching between languages and it helps me practicing my english.
Post a Comment

Popular posts from this blog

Creating YTD transformation tables

The other day I had to setup a new data warehouse that will be used for reporting with MicroStrategy. Part of it was setting up the date dimension including the transformation tables. I had a quick look online and couldn't find any script doing the work for me so I created them myself (with the help of a colleague). All you need is an existing date dimension with date_id, year_id, quarter_id, month_id and week_id, you can find plenty of scripts for that online. YTD tableselect t1.day_id, t2.day_id
INTO YTD_DAY
from LU_DAY t1, LU_DAY t2
where t1.day_id >= t2.day_id
and t1.year_id = t2.year_id QTD table select t1.day_id, t2.day_id as qtd_day_id
INTO QTD_DAY
from LU_DAY t1, LU_DAY t2
where t1.day_id >= t2.day_id
and t1.QUARTER_id = t2.QUARTER_id  MTD tableselect t1.day_id, t2.day_id as mtd_day_id
INTO MTD_DAY
from LU_DAY t1, LU_DAY t2
where t1.day_id >= t2.day_id
and t1.month_id = t2.month_id  WTD tableselect t1.day_id, t2.day_id as wtd_day_id
INTO WTD_DAY
from LU_DAY t1, LU_DAY t2
where …

Dynamic cell references in spreadsheets with Google Docs

During my former internships in a consulting company I had to work A LOT with Microsoft Excel and often had to use dynamic cell references over multiple worksheets. Recently I started using the spreadsheets of Google Docs to track my bank account balance and to figure out where all my money goes. I decided to have one sheet for every month + one sheet of the month I want to analyze. But how do I dynamically change the reference to the sheet (the monthly sheet) I want to analyze without editing every single formula? Here is my solution: Create the target sheets and your overview sheet
- I gave my sheets the names Month + Year (July 09)In the overview choose one cell that you want to contain the reference sheet and enter the sheet name
- cell D24 in the example
- Using the month names you might have to write 'July 09, otherwise Google will think it's a date.In the overview you can now dynamically reference to a detail sheet using the following formula:=INDIRECT("'"&…

Pentaho BI Server: Using action sequences as a web service with PHP

For my masterthesis I had to figure out, how to use the action sequences as webservice with PHP. According to the documentation you can receive soap messages but the action sequences don't offer a WSDL that would help you building your client. I also had problems with the http basic authentication, that Pentaho uses.
After a couple hours of research and try and error, I found a solution. I doubt thats the best way to go, but at least it works. All you need is the PEAR HTTP Request class.
Here is the code:

//PEAR Request
require_once 'Request.php';
$response = $req->sendRequest();

if (PEAR::isError($response)) {
echo $response->getMessage();
} else {
$req->clearPostData();
$req->setURL("localhost:8080/pentaho/ServiceAction");
$req->addQueryString("solution", "bi-developers");
$req->addQueryString("path", "reporting");
$req->addQueryString("action", "Testreport.xaction");