FCC

[Former Member]

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

[zameerf]

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

[Former Member]

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:

[iaki_vila]

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.

[former_member184681]

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