Transcript ECA Basics & More - Brightlight Solutions

ROI Systems, Western Region User Group
November 2001
ECA Basics & More
Manage 2000 6.5C SP6
presented by
Don Luoto
Powerwave Technologies
[email protected]
THE POWER IN WIRELESS™
Agenda
ECA – what is it?
Setup
Workshop – ECA.BUILD
How does it work?
Tables for referencing contacts
ECA.SCAN - demo
Reports & Debugging
Advanced stuff
Q&A
Don Luoto November 29, 2001
Page 2
THE POWER IN WIRELESS™
ECA – What It Is, What It Does
What it is.
– “…. The slickest thing from ROI since CTO on release 6.2.”
– …. A great tool for management and users.
–
–
–
Event
Condition
Action
What it does.
– Monitors data activity in Manage 2000.
 Create, delete, change, read.
– Notifies someone based on a triggered event.
 Email, FAX, pop UP message, action.1 record.
Don Luoto November 29, 2001
Page 3
THE POWER IN WIRELESS™
ECA Setup
ECA.AGENT.CTLS
– Phantom process that looks for unprocessed ECAT
(transaction) records.
– One phantom process per account (MAIN,TRAIN,etc).
– Uses, 1 M2K license and 0 IBM/U2 (Unidata) license per
phantom.
MONITOR.CONTROLS (optional)
– Add for each user so that ECA processing can be
monitored. Standard MONITOR.OPTIONS.
 ECA.ALERT.01
INBOX
 ECA.ALERT.01
STOPPED
 ECA.ALERT.03
ERROR
 ECA.SUM.01
AGENT SUMMARY STATUS
Don Luoto November 29, 2001
Page 4
THE POWER IN WIRELESS™
ECA Setup – ECA.AGENT.CTLS
Don Luoto November 29, 2001
Page 5
THE POWER IN WIRELESS™
ECA Setup – CONTACTS
CONTACTS
– All ECAs require the setup of a contact in order to send
an email of any kind.
 M2K email
 Intranet email
 External internet email
– Required fields for email
 Screen 1 - Record ID, Name, File
 Screen 2 - Type = EMAIL
 Screen 2 - E-Mail = [email protected]
 Screen 2 - Auto Notify = Y
Don Luoto November 29, 2001
Page 6
THE POWER IN WIRELESS™
ECA Setup – CONTACTS, Screen 1
Don Luoto November 29, 2001
Page 7
THE POWER IN WIRELESS™
ECA Setup – CONTACTS, Screen 2
Don Luoto November 29, 2001
Page 8
THE POWER IN WIRELESS™
ECA Workshop – Starting Simple!!!!
Objective
– Create an ECA to notify via email when a new part is added
to the item master.
ECA.BUILD
– Screen 1 – Define the ECA and related files and functions
– Screen 2 – Create and format the output notification
– Screen 3 – Define the EVENT & ACTION
Don Luoto November 29, 2001
Page 9
THE POWER IN WIRELESS™
ECA Workshop – ECA.BUILD screen 1
Don Luoto November 29, 2001
Page 10
THE POWER IN WIRELESS™
ECA Workshop – ECA.BUILD screen 2
Don Luoto November 29, 2001
Page 11
THE POWER IN WIRELESS™
ECA Workshop – ECA.BUILD screen 2
Screen 2, Prompt 12 – Body, in full screen edit mode
\EDP
Don Luoto November 29, 2001
Page 12
THE POWER IN WIRELESS™
ECA Workshop – ECA.BUILD screen 3
Don Luoto November 29, 2001
Page 13
THE POWER IN WIRELESS™
ECA Workshop – Test it with ITEMS
Test the ECA by entering a new part in ITEMS.
Don Luoto November 29, 2001
Page 14
THE POWER IN WIRELESS™
ECA Workshop – Resulting Email
Resulting
Manage 2000
Email
(The body of an
Outlook email
should be
identical)
Don Luoto November 29, 2001
Page 15
THE POWER IN WIRELESS™
How does it work? Notes on Basic Function
Most M2K transactional functions have code in the
controlling program that call the ECA.UPDATE
program. i.e. SO.ENTRY is run by program SOP111.
If function is a data update such as ITEMS, then the
controlling program MT500 calls ECA.UPDATE
program.
The ECA.AGENT.CTLS does NOT have to be running
to have records written to the ECAT file.
The ECAT (transaction) file creates 1 record for
every notification that is attempted.
– A single ECA triggered event that is sent to 5 people will create 5
ECAT records.
Don Luoto November 29, 2001
Page 16
THE POWER IN WIRELESS™
How does it work?
SOURCE
USER
“hooks” in program
trigger ECA test
MT500
(program)
ITEMS
(function)
Create Part Number
EVENT
(basic functionality)
IM
IPL
ECA.UPDATE
(program)
ECAT
(transactions)
Unprocess
ed
Processed
& set to
Purge
ECA.AGENT.CTLS
(phantom process)
RECIPIENT
Receives
notification
ACTION
Don Luoto November 29, 2001
email
VSI Fax
M2K Alarm
Action.1
Source User
Pop-Up
Page 17
?
ECAD
(ECA.BUILD)
CONTACT.MASTER
THE POWER IN WIRELESS™
Tables for Referencing Contacts
Everything must end with a contact
ECA.KEYWORDS – groupings of contacts
– Attach ECA.KEYWORDS to CONTACTS screen 1 and
ECA.BUILD screen 3
ECA.SYSTEM.REFS – links record data to
contacts
–
–
–
–
Planners
Buyers
Sales Reps
Custom Fields
Don Luoto November 29, 2001
Page 18
THE POWER IN WIRELESS™
Tables – ECA.KEYWORDS
Don Luoto November 29, 2001
Page 19
THE POWER IN WIRELESS™
Tables – ECA.SYSTEM.REFS
Don Luoto November 29, 2001
Page 20
THE POWER IN WIRELESS™
Tables – ECA.SYSTEM.REFS
Don Luoto November 29, 2001
Page 21
THE POWER IN WIRELESS™
ECA Workshop – Add Conditions
Add an EVENT “condition” that excludes parts with
the Inventory Type Code = CO
– CO = non inventory items used for CTO development
Add an ACTION “condition” so that the planner only
receives manufactured parts.
NOTE: The “condition” must be TRUE to allow
processing of the EVENT and/or ACTION
Read the prompt help for entering multiple
conditions with and/or logic.
Don Luoto November 29, 2001
Page 22
THE POWER IN WIRELESS™
ECA Workshop – Add Conditions
Don Luoto November 29, 2001
Page 23
THE POWER IN WIRELESS™
ECA Workshop – Test Conditions
Test 1 – Add a part with the inventory type =
CO and Lead Time Code = P
– Expected result – no emails sent
Test 2 – Add a part with the inventory type =
CM and Lead Time Code = M
– Expected result – email sent to the CONTACT and to all
CONTACTS with ECA.KEYWORD = NEWITEM
Test 3 – Add a part with the inventory type =
FA and Lead Time Code = M
– Expected result – same as test 2 plus the PLANNER on
record for the part
Don Luoto November 29, 2001
Page 24
THE POWER IN WIRELESS™
ECA Workshop – Simple Pop UP
A pop up browser of the notification can be sent to the source
user.
Don Luoto November 29, 2001
Page 25
THE POWER IN WIRELESS™
ECA Workshop – Simple Pop UP
The user entering the part number will get this upon ENDing.
Don Luoto November 29, 2001
Page 26
THE POWER IN WIRELESS™
ECA Workshop – Simple Pop UP
NOTES:
All Manage 2000 logins must be setup in
CONTACTS for Pop Up ECAs to work. The
CONTACT record key must match the
SYS.USER record key.
Don Luoto November 29, 2001
Page 27
THE POWER IN WIRELESS™
ECA.SCAN
Use to periodically scan files for specific
existing data and send a notification if
conditions are met.
Can be run manually or perhaps launched by
DJS (delayed job stream) or
BATCH.MASTER.
Don Luoto November 29, 2001
Page 28
THE POWER IN WIRELESS™
ECA.BUILD for ECA.SCAN
SCREEN 1
Don Luoto November 29, 2001
Page 29
THE POWER IN WIRELESS™
ECA.BUILD for ECA.SCAN
SCREEN 2
Don Luoto November 29, 2001
Page 30
THE POWER IN WIRELESS™
ECA.BUILD for ECA.SCAN
SCREEN 3
Don Luoto November 29, 2001
Page 31
THE POWER IN WIRELESS™
Reports & Debugging Methods
Key Reports
– ECA.TXN.DTL.RPT
Prompt.Update.Truth.Results
– Produces a browser report to the source user that traces
and displays the entire ECA logic.
USE TCL to analyze the ECAT file
– :LIST ECAT WITH Src_Eca_Key = DEMO_1
Don Luoto November 29, 2001
Page 32
THE POWER IN WIRELESS™
Advanced Stuff
I – descriptors
– Can be used in all cases where a dictionary item is used.
– Prompts 8 & 9 in screen 2 of ECA.BUILD work like a TRANS
I - descriptor
Email formatting
– /INCLUDE.SENT.TO.LIST
 List other users notified of the ECA
– /FORM.FIELDS
 Used to format columns of multivalued data
– Add a hyperlink that takes the email recipient to a help
document
Complex conditional statements
Don Luoto November 29, 2001
Page 33
THE POWER IN WIRELESS™
Advanced Stuff, I-Descriptors
Works like a “TRANS” I-Descriptor
Don Luoto November 29, 2001
Page 34
THE POWER IN WIRELESS™
Advanced Stuff, Formatting
Don Luoto November 29, 2001
Page 35
THE POWER IN WIRELESS™
Advanced Stuff, Complex Cond
Don Luoto November 29, 2001
Page 36
THE POWER IN WIRELESS™
General Notes
Advise users to NOT to use MS Word as their email
editor. ECAs are best viewed in plain text.
Watch your ECAT file size, it will increase
dramatically! Use FILE.STAT & RESIZE.
For testing purposes, change your SYS.USER for
Screen 6, Pmt 8, “Delete Self in Sent Mail” to N.
Otherwise you cannot send and an ECA email to
yourself.
wSendmail for NT or sendmail UNIX will need to be
installed and configured before emails can be
forwarded to MS Exchange.
There are treasures where some transactional
functions do not trigger the ECA for certain files.
i.e. PO.RECEIPTS for the IT file.
Don Luoto November 29, 2001
Page 37
THE POWER IN WIRELESS™
General Notes
Create the ECA as simply as possible at first
to confirm that the ECA will trigger and send
the notice. Then add the gravy.
Don Luoto November 29, 2001
Page 38
THE POWER IN WIRELESS™
Q&A
Thank you!
Questions?
Don Luoto November 29, 2001
Page 39
THE POWER IN WIRELESS™