Read multiple emails save attachments and process an application at once

Help Forum
, , , , , , ,
1

scenario: read multiple emails with valid sender, subject line and attachment->if everything is okay then download the attachments and store it in input folder->then read each excel and strore data in a datatable->once each excel processed and data table is ready then open a XYZ application and copy all the data from datatable and paste it in XYZ application and run the load program->then load program if success close the application send final report to the client, explain which framework do i need to use and and if re framework we are using then it is simple or queue base, because we are opening XYZ application only once explain it in details

2

@Mohammad_Imran,

U would suggest to use dispatcher performer approach here.

In dispatcher robot customise the reframework to iterate all the valid emails and download attachment. After downloading the attachment add the download path to queue.

In performer use your logic to process all the attachment as queue items.

3

Can you explain more please its implementation really needed

4

@Mohammad_Imran

  1. You can use REF
  2. Single ref should be enough
  3. Change the transaction type to mailmessage..so that you can directly iterate over emails
  4. In process state check your attachments and read the data create the datatable
  5. In the end process have the logic to open the application and wrote whole data at once
  6. Then next activity would be to send the report back

As in application there is no separate data input for each email this should suffice

Cheers

5

You mean single Reframework can also handle, could you please explain more so that i can start the process

6

@Mohammad_Imran

yes you can

I explained already

if you start with that and if stuck we can help

cheers

7

@Mohammad_Imran,

Could you specify in which part you have dought?

8

Hi @ashokkarale,

I have started development of this bot using single reframework and completed the bot but while running the bot, when bot is compiling getting below errors and bot is not running even i have already converted and there is no any queueitem variable type:
please see below and provide appropriate solution for this.

image
image535×137 27.7 KB

9

@Mohammad_Imran,

You will have to change the datatype of QueueItem variable. Refer this solution.

1 Like
10

I have already change there is no any queue item variable

11

@Mohammad_Imran,

Sorry my bad! There error is occurring because of datatype of TransactionItem or out_TransactionItem variable/arguments. Check them and you should be good.

12

Please see the screeshot there is no any error in any state

image
image507×568 22.3 KB

and while running the bot getting popup

image
image1118×236 70.8 KB

13

Hi @Anil_G /@ashokkarale
This is very urgent requirement please help me i have to submit this bot by day after tomorrow, i am really struggling .

14

Hi @Mohammad_Imran

You need to change the argument type in the following workflows:

  • GetTransactionData.xaml
  • Process.xaml
  • SetTransactionStatus.xaml
  • Main.xaml
15

@Mohammad_Imran

Use ctrl+f search for variable name change every where

After that you have to click on import arguments for each xaml where it is invoked and then it would reflect

Cheers

16

@Mohammad_Imran

It will be there, go through all the xamls