on 06-29-2007 4:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
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
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.