File adapter - content conversion

[Former Member]

Hi all,

I have one parameter x in my structure which identifies on which server the file should be generated.

After this parameter I have this structure: (rows of the file)

Recordset structure: ns0:MT_STDB_FILE,row,row.column

ns0:MT_STDB_FILE.fieldSeparator |

row.fieldSeparator |

row.column.fieldSeparator |

row.endSeparator '0x0D''0x0A'

The file will be generated successfully.

But in the first line the first value is the value of the parameter x.

I don't have specified the parameter x in the recordset structure.

How can I remove the value of parameter x?

Regards

[Former Member]

1. Does this pertain to file to XML or XML to flat-file conversion?

2. If file receiver::

a. I guess the value will be ignored if you do not specify its XML element in the Recordset Structure field

b. Additionally, you can always have an extra map placed after the existing map to remove that value

rgds

gab

[Former Member]

Hi,

it is file receiver channel. (7.1 EHP1)

I guess the value will be ignored if you do not specify its XML element in the Recordset Structure field

-> I don't have the parameter x in the recordset structure

Additionally, you can always have an extra map placed after the existing map to remove that value

-> I think this is working -> but I think it is not the best solution

How can I remove the value of the parameter x without having an additional mapping which removes the value?

Regards

[Former Member]

hi Wolfgang,

Just an idea, in your target structure (Data Type), do not define your "x" parameter as an "element" (so a field), but as an "attribute" of a field. And in your Receiver Determination, do your control on this attribute.

I think the attribute should not appeared after the content conversion in the file.

As it's just an idea (never did it with a file content conversion), do a copy of of your Data Type, do test it.

Regards

Mickael

[Former Member]

>> How can I remove the value of the parameter x without having an additional mapping which removes the value?

My assumption is that if you do not specify the element "X" in the field Recordset Structure, then its value won't be output to the flat-file

So you would have a flat-file without any reference to "X" or its value

So where is the issue?

Also, why are you bothered with removing "X" before it reaches file adapter?

rgds

gab

[Former Member]

Hi,

I don't have field x in the recordset structure! Please have a look at my configuration. First post.

That is exectely my problem.

Parameter x has at runtime the value 'I' or 'C'.

My file looks like this:

C|field1|field2|field3...

field1|field2|field3...

field1|field2|field3...

The C is the problem.

The value of parameter x = C is necessary in the receiver determination.

I = Server A

C = Server B

Regards

[Former Member]

You should create a structure such as x lie as a separate node say NodeX. Then use the content converion and include the

NodeX.fixedFieldLength = 0

NodeX.fixedLenghtTooShortHandling = Cut

Recordset structure: ns0:MT_STDB_FILE,row,row.column,NodeX

ns0:MT_STDB_FILE.fieldSeparator |
row.fieldSeparator |
row.column.fieldSeparator |
row.endSeparator '0x0D''0x0A'

It will allow you to remove the filed at the time of CC.

Regards

Raj

[Former Member]

>> The value of parameter x = C is necessary in the receiver determination.

But you stated earlier that it is receiver file adapter?

Does the structure given above( C|field1|field2 ; field1|field2 ...) belongs to sender or receiver file adpater?

rgds

[Former Member]

Hi,

I think the behaviour of the file content conversion changed in version 7.1 EHP1?

I tried the following:

Recordset structure: row

row.addHeaderLine 0

row.fieldSeparator |

row.endSeparator '0x0D''0x0A'

Then the content looks good.

But the first line of the file is empty.

regards