SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 Creating a date (CYYDDD) for JDEdwards in EXTOL Business Integrator

Creating a date (CYYDDD) for JDEdwards in EXTOL Business Integrator

6th June 2012

JD Edwards requires dates to be formatted as CYYDDD. In our example, we receive an inbound EDI document and use EXTOL Business Integrator to populate the F47 files.

Our inbound date 20120606 (yyyyMMdd) and we will convert it to the Century/Julian Date (CYYDDD).

Below are the EXTOL EBI steps to take the EDI element data and move it into JDEdwards date field:

  • Move BEG05 into “rls.var.BEG05_string”
  • Convert Date Format: (format - “rls.var.BEG05_string”,“yyyyMMdd”,“yyDDD” ==> “rls.var.BEG05_string”
  • Move “rls.var.BEG05_string” ==> “rls.var.BEG05_int”
  • Add “rls.var.BEG05_int” + “100000” ==> F47011.SYDRQJ



Copyright 2012 @ www.seanhoppe.com


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 ' '; ?>