File Content Conversion

Hi,

I need to generate an XML file of the following structure:

<employee>

<name>

<first></first>

<last></last>

</name>

<address>

<street></street>

<city></city>

<zip></zip>

</address>

<designation></designation>

</employee>

I could have only 1 name and designation and multiple addresses in one employee recordset.

I am using FCC ( File content conversion)

Here are the parameters:

Recordset Structure: Name,1,Address,*,Designation,1

Key Field Name: key

Key Field Type: Integer

Name.fieldNames: first,last

Address.fieldNames: key,street,city,zip

Name.fieldSeparator: ,

Address.fieldSeparator: ,

Designation.endSeparator: nl

Address.keyFieldInStructure: 1

My input is:

Sam,Smith,1,100 Golden Drive,San Diego,77990,1,121 silver beach,san diego,77905,Manager

Dave,Green,1,111 abey lane,orange,77665,HR

Can you tell me what more I need to specify to get this working?