How to use reframework for datatable workflow

Help Studio
, ,
1

Hi,

I want to use the reframework for datatable project. How to reuse the reframework for datatable.

Let me know please provide the template

Regards
Sai

2

Hi Sai.

ReFramework is a pre-built solution template in UiPath Studio that can be used as a starting point for building your automation projects. To reuse the ReFramework for a data-table project, you can follow these steps:

  1. Create a new project in UiPath Studio and select the “Process” option.
  2. Select the “ReFramework” template from the list of available templates.
  3. Create a new workflow called “Main” and drag and drop the “GetTransactionData” activity from the “Data” tab in the activities panel to the “Main” workflow.
  4. Customize the “GetTransactionData” activity to read the data from your data table.
  5. In the “Main” workflow, drag and drop the “For Each” activity from the “Flow” tab in the activities panel.
  6. Configure the “For Each” activity to loop through each row in the data table.
  7. Within the “For Each” loop, add your custom automation logic to process each row of data.
  8. Finally, run the project and observe the results.

Note: The above steps are a basic outline and may need to be adapted based on the specific requirements of your project.

Here’s an example of a ReFramework template in UiPath Studio for a data-table project:

`Imports System
Imports System.Data
Imports UiPath.Core.Activities.Data
Imports UiPath.Core.Activities

Public Class Main
    Inherits Sequence

Private ReadOnly _getTransactionData As New GetDataTable

Protected Overrides Function Execute(ByVal context As CodeActivityContext) As Object
    _getTransactionData.DataTable = GetData()
    
    For Each row As DataRow In _getTransactionData.DataTable.Rows
        ' Add your custom logic to process each row of data
    Next

    Return Nothing
End Function

Private Function GetData() As DataTable
    ' Your code to retrieve data from the data source and return it as a DataTable
    Return Nothing
End Function

End Class
`

image
image653×686 18.5 KB

This template includes the ReFramework’s “GetDataTable” activity to retrieve data from a data source, and a “For Each” loop to process each row of data in the data table. You’ll need to customize the GetData function to read your data from the data source and return it as a DataTable. You’ll also need to add your custom logic within the For Each loop to process each row of data.

Regards

Milos Panic

3

Hi,

Can u come up with xaml file

4

Hi Sai.

This can help.

<Sequence DisplayName="Main" xmlns="http://schemas.uipath.com/workflow/activities">
  <Sequence.Variables>
    <Variable x:TypeArguments="data:DataTable" Name="dtTransactionData" />
  </Sequence.Variables>

  <GetDataTable DisplayName="Get Transaction Data"
                DataTable="[dtTransactionData]" />

  <ForEach DisplayName="For Each Transaction"
           x:TypeArguments="data:DataRow"
           Items="[dtTransactionData.Rows]">
    <!-- Add your custom logic to process each row of data -->
  </ForEach>

</Sequence>

image

This template includes the ReFramework’s GetDataTable activity to retrieve data from a data source, and a For Each loop to process each row of data in the data table. You’ll need to customize the GetDataTable activity to read your data from the data source and return it as a DataTable. You’ll also need to add your custom logic within the For Each loop to process each row of data.

5

@Sai.Srinivas

PFA the template

So basically we use io_Transactiondata for storing the datatble and then change transactionitem to Datarow…And remove any queue related details from the set transaction xaml.And Get transactiondata is modified to send out datarow instead of Queueitem

NotUsingQueue.zip (946.1 KB)

Hope this helps

Cheers

6

@Sai.Srinivas , did you checked this? ReFramework for Tabular Data - RPA Component | UiPath Marketplace and this Robotic Enterprise Framework (the template in studio provides doc and eg)
Regards,
Balram

7

Sir,if i have to run the whole framework with a data table as a source,what kind of customization i have to do and where?

8

you can watch this

9

You can use the below template for re framework using excel
ExcelREFramework.1.0.2.nupkg (967.7 KB)
ExcelREFramework.zip (956.0 KB)