Receiver File Content Conversion...

[Former Member]

Hello Guru's

I can see only one row in my Target file. I don't want to use the fieldSeparator in my target file.

Source Structure:

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

- <ns:MT_Customer xmlns:ns="urn://sap.com/customer">

- <Record>

- <Row>

<CUSTNO>00000142JANE FRAGAX29.09.200930.09.2009</CUSTNO>

</Row>

</Record>

</ns:MT_Customer >

Source File test.txt

00000142JANE FRAGAX29.09.200930.09.2009

12300142JANE FRAGAX29.09.200930.09.2009

Output getting right now with this File content Conversion for my receiver.

00000142,JANE FRAGAX,29.09.2009,30.09.2009

Recordset Structure: Record,Row

Row.addHeaderLine ==> 0

Row.fieldSeparator ==>,

Record.fieldSeparator ==> 'nl'

Row.endSeparator ==>'nl'

Expected Target File (this result I am in the needed)

00000142JANE FRAGAX29.09.200930.09.2009

12300142JANE FRAGAX29.09.200930.09.2009

Please let me know what needs to be changed in my content Conversion.

For Source stucture infomation please refer my ealier

Thanks,

Jane.

[Former Member]

I had some space in the FCC's field name's and values. Once I removed the spaces it works fine.

[Former Member]

If your Row node contains only one element then from content conversion remove the

Row.fieldSeparator = , from the content conversion parameters and check the same

Rajesh

[Former Member]

Rajesh,

Here is my source stru

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

- <ns:MT_Customer xmlns:ns="urn://sap.com/customer">

- <Record>

- <Row>

<CUSTNO>00000142</CUSTNO>

<Date>01012009</Date>

</Row>

- <Row>

<CUSTNO>12300142</CUSTNO>

<Date>12122009</Date>

</Row>

</Record>

</ns:MT_Customer >

If I remove the Row.fieldSeparator.

I am getting this error in the Receiver CC.

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Channel has not been correctly initialized and cannot process messages

and I am not getting any files in my target end.

Thanks,

Jane.

Edited by: Jane Fraga on Oct 23, 2009 6:13 PM

[former_member187339]

Hi Jane,

Dont remove Row,fieldSepartaor from Receiver channel. Do like this;

instead of Row.fieldSeparator = , give

Row.fieldSeparator =

ie you are not putting , (Comma) there.

Regards

Suraj

[Former Member]

Suraj,

It works fine after removing the , from my target file and adding space for this.

I am getting only one row in my target file. My source file contains 2 rows. What need to change in FCC?

Recordset Structure: Record,Row

Row.addHeaderLine ==> 0

Row.fieldSeparator ==>

Record.fieldSeparator ==> 'nl'

Row.endSeparator ==>'nl'

Thanks,

Jane.

Edited by: Jane Fraga on Oct 23, 2009 6:48 PM

[Former Member]

Hi Jane,

Can you provide your target sturcture?

Thanks,

Pooja Pandey

[Former Member]

duplicate

Edited by: Pooja Pandey on Oct 23, 2009 2:03 PM

[Former Member]

Hi,

Make sure you have the Row (0.. unbounded) in your message type.

Then just use the below configuration and see if it works

Recordset Structure: Row

Row.fieldSeparator ==>'nl'

Row.endSeparator ==>'nl'

regards,

Ravi

[Former Member]

Hi Ravi / Pooja,

Here is my Source and target Data Type structure.

DT_Customer Complex Type

Record Element 0..unbounded

Row Element 0..unbounded

CUSTNO Element xsd:integer 1

Date Element xsd:date 1

I am using the same Row(0 ....unbound) still I am getting only one Row in my target file.

If I add Row.fieldSeparator ==> 'nl' getting the values in 2 rows.

12300142

29.09.2009

Thanks,

Jane.

Edited by: Jane Fraga on Oct 23, 2009 9:09 PM

[Former Member]

Pooja,

Here is the target stru.

DT_Customer Complex Type

Record Element 0..unbounded

Row Element 0..unbounded

CUSTNO Element xsd:integer 1

Date Element xsd:date 1

Thanks,

Jane.

[Former Member]

Hi Jane,

For the below source message, what target xml your message mapping produces ?

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

- <ns:MT_Customer xmlns:ns="urn://sap.com/customer">

- <Record>

- <Row>

<CUSTNO>00000141</CUSTNO>

<Date>01012009</Date>

</Row>

- <Row>

<CUSTNO>12300142</CUSTNO>

<Date>12122009</Date>

</Row>

- <Row>

<CUSTNO>12300143</CUSTNO>

<Date>12122009</Date>

</Row>

</Record>

</ns:MT_Customer >

Can you provide your target msg ?

Pooja

[Former Member]

Do you have the same message structure for both source and target? Are you doing message mapping? If so then better use concat function and combine those 2 fields.