File content Conversion

[Former Member]

Hi all,

My receiver structure is like this

Manager(Message name) has no root node

emp1

emp2

emp3

emp4

My requirement is to convert from XML to csv.

in CC(FCC)

in the Record structure i gave as Manager.

Manager.fieldSeparator =,

Manager.endSeparator ='nl'' .

When I give this

the CSV file is generated with no structure or fields present in it.

Pay load can be seen in moni,please clarify.

Thanks,

Srini

[Former Member]

Hi srinivas,

what is ur source structure???

Thanks,

Maheshwari.

[Former Member]

Phani,

<i>in the Record structure i gave as <b>Manager</b>.</i>

You have to give your record structure name here. But here it is your Message name and not the record structure name.

So add one more field as Record and then within it add all your fields and then you give recod set structure name as Record and your file content conversion parameters. Then it will work like a boom.

---Satish

[Former Member]

Hi Satish,

As per my requirement I should not change the structure.

Please suggest other way.

Thanks,

Srini

[Former Member]

Hey

>>Manager(Message name) has no root node

XML file is not valid without a root node,u have to have a root node,then only u can use correct FCC

also check in RWB,adapter monitoring,u shud be getting some errors there

thanx

ahmad

[Former Member]

Hi ahmad,

As i mention in my message,The FCC is in receiver side,Manager is in receiver side for which i need to do FCC.

Thanks

[moorthy]

Hi,

what is the receiver message in SXMB_MONI ? How it looks ? This message will be going to Reciever File adapter ..

For e.g does it look like this :

<Manager>

</field1>

</field2>

</Manager>

If so just give Manager.fieldSeparator = ,

Manager.endSeparator = 'nl'

Check out the structure.,

Hope this helps,

Moorthy

[Former Member]

hey

u have to have a root in ur XML for FCC to work properly,can u post the XML from the receiver side ur getting from Message mapping .

as pointed out earlier,looks like u need to add an extra tag

thanx

ahmad

[Former Member]

No this is not working