File Watcher and Extractor

Tasks

• Loop through monitoring folder for a new file
• Get the new files filename and file creation datetime and comapre with the queue file
• If the file is not logged in queue file, generate the GUID and update the queue file

Many times, we require automation of a process whose input is the new file in a folder. This job can be done in the processing bot, but this will lead to the complexity of the process. We all need a solution for this scenario where we get the input in queue form, which can be either Excel or DB. And the solution is a File Watcher, which checks the folder on a continuous basis and provides you the queue of file locations.

This Automation Anywhere bot monitors a specific folder for new files in that folder. The files which are created in the last x (any number) minutes will be picked up by the bot. The extracted files from the folder will be logged in an Excel queue. The queue contains the location of the file, created time, and unique ID for each file.

This bot is very useful in monitoring the activities in a folder and picked-up files can be used as the input for another process. The bot can be scheduled to run 24x7 every x minutes to not lose any files.