cancel
Showing results for 
Search instead for 
Did you mean: 

File Contentent Conversion

rajasekhar_reddy14
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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]

Answers (2)

Answers (2)

rajasekhar_reddy14
Active Contributor
0 Kudos

thanks

Former Member
0 Kudos

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