A method and server for data import of a web system

Abstract

The specification provides a method and a server for web system data import, the method comprising: according to a data import instruction input by a user, a web front end requests and acquires template configuration information from the server, a corresponding table entry interface is rendered through a man-machine interaction interface by using an online table component according to the template configuration information, configuration data input by the user through the entry interface is acquired, the configuration data is verified according to a verification rule set associated with the template configuration information acquired from the server, and when abnormal data is detected, abnormal data information is fed back to the user. Through the scheme, online entry of a server configuration file can be realized.

Description

Technical Field

[0001] This specification relates to the field of communication technology, and in particular to a method and server for importing data into a Web system. Background Technology

[0002] As enterprises become increasingly information-driven, various web management systems (such as ERP, CRM, and OA) play a central role in daily operations. In these systems, batch data import is a high-frequency and critical operation, often used for initializing data, updating records in batches, or migrating data from external systems.

[0003] Currently, the common practice in the industry is for users to fill in data in local spreadsheet software such as Microsoft Excel according to the template provided by the system, generating a data file (usually in .xlsx or .csv format), and then submit the file to the server through the file upload function of the web system. After receiving the file, the server-side program parses the data line by line and performs strict data validation according to preset business rules (such as data type, format, value range, uniqueness constraints, and relationships).

[0004] However, this traditional "offline preparation-upload-backend verification" model has significant efficiency bottlenecks and user experience issues: 1. Cumbersome operation process: Users need to go through multiple cycles of "upload -> wait -> view error report -> return to local to modify Excel -> upload again", which is time-consuming and laborious.

[0005] 2. Error location is not intuitive: Error feedback is usually presented as a text list, which requires users to manually match it with Excel cells, making it easy to make mistakes.

[0006] 3. Delayed verification feedback: This is a "post-verification" issue, where guidance cannot be obtained during input.

[0007] 4. Template version management challenges: When business changes or system upgrades cause data templates to be updated (such as adding or removing columns, or changes in validation rules), if users continue to use the old version templates stored locally, the import will fail due to format mismatch. Summary of the Invention

[0008] To overcome the problems existing in related technologies, this specification provides a method and server for importing data into a Web system.

[0009] According to a first aspect of the embodiments of this specification, a method for importing data into a Web system is provided, the method comprising: Based on the data import instructions entered by the user, the web front-end requests and obtains the template configuration information from the server, and uses the online form component to render the corresponding form entry interface through the human-computer interaction interface according to the template configuration information. The system obtains configuration data input by the user through the input interface, verifies the configuration data according to the verification rule set associated with the template configuration information obtained from the server, and provides feedback on abnormal data to the user when abnormal data is detected.

[0010] This includes obtaining the data import table filled out by the user offline, and importing the data import table beforehand; The configuration data in the data import table is validated based on the set of validation rules associated with the template configuration information obtained from the server; When it is found that there is target abnormal data in the configuration data of the data import table, it is determined whether the target abnormal data is critical data; If the data is not critical, allow the import of configuration data from the data import table; If the data is critical, the configuration data in the data import table should not be imported.

[0011] The process of importing data based on user input involves the web frontend requesting and obtaining template configuration information from the server, and then using an online form component to render the corresponding form entry interface through a human-computer interaction interface based on the template configuration information. Embed an online form component in the web front-end page; When the web frontend receives a data import instruction from the user, it requests template configuration information from the server. Using the online form component, the corresponding form input interface is rendered through the human-computer interaction interface according to the template configuration information.

[0012] The method further includes: establishing a set of verification rules, including: Link the input rules of the authentication module, user management module, database, and foreign key association module within the device, and establish a set of verification rules; Establish a relationship between each rule in the validation rule set and the table items in the rendered table entry interface.

[0013] The step of validating the configuration data in the data import table based on the validation rule set associated with the template configuration information obtained from the server includes: Identify each item in the imported data table and match it with the corresponding rules in the validation rule set; Based on the matching results, identify whether there is any target abnormal data in the configuration data of the data import table.

[0014] As can be seen from the above examples, this disclosure realizes the online input and verification functions of server configuration files. Error information is directly associated with and located through cell styles, eliminating the trouble of manual comparison. At the same time, it is also compatible with offline use scenarios of configuration files. When users import configuration data using old version templates, as long as the key data meets the current system requirements, the system can still automatically import the data, reducing the import failure rate caused by template version differences.

[0015] According to a second aspect of the embodiments of this specification, a server is provided, the server comprising: The acquisition module is used to request and obtain template configuration information from the server based on the data import instructions input by the user. The web front-end then uses the online form component to render the corresponding form entry interface through the human-computer interaction interface based on the template configuration information. The processing module is used to obtain the configuration data entered by the user through the input interface, verify the configuration data according to the verification rule set associated with the template configuration information obtained from the server, and when abnormal data is detected, to provide feedback on the abnormal data information to the user.

[0016] The acquisition module is also used to acquire the data import table filled out by the user offline; The processing module is further configured to verify the configuration data in the data import table according to the verification rule set associated with the template configuration information obtained from the server before importing the data import table; When it is found that there is target abnormal data in the configuration data of the data import table, it is determined whether the target abnormal data is critical data; If the data is not critical, allow the import of configuration data from the data import table; If the data is critical, the configuration data in the data import table should not be imported.

[0017] The acquisition module is specifically used to embed online form components in the web front-end page; When the web frontend receives a data import instruction from the user, it requests template configuration information from the server. Using the online form component, the corresponding form input interface is rendered through the human-computer interaction interface according to the template configuration information.

[0018] The server further includes a configuration module, used to link the input rules of the authentication module, user management module, database, and foreign key association module within the device, and to establish a set of verification rules; Establish a relationship between each rule in the validation rule set and the table items in the rendered table entry interface.

[0019] Specifically, the processing module is used to identify each item in the data import table and match it with the rules in the validation rule set. Based on the matching results, identify whether there is any target abnormal data in the configuration data of the data import table.

[0020] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and are not intended to limit this specification. Attached Figure Description

[0021] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this specification and, together with the description, serve to explain the principles of this specification.

[0022] Figure 1 This is a flowchart illustrating a method for importing data into a Web system according to an exemplary embodiment of this specification. Detailed Implementation

[0023] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numerals in different drawings denote the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this specification. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this specification as detailed in the appended claims.

[0024] The terminology used in this specification is for the purpose of describing particular embodiments only and is not intended to be limiting of this specification. The singular forms “a,” “the,” and “the” as used in this specification and the appended claims are also intended to include the plural forms unless the context clearly indicates otherwise. It should also be understood that the term “and / or” as used herein refers to and includes any and all possible combinations of one or more of the associated listed items.

[0025] It should be understood that although the terms first, second, third, etc., may be used in this specification to describe various information, this information should not be limited to these terms. These terms are only used to distinguish information of the same type from one another. For example, without departing from the scope of this specification, first information may also be referred to as second information, and similarly, second information may also be referred to as first information. Depending on the context, the word "if" as used herein may be interpreted as "when," "when," or "in response to determination."

[0026] The currently widely used method is "template Excel upload + server-side batch verification". The specific process is as follows: 1. The web system provides a fixed-format Excel template for users to download.

[0027] 2. Users open the template and fill in the data using Excel software on their local machines.

[0028] 3. Users can upload a completed Excel file using the file selection control on the web interface.

[0029] 4. The server receives the file, parses the content, and performs batch verification.

[0030] 5. After the verification is completed, the system generates an error report and presents it to the user.

[0031] 6. Users modify their local Excel file according to the report and re-upload it until successful.

[0032] The above approach has the following problems: 1. Cumbersome and time-consuming operation process: It requires repeated switching between local software and browser, making rapid iteration impossible.

[0033] 2. Error location is not intuitive: it is difficult to match text error reports with Excel cells.

[0034] 3. Delayed verification feedback: All verifications are performed after the fact.

[0035] 4. Template version out of control: Users may use outdated local templates, causing batch import failures, and the problem is difficult to trace and resolve in a unified manner.

[0036] To address the aforementioned technical problems, this disclosure provides a method for importing data into a Web system, such as... Figure 1 As shown, the method includes: Based on the user's input data import instructions, the web frontend requests and obtains template configuration information from the server, and uses the online form component to render the corresponding form entry interface through the human-computer interaction interface according to the template configuration information. S102 obtains the configuration data entered by the user through the input interface, verifies the configuration data according to the verification rule set associated with the template configuration information obtained from the server, and when abnormal data is detected, provides feedback on the abnormal data information to the user.

[0037] In step S101, the system can embed an online table component in the web front-end page. When a user enters the data import function page, for example, upon receiving a data import instruction from the user, the web front-end requests the latest template configuration information from the server. This template configuration information is structured data, which may include, for example, column definitions (keys, headers, data types), initial styles, and bound validation rule identifiers. The online table component renders the table interface in real time based on this template configuration information. Users can obtain an input interface in their browser that is completely consistent with the system's current requirements without downloading anything.

[0038] In this embodiment, while configuring structured data according to template configuration information, the web frontend can obtain a complete set of validation rules corresponding to each column of the template from the server, such as: Front-end rules: Rules that can be executed directly in the browser (e.g., NOT NULL, number format, date format, regular expression matching, static dropdown list).

[0039] Server-side rule identifiers: identifiers for complex business rules that require server verification (e.g., uniqueness, dynamic data range, cross-table join validity).

[0040] The front end dynamically binds the validation rule set to the corresponding columns of the online table, establishing the association between the columns and the validation logic.

[0041] In one implementation, the above-mentioned relationship can be established through automatic generation.

[0042] Specifically, validation rules for key data fields can be automatically generated by the system based on the metadata of the business modules. The system can read the data model, field attributes, authentication constraints, or database constraints of each business module and automatically generate the corresponding validation rules. For example: 1. When the field originates from the authentication module, automatically generate username format rules, password complexity rules, account uniqueness rules, etc. 2. When the field originates from the user management module, it automatically generates mobile phone number format rules, email format rules, organization code rules, etc. 3. When a field has a unique index in the database, uniqueness verification rules are automatically generated; 4. When a field has a foreign key relationship, automatically generate relationship validity validation rules; 5. When a field is defined as a required field, a non-empty validation rule is automatically generated.

[0043] The aforementioned key data rules can be automatically synchronized to the front-end online table component by the system, achieving consistency with the rules of the business system, reducing manual maintenance costs, and avoiding data errors caused by rule omissions.

[0044] Furthermore, for non-critical data fields, the system supports administrators in configuring custom rules through the template management center. Administrators can configure one or more of the following rules online: • Is this field required? • Text length range; • Regular expressions; • Numerical range; • Date range; • Range of enumerated values; • Drop-down options; • Customize the message.

[0045] In this embodiment, it is also possible to dynamically export offline Excel templates, allowing users to fill in Excel files offline locally and then re-upload them to the system after completion. Specifically, users can export the Excel file corresponding to the current template through the web system. The Excel file is dynamically generated by the server based on the latest template configuration, and its field structure, column order, data type description, drop-down options, and validation prompts are consistent with the online table.

[0046] After receiving the Excel file, the system performs template compatibility analysis. Even if the user uses a data file generated from a previous version of the template, as long as the key data fields meet the current system requirements, the system will still allow successful import.

[0047] As can be seen, this embodiment not only supports online real-time editing and import, but is also compatible with traditional Excel offline data entry scenarios, improving system applicability and user migration compatibility.

[0048] As can be seen from the above embodiments, this disclosure realizes the functions of online input and verification of server configuration files. Error information is directly associated with and located through cell styles, eliminating the trouble of manual comparison. At the same time, it is also compatible with offline use scenarios of configuration files. When users import configuration data using old version templates, as long as the key data meets the current system requirements, the system can still automatically import it, reducing the import failure rate caused by template version differences.

[0049] Based on the above method embodiments, this disclosure also provides a server, the server comprising: The acquisition module is used to request and obtain template configuration information from the server based on the data import instructions input by the user. The web front-end then uses the online form component to render the corresponding form entry interface through the human-computer interaction interface based on the template configuration information. The processing module is used to obtain the configuration data entered by the user through the input interface, verify the configuration data according to the verification rule set associated with the template configuration information obtained from the server, and when abnormal data is detected, to provide feedback on the abnormal data information to the user.

[0050] The acquisition module is also used to acquire the data import table filled out by the user offline; The processing module is further configured to verify the configuration data in the data import table according to the verification rule set associated with the template configuration information obtained from the server before importing the data import table; When it is found that there is target abnormal data in the configuration data of the data import table, it is determined whether the target abnormal data is critical data; If the data is not critical, allow the import of configuration data from the data import table; If the data is critical, the configuration data in the data import table should not be imported.

[0051] The acquisition module is specifically used to embed online form components in the web front-end page; When the web frontend receives a data import instruction from the user, it requests template configuration information from the server. Using the online form component, the corresponding form input interface is rendered through the human-computer interaction interface according to the template configuration information.

[0052] The server further includes a configuration module, used to link the input rules of the authentication module, user management module, database, and foreign key association module within the device, and to establish a set of verification rules; Establish a relationship between each rule in the validation rule set and the table items in the rendered table entry interface.

[0053] Specifically, the processing module is used to identify each item in the data import table and match it with the rules in the validation rule set. Based on the matching results, identify whether there is any target abnormal data in the configuration data of the data import table.

[0054] For the device embodiments, since they basically correspond to the method embodiments, the relevant parts can be referred to in the description of the method embodiments. The device embodiments described above are merely illustrative. The modules described as separate components may or may not be physically separate, and the components shown as modules may or may not be physical modules, that is, they may be located in one place or distributed across multiple network modules. Some or all of the modules can be selected to achieve the purpose of the solution in this specification according to actual needs. Those skilled in the art can understand and implement this without creative effort.

[0055] The foregoing has described specific embodiments of this specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in a different order than that shown in the embodiments and may still achieve the desired result. Furthermore, the processes depicted in the drawings do not necessarily require the specific or sequential order shown to achieve the desired result. In some embodiments, multitasking and parallel processing are possible or may be advantageous.

[0056] Other embodiments of this specification will readily occur to those skilled in the art upon consideration of the specification and practice of the invention claimed herein. This specification is intended to cover any variations, uses, or adaptations that follow the general principles of this specification and include common knowledge or customary techniques in the art not claimed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of this specification are indicated by the following claims.

[0057] It should be understood that this specification is not limited to the precise structures described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this specification is limited only by the appended claims.

[0058] The above description is merely a preferred embodiment of this specification and is not intended to limit this specification. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this specification should be included within the scope of protection of this specification.

Claims

1. A method for importing data into a Web system, characterized in that, The method includes: Based on the data import instructions entered by the user, the web front-end requests and obtains the template configuration information from the server, and uses the online form component to render the corresponding form entry interface through the human-computer interaction interface according to the template configuration information. The system obtains configuration data input by the user through the input interface, verifies the configuration data according to the verification rule set associated with the template configuration information obtained from the server, and provides feedback on abnormal data to the user when abnormal data is detected.

2. The method according to claim 1, characterized in that, The method further includes: Obtain the data import table filled out by the user offline, and import the data import table before doing so; The configuration data in the data import table is validated based on the set of validation rules associated with the template configuration information obtained from the server; When it is found that there is target abnormal data in the configuration data of the data import table, it is determined whether the target abnormal data is critical data; If the data is not critical, allow the import of configuration data from the data import table; If the data is critical, the configuration data in the data import table should not be imported.

3. The method according to claim 1, characterized in that, According to the user's input data import instruction, the web frontend requests and obtains template configuration information from the server, and uses an online form component to render the corresponding form entry interface through a human-computer interaction interface based on the template configuration information, including: Embed an online form component in the web front-end page; When the web frontend receives a data import instruction from the user, it requests template configuration information from the server. Using the online form component, the corresponding form input interface is rendered through the human-computer interaction interface according to the template configuration information.

4. The method according to claim 1, characterized in that, The method further includes: establishing a set of verification rules, including: Link the input rules of the authentication module, user management module, database, and foreign key association module within the device, and establish a set of verification rules; Establish a relationship between each rule in the validation rule set and the table items in the rendered table entry interface.

5. The method according to claim 2, characterized in that, The step of validating the configuration data in the data import table based on the set of validation rules associated with the template configuration information obtained from the server includes: Identify each item in the imported data table and match it with the corresponding rules in the validation rule set; Based on the matching results, identify whether there is any target abnormal data in the configuration data of the data import table.

6. A server, characterized in that, The server includes: The acquisition module is used to request and obtain template configuration information from the server based on the data import instructions input by the user. The web front-end then uses the online form component to render the corresponding form entry interface through the human-computer interaction interface based on the template configuration information. The processing module is used to obtain the configuration data entered by the user through the input interface, verify the configuration data according to the verification rule set associated with the template configuration information obtained from the server, and when abnormal data is detected, to provide feedback on the abnormal data information to the user.

7. The server according to claim 6, characterized in that, The acquisition module is also used to acquire the data import table filled out by the user offline; The processing module is further configured to verify the configuration data in the data import table according to the verification rule set associated with the template configuration information obtained from the server before importing the data import table; When it is found that there is target abnormal data in the configuration data of the data import table, it is determined whether the target abnormal data is critical data; If the data is not critical, allow the import of configuration data from the data import table; If the data is critical, the configuration data in the data import table should not be imported.

8. The server according to claim 6, characterized in that, The acquisition module is specifically used to embed online form components in web front-end pages; When the web frontend receives a data import instruction from the user, it requests template configuration information from the server. Using the online form component, the corresponding form input interface is rendered through the human-computer interaction interface according to the template configuration information.

9. The server according to claim 6, characterized in that, The server also includes: a configuration module, used to link the input rules of the authentication module, user management module, database, and foreign key association module within the device, and to establish a set of verification rules; Establish a relationship between each rule in the validation rule set and the table items in the rendered table entry interface.

10. The server according to claim 7, characterized in that, The processing module is specifically used to identify each item in the data import table and match it with the corresponding rules in the verification rule set; Based on the matching results, identify whether there is any target abnormal data in the configuration data of the data import table.

Images