EXTOL Insider’s Tips from the Technical Support Center – May 2012

EXTOL Business Integrator (EBI)

Question: Is there a quick and easy way to see if the Regular Expression I just created will work in my EBI Adapters?

Answer: Yes, through the use of the Regular Expression Evaluation Utility. The Regular Expression Evaluation Utility was designed to be a time-saving device for testing Regular Expressions. The Regular Expression Evaluation Utility can be found in the EBI “Workbench” Tab under the “Utilities” group. To use the Regular Expression Evaluation Utility, simply type in your Regular Expression in the text box provided to you at the top of the Utility window. Next, click on the green plus (+) button (on the bottom left of the screen) to add the value you wish to evaluate. Once you put in your values you wish to test, click the “Evaluate” button (top right side of your screen). This will now test to see if your provided values match your Regular Expression (giving you a “True” value under the “Matches” column) or if the values do not match your Regular Expression (giving you a “False” Value.) You can also use this utility to see what would happen if you wanted to use the replacement feature using Regular Expressions (by selecting the “Replacement” tab inside of the Utility window).

The following are a few common Regular Expressions syntaxes:

\d (Any character that is a digit between 0 and 9)
+ (One or more times)
.* (Any character, zero or more times)
\. (The literal value of period)”

EXTOL EDI Integrator for i (EEI)

Question: How should HL segments be setup for an outbound 856 document?

Answer: You can create an HL segment for each hierarchical level – for example when doing Shipment, Tare, Order, and Item. You would setup 4 HL segments. Then, do a change on the first HL segment and in the Segment ID qualifier code field enter an H in the first position and press enter. In the HL ID qual field, enter S (shipment) and also make the segment optional. Each of the other HL should be qualified the same way by T (Tare), O (Order) and I (Item) respectively. These segments should be set to N occurring and optional.

Example:
HL 1 Hierarchical Level         O H           S
HL 2N Hierarchical Level      O H           T
HL 3N Hierarchical Level      O H           O
HL 4N Hierarchical Level      O H            I

The first HL should be mapped as follows:
1 1 628 M AN Hierarchical ID Number S0
3 1 735 M ID S Hierarchical Level Code C1 S

The second HL should be mapped as follows:
1 1 628 M R Hierarchical ID Number S0
2 1 734 O AN Hierarchical Parent ID Nu S0
3 1 735 M ID S Hierarchical Level Code C1 T

The third HL should be mapped as follows:
1 1 628 M R Hierarchical ID Number S0
2 1 734 O AN Hierarchical Parent ID Nu S0
3 1 735 M ID S Hierarchical Level Code C1 O

and the other HL’s should have appropriate constants defined in the 3rd element.

Note: We recommended that each Hierarchical Level have its own File/Format associated with it.

Leave a Reply

Your email address will not be published. Required fields are marked *


*