RecordList to XML

dennis2 · December 16, 2004, 10:48pm

Hi,
it’s me again.
I have a recordList as an outbound from a CSV parser.
Now I want to use “RecordListToRecord” and “RecordToXMLValues” to ceate a XML-File. (WMPub)
Unfortunately, I can’t the the code, so I don’t know what I have to fille in the strings Name and Value.

Can anyone help?
Is this the correct way to create a XML-file?

I used “convertDelimitedStringToRecordListWithColumnNames” (WMSamples) to parse my csv-file into a recordList.

Thanks for your help,

Dennis

atul_ahire.43935 · December 17, 2004, 12:13am

You can loop on the recordlist and inside you can use recordtodocument which will give u the xml for that record.

dennis2 · December 17, 2004, 9:52pm

Thanks Athul,
but then I get just the last dataset.
But I need all.

How can I realize?

Thanks,

Dennis

atul_ahire.43935 · December 18, 2004, 3:27am

You can Create one StringList element and in loop get the xml and append it to stringlist.
After loop you will have one stringlist with all xlms.

gupta_r.17495 · December 19, 2004, 1:33am

Dennis,

What you do is create a temporary record(this should have all the fields which you have parsed a recordList,root element is recordList NAme) do a map step and map the recordList to a recordReference(above created temporary document)and in the recordToDocument service just map the record and (set recordName),it gives output xmldata.

HTH,
RMg.