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
Location
- 92Activities
- 8akaBot Vision
Last author
- 58Nhan Nguyen
- 31VuNH54
- 8admin
- 2DatPT
- 1Giang Tran
Creator
- 90admin
- 9Nhan Nguyen
- 1Giang Tran
Last modification date
Creation date
Object type
Upload date
[4] Capture Custom Table Data
Located in
- Rendered document content
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
…A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
- Title
[4] Capture Custom Table Data
- Location
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
- Raw document content
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
…="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table
[3] Review Document
Located in
- Rendered document content
, akaBot Vision provides users with the capability to add or remove rows in a table To insert a row, you can click "+" icon To delete a row, you can click "x" icon To add a new row at the end of the table
…After importing the document successfully and the data extraction process is successfully finished
- Raw document content
or remove rows in a table * To insert a row, you can click "+" icon * To delete a row, you can click "x
…="wikigeneratedid" %) After importing the document successfully and the data extraction process is successfully
…with this status in the “To review” tab in the user interface. [[image:image-20220420193327-1.png||data-xwiki
Execute Non Query
Located in
- Rendered document content
statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows
…) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit
…if you want to publicize it. Remember to consider data security requirements before using it. Display
- Raw document content
. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command
…]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities
Open Browser
Located in
- Rendered document content
it. (* for Mandatory) In the body of activity URL (String) - Insert a specified URL in the container. Ex: “https
…(Browser)* - Insert the specified browser in which activities could be active. URL (String)* - Provide
…want to publicize it. Remember to consider data security requirements before using it. Display Name
- Raw document content
-20220506110901-1.png]] (* for Mandatory) **In the body of activity** * **URL (String)** - Insert
…Browser (Browser)*** - Insert the specified browser in which activities could be active. * **URL (String
…to consider data security requirements before using it. * **Display Name (String)** - The name
Remove Duplicated Rows
Located in
- Rendered document content
duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember
…Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.
- Location
Data Table
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table
…** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public
…** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity
Get Table
Located in
- Rendered document content
of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you
…using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored
…RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from
- Title
Get Table
- Location
Get Table
- Raw document content
the data table * **Public (Checkbox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. **Output** * **Data Table (DataTable
…== **Description** == This activity allows you to retrieve a table from a Word Document and return
Word Application Scope
Located in
- Rendered document content
does not exist, a new document file is created. Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String
…. E.g: Working with Word. Option Password (String) - Insert Word file password to proceed. String
- Raw document content
** * **Public (Checkbox) ** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. * **Display Name (String)** - The name of this activity. You can
…. **Option** * **Password (String) **- Insert Word file password to proceed. String variables and Strings
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
Add Data Column
Located in
- Rendered document content
want to add to the specified DataTable Object. String supported only. Data Table (DataTable
…Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements
…to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type
- Title
Add Data Column
- Attachment name
add data column.jpg
- Location
Data Table
…Add Data Column
- Raw document content
to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object
…DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before