04
Mon, Nov
5 New Articles

Case Study: DRV Technologies' SpoolFlex

Case Studies
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

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 This email address is being protected from spambots. You need JavaScript enabled to view it..

http://www.mcpressonline.com/articles/images/2002/DRV-Elje00.png
DRV Technologies
3250 Peachtree Industrial Boulevard
Suite 105
Duluth, Georgia 30096
USA
Web: www.drvtech.com
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Tel: 678.417.1521 or 866.378.3366
Fax: 678.417.1521

Joel Klebanoff

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 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

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More 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.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY 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.

  • SB HelpSystems ROBOT GenericForms 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.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA 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:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA 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.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra 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: