on 06-01-2009 7:31 AM
Hi Frnds,
I am receiving Flat file(.txt) from File Sytsem i hav to read that file using file adapter i have to use File Content Conversion , but i never worked on that help me on this
Flat File:
000000009900000201;17;2007;413.000 ;361.000 ;362.000 ;361.000 ;384.000 ;400.000 ;400.000 ;400.000 ;377.000 ;361.000 ;362.000 ;361.000 ;363.000 ;374.000 ;373.000 ;373.000 ;374.000 ;363.000 ;361.000 ;362.000 ;361.000 ;366.000 ;373.000 ;374.000 ;373.000 ;372.000 ;361.000 ;361.000 ;362.000 ;361.000 ;361.000 ;361.000 ;362.000 ;361.000 ;365.000 ;373.000 ;374.000 ;373.000 ;373.000 ;361.000 ;361.000 ;362.000 ;361.000 ;368.000 ;373.000 ;374.000 ;373.000 ;370.000 ;361.000 ;362.000 ;361.000 ;361.000 ;0.000 ;0.000 ;19200.000.
My Output Format
<Records>
<Record>
<Field1>
<Field2>
<File3>..........<Field58>
text file may contain single record or multiple recored it 1:unbounded but if first number starts with 000000009900000201 number sequece..
How to use FCC for above structure help me on this
Regards
Raja Sekhar
In the Content conversion parameter (in the sender communication Channel)
specify the paremeters as shown below if ur source structure is like this
<MT_Source>
<Records>
<Record>
<Field1>
<Field2>
<File3>..........<Field58>
</Record>
</Records>
</MT_Source>
Document Name :MT_Source
Document Namespace:Specify the namespace under which u have created ur source message type
RecordSet name:Records
RecordSet structure:Record,*
Record.fieldSeparator:,
Record.fieldNames:Field1,Field2,Field3(Specify all Fields separated by comma)
Record.endSeparator :'nl'
choose + to add extra parameters specified above
for detail about File content conversion at sender adapter see this link [http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check links for using file content conversion.
[https://wiki.sdn.sap.com/wiki/x/8QEPB]
[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7154] [original link is broken] [original link is broken] [original link is broken];
For creating sequence number is not possible at FCC level.You need to do that in Mapping level
Map like below.
If your Record structure is 0-unbounded then,
Constant(00000000990000020)---------------concat---Field1
Record--index--Splibyvalue(each value)---
Regards,
Prakasu.M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.