›> ›> EXTOL Business Integrator (EBI/EBF) - Setting Up a Flat File Schema 101 continued.

EXTOL Business Integrator (EBI/EBF) - Setting Up a Flat File Schema 101 continued.

12th December 2013

In addition to setting up the EXTOL flatfile schema and defining the delimiters (below) we need to define the record layout.

The record layout can be defined by 1 of the 5 set-ups below:

  • Single Format Delimited Flat File
  • Single Format Fixed Length Flat File
  • Multiple Format Delimited Flat File
  • Multiple Format Fixed Length Flat File
  • Multiple Format Fixed Length Flat File, Advanced*

When it comes time to save the EXTOL Flat File Schema for the first time, we will see the screen below. Depending on how the flat file is used – Target or Schema; EXTOL EBI will ask us to define the flat file layout.

EXTOL Schema flat file properties


Note: EXTOL does no use the following set-ups. They were originally implemented in earlier releases of EBI, ie version 2.2

  • Multiple Format Delimited Flat File, multiple transformations
  • Multiple Format Fixed Length Flat File, multiple transformations

*Multiple Format Fixed Length Flat File, Advanced is used by multiformat schemas utilize in TMW. TMW schemas can have multiple record types with the same record identifier. EXTOL is able to distinguish between these ‘like’ record types.

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