Skip to Content
avatar image
Former Member

Flatfile with fixed field Lengths

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Mar 07, 2008 at 05:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2008 at 11:26 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 10, 2008 at 05:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2008 at 06:06 AM

    u cannot use both field seperator and fixed lenghts together.

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

    thanks

    kiran

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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