on 05-24-2012 9:12 AM
Hi,
i am working on a FTP to FTP XMl scenerio wherein I am getting CSV file as in put and I have implemented a FCC in the sender file communication channel.
The message type is
RootNode
---->ItemNode
--------->field1
---------->field2
------------>field3
------------->field4
-------------->field5
FCC configuration done is sender file communication channel
Document Name:RootNode
Document namespace:Namespace
Recordset name:RootNode
Recordset structure:ItemNode,
Recordset sequence:Ascending
KeyfieldType:String(Case-Sensitive)
recordset.fieldNames:field1,field2,field3,field4,field5
recordset.fieldSeparator:,
recordset.endSeparator:nl
item.fieldNames:field1,field2,field3,field4,field5
item.fieldSeparator:,
Still I am getting error in communication channel as
Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'item.fieldFixedLengths' or 'item.fieldSeparator' is missing Mandatory parameter 'item.fieldNames': no value found
Can you please help me?
Thanks in advance
Hi,
In addition please check these,
If you haven't specified the occurrence for Record structure after the comma, please add that as well
Recordset structure:ItemNode,
Also you do not need the below parameters in your list
recordset.fieldNames:field1,field2,field3,field4,field5
recordset.fieldSeparator:,
recordset.endSeparator:nl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'item.fieldFixedLengths' or 'item.fieldSeparator' is missing Mandatory parameter 'item.fieldNames': no value found
just you have to change like below
Item.fieldSeparator ------ ,
Item.fieldNames ---------- field1,........................
Item.endSeparator --------- 'nl'
ex:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Few cents,
You can see the why of the quotation marks in sap.help documentation:
In all strings for separators (NameA.fieldSeparator, NameA.beginSeparator, and NameA.endSeparator), you can specify non-printable ASCII characters. These characters can each be inserted individually in the strings in the form ´0xHH´ (including the quotation marks), where HH represents the character coded as a hexadecimal value. A line break can be entered using the character ´nl´ (including the quotation marks); nl stands for new line. The special character ´0´ is not a separator character.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In the attributes table, you need to use the Recordset structure name, like below:
ItemNode.fieldNames: field1,field2,field3,field4,field5
ItemNode.fieldSeparator: ,
ItemNode.endSeparator: 'nl' (quotes are required here)
Regards,
Greg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.