Call Automation After Parsing Imported Data

Feature Description

Open the data table record import page, where users can import data through three methods: Excel, CSV, and Copy table from Excel or web page. The imported data will be converted into data table records according to the mapping relationship, and the specified automation will be called.

Parameter Settings

Configuration Item	Description
Data Table	Record's data table type
Allow Users to Select the Following Fields for Import	Set the fields that users are allowed to import
Default Mapping Relationship	Set the default mapping relationship between columns and fields
Field Default Values	Default values for fields when imported data is empty
Enable Import Data Validation	When enabled, imported data will be validated row by row
Row Data Does Not Meet Validation	When Enable Import Data Validation is enabled, each row of data can be validated. When the return value is true, it means the validation result is not met
Prompt Content When Validation Fails	Prompt content when row data does not meet validation
Continue Import When Validation Fails	When enabled, import will continue even if validation fails. When disabled, validation failure will prevent the import of subsequent rows of data
Skip Current Row When Validation Fails	When enabled, the current row will be skipped directly and not updated when validation fails. When disabled, updates will be made even if validation fails
Automation	Automation to call after import is completed
Input Parameters	Input parameters for automation

Example

In the data table module, we need an import button. Clicking this button can parse the data in the Excel table into data table records, and display the data table records to the client through a prompt box via automation.

To implement the above import button, you need to add a button to the toolbar of the data table module, select Call Automation After Parsing Imported Data as the execution action in the configuration item, and select the module that needs to import data in the Data Table configuration item. In this case, we select the current table (Data Table Control). In the configuration item Allow Users to Select the Following Fields for Import, select the fields that users are allowed to import. In this case, we select Random Number and Date. The configuration item Default Mapping Relationship can set the default import fields in different columns. In this case, Random Number is selected for the first column and Date is selected for the second column.