› › Parsed Data does not Match Ruleset Schema

Parsed Data does not Match Ruleset Schema

Scenario:

An EXTOL Business Integrator ruleset/business process script that transforms flat file data, into a database table has been working but recently we started to get errors.

After reviewing the set-up it appears that there is an issue with the data itself

Issue:

When examining the .csv delimited we discovered an extra column/field.

EXTOL error message:


EXTOL Business Integrator (EBI) 2 Parsed Data does not Match Ruleset Schema

Message ID: 278
Primary: Data record #1 contained 208 parsed values. Matching schema record (N/A) contains only 207 values.
Secondary: Parsed values: [SEAN][HOPPE][4321][1000][][][][0][][0][N][][A][SH1001][900001][0][][][][][][0][][][][][1][N][CIA][2][][N][900001][N][2][2][U][S][O][][][0][N][][0][0][SEAN][HOPPE][0][0][][Y][0][0][0][0][][0][0.015][][][0][110078][114232][C][C][C][0][114143][][0][][0][][USD][0][0][0][0][0][0][0][0][0][0][0][0][0][0][WOODS][110022][2][X][][][0][][N][][][][][0][][][0][535][N][Y][Y][Y][N][0][P][1][N][][0][0][N][][][0][0][0][][][][][][][0][0][][][Y][N][][][][][][Y][][1][0][][0][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][0][][][][][][][][][][][][][][0][][0][0][][SRH][SRH][SRH][SRH][][][]

Resolution:

After we removed the extra column/field from the csv delimited data, we were able to translate the data.



By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.