E-gineering partnered with a client to rebuild the reporting framework for their telephone voice response system. Their telephone response system functions differently than the traditional “voice mail” system of phone interaction and allows for a more natural and varied conversation with the user. As such they had some unique client data reporting requirements. The prior reporting solution involved batch processing production data every night to create Excel spreadsheets that were e-mailed out the following morning. While functional, the existing system… [continue]
Teacher Planning, Assessment, & Collaboration Platform
E-gineering partnered with a state advocacy group to build an online suite of tools for educators. The goal was to provide Indiana teachers with “smart” tools to assist in the broad areas of planning, instruction, curriculum, assessment, and collaboration. These goals were achieved through the implementation of a web-based portal with custom portlets that included such things as a Class Manager, Lesson Planner, Resource Repository, Standards Manager, Assignment Grader, Rubric Builder, and multiple teacher collaboration tools. E-gineering was involved from… [continue]
Getting the Status of an Oracle Trigger
Just a quick post about trying to determine the enabled/disabled status of an Oracle trigger. I found code snippets like this: Or like this: The first only gives you the triggers owned by the user session so if you are logged in as the admin, this won’t work for a trigger in a schema. The second one doesn’t work because the status of the object as Valid/Invalid. I figured if there is an all_objects table, there must be an all_triggers… [continue]
Converting Database Data Directly to XML
I had another interesting problem when an application framework we’ve been working with came out with a new version. Before, a value relating to the application user’s “Position Name” (i.e. Manager) was a user-entered value. In the new release, this value was supposed to come from an XML configuration. Our client had already entered over 200 different positions and understandably didn’t want to take the time to hand enter each one into this new configuration. I found out that DB2… [continue]
The Vacuum of Columns
I know that I’m laying on the space analogies pretty thick, but it just seems to work so far… Anyway, I learned something interesting today and I thought that I would pass it on. I’d like to start off saying that I don’t know if this is the best way to go about trying to combine fairly unrelated records from fairly unrelated tables. If anyone has better ways to do this type of thing PLEASE let me know. I think… [continue]