Sender Adapter File Content Conversion - question

[Former Member]

Hi!

Could you help me to make xml-file from csv?

I have file like:

12345#254#9765#89654

55#9066#77127#47

And i need file like:

<dealings>

<deal>

<field1>12345</field1>

<field2>254</field2>

<field3>9765</field3>

<field4>89654</field4>

</deal>

<deal>

<field1>55</field1>

<field2>9066</field2>

<field3>77127</field3>

<field4>47</field4>

</deal>

</dealings>

I haven't key fields - all fields are accidental. And lengths of all fields are accidental.

How to put content conversion parameters?

Thank you.

[Former Member · Accepted solution]

key field is not mandatory...

try specifying these parameters

Recordset structure - deal,*

in CC parameters,

deal.fieldSeparator = '0x23' ( hex code for # separator)

deal.endSeparator = 'nl'

deal.fieldNames = field1,field2,field3,field1

Dont specify keyfield

[Former Member · Accepted solution]

Savvesh, thanks, java-mapping is very useful alternative choice.

Mugdha, it's working! Thanks a lot!

[Former Member]

HI

File Content prameters for the Sender Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

File content conversion sites

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Please see the below links for file content conversion..

- FCC

- FCC

File Content Conversion for Unequal Number of Columns

- FCC

Content Conversion (Pattern/Random content in input file)

- FCC

- FCC - MDM

XI in the role of a FTP

File content conversion sites

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Please see the below links for file content conversion..

- FCC

- FCC

cheers

[Former Member]

How to send a flat file with various field lengths and variable substructures to XI 3.0

[Former Member]

Sarvesh, thanks for your answer.

But by this blog i must identify key fields.

Add key field value parameters to identify the substructures in the recordset

-H1.keyFieldValue: "V00"

-sub1.keyFieldValue: "A11"

-sub2.keyFieldValue: "A27"

But i dont know which strings may occurs in this file.

[Former Member]

In my opinion without keyfield or fixed field length it is not possible.

I am not very sure about it, but you can at least go though it and see if it is possible.

Coz here in this they have used java mapping to handle the flat file.

Edited by: Sarvesh Singh on Jul 17, 2008 6:44 PM