I. Overview
1. Application scenarios
All the logic for importing is described in the Import Excel document. Location matching is the built-in logic that cannot be modified. Matching by title is the default logic. For other logic, you need to install the plugin "Excel Import Logic Setting" before setting and modifying it.
2. Function logic
1) The plugin configuration is global, meaning that the import function of all templates takes effect. Currently, it is not supported to set import logic for a single template.
2) Import methods other than "Tag Import" are affected by this plugin configuration.
II. Plugin introduction
1. Install the plugin
Click to download the plugin: fr-plugin-excelimportattr-1.7.zip
Designer plugin installation method reference: Plugin Management
Server installation plugin method reference: Server plugin management
2. Setting the import logic
After installing the plugin, click "Template > Excel Import Setting" on the menu bar of designer, the Excel Import Setting dialog box will pop up, and you can set the import logic.
3. Function introduction
Import Logic | Description |
---|---|
Import Excel Match by Title | Default logic. Compare the title in Excel and the template, and import the column data if the title is the same. This logic is triggered only if at least two or more column titles match. |
Import Excel matched by location | After identifying the area where data needs to be imported, import the data in the order of the columns in Excel, without determining whether the titles are consistent. |
Display Value Conversion | It is disabled by default. The value imported by Excel will be submitted to the library as the actual value. After this function is enabled, the values imported by Excel can be converted into corresponding actual values for library according to the data dictionary settings of cells. |
Bidirectional Extension Cell Import | It is disabled by default. If the import area of a template contains horizontal and vertical extension cells, or multiple datasets exist, select bidirectional extension cell import. |