cancel
Showing results for 
Search instead for 
Did you mean: 

Sender File adpter --File content conversion

Former Member
0 Kudos

Hi,

I had a CSV file like

field1,field2, field3, field4

when my input file contains values for only first three fields

example: abcd,20,30,

*then when iam converting the file to xml, the last field is missing in the xml*

my content conversion is as below

ROW.fieldNames : field1,field2,field3,field4

ROW.fieldSeparator : ,

ROW.processConfiguration : FromConfiguration

ROW.endSeparator : 'nl'

Please suggest how i can proceed.

Regards

Srinivas

Accepted Solutions (1)

Accepted Solutions (1)

shweta_walaskar2
Contributor
0 Kudos

Hi Srinivas,

May be lastFieldOptional parameter will help.

Can you try this?

Thanks.

Regards,

Shweta

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for your help

Former Member
0 Kudos

Hello,

Can you try out the following parameter

ROW.missingLastfields and set the value as 'add'

Regards,

Akshay

Also, lastFieldOptional doesn't work for csv files.

Edited by: Akshay Salunke on Jun 25, 2009 11:14 AM

Former Member
0 Kudos

Srinivas,

You need to specify the parameter:

ROW.lastFieldsOptional as YES

This can be used to ignore only the last fields.

Also see this help for more info:

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

Regards,

---Satish

Former Member
0 Kudos

Satish

NameA.lastFieldsOptional is obselete.

Srinivas

Former Member
0 Kudos

Yes. But still it works for me. Give out a try. It all depends upon your SP.

If it didnot work then give ROW.keepIncompleteFields=YES

or

ROW.missingLastFields = ignore

Worth seeing the notes:

868039 --- XI 3.0 AF: Content conversion issues for lastFieldsOptional

1224355 --- SP20/SP12(04S):Obsolete parameter in Content conversion

Regards,

---Satish

Edited by: Satish Reddy on Jun 25, 2009 9:51 AM

Former Member
0 Kudos

Satish,

i tried as below.

ROW.keepIncompleteFields=YES

ROW.missingLastFields = ignore

ROW.missingLastFields = add

ROW.lastFieldsOptional = YES

it is not working,My scenarion file to proxy.iam getting an error on sender side,the last field is missing in the payload.

Please suggest

Srinivas

Former Member
0 Kudos

Hi Srinivas,

Just use NameA.missingLastfields = add. The value 'Ignore' is not necessary.

Regards,

Akshay

Hey Srinivas, can you tell which version you are on.

Edited by: Akshay Salunke on Jun 25, 2009 1:59 PM

Former Member
0 Kudos

Akshay,

Still the same isuue.

Srinivas

Former Member
0 Kudos

Hi Srinivas,

What is the version of XI you are working on?

If you are on release prior to SP20(NW 2004 release) or SP12(NW 2004S Release), then only ROW.lastFieldsOptional is going to work. Otherwise its going to give you an error. So, use it accordingly.

Is the last comma occuring in the row in case of a missing field? If yes then, just use the following parameter. Remove the rest of the parameters for handling this problem.

ROW.keepIncompleteFields=YES

Regards,

Akshay