on 2013 Dec 17 4:49 PM
Hello Experts
I have a requirement to generate a CSV file on an SFTP server for each IDOC triggered from ECC. One of the business requirements is to add the header(with the field names) in the CSV file. I used the module MessageTransformBean to achieve this; the CSV file is getting created fine but without the header.
I have used the parameter "addHeaderLine" to add the header in the CSV file in the module configuration but it doesn't work. Could you please check if I have missed any parameter for this functionality?
Regards
VJ
Hello,
Cross check ur header line parameter, in addition to that i believe u don't need to use StructXML2Plain, SimpleXML2Plain parameters would suffice.
http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm
Thanks
Amit Srivastava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You are right, it seems that simpleXML2Plain is creating header and data in the same line.
I would suggest you to use "StrictXML2Plain" parameters.
http://help.sap.com/saphelp_NW04/helpdata/en/44/748d595dab6fb5e10000000a155369/content.htm
For the below XML structure, strictXML2Plain parameters will be (i have tested it and it's working fine):
<MT>
<Record>
<Name>ABC</Name>
<Age>26</Age>
<Designation>Consultant</Designation>
</Record>
<Record>
<Name>ABC1</Name>
<Age>25</Age>
<Designation>Senior Consultant</Designation>
</Record>
</MT>
Thanks
Amit Srivastava
Hello,
I don't have SFTP in my landscape so tested above parameters with File. But i don't see any reason why it should not work.
BTW, make sure the sequence of modules are properly maintained.
>>Are you using only those 4 parameters that you showed in the snapshot?
Yes, for the above mentioned XML structure, 4 parameters mentioned in the screenshot would suffice.
In addition to that, i have noticed that if u open text file created using MTB module (SimpleXML2Plain) with notepadd++ (or using some editor instead of notepad) u will find that header and data are coming in separate lines which eventually means that file is properly created.
Not sure, why file is not properly aligned in case of noteapd view, may be it's just a editor problem...
Thanks
Amit Srivastava
User | Count |
---|---|
69 | |
12 | |
11 | |
10 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.