Design of File to File Scenario

[former_member190358]

Hello Everyone,

I have to pick CSV file from R/3 application server and convert it to XLS file and drop it in FTP Server.

Can anyone help me with the design and configuration steps.

Regards,

Ravi

[prateek]

Too basic question. Thread locked.

[Former Member]

pick CSV file from R/3 application server and convert it to XLS file and drop it in FTP Server.

that is possiable with adapter framework.

create Adapter framework.

In ESr:

->you have to create data type and message type , service interfaces for sender and receiver .

->create Operation Mapping and MM .

IN ID :

->create Sender Communication channel and transport protocal is FTP, msg.protocal is FCC

and crete sender agreement

->create Receiver Communication channel and transport protocal is FTP and crete Receiver agreement

->Create ID and RD.

for ex:

http://www.saptechnical.com/Tutorials/XI/Adapter/Index.htm

[rajasekhar_reddy14]

Hi,

use file sender channel in sender side to pick up data from Application server and implement file content conversion to in sende channel to convert XML file.

You have to write adapter module in receiver channel to convert in excel files.

many blogs and discussions avaiable on similar requirement.pls do search in sdn.

Regards,

Raj

[former_member415468]

Hi,

Plz check the below links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4013f6bb-7ec3-2b10-62b5-e5be01e49...

Edited by: Muni 1234 on Jan 30, 2012 4:32 AM

[Former Member]

Hi,

Check these links: [http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13846] [original link is broken] [original link is broken];

[https://wiki.sdn.sap.com/wiki/display/XI/CODE%20-%20Create%20an%20Excel%20File%20via%20the%20JExcel%20API]

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4013f6bb-7ec3-2b10-62b5-e5be01e498f7?QuickLink=index&overridelayout=true]

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1312] [original link is broken] [original link is broken];

Regards,

Horia