on 06-25-2009 3:45 PM
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
Hi Srinivas,
May be lastFieldOptional parameter will help.
Can you try this?
Thanks.
Regards,
Shweta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.