Excel-erator

Excel-erator is an i5/OS based software utility that converts i5/OS database files into spreadsheets in Microsoft's Excel format. The resulting PC files are either placed into any directory in i5/OS's Integrated File System or sent as an attachment to an email. With Excel-erator you can make i5/OS data available to your users in the form best suited to them. Example conversion from i5/OS's host services file.

Excel-erator converts database files into spreadsheets in Microsoft's Excel format. Excel-erator supports the following database files:

• Physical files
• Logical files with a single record format

There are two commands that provide the conversion:

• Copy To Excel (CPYTOEXCEL)
• Send File Excel (SNDFEXCEL)

The Copy To Excel (CPYTOEXCEL) command takes a database file and an Integrated File System object (PC file) name as input. The file's contents are converted into a spreadsheet in Microsoft's Excel format. The converted file is then placed in the requested Integrated File System object (PC file).

By specifying the correct Integrated File System name you can place the generated file in any file system known to i5/OS including writing directly to Windows systems on the network, another System i, Novell NetWare or NFS servers.

The Send File Excel (SNDFEXCEL) command takes a database file and an email address as input. The file's contents are converted into a spreadsheet in Microsoft's Excel format. The converted file is then emailed to the requested recipient using i5/OS's built-in mail support. i5/OS delivers the mail in the manner appropriate to the recipient's mail client. The spreadsheet arrives as a MIME attachment to an email message.

When sending the email, you have a wide variety of options to tailor the delivered message to your specific needs. Addressing includes multiple recipients, copy recipients and blind copy recipients. Additionally, you can include multiple Reply-To: addresses as well as specify the email address the message appears to come from. Delivery confirmation by read receipt can also be specified.

Commands to help you trouble shoot and, optionally, automatically configure i5/OS to send mail are also included with the product.

Both commands support:

• Field selection and ordering
• Selecting column headings from the file's field names, aliases or column headings (or *NONE)
• Control over column heading format including alignment, borders background pattern, bolding, etc.
• Addition of print header and print footer
• Selection of font typeface
• Addition of comments to cells
• File sharing settings including password protection and encryption
• Control over the color palette included in the spreadsheet

Gumbo's products include a range of standard features that make them easy to use, easy to manage, and easy to live with:

• Extensive manual, both online as menu option 1 and in PDF (See downloads page).
• Context sensitive help for every command and parameter.
• Menu that provides organized access to the product's features.
• Products are packaged as licensed programs and participates in the full range of support provided by i5/OS. Licensed program installation, PTF management, etc. are handled with the same commands used to manage IBM^® software.
• Unlike IBM^® Licensed Programs, our products are packaged to allow multiple releases to be installed at the same time which facilitates new release testing.
• Product PTFs are available on the web.
• Our products include a hot site friendly automatic authorization function that allows you to immediately move operations to any back up or fail over machine without contacting us for a license key or authorization code.
• We include a Check Product Authorization (CHKPRDAUT) command that allows you to exercise the product's authorization algorithm and insure there are no authorization "surprises".
• An installation verification option is available on the menu. You can easily verify that the product is correctly installed.
• All (applicable) objects in our products are digitally signed allowing you to verify their integrity. Modifications that could jeopardize the security of your system are easily detected with i5/OS's Check Object Integrity (CHKOBJITG) command.
• Our products are upward compatible with future releases of i5/OS. You can install a new releases of i5/OS without installing a new release from us.
• Our products are compatible with all i5/OS security levels. We use only published interfaces.

For additional information see: Answers to the most frequently asked general product questions.

The current release of Excel-erator operates on any model System i with i5/OS Version 5 Release 2 or higher. See the download page for availability for earlier releases of i5/OS.

A fully functional 30-day trial of the product is available for immediate download. Or you can fill out a Demo Request to receive it in the mail. In either case, there is no obligation. To receive an invoice, fill out an Invoice Request.

Gumbo Software, Inc. offers two choices for licensing our software products for your System i, system wide licensing and partition licensing. These are mutually exclusive. A system wide license applies to a specific System i serial number and processor group and is good for any and all partitions in the system. A partition license applies to a specific System i serial number, partition number, and maximum processing capacity, and is not valid for a system that has not been partitioned. For the overwhelming majority of our customers, a system wide license (> 98%) is the best choice. A partition license (< 2%) is the best choice in very limited circumstances involving small partitions on large machines.

The system wide license prices for all of our products, with the exception of Report Designer, are tiered based on your System i's processor group. You can determine your machine's processor group by running the i5/OS Work with License Information (WRKLICINF) command.

The partition only license prices for all of our products, with the exception of Report Designer, are based on the maximum processing capacity configured for the partition (rounded up to the nearest tenth). You can determine your partition's maximum processing capacity by running the i5/OS Start System Service Tools (STRSST) command and taking option 5 "Work with system partitions" then option 1 "Display partition information" then option 2 "Display partition processing configuration".

Additional processor group information can be found on our Processor Group page. The one time charge includes the first  year of maintenance services. You are purchasing a permanent license to use the software subject to the terms of a license agreement and upgrade policy.