cancel
Showing results for 
Search instead for 
Did you mean: 

FileReceiver Content Conversion fixed Order in CSV structure

Former Member
0 Kudos

Hello together,

I have a mapping problem, my message mapping doesnt create the target structure in the order it is given in the XSD:

Target Structure:

<sequence>

<element name="A">

<element name="B">

</sequence>

but after mapping die elements are switched:

<B> Letter B</B>

<A> Letter A</A>


Is there a way forcing the mapping to write the elements in the order given by the xsd?


The Main Problem is that I want to write a Text File with a comma separated structure (CSV) as example:

A;B

Letter A;Letter B


But the Fileadapter writes the file structure in the wrong order:


B;A

Letter B;Letter A


I found no way to write the file structure as I wanted. My FCC Parameters are:


Recordset Structure:     item


Parameter 1:                 item.fieldSeparator     = ;

Parameter 2:                 item.addHeaderLine   = 1

Thanks for any help.

Rgds Steffen


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I found the answer by my self.

the Only thing to do is in message mapping insert SplitByValue and now the Structure will every time a XSD defined!

Thanks.

former_member186851
Active Contributor
0 Kudos

Great to hear.

Answers (1)

Answers (1)

former_member186851
Active Contributor
0 Kudos

Hello Steffen,

Try using Sort function in Mapping

Former Member
0 Kudos

Thanks for reply, but there are no criteria for sorting. my example may give the impression, but the simple thing I need it that after mapping I got exactly the structure in the order of the xsd.

Or changing the order of items in de FileReceiver.