Home for Robert Lawson's Code

This site is the home for code and scripts I’ve written somewhat recently, or at least I have e-copies of the material. There are 3 main sections/groups:
- OneCard, a custom Identity Management System using MS Access/VBA
- Active Directory & Exchange/EAS email administration with vbscript
- JIT ERP system with Oracle database and hpux

The OneCard system is written in MS Access, mostly using Visual Basic for Applications, VBA, and MS SQL Server database. This code started back in the late 1990’s on another project, sat idle, and was re-born as a custom Identify Management System for a private university. OneCard is a physical card used by staff, faculty and students for room access, library card, meal plan, money card, and photo ID. Staff and faculty information is gotten from PeopleSoft HR, student information from PeopleSoft SA and all others directly from OneCard. OneCard sets up a user in most of the key campus applications, including all that have LDAP authentication: PeopleSoft Campus Solutions, PeopleSoft Financials, PeopleSoft Portal and Angel (e-courseware). OneCard creates the Active Directory user, the Exchange mailbox and the personal network share. No less important is the setup for library patron: IIS, access card: Diamond, ID and meal plan: CBORD Odyssey PCS, and soon housing: CBORD Odyssey HMS. Other tasks are the central phone number replicated with the CISCO Unity voicemail system, and setting up help desk tickets for new user setup and phone setup. Some of the post index’s for this area and more are: Active Directory, VBA, PeopleSoft, ADO, ADSI,OneCard, Microsoft SQL Server, Windows Server.

The Active Directory and Exchange/EAS email administration use various tools for reporting and/or improving, most written in vb-script. EAS, from Zantaz, was configured to store/archive email attachments from the Microsoft Exchange email server. Thus Exchange only stored the text portion of the email, enabling us to offer large mailboxes campus-wide, without clogging up Exchange. The biggest portion of email storage was thus in EAS, and the focus of reporting: over quota and weekly recap. The weekly recap proven to be an effective tool, showing total space used, quota, % used, details of top 20 largest attachments. If a user got an over-quota warning, all the help desk had to do was refer them to their last weekly summary report. Active Directory reporting was ad-hoc requests and used for auditing that our standards were indeed being followed. Some of the post index’s for this area and more are: Active Directory, Exchange, EAS, Group Policy, CDO, DDL, event log, HTML, CSS, outlook, bat file, vbscript.

The JIT ERP system was an Oracle database and tools based product that ran on hp-ux unix. The JIT system included inventory control, purchasing, WIP, shipping, GL, cost accounting, order entry, and accounts receivable. The samples included on this site are examples from most of these areas. Many were used to improve reporting speed and accuracy, both for short term planning and longer term. Much of the information was assembled into spreadsheet format and then downloaded to PC. Some of the post index’s for this area and more are: Oracle, pl/sql, sql*plus, shell script, hpux.

The main navigation is by way of the "post index". You can search with the search up at the upper left on the blogspot bar. My convention on dates shown is the creation date. Contact me at trev3411@gmail.com
Thanks, Robert