Data Entry Introduction

Function Description

The data entry function enables page data to be written to the database, supporting operations such as creating, deleting, and updating data. Additionally, it supports custom validation of input data, Excel data import, and intelligent linkage based on input values.

Notes

1. The data entry function of FineReport is not available for the following databases: Hive, Impala, ADB-MySQL, MongoDB, CirroData, MaxCompute (formerly ODPS), SAP BW, openPlant 5.0, ClickHouse (data insertion only), Presto, Doris, Transwarp, OceanBase, and StarRocks.

Note: 

1. FineDataLink allows you to write data to the following databases: Hive, Impala, ClickHouse, Doris, and Transwarp Inceptor.

2. FineDataLink also allows you to synchronize the data creation, deletion, and update operations from database A to database B, thereby reducing task configuration effort and improving data collection efficiency. For details, see FineDataLink Introduction, Data Comparison Example, and Overview of Scheduled Task.

2. Due to the functional limitations of FRM reports in data entry scenarios, you are advised not to use FRM reports for data entry unless necessary.

While FineReport offers a high degree of flexibility in template design, functional limitations still exist. Therefore, you are advised to pay attention to the following aspects when creating data entry templates:

1. Avoid creating Excel-like templates, as they may incur problems in maintenance and preview performance.

Excel-like templates are those where the header and subsequent columns consist of non-expanding cells, as shown in the following figure.

2. Avoid using SQL functions and enabling Display Widget Directly when the template contains many expanding rows. This is because SQL functions are executed repeatedly, which can impact the overall computation performance, and directly displaying widgets increases page rendering pressure.

3. Use Chromium-based browsers, such as Chrome and Edge, to preview the created templates.