Skip to Content

FCC help for File receiver please

Hi all,

My issue was not resolved and so posting a fresh question which is much straight forward to ask.

Source is xml. (SOAP)

Target is csv file.

Source structure:

WS_Response ( 1 to 1)

Result ( 1 to 1)

Message ( 1 to 1)

Header ( 1 to Unbounded)

headerField1

headerField2

headerField3

Item_Line ( 0 to 1)

Invoices ( 0 to Unbounded)

invoiceFiled1

invoiceFiled2

invoiceFiled3

My target cvs file should be: (for example)

headerField1 headerField2 headerField3

invoiceFiled1 invoiceFiled2 invoiceFiled3

invoiceFiled1 invoiceFiled2 invoiceFiled3 (repeat)

headerField1 headerField2 headerField3 (repeat)

invoiceFiled1 invoiceFiled2 invoiceFiled3

invoiceFiled1 invoiceFiled2 invoiceFiled3

But I am getting:

headerField1 headerField2 headerField3 invoiceFiled1 invoiceFiled2 invoiceFiled3

invoiceFiled1 invoiceFiled2 invoiceFiled3 (repeat)

headerField1 headerField2 headerField3 invoiceFiled1 invoiceFiled2 invoiceFiled3

invoiceFiled1 invoiceFiled2 invoiceFiled3



My FCC is as follows:


Recordset Structure: Header,Invoices


Header.endSeparator : 'nl'

Header.fieldSeparator : ,

Invoices.endSeparator : 'nl'

Invoices.fieldSeparator : ,


I tried using addHeaderLine, filedNames, beginSeparator etc but did not achieve what I am looking for.


Can you guys help?


Many thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 21, 2014 at 04:50 PM

    Ok, I got it working myself.

    I have used L, as begin separator and removed the "key" field from the structure. I have also inserted an extra node just before the line items and it works as expected. Phew..!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.