FCC

[Former Member]

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

[Shabarish_Nair]

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

[Former Member]

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...

[Former Member]

Venkat,

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

then give and remove Recordset Name : RECORD

RECORD.fieldNames : Recordname

RECORD.fieldSeparator : ,

RECORD.endSeparator : 'nl'

.

[Former Member]

Juz try to refresh the cache once.

<b>Cheers,

*RAJ*</b>

[Former Member]

HI

can you give your DT structure here ?

---Ram

[Former Member]

Please look at DT file below:

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

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

<xsd:complexType name="FILEINPUT">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

f4401d7041b911dcbfd40011258ca532

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="RECORD">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13a76af040cb11dca9e100123f3f523d

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

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

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13a76af140cb11dc9c3900123f3f523d

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

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

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13a76af240cb11dca40b00123f3f523d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

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

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13a8f19040cb11dcbb3100123f3f523d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

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

<xsd:annotation>

<xsd:appinfo source="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

[Former Member]

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: <a href="http://help.sap.com/saphelp_nw70/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm">http://help.sap.com/saphelp_nw70/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm</a>