A data processing method, device and medium supporting interaction

Abstract

The present application discloses a data processing method, device and medium that supports interaction, which is used to solve the technical problems that the process of the existing data import system is too single, and the user cannot perform any interactive operations in the process of the data import system. The method includes: obtaining file data, business type and import method; based on the business type, determining the verification algorithm corresponding to the file data; according to the verification algorithm, determining the verification results corresponding to each sub-data in the file data, so as to divide each sub-data into qualified data and illegal data according to the verification results; feeding back the illegal data to the front-end modification page to obtain the modified data corresponding to the illegal data; according to the import method, determining the order of importing qualified data and modified data into the system. The present application enables operators to flexibly participate in the process of the file data import system through the above method; and avoids the problem that valid information cannot be reused due to the overly single process.

Description

Technical Field

[0001] The present application relates to the field of data interaction technology, and in particular to a data processing method, device and medium supporting interaction. Background Art

[0002] Data import usually involves reading data from a file according to certain rules and storing the read data in a database (or for other business use).

[0003] In the existing technology, when an exception occurs in the process of importing data into the system, the data file can usually only be modified according to page prompts or log records, and the re-import after the modification can only be regarded as a new import process, and some data features that have been learned in the previous round of operations cannot be retained.

[0004] However, the prior art has at least the following problems: the process of importing data is too simple, and since each import is an independent transaction, the user cannot perform any interactive operations regardless of whether the import is successful, so that the valid information of the previous round of import operations is not reused, and there are major defects in performance and user experience. Summary of the invention

[0005] The embodiments of the present application provide a data processing method, device and medium that support interaction, so as to solve the technical problems that the process of the existing data import system is too single and the user cannot perform any interactive operations during the process of importing data into the system.

[0006] In a first aspect, an embodiment of the present application provides a data processing method that supports interaction, the method comprising: obtaining file data, a business type, and an import method; wherein the file data includes a plurality of sub-data; based on the business type, determining a verification algorithm corresponding to the file data; according to the verification algorithm, determining a verification result corresponding to each sub-data in the file data, so as to divide each sub-data into qualified data and illegal data according to the verification result; feeding back illegal data to a front-end modification page to obtain modified data corresponding to the illegal data; and according to the import method, determining the order in which qualified data and modified data are imported into the system.

[0007] The data processing method provided in the embodiment of the present application realizes rapid matching of file data with verification algorithms by pre-acquiring business types; realizes flexible adjustment of file data import system methods by pre-acquiring import methods; realizes effective acquisition of qualified data and screening out of illegal data by determining the verification results of each sub-data; realizes rapid acquisition of modified data corresponding to the illegal data by feeding back illegal data to the front-end modification page, and since only the modified data needs to be acquired, re-reading of qualified data is avoided, thereby realizing effective reuse of qualified data.

[0008] In one implementation of the present application, a business-algorithm database is preset; wherein the business-algorithm database stores the correspondence between business types and verification algorithms; after obtaining file data, business types, and import methods, the method further includes: when it is detected that the business type does not exist in the business-algorithm database, a prompt message is generated that the business type cannot match the verification algorithm, and a pop-up box is generated to display the prompt message.

[0009] In one implementation of the present application, when it is detected that the amount of illegal data is greater than a preset threshold, a request to update the file instruction is generated and displayed on the front-end withdrawal frame; based on the front-end withdrawal frame, when it is determined that the update file instruction is triggered, the process of importing file data into the system is terminated; based on the front-end withdrawal frame, when the cancel update file instruction is triggered, the illegal data is fed back to the front-end modification page to obtain the modification data corresponding to the illegal data.

[0010] In the data processing method provided by the embodiment of the present application, since the operator needs to manually input the modified data, in the present application, the server predicts whether the operator needs to spend a lot of time modifying the data by detecting the number of illegal data. When it is detected that the number of illegal data is greater than the preset threshold, the server automatically determines that the operator will consume too much modification time. At this time, by sending a request to update the file data instruction to the operator, the operator is allowed to determine again whether the file data instruction needs to be re-uploaded, and based on the operator's judgment, it is determined whether to end the import of the file data this time. The operator is enabled to flexibly participate in the file data import process.

[0011] In one implementation of the present application, the front-end modification page includes any one or more of the following: a direct modification key, a re-upload key, and an ignore key; the illegal data is fed back to the front-end modification page to obtain the modification data corresponding to the illegal data, specifically including: obtaining a trigger instruction to trigger any one of the following: a direct modification key, a re-upload key, and an ignore key; when the direct modification key is triggered, an illegal data modification box pops up to obtain the modification data corresponding to the illegal data; when the re-upload key is triggered, a re-upload page pops up to obtain the file data again, and then read the modification data corresponding to the illegal data; when the ignore key is triggered, the illegal data is determined to be modification data.

[0012] The data processing method provided in the embodiment of the present application enables the operator to flexibly select a method of uploading and modifying data according to illegal data by presetting a direct modification key, a re-upload key, and an ignore key.

[0013] In one implementation of the present application, the import method is any one of the following: a synchronous operation method, an asynchronous operation method; according to the import method, the process of importing qualified data and modified data into the system is determined, specifically including: when the import method is a synchronous import method, obtaining the modified data, and importing the qualified data and modified data into the system at the same time; when the import method is an asynchronous import method, after determining the verification results corresponding to each sub-data, importing the qualified data into the system; obtaining the modified data, and importing the modified data into the system.

[0014] In one implementation of the present application, based on the front-end modification page, a first processing algorithm corresponding to qualified data is obtained, and a second processing algorithm corresponding to modified data is obtained; and qualified data and modified data are imported into the system according to the first processing algorithm and the second processing algorithm.

[0015] In one implementation of the present application, a default processing algorithm corresponding to the qualified data and the modified data is obtained; and the qualified data and the modified data are imported into the system according to the default processing algorithm.

[0016] In one implementation of the present application, the verification result includes any one of the following: a qualified result and an illegal result; wherein, when the verification result of the sub-data is a qualified result, the sub-data is predicted to be qualified data; when the verification result of the sub-data is an illegal result, the sub-data is predicted to be illegal data.

[0017] In a second aspect, an embodiment of the present application provides a data processing device that supports interaction, the device comprising: a processor; and a memory on which executable code is stored, and when the executable code is executed, the processor executes any one of the above-mentioned data processing methods that support interaction.

[0018] In a third aspect, an embodiment of the present application provides a non-volatile computer storage medium on which computer instructions are stored, and when the computer instructions are executed, the above-mentioned data processing method supporting interaction is implemented. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0020] Figure 1 A flow chart of a data processing method supporting interaction provided in an embodiment of the present application;

[0021] Figure 2 A schematic diagram of the internal structure of a data processing device supporting interaction provided in an embodiment of the present application. DETAILED DESCRIPTION

[0022] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in combination with the specific embodiments of the present application and the corresponding drawings. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present application.

[0023] The embodiments of the present application provide a data processing method, device and medium that supports interaction, by obtaining file data, business type and import method; matching of file data with verification algorithm is achieved. The verification results of each sub-data in the file data are verified one by one by the verification algorithm, and illegal data in the file data is effectively screened out; the illegal data is displayed on the front-end modification page, so that the operator can determine the key (direct modification key, re-upload key and ignore key) that triggers the trigger instruction according to the illegal data. Then, based on the front-end modification page, the modification data corresponding to the illegal data is obtained. By pre-specifying the import method, a variety of file data can be imported into the system.

[0024] In addition, a data processing method supporting interaction is proposed in an embodiment of the present application, and its execution subject is a server.

[0025] The technical solution proposed in the embodiments of the present application is described in detail below with reference to the accompanying drawings.

[0026] Figure 1 A data processing method supporting interaction is provided in an embodiment of the present application. Figure 1 As shown, the data processing method provided in the embodiment of the present application mainly includes the following steps:

[0027] Step 101: Obtain file data, business type, and import method.

[0028] It should be noted that file data is a general term for data that needs to be uploaded to the system. The types of file data are diverse. For example, the types of file data can be Excel tables, TXT documents, and Word documents. Furthermore, file data is composed of several sub-data. In Excel tables, sub-data can be represented by a column of data or a row of data, in TXT documents, sub-data can be represented by a row of data, and in Word documents, sub-data can be represented by a segment of data (with sub-data separated by carriage returns). Business type is used to indicate the type of file data currently being uploaded, such as financial type, performance type, and personnel information type. Import mode is used to pre-set the mode of importing the file data into the system. The import mode includes at least synchronous import mode and asynchronous import mode. For specific steps, see step 105.

[0029] Specifically, the operator clicks the preset upload button so that the server obtains the upload instruction and pops up the upload page. Based on the operator's operation, the file data is imported on the upload page, the business type corresponding to the file data is input or selected, and the import method corresponding to the file data is input or selected. It should be noted that the business type and import method can be input by the operator himself or selected. Specifically, the server pre-stores all business types and import methods. The operator can directly click the selection button on the right side of the business type input box to select the business type corresponding to the file data; or directly select the selection button on the right side of the import method input box to select the import method corresponding to the file data. Furthermore, there is an "OK" button on the upload page. When the operator triggers the "OK" button, the upload page is automatically closed, the server obtains the start instruction, and the server switches the page to the front-end modification page to facilitate the subsequent modification of illegal data.

[0030] Step 102: Based on the business type, determine a verification algorithm corresponding to the file data.

[0031] It should be noted that the verification algorithm is used to verify whether the sub-data uploaded by the file data is qualified. For example, the content of the verification algorithm can be: whether there is a space in the current column / row, and / or whether there is a "#REF!" symbol in the current column / row, and / or whether there are two paragraphs connected by carriage returns in the current document; and the display and / or application form of the verification algorithm can be a programming file composed of C, C++, Java and other codes. In addition, there is a mapping relationship between the business type and the verification algorithm; specifically, the mapping relationship can be that one verification algorithm corresponds to multiple business types.

[0032] Specifically, the server pre-stores a business-algorithm database, wherein the business-algorithm database stores the correspondence (mapping) relationship between business types and verification algorithms; after the server obtains the file data and the business type, the business type is input into the pre-stored business-algorithm database to obtain the verification algorithm for processing the file data; it should be noted that there is a situation where the verification algorithm is lost or the relevant programmer fails to upload the verification algorithm in time. At this time, the business type cannot find the verification algorithm corresponding to the uploaded file data in the business-algorithm database; then the server will generate a prompt message that the verification algorithm cannot be matched by the business type, and display the prompt message to the operator in the form of a pop-up box.

[0033] Step 103: Determine the verification result corresponding to each sub-data in the file data according to the verification algorithm, so as to classify each sub-data into qualified data and illegal data according to the verification result.

[0034] It should be noted that the verification results can be divided into qualified results and illegal results; further, when the server detects that the sub-data complies with the verification algorithm, the server determines that the verification result of the sub-data is a qualified result, and predicts that the sub-data is qualified data; and when the server detects that the sub-data does not comply with the verification algorithm, the server determines that the verification result of the sub-data is an illegal result, and predicts that the sub-data is illegal data.

[0035] Specifically, the server inputs each sub-data in the file data into the verification algorithm, and automatically detects whether the sub-data meets the specified conditions of the verification algorithm; the server sets the sub-data that meets the verification algorithm as qualified data; and sets the sub-data that does not meet the verification algorithm as illegal data; so that the server obtains qualified data and filters out illegal data.

[0036] In addition, it should be noted that when the server detects that the amount of illegal data is greater than a preset threshold, the server predicts that the operator may have uploaded incorrect file data; wherein, the preset threshold can be any feasible value, which can be obtained by a technician in this field through multiple experiments. At this time, the server will automatically generate a request to update the file instruction, and display the front-end withdrawal box to the operator in the form of a pop-up box; it should be noted that the front-end withdrawal box has an "OK" button and a "Cancel" button. When the operator triggers the "OK" button, the server automatically generates a confirmation update file instruction, and the server determines that the file data currently to be imported into the system is incorrect data, and will terminate the process of importing the file data into the system. When the operator triggers the "Cancel" button, the server automatically generates a cancellation update file instruction, and the server determines that the file data currently to be imported into the system is correct data, and then the server displays the predicted illegal data on the front-end modification page.

[0037] Step 104: Feedback the illegal data to the front-end modification page to obtain modification data corresponding to the illegal data.

[0038] It should be noted that, as explained in step 101, after the server obtains the file data, business type and import method through the upload page, the server will automatically switch the page to the front-end modification page; after the server detects illegal data in step 103, the illegal data will be directly displayed on the front-end modification page for the operator to check and analyze. And the modified data is the data modified by the operator according to the illegal data.

[0039] Specifically, the server screens out illegal data that may have problems through a verification algorithm in the background, and displays them on the front-end modification page in chronological order; it should be further explained that each illegal data displayed on the front-end modification page is at least provided with a direct modification key, a re-upload key, and an ignore key; when the operator determines that there is really a problem with the illegal data, the operator can modify the illegal data through the direct modification key or the re-upload key. Among them, when the operator triggers the direct modification key, the server will pop up an illegal data modification box, and the server can obtain the modification data corresponding to the illegal data through the illegal data modification box; when the operator triggers the re-upload key, the server will pop up a preset re-upload page to obtain the file data again, and the server reads the file data to obtain the modification data corresponding to the illegal data. In addition, there is a situation where the illegal data is actually qualified data, and the ignore key can be triggered based on the operator's operation. The server receives the trigger instruction generated by the ignore key and sets the illegal data as the modification data.

[0040] Step 105: Determine qualified data and modify the order of importing data into the system according to the import method.

[0041] It should be noted that the import method can be divided into at least a synchronous import method and an asynchronous import method; specifically, after selecting the synchronous import method, the service needs to wait for the modification data fed back by the front-end modification page, and then import the qualified data and the modification data into the system at the same time; and after selecting the asynchronous import method, the server does not need to wait for the modification data fed back by the front-end modification page. After determining the qualified data, the server can directly import the qualified data into the system first, and then wait for the modification data fed back by the front-end modification page, and then import the modification data into the system.

[0042] More specifically, if the synchronous import method is selected in advance, after the server obtains the modified data corresponding to the illegal data on the front-end modification page, a processing algorithm selection page will automatically pop up. Based on the user's operation, the server obtains the first processing algorithm for importing qualified data into the system, and obtains the second processing algorithm for importing modified data into the system; it should be noted that the first processing algorithm is used to process qualified data, and the second processing algorithm is used to process modified data. For example, the first processing algorithm can be an algorithm that limits the expression form of qualified data, and the second processing algorithm can be an algorithm that limits the expression form of modified data. It should be noted that the server can pre-store several first processing algorithms and several second processing algorithms; and, in this embodiment, the operator can freely select the specific first processing algorithm corresponding to the qualified data and the specific second processing algorithm corresponding to the modified data before importing the system.

[0043] If the asynchronous mode is selected in advance, a default processing algorithm is preset in the asynchronous mode. After the server obtains qualified data, the server directly obtains the default processing algorithm, imports the qualified data into the default processing algorithm in the background, and then imports the qualified data processed by the default processing algorithm into the system; waits for the modified data feedback from the front-end modification page, and after the server obtains the modified data, imports the modified data into the default processing algorithm, and then imports the processed modified data into the system.

[0044] In addition, the embodiment of the present application also provides a data processing device that supports interaction, such as Figure 2 As shown, the device includes a processor and a memory, on which executable instructions are stored. When the executable instructions are executed, a data processing method supporting interaction as described above is implemented. Specifically, the server sends an execution instruction to the memory through a bus, and when the memory receives the execution instruction, it sends an execution signal to the processor through the bus to activate the processor.

[0045] It should be noted that the processor is used to obtain file data, business type and import method; wherein the file data contains several sub-data; based on the business type, determine the verification algorithm corresponding to the file data; according to the verification algorithm, determine the verification results corresponding to each sub-data in the file data, and divide each sub-data into qualified data and illegal data according to the verification results; feedback the illegal data to the front-end modification page to obtain the modified data corresponding to the illegal data; according to the import method, determine the process of importing qualified data and modified data into the system.

[0046] In addition, an embodiment of the present application further provides a non-volatile computer storage medium on which executable instructions are stored. When the executable instructions are executed, a rotation method of a four-wheel drive four-turn robot provided in the above embodiment is implemented.

[0047] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0048] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0049] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A data processing method supporting interaction, characterized in that: The method comprises: Obtaining file data, business type and import method; wherein the file data includes several sub-data, and the import method includes any one of the following: synchronous import method and asynchronous import method; Based on the business type, determining a verification algorithm corresponding to the file data; Determine, according to the verification algorithm, a verification result corresponding to each sub-data in the file data, so as to classify each sub-data into qualified data and illegal data according to the verification result; Feedback the illegal data to the front-end modification page to obtain modification data corresponding to the illegal data; Determining the order of importing the qualified data and the modified data into the system according to the import mode includes: When the import mode is a synchronous import mode, the modified data fed back by the front-end modification page is obtained, and the qualified data and the modified data are simultaneously imported into the system, including: based on the front-end modification page, obtaining a first processing algorithm corresponding to the qualified data, and obtaining a second processing algorithm corresponding to the modified data, and according to the first processing algorithm and the second processing algorithm, simultaneously importing the qualified data and the modified data into the system; When the import method is an asynchronous import method, after determining the verification results corresponding to each sub-data, importing the qualified data into the system, obtaining the modification data fed back by the front-end modification page, and importing the modification data into the system, including: based on the asynchronous import method, obtaining the qualified data and the default processing algorithm corresponding to the modification data, importing the qualified data into the system according to the default processing algorithm, and after receiving the modification data from the front-end modification page, importing the modification data into the system according to the default processing algorithm.

2. The interactive data processing method according to claim 1, characterized in that: After obtaining the file data, the business type and the import method, the method further includes: When it is detected that the business type does not exist in the preset business-algorithm database, a prompt message is generated that the business type cannot match the verification algorithm, and a pop-up box is generated to display the prompt message; wherein the preset business-algorithm database stores the correspondence between the business type and the verification algorithm.

3. The interactive data processing method according to claim 1, characterized in that: After determining the verification result corresponding to each sub-data in the file data according to the verification algorithm, and dividing each sub-data into qualified data and illegal data according to the verification result, the method further includes: When it is detected that the amount of illegal data is greater than a preset threshold, a request to update the file instruction is generated and displayed in a pop-up front-end revocation box; wherein the front-end revocation box at least includes a confirmation update file instruction and a cancellation update file instruction; When the instruction to update the file is triggered, the process of importing the file data into the system is terminated; When the cancel file update instruction is triggered, the illegal data is fed back to the front-end modification page to obtain the modification data corresponding to the illegal data.

4. The interactive data processing method according to claim 1, characterized in that: The front-end modification page includes any one or more of the following: direct modification key, re-upload key, and ignore key; Feedback the illegal data to the front-end modification page to obtain modification data corresponding to the illegal data, specifically including: Based on the front-end modification page, display the illegal data; Get the trigger command to trigger any of the following: preset direct modification key, re-upload key, and ignore key; When the direct modification key is triggered, an illegal data modification box pops up to obtain the modification data corresponding to the illegal data; When the re-upload button is triggered, a re-upload page pops up to obtain the file data again, and then read the modified data corresponding to the illegal data; When the ignore key is triggered, the illegal data is determined to be the modified data.

5. The interactive data processing method according to claim 1, characterized in that: The verification result includes any one of the following: a qualified result and an illegal result; When the verification result of the sub-data is a qualified result, the sub-data is predicted to be the qualified data; When the verification result of the sub-data is an illegal result, it is predicted that the sub-data is the illegal data.

6. A data processing device supporting interaction, characterized in that: The device comprises: processor; and a memory having executable codes stored thereon, which, when the executable codes are executed, enable the processor to execute a data processing method supporting interaction as described in any one of claims 1 to 5.

7. A non-volatile computer storage medium, characterized in that: Computer instructions are stored thereon, and when the computer instructions are executed, the method for supporting interactive data processing as described in any one of claims 1 to 5 is implemented.

Images