Thu, Dec
0 New Articles

Case Study: ASNA's Visual RPG for .NET

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

Wyandot, Inc. is a 69-year-old snack food producer and distributor with production facilities in Marion, Ohio, and Jeffersonville, Indiana. Wyandot used ASNA Visual RPG for .NET and Microsoft's .NET Visual Studio to create a new iSeries-based production scheduling system--in one week! This new program enabled Wyandot to avoid purchasing a $100,000 vertical software package. It also put the Wyandot IT team more directly in charge of the software that drives the Wyandot production facilities. Wyandot's new ASNA Visual RPG-based daily production scheduling system is the foundation for many new production-related software enhancements, all of which will be done in-house by the Wyandot IT team using AVR for .NET.

Wyandot, Inc. has spent 69 years as the leading private label manufacturer of salted snacks. With more than 150 million pounds of total annual capacity, Wyandot obviously ships lots of snacks in a year. To ship those millions of snacks yearly, Wyandot needs a superb production scheduling system.

Bob Shaw, Wyandot's Manager of Information Services, explains, "In the old days, with fewer production lines and less constraints on inventory levels, production scheduling didn't need to be a very sophisticated process. However, as our business matured so did our production scheduling complexities." With the capabilities of the old-time green-screen scheduling application quickly timing out, Wyandot's production scheduling process evolved into a miasma of complex Excel spreadsheets. To lift itself out of an enterprise dependency on Excel for production purposes, Wyandot turned to ASNA Visual RPG for .NET to create a Windows application that connects directly to its line-of-business iSeries.

When the Chips Are Down

With the realization that the spreadsheet-based solution required excessive manual manipulation and wasn't robust and reliable enough, Shaw and other members of the Wyandot IT team carefully pondered the unique challenges they needed a new production application to solve. The primary facilities the new production system needed to provide were these:

  • A vastly improved user interface that would ensure product scheduling correctness as well as eliminate existing redundant data entry requirements
  • A real-time, read/write iSeries connection for data validation and inventory on-hand levels
  • A direct interface with Wyandot's iSeries-based ERP package, PRISM
  • The ability to create and distribute a variety of production-related schedules and reports, by shift

Shaw and his team understood that their new application needed a rich, expressive, and friendly user interface; this translated, almost without saying, to knowing they needed a Windows graphical user interface. Explains Shaw, "All of our operators are familiar with Windows applications. We knew the green-screen couldn't provide the rich interface we needed, so the Windows GUI was simply a de facto part of our application specifications. That interface would be easy to teach and provide all the real-time error handling, data validation, and user feedback we needed."

Acquiring that rich user interface, though, could not come at the expense of a real-time iSeries connection. Wyandot is a hard-core iSeries shop; all their enterprise data is, and has been for years, iSeries-bound. Thus, in addition to the Windows GUI, their new production scheduling application needed a reliable, fast, and secure iSeries database connection.

With specifications in hand, Shaw's team turned their attention to selecting a product with which to build their new solution. ASNA Visual RPG for .NET (AVR) quickly acquired a place at the top of the list. The Wyandot team had experience with the older COM-based version of AVR, and AVR for .NET was a natural fit for them. Says Shaw, "We knew that our application needed a rock-solid interface to our iSeries platform. Through our previous experiences with ASNA, we knew its our products were a good fit for us. We've been very happy with ASNA DataGate for years." ASNA DataGate is the iSeries-based component that AVR uses to connect to the iSeries. DataGate provides Shaw's team with read/write record-level access and a superb OS/400 program call facility.

In addition to its iSeries connectivity, AVR offered other pluses to Shaw and his team. Because AVR for .NET is able to create native Windows interfaces (AVR comes with many sophisticated Windows user interface components), AVR was perfectly situated to solve two of Wyandot's biggest production scheduling issues. AVR's RPG foundation was also a good fit for Wyandot. In fact, it was AVR's RPG heritage that first attracted the Wyandot IT team to ASNA and its family of products.

"With a team of RPG programmers, it only made sense to us to use a product based on RPG," explains Shaw. He continues, "Our programmers learned AVR quickly--partly on their own, partly with ASNA's tech support help, and partly by attending ASNA's annual ASNApalooza developer conference." With AVR, Wyandot's programmers were able to quickly build sophisticated Windows applications. ASNA's simple but sophisticated approach leads the Wyandot team to enterprise solutions much faster and more affordably than using tools such as Java and WebSphere.

On to the Deliverable

The task of creating the new production scheduling system was assigned to Eric Watkins, a Wyandot programmer/analyst. Although Watkins had limited exposure to AVR for .NET, he is an accomplished programmer with five-plus years experience in RPG, Visual Basic, and COBOL. With this background and lots of enthusiasm, Watkins rolled up his sleeves and got busy. To Shaw's amazement, Watkins delivered a working version of the Production Scheduling application in just one week.

Shaw proudly says, "I was very impressed with how quickly Eric built the initial version of our new production scheduling system. He designed the user interface to nearly anticipate where a user's fingertips would be next. We had excellent user acceptance of the new application. And, because the application connects directly to our iSeries, database updates are immediate and reliable. Redundant data entry was no longer needed to keep our production schedules humming!" Watkins was also able to add the needed integration to Wyandot's ERP solution as well as use AVR's built-in print file editor to build the necessary production schedule reports. These reports are printed to Windows laser printers or directly to PDF (with all the fancy attributes a Windows laser printer provides, such as fonts and images).

Back in the Chips

Shaw is rightfully very proud of Wyandot's new production scheduling system. With Watkins' efforts and ASNA AVR for .NET, the new application was delivered on time and on target. On the business payoff of this new system, Shaw reports, "It's hard to put a dollar figure on the worth of our new production scheduling system, but I can tell you at the very least it clearly helped us avoid the cost of a $100,000 third-party product. We expect the return on investment of our new application to do nothing but grow from there." Next up for Wyandot with AVR are inventory availability checks for seasonings, packaging materials, and cartons. This includes issuing picking lists for these materials to be delivered to the finished goods packaging area.

Perhaps an even bigger measure of the short-term success of the new production scheduling system is the longer-term foundation it lays for Wyandot. Because Shaw's team maintains complete control over the system, it provides the foundation for future enhancements such as identifying upcoming inventory problems, targeting labor requirements, and determining packaging needs. These things are all now easily within reach of the Wyandot IT team because ASNA AVR puts them in control.

About ASNA

Established in 1982, San Antonio-based ASNA (Amalgamated Software of North America) develops and markets unique software products that evolve IBM AS/400 and iSeries/i5 systems. Aligned with Microsoft’s .NET initiative, ASNA is the only company to offer a thoroughly conceived, standards-based extension and migration path that solves its customers' business challenges.

Most recently, ASNA joined Microsoft in founding the Midrange Alliance Program, a strategic initiative to help enterprises worldwide reduce the risks and high cost of maintaining, extending, and migrating aging IBM midrange systems. The alliance establishes the technical foundation for these enterprises to move efficiently to .NET and includes ASNA products as cornerstone enabling technologies. For more on the Midrange Alliance Program, click here.

Roger Pence is education director for ASNA, an application developer tools company, where he focuses on helping customers build browser- and Internet-based line-of-business iSeries applications. Roger has spent many years writing and speaking about the iSeries.


9901 West IH-10, Suite 1000
San Antonio, Texas 78230
Web: www.asna.com
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Tel: 800.289.ASNA (x2762) or 210.408.0212
Fax: 210.408.0211



Support MC Press Online

$0.00 Raised:

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: