SeanHoppe.com > CLEO Tips > Cleo EDI Integrator > Formulas :: Creating A Value Formula

Formulas :: Creating A Value Formula

29th April 2020

Creating A Value Formula

STEP 1:

In the Extol Integrator Main Menu, select option ‘5′, Mapping

CLeo EDI Integrator Main Screen

STEP 2:

In the Mapping Menu, select option ‘63′, Formulas

CLeo EDI Integrator Mapping menu Screen

STEP 3:

In the Formulas Menu, select option 1, Work with formulas

CLeo EDI Integrator Formula Menu Screen

STEP 4:

The Work with formulas panel is displayed

CLeo EDI Integrator Work with Formulas Screen

Press [F9] to enter create mode

CLeo EDI Integrator Create new formula Screen

STEP 5:

Assign the formula’s ID, Status, Type and Description. Status may be either an ‘A’ for an active formula that has been tested and is ready to be used in a message class or an ‘I’ for an inactive formula that needs some testing. 

Note that having an ‘I’ for the status will not prevent the formula from being used in a message class. Using this status is a recommended way to flag your formulas that need to be tested

‘V’ is placed in the type column to denote a Value formula

CLeo EDI Integrator Create new formula Screen

Press Enter and confirm. The Change formula details panel appears

CLeo EDI Integrator Change formula details Screen

STEP 6:

Type your desired formula, press Enter and confirm your changes

CLeo EDI Integrator Change formula details Screen

The Work with formulas panel will be displayed in Create mode. Press [F9] to return to change mode. The new formula will be displayed in the panel

CLeo EDI Integrator work with formalas Screen

To make changes to this formula or any other formulas that have already been created, you can use option ‘2′ to change the formula


By: on
load('http://www.seanhoppe.com/EXTOL-Blog-Feed2/'); $feed2 = array(); foreach ($rss2->getElementsByTagName('item') as $node2) { $item2 = array ( 'title' => $node2->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node2->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node2->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node2->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed2, $item2); } $limit2 = 5; $rss3 = new DOMDocument(); $rss3->load('http://www.ebithree.com/EBIThree-RSS/'); $feed3 = array(); foreach ($rss3->getElementsByTagName('item') as $node3) { $item3 = array ( 'title' => $node3->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node3->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed3, $item3); } $limit3 = 5; $rss4 = new DOMDocument(); //$rss4->load('http://www.ebithree.com/EBIThree-RSS/'); $rss4->load('http://www.ebiworld.com/EBI-Feed/'); $feed4 = array(); foreach ($rss4->getElementsByTagName('item') as $node4) { $item4 = array ( 'title' => $node4->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node4->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed4, $item4); } $limit4 = 5; echo ' '; ?>