05
Sat, Oct
2 New Articles

Case Study: ASNA Visual RPG

Case Studies
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times
Celebrating its 100th year in business in 2002, the Wasserstrom Company has obviously learned how to make its customers happy. Over the course of those 100 years, the Wasserstrom family has built a small family business into the nation's second largest smallwares distributor and equipment fabricator for the food service industry. Wasserstrom operates seven state-of-the-art custom wood and metal manufacturing facilities and seven state-of-the-art distribution centers.

Companies don't get to be 100 years old by accident. It takes lots of care and diligence. And to Wasserstrom, that care and diligence is all for its customers. Wasserstrom excels by tailoring itself to meet each customer's special needs. When the company was just starting, Orville and Wilbur hadn't yet gotten the Kittyhawk airborne. But today, Wasserstrom uses technology to ensure its customers' complete satisfaction. As an early adopter in technologies such as bar coding, scanning/electronic data interchange, and computerized order entry, Wasserstrom has always been on the leading edge. Today, Wasserstrom's use of the Web is also leading edge. Wasserstrom uses the Web to tailor fully its solutions for its customers--around the clock!

To the Web with ASNA Visual RPG (AVR)

"We needed a Web-based e-commerce site that offers customized product catalogs (with full shopping cart capabilities) for our regular customers as well as the general public," says Wasserstrom's Senior Programmer/Analyst, Bill Deady. "I'd used ASNA Visual RPG for some Windows projects. After reading some of the articles at ASNA's Web site regarding AVR Web development, curiosity got the better of me and I decided to give AVR a chance for our new Web project." Until Bill got involved in the project, the Wasserstrom e-commerce Web site was developed and maintained by a third party. While it was serviceable, it didn't provide all the features Wasserstrom needed, and it wasn't maintainable in house.

Bill is a long way from the typical Web developer. When he started working on the Wasserstrom e-commerce site, he had no experience with Web development technologies. Zero. Zip. Nada. He explains, "Prior to this project, I was primarily a green-screen programmer. Our environment is mostly green-screen AS/400 applications, so interesting opportunities like this don't occur much. I had dabbled with AVR and Visual Basic, but nothing too extensive. However, after following the examples in the ASNA AVR Smarties for the Web manual (available at http://support.asna.com/kb/documentation/), I saw how easy it was to create Web pages that interact with our business data."

A Demanding Specification

The new Wasserstrom e-commerce site had several very specific requirements. Its most notable immediate needs were:
-- to provide tailored product catalogs for customers.
-- to validate credit cards.
-- to not only let a customer enter an order, but also track an order's progress and status-in real time. This process needed to clearly report all back-orders and other potential trouble spots.
-- to provide shipment tracking and tracing.
-- to be able to connect not only to the primary Wasserstrom AS/400 database, but also to some third-party data stored in Microsoft SQL Server.

The Wasserstrom site would be hosted on a Windows NT Server and connect to Wasserstrom's primary AS/400 data server.

Bill's first step towards creating the Web site was to build a prototype. He'd just done enough Web work with AVR to get intrigued; he knew he had miles to go if he was going to create a modern e-commerce site. "I started by creating a mock-up of our existing site. Within a short time, I was able to develop some Active Server Pages (ASP) with AVR that mimicked portions of our existing site. With the knowledge and confidence that I really could build the project with my RPG skills and AVR, I set into motion selling it internally. I had to demonstrate that I could develop our e-commerce solution with AVR. Because Bill had some positive experience with ASNA's AVR, he didn't even consider any other development tools.

The Green Light

Bill's prototype got management's attention and they gave him the go-ahead to start creating the new Web site. Now, remember, Bill didn't have any Web development experience under his belt. Bill recalls, "I was the sole programmer on this project. I had support from various members of our advertising and sales departments; I needed them to provide the images, including the thumbnails, and to help with data entry to create the custom catalogs.

Bill's biggest challenges building the Web site weren't AVR-related. With AVR's language rooted in RPG, all Bill needed to do with AVR was to put his existing RPG skills to work. Bill's bigger challenges came with the tangential technologies the Web requires. He says, "I worked very hard to learn HTML, style sheets, and DHTML in as short a time as possible. The Internet was an invaluable tool for learning about these technologies." One especially helpful Web site is http://www.w3schools.com. It provides tutorials on virtually every Web-related technology.

"I faced a variety of challenges as I began to build the site. Figuring out how to code the expanding/collapsible menu for the catalog table of contents was especially challenging. This took lots of Web research and looking at quite a few other sites using collapsible menus.

Another big struggle for Bill was cross-browser support for his application. Making the pages look identical in both Microsoft's Internet Explorer and Netscape's Navigator took lots of testing. Bill spent lots of time learning the subtle differences of each browser.

As Bill's site started coming together, he realized he needed help in one big area: he needed help to improve the appearance of the Web site. Late in the project's cycle, an outside Web designer was contracted to help Bill spiff up the site. "This portion of the project took about six weeks. I sure learned a lot, though. I got to the point during the process where I was able to anticipate the changes the Web designer would suggest next."

Data Is the Key

To improve response time with Wasserstrom's highly normalized AS/400 database, the bulk of the shopping catalog data was stored in an ASNA Acceler8DB database on the Windows 2000 Server. A server-side Windows-based AVR program was written to update pricing and other item information on the local database on the Windows NT Servers each evening. Even with this cached data, real-time database access to the AS/400 is performed for each order. The AS/400 performs real-time item availability and performs tax calculations. The AS/400 is also accessed for shipping status and shipping tracking numbers.

In the final stages of the project, Bill tackled credit card authorization and shipment tracking. For credit card authorization, he used SkipJack Merchant Services (http://www.skipjack.com). "Most of the SkipJack examples were written in C++ but a few were provided in Visual Basic. I was able to translate those calls to AVR with a little diligence and hard work. Ultimately, getting the credit card authorization process working with AVR and SkipJack's API was easier than I had anticipated," says Bill.

Order tracking was also a key part of the project. Bill explains, "I wanted to be able to display the status, including shipping and tracking info, for all outstanding orders. If the order had been shipped, I wanted to group the tracking numbers together for a convenient user display. Both UPS and FedEx offer the ability to link to their sites by passing tracking numbers. With the tracking numbers stored on our PC, creating the links to the UPS and FedEx sites with AVR was a relatively simple process."

In Retrospect

As Bill looks back on the project, he ponders what he would have done differently. "I would have optimized the design of the main catalog database for a multi-tiered application. Because our Web project is constantly evolving and acquiring features, I'm pretty sure I'll get around to this chore someday.

"I also wish I had considered using HTML frames for the Web site. That would make it unnecessary to load the menu code on every page of the catalog display. Again, I'll probably get to that sometime in the future."

Just What the Doctor Ordered

Bill's first pass at creating the AVR-powered Wasserstrom e-commerce site is an overwhelming success. The advantages it offers Wasserstrom includes being able to:

-- Host their Web site, which interacts directly with their AS/400, without any third parties involved.
-- Maintain the site and create new features on an as-needed basis-without expensive and procrastinating third-party contractors.
-- Directly apply Wasserstrom business knowledge, through Bill, to the Web site. With the AVR-powered site, Wasserstrom can react faster and more knowledgably to keep their Web site current and effective.

Today, customers are able to place orders with Wasserstrom's site at virtually anytime of the day or night (at least half the current orders are placed outside of normal business hours). Customers can make secure credit card payments easily and they can quickly track the shipping status of their orders.

"I've had no formal training for Web site development. Everything I've learned, I learned on the job, at the keyboard! I couldn't have done this project without AVR. It let me put my data access skills to work and put my learning cycles to work on other phases of the project," Bill says. You can see Bill's finished product at http://www.wasserstrom.com.Wasserstrom viewed 2002 not so much as its anniversary, but the opportunity to start the second 100 years of successful business. With Bill Deady and AVR, Wasserstrom is clearly poised for that second 100 years.

Download a FREE trial of ASNA Visual RPG now!
http://www.asna.com/downloads.asp

Roger Pence is ASNA's education director. Prior to joining ASNA three years ago, Roger worked for many years as a journalist, speaker and technical editor in the AS/400 community.

http://www.mcpressonline.com/articles/images/2002/Wasserstrom%20case%20study%20for%20Feb.%2024,%20200300.jpg

ASNA
14855 Blanco Road, Suite 300
San Antonio, TX 78216
U.S.A. 800-289-2762
Europe +44 (0) 1483 570666
This email address is being protected from spambots. You need JavaScript enabled to view it.
http://www.asna.com

ROGER PENCE

Roger Pence is ASNA's Product Evangelist. Roger has been in the IBM i midrange community for so long that Elvis was alive when he started. He has been with ASNA since 2000. Prior to joining ASNA, Roger was a technical editor for NEWS/400 and the author of the 400/Group's AS/400 and Windows newsletter.

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: