Update status of each Transaction from Queue to Excel Colum

Help Studio
, , , ,
1

Hi Guys,

How to write remarks once i processed the records in Excel file?

Example:
I processed the records from the queue.
After that i want to capture the Remarks in excel file.

LIKE : sucess , Failed or invalid

Regards
Viswa

2

Hi!

Have a view on this thread

Regards,
NaNi

3

File is not available Thiru.

Regards
Viswa

4

Hi! @ViswanathanAM,

What do you mean by file? have you gone through the entire process which they’ve already given in the thread? which already provided above?

Regards,
NaNi

5

@ViswanathanAM

If you have Unique reference maintained, then you can use lookup activity and pass that unique reference and create a variable for row Index

Now once you have the row index of the record then you can use write cell activity to write to that activity

Hope this will help you

Thanks

6

I am looking for XML file @THIRU_NANI

7

i Get your logic @Srini84 but if you provide POC of XML file . will validate and implement on my project.

Thank you for understanding !!

Regards
Viswa

8

Are you doing this with REFramework?

Regards,
NaNi

9

Yes Thiru - Pls Help

10

Hi! @ViswanathanAM,

Please read carefully…

How u can do this is

In set transaction status workflow, there are three sequences : success, business exception, system exception.

In each of section after setting the transaction status of queue item add a write cell activitiy with properties

Let’s take the case of success case, we are adding the below write cell activitiy in success sequence
Workbook path : excel file path

Sheet Name : sheet name

Cell : “E”+(io_TransactionNumber+1).ToString

(If the transactionnumber is 1)

Data to be written : “Success”

While in system/business exception section

Before writing data into cell , use lookup datatable activitiy to lookup for data from the queue to datatable and getting output as rowindex , use that rowindex to fill the cell

So that I handle it

For ur clarity I will explain with example

Let’s say a queue item has following data

Queue 1

Name : xyz1

Email : xyz1@gmail.com

Mobile : 123456790

Etc…

In init state try to read the excel file and store in dt1 varaible and should be in main.xaml so that it can be accessed by other workflows too

Now after updating status as success or failed use the following to update queue status in excel

First use lookup datatable activitiy with following property configurations

Datatable : dt1

Lookup value : transactionitem.specificContent(“Name”).ToString ( this u can customize accordingly to ur requirements)

Lookup Column Name : “Name”

rowindex : index , index is a variable which stores the row index of that particular row where lookup value is …

after this use write cell activitiy with following property configurations.

Workbook path : excel file path

Sheet Name : sheet name

Cell : “E”+(index+2).ToString

Data to be written : “Success”

Or

if it is failed transactionitem, then u had to make changes in write cell as follows.

Workbook path : excel file path

Sheet Name : sheet name

Cell : “F”+(index+2).ToString

(Failure details are written in the Remarks column)

Data to be written : reason u need to add for

So the main logic I am telling is before updating status in excel we are checking what is position of the row which contains information about queue item using lookup datatable activitiy.

refer the post below.

Regards,
NaNi