Tuesday, March 18, 2008

Conference update

Ok I have been planning for a few years now to redo the entire report generator and I have finally done it. It took a lot of side work for the past few months but it is done. I have also compared it to some of the results from last year to see if it is functioning properly.

Some updates that are in the new version:

  • Moved from DAO to ADO data connections
  • Changed all code away from MS Jet to pure SQL
  • Created option boxes for each report so the entire routine isn't needed for one report
  • Created accurate progress bars to reflect what is being done
  • Made liberal use of "DoEvents" commands to the processor isn't killed
  • Reduced excessive code
  • Removed redundant code

    With all those changes the report generator which, from what I recall, took minutes to run is now down to 26 seconds for all reports. This includes the most difficult and twisted ones. This should make our job much easier when it comes time to actually use the report generator.

    Out of everything listed there I'm not done with it though. Right now it is set to a static database which I need to change to something more dynamic. I'll be including a standard open file dialog box for this use. After that I'm not sure how much more I need to do to make it a better program. The reports are nice and snappy and still accurate so what can I do?

    Actually there is two things that need to happen. I need the full documentation of all the reports to make sure that what I am generating is what should be generated. I did find a fault in the previous version of the report generator though. The swimming award doesn't work and from what I can see never did. I'm not sure what I was generating in previous years but it isn't want they wanted LOL.

    Well no more updates on this subject at least until Purple Mangos gets back to me about the reports. [Insert not so subtle nudge here.]

    Update: It seems my understanding of the report was incorrect. The design of the tables involved were very flawed. Enough that they shouldn't have been published like that in the first place. Anyway a new table will be introduced that will help slipstream the process and make it faster than before. To relax people let it be known that the system before was completely functional just very clumsy. If I wanted to go to Vancouver and back again I wouldn't take a cruise ship to get there I would take a plane. Both will get you there one will just take longer.

  • Friday, March 14, 2008

    And so a truth comes out ....

    I'm not sure if it is the real truth or just a convenient truth but it is something. At last I have a reason why my employment was not continued. It seems that I wasn't "management enough" to be able to stay there. Considering the way that people were talking I'm not sure if this is the real reason but it is something closer than anything else that I have heard. The only part that makes this funny is I'm not sure if my boss actually knew that was the reason.

    I'm not sorry to go though. The place was nice but I did start to notice some undercurrents throughout the company that I'm not sure I would have enjoyed. This saved me time about what was going on. Also the release resulted me in not having to drive through way too much snow. The other advantage is that I really don't want to be management at this stage of my life. I enjoy what I do right now and I'm not sure I could step away from that to be able to do more. I'm a System Administrator and I'm happy with that.

    Sunday, March 09, 2008

    A sweet goodbye

    One of my co-workers sent me this e-mail after my departure:

    "Thanks a lot for your assistance in the past, and if need be in the future. The only person that was here to provide stimulating conversation is no longer - you. Days and afternoons will be boring now.

    I do wish you all the best that can possibly come to you, and that you find deserving employment soon. I am sure that my surprise was equal to yours on Friday, but I guess the "perfect fit" was more important than an individual who was willing at all times to assist, and one who had work ethics similar to mine.

    I am sorry for their loss - not yours.

    Keep well and good luck."

    I think that is the nicest thing anyone has said to me after I have left a company.

    Sunday, March 02, 2008

    A little update

    Ok I have my domain back and it is actually working. I have been responding to various e-mails and what not since it has been back online.

    As most people know when you first get a job there is a certain probation period that you are in where both parties have an option of ending the working relationship without notice or reason. Well Monday would have marked the passing of that time at my employment but it seems I won't be there to see it. As management said they didn't think I was the "right fit" for the company. So I'm out looking again for employment and we shall see how that goes. Anyone know of a company hiring a Windows System Administrator? If anyone wants to see my public resume you can find it here.