Skip to main content

Kanada - Tag 3

Nachdem ich am Dienstag Abend in Toronto angekommen bin, sind jetzt schon drei Tage vergangen in denen sich auch ein bisschen was getan hat und ich mich soweit sehr gut einleben konnte.
Am Dienstag konnte ich direkt am Flughafen ohne große Wartezeit mein Work&Travel Visum holen, mit dem ich jetzt ein Jahr ohne große Einschränkungen in Kanada arbeiten kann. Am Mittwoch habe ich meine Sozialversicherungsnummer beantragt und versucht, meinen deutschen Führerschein gegen einen Kanadischen umzutauschen, was leider nicht auf Anhieb ging. Dafür musste ich gestern meinen Führerschein zum Übersetzer bringen. Heute konnte ich ihn wieder abholen und habe jetzt meine vorübergehenden kanadischen Führerschein.
Mit unserem Auto bin ich inzwischen auch vertraut und es macht richtig Spaß bei gemächlichem Tempo (schnell fahren darf man leider nicht) durch die Gegend zu fahren und das schöne Wetter zu genießen.
Somit sind eigentlich alle wichtigen Vorbereitungen abgeschlossen und ich kann mich ganz darauf konzentrieren einen Job zu suchen und mich schlau zu machen, ob und wie ich mit einer temporären Arbeitserlaubnis selbständig machen kann.
Bei meinen Bildern gibt es übrigens auch schon erste Bilder aus Kanada. Ich werde versuchen diese von Zeit zu Zeit zu ergänzen.

Comments

Popular posts from this blog

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 Data Integration - Multi-part Form submission with file upload using the User Defined Java Class Step

I recently needed to use Pentaho Data Integration (PDI) to send a file to a server for processing using HTTP Post. I spent several hours trying to use the existing steps HTTP Post, HTTP Client & Rest Client but I couldn't get it to work. After some more research I came across the issue PDI-10120 - Support for Multi-part Form Submittal In Web Service Steps  and I thought I was out of luck. I previously wrote a small Java client for a similar use case and remembered the PDI has a step called User Defined Java Class  (UDJC). After reading this great tutorial I created the following basic transaction. I have a dataset with the URL and the full file path and use the UDJC to make the HTTP call. HTTP Post using User Defined Java Class The Java class handles the actual HTTP Post. It uses 2 input variables, the URL (url) which is used for the call and the file name (longFileName). The HTTP call then contains the file (line 30) and the file name (line 31). I included some basi

Products you don't expect to be 'Made in China' - Del Monte fruit cups

Since I moved to Canada back in March I have started to realize how many products are actually made in China. Back in Germany you could also buy lots of stuff from China but you mostly had the choice between German or Europe products and Chinese products. When I went to Food Basics in Oakville a couple weeks ago to get some apples I stood in front of a huge tray of Chinese apples! Aren't there enough apples in Ontario, Canada or the US? Even Mexico would probably be closer than China. Another day my wife bought Del Monte fruit cups in the grocery store. I checked the label when I was going to eat it and i decided to leave it in the fridge. First of all it is 'Made in China' (again I guess no other country in this world has fruit) and second it contains artificial flavor. How bad must the fruit inside be that you need artificial flavor (and does anybody in China controls how it is made)? For my part I'll check the labels more closely whenever I buy any kind of product