1999-00-00 Calgary Work And Car
Marr Associates needed to export their data from the PIMS database (which i wrote in Lotus Notes) to the CEPA database. The CEPA DB was in Paradox. Anyone who knows of those two realize how big a pain in the ass it was.
I wrote some neat functions in lotus note that would loop through the recordsets and perform the neccessary calculations to convert the PIMS values to the CEPA values. The whole system initially took 4 hours to run! My revised version brought it down to 30 minutes.
The papers on the floor is the map between the two DB's.
Marr Associates flew me in from Thunder Bay to Calgary to write this program as the due date was in a week! So many 14 hour days with David Portelance to get it done.
|