cancel
Showing results for 
Search instead for 
Did you mean: 

file content conversion

Former Member
0 Kudos

in flat file to flat file (.txt)

How should I give conversion settings( I mean for example 'endSeparators') I need all settings for sender and receiver side, especially when I m sending two records. I m able to send with 1 record, but when I send two or more records only first field of every record is receiving... I think I m doing mistake in conversion settings for records..

my data type is :

record

---> row

-


>name

-


>class

-


>marks.

and same for receiver as well..

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Kumar,

Sender Comm channel:

Recordset Structure: row,*

Parameters:

ignoreRecordsetName : true

row.fieldFixedLengths : <Give the lenghts of your fields>

row.endSeparator : 'nl'

Receiver Comm. Channel:

Recordset Structure : row

Parameters:

row.addHeaderLine : 0

row.fieldFixedLengths : <Give the lenghts separated by commas)

row.endSeparator : 'nl'

If this does not work send us the error message and the payload.

---Satish

agasthuri_doss
Active Contributor
0 Kudos

Hi,

In the receiver side, you can add Header line Items.. for this refer-

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

Regards

Agasthuri Doss

former_member201264
Active Contributor
0 Kudos

hi shiva kumar ,

You can handle this with File Content Conversion of the File Adapter. Make use of Key field to identify each record. And use *, whenever you feel it is 0-unbounded.

Also make sure that your content conversion is in sequence wrt Datat Type Sturcture.

I have a situation where the Flat File has the following stucture:

H01 100 200 300

H02 400 500 600

H02 700 800 900

H03 10 20

L01 10 20 30

S01 10 20 30

H01 Occurs once. H02 1 - unbounded.

H03 0 - unbounded.

L01 1 - unbounded

S01 1 - unbounded.

Can File Content Conversion handle such data. Especially like H03 which might not exist in the file.

To more-

/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

Have a look at this weblogs.

/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

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

Go also thru these links

AdapterConverting File Content in the Sender Adapter

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

AdapterConverting File Content in the Receiver Adapter

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

<b>reward points if helpful

regards

sreeni</b>

Former Member
0 Kudos

shiv,

Could u provide some sample data to assist then it might be helpful

Regards

Former Member
0 Kudos

hey amit,

data is :

shiva,MS,99

ravi,bsc,80

raju,ten,90

Note: Im getting output as shiva,ravi,raju

I need output as below :

shiva,MS,99

ravi,bsc,80

raju,ten,90

Please just provide for above data, I can understand actual funda ..

      • if I send single record(shiva,ms,99), I am able to receive correctly but not wid multple records.

Former Member
0 Kudos

hey

both ur source and receiver have same structure,then why are u using FCC?

thanx

ahmad

Message was edited by:

Ahmad

Former Member
0 Kudos

Hi,

<i>Note: Im getting output as shiva,ravi,raju</i>

Plase insert the standard node function Splitbyvalue (this will insert the context change in each value)

Or

Check the FCC parameters

record.endSeparator : 'nl' is used or not

Regards

Chilla

Former Member
0 Kudos

@ahmed

since I m beginer I want to know how it works for fcc to fcc. Once I am successfull wid same structure, will try different structures.

former_member189558
Contributor
0 Kudos
Former Member
0 Kudos

im beginer, so can u just give me for above problem... anyways thank u for the links, I check my things from there as well.

Former Member
0 Kudos

Check this recent thread for File Sender Content Conversions..