on 06-04-2007 7:05 AM
hi all,
I have tried the file to file scenario and its working fine. Now i'm trying the file to csv scenario. In the same file to file scenario I have done changes in the receiver communication channel like file content conversion. In the datatype i have only one element with two sub elements, is that fine or do i need to change the receiving structure with more sub elements.
Hi,
Do the same as Jai says..
Your scenario is csv..these blog might help you...
<u>/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30
<u>/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem
Cheers!
Samarjit
Message was edited by:
Samarjit Dey
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Arunkumar,
If you could give the XML output after mapping, we can guide you better.
P.S: Your subject line and thread discusses different issues.Try to avoid this.
Regards,
Jai Shankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Arun,
Change your data type slightly. Add the tag <Employee>
<?xml version="1.0" encoding="UTF-8"?>
<ns0:messagetype xmlns:ns0="http:
ftptoftp">
<b><Employee></b>
<rollnumber>101</rollnumber>
<name>arun</name>
<b></Employee></b>
</ns0:messagetype>
FCC parameters
Recordset structure : Employee
Employee.filedSeparator ,
Employee.endSeparator 'nl'
Regards,
Jai Shanakr
>>is it mandatory in file to csv case that the receiving structure should have a extra element than the sending structure
No. To perform File Content Conversion, you need to have a structure that encloses the fields. In your case, the fields are rollno and another field. It does not have any enclosing structure. So I added a structure to enclose this.
The name Employee is arbitary. You can have any name.
Regards,
Jai Shankar
>>must be something in the conversion i guess...suggestions please
You are correct. But the only place that shows the error log related to FCC is RWB.
Fine. Let us give a try with out error msg. Give us the XML after mapping(copy it from SXMB_MONI) and the FCC parameters you have used.
Regards,
Jai Shankar
FCC parameters :
dt_filetocsv_receiver.fieldseparator ,
dt_filetocsv_receiver.endseparator 'nl'
dt_filetocsv_receiver.addheaderline 1
dt_filetocsv_receiver - this is the receiver datatype
xml file from sxmb_moni :
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_filetocsv_sender xmlns:ns0="http://arun_filetocsv">
<ROLLNO>101</ROLLNO>
<NAME>arun</NAME>
<ADDRESS>asdf</ADDRESS>
</ns0:MT_filetocsv_sender>
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.