Problem with File Content Conversion (Receiver FIle Adapter)

[Former Member]

Hi Experts,

I have following structure in receiver side:

MT_Test

F1

F2

F3

F4

Now I want a CSV file in target side in below format:

F1,F2,F3,F4

I have provided below config in receiver file adapter under content conversion tab:

Recordset Structure : MT_Test

MT_Test.fieldSeperator= ,

MT_Test.endSeperator= 'nl'

But this is generating blank CSV files in target directory..What might be the reason.. I have checked the msg in adapter engine, the XML file is correct and contains valid values for the fields..Its something like below:

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

<MT_Test>

<F1>Hai</F1>

<F2>Hello</F2>

<F3>Bye</F3>

<F4>Hi</F4>

</MT_Test>

I should get CSV file as

Hai,Hello,Bye,Hi

But I am getting a blank file with above said config parameters in content conversion tab.

What might be the reason for getting blank CSV files in target side???

Thanks,

Adi

[former_member463616 · Accepted solution]

Hi,

>>>MT_Test.fieldSeperator= ,

>>>MT_Test.endSeperator= 'nl'

The above steps are wrong. It should be case sensitive. You have to write like this

MT_Test.fieldSeparator= ,

MT_Test.endSeparator= 'nl'

See the below blogs, it might be helpful to you.

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

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

Regards,

P.Rajesh

Edited by: Rajesh_1113 on Mar 22, 2011 9:18 AM

[Former Member · Accepted solution]

Hi Rajesh,

I have written same as u provided. But its not working..What is the cause?

Thanks,

Aditya

Edited by: Adi_Roy_Sap on Mar 22, 2011 4:59 AM

[Former Member · Accepted solution]

Hi,

My target structure in below format:

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

- <MT_Test>

<F1>Hai</F1>

<F2>Hello</F2>

<F3>Bye</F3>

<F4>Hi</F4>

</MT_Test>

Pls let me know the parameters in Receiver file adapter for FCC to generate a CSV file in below format:

Hai,Hello,Bye,Hi

Regards,

Adi

[former_member437549 · Accepted solution]

Hi Adi,

>>My target structure in below format:

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

- <MT_Test>

<F1>Hai</F1>

<F2>Hello</F2>

<F3>Bye</F3>

<F4>Hi</F4>

</MT_Test>

So, try to edit Data type and include hierarchy level above <F1>.

Finally your Target Structure will resembles like this.

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

- <MT_Test>

<Structure>

<F1>Hai</F1>

<F2>Hello</F2>

<F3>Bye</F3>

<F4>Hi</F4>

</Structure>

</MT_Test>

FCC Parameters will be like this.

Structure.fieldSeparator = ,

Structure.endSeparator = 'nl'

Hope you were clear.

Thanks,

Siva.

[Former Member · Accepted solution]

Hi Siva,

Thats the one I needed..Thanks a lot..Awared full points..

Regards,

Adi

[former_member437549]

Hi Adi,

I hope there is no Recordset Structure in your message .

So jut follow the given below blog and ur issue will be solved.

If any problem occurs just provide the error message which u r getting in ADAPTER ENGINE.

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

Thanks,

Siva.