WO2020253069A1

WO2020253069A1 - Table data modification method and apparatus, and electronic device and storage medium

Info

Publication number: WO2020253069A1
Application number: PCT/CN2019/118601
Authority: WO
Inventors: 王宏力
Original assignee: 平安科技（深圳）有限公司
Priority date: 2019-06-17
Filing date: 2019-11-14
Publication date: 2020-12-24
Also published as: CN110413598A

Abstract

A table data modification method and apparatus, and an electronic device and a storage medium. The table data modification method comprises: when table data is received, checking the table data according to a configuration condition (S10); when the table data is wrong, obtaining and displaying error information of the table data, so that a user can visually view an error of the table data; when a modification instruction of the error information is received, determining a modification option corresponding to the error information (S13), displaying the modification option (S14), and modifying the table data according to the modification option when a confirmation signal for the modification option is received (S15). Therefore, the table data is intelligently modified, data processing is implemented, modification efficiency is improved, and the present invention is more human-computer interactive and more humanized.

Description

Table data modification method, device, electronic equipment and storage medium

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on June 17, 2019. The application number is 201910523715.8. The invention title is "Method, Apparatus, Electronic Equipment and Storage Medium for Form Data Modification". The entire content is incorporated by reference. In this application.

Technical field

This application relates to the field of data processing technology, and in particular to a method, device, electronic device and storage medium for modifying table data.

Background technique

In the prior art solution, after receiving the uploaded form data, in order to avoid format errors in the content of the form, it is also necessary for the staff to perform manual inspections, and when the errors are confirmed, manually add, Deleting, modifying, and checking requires high manpower consumption, and is prone to miss or don't see. The accuracy and efficiency of the investigation need to be improved.

Summary of the invention

In view of the above, it is necessary to provide a table data modification method, device, electronic equipment and storage medium, which can realize intelligent modification of table data, improve modification efficiency, and is more human-computer interaction, and at the same time more humane.

A method for modifying table data, the method includes:

When receiving the form data, review the form data according to the configuration conditions;

When the table data is incorrect, obtaining error information of the table data;

Display the error message;

When receiving a modification instruction of the error message, determine the modification option corresponding to the error message;

Display the modification options;

When a confirmation signal for the modification option is received, the table data is modified according to the modification option.

According to a preferred embodiment of the present application, the review of the table data according to configuration conditions includes one or a combination of the following:

Obtain required items in the form data, and when the required items are empty fields, determine that the form data is incorrect; and/or

Obtain the configuration data format of each item to be filled in the table data, and determine that the table data is incorrect when the data format of the data to be filled in the item to be filled is inconsistent with the corresponding configuration data format; and/or

Obtain historical data, and when the input data of the item to be filled is recorded in the historical data, it is determined that the table data is incorrect.

According to a preferred embodiment of the present application, the determining the modification option corresponding to the error information includes:

Obtain the cause of the error from the error message;

Obtain the configuration modification mode corresponding to the error cause;

The configuration modification mode is used as the modification option.

According to a preferred embodiment of the present application, the method further includes:

Obtain the configuration filling example of each item to be filled;

Show the configuration example.

When the reason for the error is that the input data of the item to be filled is recorded in the historical data, it is prompted whether to update the item to be filled.

According to a preferred embodiment of the present application, when a confirmation signal for the modified option is received, modifying the table data according to the modified option includes:

When receiving a selection signal for any modification manner in the configuration modification manner, modify the table data in the arbitrary modification manner.

According to a preferred embodiment of the present application, after modifying the table data according to the modification option, the method further includes:

Upload the table data;

Display the upload information of the table data.

A table data modification device, the device includes:

The review unit is used to review the form data according to the configuration conditions when the form data is received;

The obtaining unit is configured to obtain error information of the table data when the table data is incorrect;

A display unit for displaying the error message;

A determining unit, configured to determine a modification option corresponding to the error information when a modification instruction of the error information is received;

The display unit is also used to display the modification options;

The modification unit is configured to modify the table data according to the modification option when a confirmation signal for the modification option is received.

According to a preferred embodiment of the present application, the auditing unit auditing the table data according to configuration conditions includes one or a combination of the following:

According to a preferred embodiment of the present application, the determining unit is specifically configured to:

Obtain the cause of the error from the error message;

Obtain the configuration modification mode corresponding to the error cause;

The configuration modification mode is used as the modification option.

According to a preferred embodiment of the present application, the obtaining unit is further configured to obtain a configuration filling example of each item to be filled;

The display unit is also used to display the configuration filling example.

According to a preferred embodiment of the present application, the device further includes:

The prompt unit is used for prompting whether to update the to-be-filled item when the reason for the error is that the input data of the to-be-filled item is recorded in the historical data.

According to a preferred embodiment of the present application, the modification unit is specifically configured to:

The uploading unit is configured to upload the table data after modifying the table data according to the modification option;

The display unit is also used to display upload information of the table data.

An electronic device, which includes:

Memory, storing at least one instruction; and

The processor executes the instructions stored in the memory to implement the table data modification method.

A non-volatile readable storage medium stores at least one instruction, and the at least one instruction is executed by a processor in an electronic device to implement the table data modification method.

It can be seen from the above technical solutions that this application can review the table data according to the configuration conditions when the table data is received, and when the table data is wrong, obtain and display the error information of the table data, which makes the user intuitive Seeing the error of the table data, when receiving a modification instruction of the error message, determine the modification option corresponding to the error message, display the modification option, and when a confirmation signal for the modification option is received , Modify the table data according to the modification options, so as to realize the intelligent modification of the table data, improve the modification efficiency, and be more human-computer interaction, and at the same time more humane.

Description of the drawings

Fig. 1 is a flowchart of a preferred embodiment of the method for modifying the form data of the present application.

Fig. 2 is a functional module diagram of a preferred embodiment of the form data modification device of the present application.

FIG. 3 is a schematic structural diagram of an electronic device according to a preferred embodiment of the method for modifying table data in this application.

Detailed ways

In order to make the objectives, technical solutions, and advantages of the present application clearer, the present application will be described in detail below with reference to the accompanying drawings and specific embodiments.

As shown in Fig. 1, it is a flowchart of a preferred embodiment of the method for modifying form data of the present application. According to different needs, the order of the steps in the flowchart can be changed, and some steps can be omitted.

The table data modification method is applied to one or more electronic devices. The electronic device is a device that can automatically perform numerical calculation and/or information processing in accordance with pre-set or stored instructions. Its hardware includes but not Limited to microprocessors, application specific integrated circuits (ASICs), programmable gate arrays (Field-Programmable Gate Arrays, FPGAs), digital processors (Digital Signal Processors, DSPs), embedded devices, etc.

The electronic device may be any electronic product that can interact with a user with a human machine, such as a personal computer, a tablet computer, a smart phone, a personal digital assistant (PDA), a game console, an interactive network television ( Internet Protocol Television, IPTV), smart wearable devices, etc.

The electronic device may also include a network device and/or user equipment. Wherein, the network device includes, but is not limited to, a single network server, a server group composed of multiple network servers, or a cloud composed of a large number of hosts or network servers based on Cloud Computing.

The network where the electronic device is located includes but is not limited to the Internet, wide area network, metropolitan area network, local area network, virtual private network (Virtual Private Network, VPN), etc.

S10: When the table data is received, the table data is reviewed according to configuration conditions.

In at least one embodiment of the present application, the table data may include, but is not limited to, one or a combination of the following:

Employee information data, customer information data, enterprise management data, etc.

In an enterprise, relevant personnel are required to regularly maintain the table data so that the content in the table data can be kept up-to-date, which is convenient for enterprise management.

It is understandable that, in view of the importance of the table data, once the table data is wrong, it will cause some trouble to the user. In order to avoid data errors, the electronic device pre-configures the configuration conditions so as to review the table data.

Specifically, the configuration conditions can be customized, which is not limited in this application.

Further, the review of the table data according to configuration conditions includes, but is not limited to, one or a combination of the following:

(1) The electronic device acquires required items in the form data, and when the required items are empty fields, it is determined that the form data is incorrect.

It is understandable that in the process of filling in the form, in order to ensure the practicality and usability of the form, some items are required, and these items are the required items.

Therefore, when the electronic device detects that the required items are empty fields, it indicates that there are missing items in the form data, and the electronic device can determine that the form data is incomplete, and further determine the form The data is incorrect.

For example: when a user fills in an employee information form, it is obvious that the name and gender are all required items. At this time, when the electronic device detects that the input item corresponding to the employee's name is empty, it can determine the The stated table data is incorrect.

Through the foregoing implementation manners, the electronic device can effectively avoid the phenomenon of missing filling, so as to ensure the integrity and availability of the data in the table data.

(2) The electronic device obtains the configuration data format of each item to be filled in the form data, and when the data format of the data to be filled in the item to be filled is inconsistent with the corresponding configuration data format, it is determined that the form data is incorrect .

It is understandable that in the process of filling in the form, in order to ensure the availability of the data in the form, each data input item has a corresponding data format. Therefore, the electronic device is configured for each item to be filled according to actual usage requirements. The configuration data format.

In view of this, when the data format of the data to be filled in the item to be filled is inconsistent with the corresponding configuration data format, it means that the data of the form data is incorrectly filled, and the electronic device can determine that the form data is incorrect.

For example: when the item to be filled is an ID number, if the user is missing one character when filling in, the electronic device can determine that the form data is incorrect.

Through the foregoing implementation manners, the electronic device can effectively prevent the form data from being easily overlooked and obvious form errors, and improve the accuracy of the form data.

(3) The electronic device obtains historical data, and when the input data of the items to be filled is recorded in the historical data, it is determined that the table data is incorrect.

It is understandable that since the table data is maintained irregularly, duplicate data is likely to occur. In order to avoid data redundancy and save storage space, the electronic device will not upload or save duplicate data.

Therefore, when the input data of a to-be-filled item is recorded in the historical data, it means that the input data of the to-be-filled item has been recorded, and the electronic device can determine that the form data is incorrect.

For example: when the electronic device detects a duplicate ID card A, since the relevant information of the ID card A has been maintained, the electronic device determines that the form data is incorrect.

Through the foregoing implementation manners, the electronic device can effectively avoid repeated data entry, reduce data redundancy, and save storage space at the same time.

S11: When the table data is wrong, obtain error information of the table data.

In at least one embodiment of the present application, after the electronic device reviews the form data, when it is determined that the form data is correct, the electronic device can upload the form information and upload the form The information is saved to the designated database for subsequent use.

In at least one embodiment of the present application, the error information includes, but is not limited to, one or a combination of the following:

Error object, error number, error reason, error path, etc.

S12. Display the error message.

In at least one embodiment of the present application, the electronic device displays the error information so that the user can intuitively see the errors in the data table.

Specifically, the electronic device displaying the error information includes, but is not limited to, one or a combination of the following methods:

(1) The electronic device displays the number of errors in the error message in a pop-up window.

(2) The electronic device makes a special mark on the error object, such as highlighting the form, changing the color of the text, etc.

(3) The electronic device displays the cause of the error in the last column of the table data.

(4) The electronic device displays a link to the wrong path, and when receiving a selection signal for the link, links to the wrong object.

Through the foregoing implementation manners, the electronic device can allow the user to intuitively see the error object, error number, error cause, error path, etc. of the table data, so that the user can modify the table data in a targeted and timely manner, and avoid The data upload error also saves the user's time and energy wasted by comparing the data in the table one by one. It is not only smarter, but also more user-friendly, and the user experience is better.

S13: When a modification instruction of the error information is received, a modification option corresponding to the error information is determined.

In at least one embodiment of the present application, the modification instruction may be triggered by the user, so as to make timely modifications according to the user's needs.

In at least one embodiment of the present application, the electronic device determining the modification option corresponding to the error information includes:

The electronic device obtains the cause of the error from the error information, and obtains the configuration modification mode corresponding to the error cause, and further, the electronic device uses the configuration modification mode as the modification option.

It should be noted that the electronic device is pre-configured with a modification method to determine the cause of the error of the modification option, and the user does not need to modify it manually. As long as the corresponding one of the modification methods is selected, the electronic device can modify the form The data is automatically modified.

For example: when the required gender input method is male/female, but the user fills in MAN/WOMAN, the electronic device will not be able to recognize it. Therefore, the electronic device determines that the form data is filled in incorrectly. Moreover, since the gender input mode is only "male" or "female", that is, the modification mode is fixed, therefore, the electronic device determines the "male" or "female" as the modification option for the user to select .

Through the foregoing implementation manner, the user does not need to manually re-enter data, which simplifies the operation steps and saves modification time.

Preferably, the method further includes:

The electronic device obtains a configuration filling example of each item to be filled, and further, the electronic device displays the configuration filling example.

Through the foregoing implementation manners, the electronic device can provide users with filling examples for reference, thereby effectively avoiding filling errors.

S14, displaying the modification options.

In at least one embodiment of the present application, the electronic device may display the modification option in the form of a selection box, which is not limited in the present application.

Specifically, the selection box may include, but is not limited to: a drop-down selection box, a check box, and the like.

S15: When a confirmation signal for the modification option is received, modify the table data according to the modification option.

In at least one embodiment of the present application, the confirmation signal may include, but is not limited to: a single click signal, a double click signal, a drag signal, and the like.

Through the foregoing implementation manners, the electronic device can effectively improve the human-computer interaction, and at the same time make the modification of the table data more intelligent and humane.

In at least one embodiment of the present application, the method further includes:

When the reason for the error is that the input data of the item to be filled is recorded in the historical data, the electronic device prompts whether to update the item to be filled.

For example: when encountering two employees with duplicate names, if the electronic device directly determines that the data is incorrect, it is likely to cause the omission of employee information. Therefore, the electronic device needs to confirm with the user whether to update first, and then perform the subsequent steps .

Through the foregoing implementation manners, the electronic device can effectively avoid data omissions, while also ensuring that the data in the table data is more complete.

In at least one embodiment of the present application, when a confirmation signal for the modification option is received, modifying the table data according to the modification option includes:

When receiving a selection signal for any modification manner in the configuration modification manner, the electronic device modifies the table data in the arbitrary modification manner.

For example, if the electronic device selects "female" from the configuration modification mode "male" or "female", then "female" is filled in the table data.

Through the foregoing implementation manners, the modification efficiency is effectively improved, thereby saving the time cost of modifying the table data.

In at least one embodiment of the present application, after modifying the table data according to the modification option, the method further includes:

The electronic device uploads the form data, and further, the electronic device displays upload information of the form data.

Specifically, the upload information includes, but is not limited to one or a combination of the following:

The number of new personnel, the number of new departments, etc.

Through the foregoing implementation manners, the electronic device can intuitively display the uploaded information, which facilitates the user to check the information, saves the user's operation time, and improves the enthusiasm for work.

As shown in FIG. 2, it is a functional module diagram of a preferred embodiment of the form data modification device of the present application. The table data modification device 11 includes a review unit 110, an acquisition unit 111, a display unit 112, a determination unit 113, a modification unit 114, a prompt unit 115, an upload unit 116, and an identification unit 117. The module/unit referred to in this application refers to a series of computer-readable instruction segments that can be executed by the processor 13 and can complete fixed functions, and are stored in the memory 12. In this embodiment, the functions of each module/unit will be described in detail in subsequent embodiments.

When the form data is received, the review unit 110 reviews the form data according to the configuration conditions.

In the prior art solution, after receiving the form data uploaded by the user, in order to avoid the content in the form from formatting and other formal errors, it is also necessary for the staff to perform manual investigation, and when the error is confirmed, the cause of the error is manually added. , Delete, modify, query and other operations, the manpower consumption is high, and it is easy to miss, do not see, etc., the accuracy of the investigation and the efficiency of the investigation need to be improved.

In view of the above situation, this application can provide an intelligent review method for data tables, which effectively saves labor costs, and the operation steps are more user-friendly.

It is understandable that, in view of the importance of the table data, once the table data is wrong, it will cause some trouble to the user. In order to avoid data errors, the review unit 110 configures the configuration conditions in advance to review the table data.

Further, the auditing unit 110 auditing the table data according to configuration conditions includes, but is not limited to, one or a combination of the following:

(1) The review unit 110 obtains required items in the form data, and when the required items are empty fields, it is determined that the form data is incorrect.

Therefore, when the verification unit 110 detects that the required items are empty fields, it indicates that there are missing items in the form data, and the verification unit 110 can determine that the form data is incomplete and further determine that The stated table data is incorrect.

For example: when a user fills in an employee information form, it is obvious that the name and gender are all required items. At this time, when the review unit 110 detects that the input item corresponding to the employee name is an empty field, it can be determined The table data is incorrect.

Through the above-mentioned implementation manners, the verification unit 110 can effectively avoid missing filling, so as to ensure the integrity and availability of the data in the table data.

(2) The review unit 110 obtains the configuration data format of each item to be filled in the form data, and when the data format of the data to be filled in the item to be filled is inconsistent with the corresponding configuration data format, it is determined that the form data has error.

It is understandable that in the process of filling in the form, in order to ensure the availability of the data in the form, each data input item has a corresponding data format. Therefore, the review unit 110 provides a corresponding data format for each item to be filled according to actual usage requirements. Configure the configuration data format.

In view of this, when the data format of the data to be filled is inconsistent with the corresponding configuration data format, it means that the data of the form data is incorrectly filled, and the verification unit 110 can determine that the form data is incorrect.

For example: when the item to be filled is an ID number, if the user is missing one character when filling in, the verification unit 110 can determine that the form data is incorrect.

Through the above-mentioned implementation manners, the review unit 110 can effectively avoid the easily overlooked and obvious form errors in the table data, and improve the accuracy of the table data.

(3) The review unit 110 obtains historical data, and when the input data of the items to be filled is recorded in the historical data, it is determined that the table data is incorrect.

It is understandable that since the table data is not regularly maintained, duplicate data is likely to occur. In order to avoid data redundancy and save storage space at the same time, the audit unit 110 will upload and update non-duplicated data. save.

Therefore, when the input data of a to-be-filled item is recorded in the historical data, it means that the input data of the to-be-filled item has been recorded, and the verification unit 110 can determine that the form data is incorrect. For example: when the verification unit 110 detects a duplicate ID card A, since the relevant information of the ID card A has been maintained, the verification unit 110 determines that the table data is incorrect.

Through the foregoing implementation manners, the review unit 110 can effectively avoid repeated data entry, reduce data redundancy, and save storage space at the same time.

When the table data is incorrect, the obtaining unit 111 obtains error information of the table data.

In at least one embodiment of the present application, after reviewing the form data, when it is determined that the form data is correct, the form information can be uploaded, and the form information can be saved to a designated database for use Follow-up use.

Error object, error number, error reason, error path, etc.

The display unit 112 displays the error message.

In at least one embodiment of the present application, the display unit 112 displays the error information so that the user can intuitively see the errors in the data table.

Specifically, the error information displayed by the display unit 112 includes, but is not limited to, one or a combination of the following methods:

(1) The display unit 112 displays the number of errors in the error message in a pop-up window.

(2) The display unit 112 makes a special mark for the error object, such as highlighting the table, changing the color of the text, and so on.

(3) The display unit 112 displays the cause of the error in the last column of the table data.

(4) The display unit 112 displays the link to the error path, and when a selection signal for the link is received, links to the error object.

Through the foregoing implementation manners, the display unit 112 can allow the user to intuitively see the error object, the number of errors, the cause of the error, the error path, etc. of the table data, so that the user can modify the table data in a targeted and timely manner. To avoid data upload errors, it also saves the time and energy for users to compare the data in the table one by one. It is not only smarter, but also more user-friendly, and the user experience is better.

When a modification instruction of the error information is received, the determining unit 113 determines the modification option corresponding to the error information.

In at least one embodiment of the present application, the determining unit 113 determines that the modification option corresponding to the error information includes:

The determining unit 113 obtains the cause of the error from the error information, and obtains the configuration modification mode corresponding to the error cause. Further, the determining unit 113 uses the configuration modification mode as the modification option.

It should be noted that the determining unit 113 has pre-configured a modification method for determining the error cause of the modification option, and the user does not need to modify it manually. As long as the corresponding modification method in the modification method is selected, the table data can be automatically performed. modify.

For example, when the required gender input method is male/female, but the user fills in MAN/WOMAN, the recognition unit 117 will not be able to recognize it. Therefore, the verification unit 110 determines that the form data is incorrectly filled. Moreover, since the gender input mode is only "male" or "female", that is, the modification mode is fixed, therefore, the determining unit 113 determines the "male" or "female" as the modification option for the user select.

Preferably, the method further includes:

The obtaining unit 111 obtains a configuration filling example of each item to be filled, and further, the display unit 112 displays the configuration filling example.

Through the foregoing implementation manners, it is possible to provide users with filling examples for reference, thereby effectively avoiding filling errors.

The display unit 112 displays the modification options.

In at least one embodiment of the present application, the display unit 112 may display the modification options in the form of a selection box, which is not limited in the present application.

When receiving a confirmation signal for the modification option, the modification unit 114 modifies the table data according to the modification option.

Through the foregoing implementation manners, the modification unit 114 can effectively improve the human-computer interaction, and at the same time make the modification of the table data more intelligent and humane.

When the reason for the error is that the input data of the item to be filled is recorded in the historical data, the prompt unit 115 prompts whether to update the item to be filled.

For example: when encountering two employees with duplicate names, if you directly judge that the data is incorrect, it is likely that the employee information will be missed. Therefore, you need to confirm with the user whether to update before performing the subsequent steps.

Through the foregoing implementation manners, data omission can be effectively avoided, and at the same time, the data in the table data can be more complete.

In at least one embodiment of the present application, when a confirmation signal for the modification option is received, the modification unit 114 modifying the table data according to the modification option includes:

When receiving a selection signal for any modification manner in the configuration modification manner, the modification unit 114 modifies the table data in the arbitrary modification manner.

For example, if the modification unit 114 selects "female" from the configuration modification mode "male" or "female", then "female" is filled in the table data.

In at least one embodiment of the present application, after the modification unit 114 modifies the table data according to the modification options, the method further includes:

The upload unit 116 uploads the form data, and further, the display unit 112 displays upload information of the form data.

The number of new personnel, the number of new departments, etc.

Through the foregoing implementation manners, the upload information can be displayed intuitively, which facilitates the user to check the information, saves the user's operation time, and improves the enthusiasm for work.

As shown in FIG. 3, it is a schematic structural diagram of an electronic device according to a preferred embodiment of the method for modifying table data in this application.

The electronic device 1 is a device that can automatically perform numerical calculation and/or information processing according to pre-set or stored instructions. Its hardware includes, but is not limited to, a microprocessor, an Application Specific Integrated Circuit (ASIC) ), programmable gate array (Field-Programmable Gate Array, FPGA), digital processor (Digital Signal Processor, DSP), embedded equipment, etc.

The electronic device 1 can also be, but is not limited to, any electronic product that can interact with the user through a keyboard, a mouse, a remote control, a touch panel, or a voice control device, for example, a personal computer, a tablet computer, or a smart phone. , Personal Digital Assistant (PDA), game consoles, interactive network TV (Internet Protocol Television, IPTV), smart wearable devices, etc.

The electronic device 1 may also be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server.

The network where the electronic device 1 is located includes, but is not limited to, the Internet, a wide area network, a metropolitan area network, a local area network, a virtual private network (Virtual Private Network, VPN), etc.

In an embodiment of the present application, the electronic device 1 includes, but is not limited to, a memory 12, a processor 13, and computer readable instructions stored in the memory 12 and running on the processor 13 , Such as table data modification procedures.

Those skilled in the art can understand that the schematic diagram is only an example of the electronic device 1 and does not constitute a limitation on the electronic device 1. It may include more or less components than those shown in the figure, or a combination of certain components, or different components. Components, for example, the electronic device 1 may also include input and output devices, network access devices, buses, and so on.

The processor 13 may be a central processing unit (Central Processing Unit, CPU), other general-purpose processors, digital signal processors (Digital Signal Processors, DSP), application specific integrated circuits (ASICs), Ready-made programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor, etc. The processor 13 is the computing core and control center of the electronic device 1 and connects the entire electronic device with various interfaces and lines. Each part of 1, and executes the operating system of the electronic device 1, and various installed applications, program codes, etc.

The processor 13 executes the operating system of the electronic device 1 and various installed applications. The processor 13 executes the application program to implement the steps in the foregoing embodiment of the method for modifying table data, such as steps S10, S11, S12, S13, S14, and S15 shown in FIG. 1.

Alternatively, when the processor 13 executes the computer-readable instructions, the functions of the modules/units in the foregoing device embodiments are implemented, for example: when the table data is received, the table data is reviewed according to the configuration conditions; when the When the table data is wrong, obtain the error information of the table data; display the error information; when a modification instruction of the error information is received, determine the modification option corresponding to the error information; display the modification option; when When receiving the confirmation signal for the modification option, modify the table data according to the modification option.

Exemplarily, the computer-readable instructions may be divided into one or more modules/units, and the one or more modules/units are stored in the memory 12 and executed by the processor 13 to Complete this application. The one or more modules/units may be a series of computer-readable instruction segments capable of completing specific functions, and the instruction segments are used to describe the execution process of the computer-readable instructions in the electronic device 1. For example, the computer-readable instructions may be divided into the review unit 110, the acquisition unit 111, the display unit 112, the determination unit 113, the modification unit 114, the prompt unit 115, the upload unit 116, and the recognition unit 117.

The memory 12 may be used to store the computer-readable instructions and/or modules. The processor 13 executes or executes the computer-readable instructions and/or modules stored in the memory 12 and calls the computer-readable instructions and/or modules stored in the memory 12 The data inside realizes various functions of the electronic device 1. The memory 12 may mainly include a storage program area and a storage data area. The storage program area may store an operating system, an application program required by at least one function (such as a sound playback function, an image playback function, etc.), etc.; the storage data area may Stores data (such as audio data) created according to the use of electronic devices, etc. In addition, the memory 12 may include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a Secure Digital (SD) card, a flash memory card (Flash Card), At least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device.

The memory 12 may be an external memory and/or an internal memory of the electronic device 1. Further, the memory 12 may be a circuit with a storage function without a physical form in an integrated circuit. Alternatively, the memory 12 may also be a memory in physical form, such as a memory stick, a TF card (Trans-flash Card), and so on.

If the integrated module/unit of the electronic device 1 is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a non-volatile computer readable storage medium. Based on this understanding, this application implements all or part of the processes in the above-mentioned embodiments and methods, and can also be completed by instructing relevant hardware through computer-readable instructions. The computer-readable instructions can be stored in a non-volatile memory. In the read storage medium, when the computer-readable instructions are executed by the processor, the steps of the foregoing method embodiments can be implemented.

Wherein, the computer-readable instructions may be in the form of source code, object code, executable file, or some intermediate forms, etc. The non-volatile computer-readable medium may include: any entity or device capable of carrying the computer-readable instruction code, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM , Read-Only Memory).

With reference to FIG. 1, the memory 12 in the electronic device 1 stores multiple instructions to implement a form data modification method, and the processor 13 can execute the multiple instructions to realize: when form data is received, Review the table data according to the configuration conditions; when the table data is wrong, obtain the error information of the table data; display the error information; when a modification instruction of the error information is received, determine the error information The corresponding modification option; the modification option is displayed; when a confirmation signal for the modification option is received, the table data is modified according to the modification option.

Specifically, for the specific implementation method of the processor 13 for the foregoing instructions, reference may be made to the description of the relevant steps in the embodiment corresponding to FIG. 1, which is not repeated here.

In the several embodiments provided in this application, it should be understood that the disclosed system, device, and method may be implemented in other ways. For example, the device embodiments described above are only illustrative. For example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.

The modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the objectives of the solutions of the embodiments.

In addition, the functional modules in the various embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units may be integrated into one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of hardware plus software functional modules.

For those skilled in the art, it is obvious that the present application is not limited to the details of the foregoing exemplary embodiments, and the present application can be implemented in other specific forms without departing from the spirit or basic characteristics of the application.

Therefore, no matter from which point of view, the embodiments should be regarded as exemplary and non-limiting. The scope of this application is defined by the appended claims rather than the above description, and therefore it is intended to fall into the claims. All changes in the meaning and scope of the equivalent elements of are included in this application. Any associated diagram marks in the claims should not be regarded as limiting the claims involved.

In addition, it is obvious that the word "including" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices stated in the system claims can also be implemented by one unit or device through software or hardware. The second class words are used to indicate names, and do not indicate any specific order.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the application and not to limit them. Although the application has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the application can be Modifications or equivalent replacements are made without departing from the spirit and scope of the technical solution of this application.

Claims

A method for modifying table data, characterized in that the method includes:

When receiving the form data, review the form data according to the configuration conditions;

When the table data is incorrect, obtaining error information of the table data;

Display the error message;

When receiving a modification instruction of the error message, determine the modification option corresponding to the error message;

Display the modification options;

When a confirmation signal for the modification option is received, the table data is modified according to the modification option.
The method for modifying table data according to claim 1, wherein the review of the table data according to configuration conditions comprises one or a combination of the following:

Obtain required items in the form data, and when the required items are empty fields, determine that the form data is incorrect; and/or

Obtain the configuration data format of each item to be filled in the table data, and determine that the table data is incorrect when the data format of the data to be filled in the item to be filled is inconsistent with the corresponding configuration data format; and/or

Obtain historical data, and when the input data of the item to be filled is recorded in the historical data, it is determined that the table data is incorrect.
The method for modifying table data according to claim 1, wherein said determining the modification option corresponding to said error message comprises:

Obtain the cause of the error from the error message;

Obtain the configuration modification mode corresponding to the error cause;

The configuration modification mode is used as the modification option.
3. The table data modification method according to claim 2, wherein the method further comprises:

Obtain the configuration filling example of each item to be filled;

Show the configuration example.
3. The table data modification method according to claim 2, wherein the method further comprises:

When the reason for the error is that the input data of the item to be filled is recorded in the historical data, it is prompted whether to update the item to be filled.
5. The method for modifying table data according to claim 3, wherein when a confirmation signal for the modified option is received, modifying the table data according to the modified option comprises:

When receiving a selection signal for any modification manner in the configuration modification manner, modify the table data in the arbitrary modification manner.
5. The method for modifying table data according to claim 1, wherein after modifying the table data according to the modification options, the method further comprises:

Upload the table data;

Display the upload information of the table data.
A table data modification device, characterized in that the device includes:

The review unit is used to review the form data according to the configuration conditions when the form data is received;

The obtaining unit is configured to obtain error information of the table data when the table data is incorrect;

A display unit for displaying the error message;

A determining unit, configured to determine a modification option corresponding to the error information when a modification instruction of the error information is received;

The display unit is also used to display the modification options;

The modification unit is configured to modify the table data according to the modification option when a confirmation signal for the modification option is received.
An electronic device, characterized in that, the electronic device includes:

The memory stores at least one computer readable instruction; and

The processor executes the at least one computer-readable instruction to implement the following steps:

When receiving the form data, review the form data according to the configuration conditions;

When the table data is incorrect, obtaining error information of the table data;

Display the error message;

When receiving a modification instruction of the error message, determine the modification option corresponding to the error message;

Display the modification options;

When a confirmation signal for the modification option is received, the table data is modified according to the modification option.
9. The electronic device of claim 9, wherein the processor executes at least one computer-readable instruction to implement the review of the table data according to configuration conditions, including one or a combination of the following methods:

Obtain required items in the form data, and when the required items are empty fields, determine that the form data is incorrect; and/or

Obtain the configuration data format of each item to be filled in the table data, and determine that the table data is incorrect when the data format of the data to be filled in the item to be filled is inconsistent with the corresponding configuration data format; and/or

Obtain historical data, and when the input data of the item to be filled is recorded in the historical data, it is determined that the table data is incorrect.
9. The electronic device according to claim 9, wherein when the processor executes at least one computer-readable instruction to implement the determination of the modification option corresponding to the error message, the method comprises the following steps:

Obtain the cause of the error from the error message;

Obtain the configuration modification mode corresponding to the error cause;

The configuration modification mode is used as the modification option.
The electronic device of claim 10, wherein the processor executes at least one computer-readable instruction to further implement the following steps:

Obtain the configuration filling example of each item to be filled;

Show the configuration example.
The electronic device of claim 10, wherein the processor executes at least one computer-readable instruction to further implement the following steps:

When the reason for the error is that the input data of the item to be filled is recorded in the historical data, it is prompted whether to update the item to be filled.
The electronic device of claim 11, wherein the processor executes at least one computer-readable instruction to implement the modification of the modification option according to the modification option when the confirmation signal for the modification option is received. When tabulating data, include the following steps:

When receiving a selection signal for any modification manner in the configuration modification manner, modify the table data in the arbitrary modification manner.
A non-volatile readable storage medium, characterized in that: the non-volatile readable storage medium stores at least one computer readable instruction, and the at least one computer readable instruction is used by a processor in an electronic device Perform the following steps:

When receiving the form data, review the form data according to the configuration conditions;

When the table data is incorrect, obtaining error information of the table data;

Display the error message;

When receiving a modification instruction of the error message, determine the modification option corresponding to the error message;

Display the modification options;

When a confirmation signal for the modification option is received, the table data is modified according to the modification option.
The storage medium of claim 15, wherein the at least one computer-readable instruction is executed by the processor to implement the review of the table data according to configuration conditions, including one or a combination of the following methods: :

Obtain required items in the form data, and when the required items are empty fields, determine that the form data is incorrect; and/or

Obtain the configuration data format of each item to be filled in the table data, and determine that the table data is incorrect when the data format of the data to be filled in the item to be filled is inconsistent with the corresponding configuration data format; and/or

Obtain historical data, and when the input data of the item to be filled is recorded in the historical data, it is determined that the table data is incorrect.
15. The storage medium according to claim 15, wherein when the at least one computer-readable instruction is executed by a processor to implement the determination of the modification option corresponding to the error message, the method comprises the following steps:

Obtain the cause of the error from the error message;

Obtain the configuration modification mode corresponding to the error cause;

The configuration modification mode is used as the modification option.
15. The storage medium of claim 16, wherein the at least one computer readable instruction is executed by the processor to further implement the following steps:

Obtain the configuration filling example of each item to be filled;

Show the configuration example.
15. The storage medium of claim 16, wherein the at least one computer readable instruction is executed by the processor to further implement the following steps:

When the reason for the error is that the input data of the item to be filled is recorded in the historical data, it is prompted whether to update the item to be filled.
The storage medium according to claim 17, wherein the at least one computer-readable instruction is executed by the processor to implement the modification of the modification option according to the modification option when the confirmation signal for the modification option is received. When describing tabular data, include the following steps:

When receiving a selection signal for any modification manner in the configuration modification manner, modify the table data in the arbitrary modification manner.