Using SmartWare Plus to Build the Integrated Office
Linux has made great inroads into development environments, become a good X terminal, and been used in embedded applications. However, to seriously penetrate the office market, Linux needs to not look like Linux. That is, when the average office user sits down at his system, he needs to see a means for accomplishing a clerical task, not a Unix or Linux command prompt.
There are ways to address this problem with available tools. Caldera has developed a desktop and applications suite. Others, such as Dr. Greg Wettstein of the Roger Maris Cancer Center, have built their own solutions using languages such as Perl and Tcl/Tk. Here at SSC we use the Progress database (now running on Linux) and then use external Linux tools (such as vi and groff) to do the support functions. Angoss offers another alternative with SmartWare Plus.
SmartWare Plus is an integrated office environment that includes a database, spreadsheet, word processor, and more. Also included is a Rapid Application Development System that allows you to write custom applications that use the features of the various SmartWare packages in an integrated fashion.
SmartWare has been around for quite a while and boasts over half a million users worldwide and over 600 software developers. SmartWare is available for MS-DOS and Xenix and has been very popular for use in local governments.
To get an idea of what you might do with SmartWare, think about an average office—say a dentist's office. You would need a system that allowed scheduling of patients, ordering supplies, patient billing, time management and letter writing.
You could train the receptionist (who probably also does billing, orders supplies, and probably most everything else in a small office) to use a word processor, a spreadsheet, an appointment manager and a database—but this would mean s/he would have to learn how to use all these programs, as well as how to use the operating system to load the different programs and move information between them.
One solution would be to purchase an integrated package, but you are in trouble if this package doesn't do exactly what you need it to right out of the box. A vendor of mass-market software is not going to make the changes you need or give you the source code so you can do it yourself.
With SmartWare, you can write the necessary spreadsheets, develop the scheduling and accounting software using the database, and then, using the Rapid Application Development (RAD) system, tie it all together so everything can be accessed from a single menu: Figure 1..
SmartWare also includes some utilities such as file copy, erase, and print that insulate the user from the operating system. While I don't get excited about a menu option to copy a file Figure 2. , menus do allow the user to accomplish tasks without even knowing what operating system is under the hood.
The advantages of using the SmartWare Plus package are:
The same applications work under X-Windows and in character mode.
Applications are portable between platforms/operating systems.
All the necessary packages are integrated into one consistent package.
But, you pay a price for this. The disadvantages I see are:
No source code for the system itself.
The SmartWare user interface, while consistent among the different pieces of the package, is not consistent with other Linux/X applications.
Another important consideration is data security. Internal concerns need to be considered, such as access to payroll records, as well as mandated protection of confidential client records. Within the RAD system you can limit access to any application and thus any data.
Looking under the hood there is much more to SmartWare Plus than simply offering a GUI-based development environment. Also included is the SmartWare Programming Language—a complete programming environment containing standard structured programming constructs, over 200 commands and 300 built-in functions, multi-dimensional arrays and lots more. Thus, much can be done directly using the GUI-development tools but there is something under the hood if you need to do some serious programming.
When I first looked at this package I had a few misgivings concerning the installation procedure. The people at Angoss addressed them, but to be sure that the installation made sense, I asked Carlie Fairchild to give it a try. This is the result.
I then handed a copy to Bryan Phillippe, a systems technician at Zebu, a company related to SSC that produces Linux-based firewall systems. Bryan said, “SmartWare comes as a dynamically linked ZMAGIC a.out binary, tarred onto floppies. It installs easily for anyone with Unix experience, although the installation instructions themselves had some mistakes that might prevent a newbie from being able to install by following the instructions verbatim.”
Once he had the product installed, Bryan started doing some development. The “Working with SmartWare Plus” Sidebar contains the remainder of Bryan's comments about the system. Figures 3 and 4 show the database screens he has developed so far. Figures 5 and 6 show the word processor and its spell-check mode, respectively.
- Three More Lessons
- Django Models and Migrations
- August 2015 Issue of Linux Journal: Programming
- Hacking a Safe with Bash
- Secure Server Deployments in Hostile Territory, Part II
- The Controversy Behind Canonical's Intellectual Property Policy
- Huge Package Overhaul for Debian and Ubuntu
- Shashlik - a Tasty New Android Simulator
- Embed Linux in Monitoring and Control Systems
- General Relativity in Python