Skip to Content
avatar image
Former Member

content conversion parameters for fixed length file

Hi,

Hey i have a small doubt.My input is like this

99443 123213 232234 12312 127544 23423

Here i have four recorsetnames namely HEADER1,HEADER2,HEADER3,HEADER4,HEADER5,HEADER6 all the recordsets are of same size but the lengths of the fields in it vary so i specified the following parameters

HEADER1.fieldFixedLengths=1,3,1

HEADER1.fieldNames=value1,value2,value3

HEADER1.endseperator=" "

HEADER2.fieldFixedLengths=1,3,2

HEADER2.fieldNames=value1,value2,value3

HEADER2.endseperator=" "

MY OUPUT XML STRUCTURE SHOULD BE like this

<header1>

<value1>9<\value1>

<value2>944<\value2>

<value3>3<\value3>

<\header1>

<header2>

<value1>1<\value1>

<value2>232<\value2>

<value3>13<\value3>

<\header2>

.......

Is the content conversion parameters i specified enough for that. I wanted to know how would it know the begin of the next recordset(ie the seperation between the two recordsets) .Please help me its vey urgent

Thanks in advance

Sriandh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 29, 2007 at 05:12 AM

    Are header 1 fields always going to occur first , then header 2 and so on?

    By default file adapters do not support Nested Strcutures and so if the sequence is going to be the same and all of these have an occurence of 1..1 then things will work.

    But if there is going to be an occurnece of * then you will need to use KeyFields.

    Regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhavesh,

      Yes i have used keyFields.But my question is that the total recordset size is same i.e 80.But for the end seperator i have given it as " ".But the number of spaces are not same.Than in that case if i give

      HEADER1.endSeperator=' ';

      Than will it accept

      Thanks,

      Srinadh