Ross Morrissey - UniVerse Articles

Ross Morrissey - UniVerse Publications

Reusable TRANS I-descriptor DICTionary items
"We can create keys involving complex inter-relationships between files by building them from simpler keys."
Article for the Geac October 1994 Service Plus Newsletter

Utility to Produce HTML Pages
Concise description of Intranet Reporting in UniVerse from 1996.

Intranet Reporting in UniVerse [630k Microsoft Word doc *]
Techniques for using an Apache webserver and Unix symbolic links to leverage standard UniVerse reports.
Article for OSDA Spring 2001 Newsletter, based on presentation notes.

UniVerse Intranet Access [108k Microsoft Word doc *]
Techniques for using an Apache webserver and ISINDEX to access UniVerse commands.
Article for OSDA Fall 2001 Newsletter

Using Web Forms to access UniVerse [95k Microsoft Word doc *]
Techniques for using an Apache webserver and web forms to access UniVerse.
Article for OSDA Winter 2002 Newsletter

A UniVerse Web tool for Phantom Control [618k Microsoft Word doc *]
Documentation for SpliceWorld.
Article for OSDA Spring 2002 Newsletter

Giving UniVerse Secondary Indexes a Second Chance [521k Microsoft Word doc *]
Setting up pointers directly to the internal B-tree index files.
Article for OSDA Fall 2002 Newsletter

Fast and Cheap Multivalue ETL - leveraging Microsoft's DTS - Part 1 [908k Microsoft Word doc *]
Converting UniVerse files to flat files using SELECTs and extraction of fields from flat files by SQL Server DTS using ActiveX scripting.
Article for OSDA Summer 2003 Newsletter

Fast and Cheap Multivalue ETL - leveraging Microsoft's DTS - Part 2 [1430k Microsoft Word doc *]
Using SQL Server DTS to manage the ETL process and Perl and Shell scripts to take our multivalue data as far as normalized tab-delimited text.
Article for OSDA Fall 2003 Newsletter

* These Word documents can be viewed using Microsoft's free viewer

U2 Family Application Development - Test 713 Study Notes [96k Microsoft Word doc *]
This is a set of notes I put together from sparse information on the Internet (Test 713 Objectives/Skills Measured on Test) and cut and paste from online and Acrobat UV documentation.
Note that these notes were assembled before I took the test.
Handout for presentation to SAPUG October 16th 2003 IBM U2 Meeting

Presentations

Intranet Reporting in UniVerse
Techniques for using an Apache webserver and Unix symbolic links to leverage standard UniVerse reports.
Notes for presentation to SAPUG in Bellevue in October 1998 and to MVDBUG in Portland in February 1999.

The Five-Minute Data Mart
Analyzing large text files using Unix tools.
Notes for presentation to SAPUG in Bellevue in December 1998.

Intranet Programming in UniVerse
Unix scripts to invoke UniVerse from Apache.
Notes for presentation to MVDBUG in Portland in October 1999.

OSDA 2002 Lectures Roadmap
I gave four related talks in Tampa at the OSDA 2002 Spring Conference. This is a flowchart of the various http clients and servers and their relation to each other. Each of the lectures has a version of the map with the applicable section highlighted.

112 - Intranet Reporting in UniVerse

[map]

OSDA

122 - Web Forms in UniVerse [map]
Using a web browser to dynamically query and update UniVerse using simple CGI scripts and BASIC routines. Parsing input and URL encoding are discussed. Examples include lightweight applications to create and interact with reports.
Notes for presentation to OSDA Spring 2002 Conference in Clearwater Beach.

216 - UniVerse Process Control and Monitoring via an Intranet [map]
A web browser is an ideal client to control and monitor background processes. We can create a clean graphical representation of our PHANTOMs that gives end users a simple restricted control interface and gives IT staff status at a glance. We use more advanced CGI techniques and some HTML tricks to build this robust tool.
Notes for presentation to OSDA Spring 2002 Conference in Clearwater Beach.

222 - Using HTTP to Communicate with UniVerse [map]
There are a host of techniques for communicating with UniVerse, but HTTP is fast, free, and ubiquitous. Using HTTP to support debugging. Moving Data using HTTP with UniVerse as server. Using HTTP with UniVerse as Client. Using HTTP with UniVerse as both Client and Server. Using free software tools to extend UniVerse's HTTP capability. Where to XML and SOAP fit in?
Notes for presentation to OSDA Spring 2002 Conference in Clearwater Beach.

Using Apache to Leverage your Multivalue Database [map]
Making reports available via Apache in text, hypertext, and to spreadsheets. Interacting via web scripts. Migrating data.
Notes for presentation to SAPUG February 27th 2003 Free Software Meeting

Spectrum 2004 Lectures
I am giving two related talks in Las Vegas at the International Spectrum 2004 Conference. These presentations were test-driven at the Annual SAPUG Free Software Forum in February 2004.

The Last Mile - Integrating UniVerse with Free Software Tools

Beyond ED - Complimenting UniVerse with Free Software Tools - Powerpoint Web Presentation
Free Software Tools to make the UniVerse programmer more productive. What's in your toolbox? Mine includes free networking, web authoring, knowledge management, and configuration management tools.

Ross Morrissey


		Ross Morrissey - UniVerse Publications Reusable TRANS I-descriptor DICTionary items "We can create keys involving complex inter-relationships between files by building them from simpler keys." Article for the Geac October 1994 Service Plus Newsletter Utility to Produce HTML Pages Concise description of Intranet Reporting in UniVerse from 1996. Intranet Reporting in UniVerse [630k Microsoft Word doc ] Techniques for using an Apache webserver and Unix symbolic links to leverage standard UniVerse reports. Article for OSDA Spring 2001 Newsletter, based on presentation notes. UniVerse Intranet Access* [108k Microsoft Word doc ] Techniques for using an Apache webserver and ISINDEX to access UniVerse commands. Article for OSDA Fall 2001 Newsletter Using Web Forms to access UniVerse* [95k Microsoft Word doc ] Techniques for using an Apache webserver and web forms to access UniVerse. Article for OSDA Winter 2002 Newsletter A UniVerse Web tool for Phantom Control* [618k Microsoft Word doc ] Documentation for SpliceWorld. Article for OSDA Spring 2002 Newsletter Giving UniVerse Secondary Indexes a Second Chance* [521k Microsoft Word doc ] Setting up pointers directly to the internal B-tree index files. Article for OSDA Fall 2002 Newsletter Fast and Cheap Multivalue ETL - leveraging Microsoft's DTS - Part 1* [908k Microsoft Word doc ] Converting UniVerse files to flat files using SELECTs and extraction of fields from flat files by SQL Server DTS using ActiveX scripting. Article for OSDA Summer 2003 Newsletter Fast and Cheap Multivalue ETL - leveraging Microsoft's DTS - Part 2* [1430k Microsoft Word doc ] Using SQL Server DTS to manage the ETL process and Perl and Shell scripts to take our multivalue data as far as normalized tab-delimited text. Article for OSDA Fall 2003 Newsletter These Word documents can be viewed using Microsoft's free viewer U2 Family Application Development - Test 713 Study Notes [96k Microsoft Word doc ] This is a set of notes I put together from sparse information on the Internet (Test 713 Objectives/Skills Measured on Test) and cut and paste from online and Acrobat UV documentation. Note that these notes were assembled before* I took the test. Handout for presentation to SAPUG October 16th 2003 IBM U2 Meeting Presentations Intranet Reporting in UniVerse Techniques for using an Apache webserver and Unix symbolic links to leverage standard UniVerse reports. Notes for presentation to SAPUG in Bellevue in October 1998 and to MVDBUG in Portland in February 1999. The Five-Minute Data Mart Analyzing large text files using Unix tools. Notes for presentation to SAPUG in Bellevue in December 1998. Intranet Programming in UniVerse Unix scripts to invoke UniVerse from Apache. Notes for presentation to MVDBUG in Portland in October 1999. OSDA 2002 Lectures Roadmap I gave four related talks in Tampa at the OSDA 2002 Spring Conference. This is a flowchart of the various http clients and servers and their relation to each other. Each of the lectures has a version of the map with the applicable section highlighted. 112 - Intranet Reporting in UniVerse [map] How to use free software and no programming to provide access to legacy reports via a web browser. How small changes to existing reports can leverage the capabilities of the internet. Automatically generating reports and tracking their usage. I will share the experience of five years of using this technique in several flavors of Unix. Notes for presentation to OSDA Spring 2002 Conference in Clearwater Beach. 122 - Web Forms in UniVerse [map] Using a web browser to dynamically query and update UniVerse using simple CGI scripts and BASIC routines. Parsing input and URL encoding are discussed. Examples include lightweight applications to create and interact with reports. Notes for presentation to OSDA Spring 2002 Conference in Clearwater Beach. 216 - UniVerse Process Control and Monitoring via an Intranet [map] A web browser is an ideal client to control and monitor background processes. We can create a clean graphical representation of our PHANTOMs that gives end users a simple restricted control interface and gives IT staff status at a glance. We use more advanced CGI techniques and some HTML tricks to build this robust tool. Notes for presentation to OSDA Spring 2002 Conference in Clearwater Beach. 222 - Using HTTP to Communicate with UniVerse [map] There are a host of techniques for communicating with UniVerse, but HTTP is fast, free, and ubiquitous. Using HTTP to support debugging. Moving Data using HTTP with UniVerse as server. Using HTTP with UniVerse as Client. Using HTTP with UniVerse as both Client and Server. Using free software tools to extend UniVerse's HTTP capability. Where to XML and SOAP fit in? Notes for presentation to OSDA Spring 2002 Conference in Clearwater Beach. Using Apache to Leverage your Multivalue Database [map] Making reports available via Apache in text, hypertext, and to spreadsheets. Interacting via web scripts. Migrating data. Notes for presentation to SAPUG February 27th 2003 Free Software Meeting U2 Family Application Development - Test 713 Study Notes [96k Microsoft Word doc ] This is a set of notes I put together from sparse information on the Internet (Test 713 Objectives/Skills Measured on Test) and cut and paste from online and Acrobat UV documentation. Note that these notes were assembled before* I took the test. Handout for presentation to SAPUG October 16th 2003 IBM U2 Meeting Spectrum 2004 Lectures I am giving two related talks in Las Vegas at the International Spectrum 2004 Conference. These presentations were test-driven at the Annual SAPUG Free Software Forum in February 2004. The Last Mile - Integrating UniVerse with Free Software Tools - Powerpoint Web Presentation Real World examples using UniVerse as both http server and client to create web browser interfaces, automate and deliver reports, move data between systems. Getting data into and out of UniVerse from Unix using free tools. Beyond ED - Complimenting UniVerse with Free Software Tools - Powerpoint Web Presentation Free Software Tools to make the UniVerse programmer more productive. What's in your toolbox? Mine includes free networking, web authoring, knowledge management, and configuration management tools. Ross Morrissey