Glimpse at OS Command: Yet Another Scenario

[santhosh_kumarv]

Adding to the following Blogs this would cater another use case of the OS command.

The specified item was not found.

Executing Unix shell script using Operating System Command in XI

The specified item was not found.

Until the time I answered this Need a clarification in File to File scenario... in the forum truly I only had a theoretical view of the OS command rather practicing it. A week later a mail from my colleague knocked my mailbox addressing a requirement to delete file and also to send mails using the Unix script.  This aspired me to try out the OS Command scenario and the outcome of it is this Blog.

 

The requirement in curtail edition is to delete the inbound file only after the outbound files is posted successfully. The requirment is very genuine and wonder why this cant be made as an inbuilt functionality.

The approach to this is as follows.

 

1. Archieve the inbound file.


2. Use the same file name both in case of sender and receiver.


3. Execute the Unix Script to delete the archived files only after the successful execution.

 

Configuration Steps:

1. In the Sender file adapter set the Processing Mode as Archieve and specify the path. Also enable the Adapter-Specific Message Attributes.

2. In the Receiver file adapter give the exact path of the Unix script in the option Run Operating System Command After Message Processing. Pass the filename as a command line argument to the script using the parameter %f.

3. Use this Script to delete the Files from the Archive Directory.

#!/bin/ksh  #Author: Santhosh Kumar  #Change to the Archive Directory cd /local/data/temp/interface/dx7/processed/inbound  #Change the File Permission Mode chmod +x $1  #Remove the File rm $1

You can even make an mail notification by adding the following Shell Script.

<span># Write Your Subject Here. SUB="File $1 Have been Processed Sucessfully"  # To Address TO="</span><a class="jive-link-email-small" href="mailto:santhosh.vellingiri@wipro.com">santhosh.vellingiri@wipro.com</a><span>"  # Mail Content # create a temporary file. CONTENT="/tmp/emailmessage.txt"  # Append the Mail content to the File echo "The File $1 is Proceessed and the archive files is also deleted"> $CONTENT  # send an email using /bin/mail /bin/mail -s "$SUB" "$TO"<$CONTENT </span>

Output Mail:



This mail brought Grin in my face.