Hi All,
I am trying to read excel and upload queue item data. Without creating separate performer and dispatcher bot , I am trying to read the input file in Init All Applications using read range workbook and adding queue items. Is this approach correct?
If I dont want to use separate performer and dispatcher bots and want to upload queue data from excel file how should the design be ?
Also in queue ,
I am getting only “Subsidiary_Name” value , I want ReportName should also come.
Hi @dutta.marina,
You should consider making another workflow(e.g. Add items to the queue) in your Initialization state. Adding in initallapplications workflow would mean that your process will keep adding items to the queue on every system exception that occurs.
Reason - in Ref-framework, on every system exception, control goes back to initallapplications workflow to reset the opened applications…
Hence you should make this another workflow and include it under the section (if config is nothing) → this section is already there in re-framework where initallsettings workflow etc are included.
For your queue items, please refer/open the items which have report name available like your first 4 rows because all other rows doesn’t have any value in the report name, hence you are not able to see anything there.
Hope this helps.
Regards
Sonali
Hello @dutta.marina , like the other commenter mentioned, you would want to have your excel reading activities and your adding to queue activities in a separate sequence or workflow in the Initialization portion of the re-framework project. Please note though every time you start the ‘Performer’ it will read that same excel over again.
I know you mentioned not wanting to seperate bots, but best practice would be to create 2, and have the performer get triggered based on if items are added to the queue by the dispatcher.
You can keep it in the if config is nothing sequence to prevent it from being repeated after system exceptions (the very first steps of the init state) - if I build stuff out like this (dispatcher in if config is nothing seq of the initial state) i’ll usually throw a boolean argument in the main workflow e.g. ‘Run Dispatcher’ so I can run 1 job with a time trigger with the value set to ‘True’ and additional jobs with a transaction trigger with it set to false
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.