Businesses are inundated with reports, but turning that data and information into knowledge and value can be difficult. Managers and analysts want the ability to perform value-enhancing activities—such as sorting, searching, and performing "what ifs"—against the data quickly and easily. These tasks are best performed with spreadsheets, not reports. The challenge for Eljer, Inc. was to find a way to transfer data in existing spooled reports into Excel spreadsheets, where it can provide the greatest value for the company. Eljer now meets that challenge with SpoolFlex from DRV Technologies, Inc.
Founded in 1904, Dallas, Texas–based Eljer, Inc. is a leading manufacturer of residential and commercial plumbing products, with sales of approximately $150 million. Its products include toilets, bathtubs, sinks, lavatories, whirlpools, bidets, shower bases, and commercial restroom fixtures. Previously owned by Jacuzzi Brands, Eljer is now a private company owned by an affiliate of Sun Capital Partners.
Eljer uses System i servers for most of its IT requirements. Its ERP software includes many useful reports, but the company needed to give users a way to work with the data in those reports in order to increase its value. Eljer considered a PC-based package that would fulfill the requirement, but the cost was too high. A separate license would have been required for each user who needed the functionality. What's more, those users would have required training in the new software. Eljer wanted to avoid those training costs by allowing users to employ a tool they were already familiar with, Excel.
In Search of an Easier Way
As at all but the smallest of companies, audits are a fact of life at Eljer. In addition to regular internal financial audits, it must also occasionally submit to bank, municipality, and other tax audits, not to mention the SOX audit that was necessary until it became a private company. Most of the data that auditors need is available in the ERP-generated reports, but auditors don't want printed data or even electronic copies of reports. They insist on receiving data in spreadsheet form. Eljer wanted a way to meet this requirement without having to write customized programs to extract and convert the necessary data.
Mike Gleason, director of IT at Eljer, kept his eye out for a solution. One day, an ad for SpoolFlex arrived in the mail. Gleason checked it out and found that SpoolFlex would easily meet his needs at an affordable cost. SpoolFlex V3 allows complete reports or selected pages to be converted to any e-format, including Excel (XLS), Acrobat (PDF), plain text (TXT), rich text format (RTF), comma-separated values (CSV), HTML, and XML. The resulting files can be emailed, printed, faxed, or placed directly on a System i server.
Some products that claim to generate spreadsheet files offer only CSV format for that purpose. If the file is set up properly, Excel can perform the conversion, but the process is not foolproof and typically requires manual formatting and close examination for conversion errors. SpoolFlex's support for native Excel format (XLS) automates the conversion and makes the results available for immediate use without errors.
Eljer appreciates the fact that SpoolFlex is resident on System i. "In a small IT shop like ours, it's paramount to be on the 400. If the data is on one box, I want all of the tools on the same box." That reduces the number of skills required and eliminates the need for cross-platform interfaces.
Gleason found SpoolFlex easy to install. "DRV support was phenomenal. When I had a question, I connected with the support guy through a Web meeting and he answered it quickly. That saved us a ton of time."
SpoolFlex is also simple to learn. "There are a lot of wizards that make it very easy," explained Gleason. "DRV just walked me through it once, and I was able to use it after that."
Saving Time Across the Board
To provide users with Excel files from spooled data, Gleason creates a SpoolFlex definition. Within the first few days of installing the software, he had four or five definitions up and running. The company now has about 15 definitions. When users want an Excel file, they go to SpoolFlex and select what they want from a drop-down menu of available spool files. Then SpoolFlex emails it to them. Using the same process, creating Excel files for auditors is equally easy.
Eljer has received substantial tangible benefits from SpoolFlex. For example, one person in the credit department used to key data from a weekly report into a spreadsheet—a task that took about eight hours. Now it takes him about three minutes to get the spreadsheet directly from SpoolFlex.
SpoolFlex has also allowed Eljer to eliminate considerable tedious programming. "The reports we have are good; they just weren't in the format our users wanted," said Gleason. "With SpoolFlex, if we already have a spool file, we don't have to spend any money rewriting the reporting programs to create the spreadsheets."
SpoolFlex provided Eljer with a benefit that Gleason wasn't expecting. He originally installed it solely to create Excel files, but then he learned that it could also produce PDF output. Eljer runs five e-commerce sites. It now uses SpoolFlex to present customers with purchase orders and invoices in PDF format through the Web. This has increased the value that customers receive from the e-commerce sites.
The Bottom Line
The bottom line for Eljer is improved productivity for users and the IT department, more valuable data, and enhanced customer satisfaction. "In all my years of IT, moving data out of the 400 and into Excel or Access, where users can make better use of it, was the last piece of the puzzle," concluded Gleason. "SpoolFlex makes that migration fast, easy, and affordable."
See below for DRV Technologies' contact information.
Joel Klebanoff is a consultant, a writer, and president of Klebanoff Associates, Inc., a Toronto, Canada-based marketing communications firm. Joel has 25 years experience working in IT, first as a programmer/analyst and then as a marketer. He holds a Bachelor of Science in computer science and an MBA, both from the University of Toronto. Contact Joel at
DRV Technologies
3250 Peachtree Industrial Boulevard
Suite 105
Duluth, Georgia 30096
USA
Web: www.drvtech.com
Email:
Tel: 678.417.1521 or 866.378.3366
Fax: 678.417.1521
Joel Klebanoff is a consultant, writer, and formerly president of Klebanoff Associates, Inc., a Toronto-based marketing communications firm. He has 30 years' experience in various IT capacities and now specializes in writing articles, white papers, and case studies for IT vendors and publications across North America. Joel is also the author of BYTE-ing Satire, a compilation of a year's worth of his columns. He holds a BS in computer science and an MBA, both from the University of Toronto.
MC Press books written by Joel Klebanoff available now on the MC Press Bookstore.
 |
||
 |
|
BYTE-ing Satire Find out the hilarious answer to the eternal question: "Is technology more hindrance than help?" List Price $14.95 Now On Sale
|
More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.
TRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now! Request Now.
Forms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.
Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online