Data processing method and device, electronic equipment and storage medium

Abstract

This disclosure provides a data processing method, apparatus, electronic device, and storage medium. In some embodiments, this disclosure provides a data processing method, characterized by comprising: determining a first online document in response to a first operation event based on a first system; creating a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data; and importing the first data in the first online document into the first system based on the first mapping relationship. The method proposed in the embodiments of this disclosure improves data import efficiency.

Description

Technical Field

[0001] This disclosure relates to the field of computer technology, and more particularly to a data processing method, apparatus, electronic device, and storage medium. Background Technology

[0002] In data systems, it is sometimes necessary to import data from other systems or from other documents. The imported data needs to be aligned with the existing data in the data system. Summary of the Invention

[0003] This disclosure provides a data processing method, apparatus, electronic device, and storage medium.

[0004] The following technical solution is adopted in this disclosure.

[0005] In some embodiments, this disclosure provides a data processing method, characterized in that it includes:

[0006] In response to a first operational event based on the first system, determine the first online document;

[0007] Create a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data;

[0008] Based on the first mapping relationship, the first data in the first online document is imported into the first system.

[0009] In some embodiments, this disclosure provides a data processing apparatus, including:

[0010] The determining unit is configured to determine the first online document in response to a first operation event based on the first system;

[0011] A control unit is configured to create a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data;

[0012] The control unit is further configured to import the first data in the first online document into the first system based on the first mapping relationship.

[0013] In some embodiments, this disclosure provides an electronic device, including: at least one memory and at least one processor;

[0014] The memory is used to store program code, and the processor is used to call the program code stored in the memory to execute the above method.

[0015] In some embodiments, this disclosure provides a computer-readable storage medium for storing program code that, when run by a processor, causes the processor to perform the methods described above.

[0016] This disclosure provides a data processing method, characterized by comprising: in response to a first operation event based on a first system, determining a first online document; creating a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data; and importing the first data in the first online document into the first system based on the first mapping relationship. The method proposed in this disclosure improves data import efficiency. Attached Figure Description

[0017] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and elements are not necessarily drawn to scale.

[0018] Figure 1 This is a flowchart of a data processing method according to an embodiment of the present disclosure.

[0019] Figures 2 to 4 This is a schematic diagram of the first system during data import in an embodiment of this disclosure.

[0020] Figure 5 This is a schematic diagram of the template document in an embodiment of this disclosure.

[0021] Figures 6 to 13 This is a schematic diagram of the first system during data import in an embodiment of this disclosure.

[0022] Figure 14 This is a schematic diagram of the first online document in an embodiment of this disclosure.

[0023] Figure 15 This is a schematic diagram of the imported result file in an embodiment of this disclosure.

[0024] Figures 16 to 19 This is a schematic diagram of the first system for data export in an embodiment of this disclosure.

[0025] Figure 20 This is a schematic diagram of the exported result file of an embodiment of this disclosure.

[0026] Figure 21 This is a schematic diagram of the layered architecture of the first system according to an embodiment of this disclosure.

[0027] Figure 22This is yet another schematic diagram of the layered architecture of the first system according to an embodiment of this disclosure.

[0028] Figures 23 to 26 This is a timing diagram of the first system according to an embodiment of this disclosure.

[0029] Figure 27 This is a schematic diagram of the structure of an electronic device according to an embodiment of the present disclosure. Detailed Implementation

[0030] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.

[0031] It should be understood that the various steps described in the method embodiments of this disclosure can be performed in sequence and / or in parallel. Furthermore, method embodiments may include additional steps and / or omit the steps shown. The scope of this disclosure is not limited in this respect.

[0032] The term "comprising" and its variations as used herein are open-ended inclusions, meaning "including but not limited to". The term "based on" means "at least partially based on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Definitions of other terms will be given in the description below.

[0033] It should be noted that the concepts of "first" and "second" mentioned in this disclosure are used only to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.

[0034] It should be noted that the use of the word "a" in this disclosure is illustrative rather than restrictive, and those skilled in the art should understand that it should be understood as "one or more" unless otherwise expressly indicated in the context.

[0035] The names of messages or information exchanged between multiple devices in the embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.

[0036] The solutions provided by the embodiments of this disclosure will be described in detail below with reference to the accompanying drawings.

[0037] like Figure 1 As shown, Figure 1This is a flowchart of a data processing method according to an embodiment of the present disclosure. The data processing method can be used in a first system, or a terminal that can access the first system, and includes the following steps.

[0038] S11: In response to a first operation event based on the first system, determine the first online document.

[0039] In some embodiments, the first system may be a data management system, such as a company's internal product management system. The first operation event is one or more operations performed based on the first system, such as an operation event that triggers a control in the first system. The first online document may be a table document or a document containing tables, or other types of documents. The first online document is stored in an online document space and can be viewed online. The first online document is a document outside the first system.

[0040] S12: Create the first mapping relationship between the data fields in the first online document and the data fields in the first system.

[0041] In some embodiments, the first online document contains first data, and the data fields of the first online document are fields of the first data. For example, the first data is stored in the form of a table, and the data fields can be the table headers. The data fields of the first system can be the table headers of the data tables in the first system. The first mapping relationship identifies which data fields in the first data correspond to which data fields in the first system.

[0042] S13: Import the first data in the first online document into the first system based on the first mapping relationship.

[0043] In some embodiments, based on the first mapping relationship, it can be determined which data fields in the first system the first data in the first online document needs to be stored under. This allows the first data to be imported into the corresponding data fields in the first system without requiring the user to manually copy and paste the first data into the first system. Furthermore, since the first online document is an online document, data from the online document can be directly imported into the first system without downloading the first online document and then re-uploading it. The method proposed in this disclosure improves data import efficiency.

[0044] In some embodiments of this disclosure, determining a first online document in response to a first operation event based on a first system includes: displaying a first interface in response to the first operation; and determining that the document pointed to by the link address is the first online document in response to entering a link address in the link area of ​​the first interface.

[0045] In some embodiments, please refer to Figure 2 and Figure 3 , Figure 2The diagram illustrates the interface of the first system. A first operation could be, for example, triggering a control within the first system used for importing data. Figure 2 (Click "Import Data" in the upper right corner), then... Figure 3 As shown, the first interface is displayed. Figure 3 The interface that pops up on the right side of the screen (in some embodiments) allows only users with the corresponding permissions to trigger the data import control. The first interface may contain sub-interfaces, with different sub-interfaces corresponding to different process nodes. Figure 3 The import task process includes three nodes: "Select Data", "Data Mapping", and "Start Import". Each node has a corresponding sub-interface. The link area can be located in the sub-interface corresponding to "Select Data". The link area is used to add the link address of the document. After entering the link address of the document in the link area, the first system can identify the document pointed to by the link address and thus use it as the first online document.

[0046] In some embodiments of this disclosure, the first interface has an object option, which is used to select an object in the first system, and the first data of the first online document is imported under the selected object. In some embodiments, such as... Figure 3 As shown, Figure 3 The diagram illustrates a dropdown menu for selecting objects, which can include customers, products, orders, teams, etc. It indicates which type of object the first data imported is, such as product data or customer data.

[0047] In some embodiments of this disclosure, the first interface displays operation type options, including adding data and modifying data. When the "add data" option is selected, the first data in the first online document is imported into the first system in the manner of adding data. When the "modify data" option is selected, the data in the first system is modified using the first data in the first online document. In some embodiments, such as... Figure 3 As shown, the first interface displays "Select Operation Type." When the user selects "Add Data," the first data will not overwrite existing data in the first system; instead, it will be added as new data. If the user selects "Modify Data," the first data can overwrite existing data in the first system. Due to the importance of the operation type option, it is not checked by default; users must select it manually to avoid impacting data security due to default selection. In some embodiments, to ensure data security and accuracy, the link area can be automatically cleared after the selected operation type option changes. Since data import cannot continue when the link area is empty, the user needs to re-enter the document's link address to ensure the correctness of the first document.

[0048] In some embodiments of this disclosure, a template control is displayed on the first interface. When triggered, the template control displays a template document and automatically inputs the link address of the template document into the link area of ​​the first interface. In some embodiments, Figure 3 The "Get Document Template" function is a template control. Triggering this control automatically creates a template document based on the existing document template, essentially creating an online document as the first online document. This online template document is generated according to the latest data fields of the first system. The template document can be opened in a new window, allowing users to write data into it, thus ensuring seamless integration between the first online document and the first system. In some embodiments, after the template control is triggered, if the link area is empty, the link address of the template document is entered into the link area of ​​the first interface; if the link area is not empty, the link address is not entered. This avoids the need to re-enter the link address of the first online document when the user accidentally triggers the template control. In some embodiments, the owner of the template document is a robot, and the user who triggered the template control has editing permissions. In some embodiments, Figure 5 The template document is illustrated. It can be a table, with different rows or columns displaying different data fields from the first system. These fields can be categorized as required or optional. The template document may include instructions on how to complete it. Data fields can include at least one of the following: associated fields, reference fields, formula fields, system fields, and required fields. Associated fields indicate a relationship between two fields. For example, if the input data includes product data for a product associated with a customer, the customer's ID can be entered in the associated field to establish the relationship. Reference fields are used to input references to other information in the first system; these may not be shown in the template document. Formula fields are used to input formulas and may not be shown in the template document. System fields are automatically entered by the system and do not require manual input; therefore, they may also not be shown in the template document. Required fields are data fields that must be entered, such as customer name and ID.

[0049] In some embodiments, if the link address in the link area changes or the link address in the first interface is a manually entered link address, the document pointed to by the link address in the link area is format-validated. In some embodiments, the first system has requirements for the format of the first online document; only data from documents with specific formats can be imported into the first online document. For example, the first online document needs to be in online table format, or, for data security reasons, only data from online table documents can be imported into the first system. Therefore, when a link address is entered in the link area, the document pointed to by the link address is format-validated. If the link address is automatically entered by the trigger module control, it is a template document generated by the first system and therefore does not need format validation. However, if the link address is manually entered, the document pointed to by the link address needs format validation. Additionally, when the link address in the link area changes, for example, if an existing link address is modified, the document pointed to by the link address is also format-validated. If the validation fails, a prompt message can be issued.

[0050] In some embodiments of this disclosure, after determining that the document pointed to by the link address is a first online document, and before creating the first mapping relationship, the method further includes: determining whether the first online document has enabled a first permission; if not, displaying a first prompt message, or displaying the first prompt message and opening the first online document after the prompt message is triggered. In some embodiments, for the first online document, the first data contained therein is imported into the first system; therefore, it is necessary to ensure that the first online document allows the export of its first data to avoid data leakage. The first permission can be a sharing permission; only if the first online document can be shared can the first data be imported into the first system; otherwise, the first data cannot be imported into the first system. In some embodiments, such as... Figure 4 As shown, when a link address is entered in the link area, the first online document pointed to by the link address will be checked for first-level permissions. If the first-level permissions of the first online document are not enabled, a prompt message will be displayed. Figure 4 The message "Permissions are not enabled for the current document" appears in the file name.

[0051] In some embodiments of this disclosure, the first interface has an object option and an operation type option. If the object option is not selected, the operation option is not selected, or the link area is empty, a second prompt message is displayed. In some embodiments, it is necessary to determine the object, operation type, and the first online document containing the imported first data. If the object option and operation type option are not selected, or no link address is entered in the link area, the first data cannot be imported into the first system. For example, in this case, the first data can be... Figure 4The "Next" button is set to be unavailable. If the object option, operation type option is not selected, or no link address is entered in the link area, a prompt message will pop up to explain why the process cannot continue if the "Next" button is triggered.

[0052] In some embodiments, the first interface has a close control for closing the first interface. The first interface can only be closed by closing the close control and cannot be closed by other means, such as clicking other areas or using the Esc key on the keyboard. This avoids closing the first interface without any operation.

[0053] In some embodiments of this disclosure, the first online document is an online table, and creating a first mapping relationship between the data fields in the first online document and the data fields in the first system is equivalent to creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system.

[0054] In some embodiments of this disclosure, creating a first mapping relationship between data rows and columns in a first online document and data rows and columns in a first system specifically includes: displaying data rows and columns in the first online document; displaying an associated first control, wherein the first control is used to select data rows and columns in the first system; and creating a first mapping relationship between the data rows and columns of the first online document and the data rows and columns selected in its associated first control. In some embodiments, such as... Figure 6 As shown, after entering the data mapping process node of the import task, the following is displayed: Figure 6 The sub-interface shown in the first interface displays the data rows and columns from the first document. Figure 6 The content under the "Imported File Header" column displayed on the left and the first control ( Figure 6 The option box under the "System Headers" column indicates that the data rows and columns in the first online document can be the headers of the online table determined after parsing the first online document. These headers can be arranged sequentially according to the order in the first online document. Figure 6 In the first online document, "Customer Code," "Telephone," "Other," and "Other" are table headers. The first control maps to data rows and columns in the first system. Specifically, the first control can be used to select the table headers of data tables in the first system. By using the first control to select the data rows and columns in the first system that correspond to the data rows and columns in the first online document, a first mapping relationship is established between them. For example... Figure 6 A first mapping relationship is established between the "Customer Code" header in the first online document and the "Customer" header in the first system. This way, when importing the first data, the specific data under the "Customer Code" header in the first online document will be imported into the "Customer" header in the first system.

[0055] In some embodiments of this disclosure, after creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system, before importing the first data in the first online document into the first system based on the first mapping relationship, the method further includes: performing data verification, which includes at least one of the following: determining that the first data in the first online document is not empty; determining that the format of the first online document meets the format requirements; determining that the required data rows and columns in the first system and the data rows and columns in the first online document have a first mapping relationship; determining that the first data in the imported first online document does not have a unique identifier when the operation type of the first online document is adding data; and determining that the first data in the imported first online document has a unique identifier when the operation type of the first online document is modifying data. In some embodiments, such as Figure 10 As shown, before importing the first data into the first system, data validation is required to ensure that the first data can be imported. This validation ensures that the first data is not empty, that the format of the first online document is compatible with the first system, and that mapping relationships have been established for all required data rows and columns. After validating the first online document, it can be processed as follows: Figure 11 As shown, the data verification results are displayed.

[0056] In some embodiments of this disclosure, if the names of data rows and columns in the first online document match those in the first system, the first control is automatically controlled to select the matching data rows and columns. In some embodiments, if the names of data rows and columns in the first online document match those in the first system, the first control associated with that data row and column in the first online document will automatically select the matching data row and column in the first system, thereby reducing user operations and improving the user experience. Of course, the user can modify the data rows and columns automatically selected by the first control. For example... Figure 8 As shown, the first online document has a data row and column "telephone", and the first control automatically selects the "telephone number" data row and column in the first system.

[0057] In some embodiments of this disclosure, if the names of data rows and columns in the first online document do not match those of data rows and columns in the first system, the associated first control is in an unselected state. In this case, the user needs to manually control the first control to select data rows and columns in the first system. For example... Figure 7 The text demonstrates that once the first control is triggered, it can display rows and columns of data from the first system, which the user can then select.

[0058] In some embodiments of this disclosure, after the first control is triggered, a list of data rows and columns in the first system is displayed, and at least one of the following conditions is met: required data rows and columns in the list are displayed first; required data rows and columns are associated with a first symbol; and selected data rows and columns in the list are in an unselectable state. For some embodiments, please refer to... Figure 7 , Figure 7 When the first control is triggered, a list of data rows and columns in the first system is displayed. This list shows which data rows and columns exist in the first system, with mandatory data rows and columns requiring mapping being the first selection, and optional data rows and columns not requiring mapping being the first selection. Mandatory data rows and columns are displayed before optional data rows and columns, and are marked with an asterisk ("first") to their left to remind the user that a first mapping relationship must be established for that data row and column. Since "Customer" and "Phone Number" have already been selected in other first controls, they can either not be displayed in the list again, or they can be displayed at the bottom of the list and set to an unselectable state.

[0059] In some embodiments of this disclosure, creating a first mapping relationship between data rows and columns in a first online document and data rows and columns in a first system further includes: if the data rows and columns selected by the first control are of a preset type, displaying an associated second control, the second control being used to select data rows and columns in the first system, and creating a second mapping relationship between the data rows and columns selected by the first control and the data rows and columns selected by the second control. In some embodiments, such as... Figure 7 and Figure 8 As shown, the "Customer Code" row displays an option control corresponding to "Mapping Rules," which is the second control. In the first system, there are preset data rows and columns. These preset data rows and columns are associated with other data rows and columns. For example, data row 1 in the first system references data row 2. If data row 1 is a product, and this product is of particular interest to a certain customer, then the product is associated with that customer. When the first data is imported into the first system under this product, the newly imported data needs to establish an association with that customer, i.e., the second mapping relationship. Therefore, the preset data fields can be referenced fields or associated fields in the first system. At this time, the data rows and columns must be selected through the second control to establish the second mapping relationship. After the first data in the first online document is imported into the first system, the imported first data will be stored under the corresponding data row and column in the first system according to the data row and column selected by the first control. For the imported first data, the association between the data row and column selected by the first control and the data row and column selected by the second control is established according to the second mapping relationship. When the second control is triggered, it can provide all data fields (data rows and columns) associated with the data field (data row and column) selected by the first control, or it can only provide data fields in the first system that are associated with the data field selected by the first control, for example... Figure 7 and Figure 8 In the "Customer Code" row, there is a second control. When this second control is triggered, it can provide all the data fields associated with "Customer" in the first system, thus avoiding user selection errors. If the data field selected by the first control is not a preset type, the associated second control will not be displayed.

[0060] In some embodiments of this disclosure, a third prompt message is displayed that is associated with the data row and column of the first system selected in the first control. The third prompt message is field information of the data row and column in the first system. For some embodiments, please refer to... Figure 7 The "Example" column displays "234" and "XX Phone Number" as third-party prompts. In the first online document, field information may have been added to the data rows and columns to explain their meaning. Therefore, after the first control selects a data row or column in the first system, the corresponding field information can be displayed to help the user understand whether the data row or column selected by the first control has the same function as the associated data row or column in the first online document, thus avoiding incorrectly establishing the first mapping relationship.

[0061] In some embodiments of this disclosure, after selecting a data row or column in the first system via the first control and before importing the first data of the first online document into the first system, the method further includes: validating the data format of the data row or column in the first online document associated with the first control, and / or determining that a first mapping relationship is established between the required data row or column in the first system and the data row or column in the first online document. In some embodiments, data format validation is performed when the first control loses focus (e.g., mouse), because the data row or column in the first system may need to have a specific data format, for example, a phone number cannot be text but should be numbers. If the data field in the first online document that has a first mapping relationship with the phone number in the first system is not in a number format, it indicates a number format error. That is, by validating the data format of the data row or column in the first online document associated with the data row or column selected by the first control, it is ensured that the data in the first online document can be correctly imported into the first system. If the data format validation fails, a prompt message can be displayed. Figure 9 As shown, Figure 9 The bottommost control is "Orders," and the data row and column in the corresponding online document are "Other." The data format in this row and column does not meet the requirements of "Orders" in the first system, therefore the message "Data format error" will be displayed. In some embodiments, such as... Figure 8 As shown, when there are required data rows or columns in the first system that do not have a first mapping relationship with the data rows or columns in the first online document, a prompt message can be displayed on the first interface (such as...). Figure 8(As shown at the top right). In some embodiments, it should be noted that data format verification and verification of required data rows and columns are performed before data verification, thereby performing double verification to ensure data security.

[0062] In some embodiments of this disclosure, before importing the first data from the first online document into the first system based on the first mapping relationship, the method further includes: displaying the verification result of the data verification, wherein the verification result includes at least one of the following: object, operation type, number of data rows and columns in the first system with established first mapping relationship, and number of data rows and columns in the first system without established mapping relationship. In some embodiments, such as... Figure 10 and 11 As shown, data validation will be performed before the first data is imported. The validation result will be displayed on the first interface. If the validation is successful, the first data can be imported into the first system. If the validation fails and there are items that cannot pass the data validation, a prompt message can be displayed to inform the user so that the user can go back to the previous step to make modifications.

[0063] In some embodiments of this disclosure, importing first data from a first online document into a first system based on a first mapping relationship includes: creating and saving a copy of the first online document. In some embodiments, when importing the first data into the first system, a copy of the first online document is created and saved. This facilitates future data backtracking and prevents data modification during the import process. Specifically, when importing the first data into the first system, the copy of the first online document can be used directly for data import, or, after importing the first data into the first system, the copy of the first online document can be used to compare the imported first data to ensure its correctness.

[0064] In some embodiments of this disclosure, importing first data from a first online document into a first system based on a first mapping relationship includes: creating a first import task to import the first data from the first online document into the first system; if the creation of the first import task is successful, displaying a fourth prompt message; or, if the creation of the first import task fails, displaying a fifth prompt message. In some embodiments, when importing data into the first system, it is necessary to create a corresponding import task and return a prompt message indicating the result of creating the import task to inform the user, and the first interface can be hidden.

[0065] In some embodiments of this disclosure, after importing the first data from the first online document into the first system based on the first mapping relationship, the method further includes: redirecting to a second interface of the first system, where the second interface displays a list of import tasks. In some embodiments, such as... Figure 12As shown, the right side displays a second interface, which can be an import task list page, displaying import tasks that have been executed, are being executed, and will be executed. After the first data is imported into the first system, the user will automatically jump to the second interface.

[0066] In some embodiments of this disclosure, the second interface of the first system displays an import task list. The import task list displays at least one of the following: an import task identifier, an import task object, an import task operation type, an import task operator, an import task creation time, an import task end time, an import task status, and a third control associated with the import task. The third control, when triggered, is used to view the details page of its associated import task or to view the original import data of the import task. In some embodiments, such as... Figure 12 As shown, the import task list displays import tasks. In addition to basic information such as identifier (id) and object, the import tasks also display third-party controls (…). Figure 12 The function of the third control ("View Original Data" / "View Details") is related to the state of the import task. The function of the third control can be different when the import task is in different states.

[0067] In some embodiments, such as Figure 12 As shown, the import task status includes queued, importing, partially successful, failed, and completed. Queued and importing indicate that the import is not yet completed, while partially successful, failed, and completed indicate that the import is completed. When the import task status is completed (e.g., the import status is partially successful, failed, or completed), the third control is used to view the details page of the import task; otherwise (e.g., the import status is queued or importing), the third control is used to view the original import data of the import task.

[0068] In some embodiments of this disclosure, the details page of the import task includes at least one of: basic information, a link to the original import data, and import results. In some embodiments, such as... Figure 13 As shown, the basic information displays the import task ID, operation type, start time, operator, object, start and end times of the imported data, and import status. After the link to the original imported data is triggered, a snapshot of the original imported data before import is displayed. For example, if the import task is the first import task, triggering the link to the original imported data will display a snapshot of the first online document before import (e.g.,...). Figure 14 The image shown is a schematic snapshot of a first online document, which may be generated based on a copy of the first online document. In some embodiments, the import results display the number of imported data entries, as well as the number of data entries that were successfully imported and the number of data entries that failed to import.

[0069] In some embodiments of this disclosure, such as Figure 13 As shown, the import results include a fourth control for viewing the import result file. The import result file displays detailed import result information, and if any data failed to import, the reason for the failure is also displayed. In some embodiments, Figure 15 The imported result file is illustrated in the illustration, such as... Figure 15 As can be seen, the document displays data that was successfully imported into the first system and data that failed to be imported into the first system, along with the reasons for the failures. In some embodiments, the creator of the imported result file is a robot. After the fourth control is triggered, the owner of the imported result file is transferred to the user who triggered the fourth control. That is, when the user views the imported result file, the owner changes from the robot to the user, thus facilitating the user to further process or share the imported result file without being subject to permission restrictions.

[0070] In some embodiments of this disclosure, the data processing method further includes: in response to a second operation event based on the first system, determining second data in the first system; and exporting the second data in the first system to a second online document. In some embodiments, the method proposed in this disclosure can export data from the first system and generate a second online document based on the exported second data, thereby eliminating the need for the user to manually generate the online document, and can achieve the following... Figure 16 The fourth interface of the first system provides a filtering control, which allows filtering by object as a condition.

[0071] In some embodiments of this disclosure, determining second data in the first system in response to a second operation event based on the first system includes: displaying a third interface in response to a trigger operation on a fifth control in the first system; and determining the second data in the first system in response to a target object and / or target time range determined based on the third interface. In some embodiments, such as... Figure 16 As shown, by triggering Figure 16 The fifth control, "Export Data," will display... Figure 17 The pop-up window shown serves as the third interface, displaying controls for selecting objects and time ranges. Objects can be customers, orders, teams, products, etc. Only one object can be selected at a time. The selected object is the target object, and the selected time range is the target time range. The selectable time range can be set to the most recent three months. Secondary data can be data of the target object within the target time range. The exported data can be data that the current user has viewing permissions for, such as generating data within the target time range. Then, click... Figure 17After clicking "Start Export," the second data is exported to a second online document. In some embodiments, the fifth control is only accessible to users with export permissions. In some embodiments, once the second data is exported to the second online document, it cannot be reversed.

[0072] In some embodiments of this disclosure, after exporting the second data from the first system to the second online document, a sixth prompt message is sent via a chatbot to the communication client. If the export of the second data from the first system to the second online document is successful, a sixth control for viewing the export result is displayed in the sixth prompt message; if the export of the second data from the first system to the second online document fails, the sixth control is not displayed. In some embodiments, when exporting the second data to the second online document, a corresponding first export task needs to be created, which can be achieved by clicking... Figure 17 After clicking the "Start Export" button, the first export task is created. A prompt message can be displayed when the first export task is created successfully or unsuccessfully. Upon completion of the first export task, a notification message will be sent from the first system to inform users that the task is finished. The first system will also pre-bind a communication client (which can be instant messaging software or an office suite with integrated communication functions). The chatbot in the communication client will send communication messages to the user, including a sixth prompt message. This allows the user to directly trigger the sixth control through the communication client to view the export result, which is the execution result of the export task.

[0073] In some embodiments of this disclosure, the fourth interface of the first system displays an export task list. The export task list displays at least one of the following: the identifier of the export task, the object of the export task, the operation type of the export task, the operator of the export task, the creation time of the export task, the end time of the export task, the status of the export task, a seventh control associated with the export task, and an eighth control associated with the export task. The seventh control is used to view the details page of its associated export task after being triggered, and the eighth control is used to re-execute the export task if the export task fails. In some embodiments, the fourth interface may be... Figure 16The export task list page shown displays export tasks, which can be sorted by submission time, with the newest export task recorded at the top. One or more export tasks can be executed simultaneously. If an export task is already in progress, the system will not execute other export tasks at this time; the status of the export task is "queued." The export task will automatically begin execution when the conditions for execution are met. Multiple export tasks can be executed simultaneously, for example, up to 10 export tasks can be executed at a time. For each export task, based on its status, it can be associated with 0 to 2 of the seventh and eighth controls. That is, an export task may or may not have any associated seventh and eighth controls. In some embodiments, when the export task is in an incomplete state (queued or exporting), it does not have any associated seventh and eighth controls. In some embodiments, when the export task is in a completed state (successful or failed), it has an associated seventh control; when the export task is in a failed state, it has an associated eighth control.

[0074] In some embodiments of this disclosure, such as Figure 18 As shown and Figure 19 As shown, if the export task fails, the export task details page displays: basic information and a ninth control for re-executing the export task. If the export task succeeds, the export task details page displays: basic information and the export result, which includes a tenth control for viewing the exported result file.

[0075] In some embodiments, the basic information displays the export task ID, operation type, start time, operator, object, time range of exported data, and export status. When the export task fails, click... Figure 18 The ninth control in the upper right corner, "Re-export," collapses the export task details page and automatically opens the third interface. It automatically selects the objects and time range for the export task, and generates a new export task upon confirmation. Upon successful export, the export results are displayed, showing the number of data rows exported successfully, the number of data rows exported successfully, and the number of data rows that failed. Triggering the tenth control allows viewing the exported result file (the second online document is the exported result file of the first export task). Figure 20The exported result file is illustrated. Explanatory text can be displayed within the exported result file to describe its contents. The exported result file shows the data fields and specific data content from the exported second data set. For related fields in the first system, the corresponding object identifiers are exported along with them. For example, if object name and object ID are associated, they can be exported as two columns: {object} name and {object} ID. For reference fields in the second data set, they are exported as four columns: {object} name, {object} ID, field name label, and field primary key. For formula fields in the second data set, the formulas can be directly exported from the second online document. For system fields in the second data set, the corresponding label is changed to {label name} (system field). For required fields in the second data set, the corresponding label is changed to {label name}.

[0076] In some embodiments of this disclosure, modification of the second data may be prohibited when exporting the second data to a second online document. In other embodiments, a last modified time field may be added to the second data. After exporting the second data to the second online document, the second data in the second online document is compared with the second data in the first system. If the two are inconsistent, a prompt message may be issued.

[0077] In some embodiments of this disclosure, users with data management permissions can import and export data to the first system. When a user with data management permissions accesses the first system, a data management module (such as...) is displayed. Figure 2 (Left side) Otherwise, the data management module will not be displayed.

[0078] In some embodiments of this disclosure, such as Figure 21 As shown, it illustrates the layered architecture of the first system, which includes an application layer, a task management layer, a service layer, and a facility layer. The application layer is used to create import or export tasks. The task management layer is used to receive import or export tasks created by the application layer, determine the required services based on the import or export tasks, and call the services to the service layer. The service layer is used to call services according to the instructions of the task management layer, and the services are used to interact with the task management layer and the facility layer. The facility layer is used to write or query data according to the instructions of the services in the service layer.

[0079] In some embodiments, Figure 22 The layered architecture of the first system is specifically shown in the text. Figure 22 The first system front-end corresponds to Figure 21 The application layer in Figure 22 The first system backend in the middle corresponds to Figure 21 In the task management layer, Figure 22 The import / export service layer and the basic service layer correspond to each other. Figure 21 The service layer in the middle, Figure 22 The facility layer and the corresponding MySQL and Redis databases in the middle. Figure 21 The facility layer in the system. In some embodiments, users interact with the first system through the application layer, creating import or export tasks and viewing task lists for import and export tasks. The task management layer receives import or export tasks or tasks from the application layer, determines the services that need to be invoked, and invokes the corresponding services from the service layer. The corresponding services in the service layer access the facility layer to perform data import, data export, data reading, and other related operations. The following is in conjunction with the appendix. Figure 23 To the attached Figure 25 Please provide a detailed explanation.

[0080] like Figure 23 The diagram illustrates the interaction sequence when viewing a task list (importing or exporting a task list). When viewing or exporting a task list, the user sends a request at the application layer (the system front-end of the first system) to retrieve the import or export task list. Upon receiving this request, the system back-end, acting as the task management layer, determines that access to the import / export service is required. It then calls the import / export service to retrieve the import or export task list. Based on the request from the system back-end, the import / export service accesses the database located at the facilities layer where the import or export task list resides. Figure 23 After obtaining the import or export task list from the MySQL database, the task list is passed up the system backend and then presented on the system frontend.

[0081] like Figure 24 As shown, it illustrates the interactive sequence diagram of writing the first data from the first online document into the first system. The user triggers an object option on the first interface of the first system's front end, and the system front end executes... Figure 24The process involves several steps: 1. Selecting an entity to import (an entity is an object). The system backend executes this via an interface. 2. The interface passes through, calling the import / export service. The import / export service executes this step. 3. Obtaining the entity list (object list). The object list is retrieved from the metadata service (which can be the entity list from a MySQL database), and returned sequentially. This list is then displayed on the system frontend via the import / export service and the system backend, allowing the user to select objects. When the template control displayed on the system frontend is triggered, the system frontend executes step 4. Obtaining the import template (template document). The system frontend retrieves the template document from the system backend and displays it. Then, the user executes step 5. Filling in data. The user writes the first piece of data into the template document. If the template control is not triggered, and the user manually enters a link address in the link area displayed on the first interface, the system frontend executes step 4. Filling in the document link (link address). The system backend receives the entered document link and then executes step 5. Verifying the link's validity. The import / export service is called to verify the validity of the document link, specifically checking whether the document linked to has enabled the first permission and performing format verification. Then, the user creates the first mapping relationship on the first interface. Specifically, at this point, the system frontend executes step 6, configuring field mapping, selecting the associated data fields from the first system for the data fields in the first online document using the first and second controls, and transmitting the selection results to the system backend. Afterwards, the system frontend submits the first data import task (first import task), i.e., the system frontend executes step 7, submitting the import task. Upon receiving the submitted import task, the system backend executes step 8, submitting the import task. Specifically, the system backend calls the import / export service, executing step 9, reading sheet data, retrieving the first data from the first online document from the open platform (the storage space of the first online document), and then the import / export service executes step 10, creating the import task (first import task). After the import task is created, the process of importing the first data from the first online document into the first system based on the first mapping relationship begins, specifically as follows... Figure 24As described above, when importing the first data into the first system, the import / export service first performs step 11, splitting the task pipeline, which splits the first import task into different tasks corresponding to different databases. Specifically, the MySQL database stores the list of import tasks and metadata, the Redis database stores the status of the import tasks in the first system, and the entity database is used to store entity data (object data, such as specific product data and customer data). Therefore, the import / export service performs step 12, storing the task pipeline, writing the first import task into the MySQL database, and then adding the first import task to the Redis database, adding the task status of writing the first data to the Redis database, and the task of writing the first data begins to be queued. Then, the import / export service executes the first import task according to the queue order. Specifically, the import / export service executes step 14, obtaining the import task and updating the status of the first import task in the Redis database. Then, it loops through step 15, writing data, and uses the data service to execute step 16, persistence, storing the first data to be imported corresponding to the first import task into the entity database used to store the first system. Based on the feedback from the data service, the import / export service needs to update the status and list of import tasks accordingly. Therefore, it executes steps 17, updating the task log status, and 18, updating the import task status, updating the import task list and status in the MySQL and Redis databases respectively. After the first import task is completed, the import / export service executes step 19, updating the import task status to update the import tasks in the import task list, then executes step 20, sending the result, and step 211, sending the card, calling the card service to send the card to the open platform. The card is sent to the communication client through the open platform, and the chatbot sends the card (sixth prompt message) to the user to inform them of the execution result of the import task. The user can learn the result through the card.

[0082] like Figure 25 As shown, it illustrates the interaction sequence diagram when writing second data from the first system to the second online document. The user triggers a control for selecting an object (entity) on the third interface of the first system's front end, executing... Figure 25The process involves: 1. Selecting the entity to export (an entity is an object). The system backend executes this via an interface. 2. The interface is passed through, calling the import / export service. The import / export service executes. 3. Obtaining the entity list (object list). The object list is retrieved from the metadata service and returned sequentially. It is then displayed on the system frontend via the import / export service and the system backend, allowing the user to select the target object. The system frontend submits the second data export task for the target object (the first export task), which is executed by the system frontend. 4. Creating the export task. After the system backend receives the submitted import task, it executes step 5: Create an export task. Specifically, the system backend calls the import / export service, executes step 6: Create an export task, writes the first export task into the export task list of the MySQL database, and executes step 7: Add the export task to the Redis database. Then, it executes step 8: Retrieve the first export task, and step 9: Create a result sheet, creating a second online document in the open platform. After that, it starts looping through steps 10 to 15. Specifically, the import / export service executes step 10: Read data page by page, and the data service executes step 11: Query data, that is, the import / export service calls the data service to read the data of each page of the second online document from the entity database storing the first system, step 12: Write sheet data, writing the second data read from the first system into the second online document through the open platform (the platform where the second online document is located). Then, the import / export service executes step 13: Update the export task status. After that, the import / export service executes step 14: Send the result, and the card service executes step 15: Send the card to the open platform. After receiving the card, the open platform will provide feedback to the user through the chatbot in the communication client to inform them of the export result, that is, step 16: Result feedback.

[0083] In some embodiments of this disclosure, creating a first mapping relationship between data fields in a first online document and data fields in a first system includes: the application layer sending a mapping configuration request to the task management layer in response to entering an interface for creating the first mapping relationship; the task management layer invoking the import / export service of the service layer; the import / export service obtaining metadata of the first system through a metadata service, obtaining data fields of the first online document from the facility layer, parsing the data fields of the first online document to obtain data types, and returning the metadata, the data fields of the first online document, and the data types to the task management layer; the task management layer returning the metadata, the data fields of the first online document, and the data types to the application layer; the application layer creating the first mapping relationship based on the data fields of the first online document and the metadata, and performing data type validation based on the metadata and the data types of the first online document.

[0084] In some embodiments, in conjunction with the appendix Figure 26The sequence of events for creating the first mapping relationship between data fields in the first online document and data fields in the first system is described. When a user enters the sub-interface for creating the first mapping relationship in the first interface of the first system's front-end (application layer), a mapping configuration request is generated and sent to the system back-end (i.e., the task management layer). Figure 26 The system frontend sends configuration entity mappings to the system backend. The system backend calls the import / export service to obtain the metadata of the first system and reads the data fields (table headers) and the first two rows of content of the first online document from the open platform of the facility layer. The import / export service determines the data type corresponding to the data field by parsing the data field of the first online document, and then returns the aforementioned metadata, the data field of the first online document, the first two rows of data, and the data type to the system backend. The system backend transmits the data field of the first online document to the system frontend for display, and displays the data field of the first system in the first control according to the metadata (the metadata records the data field of the first system and the data type of the data field). The system frontend automatically maps the data field of the first online document to the data field of the first system. If the data field in the first online document matches the name of the data field in the first system, it automatically controls the first control to select the matching data field (when the first online document is an online table, the data field is the data row and column). Of course, users can also manually configure the data field in the first system corresponding to the data field in the first online document. After a data field from the first system is selected in the first control, a data type validation is performed based on the data type of the data field in the first online document and the data type of the data field selected by the first control, as recorded in the metadata of the first system. This ensures that the data type of the data field in the first online document meets the data type requirements of the data field in the associated first system. If the validation is successful, a first mapping relationship is established between the two. If the validation fails, a first mapping relationship cannot be established between the two.

[0085] This disclosure also provides a data processing apparatus, including:

[0086] The determining unit is configured to determine the first online document in response to a first operation event based on the first system;

[0087] A control unit is configured to create a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data;

[0088] The control unit is further configured to import the first data in the first online document into the first system based on the first mapping relationship.

[0089] In some embodiments, determining a first online document in response to a first operation event based on a first system includes: displaying a first interface in response to the first operation; and determining that the document pointed to by the link address is the first online document in response to entering a link address in a link area of ​​the first interface.

[0090] In some embodiments, the first interface has an object option, which is used to select an object in the first system, and the first data of the first online document is imported under the selected object;

[0091] In some embodiments, the first interface displays operation type options, including adding data and modifying data. When the option to add data is selected, the first data in the first online document is imported into the first system in the manner of adding data. When the option to modify data is selected, the data in the first system is modified using the first data in the first online document.

[0092] In some embodiments, a template control is displayed on the first interface. When the template control is triggered, a template document is displayed, and the link address of the template document is automatically entered into the link area of ​​the first interface.

[0093] In some embodiments, if the link address in the link area changes or the link address in the first interface is a manually entered link address, the document pointed to by the link address in the link area is format-validated.

[0094] In some embodiments, the control unit is further configured to: determine whether the first online document has enabled the first permission after determining that the document pointed to by the link address is the first online document and before creating the first mapping relationship; if not enabled, display a first prompt message, or display the first prompt message and open the first online document after the prompt message is triggered;

[0095] In some embodiments, the first interface has an object option and an operation type option, and the control unit is further configured to display a second prompt message if the object option is not selected, the operation option is not selected, or the link area is empty.

[0096] In some embodiments, the first online document is an online table, and the creation of the first mapping relationship between the data fields in the first online document and the data fields in the first system is to create the first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system.

[0097] In some embodiments, creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system specifically includes: displaying the data rows and columns in the first online document, displaying an associated first control, wherein the first control is used to select data rows and columns in the first system; and creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns selected in the associated first control.

[0098] In some embodiments, the control unit is further configured to perform data verification after creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system, and before importing the first data in the first online document into the first system based on the first mapping relationship. The data verification includes at least one of the following: determining that the first data in the first online document is not empty; determining that the format of the first online document meets the format requirements; determining that the required data rows and columns in the first system and the data rows and columns in the first online document have a first mapping relationship; determining that the first data in the first online document imported does not have a unique identifier when the operation type of the first online document is adding data; and determining that the first data in the first online document imported has a unique identifier when the operation type of the first online document is modifying data.

[0099] In some embodiments, the control unit is also configured to automatically control the first control to select the matching data row or column if the data row or column in the first online document matches the name of the data row or column in the first system;

[0100] In some embodiments, the control unit is further configured to control the associated first control to be in an unselected state if the names of the data rows and columns in the first online document do not match the names of the data rows and columns in the first system;

[0101] In some embodiments, the control unit is further configured to display a list of data rows and columns in the first system after the first control is triggered, and satisfy at least one of the following: the required data rows and columns in the list of data rows and columns are displayed first, the required data rows and columns are associated with a first symbol, and the selected data rows and columns in the list of data rows and columns are in an unselectable state;

[0102] In some embodiments, creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system further includes: if the data rows and columns selected by the first control are of a preset type, displaying an associated second control, the second control being used to select data rows and columns in the first system, and creating a second mapping relationship between the data rows and columns selected by the first control and the data rows and columns selected by the second control;

[0103] In some embodiments, the control unit is also configured to display a third prompt message associated with a data row or column of a first system selected in the first control, the third prompt message being field information of the data row or column in the first system;

[0104] In some embodiments, the control unit is further configured to, after selecting a data row or column in the first system via the first control, verify the data format of the data row or column in the first online document associated with the first control, and / or determine that a first mapping relationship is established between the required data row or column in the first system and the data row or column in the first online document.

[0105] In some embodiments, importing the first data in the first online document into the first system based on the first mapping relationship includes: creating a copy of the first online document and saving it;

[0106] In some embodiments, importing the first data in the first online document into the first system based on the first mapping relationship includes: creating a first import task to import the first data in the first online document into the first system; if the creation of the first import task is successful, displaying a fourth prompt message; or, if the creation of the first import task fails, displaying a fifth prompt message.

[0107] In some embodiments, the control unit is further configured to import the first data in the first online document into the first system based on the first mapping relationship, and then jump to a second interface of the first system, the second interface displaying an import task list.

[0108] In some embodiments, the second interface of the first system displays an import task list, which displays at least one of the following: the identifier of the import task, the object of the import task, the operation type of the import task, the operator of the import task, the creation time of the import task, the end time of the import task, the status of the import task, and a third control associated with the import task. The third control is used to view the details page of the associated import task or to view the original import data of the import task after being triggered.

[0109] In some embodiments, when the import task is in the import completed state, the third control is used to view the details page of the import task; otherwise, the third control is used to view the original import data of the import task.

[0110] In some embodiments, the details page of the import task includes at least one of the following: basic information, a link to the original import data, and import results.

[0111] In some embodiments, a snapshot of the original imported data before its import is viewed after the link to the original imported data is triggered;

[0112] In some embodiments, the import result includes a fourth control for viewing the import result file, which displays detailed import result information. If there is data that failed to be imported, the import result file also displays the reason for the import failure.

[0113] In some embodiments, the import result includes a fourth control for viewing the import result file, the creator of which is a robot, and after the fourth control is triggered, the owner of the import result file is transferred to the user who triggered the fourth control.

[0114] In some embodiments, the control unit is further configured to, in response to a second operational event based on the first system, determine second data in the first system and export the second data in the first system to a second online document.

[0115] In some embodiments, determining second data in the first system in response to a second operation event based on the first system includes: displaying a third interface in response to a trigger operation on a fifth control in the first system; and determining the second data in the first system in response to a target object and / or target time range determined based on the third interface.

[0116] In some embodiments, the control unit is further configured to send a sixth prompt message in the communication client via a chatbot after exporting the second data from the first system to the second online document. If the export of the second data from the first system to the second online document is successful, a sixth control for viewing the export result is displayed in the sixth prompt message; if the export of the second data from the first system to the second online document fails, the sixth control is not displayed.

[0117] In some embodiments, the fourth interface of the first system displays an export task list. The export task list displays at least one of the following: the identifier of the export task, the object of the export task, the operation type of the export task, the operator of the export task, the creation time of the export task, the end time of the export task, the status of the export task, a seventh control associated with the export task, and an eighth control associated with the export task. The seventh control is used to view the details page of its associated export task after being triggered, and the eighth control is used to re-execute the export task when the export task fails.

[0118] In some embodiments, if the export task fails, the details page of the export task displays: basic information and a ninth control for re-executing the export task;

[0119] In some embodiments, if the export task is successful, the details page of the export task displays: basic information and export results, and the export results include a tenth control for viewing the exported result file.

[0120] In some embodiments, the first system includes an application layer, a task management layer, a service layer, and a facility layer;

[0121] The application layer is used to create import or export tasks;

[0122] The task management layer is used to receive the import task or export task created by the application layer, determine the required service based on the import task or export task, and call the service to the service layer.

[0123] The service layer is used to invoke services according to the instructions of the task management layer, and the services are used to interact with the task management layer or the facility layer.

[0124] The facility layer is used to write or query data according to the instructions of the service layer.

[0125] In some embodiments, creating a first mapping relationship between data fields in the first online document and data fields in the first system includes:

[0126] In response to entering the interface for creating the first mapping relationship, the application layer sends a mapping configuration request to the task management layer;

[0127] The task management layer calls the import / export service of the service layer;

[0128] The import / export service obtains the metadata of the first system through the metadata service, and obtains the data fields of the first online document from the facility layer. It then parses the data fields of the first online document to obtain the data type, and returns the metadata, the data fields of the first online document, and the data type to the task management layer.

[0129] The task management layer returns the metadata, the data fields and data types of the first online document to the application layer.

[0130] The application layer creates the first mapping relationship based on the data fields of the first online document and the metadata, and performs data type validation based on the metadata and the data type of the first online document.

[0131] For embodiments of the apparatus, since they basically correspond to the method embodiments, relevant details can be found in the descriptions of the method embodiments. The apparatus embodiments described above are merely illustrative, and the modules described as separate modules may or may not be separate. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0132] The methods and apparatus of this disclosure have been described above based on embodiments and application examples. Furthermore, this disclosure also provides an electronic device and a computer-readable storage medium, which are described below.

[0133] The following is for reference. Figure 27 The figure illustrates a structural schematic of an electronic device (e.g., a terminal device or a server) 800 suitable for implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, laptops, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. The electronic device shown in the figure is merely an example and should not be construed as limiting the functionality and scope of the embodiments of the present disclosure.

[0134] Electronic device 800 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 801, which can perform various appropriate actions and processes according to a program stored in read-only memory (ROM) 802 or a program loaded from storage device 808 into random access memory (RAM) 803. RAM 803 also stores various programs and data required for the operation of electronic device 800. The processing device 801, ROM 802, and RAM 803 are interconnected via bus 804. Input / output (I / O) interface 805 is also connected to bus 804.

[0135] Typically, the following devices can be connected to I / O interface 805: input devices 806 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 807 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 808 including, for example, magnetic tapes, hard disks, etc.; and communication devices 809. Communication device 809 allows electronic device 800 to communicate wirelessly or wiredly with other devices to exchange data. Although an electronic device 800 with various devices is shown in the figure, it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed alternatively.

[0136] In particular, according to embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via a communication device 809, or installed from a storage device 808, or installed from a ROM 802. When the computer program is executed by a processing device 801, it performs the functions defined in the methods of embodiments of this disclosure.

[0137] It should be noted that the computer-readable medium described in this disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this disclosure, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in connection with an instruction execution system, apparatus, or device. In this disclosure, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium can be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wires, optical fibers, RF (radio frequency), etc., or any suitable combination thereof.

[0138] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future-developed networks.

[0139] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device.

[0140] The aforementioned computer-readable medium carries one or more programs, which, when executed by the electronic device, cause the electronic device to perform the methods of the present disclosure.

[0141] Computer program code for performing the operations of this disclosure can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0142] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0143] The units described in the embodiments of this disclosure can be implemented in software or hardware. The names of the units are not, in some cases, intended to limit the specific unit.

[0144] The functions described above in this document can be performed, at least in part, by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: Field Programmable Gate Arrays (FPGAs), Application-Specific Integrated Circuits (ASICs), Application Standard Products (ASSPs), System-on-Chip (SoCs), Complex Programmable Logic Devices (CPLDs), and so on.

[0145] In the context of this disclosure, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0146] According to one or more embodiments of this disclosure, a data processing method is provided, comprising:

[0147] In response to a first operational event based on the first system, determine the first online document;

[0148] Create a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data;

[0149] Based on the first mapping relationship, the first data in the first online document is imported into the first system.

[0150] According to one or more embodiments of this disclosure, a data processing method is provided to determine a first online document in response to a first operation event based on a first system, including: displaying a first interface in response to the first operation; and determining that the document pointed to by the link address is the first online document in response to inputting a link address in a link area of ​​the first interface.

[0151] According to one or more embodiments of this disclosure, a data processing method is provided, the method comprising at least one of the following:

[0152] The first interface has an object option, which is used to select an object in the first system, and the first data of the first online document is imported into the selected object;

[0153] The first interface displays operation type options, including adding data and modifying data. When the option to add data is selected, the first data in the first online document is imported into the first system in the manner of adding data. When the option to modify data is selected, the data in the first system is modified using the first data in the first online document.

[0154] The first interface displays a template control. When the template control is triggered, it displays a template document and automatically inputs the link address of the template document into the link area of ​​the first interface.

[0155] If the link address in the link area changes or the link address in the first interface is a manually entered link address, the document pointed to by the link address in the link area is formatted.

[0156] After determining that the document pointed to by the link address is the first online document, and before creating the first mapping relationship, the method further includes: determining whether the first online document has enabled the first permission; if not, displaying the first prompt message, or displaying the first prompt message and opening the first online document after the prompt message is triggered;

[0157] The first interface has an object option and an operation type option. If the object option is not selected, the operation option is not selected, or the link area is empty, a second prompt message will be displayed.

[0158] According to one or more embodiments of this disclosure, a data processing method is provided, wherein the first online document is an online table, and the step of creating a first mapping relationship between data fields in the first online document and data fields in the first system is to create a first mapping relationship between data rows and columns in the first online document and data rows and columns in the first system, the method comprising at least one of the following:

[0159] Creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system specifically includes: displaying the data rows and columns in the first online document, displaying an associated first control, wherein the first control is used to select data rows and columns in the first system; and creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns selected in the associated first control.

[0160] After creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system, before importing the first data in the first online document into the first system based on the first mapping relationship, the method further includes: performing data verification, wherein the data verification includes at least one of the following: determining that the first data in the first online document is not empty; determining that the format of the first online document meets the format requirements; determining that the required data rows and columns in the first system and the data rows and columns in the first online document have a first mapping relationship; determining that the first data in the first online document imported does not have a unique identifier when the operation type of the first online document is adding data; and determining that the first data in the first online document imported has a unique identifier when the operation type of the first online document is modifying data.

[0161] According to one or more embodiments of this disclosure, a data processing method is provided that satisfies at least one of the following:

[0162] If the data row and column in the first online document match the name of the data row and column in the first system, the first control will automatically select the matching data row and column.

[0163] If the names of the data rows and columns in the first online document do not match the names of the data rows and columns in the first system, the first control associated with the control is in an unselected state.

[0164] After the first control is triggered, a list of data rows and columns in the first system is displayed, and at least one of the following conditions is met: the required data rows and columns in the list of data rows and columns are displayed first; the required data rows and columns are associated with a first symbol; and the selected data rows and columns in the list of data rows and columns are in an unselectable state.

[0165] Creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system further includes: if the data rows and columns selected by the first control are of a preset type, displaying an associated second control, the second control being used to select data rows and columns in the first system, and creating a second mapping relationship between the data rows and columns selected by the first control and the data rows and columns selected by the second control;

[0166] Display a third prompt message associated with the data row and column of the first system selected in the first control, wherein the third prompt message is the field information of the data row and column in the first system;

[0167] After selecting a data row or column in the first system using the first control, the method further includes: validating the data format of the data row or column in the first online document associated with the first control, and / or determining that a first mapping relationship is established between the required data row or column in the first system and the data row or column in the first online document.

[0168] According to one or more embodiments of this disclosure, a data processing method is provided that satisfies at least one of the following:

[0169] Importing the first data from the first online document into the first system based on the first mapping relationship includes: creating a copy of the first online document and saving it;

[0170] Importing the first data in the first online document into the first system based on the first mapping relationship includes: creating a first import task to import the first data in the first online document into the first system; if the creation of the first import task is successful, a fourth prompt message is displayed; or if the creation of the first import task fails, a fifth prompt message is displayed.

[0171] After importing the first data from the first online document into the first system based on the first mapping relationship, the process further includes: redirecting to a second interface of the first system, where the second interface displays an import task list.

[0172] According to one or more embodiments of this disclosure, a data processing method is provided. The second interface of the first system displays an import task list. The import task list displays at least one of the following: an import task identifier, an import task object, an import task operation type, an import task operator, an import task creation time, an import task end time, an import task status, and a third control associated with the import task. The third control is used to view the details page of its associated import task or to view the original import data of the import task after being triggered.

[0173] According to one or more embodiments of this disclosure, a data processing method is provided that satisfies at least one of the following:

[0174] When the import task is in the import completed state, the third control is used to view the details page of the import task; otherwise, the third control is used to view the original import data of the import task.

[0175] The details page of the import task includes at least one of the following: basic information, a link to the original import data, and the import results.

[0176] According to one or more embodiments of this disclosure, a data processing method is provided to view a snapshot of the original imported data before its import after the link to the original imported data is triggered.

[0177] The import result includes a fourth control for viewing the import result file, which displays detailed import result information. If there is data that failed to be imported, the import result file also displays the reason for the import failure.

[0178] The import results include a fourth control for viewing the import result file. The creator of the import result file is the robot. After the fourth control is triggered, the owner of the import result file is transferred to the user who triggered the fourth control.

[0179] According to one or more embodiments of this disclosure, a data processing method is provided, further comprising:

[0180] In response to a second operational event based on the first system, determine the second data in the first system;

[0181] Export the second data from the first system to the second online document.

[0182] According to one or more embodiments of this disclosure, a data processing method is provided that satisfies at least one of the following:

[0183] In response to a second operation event based on the first system, determining second data in the first system includes: in response to a trigger operation on a fifth control in the first system, displaying a third interface; and in response to a target object and / or target time range determined by the third interface, determining second data in the first system.

[0184] After exporting the second data from the first system to the second online document, a sixth prompt message is sent in the communication client via a chatbot. If the export of the second data from the first system to the second online document is successful, a sixth control for viewing the export result is displayed in the sixth prompt message. If the export of the second data from the first system to the second online document fails, the sixth control is not displayed.

[0185] The fourth interface of the first system displays an export task list, which displays at least one of the following: the identifier of the export task, the object of the export task, the operation type of the export task, the operator of the export task, the creation time of the export task, the end time of the export task, the status of the export task, a seventh control associated with the export task, and an eighth control associated with the export task. The seventh control is used to view the details page of its associated export task after being triggered, and the eighth control is used to re-execute the export task when the export task fails.

[0186] According to one or more embodiments of this disclosure, a data processing method is provided that satisfies at least one of the following:

[0187] If the export task fails, the details page of the export task will display: basic information and a ninth control for re-executing the export task;

[0188] If the export task is successful, the details page of the export task will display: basic information and export results, including a tenth control for viewing the exported result file.

[0189] According to one or more embodiments of this disclosure, a data processing method is provided, wherein the first system includes an application layer, a task management layer, a service layer, and a facility layer;

[0190] The application layer is used to create import or export tasks;

[0191] The task management layer is used to receive the import task or export task created by the application layer, determine the required service based on the import task or export task, and call the service to the service layer.

[0192] The service layer is used to invoke services according to the instructions of the task management layer, and the services are used to interact with the facility layer;

[0193] The facility layer is used to write or query data according to the instructions of the service layer.

[0194] According to one or more embodiments of this disclosure, a data processing method is provided to create a first mapping relationship between data fields in the first online document and data fields in the first system, including:

[0195] In response to entering the interface for creating the first mapping relationship, the application layer sends a mapping configuration request to the task management layer;

[0196] The task management layer calls the import / export service of the service layer;

[0197] The import / export service obtains the metadata of the first system through the metadata service, and obtains the data fields of the first online document from the facility layer. It then parses the data fields of the first online document to obtain the data type, and returns the metadata, the data fields of the first online document, and the data type to the task management layer.

[0198] The task management layer returns the metadata, the data fields and data types of the first online document to the application layer.

[0199] The application layer creates the first mapping relationship based on the data fields of the first online document and the metadata, and performs data type validation based on the metadata and the data type of the first online document.

[0200] According to one or more embodiments of this disclosure, a data processing apparatus is provided, comprising:

[0201] The determining unit is configured to determine the first online document in response to a first operation event based on the first system;

[0202] A control unit is configured to create a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data;

[0203] The control unit is further configured to import the first data in the first online document into the first system based on the first mapping relationship.

[0204] According to one or more embodiments of the present disclosure, an electronic device is provided, including: at least one memory and at least one processor;

[0205] The at least one memory is used to store program code, and the at least one processor is used to call the program code stored in the at least one memory to execute the method described in any one of the above.

[0206] According to one or more embodiments of the present disclosure, a computer-readable storage medium is provided for storing program code that, when executed by a processor, causes the processor to perform the methods described above.

[0207] The above description is merely a preferred embodiment of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features disclosed in this disclosure that have similar functions.

[0208] Furthermore, while the operations are described in a specific order, this should not be construed as requiring these operations to be performed in the specific order shown or in a sequential order. In certain environments, multitasking and parallel processing may be advantageous. Similarly, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

[0209] Although the subject matter has been described using language specific to structural features and / or methodological logic, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely illustrative examples of implementing the claims.

Claims

1. A data processing method, characterized in that, include: In response to a first operational event based on the first system, determine the first online document; Create a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data; Based on the first mapping relationship, the first data in the first online document is imported into the first system; Wherein, the first online document is an online table, and the creation of the first mapping relationship between the data fields in the first online document and the data fields in the first system is to create the first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system, and the method includes at least one of the following: Creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system specifically includes: displaying the data rows and columns in the first online document, displaying an associated first control, wherein the first control is used to select data rows and columns in the first system; and creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns selected in the associated first control. After creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system, before importing the first data in the first online document into the first system based on the first mapping relationship, the method further includes: performing data verification, wherein the data verification includes at least one of the following: determining that the first data in the first online document is not empty; determining that the format of the first online document meets the format requirements; determining that the required data rows and columns in the first system and the data rows and columns in the first online document have a first mapping relationship; determining that the first data in the first online document imported does not have a unique identifier when the operation type of the first online document is adding data; and determining that the first data in the first online document imported has a unique identifier when the operation type of the first online document is modifying data.

2. The method according to claim 1, characterized in that, In response to a first operation event based on a first system, determining a first online document includes: in response to the first operation, displaying a first interface; and in response to entering a link address in a link area of ​​the first interface, determining that the document pointed to by the link address is the first online document.

3. The method according to claim 2, characterized in that, The method includes at least one of the following: The first interface has an object option, which is used to select an object in the first system, and the first data of the first online document is imported into the selected object; The first interface displays operation type options, including adding data and modifying data. When the option to add data is selected, the first data in the first online document is imported into the first system in the manner of adding data. When the option to modify data is selected, the data in the first system is modified using the first data in the first online document. The first interface displays a template control. When the template control is triggered, it displays a template document and automatically inputs the link address of the template document into the link area of ​​the first interface. If the link address in the link area changes or the link address in the first interface is a manually entered link address, the document pointed to by the link address in the link area is formatted. After determining that the document pointed to by the link address is the first online document, and before creating the first mapping relationship, the method further includes: determining whether the first online document has enabled the first permission; if not, displaying the first prompt message, or displaying the first prompt message and opening the first online document after the prompt message is triggered; The first interface has an object option and an operation type option. If the object option is not selected, the operation option is not selected, or the link area is empty, a second prompt message will be displayed.

4. The method according to claim 1, characterized in that, It satisfies at least one of the following: If the data row and column in the first online document match the name of the data row and column in the first system, the first control will automatically select the matching data row and column. If the names of the data rows and columns in the first online document do not match the names of the data rows and columns in the first system, the first control associated with the control is in an unselected state. After the first control is triggered, a list of data rows and columns in the first system is displayed, and at least one of the following conditions is met: the required data rows and columns in the list of data rows and columns are displayed first; the required data rows and columns are associated with a first symbol; and the selected data rows and columns in the list of data rows and columns are in an unselectable state. Creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system further includes: if the data rows and columns selected by the first control are of a preset type, displaying an associated second control, the second control being used to select data rows and columns in the first system, and creating a second mapping relationship between the data rows and columns selected by the first control and the data rows and columns selected by the second control; Display a third prompt message associated with the data row and column of the first system selected in the first control, wherein the third prompt message is the field information of the data row and column in the first system; After selecting a data row or column in the first system using the first control, the method further includes: validating the data format of the data row or column in the first online document associated with the first control, and / or determining that a first mapping relationship is established between the required data row or column in the first system and the data row or column in the first online document.

5. The method according to claim 1, characterized in that, It satisfies at least one of the following: Importing the first data from the first online document into the first system based on the first mapping relationship includes: creating a copy of the first online document and saving it; Importing the first data in the first online document into the first system based on the first mapping relationship includes: creating a first import task to import the first data in the first online document into the first system; if the creation of the first import task is successful, a fourth prompt message is displayed; or if the creation of the first import task fails, a fifth prompt message is displayed. After importing the first data from the first online document into the first system based on the first mapping relationship, the process further includes: redirecting to a second interface of the first system, where the second interface displays an import task list.

6. The method according to claim 1, characterized in that, The second interface of the first system displays an import task list, which displays at least one of the following: the identifier of the import task, the object of the import task, the operation type of the import task, the operator of the import task, the creation time of the import task, the end time of the import task, the status of the import task, and a third control associated with the import task. The third control is used to view the details page of the associated import task or to view the original import data of the import task after being triggered.

7. The method according to claim 6, characterized in that, It satisfies at least one of the following: When the import task is in the import completed state, the third control is used to view the details page of the import task; otherwise, the third control is used to view the original import data of the import task. The details page of the import task includes at least one of the following: basic information, a link to the original import data, and the import results.

8. The method according to claim 7, characterized in that, View a snapshot of the original imported data before it was imported after the link to the original imported data is triggered. The import result includes a fourth control for viewing the import result file, which displays detailed import result information. If there is data that failed to be imported, the import result file also displays the reason for the import failure. The import results include a fourth control for viewing the import result file. The creator of the import result file is the robot. After the fourth control is triggered, the owner of the import result file is transferred to the user who triggered the fourth control.

9. The method according to claim 1, characterized in that, Also includes: In response to a second operational event based on the first system, determine the second data in the first system; Export the second data from the first system to the second online document.

10. The method according to claim 9, characterized in that, It satisfies at least one of the following: In response to a second operation event based on the first system, determining second data in the first system includes: in response to a trigger operation on a fifth control in the first system, displaying a third interface; and in response to a target object and / or target time range determined by the third interface, determining second data in the first system. After exporting the second data from the first system to the second online document, a sixth prompt message is sent in the communication client via a chatbot. If the export of the second data from the first system to the second online document is successful, a sixth control for viewing the export result is displayed in the sixth prompt message. If the export of the second data from the first system to the second online document fails, the sixth control is not displayed. The fourth interface of the first system displays an export task list, which displays at least one of the following: the identifier of the export task, the object of the export task, the operation type of the export task, the operator of the export task, the creation time of the export task, the end time of the export task, the status of the export task, a seventh control associated with the export task, and an eighth control associated with the export task. The seventh control is used to view the details page of its associated export task after being triggered, and the eighth control is used to re-execute the export task when the export task fails.

11. The method according to claim 10, characterized in that, It satisfies at least one of the following: If the export task fails, the details page of the export task will display: basic information and a ninth control for re-executing the export task; If the export task is successful, the details page of the export task will display: basic information and export results, including a tenth control for viewing the exported result file.

12. The method according to claim 1, characterized in that, The first system includes an application layer, a task management layer, a service layer, and a facility layer; The application layer is used to create import or export tasks; The task management layer is used to receive the import task or export task created by the application layer, determine the required service based on the import task or export task, and call the service to the service layer. The service layer is used to invoke services according to the instructions of the task management layer, and the services are used to interact with the task management layer or the facility layer. The facility layer is used to write or query data according to the instructions of the service layer.

13. The method according to claim 12, characterized in that, Creating a first mapping relationship between data fields in the first online document and data fields in the first system, including: In response to entering the interface for creating the first mapping relationship, the application layer sends a mapping configuration request to the task management layer; The task management layer calls the import / export service of the service layer; The import / export service obtains the metadata of the first system through the metadata service, and obtains the data fields of the first online document from the facility layer. It then parses the data fields of the first online document to obtain the data type, and returns the metadata, the data fields of the first online document, and the data type to the task management layer. The task management layer returns the metadata, the data fields and data types of the first online document to the application layer. The application layer creates the first mapping relationship based on the data fields of the first online document and the metadata, and performs data type validation based on the metadata and the data type of the first online document.

14. A data processing apparatus, comprising: The determining unit is configured to determine the first online document in response to a first operation event based on the first system; A control unit is configured to create a first mapping relationship between data fields in the first online document and data fields in the first system, wherein the first online document contains first data; The control unit is further configured to import the first data in the first online document into the first system based on the first mapping relationship; Wherein, the first online document is an online table, and the creation of the first mapping relationship between the data fields in the first online document and the data fields in the first system is to create the first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system, and satisfies at least one of the following: Creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system specifically includes: displaying the data rows and columns in the first online document, displaying an associated first control, wherein the first control is used to select data rows and columns in the first system; and creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns selected in the associated first control. The control unit is further configured to perform data verification after creating a first mapping relationship between the data rows and columns in the first online document and the data rows and columns in the first system, and before importing the first data in the first online document into the first system based on the first mapping relationship. The data verification includes at least one of the following: determining that the first data in the first online document is not empty; determining that the format of the first online document meets the format requirements; determining that the required data rows and columns in the first system and the data rows and columns in the first online document have a first mapping relationship; determining that the first data in the first online document imported does not have a unique identifier when the operation type of the first online document is adding data; and determining that the first data in the first online document imported has a unique identifier when the operation type of the first online document is modifying data.

15. An electronic device comprising: At least one memory and at least one processor; The at least one memory is used to store program code, and the at least one processor is used to call the program code stored in the at least one memory to execute the method of any one of claims 1 to 13.

16. A computer-readable storage medium for storing program code that, when executed by a processor, causes the processor to perform the method of any one of claims 1 to 13.

Images