Visual configuration type data filling and reporting system

Abstract

The invention relates to the technical field of data processing, discloses a visual configuration type data filling and reporting system, and aims to optimize a data entry process, improve data quality, reduce complexity and error rate of data filling and reporting and improve data quality. According to the scheme, the system mainly comprises a template management module, a configuration module, an authority management module, a visual graphical interface module, a verification module, a data import module, a data export module and a log module. According to the method, the data filling difficulty is reduced, the filling efficiency and consistency are improved, the security and compliance of the data are ensured, flexible configuration can be realized, diversified requirements are met, and the method is particularly suitable for filling tasks with relatively large data volumes.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a visual configuration-based data filling system. Background Art

[0002] With the advent of the big data era, data filling and processing have become key links in enterprise operation and decision-making. As an important tool in the field of modern data management and analysis, visual configuration-based data filling aims to optimize the data entry process and improve data quality through an intuitive graphical interface and flexible configuration means. This solution allows users to quickly enter data through intuitive operations such as dragging and clicking. Although visual configuration-based data filling performs well in many aspects, there are still some limitations, mainly in the following aspects:

[0003] Although the system provides flexible configuration means, for non-professional users, the configuration process still appears complex and time-consuming. Users need to have a certain technical background to accurately understand and operate the configuration options, which to some extent limits the popularization and usability of the system; during the data filling process, although the existing system provides certain security mechanisms, there are still certain risks in the face of complex security threats such as data leakage and malicious attacks; although the graphical interface significantly improves the operation efficiency, there is still room for further improvement in terms of details. For example, the interface layout is too cumbersome or not intuitive enough, and the interaction design lacks fluency and humanization, which may cause users to feel confused or dissatisfied during use, thus affecting the overall satisfaction and loyalty of the system. Especially during long-term and high-intensity filling work, the visual system of staff will feel fatigued due to continuously receiving a large amount of visual information.

[0004] For example, in the data management department of a large enterprise, the staff are busy with an important data filling task. This task involves a large number of data items, including aspects such as sales, costs, and profits, and these data need to be filled in according to specific formats and rules. To reduce the workload, the enterprise has configured a filling template for this task, which contains all the data items to be filled in and their corresponding input positions. However, during the actual filling process, due to the large amount of data and the numerous data items in the filling template, the staff gradually feel visual fatigue and distracted attention during the long-term and high-intensity filling work. In addition, the data items in the template are sometimes difficult to accurately distinguish because their names are similar or their formats are alike. These factors together cause the staff to easily click on the wrong input position when entering data, that is, to input the data into the wrong data item. Once the data is input into the wrong position, the staff needs to perform repeated input and deletion operations to correct the error. This process is not only time-consuming and laborious but also may increase the risk of data errors due to frequent operation mistakes. At the same time, the continuous repeated operations also reduce the user experience of the staff and increase their mental burden and work pressure. Summary of the Invention

[0005] The present invention aims to provide a visual configuration-based data filling system to optimize the data entry process, improve data quality, and reduce the complexity and error rate of data filling.

[0006] The technical solution adopted by the present invention to solve the above technical problems is as follows:

[0007] A visual configuration-based data filling system, the system comprising:

[0008] A template management module, used to create a filling template and configure the layout and style of the filling template according to the user's interactive operations on the template configuration interface, and automatically optimize the layout of the filling template;

[0009] A configuration module, used to configure data types, data formats, and data verification rules according to the user's interactive operations on the data configuration interface;

[0010] A permission management module, used to manage and verify user permissions so that users can only access and operate on data within the corresponding permission scope;

[0011] A visual graphic interface module, used to present the operation interface with graphic elements so that users can perform interactive operations on the graphic elements to achieve data filling, data configuration, permission management, and data import and export, and provide real-time dynamic feedback on the interactive operations when users perform interactive operations;

[0012] A verification module, which is used to perform real-time data verification according to data verification rules when the user fills in data, and feedback error prompt information when errors are found during verification;

[0013] A data import module, which is used to receive imported data, automatically parse the format and structure of the imported data, verify and clean the imported data, and map the imported data to the corresponding fields or tables in the system according to preset rules;

[0014] A data export module, which is used to export the filled data according to a preset format and preset style when receiving a data export request;

[0015] A log module, which is used to record all interaction operations of the user.

[0016] Furthermore, automatically optimize the layout of the filling template, including:

[0017] Count the number of repeated edits by the user at the same position. If the number of repeated edits is greater than the number threshold, calculate the touch area of each interactive control in the layout of the filling template. If the touch area of a certain interactive control is less than the area threshold, automatically expand the touch area of the corresponding interactive control, or add guiding information to the corresponding interactive control.

[0018] Furthermore, automatically optimize the layout of the filling template, which also includes:

[0019] Count the number of repeated edits by the user at the same position. If the number of repeated edits is greater than the number threshold, judge the similarity of the names or formats of each interactive control. If the similarity is greater than the similarity threshold, automatically adjust the name or format of the corresponding interactive control according to the user's historical input habits.

[0020] Furthermore, the system further includes:

[0021] A click position prediction module, which is used to collect historical data of the user under each filling template. The historical data includes input positions, input contents, and input frequencies. Based on the historical data, build an input habit model of the filling template. When the user fills in data, predict the user's next input position according to the current interaction operation and input content and based on the input habit model, and feedback the predicted next input position.

[0022] Furthermore, feedback on the predicted next input position includes one or more of highlighting the next input position, displaying a prompt box, and expanding the click range.

[0023] Furthermore, the click position prediction module is also used to perform click feedback when the cursor movement coincides with the next input position. The click feedback includes one or more of vibration prompts and sound prompts.

[0024] Further, the system further includes:

[0025] A progress monitoring module, configured to, when performing data import and data export, monitor in real time and feedback the data import progress, data export progress, as well as error and warning information occurring during the data import or data export process.

[0026] Further, the graphical elements at least include buttons, icons, and drag bars, and the interaction operations at least include clicking and dragging.

[0027] Further, the verification rules at least include format verification, range verification, and uniqueness verification.

[0028] Further, the preset formats include at least CSV, Excel, PDF, HTML, JSON, and XML.

[0029] The beneficial effects of the present invention are as follows: The visual configuration-based data filling system provided by the present invention supports users to perform data filling configuration through intuitive and easy-to-use graphical interfaces, allowing for dragging and clicking operations. It can flexibly configure data types, data formats, and verification rules to meet the diverse needs of enterprises. During the data filling process, the system performs real-time data verification. Once an error is found, a clear error prompt is immediately provided to help users quickly locate and correct it. At the same time, the system provides a data filling template function, enabling users to create, save, and reuse templates according to their needs, improving the filling efficiency and consistency. Additionally, it can automatically optimize the layout of the filling templates, reducing the error rate of data filling. The system supports the import and export of multiple data formats, facilitating data exchange and sharing with other systems. In terms of permission management, the system provides a permission management function, allowing different data filling permissions to be set according to different users to ensure data security and compliance. Furthermore, the present invention can predict the input position based on the user's input habits, shortening the touch response time and further improving the data filling efficiency. Description of the Drawings

[0030] Figure 1 A schematic structural diagram of the visual configuration-based data filling system provided for the embodiment. Detailed Embodiments

[0031] In order to enable those skilled in the art of the present technology to better understand the solution of the present invention, the technical solutions in the present embodiment will be clearly and completely described below in conjunction with the accompanying drawings in the present embodiment.

[0032] Due to the relatively high threshold for designing the filling templates in the current visual configuration-based data filling system, it is easy to result in poor efficiency and accuracy of data filling due to unreasonable layouts, and it is also prone to data leakage. Based on this, the technical solution of the present invention is proposed. In the present invention, the visual configuration-based data filling system includes: a template management module, which is used to create a filling template according to the user's interactive operations on the template configuration interface, configure the layout and style of the filling template, and automatically optimize the layout of the filling template; a configuration module, which is used to configure data types, data formats, and data verification rules according to the user's interactive operations on the data configuration interface; a permission management module, which is used to manage and verify user permissions so that users can only access and operate on the data within the corresponding permission scope; a visual graphic interface module, which is used to present the operation interface with graphical elements so that users can perform interactive operations on the graphical elements to achieve data filling, data configuration, permission management, and data import and export, and perform real-time dynamic feedback on the interactive operations when the users perform interactive operations; a verification module, which is used to perform real-time data verification according to the data verification rules when the users perform data filling, and feedback error prompt information when errors are found during verification; a data import module, which is used to receive imported data, automatically parse the format and structure of the imported data, verify and clean the imported data, and map the imported data to the corresponding fields or tables in the system according to preset rules; a data export module, which is used to export the filled data according to a preset format and preset style when receiving a data export request; a log module, which is used to record all the interactive operations of the users.

[0033] Specifically, the template management module provides a data filling template function, allowing users to create, save, and reuse templates according to their needs, improving the efficiency and consistency of data filling; the configuration module supports the configuration of multiple data types, including numerical values, texts, dates, etc., and at the same time allows users to customize data formats, verification rules, etc. to meet the diverse data filling needs of enterprises; the permission management module provides a permission management function, which can set different data filling permissions for different users to ensure the security and compliance of data; the visual graphic interface is used to provide an intuitive and easy-to-use graphic interface, and users can perform data filling, data configuration, permission management, and data import and export through operations such as dragging and clicking; the verification module is used to perform real-time data verification during the data filling process, such as format verification, range verification, etc. Once an error is found, a clear error prompt is immediately given to help users quickly locate and correct the error; the data import module and the data export module provide data import and export functions, supporting the import and export of multiple data formats, facilitating data exchange and sharing between users and other systems; the log module can record all the operation behaviors of users on the data, including data import, export, modification, deletion, etc. This helps to trace and review the operation behaviors of users, and promptly discover and handle potential security risks and compliance issues.

[0034] The technical solutions in this embodiment will be clearly and completely described below in conjunction with the accompanying drawings in this embodiment. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments.

[0035] Figure 1 A schematic structural diagram of a visual configuration data filling system is shown. Please refer to Figure 1 , the system includes: a template management module, a configuration module, a permission management module, a visual graphic interface module, a verification module, a data import module, a data export module, and a log module.

[0036] Among them, the template management module is used to create a filling template and configure the layout and style of the filling template according to the user's interactive operations on the template configuration interface, and automatically optimize the layout of the filling template.

[0037] Specifically, the user can create, save, and reuse templates according to needs, improving the efficiency and consistency of data filling. In practical applications, the filling template includes a main input area and a non-main input area. For the main input area, the filling template includes the main input area and each editing area (such as a cell). When filling data, the main input area is used to input any data, and then the main input area automatically identifies and locates the position of the corresponding editing area based on the input data, associates the data with the editing area, and prompts the user whether the data corresponds to the editing area. If it corresponds, the data is filled into the corresponding editing area; for the non-main input area, the layout of the filling template can be automatically optimized during the filling process.

[0038] In this embodiment, automatically optimizing the layout of the filling template includes: counting the number of repeated edits by the user at the same position. If the number of repeated edits is greater than the number threshold, calculate the touch area of each interactive control in the layout of the filling template. If the touch area of a certain interactive control is less than the area threshold, automatically expand the touch area of the corresponding interactive control, or add guiding information to the corresponding interactive control.

[0039] In practical applications, when the user fills data using the filling template, when the number of repeated input and deletion by the user at the same position exceeds the number threshold, the system automatically optimizes the layout of the corresponding filling template. Specifically, if the touch area of a certain interactive control is less than the area threshold, the system will consider that this position is difficult to click accurately. At this time, by automatically expanding the touch area of the corresponding interactive control, or adding guiding information to the corresponding interactive control and other methods, it helps the user to click on the target position more accurately. Among them, the number threshold and the area threshold can be set according to the actual situation, and this embodiment does not make any restrictions.

[0040] In this embodiment, automatically optimizing the layout of the filling template further includes: counting the number of repeated edits by the user at the same position. If the number of repeated edits is greater than the number threshold, then judge the similarity of the names or formats of each interactive control. If the similarity is greater than the similarity threshold, then automatically adjust the name or format of the corresponding interactive control according to the user's historical input habits.

[0041] Specifically, when the similarity of the names or formats of the interactive controls in the filling template is relatively high, the system will consider that the user may frequently click incorrectly between these positions. At this time, according to the user's historical input habits, automatically adjust the name or format of the corresponding interactive control to achieve automatic optimization of the interactive control.

[0042] The configuration module is used to configure data types, data formats, and data verification rules according to the user's interactive operations on the data configuration interface.

[0043] Specifically, the configuration module supports the configuration of multiple data types, including numerical values, text, dates, etc. At the same time, it allows users to customize data formats, data verification rules, etc. to meet the diverse data filling needs of enterprises. For example, when creating a form, the user can select the corresponding data type and customize the data format through the data configuration interface, such as setting the date format, number format, etc. And the system provides a data verification rule configuration function. The user can set multiple data verification rules for the control, such as required, format verification, range verification, etc. The user can also flexibly adjust the configuration options according to the needs, such as modifying the display order of the interactive control, adjusting the size and position of the interactive control, etc.

[0044] The permission management module is used to manage and verify user permissions so that users can only access and operate data within the corresponding permission scope.

[0045] Specifically, the system provides a role and permission division function. Different roles and permissions can be assigned to users according to their identities, responsibilities, and needs. This helps to achieve refined management of user permissions and ensure that each user can only access and operate data within their permission scope. During the data filling process, the system can restrict the user's access and modification permissions to certain data items according to the user's permission settings. During the data import and export process, it can also restrict the export and import permissions of certain data according to the user's permissions, thereby preventing unauthorized data operations and data leakage risks and ensuring the security and compliance of the data.

[0046] The visual graphic interface module is used to present the operation interface with graphical elements so that users can perform interactive operations on the graphical elements to achieve data filling, data configuration, permission management, and data import and export. When the user performs an interactive operation, real-time dynamic feedback of the interactive operation is carried out;

[0047] Specifically, the visual graphical interface uses graphical elements to provide an intuitive and user-friendly graphical operation interface. The graphical elements include buttons, icons, and drag bars, etc. Among them, buttons are used to perform various operations, such as submission, saving, revocation, etc.; icons represent different configuration items or functions, such as settings, editing, deletion, etc.; drag bars allow users to adjust the position or size of configuration items by dragging.

[0048] Users can perform data filling, data configuration, permission management, and data import and export through interactive operations such as dragging and clicking. Through simple dragging operations, configuration items such as required data items and data verification rules can be added to the filling template without writing complex code or performing cumbersome settings.

[0049] When users perform interactive operations such as dragging and clicking, the interface will immediately give dynamic feedback, such as highlighting, color change prompts, etc., allowing users to clearly perceive the effects and states of the operations, so as to make further adjustments or confirmations. During the configuration process, the interface will intelligently provide relevant tips and suggestions according to the user's operations and inputs. These tips help users quickly complete the configuration and reduce errors caused by operation mistakes.

[0050] The verification module is used to perform real-time data verification according to data verification rules when users fill in data, and feedback error prompt information when errors are found during verification.

[0051] Specifically, during the data filling process, the system performs real-time data verification, including format, range, etc. verification. When errors are found during data verification, the system will immediately give clear error prompt information. These prompt information will clearly indicate the types and locations of the errors, helping users quickly locate and correct the errors. In addition to text prompts, the system can also provide visual feedback methods, such as highlighting error data in red, flashing prompt boxes, etc. This helps users more intuitively perceive the location of the errors, reduces the generation of error data, and improves the efficiency of error correction and data quality.

[0052] The data import module is used to receive imported data, automatically parse the format and structure of the imported data, verify and clean the imported data, and map the imported data to the corresponding fields or tables in the system according to preset rules.

[0053] Specifically, the system supports the import of multiple data formats, including but not limited to CSV, Excel, JSON, XML, etc. This ensures that users can easily obtain data from various sources and systems and import it into the current system for further processing and analysis.

[0054] The data export module is used to export the filled data according to the preset format and preset style when receiving the data export request.

[0055] Specifically, the system supports users to customize the format and style of data export, including selecting the fields to be exported, setting the order and format of fields, adding titles and comments, etc. This meets the users' needs for different data formats and styles, and improves the flexibility and usability of data export. In addition to common formats such as CSV and Excel, the system also supports exporting data to various formats such as PDF, HTML, JSON, and XML. This helps users share data with different audiences and platforms according to their needs, and realizes the wide dissemination and utilization of data. When exporting data, the system will strictly comply with the permissions and data security specifications set by users, ensuring that only users with corresponding permissions can export data, and the exported data complies with relevant laws, regulations, and privacy policy requirements. This helps protect the data security and privacy rights and interests of users, and prevents data leakage and abuse.

[0056] In addition, the system provided in this embodiment further includes a progress monitoring module, which is used to monitor and feedback the data import progress, data export progress, and error and warning information that occur during the data import or data export process in real time when data import and data export are performed.

[0057] Specifically, the progress monitoring module provides real-time monitoring and feedback functions for data import and export progress. Users can view the import and export progress, the amount of imported and exported data, and the error and warning information encountered in real time. This helps users understand the import and export situation in a timely manner and take necessary measures for intervention and adjustment.

[0058] The log module is used to record all interaction operations of users.

[0059] Specifically, the log module records all operation behaviors of users on data, including data import, export, modification, deletion, etc. This helps trace and review the operation behaviors of users, and timely discover and handle potential security risks and compliance issues.

[0060] The system provided in this embodiment further includes a click position prediction module, which is used to collect historical data of users under each filling template. The historical data includes input positions, input contents, and input frequencies. An input habit model of the filling template is constructed based on the historical data. When users perform data filling, according to the current interaction operations and input contents and based on the input habit model, predict the next input position of users, and feedback the predicted next input position.

[0061] Specifically, the system constructs a user input habit model by collecting and analyzing the user's filling templates and corresponding historical data. This model can identify the user's input preferences and patterns in different scenarios. During the data filling process, the system predicts the user's next input position based on the user's current operations and input content, in combination with the input habit model, and provides feedback on the predicted next input position, including one or more of highlighting the next input position, displaying a prompt box, and expanding the click range, so that the user can quickly locate and click on the target position. The corresponding visual effects of the feedback can be dynamically updated according to the user's click operations to ensure that the user can always accurately find the target position.

[0062] In this embodiment, the click position prediction module is further configured to provide click feedback when the cursor movement coincides with the next input position, and the click feedback includes one or more of a vibration prompt and a sound prompt.

[0063] Specifically, when the user's cursor moves to coincide with the predicted input position, the system immediately gives click feedback, such as a vibration prompt, a sound prompt, etc. These feedback signals will help the user confirm that they have correctly clicked on the target position, thereby enhancing the user's operation confidence and accuracy.

[0064] Touch feedback is an important mechanism in an intelligent touch system for confirming the user's operation state and enhancing the user's operation confidence. When the user's cursor moves to coincide with the predicted next input position, the system immediately gives touch feedback, such as a vibration prompt, a sound prompt, etc. These feedback signals can not only help the user confirm that they have correctly touched the target position, but also provide a more rich operation experience for the user through different feedback methods.

[0065] In practical applications, the optimization of touch feedback needs to be personalized according to the user's perception characteristics and operation requirements. For example, for users with poor eyesight, the system can increase the volume of the sound prompt or change the tone of the prompt sound; for users using touch devices in a noisy environment, the system can enhance the intensity and frequency of the vibration prompt. In addition, the system can also intelligently adjust the presentation method and timing of touch feedback according to the user's operation habits and feedback requirements to further improve the user's operation efficiency and satisfaction.

[0066] In addition, to improve the user's touch response speed, sensitivity optimization can also be performed on the predicted next input position. Specifically, the system expands the touch range (or click range) of this position, so that even if the user touches slightly or deviates from the target position, the input operation can be successfully triggered. This sensitivity optimization technology not only improves the user's operation convenience, but also can reduce the operation error rate caused by touch errors to a certain extent. In practical applications, the improvement of the input position sensitivity needs to be intelligently adjusted in combination with the user's touch habits and operation characteristics. For example, for users who are accustomed to using their fingertips for touch, the system can appropriately increase the touch range; while for users who are accustomed to using their nails or stylus for touch, the system needs to more accurately identify the touch position and force.

[0067] In summary, the visual configuration-based data filling system provided in this embodiment supports users to perform data filling configuration through intuitive and easy-to-use graphical interfaces, such as dragging and clicking operations. It can flexibly configure data types, data formats, and verification rules to meet the diverse needs of enterprises. During the data filling process, the system performs real-time data verification. Once an error is found, a clear error prompt is immediately provided to help users quickly locate and correct it. At the same time, the system provides a data filling template function, allowing users to create, save, and reuse templates according to their needs, improving the filling efficiency and consistency. Moreover, it can automatically optimize the layout of the filling templates, reducing the error rate of data filling. The system supports the import and export of multiple data formats, facilitating data exchange and sharing with other systems. In terms of permission management, the system provides a permission management function, which can set different data filling permissions according to different users to ensure data security and compliance. In addition, this embodiment can also predict the input position according to the user's input habits and provide touch feedback, shortening the touch response time and improving the data filling efficiency.

Claims

1. A visual configuration-based data reporting system, characterized in that The system includes: A template management module, which is used to create a filling template according to the user's interactive operations on the template configuration interface, configure the layout and style of the filling template, and automatically optimize the layout of the filling template; A configuration module, which is used to configure data types, data formats, and data verification rules according to the user's interactive operations on the data configuration interface; A permission management module, which is used to manage and verify user permissions so that users can only access and operate on data within the corresponding permission scope; A visual graphic interface module, which is used to present the operation interface with graphical elements so that users can perform interactive operations on the graphical elements to achieve data filling, data configuration, permission management, and data import and export. When users perform interactive operations, real-time dynamic feedback of the interactive operations is provided; A verification module, which is used to perform real-time data verification according to the data verification rules when users fill in data, and feedback error prompt information when errors are found during verification; A data import module, which is used to receive imported data, automatically analyze the format and structure of the imported data, verify and clean the imported data, and map the imported data to the corresponding fields or tables in the system according to preset rules; A data export module, which is used to export the filled data according to the preset format and preset style when receiving a data export request; A log module, which is used to record all the interactive operations of users.

2. The visual configuration type data filling system according to claim 1, characterized in that, Automatically optimizing the layout of the filling template includes: Counting the number of repeated edits by the user at the same position. If the number of repeated edits is greater than the number threshold, calculate the touch area of each interactive control in the layout of the filling template. If the touch area of a certain interactive control is less than the area threshold, automatically expand the touch area of the corresponding interactive control or add guiding information to the corresponding interactive control.

3. The visual configuration-based data filling system according to claim 1, wherein Automatically optimizing the layout of the filling template also includes: Counting the number of repeated edits by the user at the same position. If the number of repeated edits is greater than the number threshold, judge the similarity of the names or formats of each interactive control. If the similarity is greater than the similarity threshold, automatically adjust the name or format of the corresponding interactive control according to the user's historical input habits.

4. The visual configuration data filling system according to claim 1, wherein The system further includes: A click position prediction module, which is used to collect the historical data of the user under each filling template. The historical data includes the input position, input content, and input frequency. Based on the historical data, an input habit model of the filling template is constructed. When the user fills in data, predict the user's next input position according to the current interactive operation and input content and based on the input habit model, and provide feedback on the predicted next input position.

5. The visual configuration-based data filling system according to claim 4, wherein Providing feedback on the predicted next input position includes one or more of highlighting the next input position, displaying a prompt box, and expanding the click range.

6. The visual configuration type data filling system according to claim 4, wherein The click position prediction module is also used to provide click feedback when the cursor movement coincides with the next input position. The click feedback includes one or more of vibration prompts and sound prompts.

7. The visual configuration-based data filling system according to claim 1, wherein The system further includes: A progress monitoring module, which is used to monitor and feedback the data import progress, data export progress, as well as error and warning information occurring during the data import or data export process in real time when performing data import and data export.

8. The visual configuration type data filling system according to claim 1, wherein The graphical elements at least include buttons, icons, and drag bars, and the interaction operations at least include clicking and dragging.

9. The visual configuration type data filling system according to claim 1, wherein The verification rules at least include format verification, range verification, and uniqueness verification.

10. The visual configuration-based data filling system according to claim 1, wherein The preset formats include at least CSV, Excel, PDF, HTML, JSON, and XML.

Images