Converting from PocoMail to Gmail

Wifey was tired of PocoMail. It has not been revised in years, the HTML renderer, while “safe”, is not very conformant, which translates into lots of Tech Support calls. Me. Since she uses Gmail at work, why not migrate to Gmail? PocoMail uses Unix MBOX format files to store email – very nice, a standard… Continue reading Converting from PocoMail to Gmail

Converting ISO-8601 date strings to Date in Pentaho Kettle

So I was working on a conversion from a CSV dump from a student system to our internal label database. New school year, new students. I like to use the time format yyyy-MM-ddTHH:mmZ (ISO-8601, a standard format) for strings, but Pentaho Kettle has no explicit conversion from an ISO-8601 string date to a date type… Continue reading Converting ISO-8601 date strings to Date in Pentaho Kettle