File to File scenario but input file is TXT format

[Former Member]

Hi ,

i need to do File to file scenario.. but the input file format is TXT .. how can i load this file into taget..

what is the procedure.,.

Thanks

babu

[Former Member · Accepted solution]

Hi babu

if you have file(txt) to file(xml) scenario the steps required are

1. create all the integration repository objects

data type

message type

message interface

message mapping

interface mapping

2. create all the configuration objects

sender agreement

receiver determaination

interface determination

receiver agreement

sender communication channel

receiver communication channel

and on the sender side use the content conversion

RECORD.fieldSeparator :,

RECORD.fieldNames :KEY,FNAME,LNAME,AGE

RECORD.keyFieldValue :1

DETAIL.fieldSeparatr :,

DETAIL.fieldNames :KEY,SALARY,EMPID

DETAIL.fieldNames :2

Note:these parameters are accoding to the structure given below.

suppose you have a structure like as below

data (0..unbounded)

record (0..unbounded)

key (1..1)

fname (1..1)

lname (1..1)

age (1..1)

detail (0..unbounded)

key (1..1)

salary (1..1)

empid (1..1)

and the input file will look like as below

1,aaa,bbb,23

2,12000,10838

1,ccc,ddd,23

2,13000,10830

Thanks

Rinku

[Former Member]

Hi,

babu

u have to do the content conversion in sender communication channel,

first in messageprotocol:file content conversion

and it will ask the content conversion parameters

DOCUMENT NAME:YPURS MESSAGE TYPE

DOCUMENT NAMESAPCE:GIVE UR NAME SPACE

RECORDSETNAME:RECORD NAME THAT U HAVE GIVEN IN UR D

ATATYPE

RECORDSETSTRUCTURE:THE STRUCTURE NAME THAT U HAVE GIVEN IN UR DATATYPE

RECORDSET SEQUENCE:BASED ON UR REQUIREMENT

AFTER THAT U HAVE TO MENTION THE KEYFIELD NAMES,FIELD SEPARATOR

OK

BYE

[Former Member]

hi babu

can you please send me the your source text file

Thanks

Rinku

[Former Member]

Hi,

you need to follow the below procedure

1. sender side you need to use content conversion parameters for converting the TXT file in sender communication channel

2. do the IR , and with mapping , here is main if you want send the same structure from source to target , you dont need to have mapping , one data type , one message type and two interfaces one for sender and one for receiver. no mapping.

next config ID.

2. if you want send the same file to the target side then you need to do the same , i mean content conversion in receiver communication channel.

refer above links like

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

Chilla

[Former Member]

Hi babu,

What is ur senario exactly.....u want to send a TXT file from sender side and Receiver side also u need TXT file?.........if this is the case then use file content convertion at both the sides Receiver side and Sender side.

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

Regards,

Phani.

Reward points if it is helpfull

[Former Member]

Hi babu

you can also refer to this blog foor simple file to file scenario

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

[santhosh_kumarv]

Hi BABU,

>>i need to do File to file scenario.. but the input file format is TXT .. how can i load this file into taget..

I this case u should do the Content conversion to convert the txt file to the XML format at the sender and convert back the XML message to txt format in the receiver.

Go thru this wiki

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/flatFILETOFLATFILE&">FLAT FILE TO FLAT FILE</a>

Go thru this link for the FCC parameters...

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

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards

San

there is a Way.

[Former Member]

hi babu

to uplaod the file in the XI you have to do the content conversion at the sender side to convert the txt file into the XML file bcoz XI can understand only the XML file.

Thanks

Rinku

[Former Member]

Hi babu !

refer these Blogs

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter

and also have a lok at this Thread

Thanks !!