Skip to Content
0
Former Member
Mar 30, 2011 at 02:23 AM

Error Reading up a CSV file

67 Views

Hi,

I am doing a File (SalesData.csv) -> PI -> IDOC scenario and have created a DT, MT and also made FCC configuration in sender File Channel.

However, when I run the scenario I get an error message in Channel Monitoring.

CSV File:

12,36,45,78,89

2154,789,65,78,99

This CSV file should be converted into an XML by FCC like:

<MT_SalesData>
<Data>12,36,45,78,89
2154,789,65,78,99</Data>
</MT_SalesData>

I used FCC in the channel like:

Document Name: MT_SalesData

Document Namespace: actual namespace of the MT

Recirdset Name: MT_SalesData

Recordset Structure: Data,1

Error in Channel Monitoring:

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'Data.fieldFixedLengths' or 'Data.fieldSeparator' is missing Mandatory parameter 'Data.fieldNames': no value found

What more information should I include in the FCC? If required I can change the DT.

Entire content of the SalesData.csv file should be placed inside the Data tag, as is without any modification.

Thanks

Pankaj