How to design a process


New Member
I have couple of excel files in shared folder, in each excel file there are couple of cases and I have to process case by case.How I have to design the process, should I have to use queue's or any other best practices any suggestions are welcome on this.
Work Queues should almost always be used in cases like these as it gives lot of flexibility on the can read all the cases into work queue and process them. if they have priority, you can set them while loading into the queues.


Well-Known Member
Hi LearningRPA,

Emphasizing the word "generally", Work Queues are used when there is large amount of data. Its full purpose can be achieved by distributing the data (or cases) from the Queue to be accessed by multiple bots at the same time and hence complete the task at a faster rate.
You can still use Work Queues by using a single bot. Work Queues have their own features like adding tags to the cases, updating statuses to the queue items, better monitoring and reporting of the cases, setting priorities, deferring cases to be processed at a later stage, etc.
From your post it says that there are only a couple of Excel files and couple of cases in them. So without work queues sounds suitable. But it will be up to you to decide whether to go ahead with queues or not depending on if you want to make use of the above features or not, or perhaps use it for understanding how queues work. Also, BP has the Ms Excel VBO business object which can read the files and easily update their statuses within the files without using queues.


Active Member
I'd start this solution by converting the excel cases into BP queue items and working my way through them that way. I'll risk saying it's always better for tracking, bookkeeping...etc.