file content conversion

[former_member745782]

hello everybody

I have a interface Idoc->PI-> FTP

i need use content conversion with field Fixed Lengths  but i have ofthen errores.

when i receive a empty field my communication channell have a error.

It's possible add a parameter for ignore the empty field?

I configured the content conversion like in follow:

ROW.fieldFixedLengths  = 1,3,3,18,4,10

ROW.endSeparator = 'nl'

thanks

[Former Member · Accepted solution]

Hi Alessandro

You FCC configuration seems to be fine. Just to cross check you have entered Recordset Structure as ROW

ROW.fieldFixedLengths  = 1,3,3,18,4,10

ROW.endSeparator = 'nl'

Make sure when you say "i receive a empty field " that means the filed is generated at target structure but with null value. Empty tag should be there for that field.

FCC will put as many white spaces as mentioned in ROW.fieldFixedLengths for that filed. you need not to put any other parameter.

Regards

Raj

[former_member745782 · Accepted solution]

ok thanks.

I changed my mapping and now is not possible have missing field.

[Former Member · Accepted solution]

U can also use mapwithdefault function in mapping between each source n target field to avoid such situation.

thanks

chirag

[Former Member]

Hi Alessandro,

In FCC, if you are using fieldFixedLengths, you either have to use fieldSeparator or fieldNames. Else, it'll show errors. Here, if you get empty values, the spaces will be added in the file with corresponding lenghts.

Hope this helps.

Thanks & Regards,

Samir

[former_member745782]

ok thanks!

[Former Member]

Hi Alessandro,

There're no way with File Content parameters to do that.

However, what is your issue? You need to ignore the empty fields without writing space/fixed lenght field?

[former_member745782]

hi Simone,

i'm using fixed lenghts so i want have n blank spaces when the field is missing

So i need solve the problem in mapping?

[Former Member]

You can fill with Blank Character the output fields in the Mapping when input fields are empty.

However, FieldFixedLenght parameter, should be used to specify a character string containing a list of fixed column widths that are separated by commas and determine the number and the length of columns generated in the text file.