on 03-14-2008 1:51 PM
Dear ALL,
I am doing file to file scenario, where i have to convert txt file from sender to xml as receiver .
I have done with all the conversion content parameters at the sender file adapter as below:
DocumentName:
DocumentNamespace:
RecordsetName:
RecordsetStructure:
Row.fieldNames :
Row.fieldSeparator:
Row.endSeperator:
Row.fromConfiguration;
Row.fieldFixedLengths:
Am i missing anything
still i am getting error as .
Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'Row.fieldFixedLengths' or 'Row.fieldSeparator' is missing Consistency check: no. of arguments in 'Row.fieldFixedLength' does not match 'Row.fieldNames' (0 <> 6)
Could anyone let me know where i am wrong in config.
Kind Regards,
Vijay
hi,
have a look at the following FCC blogs:
[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1825] [original link is broken] [original link is broken] [original link is broken];
[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/7053] [original link is broken] [original link is broken] [original link is broken];
Reward points if useful
regards
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i think the error occured in the field lengths
check the filed lengths in the text file ,and the same field lengths must be specified inthe FCC parameters
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vijay,
Could you give the sample CSV file looks like?
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Raj,
Please find the details
DocumentName: sto_dc.txt
DocumentNamespace: http://..
RecordsetName: MT_STO_FILEOUT
RecordsetStructure: Row,*
Row.fieldNames : Document_number,Site,Date,Item_number,
Article_number,Quantity
Row.fieldSeparator: ,
Row.endSeperator: 'nl'
Row.fromConfiguration; fromConfiguration
Row.fieldFixedLengths: 8,4,8,2,6,2
Regards,
Vijay
DocumentName: sto_dc.txt----
>Message Type Name
DocumentNamespace: http://........---Name Space
RecordsetName: MT_STO_FILEOUT -
Root node of the DATA Type
RecordsetStructure: Row,*
Row.fieldNames : Document_number,Site,Date,Item_number,
Article_number,Quantity
Row.fieldSeparator: ,
Row.endSeperator: 'nl'
Row.fromConfiguration; fromConfiguration
Row.fieldFixedLengths: 8,4,8,2,6,2
you cannot give the Fielld Fixed lenght and field separator at once,,,,,remove the fixed field lengths your file is an , sepereator not fixed length one.
Hi,
Even if i am using fieldSeparator,
i am getting error as
Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Format error in 'xml.recordset' argument: incomplete structure (name,number) pair
Can any one guide me on this....
Regards,
Vijay
Dear All,
I would like to thank one and all for their valuable time and suggestions in sharing time to fix this problem.
Now the problem is fixed..... i found a small bug..which costed
everyone's time.
a small spelling Mistake in FCC ...
i have mentioned as field.Seperator....
instead of field.Separator.
Kind Regards,
Vijay
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.