Hello Everyone,
I’m doing mainframe automation by using terminal connection. The process of automation is download excel file from SharePoint and check required values in the mainframe and update the status in excel file.
Minimum of 800 and maximum of 2500 record available in the excel file, Kindly assist me which approach will be best for this type of automation. ReFramework with queue or without queue concept. Kindly share your ideas and it will be very helpful for me.
Hi @shyamala_shyamu ,
If you want to use multiple bots to run at the same time , go for ReFramework with queue if single bot is enough and efficient then without queue.
Thank you so much for your quick response. As of now we are in the plan to implement in single bot but in future, we will plan into implement in multiple bots.
How can we update the status in excel file if we are using queue concept.
Hi @shyamala_shyamu ,
In reframework, the one uses the queue.
You will be a using a module called set transaction status.xaml, There by using excel activities and unique column as key , you can update the status column.
You can update excel file either after or before setting the status to queue item.
Hope this helps you.
Thanks,
Gautham.
Thanks for your reply. In my input file it has default 44 column values and I need only 5 mandatory column values for processing it in mainframe and once I finish the process, need to update mainframe comments in the required column field.
Please assist me shall I add only mandatory column values to the queue or I need to add all 44 column values, Initially the comments column has empty we need to update the comments once we finish process in mainframe. After updating the comments we can set the status in queue.
Hi @shyamala_shyamu ,
You need to add only the required data into queue.
Else it will be messy to handle.
Thanks,
Gautham.
Thank you so much for your valuable inputs. I will implement this method in my process.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.