Doubt regarding file content conversion Recever File adapter.

[Former Member]

target structure.

-

---

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

<ns1:MT_ChangeOfAddress xmlns:ns1="urn:passhe.com/ChangeOfAddressISA28">

<BUSINESS_PARTNER>

<item>

<CAMPUSCODE>65</CAMPUSCODE>

<STUDENTNUMBER>6500000192</STUDENTNUMBER>

<ST_OBJID>732298498</ST_OBJID>

</item>

</BUSINESS_PARTNER>

</ns1:MT_ChangeOfAddress>

-

---

target structure is look like this.

MT_ChangeOfAddress

BUSINESS_PARTNER (1,1)

item (0 to unbounded)

CAMPUSCODE (0,1)

STUDENTNUMBER (0,1)

ST_OBJID (0,1)

-

---

I have given below parameters in recever file adapter (file content conversion)

Recordset Structure : item

item.fieldNames : CAMPUSCODE,STUDENTNUMBER,ST_OBJID

item.fieldSeparator: , (comma)

i am getting first two digits in my output file: that file has only first two digits that is : 65

may i know how hould i define file contente conversion recever adapter to get proper data in file adapter.

thanks,s

Dhanush

[former_member556603 · Accepted solution]

Hi,

Go through these blogs:

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

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

Thanks,

Satya

[Former Member]

Hi,

you should add the end separatoe also like

item.endSeparator : 'nl' -

---

> its for new line.

follow this blocks if your problem is not resolved.

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

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

[Former Member]

check the below...

Recordset Structure : BUSINESS_PARTNER,item

item.fieldNames : CAMPUSCODE,STUDENTNUMBER,ST_OBJID

item.fieldSeparator: , (comma)

item.endSeparator:'nl'

[Former Member]

Sekhar,

Thanks for your help, its working fine, when i tryed to add header line in my output file with this option: item.addHeaderLine = 2, and also i tryed with BUSINESS_PARTNER.addHeaderLine = 2 , still header line is not appearing in my out file. i am expecting header line below metioned.

CAMPUSCODE STUDENTNUMBER ST_OBJID

i have tryed all possible ways : item.addHeaderLine = 1 and 2, BUSINESS_PARTNER.addHeaderLine = 1 and 2 . please help me out.

Thanks

Dhanush

[GabrielSagaya]

Recordset Structure : BUSINESS_PARTNER, item

BUSINESS_PARTNER.fieldNames=item

BUSINESS_PARTNER.fieldSeparator='nl'

BUSINESS_PARTNER.endSeparator='nl'

item.fieldNames = CAMPUSCODE,STUDENTNUMBER,ST_OBJID

item.fieldSeparator = ,

item.endSeparator = ,

[Former Member]

Hi,

Thanks for your help, its working fine, when i tryed to add header line in my output file with this option: item.addHeaderLine = 2, and also i tryed with BUSINESS_PARTNER.addHeaderLine = 2 , still header line is not appearing in my out file. i am expecting header line below metioned.

CAMPUSCODE STUDENTNUMBER ST_OBJID

i have tryed all possible ways : item.addHeaderLine = 1 and 2, BUSINESS_PARTNER.addHeaderLine = 1 and 2 . please help me out.

Thanks

Dhanush

[Former Member]

Try with this option.....

xml.addHeaderLine = 1