Sean Hoppe Consulting Group

Basic Training

• Basic Mapping
• Segment Qualifying
• Code Table Exceptions
• Auto Routing
• Everday Commands
• Everyday Reports
• Email from EXTOL
• Duplicate Value Checking
• Recode update

• Anybody who has completed the Cleo Tutorial training
• Seasoned users who are looking to get a better grasp of Cleo's features
• Individuals who can set-up a map but need assistance to go-live with a TP
• Organizations looking to create automatic 997 and exception EDI reports/

• Update internal files once outbound data has been generated.
• Eliminate the need for external programs with simple code table modifications.
• Learn how to switch to new maps in thhope middle of translation.
• Set-up Cleo's email client to send emails. Commands can be used by any program/CL on iSeries.
• Capture duplicate documents. Helpful when duplicate POs and invoices are being sent.
• Know common Cleo commands that can be used on a daily basis.
• Find EDI data by just knowing minimal information.
• Determine which exception reports/screens to to review on a daily basis .
• Resend data with or without new interchange control numbers.
• Introduction to formula processing.

• To cover each topic please allow for 1-1.5 weeks.

Intermediate Training

• External File Lookup
• Force translation errors with formulas
• Send emails with formulas
• Formulas Indepth
• Archive/Purge
• Advanced commands
• Review of JOBDs
• Working with data in IFS

• Users needing to use logic, calculation, and automation in Cleo processes.
• Individuals finding data is not readily available and need to go to outside files to retrieve it.
• # Customer service reps who need to know when an order is received.

• Perform calculations easily within the map.
• With EFL, chain-out to a keyed file to retrieve data in 5 simple steps.
• Use EXTOL formulas to send emails to specific individuals when a document is received.
• Prevent corrupt data from going into your database files by forcing a translation error in an Cleo formula.
• Understand how Cleo's commands can be used in CLs.
• Learn how to perform archiving/purging activities.
• Configure number of days to keep EDI data.
• Work with data streaming data in IFS.

• To cover each topic please allow ?-1 week. If there is additional discussion on how these topics can be custom applied, allow for 1.5-2 weeks.

Advanced Training

• FTP scripting
• FTP with cleanup
• Creating external calls
• Advanced Formulas
• Using iSeries Edit Word functionality in Cleo
• Proprietary/FlatFile Data Mapping
• TPMC external calls
• Advanced External Lookup
• Query Internal Cleo files for status codes
• Debug mode
• Late 997 email notification PGM

• Companies looking to use FTP between VANs and trading partners.
• RPG programmers who want to call their programs from within Cleo maps.
• RPG programmers who want to call their programs post translation.
• Individuals who want to capture certain status codes that can only be found in Cleo (internal) files.

• Learn how to capture inbound trading partner data in an unrelated file for use later on. Helpful when trading partner specific data is received and there is no specific place for the data.
• Use Cleo's FTP functionality for secure FTP and non-secure FTP transmissions.
• Learn how to implement external calls.
• Use Cleo Trading Partner Message Classes to notify you if there is a translation error.
• Implement one-stop-shopping for error messages. Place all messages in the connection message queue. Avoids using multiple screens to find errors.
• Query specific Cleo logicals to determine translation/generation status.
• Place Cleo jobs into debug mode

• To cover each topic please allow for 1.5-2 weeks.