Andy Kopciuch's Blog
Sunday, March 29, 2009
  db2sql, download quotes & the brier
So really working on the Power Broker to Toolkit integration last week. Jeff did a bunch of the leg work, and produced a dump of the dbf file with a utility from whitetown. They seem to be dbf conversion specialists. Handy tools they provide. We switched to the conversion directly to Postges SQL format, instead of CSV. So now it is a direct import. I ran into a couple of small issues with escape characters, and how close to the SQL spec PG is with regards to string literals. I now have a working script that sets the proper options, and the right sequence of events. Also converts the encoding of the data to UTF-8. Which is required for the import to work properly. Onwards and upwards.

I also spent some time back in the world of bikes. I changed some of the navigation, and added some options to download a copy of the quote in PDF or email it to your address. Didn't take too much effort. It's nice to have handy libraries like FPDF. I also did some quick work with jpgraph for some of the statistics pages to get them going. Again ... nice to leverage existing work.

So the brier was in Calgary a couple of weeks ago. I had some tickets. I caught 1 draw, and our party never made it back from the brier patch for the evening draw. Ian, Scott, yaz and myself. TOTALLY SHITFACED! We were all gong-show drunk. It was such a great night ... well ... early night as it was. Kinda funny that happens when you start drinking at 2:00 P.M. Cheers to the Brier!
 
Comments: Post a Comment



<< Home
The Jolly Smoking Computer Programmer

ARCHIVES
October 2004 / November 2004 / December 2004 / January 2005 / February 2005 / March 2005 / April 2005 / May 2005 / June 2005 / July 2005 / August 2005 / September 2005 / October 2005 / November 2005 / December 2005 / January 2006 / February 2006 / March 2006 / April 2006 / May 2006 / June 2006 / July 2006 / August 2006 / September 2006 / October 2006 / November 2006 / December 2006 / January 2007 / February 2007 / March 2007 / April 2007 / May 2007 / June 2007 / July 2007 / August 2007 / September 2007 / October 2007 / November 2007 / December 2007 / January 2008 / February 2008 / March 2008 / May 2008 / August 2008 / October 2008 / December 2008 / January 2009 / February 2009 / March 2009 / May 2009 / August 2009 /


Powered by Blogger