I need to create the dispatcher bot with Reframework .
Process steps
Input excel have two sheets. Sheet1 & Sheet2
Sheet 1 data i need to read directly and upload into the queue.
But Sheet 2 data i need to log in the application , then upload the sheet2 datas into there and after upload i need to download the another excel file. Those excel data i need to upload into the queue.
Here I need to upload datas into one single queue in two different way.
Can someone guide me which one is handle in the which state on reframework will be the best approach.
under initialization stage, use read range to read data from sheet 1 and save it to datatable.
use add bulk items to queue activity and load the datatable into queue at once. Step 1 and 2 can form part of a sequence - add sheet 1 data to queue.
use read range activity to read data from sheet 2.
loop through datatable from step 3, load the data one by one into application. Step 3 and 4 can form part of another sequence - load sheet 2 data into application.
once done, read another sheet and load that data into queue in bulk like step 2. This step can be in separate sequence.
All these sequences can form part of initialization stage and once done, move process to end process stage.
Or you can include only sequence 1 under initialization stage, then loop through reframework for sheet 2 data to loop though it and load data into app under process stage. Once done, sequence 3 is included in end process to finally add last set of data into queue.