Display Value Conversion During Excel Import

Application Scenarios

You can import values from Excel and convert them into desired actual values for storage through settings in Display > Data Dictionary. For example, when you import M and F from Excel, 1 and 2 are stored into the database instead.

Functional Logic

1. Install Excel import mark plugin first.

2. After you set Data Dictionary under Display, the imported value will act as the display value when submitted, and will be converted into the actual value and stored in the database according to the data dictionary.

3. Setting Data Dictionary > Formula is not supported.

Preparing the Template

Setting Data Dictionary

Click cell C2, select Data Dictionary under Cell Attributes > Display, set Type to Custom, and add Actual Value and Display Value.

Setting Data Entry Attributes

Click Template > Data Entry Attributes, add Built-in SQL, select Smart Submit and the embeded table Student, and bind the fields and cells.

Setting Excel Import

Click Template > Excel Import Mark, and tick Convert data to actual values to submit. For details, see Excel Import Mark.

Adding Mark the Import Button

Go to Template > Web Attributes > Data Entry Settings, select Individually set for the template, double-click Mark the import and add it to the toolbar.

Demonstration

1. Save the report, click Data Entry Preview, click Mark the import to import the Excel file.

2. After submission, preview the database table student, and you can see that the imported data in the gender column is the Actual Value.

Note: Excel import is not supported on mobile devices.

Click to download the template:Display Value Conversion During Excel Import.zip

Click to download the Excel: Display Value Conversion.zip