Skip to Content
avatar image
Former Member

FCC

Hi All,

My scenario is Text file to Xml file. I have chosen message protocol as FCC and the content conversion parameters are as follows :

Document name : FILEINPUT

Document Namespace : http://text2xml.com

Recordset Name : RECORD

Recordset Structure : ROW,*

ROW.fieldNames : Name,Street,City

ROW.fieldSeparator : ,

ROW.endSeparator : 'nl'

ignoreRecordsetName = 'true'

But the file is not picked from the location and i am getting an error as :

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'ROW.fieldNames': no value found

My data in text file looks like :

Name1,Street1,City1

Name2,Street2,City2

Kindly suggest me what is problem, whether is any any problem in content conversion parameters or any problem in text file data. I have written as it is how they appear.

Regards,

Venkat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Aug 03, 2007 at 10:59 AM

    HI

    can you give your DT structure here ?

    ---Ram

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Please look at DT file below:

      <?xml version="1.0" encoding="ISO-8859-1"?>

      http://www.w3.org/2001/XMLSchema" xmlns=" http://text2xml.com" targetNamespace=" http://text2xml.com">

      <xsd:complexType name="FILEINPUT">

      <xsd:annotation>

      http://sap.com/xi/TextID">

      f4401d7041b911dcbfd40011258ca532

      </xsd:appinfo>

      </xsd:annotation>

      <xsd:sequence>

      <xsd:element name="RECORD">

      <xsd:annotation>

      http://sap.com/xi/TextID">

      13a76af040cb11dca9e100123f3f523d

      </xsd:appinfo>

      </xsd:annotation>

      <xsd:complexType>

      <xsd:sequence>

      <xsd:element name="ROW" maxOccurs="unbounded">

      <xsd:annotation>

      http://sap.com/xi/TextID">

      13a76af140cb11dc9c3900123f3f523d

      </xsd:appinfo>

      </xsd:annotation>

      <xsd:complexType>

      <xsd:sequence>

      <xsd:element name="Name" type="xsd:string">

      <xsd:annotation>

      http://sap.com/xi/TextID">

      13a76af240cb11dca40b00123f3f523d

      </xsd:appinfo>

      </xsd:annotation>

      </xsd:element>

      <xsd:element name="Street" type="xsd:string">

      <xsd:annotation>

      http://sap.com/xi/TextID">

      13a8f19040cb11dcbb3100123f3f523d

      </xsd:appinfo>

      </xsd:annotation>

      </xsd:element>

      <xsd:element name="City" type="xsd:string">

      <xsd:annotation>

      http://sap.com/xi/TextID">

      13a8f19140cb11dc9ea300123f3f523d

      </xsd:appinfo>

      </xsd:annotation>

      </xsd:element>

      </xsd:sequence>

      </xsd:complexType>

      </xsd:element>

      </xsd:sequence>

      </xsd:complexType>

      </xsd:element>

      </xsd:sequence>

      </xsd:complexType>

      </xsd:schema>

      Venkat

  • avatar image
    Former Member
    Aug 03, 2007 at 11:52 AM

    hi,

    give the following input for ur FCC:

    Document name:ur message type name(i.e FILEINPUT)

    Document namespace : http://text2xml.com

    Recordset Name : RECORD

    Recordset Structure : ROW,*

    And in the table give the below details alone...

    ROW.fieldNames : Name,Street,City

    ROW.fieldSeparator : ,

    ROW.endSeparator : 'nl'

    definitely it ill work....

    ur source file shoulld be...

    efe,ssdf,efef

    egh,fgf,fghf

    hope this helpful...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2007 at 10:57 AM

    hi,

    sometime it happens that there is some other parameter that would be required other than the mandatory ones. i am not sure, wat exactly is causing the trouble here..

    Also, sometimes it works when you give the hexadecimal equivalents for the separators also.

    check if this helps you: http://help.sap.com/saphelp_nw70/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htmhttp://help.sap.com/saphelp_nw70/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm">http://help.sap.com/saphelp_nw70/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2007 at 11:38 AM

    Juz try to refresh the cache once.

    <b>Cheers,

    *RAJ*</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2007 at 11:44 AM

    Venkat,

    in FCC Recordset Structure : RECORD,1,ROW,*

    then give and remove Recordset Name : RECORD

    RECORD.fieldNames : Recordname

    RECORD.fieldSeparator : ,

    RECORD.endSeparator : 'nl'

    .

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 03, 2007 at 12:03 PM

    Use the FCC defined here - /people/sravya.talanki2/blog/2005/11/29/night-mare-processing-huge-files-in-sap-xi

    Add comment
    10|10000 characters needed characters exceeded