›> ›> EXTOL Business Integrator (EBI/EBF) - Defining Record IDs in flat file schema

EXTOL Business Integrator (EBI/EBF) - Defining Record IDs in flat file schema

17th December 2013

From our previous posts we reviewed setting up the EXTOL flatfile schema, defining the delimiters and setting the properties of a flat file schema (below) we need to review how to define the record IDs.

In the example below we show how to set-up the record “HI” and the set-up for:

  • Record ID length
  • Record ID Start
  • Record ID Type
  • Record ID Value
  • Record ID Length

EXTOL Business Integrator EBI Flat File Schema Record ID screenshot 1

When we describe the attributes of the above values, we are referencing the RecordID field.

In the example below we look at the ‘CM’ record. Just like the 'HI’ record we are using the RecordID field to describe the actual record ID.

EXTOL Business Integrator EBI Flat File Schema Record ID screenshot 2

Note: When the file is delimited the 'Record Length’ attribute will be 0.



Copyright 2013 @ 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 ' '; ?>