Problem with conversion from EDI to Flatfile (using FCC)

[Former Member]

Hi all,

Kindly advise regarding my problem of conversion to flatfile,

I have here an XML,

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_SLSRPT_Flat xmlns:ns0="http://pg.com/xi/tom/connect/edi">

- <SLI>

<PERIO>20080112</PERIO>

<EAN>737052056760</EAN>

<ILN>4327926000003</ILN>

<SALES>1</SALES>

<TURNO>12.9</TURNO>

<PERFL>W</PERFL>

<SUBSFL>X</SUBSFL>

<SALUN>ST</SALUN>

<CURRENCY>EUR</CURRENCY>

<STOCK>000000000</STOCK>

<STOUN>ST</STOUN>

<CRLF />

</SLI>

- <SLI>

<PERIO>20080112</PERIO>

<EAN>737052056852</EAN>

<ILN>4330599000003</ILN>

<SALES>4</SALES>

<TURNO>41.8</TURNO>

<PERFL>W</PERFL>

<SUBSFL>X</SUBSFL>

<SALUN>ST</SALUN>

<CURRENCY>EUR</CURRENCY>

<STOCK>000000000</STOCK>

<STOUN>ST</STOUN>

<CRLF />

</SLI>

- <SLI>

<PERIO>20080112</PERIO>

<EAN>737052057101</EAN>

<ILN>4331275000003</ILN>

<SALES>1</SALES>

<TURNO>12.9</TURNO>

<PERFL>W</PERFL>

<SUBSFL>X</SUBSFL>

<SALUN>ST</SALUN>

<CURRENCY>EUR</CURRENCY>

<STOCK>000000000</STOCK>

<STOUN>ST</STOUN>

<CRLF />

</SLI>

When, i've test my scenario, my output has discrepancies,

I've generated many files (in which, each file contains one line) :

PERIO;EAN;ILN;SALES;TURNO;PERFL;SUBSFL;SALUN;%CURRENCY%;STOCK;STOUN;ARTNR

20080112;737052056760 ;4327926000003; 1; 12.90;W;X;ST ;EUR;0000000000;ST ;

PERIO;EAN;ILN;SALES;TURNO;PERFL;SUBSFL;SALUN;%CURRENCY%;STOCK;STOUN;ARTNR

20080112;737052056852 ;4327926000003; 4; 41.80;W;X;ST ;EUR;0000000000;ST ;

PERIO;EAN;ILN;SALES;TURNO;PERFL;SUBSFL;SALUN;%CURRENCY%;STOCK;STOUN;ARTNR

20080112;737052057101 ;4327926000003; 1; 12.90;W;X;ST ;EUR;0000000000;ST ;

The desired output for this XML above should look like this,

PERIO;EAN;ILN;SALES;TURNO;PERFL;SUBSFL;SALUN;%CURRENCY%;STOCK;STOUN;ARTNR

20080112;737052056760 ;4327926000003; 1; 12.90;W;X;ST ;EUR;0000000000;ST ;

20080112;737052056852 ;4327926000003; 4; 41.80;W;X;ST ;EUR;0000000000;ST ;

20080112;737052057101 ;4327926000003; 1; 12.90;W;X;ST ;EUR;0000000000;ST ;

Kindly advise whether there is wrong on my configurations ?

My current configurations in Receiver File Adapter is this,

Transport Protocol: File System (NFS)

Message Protocol: File Content Conversion

Adapter Engine: Integration Server

File Access Parameters

Target Directory: (my specified directory)

File Name Scheme: .csv

Processing Parameters

File Construction Mode: Add Message ID

Write Mode: Directly

File Type: Text

Variable Substitution (target Directory/File Name Scheme)

Enabled

Variable Name : var1

Reference: message:receiver party

Run Operating System Command After Message Processing

Command Line: chmod 664 %F

Content Conversion Parameters:

Recordset Structure: SLI

SLI.addHeaderLine: 3

SLI.headerLine: PERIO;EAN;ILN,....

SLI.fieldSeparator: ;

SLI.endSeparator: 'nl'

Adapter Status:

State: Active

Thanks!

Fred

[justin_santhanam]

Fred,

Plz check in your other threads.

raj.

[Former Member]

Hi Raj!

I believe, there is no problem with my Receiver File Adapter (FCC).

The concern is on the splitting of the message.

Original source message entering XI is a EDI message.

When it entered Seeburger, it will do splitting of the message depending on the UNH segments of the EDI message.

Thats why, the output from XI, is a splitted translated SLI XML message.

And when it enters File Adapter, it will be converted to one file each.

Could you advise on how we will do with the configurations of the Message Splitter?

SO as when the message enters XI, it is still as a whole (ONE) message.

Thanks!