Archive for the ‘VB’ Category

NT/2000 Event Log Archiver & Viewing System

Wednesday, February 23rd, 2005

OBSELENCE NOTE: This was written well over a year ago, so may be outdated (ie. may have broken links — if so, let me know and I’ll update).  Just because it’s old doesn’t mean that it’s not worth sharing!

Summary:

There are lots of products out there that allow you to remotely view your NT/2000-based event logs.  Not many of these allow for an archival and later viewing of these events.  If you look for something free, it really narrows the field down — so I wrote a program that would archive NT/2000 event logs to a SQL database.

After I had them archived, I noticed that my SQL database was really filling up fast.  I decided to code the ability to export certain events from the SQL DB to an XML file, allowing the file to be burned to a CD/DVD for archival.

Well, now I’ve got a 600MB XML file, and no way to view it.  Naturally, I wrote a program that would view and print the XML file as if you were looking directly at the NT/2000 event log itself.

Obviously there are several pieces to the big picture:

  1. The archiver (reads event log entries – stores them in the SQL DB – exports events to XML file).
  2. The viewer (reads XML file for viewing/printing).
  3. The SQL DB (plan on having a lot of space taken up by these logs).

NOTE: You need to have the MS XML parser installed on the machine that you run any of the first two above programs on to have them work.  If you’re looking for the MS XML Parser 4.0 SP2, go to http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&displaylang=en.

(more…)

Online Requisition System (ORS)

Thursday, January 13th, 2005

OBSELENCE NOTE: This was written well over a year ago, so may be outdated (ie. may have broken links — if so, let me know and I’ll update).  Just because it’s old doesn’t mean that it’s not worth sharing!

Summary:

THIS PAGE IS UNDER CONSTRUCTION AND MAY BE INCOMPLETE

This is a requisition and PO management system that I built.  The ORS interfaces with Meditech’s data repository (DR) to provide accurate shipping and status from the Meditech system itself (assuming that your site has Materials Management (MM)).  The system could still be used if you don’t have Meditech, but quite a bit of the code would have to be modified (it was originally designed to tightly integrate with Meditech).

Each user is authenticated against a Windows NT/2000 domain.  Group permission can be setup by the NT group that the user is a member of (mapping NT groups to the appropriate ORS groups requires a manual initial mapping).  There are system-wide limits for how much can be ordered without a super-user’s signature, etc.

Another added bonus for this system is the digital signature component’s integration with digital tablets.  I chose to use the ePad tablets (when originally designed, the only ePad tablets around were serial-based — you could probably get by using the USB just as easily).  The only catch is that the proper Windows drivers must be configured on the workstation that has the ePad for the digital signature piece to work properly (digital signatures need only be received from super-users — people who approve purchases over set limits within the system).

For more info, read over the docs below (go to the downloads section below).

(more…)