Flat to XML problem

[Former Member]

Hi Experts,

My Record Structure is like this

Address

Record

Name

City

I given the Content Conversion Paramaters like

I have given the Document name is Message type name and namespace also,

Record Structure Given as Record,*

And

Record.filedNames Name,City

Record.fieldSeparator ,

Record.endSeparator 'nl'.

But it got the result like this

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

<ns0:Address xmlns:ns0="http://dheeraj/test/VM_ID"></ns0:Address>

so what is the wrong in that can any one please tell me.

Thanks,

Anil.

[Former Member]

Anil,

You dont need address in your datatype. Change your datatype like this:

Record

--Name

--City

Then do the mapping. Then in sender communication channel give this parameters:

Document Name : Give message type name

Document Namespace : Give message type namespace

Recordset structure : Record,*

Parameters:

ignoreRecordsetName : true

Record.fieldSeparator : ,

Record.endSeparator : 'nl'

Thats it your file will read into XI. Then in receiver communication also take the datatype same. Dont do content conversion. You will have the xml file.

---Satish

[Former Member]

hey

can u send the sender Data structure.

thanx

ahmad

[Former Member]

Hi

I text file is like this

Srini,Hydarabad

Prakash,Delhi

Veera,Pune

Thanks,

Anil

[Former Member]

hey Anil

where do u have address in here?

can u please send the sender data type structure u created Under Data type in IR(not the sender file)

i guess ur data type or parameters are wrong

[Former Member]

---

>Address

|----->Record

|-------Name

|-------City

This is my data type in IR

Thanks,

[Former Member]

Hey

as i understand ur structure is something like this

<Address>

<Record>

<Name>Mark</Name>

<City>NY</City>

</Record>

</Address>

right?

if yes, then use the following

Document Name: Address

Recordset Structure:Record,*

Note: * means occurence,i dont know whats the occurence u have specified.

ignoreRecordsetName= true

Record.fieldNames=Name,City

Record.endSeparator='nl'

Record.fieldSeparator=,

thanx

ahmad

Pl:Reward with points if helpful

Message was edited by:

Ahmad