SAP MII Custom action block

[Former Member]

I am trying to develop custom action block which will read excel file and parse it to XML .

I can create java object for my xml pattern but how can i pass this java object to MII?

Please help me in this issue. If possible please send me one sample code for custom action block for which output will be XML.

Thank you !

[former_member196557]

HI Manjiri,

Rather than write a custom action block, why not use standard functionality with MII and Plant Connectivity (PCo):

1. Deploy PCo on a Windows PC (or MII Server is Windows Server OS), and create an OleDB Source System and Agent instance that can be queried from an MII PCoQuery. You can directly read the Excel spreadsheet and the results will be returned in the standard MII Rowset XML schema.

This option also allows direct connectivity with an Excel file that is on a Windows network even if MII is running on a Non-Windows OS.

Regards, Steve

[Former Member]

Hi Manjiri,

Steve is absolutely correct here. You can bypass creating a custom action block and use PCo as mentioned by Steve.

Regards,

Rohit Negi.

[Former Member]

Hi Steve,

I tried this. But we have following requirements:

1. We have multiple excel files to parse. With PCo I have to give fixed file path which can process one file. Can I send dynamic paths from MII ?

2. We want latest 5 modified excel files from folder which is not possible with PCo.

[Former Member]

Hi Manjiri,

Recently I done the same. reading excel file and process it in MII in two steps.

1. write a macro which will convert excel data to XML and place it a shared drive on MII server. (Manual step)

2. write MII transaction to pick the above XML file and process it (you can schedule transaction)

see if this could helpful for you.

Thanks, Eswar