Skip to Content
avatar image
Former Member

File Adapter Question

Hi,

I've got a File Adapter receiver which should convert the following XML to a CSV file:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:_-BI0_-QI6AEST_S_ORGUNIT_XI_RFC xmlns:ns0="urn:sap-com:document:sap:rfc:functions">

<DATASOURCE>

</DATASOURCE>

<DATA>

<item>

<_-BIC_-S_ORGUNIT>10</_-BIC_-S_ORGUNIT>

<_-BIC_-S_ORG_LEV>2</_-BIC_-S_ORG_LEV>

<_-BIC_-S_CH_ON></_-BIC_-S_CH_ON>

<_-BIC_-S_CR_ON></_-BIC_-S_CR_ON>

<LANGU>DE</LANGU>

<TXTSH>Unit1</TXTSH>

<TXTLG>Unit1long</TXTLG>

</item>

<item>

<_-BIC_-S_ORGUNIT>11</_-BIC_-S_ORGUNIT>

<_-BIC_-S_ORG_LEV>3</_-BIC_-S_ORG_LEV>

<_-BIC_-S_CH_ON></_-BIC_-S_CH_ON>

<_-BIC_-S_CR_ON></_-BIC_-S_CR_ON>

<LANGU>DE</LANGU>

<TXTSH>Unit2</TXTSH>

<TXTLG>Unit2long</TXTLG></item>

</item>

</DATA>

</ns0:_-BI0_-QI6AEST_S_ORGUNIT_XI_RFC>

I have configured the file receiver adapter respectively. The record set structure is item. The parameters for content conversion are item.addHeaderLine 0, item.fieldSeparator ; and item.endSeparator 'nl'.

I would expect the follwing CSV file content:

10;2;;;DE;Unit1;Unit1long;

11;3;;;DE;Unit2;Unit2long;

Instead I get the follwing output:

10;11;

Does anybody know what might be the problem here?

Kind regards,

Heiko

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 22, 2005 at 12:09 PM

    Hi Heiko,

    Your configuration seems to be fine.

    I am not uble to understand what is <DATASOURCE></DATASOURCE> in your structure. Try giving this name also in record set structure and before item and give dummy fieldSeparator.

    Hope it works,

    Regards,

    satish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Satish,

      thanks for your help. Unfortunately I can't influence the structure of my XML Output. It results from an imported RFC. So I will have to use the XML output for now.

      Kind regards,

      Heiko