File-PI_File Interface with additional feature

[Former Member]

Dear All,

We have already implemented successfully File-PI-File scenario in which files are picked from a certain folder and is converted into a different format and is sent to another folder. Now I want to add another feature to the scenario that a mail should trigger every 24 hrs or 12 hrs which should inform regarding how many files has been processed during that period along with the file names.

Is there any standard functionality available to achieve this??

Regards,

NJ

[prateek · Accepted solution]

Is there any standard functionality available to achieve this??

No

You may design it this way. Save the name of the files to some table, say on PI. Then towards end of 12 or 24 hour, trigger the interface (using Planning availability Times) and send this file in mait to required recepient. This would ensure that no process is active for 12 hours just for saving the filenames.

Regards,

Prateek

[Shabarish_Nair]

>

> Dear All,
> 
> We have already implemented successfully File-PI-File scenario in which files are picked from a certain folder and is converted into a different format and is sent to another folder. Now I want to add another feature to the scenario that a mail should trigger every 24 hrs or 12 hrs  which should inform regarding how many files has been processed during that period along with the file names.
> 
> Is there any standard functionality available to achieve this??
> 
> Regards,
> NJ

a workaround would be to store the filenames into a ABAP table via RFC call or a DB table via JDBC. then have a scenario configured where this data will be fetched (schedule your adapter for once a day) and accordingly a mail can be triggered.

[former_member200962]

Just one more approach:

When you send the file to the receiver create an additional file (in append mode) which will have the details for each of the processed file....

So that the interface now reflects

File ---> PI -----> File1
               |------> File2

Now create another interface to pick the File2 every 12/ 24 hrs (using ATP) and then in the receiver have the email CC.

Regards,

Abhishek.