c53654ee-bc6c-4d72-8c00-3d6cd982072c.png

12b9b07d-8cd1-4b4f-aef8-445d27b655d6.jpg

RPA Developer

4e33d029-96ba-4d85-a556-7eab8946af32.zip

0b9f11b7-f6c4-442f-b437-e58344ed0202.jpeg

4. No overhead in processor bot for queue creation.

5. A unique GUID for each file path in Excel queue which acts are the unique reference for the file.

Many times, we require to automate a process that has as input 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 a queue form which can be either Excel, DB or Orchestrator queue. And the solution is a File Watcher, it checks the folder on continuous basis and provide syou the queue of file locations.

This UiPath BOT monitors a specific folder for new files in that folder. The files which are created in 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, 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 file.

File watcher creates the Excel queue for all incoming file paths in a folder. The queue of file paths can be used by any UiPath robot to perform any kind of operation on those files.

c5e805ba-3f78-4e5a-aec2-32801a0d5d0c.jpg

0d21c3ec-79be-4869-9a60-2fdb65a999b3.jpeg

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Visual Basic

1. File watcher is build on UiPath version 2021.4 and can work on lower versions as well.

2. File watcher version 1.0 includes creating the entries of file paths in a specific folder in a fixed Excel queue.

3. The Bot checks the created datetime of the last file in the queue and picks up all the new files that are created after that time.

File and Folder Organizer

Read Sheets from .xls/.xlsx file