How to create the summary report?

[naveen.s]

Hi All,

I need to generate a summary report after completion of the all transaction.
for example if there are 20 queue items , after completion of all the transaction, bot needs to generate the summary report like:
Date Start time(of each transaction) End time(of each transaction) Result (Successful/ system exception/Business exception).
the status should be depends on the result of the each transaction whether its successful or system exception or business exception.

Can anyone help me on this??

[rlgandu (Rajyalakshmi Gandu)]

@naveen.s

In the orchestrator Logs you find the the details,If you want you can download the reports using Export,It will download the file in .csv format.The log contains all details about start time,End time,Exceptions and so on

[ashokkarale]

@naveen.s,

Follow this approach.

1. Build a datatable to store all the transaction items data in Init First time run. Here I have repurposed the the predefined dt_TransactionData variable available in ReFramework Template.
   
   

2. Now Datatable to store transaction details is ready, lets add logic to add transaction details. We will be using 3 Add Data Row activity to add the transaction data.
   A. Success:
   Process Transaction State here

    Add Row

B. Business Exception:
Process Transaction State here

  Add Row

C. System Exception:
Process Transaction State here

  Add Row

3. Now for every transaction we will get the data in dt_TransactionData. Now lets write it to Excel file suppose. Use Write Range workbook activity in End Process state.

That’s it.

Here is sample Template.

REFrameworkDemo.zip (954.6 KB)

Thanks,
Ashok

[naveen.s]

@ashokkarale ,

I am already using the datatable output dt_TransactionData(after reading the input).

Where exactly I need to place the add data row for success,SE, BE can you please send the screenshot as in my company I cant download the zip file or any xmal

[ashokkarale]

@naveen.s,

It’s right after Set transaction status Try catch in Process Transaction state.

1. After invoke Process.xaml
2. In Business Exception catch
3. In System Exception catch

Highlighted in my answer.

Thanks,
Ashok

[naveen.s]

If I want to mention the exception reason, how can we achieve that:

For example: if the mobile number is less than 10 digits bot should the BE with the reason Phone number is not valid because it doesn’t contains 10 digits.

for system exception : if any selectors issue comes

[ashokkarale]

@naveen.s,

In Business & System exception you have message property which will hold the reason or message of the exception. You can use this.

Thnaks,
Ashok

[Sagar1 (Sagar Das)]

Hi @naveen.s ,

There could be one way like the below I am sharing the screenshot.

Within the “create summary report” sequence of SetTransactionStatus.xaml file you can have your require action to update the output report file.

If you are using QueueItem start time you can get it by below expression :

in_TransactionItem.StartTransactionTime.Value.ToString("yourDateExpression")

and end Time will be your current time like below:

Now.ToString("yourDateExpression")

Set your value of transactionStatus variable as Success/SE/BE - in the predefined Success/Business exception/System exception sequence.

Post here for any query.

Cheers