Hi, this is my first time using reframe work and need some guides for the automation i am about to create.
i have done this with an iterative way and need to make the same process with reframework
the automation simply is as following:
the end-users will send email with excel file as attached.
i need to download this attached files to a folder and upload the data to the queue.
then open the Oracle Application and get the data line by line send email for the completion of the process.
also, i have some concerns in the GL module at the Oracle application if one line has invalid data the application will throw, and error and you need to close the java and start from the beginning. but the queue will still have data from the old file and cannot use it for the new entry. so is the dispatcher the using of the orchestrator queue is the right way or there is another approach for such cases.
also, the after the login i should select the responsibility base on the excel file. so, the bot processed the fill correctly it will go to the transaction stage to get the next file and still couldn’t open the new responsibly for the new file which is in the Initialization stage.
so, I a, very confused of what i should do.
first check the project requirement
Download Excel attachments from incoming emails.
Upload data from Excel to Orchestrator queues.
Process data line by line in Oracle, handle errors, and ensure proper session handling.
Initialization
Read Config: Store all configuration settings (e.g., email settings, Oracle credentials) in the Config.xlsx file.
Email Handling: Use the initialization state to download email attachments and save them to a specified folder.
Use activities like Get IMAP Mail Messages or Get Outlook Mail Messages.
Use Save Attachments activity to store the files.
Data Upload to Queue: Read the Excel files and upload the data to an Orchestrator queue.
Use Excel Application Scope and Read Range to read the Excel data.
Use Add Queue Item to upload data to the queue.
Use Get Transaction Item to retrieve items from the queue.
Ensure each queue item contains all necessary information (e.g., responsibility, data rows).
I seriously recommend not bothering with REFramework. It’s bloated, disorganized, old, and overcomplicated for an automation like this.
A simple dispatcher performer model, with a performer that reads config, opens applications, gets transaction, processes transaction, then repeats back at get transaction (in a flowchart) is a much better design.
Hi! Welcome to the forum and the world of automation.
First, when converting a linear process to a reframework process, you need to plan the steps of your process into three categories:
Inicialization: after the initialization and configs files, here you execute all the pre-processing of your flow. in your case, i would put the e-mail processing here. then, send all the relevant info to the queue item do be gathered in the loop.
Process → here you can process the transaction item as much as you want. by your description, the oracle application can easily be processed here. when an item cannot be completely done, you can just set the reframework to repeat the process as much as you like. since the transaction item is a unique item, you wont have the problem of not getting the next item to be processed.
End Process → here all the post processing should be made.
i hope this brief explanation helps. let me know if you need anything
Thanks, i have got your idea, i will mark this as solved as the implementation will take time.
so, i hope there is no problem if i contacted you again if i need some help.
have a nice day.
