SeanHoppe.com Cleo Best Practices
Cleo/EXTOL Best Practices
Updated: May 5th, 2020
Resolve Support Issues Faster
Cleo EDI Integrator for iSeries
- Querying CLEO Integrator for Numeric Field Decimal Values
- Everything to know about Archive/Purging - DLTADTA
- Mapping Zero to EDI QTY02 Numeric Element
- Retrieve System Date/Time for Outbound Map with RTVDTM
- Preserve Connection MSGQ data with EXPIPMSGQ
- How to Create FTP Network, Ports, & Scripts
- Write Multiple Records for Single NTE/MSG/MTX Segment
- 997 Functional Acknowledgements Explained
- Debugging External File Lookup (EFL)
- Visibility to Data Queues
- Qualify element pair nodes
- Qualify Segments For Inbound EDI
- ERe-Sequence Map Segments
- Qualify Segments in Outbound Map
- How to Resend Outbound EDI Connection Data
- Automatically Create Conversion Map
- iSeries Command to Access EXTOL Main Menu
- ADDDAYS External Call to Subtract 7 Days
- How to Email Spool File using EXTOL Command EXSNDSPLF
- Relational Conditioning Mapping to Omit Outbound Data
- Proprietary Mapping for Delimited and Fixed Length Flat Files
- Proprietary (Flat File) Question and Answer
- Purging EXDIIPP and EXDISPP (User View) Tables
Cleo Clarify
EXTOL Business Integrator
- Using HAS DATA in Business Process Script
- Don't force an error in Application Analysis Ruleset BPS
- Qualifying data in SAP iDoc
- Use the most up-to-date JDBC driver
- Retrieve today's date
- Calling a Business Process Script within a Ruleset
- Force Transformation Errors in EBI Ruleset
- Using NAND in EXTOL Binding to Select Data
- Converting Date into CYYDDD
- Reprocessing inbound EDI Data
- Managing Processes on Linux Platform
- Document and track your ruleset rules
- Use Dashboard 2.1 to determine status of EBI
- Setting Up Database Commit Control
- Delimiters and Escape Characters in Flat Files
- Setting Up a Flat File Schema 101
- Setting Up Record Fragments in a Flat File Schema
- Setting Up Fixed Length Flat File Schema
- File Write Adapter Using Substitution Variable Creator
- Use File Write Adapter to Archive Outbound EDI Data Into Single File
- Passing a Variable into a File Write Adapter
- Applying a UNC Path with FileSystem Monitor
- Use SQL Access Insert Reference Data Values for EXTOL Dashboard
- Business Process Script - Carbon Copy Inbound x12 EDI Data with Outbound SFTP
- Update Dashboard URL for Quicker Access
- Customize BPS to run on Select Days During Certain Hours
- Create Custom Batch Process for Inbound AS2 Data
- Remove Leading Zeros from Alpha Value in Ruleset
- Check for Multiple Values with a Single Rule using Regex and Match
EXTOL Secure Exchange
EXTOL VAN
By: Sean Hoppe on