Search: insert-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Last author
- 93Nga Nguyen
- 70Tuan Nguyen
- 63VuNH54
- 59Nhan Nguyen
- 46Giang Tran
- … 3 more
Creator
- 223admin
- 67Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 7DatPT
- … 3 more
Last modification date
Creation date
Object type
Uploaded by
- 140Nga Nguyen
- 92Nhan Nguyen
- 71Giang Tran
- 54Tuan Nguyen
- 21admin
- … 2 more
Upload date
Append CSV File
Located in
- Rendered document content
of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable
- Raw document content
of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append
…\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV
…)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security
Navigate To (NB)
Located in
- Rendered document content
to be inserted (String)* - The URL that you want to navigate to in the browser. The URL must be quoted
…to consider data security requirement before using it. Default is uncheck.
- Raw document content
** == * **URL to be inserted (String)*** - The URL that you want to navigate to in the browser. The URL must
…to consider data security requirement before using it. Default is uncheck. ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc
Navigate To
Located in
- Rendered document content
RCA.Activities.Common.NavigateTo Description The Navigate To activity allows you to navigate to another URL on the current browser. (*For mandatory) In the body of activity URL to be inserted
…and structure your code better. Public (Checkbox) - Check if you want to public it. Remember to consider data
- Raw document content
** == * **URL to be inserted (String)*** - The URL that you want to navigate to in the browser. The URL must
…data security requirement before using it. Default is uncheck. ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4
For Each Row
Located in
- Rendered document content
loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from the DataRow. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security
- Location
Data Table
- Raw document content
) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before
Bulk Add Queue Items
Located in
- Rendered document content
to add a collection of items to a data table to a specific queue. Once it is added to the queue
…) - The data table that you want to add the queue into. QueueName (String) - The queue to which the new queue
…Output Result (DataTable) - This is the data table that you have added to the queue.
- Raw document content
of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed
…. The default value is: AllOrNothing * **Queue Items DataTable (DataTable)** - The data table that you want
…**Output** * **Result (DataTable) **- This is the data table that you have added to the queue
Write CSV File
Located in
- Rendered document content
the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable
…\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log
- Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
Open Browser
Located in
- Rendered document content
) In the body of activity URL to be inserted (String)* - The URL that you want to open in the browser. The URL
…to public it. Remember to consider data security requirement before using it. Default is uncheck. Options
…will be passed to the browser directly when startups User Data Folder Mode (UserDataFolderMode
- Raw document content
]] (*For mandatory) == **In the body of activity** == * **URL to be inserted (String)*** - The URL that you want
…to consider data security requirement before using it. Default is uncheck. **Options** * **Hidden (Checkbox
…will be passed to the browser directly when startups * **User Data Folder Mode (UserDataFolderMode
Read Range
Located in
- Rendered document content
(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
…” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
…)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole
- Raw document content
range in a data table variable. Only data table variables are supported ))) {{velocity
…: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g
…want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole
Write Range
Located in
- Rendered document content
. Only string variables and strings are supported. Data Table - The data that you want to write
…to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
…RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. * **Data Table** - The data that you want to write to the specified range
…which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
…" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable
Append Range
Located in
- Rendered document content
are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable
…in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you
- Raw document content
". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data
…and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added
…to public it. Remember to consider data security requirement before using it. * **Display Name (String