Querying Table Data

Updated on 2025-01-23 GMT+08:00

View PDF

The data customization feature has been enabled for the tenant.
A dynamic data table has been released. For details, see Configuring Dynamic Data Tables.

Sign in to the AICC as a tenant administrator and choose Configuration Center > Expansion Management > Table Data.
Click and select a released dynamic data table to configure table data.
Import table data.
1. Choose Import Data. The data import page is displayed.
2. Click Export Template to download the table data template to a local path and fill in table data.
  NOTE:
  - Only an Excel file can be uploaded. The file size cannot exceed 20 MB. The file name can contain only Chinese characters, letters, digits, and underscores (_).
  - The header of the uploaded Excel file must match that of the downloaded template. Otherwise, the file processing fails.
  - The imported data cannot start with +, =, or @. If the data starts with -, the data must be in the format of -{One or more digits}{Several characters}.
3. Click . In the dialog box that is displayed, select the configured table data file.
4. Click Submit. In the dialog box that is displayed, click OK to import the table data.
Click Import Result View. On the import result list page that is displayed, confirm that the Status of the data import record is Completed.
Click Return. The table data list page is displayed, showing details about the imported data.

Data editing: Imported table data can be edited again.
- Click Edit. On the Edit page, edit table data except index data. After confirming that the data is correct, click Submit to save the table data.
- Click Delete. In the dialog box that is displayed, click Yes to delete unnecessary table data.
Data export: Existing table data can be exported.
NOTE:

The exported data contains personal data. Exercise caution when processing the exported data to prevent personal data leakage and abuse.
1. Click New Export Task. The Enter compression password dialog box is displayed.
2. Enter the customized compression password and click Confirm. The data is exported successfully.
3. In the dialog box that is displayed, click OK to return to the table data configuration page.
4. Click Export Task View. The export result page is displayed.
5. Select the export record whose Status is Success, and click Download to export the table data file to a local path.
6. After the download is successful, open the exported file and enter the compression password to view table data.