08
Tue, Oct
2 New Articles

How to Implement Event Notification Triggers

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

Using event notification triggers is a smart, simple, cost-effective way to improve productivity.

 

The concept behind event notification triggers is fairly simple. As the name suggests, the goal of implementing event notification triggers is to provide "notification" to someone when a significant business "event" occurs. This is a proactive means of "pushing" information from the system. This may come in the form of a simple email message. However, the benefits of a simple message are limited.

 

The challenges are to make it flexible enough to meet the needs of virtually any event, to include intelligent information from your enterprise systems, and to make it technically simple enough for it to be cost-effective to implement anywhere within your enterprise systems. In this article, we will explore what it takes to implement event notification triggers.

 

Consider your situation. Your company has an integrated system that collects accurate information in real time in the key functional areas of your business. This is a great accomplishment. Yet you look around and see that human-intensive manual processes are happening everywhere every day. This should make you think. Is your system providing value only for financial reporting and business analysis? Don't get me wrong. These are critical aspects of any business. But since you have this great system in place, why not provide real-time value to the areas that keep your business running on a day-to-day basis?  Event notification triggers are a simple way to begin.

 

Hopefully, you noted this above, but just to be sure, here is a simple description of an event notification trigger: When a significant business event occurs, notify the appropriate people with the information necessary to take action (or for informational purposes only).

 

Here are a few examples to get you thinking:

•·      A transaction has caused the available inventory quantity on a critical product to drop to zero. Notify the materials manager with the item number, description, date, time, and an intelligent message.

•·      Your normal delivery time for stock products is within 48 hours, but an order has been accepted that requires same-day delivery. Notify picking and shipping with the order number, customer name, item number, description, quantity, and a PDF attachment of the order or pick slip.

•·      Consider a workflow example. A requisition has been entered. Based on its dollar value, it must be approved by a manager. Notify the manager that a requisition is pending approval. Once approved, notify the buyer to convert it to a purchase order. Once the purchase order is created, notify the requisitioner of the PO number and expected delivery date. Once the item is received, notify the requisitioner that it has been received.

 

Contrast these examples with the way things are happening now. You get nightly (next morning) reports of products with available inventory quantity of zero, and then you take action. When an order is taken for same-day delivery, your order entry person walks the order or pick slip out to shipping or calls shipping with this information. The list of examples abounds across departments. Only by working with the people who do the job daily can you determine what benefits will come from having the knowledge in real time.

 

OK, now that I've got your mind going, let's work through building the architecture necessary to make this work. There are just a few setup tasks, a relatively simple database, and three programs (functions) that perform all of the work.

 

Setup

Setup requires three things:

•·      Access to an email server--Any area of your system that will be allowed to trigger an event notification must have access to an email server. On the System i, set up the SMTP email service.

•·      Access to a disk location for attachments--Standard (reusable) attachments must have an accessible place to reside so that the event messages can use them.

•·      Tool to generate PDF documents--Any spooled file to be sent can be placed into a dynamic email attachment once it is converted to a PDF.

Database

Here's what you'll need for your database:

•·      Event master file--Define the event with an accurate business description.

•·      Message file--Define the text of the message, the format, and the variable data to be included.

•·      Distribution list file--Define the list of people to receive the message.

•·      Attachment file--Define the location of the attachment(s) to be included.

•·      Event notification trigger file--Tie all of the above pieces together (event, message, distribution, attachment).

 

Figures 1 and 2 below show what your database structure and file layouts should be.

 

121008GleisnerFigure1-20081125.JPG

Figure 1: Your database should be structured like this. (Click images to enlarge.)

 

 

    FILE   : XAMEEP               Event Master               

    LIBRARY: MC@EDDF                                      

    FORMAT : XAMEEP               Event Master                

                                                   

  DEC    

    FIELD NAME  FIELD DESCRIPTION                FROM     TO    LEN TYP POS    

    ----------  ------------------------------  -----  -----  ----- --- ---    

    ENEVNT      Event Identification                1     10     10  A      

    LANG        Language Code                      11     13      3  A   

    ENEVDS      Event Description                  14     63     50  A      

    ENEVED      Event Extra Description            64    113     50  A         

    USRX        Created/Updated by User           114    123     10  A        

    CYDX        Date Created/Updated              124    131      8  S   0   

    TIMX        Time Created/Updated              132    137      6  S   0   

    FILE   : XAMEMP               Event Message Master                       

    LIBRARY: MC@EDDF                                                  

    FORMAT : XAMEMP               Event Message Master                        

                                                                

DEC    

    FIELD NAME  FIELD DESCRIPTION                FROM     TO    LEN TYP POS    

    ----------  ------------------------------  -----  -----  ----- --- ---    

    ENMSID      Message Identification              1     10     10  A     

    LANG        Language Code                      11     13      3  A    

    ENMSSQ      Message Sequence                   14     15      3  P   0   

    ENMSTX      Message Text                       16     85     70  A     

    ENEOLN      Message End-of-Line Indicator      86     86      1  A         

    USRX        Created/Updated by User            87     96     10  A         

    CYDX        Date Created/Updated               97    104      8  S   0     

    TIMX        Time Created/Updated              105    110      6  S   0     

    FILE   : XAMEAP               Event Notification Attachments               

    LIBRARY: MC@EDDF                                                    

    FORMAT : XAMEAP               Event Notification Attachments               

                                                                 

DEC    

    FIELD NAME  FIELD DESCRIPTION                FROM     TO    LEN TYP POS    

    ----------  ------------------------------  -----  -----  ----- --- ---    

    ENATID      Attachment ID                       1     10     10  A     

    ENATLN      Language Code                      11     13      3  A     

    ENATSQ      Attachment Sequence                14     15      3  P   0    

    ENATPT      Attachment Path (IFS)              16     85     70  A        

    ENATFN      Attachment Filename                86    155     70  A        

    USRX        Created/Updated by User           156    165     10  A         

    CYDX        Date Created/Updated              166    173      8  S   0     

    TIMX        Time Created/Updated              174    179      6  S   0     

    FILE   : XAMELP               Event Distribution List Master               

    LIBRARY: MC@EDDF                                                   

    FORMAT : XAMELP               Event Distribution List Master               

                                                                

DEC    

    FIELD NAME  FIELD DESCRIPTION                FROM     TO    LEN TYP POS    

    ----------  ------------------------------  -----  -----  ----- --- ---    

    ENDLID      Distribution List Identifier        1     10     10  A         

    ENDLSQ      Distribution List Sequence         11     12      3  P   0     

    ENDLTY      Distribution List Type             13     15      3  A         

    ENMAIL      Email Address                      16     65     50  A    

    LANG        Language Code                      66     68      3  A    

    USRX        Created/Updated by User            69     78     10  A         

    CYDX        Date Created/Updated               79     86      8  S

Bob Gleisner

As a Director of Professional Services at LANSA, Bob Gleisner draws on over 25 years experience working with a variety of IBM midrange systems across a wide range of industries. Bob has extensive experience with the LANSA suite of products and manages the LANSA Enterprise Systems (ERP) practice. He has worked with a variety of LANSA customers including Morton Salt, Kawasaki, Motta International, Carlisle Foodservice Products, and TimeMed Labeling. He's a frequent speaker at various industry events, including COMMON, and has authored numerous articles. You can contact Bob at This email address is being protected from spambots. You need JavaScript enabled to view it..

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: