Import Data Matching Update

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

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
Matched Record List	Select the record list that needs to be matched, only the data of the currently set record list will be updated

Example

In the data table module, we need an import update button. Clicking this button can batch update all data on the current page of the data table. By matching the specified column of data in the Excel table, update the data of other columns, and when the validation rules are not met, a prompt will be given and skipped without updating

To implement the above import button, you need to add a button to the toolbar of the data table module, select Import Data Matching Update 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 set to match update, and Date is selected for the second column. In this example, the data will be matched and updated according to the Random Number field. The matched record list is ${tableRecordList}