Skip to Content
avatar image
Former Member

CSV to XML Scenario

Hi All,

I am having a scenario in which a CSV file is getting converted to a xml file. I have configured the FCC parameters in my sender file channel. The file is getting converted to xml, but the issue is that the output xml file is having only those fields which are mapped to constants other fileds are not present (not even blank fields).

Plesae help me solve this issue.

Thanks,

Abhishek.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 09, 2008 at 10:15 AM

    Hi

    you can use the following parameters in the sender communication channel.

    Document Name: your Mesage type Name

    Document Namespace: your Namespace Name

    Recordsert Name --your parent node name

    RecoredSetStructure: your node name with occurence

    for(0..unbounded[*], 1.1[1])

    RecoreSetSequence--Ascending

    in the below column

    parent node name.fieldseparator-----whatever u have in ur file(#)

    parentnodename.fieldNames----


    all filed name in that node.

    if u still face the problem please reply me back.

    Thanks

    Rinku

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2008 at 10:01 AM

    Hi,

    Read Excel instead of XML through FileAdapter

    Read Excel instead of XML through FileAdapter

    XI: Generating Excel files without the Java nor the Conversion agent not possible?

    https://blogs.sap.com/?p=41123

    Thanks,

    Madhu

    Edited by: Madhu on Jul 9, 2008 12:01 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 09, 2008 at 10:04 AM

    Hi,

    1. Check if the inbound XML file is holding the correct data as in the CSV file.

    2. Check if the mapping is sufficently defined.

    3. Copy the payload from the monitor and test it in the Message Map

    Thanks

    SaNv...

    Add comment
    10|10000 characters needed characters exceeded