on 09-30-2013 11:45 AM
Hi All,
I want to convert CSV (Comma Separated Value) to XML format.So here In sender channel I am using File adapter with FileContentConvertion. I got Exception named bellow " conversion initilization Failed ,java.lang.Exception Error(s) in XML Convertion Parameter found.Format Error in 'xml.recordset' argument incomplete structure (name ,number) pair. "
Please help me how to resolve this issue.
PFA Screen shots my Scenario.
Input File Content:
2069,Mahesh,80000.00
Input is CSV , So In Sender Channel use File Adapter , and I am using File Content Conversion tab and Specify following details regarding input format
I Tested my Message Mapping, it is success.
But I got Exception " Conversion initialization Failed ,java.lang.Exception Error(s) in XML Conversion Parameter found.Format Error in 'xml.recordset' argument incomplete structure (name ,number) pair"
Please help me how to resolve , I think I did mistake in File Content Conversion ,Help me is there any modifications.
--
Thanks
Mahesh Mediboyina
Hi Mahesh
You need to add the following parameters in the parameter section
Recordset.fieldSepartor ( value will be , (comma)
Recordset.endSepartor ( value will be 'nl')
If you use key then you need to add the following paramter
Recordset.keyFieldValue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The issue is that you have defined the recordset structure wrongly. The fields you mentioned should come in the fieldnames, not in the place where you mentioned it now..
go through the below tutorial link and you can define accordingly.
ideally in your case, the recordset structure should be for ex. Emp_Det,1 (if there will be only one line in the file as mentioned by you or * if you will have more lines)
then you need to define.. Emp_Det.fieldNames = EmpNo, EmpName, EmpSalary etc.
http://saptechnical.com/Tutorials/XI/Contentconversion/page2.htm
Regards
Vishnu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Indrajit,
Yah ,I already tried what you have suggested to me , please check Content conversion tab
My input file have content like below
2069,Mahesh,80000.00
But I got Exception" com.sappi.adapter.xi.routing.RoutingException ,InterfaceDetermination did not yield any actual error "
Please tell me where I did I need to change..
I want to convert CSV file , to XML File ,so our system have to generate XML File ,in target directory ,we have give necessary details in receiver channel.I have monitored Sender and Receiver Communication channels , but I have found Run success with out errors , messages id also generated ,to these channels ,but I have not found target file in target directory.
I want to convert CSV file , to XML File ,so our system have to generate XML File ,in target directory ,we have give necessary details in receiver channel.I have monitored Sender and Receiver Communication channels , but I have found Run success with out errors , messages id also generated ,to these channels ,but I have not found target file in target directory.
Hi,
You did not provide the namespace for the document namespace & recordset namepsace in File CC. This namespace would be the namespace in which you have created the message type whose fields will be populated from the values from the CSV file. Also the names of fields are not provided in correct manner.
Refer to below link:
http://saptechnical.com/Tutorials/XI/Contentconversion/page1.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.