on 04-11-2011 11:50 PM
Hi,
I'm making a Receiver File Adapter using File Content Conversion with an expected output of a CSV file. My structure is:
<?xml version="1.0" encoding="UTF-8" ?>
<ns0:CostCenter_Test xmlns:ns0="http://namespace.com/xi/system/IF00000111/100" partition="SAPDemo" variant="SAP">
<CostCenter_CostCenterPull_Item>
<item>
<UniqueName>Unique</UniqueName>
<CompanyCode>FRAA</CompanyCode>
<CostCenterDescription1>Test Cost Center</CostCenterDescription1>
<CostCenterDescription>Test Cost Center Ver 1234</CostCenterDescription>
</item>
</CostCenter_CostCenterPull_Item>
</ns0:CostCenter_Test>
<item> node would be repeating.
Recordset Structure is: Main, item
Params:
Main.fieldSeparator: #
item.fieldSeparator: ","
item.beginSeparator: "
item.endSeparator: "'n'
Problem: I can't add a headerline.
Question: Is this because I have two 'structures'?
Another problem is that if I only make one Recordset Structure (i.e. item), the output would only be: "Unique". But it would show the header lines.
Do I need to add another 'structure', just for the header lines?
If you want Header should appear one time and Item repeats then
Recordset Structure : Main,1, item,*
Hope that helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You may add header line.
Define structure as
Root
item
field1
field2 ....
and give item.addHeaderLine = 1.
It will generate header line as field1 , field2 ....
You may also define your own header line.
Please check below link for more information:
[http://help.sap.com/saphelp_nwpi711/helpdata/en/44/686e687f2a6d12e10000000a1553f6/content.htm]
Regards,
Beena.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
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.