Reciever File adapter

[Former Member]

HI,

I am doing a mail(attachment)-xi-file scenario.

The message structure on the source side is :

Lead code:12929

Order ref: sp/jaksd/1212

order type: S

Item code Qty

1221231 123

1212232 78

........... ...

Please help me and tell what will be the File content conversion parameters on the file receiver side of the scenario.

[Former Member]

Threads indeed helped.

[Former Member]

Hi Priya ,

If you have selected File Content Conversion as the message protocol, you can convert a text file that contains complex structures into an XML source format in this mode. The file contains various row formats in logical structures.

Please have a look upon the link:

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

http://help.sap.com/saphelp_nw04/helpdata/en/44/748d595dab6fb5e10000000a155369/content.htm

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f02d12a7-0201-0010-5780-8bf...

*Pls: Reward points if helpful*

Regards,

Jyoti

[nikhil_bose]

you first receive the xml message coming out.

read that message and make the parameters in the Receiver FCC.

RecordStructure : your root elements ( if more than one, you can specify all separated by comma)

you have to specify min 3 fields

all are prefixed with your record structure name

i.e.

structure.fieldNames : list all field names separated by comma

structure.fieldSeparator : , " comma separation

structure.endSeparator: '/n' " for new line

be sure that there is no internal spaces left.

[Former Member]

Hi !

The file content conversion on the RECEIVER, depends on which output format you expect. The one you included in your post, as far as I understand is an input/source code.

Please give a sample of the expected output format.

Regards,

Matias.

[Former Member]

Could you please let me see the actual flatfile itself?

and then show me the xml structure and with this information I will let you know all the exact parameters you need.

So the best way to do this is go to your message mapping --> Test --> Take the source xml

Also dont forget the flat file itself and if it is fixed length or not.

[Former Member]

The actual flat TARGET FILE SHOULD look like this only

Lead Code: 122112

Order Ref: sdffs/464/sdfs

Order Type: R

Item Code Qty

1212212 12

1234344 76

............ ........

Edited by: Priya reddy on Dec 20, 2007 5:38 AM

Edited by: Priya reddy on Dec 20, 2007 2:00 PM

[nikhil_bose]

what is the target structure?

[Former Member]

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

<ns0:MT_File_1 xmlns:ns0="http://bajaj.com/mailtofile"><dealerCode>10424</dealerCode><orderRef>SP/174 DT.18/12/2007</orderRef><orderType>R</orderType><itemdetails><itemCode>30151106</itemCode><qty>40</qty></itemdetails></ns0:MT_File_1>

[Former Member]

I am getting this error in the CC monitoring :

Conversion initialization failed: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'row.fieldFixedLengths' or 'row.fieldSeparator' is missing

[agasthuri_doss]

Hi,

>'row.fieldFixedLengths' or 'row.fieldSeparator'

Add FieldSeparator and try it out and Field length too.

Regards

Sangeetha

[Former Member]

hi priya,

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

.......<ns0:MT_File_1 xmlns:ns0="http://bajaj.com/mailtofile"><dealerCode>10424</dealerCode><orderRef>SP/174 DT.18/12/2007</orderRef><orderType>R</orderType><itemdetails><itemCode>30151106</itemCode><qty>40</qty></itemdetails></ns0:MT_File_1>

by looking at your structure I feel record name is missing.

in general record structure should be as follows...

<root>

<recordset>

<field1>

<field2>...

....

</recordset>

</root>

<root> is message type and <recordset> is a row. Here in your structure recordset is missing.

if you mensioned this record set in your structure the following can be your content conversion parameters.

Record structure : recordset

dealerCode.fieldFixedLengths

orderRef.fieldFixedLengths

orderType.fieldFixedLengths

itemdetails.itemCode.fieldFixedLengths

itemdetails.qty.fieldFixedLengths

I am not sure about the last two but try

regards,

Pavani

[Former Member]

Thanks Pavani,

But i am not sure about the field length whether it is fixed or not .

Also , it has multiple instances for itenm code and qty....how to handle this ?

[Former Member]

hi Priya,

confirm me that for each message single order or multiple orders present??

Regards,

Pavani

[GabrielSagaya]

You can use

RecordSetStructure Record, Row

Row.fieldNames=Lead code,Order ref, Order type,item code, qty

Row.fieldFixedLengths=5,15,1,7,3