Well, some good things, some bad things, some in between I guess.
I did finish one of my training courses, but I have lots and lots of them to go. Sometimes I feel they’re really helping, other times I sit and stare at my computer and wonder how in the heck I’m supposed to make what I’ve learned work. I keep hoping the information will drop into my practical knowledge repository somehow, but so far…
With everything I’ve been doing for work, I’m not writing. Anything. At all. It’s been a long time since I’ve had a chance. It will likely be a lot longer before I get one, too. I’m worried about my job. I feel like I’m on my way to becoming a victim of The Peter Principle. The problem with that is, I don’t have a level down I can drop.
I pray a lot. See above. ‘Nuff said.
I also had to stay up until 3AM both Friday and Saturday, watching a problem unfold with our nightly macros. When I try to run them manually, I have no issues. When they run through the automated process, they don’t work correctly. I’ve been reminded the way this runs is thusly:
A Windows Server scheduled task is set to open an Excel spreadsheet which contains an Autoexec macro.
The Autoexec macro calls a second spreadsheet which contains another macro which is executed.
The second spreadsheet now calls a Microsoft Access database, which also has Visual Basic for Application code written in one of its programming modules. That module then launches a routine which: executes an import of a text file, runs a screen-scrape of a mainframe emulator against some data in the newly imported text file and updates our orders, then puts the orders which were mismatched, not processed, and successfully processed into three separate tables in the database.
Whew! So, when something goes wrong with this routine, my predecessor is quick to point out he didn’t write the application. I didn’t either, but I have to try and fix it. See the Peter Principle statement above. I’m over my head on this, and have to find a way to fix it.
Did I mention it’s not consistent? Yeah, that’s fun. The problem comes and goes. Saturday night it ran fine. Friday night not. I don’t get it and don’t know what to do.
Well, enough whining. The upside is, I spent some fun time with my kids this weekend just hanging out and watching them play and stuff. I got to put up some additional Halloween decorations with them, and enjoyed them a lot. I didn’t sleep a lot, which was my plan initially, but I had a good time. I made some progress in a second video course on Visual Basic .NET too, which is good. I’m almost halfway through that one. When I finish it, I’ll be on to ASP.NET to reinforce some of what I’m learning in the boss-provided training I finished. Then on to Language INtegrated Query (LINQ) for VB.NET. Some day, I’d like to learn C#, but for now, there simply isn’t time in my deadlines. I’m supposed to have 75% of the projects I’ve been assigned done early or on time and right now, that’s not happening. But a guy can dream. And I really like the training courses I’ve chosen. I feel they’re a good vehicle to learn for me, because I get to watch stuff as well as hear it. If I could just get myself to work through the examples, I’d be all good.
Thanks for letting me vent, and have a great week. I’ll talk to you again when I can.