Excel file to Idoc scenario

[Former Member]

Hi guys,

I have the following scenario to be developed in XI:

An Excel file instead of a flat text file will be sent to an ftp location as an input (containing all the data in multiple rows) and then I have to produce some Idocs from that file, by making use of BPM as well. What do I need to do. I thought that logic would be the same like in case of flat text files. So I started with developing data type, messsage type, message mappings, Interface mappings, BPM etc. However, I checked that I need to develop modules for processing an Excel file, from link /people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter .

Can somebody explain what is the process?

Do I need to conert Excel into Flat file or XML file first and then use the logic I have developed?

Best Regards

Evaggelos Gkatzios

[Former Member]

HI,

For the given link in your question,

First u need to develop one module in SAP NETWEAVER DEVELOPER STUDIO.Through J2ee engine u shoud deploy ur bean on XI Server.While developing the

module in NWS u should put the jxl.jar

(as a external jar file).

If u want to doc on creating modules just check the wonderful document.

How To Create Modules for the J2EE Adapter Engine at service.sap.com. It will clear all the basics of creating Adapter module.

https://websmp102.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000582377&;

Thanks

swarup

[Former Member]

Hi.

Chk dis link...it might be helpful

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

regards

Prashant

[former_member187563]

hi,

Can somebody explain what is the process?

If you are talking about the process of module development then you have to refer:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3bdc14e1-0901-0010-b5a9-a01e29d7...

Do I need to convert Excel into Flat file or XML file first and then use the logic I have developed?

Yes you have to convert your excel file into a flat file or xml file.

regards,

ujjwal kumar

[Former Member]

hi

go thru below blog for

Read Excel instead of XML through FileAdapter

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

regards

chandra