CSV to XML Scenario

[Former Member]

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.

[Former Member · Accepted solution]

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

[santhosh_kumarv]

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...

[Former Member]

Hi,

Read Excel instead of XML through FileAdapter

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

Thanks,

Madhu

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