file conversion in a file adapter

[Former Member]

Hi

I am using a FTP file adapter to place the file in the ftp servers.

The structure of the file is

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

- <p2:MT_Cust xmlns:p2="http://RashidaBPM">

<Cust_no>KRTEST2</Cust_no>

<Cust_Name>XI CUSTOMER 2</Cust_Name>

<Cust_Address>GB</Cust_Address>

</p2:MT_Cust>

I want the resulta to come in as cust_no , cust_name, cust_address

Can someone please help me to get the centent conversion parameters correct to get the desired result

Thanks

Nikhil

[Former Member]

Hi Nikhil,

To convert a XML file into a flat file you need to have a Stucture of the XML file like this one mentioned below:

<root>

<substructure>

<data>

</data>

</substructure>

<root>

By XML I mean the input data, that will be routed from XI server to FTP servers.

now the parameters to be given in Content Conversion Tab and which are of utmost importance are:

substructure.fieldSeparator

root.fieldSeparator

substructure.endSeparator

you can also use the methods such as fieldFixedLengths etc.

Include these methods and test your scenario again.

I hope it helps,

Thanks & Regards,

Varun Joshi

[Former Member]

hai Nikhil Mahajan

i am giving a link i hope that will help u

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Jayaraman

[Former Member]

Hi,

In the content conversion parameters of teh recvr file adapter specify the follw:

Recordset Structure : <the structure of o/p file eg: >

cust,str

str.fieldSeparator ,

cust.fieldSeparator 'nl'

str.endSeparator :'nl'

assuming ur o/p file structure is :

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

<cust>

<str>

<Cust_no></Cust_no>

<Cust_Name></Cust_Name>

<Cust_Address></Cust_Address>

</str>

</cust>

Regards

Priyanka

[Former Member]

You have to add some parameters in the "Variable Substitution" block in the file adapter, check this weblog /people/jayakrishnan.nair/blog/2005/06/28/dynamic-file-namexslt-mapping-with-java-enhancement-using-xi-30-sp12-part-ii