Pick data in small batches

[Former Member]

Hi,

We have a requirement where we need to pick up only a few files (say 100) from a folder with many more files parked in it.

We intend to run a .bat file, which resides in the FTP server itself. The .bat file is supposed to rename the files to a particular name which will be picked up by a Sender File Channel.

We tried using the "Run Operating System Command before Message Processing" but of no avail.

We are using:

Transport Protocol : FTP

Mesage Protocol : File

From SDN, we came to know that we cannot run a batch program using the above option. Please confirm.

Also, please help us with some alternative design, if reqd.

(We are using PI 7.1)

Thanks!!

[aashish_sinha · Accepted solution]

Hi,

use command as below ;

c://usr//sap//tmp//mybatch.bat

regards

Aashish Sinha

[Former Member · Accepted solution]

Hi Ashish,

Where should be the batch file present -- on the FTP server or XI Server?

If its FTP server, should it be fully qualified path (like you specified in the post) or the relative path (from the FTP root)?

[deepak_shah · Accepted solution]

Hi Vikram,

The batch file should be on XI server.

please check below link for more info on this

http://wiki.sdn.sap.com/wiki/display/XI/SAP%2bXI%2bFile%2bAdapter%2bOS%2bCommand%2bLine%2bFeature

Regards,

Deepak.

[Former Member]

Hi Vikram,

You can try Message Packaging instead of Running OS command.

Have a look at this blog:

/people/william.li/blog/2008/03/07/step-by-step-guide-in-processing-high-volume-messages-using-pi-71s-message-packaging

Regards,

Aravind

[Former Member]

Hi,

Use a remote script to your ftp server.

Regards,

Carme.

[Former Member]

>

> Hi,
> 
> We have a requirement where we need to pick up only a few files (say 100) from a folder with many more files parked in it.
> 
> We intend to run a .bat file, which resides in the FTP server itself. The .bat file is supposed to rename the files to a particular name which will be picked up by a Sender File Channel.
> 
> We tried using the "Run Operating System Command before Message Processing" but of no avail.
> 
> We are using:
> Transport Protocol : FTP
> Mesage Protocol : File 
> 
> From SDN, we came to know that we cannot run a batch program using the above option. Please confirm.
> 
> Also, please help us with some alternative design, if reqd.
> 
> (We are using PI 7.1)
> 
> Thanks!!

You can use a Unix shell to do this.