on 08-03-2007 11:42 AM
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
Use the FCC defined here - /people/sravya.talanki2/blog/2005/11/29/night-mare-processing-huge-files-in-sap-xi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Venkat,
in FCC Recordset Structure : RECORD,1,ROW,*
then give and remove Recordset Name : RECORD
RECORD.fieldNames : Recordname
RECORD.fieldSeparator : ,
RECORD.endSeparator : 'nl'
.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Juz try to refresh the cache once.
<b>Cheers,
*RAJ*</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
can you give your DT structure here ?
---Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.