FR's online import of excel currently has three main logics: matching by title, matching by location, and two-way import. If users want to enable or disable certain logic, they need to modify the customconfig.xml file, which is troublesome. So we sorted out the current excel import logic and made it into a plugin to provide a visual interface. At the same time, the previously imported Excel display value plugin is also integrated into this plugin

1. [Demand]

There are currently three main types of FR's online import logic for excel: matching by title, matching by location, and two-way import. If users want to enable or disable certain logic, they need to modify the customconfig.xml file, which causes user operations to be more troublesome. So we sort out the current excel import logic and split it into plugin.

2. [Feature introduction]

• Match by title first, then match by cell position if not passed. By default, this option is the existing logic in the current FR (title matching and position matching are enabled at the same time). Only match by cell position, not selected by default. The effect when this option is selected is consistent with the effect of only enabling position matching in the existing logic.

• Display value Transform, the default is not checked, and the check is to enable the function of importing the actual value corresponding to the displayed value.

• Two-way extended grid import, unchecked by default, check it to enable the two-way import function.

3. [Plugin screenshot]