I am working on a project where the BOT has to perform below tasks :
1.Read 100+ PDF’s
2.Read the input excel sheet and store into Data table
2.Extract the values from PDF using Regex
3.Write the intital value in excel sheet
4.Write the Filtered values into DT and write into excel sheet
5.Add captured values to Queue
I would like to design this process as DISPATCHER in ReFramework
Can you please suggest in which state i need to place above activities in refrmework?
Do i have to remove “Get transaction” state from template?
If you have template for dispatcher. Please share with me
Note : I will create another project (Performer) to process the queue items
To take it very simple if you are handling the performer in another REFramework as a new project then it means you have the chance to create dispatcher as a separate REFramework project
And in that project don’t remove any state like get transaction state
Do same as how you will get each row from a datatable from Get transaction state and process that in PROCESS State
In process state itself you can upload the transactions to queue if needed or to a database like excel file which is the actual expectation from a dispatcher process
There is no Get transaction involved in Dispatcher ,Are you including this in a for each loop, if so Yes that will work , please surround the code with Try catch block.
Please surround your “Read PDF and Pages” sequence with a Try catch Block and in catch block you can just keep a Log message activity,
to skip the corrupted files and continue the loop.
