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!