Tag Archives: EEI

The End of Mapping is Here… Almost

A recent blog post by Steve Keifer, titled “The End of Mapping (in B2B Integration)”, asks why B2B translators can’t automatically identify and map source-to-target fields. Well, the answer is they can – at least EXTOL’s translators can. Our customers have been saving countless hours on mapping activities using EXTOL’s design-time automation technology for more than a decade!

With the Advanced Automapper feature in our EXTOL EDI Integrator for IBM i (EEI), our customers simply select a reference map, and the Advanced AutoMapper will compare it with other maps using the same files, generating a new map with the appropriate data fields. It is a very effective tool for the majority of customers, who have multiple trading partners, but trade the same or similar documents. Each new trading partner can be on-boarded much more quickly, eliminating most of the manual and repetitive mapping tasks. Continue reading

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

EXTOL Business Integrator (EBI)

Question: How can I combine multiple EDI Messages into the same Interchange?

Answer: EBI has this capability through the use of the Enveloping Limits found under the “Target” tab of the EDI Endpoints. The Enveloping Limits are a place for the user to define how many Messages they want to be placed inside of each Interchange. Different Limits could be defined inside of the EBI Workbench under the “Enveloping Limits” option. By default, EBI provides the “Default – No Max – Limits” Enveloping Limit that allows for any number of Messages inside of an Interchange. This particular Limit will be the one to use in this scenario.

In order to apply this setting to your outbound process, you must click the “Browse” button next to the “Enveloping Limits” option inside of the EDI Endpoint you wish to use. Select “EXTOL – Default – No Max Limits” from the list. After saving the Endpoint and running your Outbound EDI Process, all messages that are going through this same EDI Endpoint to be enveloped will now be combined into a single Interchange and passed to the Connection Business Process. What you do with it from there is up to you!

EXTOL EDI Integrator for i (EEI)

Question: How can I automatically print a document after it is unwrapped?

Answer: You can setup a Trading partner message class exit point to print a document after it has unwrapped.  Mapping, Trading partner, Message class exits. Do a create, enter a Sequence number, Trading partner, Group code, Message ID, Message class and Msg event of CU (Crt msg log – unwrap). After you hit enter, you will then be on the “Change TPMC exit point” screen. Enter the following:

Status: E    Operation: P    On return:

Return     Function      In process
value        status            status

Pass –

Fail –

Error – Action: E

Program –   Parm type: 1   Program: PRINTSED     Library: *LIBL

Note: This exit point will execute for every message (ST- SE)

EXTOL INSIDER’s Tips from the Technical Support Center – February 2012

EXTOL Business Integrator (EBI):

Question: Is there a way I can search for a specific Business Process inside of the Auditor instead of scrolling through every process listed?

Answer: Yes there is by using the Auditor’s Quick Search. The following are the steps required to use this feature inside of the Auditor:

  • Select the Quick Search icon (Binoculars with a blue arrow) at the top of the window.  A new window will pop up.
  • Select the Log of Process from the Log Types in the left pane.
  • Beneath the Log of Process tab inside of the right pane, click on the Business Process Script Id Value.
  • In the pane that appears below, select the ellipsis (…) button and choose from the Business Processes which you would like to search on and hit OK.
  • Ensure that the drop down menu to the right of the ellipsis button (…) says ‘Equal to’ and hit OK in the bottom right corner of the window.

Inside of the Auditor a new Quick Search tab will open up listing every instance of your specific process that have run (that has not been purged).

These searches could also be made more specific to suite your needs (i.e. If you only want to display a specific Business Process with a ‘Failed’ status, view Business Processes from a specific time, etc.).

EXTOL EDI Integrator for i (EEI)

Question:  Is there a way to subtract 10 days from transmitted date and enter the new value into application file field?

Answer: Yes, map the date field to the element and attach code table ADDDAYS.   In the Code translation direction enter ” I ” for inbound, in the Code table reference enter ADDDAYS and in the Qual type/data enter C / ZMDZMD10-. This will take the date coming in, subtract 10 days from it and convert it back to the same date format minus the 10 days and populate the field with the value.

EXTOL INSIDER’s Tips from the Technical Support Center – January 2012

EXTOL Business Integrator (EBI):

Question: How can I set a fixed length for wrapping Outbound EDI document contents?

Answer: Does your trading partner require the lines of data inside of the Outbound EDI documents you are sending to them to have fixed wrapping at a specific length?  In EDI, the term “Fixed Wrapped” refers to EDI data formatted so that there is a new line repeatedly at a fixed number of characters throughout the document.

The procedure to do this inside of EBI is actually very simple. All you need to do is go to the Target EDI Endpoint responsible for wrapping the EDI data for this particular trading partner. Select the ‘Target’ tab and find the “Enable Fixed Wrapping” checkbox. Checking this will enable the “Fixed Wrap Length” setting next to it. This is where you can enter what the length of the lines inside of your Outbound EDI document will be according to your trading partner’s request. Saving the EDI Endpoint after this will immediately enable the software to wrap the data accordingly.”

EXTOL EDI Integrator for i (EEI)

Question:  How can I use data areas to set defaults for mailroom dates, sorting, and job logging?

Answer:

  • EXWRKCNNDY – Sets the default date for Connections listing when you go to Mailroom, Work with Connections

If you enter a 0.00000000 in the data area, the starting date when you go into the Mailroom, Work with Connections will be the current date. If you enter 1.000000000, the starting date in the Mailroom, Work with Connections will be yesterday, if you enter 2.0000000 the starting date will be the day before yesterday, etc….

  • EXCONNDFT – EXTOL default Ascending/Descending view for Work with Connections
    • An ‘A’ will sort the mailroom so that the Newest Connections are at the bottom and the oldest at the Top.
    • A ‘D’ will sort the mailroom so that the Newest Connections are at the top and the oldest at the bottom.
  • EXDBG – Changing the second position to a ‘Y’ will generate additional job logs for debugging purposes.

**Note – remember to turn this data area off after debugging problems, as keeping this on will result in excess job logs being created on your system.