Need to send email after updating excel

Help Activities
, , , , , , , ,
1

I have two Excel in input path .First Excel has two sheet sheet 1 and sheet 2 and second Excel has Sheet 1 sheet 2 and sheet3
In queue it will update as
sheet1
sheet2
Sheet1
Sheet2
Sheet3

For example if queue will take sheet1 of first excel and fetch details mark as successful in queueand move to next item in queue sheet2 of first excel when updating second sheet I got application exception and it moved to sheet 1 and t got successfully and same as sheet2 and 3 of second Excel got successfully so I send email and now the bot run retried queue of sheet2 of first excel and I got application exception and failed how to I send Excel since only one sheet got updated in excel1 and sheet2 in first Excel got application exception but I can send partial mail how to do that.how do I check all sheet in excel updated successfully and if some excel sheet is not updated due to application exception even after retry how can I check that and send the excel

2

@sruthesanju,

Just maintain a tracker somewhere central location may be on SharePoint or Shared drive where bot’s will have the access.

Update that tracker after every transaction with status like which sheet completed successfully which one wasn’t.

At the End State check the tracker and accordingly send the email.

2 Likes
3

if you are using RE-Framework, there are in built-in catch blocks, separate for Business Exception and system exception, you can put a mail module when it lands up in any of the catch blocks.
if you want to send an email after every transaction, no matter the result, put this mail module in Finally block of process.xaml.
also, keep a track of the transaction statuses in a datatable(this should be ideally done in the SetTransactionStatus.xaml) and write it to a different Excel. So finally you can get a consolidated report of which are successful/retried/failed etc.

Regards
SG.

4

@sruthesanju

You can use get queue items and check the status of them and find out if they are successful or failed and accordingly can send the mail

Cheers