Flatfile with fixed field Lengths

[Former Member]

Hi All,

This is just a simple question regarding File Content Conversion parameters

I have here the desired/correct output of the flatfile,

PERIO;EAN;ILN;SALES;TURNO;PERFL;SUBSFL;SALUN;%CURRENCY%;STOCK;STOUN;ARTNR;ARKTX

20071020;737052020198 ;4333342000008; 1; 9.95;W;X;ST ;EUR;0000000000;ST ;

20071020;737052056852 ;4333342000008; 1; 14.50;W;X;ST ;EUR;0000000000;ST ;

20071020;737052073552 ;4333342000008; 1; 12.95;W;X;ST ;EUR;0000000000;ST ;

But, im getting this error output during my test,

PERIO;EAN;ILN;SALES;TURNO;PERFL;SUBSFL;SALUN;%CURRENCY%;STOCK;STOUN;ARTNR;ARKTX;CRLF

20071222;737052018164;4304452000004;16;120;W;X;ST;EUR;0000000000;ST

20071222;737052018232;4304452000004;3;38.699997;W;X;ST;EUR;0000000000;ST

20071222;737052018263;4304452000004;1;12.9;W;X;ST;EUR;0000000000;ST

The parameters that i've set in File Content Conversion Parameters are,

Recordset Structure: SLI

SLI.addHeaderLine: 3

SLI.headerLine: PERIO;EAN;ILN;SALES....

SLI.fieldFixedLengths: 8,13,13,10, ...

SLI.fixedLengthTooShortHandling: Cut

SLI.fieldSeparator: ;

SLI.endSeparator: 'n'

When, i've test my scenario, im still getting the output that has no fixed lengths on each column.

I must output the one mentioned in the first part, that is, having a defined fixed length.

Can someone advise what is wrong on my parameters set?

Are the sequence wrong?

Is the format of the SLI.fieldFixedLengths correct?

Kindly advise.

Thank you very much!

Fred

[Former Member]

u cannot use both field seperator and fixed lenghts together.

and also pl change ur the value of end seperator as 'nl'.

thanks

kiran

[Former Member]

Hi All,

If i will not use fieldSeparator, will the semicolon ( be present on my output fields?

Each value must be separated by ";" symbol. (semi-colon)

Kindly advise.

Thank you!

Fred

[Former Member]

hi

if u want each value must be separated by ";" then u have to use field separator.

BR

Kasturika

[Former Member]

Hi All,

So, it means that fieldfixedLengths and fieldSeparator must both configured in the File Content Conversion parameters? (they will exists both)

Am i right?

Kindly advise.

Thanks

[Former Member]

hi

in fCC u can use either fileSeparator or fieldfixed length but u cant use the both.. as ur requirement is for field separator go for field separator.

the purpose of using filed separator and filed fixedlength is same. so depending on our output file we go either for filed fixed length or fieldseperator. Hope this time u got ur answer. according your reqirement go for filed separator.

BR

Kasturika

Edited by: Kasturika Phukan on Mar 10, 2008 1:48 PM

[GabrielSagaya]

Recordset Structure: SLI

SLI.addHeaderLine: 3

SLI.headerLine: PERIO;EAN;ILN;SALES....

SLI.fieldSeparator: ;

SLI.endSeparator: 'nl'

Here You should not use FieldFixedLength.

You must specify at least either NameA.fieldFixedLengths or NameA.fieldSeparator.

If you have only specified NameA.fieldSeparator, the structures of the XML document can have differing numbers of elements that are added to each other separately in the text file by the value from NameA.fieldSeparator. If you specify NameA.fieldFixedLengths this is not possible since the number of columns is defined when the column widths are given.

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

[Former Member]

your config looks fine except for SLI.endSeparator: 'n' it should be SLI.endSeparator: 'nl' .

[Former Member]

Hi,

Your file content converson is not correct. Probabily you can first go through few examples then it will be good to understant the concept.

by the way endSeparator is 'nl' not 'n'.

Please go through these blogs.

Introduction to simple(File-XI-File)scenario and complete walk through for starters(Part1)

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

Introduction to simple (File-XI-File)scenario and complete walk through for starters(Part2)

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

Content Conversion (Pattern/Random content in input file)

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

NAB the TAB (File Adapter)

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

How to send a flat file with various field lengths and variable substructures to XI 3.0

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

File Content Conversion for Unequal Number of Columns

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

Content Conversion ( The Key Field Problem )

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

How to send a flat file with fixed lengths to XI 3.0 using a Central File Adapter

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

File Receiver with Content Conversion

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

File Adapter (Receiver)

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

Sdn help

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Sarvesh