How to send data from "Get Transaction Data" to "Process Transaction" in RE-Framework?

Help Studio
, ,
1

Hi Community,

Use Case : 1. Read unread mails of Specific pattern subjects and save in excel.
2. Read the excel and fill the details in application.

So for No.1 , I’ve written the code inside “Get Transaction Data”

image
image580×541 18.9 KB

image

image
image446×521 16 KB

It is saving data in excel as shown below: It is containing empty strings as highlighted.

image

And for No.2 , I have write the logic inside “Process”.

Problem : When I execute, it is just initializing , reading mail subject, extracting into excel file and then closing the application. But not performing the next task. ie. writing the excel data into application.

Solution I tried:
Created a Sample Excel having few rows of data.
Building same logic (excluding reading mails)
And it’s executing perfectly as per requirement.

Please help me what went wrong and correct me.

Thanks in Advance :slight_smile:

2

@Vaishnav_Tej

Please follow the below steps…that way it is easy and we can find the issue

  1. Create a separate worfklow for Reading emails and Writing data to Excel and have a out Argument which will send the datatable as an out argument
  2. Invoke the above xaml in the first run if condition and this will make sure the read emails runs only once and then Assign the Argument with datatable to io_TransactionData
  3. Now in Get Transaction data use a if condition in_Transactionumber <=io_TransactioNData.RowCount
  4. In the then side assign io_TransactionData.Rows(in_TransactioNumber-1) and on else give NOthing

cheers

3

okay. So the issue is not with the excel sheet having extra string inside cells?

4

@Vaishnav_Tej

No It can have any data…The bot would ideally read…

cheers

1 Like
5

Because I have tried using only that excel commenting the above part(Reading mails and write Range workbook). Still it isn’t working.

6

Better way to do these type of scenario will be to use performer and dispatcher.

7

Sorry I’m not aware about performer or dispatcher. Could you please elaborate or may be send any links.

8

Hello ,

I have tried as you said. Created a separate workflow and invoked inside first if condition of Get transaction data. But it has thrown error for GET IMAP.(Object reference not set to an instance of object).
I have created 2 arguments:
image

Default in_Config argument is like this:
image

image

Where it is going wrong?

9

@Vaishnav_Tej

First thing you have to invoke it in the first run if condition inside the initialize workflow

And it shpuld be placed after the initsettings workflow invocation

Cheers

11

Hi,

I’m still facing same old issue.
Problem : When I execute, it is just initializing , reading mail subject, extracting into excel file and then closing the application. But not performing the next task. ie. writing the excel data into application.
image

12

@Vaishnav_Tej

Can you include logs for reading to check if it really read the data and also can you share the project or some screenshots…and check in debug…if the io transactiondata has data when entering into transaction xaml and if it is properly assigning the value.use step into activities

Cheers

13

Agrifirm_Using_RE-Framework.zip (1.4 MB)

14

@Vaishnav_Tej

Please check this…I changed the out Argument variable to dt_TransactionData in the invoke in Init settings and also remove the if condition for transactionnumber 1

Agrifirm_Using_RE-Framework.zip (963.1 KB)

As of now I left the transactiondata as in/out in GetTransactiondata.xaml …you can change it to only in as well

cheers

15

Hi,

Still facing same issue :frowning:

16

@Vaishnav_Tej

So this is the issue…TransactionItem is not assigned in GetTransactioNData

image
image1599×476 27.3 KB

Please assign as shown

cheers

1 Like
17

Finally , Thank you so much. Issue resolved.

Only error I’m facing now is with “Send SMTP Mail Message”
Error : No such host is known.

image

18

@Vaishnav_Tej

I guess the smtp details procided are wrong please check the same…

Cheers

19

Thank you so much for your immediate responses. :smiley:

1 Like
20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.