content conversion parameters necessary for fixed length file

[Former Member]

Hi,

I new to xi.The scenario is that i have to handle a fixed length file where the records repeat after every 80 characters.Can anyone help me as to how thw identify the start of every record based on length

thanks and regards ,

srinadh

[Former Member]

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

[Former Member]

hey

have a look at the following

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

thanx

ahmad

[Former Member]

hi Ahmad,

My scenario is different from this my scenario is that every record is 80characters in length.For ex:99003243 32472384 2384634 234534534

Here how to identify the content conversion parameters.I just wanted how to identfy every new record

Thanks in advance,

Srinadh

[Former Member]

Hey

its pretty much the same:)

anyways,you have to use .fieldFixedLength in the FCC parameters

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

thanx

Ahmad

[justin_santhanam]

Srinadh,

Can u give the exact input flat file structure, is it like below structure.

99002342 44444444 234444444 24244444

24242424 24242421 242424244 24242424

Please confirm the same.

Best regards,

raj.

[Former Member]

Hey

this will help you out

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

Thanx

Ahmad

[Former Member]

hi,

u can specify the following parameters:

NameA.fieldFixedLengths

NameA.fieldFixedLengthType

NameA.endSeparator

NameA is ur recordset structure

regards,

latika.

Message was edited by:

Latika Sethi

Message was edited by:

Latika Sethi

[Former Member]

Yes Raj it is pretty much the same but with a small change that the number of characters may vary for ex:

99002 4444444 2344444 24244444

the characters may vary but the seperation is the same

Thanks in advance,

Srinadh

[Former Member]

Hey

>>NameA.fieldFixedLengths

NameA.fieldFixedLengthType

NameA.fieldSeparator

you need to specify either .fieldFixedlengths or .fieldSeparator,no need to specify both

Thanx

Ahmad

[Former Member]

hi ahmad,

thanx. that was a slip of mind actually ...i intended to write end separator )

i have edited the previous message!!!

regards,

latika.

[Former Member]

Hey

even if the characters might vary but still its fixed length,right?

so ur structure is something like this

<Recordset>

<Tag1>99002</Tag1>

<Tag2>4444444 </Tag2>

<Tag3>2344444</Tag3>

<Tag4>24244444</Tag4>

</Recordset>

right?

so now you need to tell us what is the field length for Tag1,Tag2,Tag3 and Tag4 and wel will give you u the parameters

Thanx

Ahmad

Message was edited by:

Ahmad

[justin_santhanam]

Srinadh,

Please clarify this too. How many columns do u have in one row.

See if its 4 as u give above.

Then you have to define the structur as

Records

---Row

-

---

Field1

-

---

Field2

-

---

Field3

-

---

Field4

is it am I right?

Then give Row.fieldSeparator 'nbsp'

Row.endSeparator 'nl'

I never tried with 'nbsp'. If its not working then give the equivalen Hex value for it.

Is my above understanding is correct?

Best regards,

raj.

[Former Member]

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,HEADER6so 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