Data processing method and device, equipment, medium and product

Abstract

The embodiment of the invention provides a data processing method and device, equipment, a medium and a product. The method comprises the steps of displaying a target interface in response to a data import request for a first table, wherein the target interface comprises at least one import information setting item; the import information setting item at least comprises an import data setting item, and the import data setting item is used for setting data to be imported into the first table; and receiving an information setting operation for the import data setting item through the target interface, determining target import data according to the information setting operation, and executing an operation of importing the target import data into the first table. According to the technical scheme provided by the embodiment of the invention, the effects of automatically determining the target import data and automatically importing the target import data into the first table can be realized only through simple interaction.

Description

Technical Field

[0001] The embodiments of the present disclosure relate to the field of computer processing technology, and in particular, to a data processing method, apparatus, device, medium, and product. Background Art

[0002] With the rapid development of Internet office, data analysis, processing and collection have become extremely important, and the application of spreadsheets has become more and more extensive. Users can store and manage data through spreadsheets, and support importing other data based on the original spreadsheets.

[0003] In the related art, when importing data into an original table, the data to be imported is usually copied manually, and then the copied data is pasted into the original table. This data import method may be time-consuming and laborious, and the import efficiency is low. Especially when the amount of data to be imported is large, the data import accuracy may be low, which affects the user's experience of using the table. Summary of the invention

[0004] The present disclosure provides a data processing method, apparatus, device, medium and product to achieve the effect of automatically importing target import data into a corresponding table when the target import data is determined based on an information setting operation.

[0005] In a first aspect, an embodiment of the present disclosure provides a data processing method, the method comprising:

[0006] In response to a data import request for a first table, a target interface is displayed; wherein the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table;

[0007] An information setting operation for the import data setting item is received through the target interface, target import data is determined according to the information setting operation, and an operation of importing the target import data into the first table is executed.

[0008] In a second aspect, an embodiment of the present disclosure further provides a data processing device, the device comprising:

[0009] A data import request module, configured to display a target interface in response to a data import request for a first table; wherein the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table;

[0010] The data import execution module is used to receive the information setting operation for the import data setting item through the target interface, determine the target import data according to the information setting operation, and execute the operation of importing the target import data into the first table.

[0011] In a third aspect, an embodiment of the present disclosure further provides an electronic device, the electronic device comprising:

[0012] one or more processors;

[0013] a storage device for storing one or more programs,

[0014] When the one or more programs are executed by the one or more processors, the one or more processors implement the data processing method as described in any one of the embodiments of the present disclosure.

[0015] In a fourth aspect, the embodiments of the present disclosure further provide a storage medium comprising computer executable instructions, which, when executed by a computer processor, are used to execute the data processing method as described in any one of the embodiments of the present disclosure.

[0016] In a fifth aspect, the embodiments of the present disclosure further provide a computer program product, including a computer program, which, when executed by a processor, implements the data processing method as described in any one of the embodiments of the present disclosure.

[0017] The technical solution of the disclosed embodiment, by responding to a data import request for a first table, displays a target interface including at least one import information setting item, the import information setting item at least including an import data setting item, and can visualize the setting process of importing data, thereby providing a data basis for subsequent execution of data import operations; further, receiving information setting operations for import data setting items through the target interface, determining target import data according to the information setting operations, and executing an operation of importing the target import data into the first table, thereby solving the problems of the data import method in the related art being laborious and time-consuming, low import efficiency, and low data import accuracy, and achieving the effect of automatically importing the target import data into the first table when the target import data is automatically determined with only simple interaction, thereby improving data import efficiency and import accuracy, and improving the intelligence and flexibility of the data import process, thereby improving the universality of the data import method. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and the originals and elements are not necessarily drawn to scale.

[0019] Figure 1 A flowchart of a data processing method provided by an embodiment of the present disclosure;

[0020] Figure 2 A schematic diagram of an effect of the import progress prompt information provided by an embodiment of the present disclosure;

[0021] Figure 3 A schematic diagram of an effect of the import result prompt information provided by an embodiment of the present disclosure;

[0022] Figure 4 A flowchart of another data processing method provided by an embodiment of the present disclosure;

[0023] Figure 5 A schematic diagram of a target interface provided by an embodiment of the present disclosure;

[0024] Figure 6 A flowchart of another data processing method provided by an embodiment of the present disclosure;

[0025] Figure 7 A schematic diagram of a target interface provided by an embodiment of the present disclosure;

[0026] Figure 8 A flowchart of another data processing method provided by an embodiment of the present disclosure;

[0027] Fig. 9 A schematic diagram of the structure of a data processing device provided by an embodiment of the present disclosure;

[0028] Fig.10 A schematic diagram of the structure of an electronic device provided by the embodiment of the present disclosure for implementing the embodiment of the present disclosure. DETAILED DESCRIPTION

[0029] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0030] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.

[0031] The term "including" and its variations used herein are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part 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". The relevant definitions of other terms will be given in the following description.

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

[0033] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0034] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0035] It is understandable that before using the technical solutions disclosed in the embodiments of the present disclosure, the types, scope of use, usage scenarios, etc. of the personal information involved in the present disclosure should be informed to the user and the user's authorization should be obtained in an appropriate manner in accordance with relevant laws and regulations.

[0036] For example, in response to receiving an active request from a user, a prompt message is sent to the user to clearly prompt the user that the operation requested to be performed will require obtaining and using the user's personal information. Thus, the user can autonomously choose whether to provide personal information to software or hardware such as an electronic device, application, server, or storage medium that performs the operation of the technical solution of the present disclosure according to the prompt message.

[0037] As an optional but non-limiting implementation, in response to receiving an active request from the user, the prompt information may be sent to the user in the form of a pop-up window, in which the prompt information may be presented in text form. In addition, the pop-up window may also carry a selection control for the user to choose "agree" or "disagree" to provide personal information to the electronic device.

[0038] It is understandable that the above notification and the process of obtaining user authorization are merely illustrative and do not constitute a limitation on the implementation of the present disclosure. Other methods that meet the relevant laws and regulations may also be applied to the implementation of the present disclosure.

[0039] It is understandable that the data involved in this technical solution (including but not limited to the data itself, the acquisition or use of the data) shall comply with the requirements of relevant laws, regulations and relevant provisions.

[0040] Figure 1 This is a flow chart of a data processing method provided by an embodiment of the present disclosure. The embodiment of the present disclosure is applicable to the scenario of importing data into a table. The method can be executed by a data processing device, which can be implemented in the form of software and / or hardware. Optionally, it can be implemented by an electronic device, which can be a mobile terminal, a PC or a server. Figure 1 As shown, the method of this embodiment may specifically include:

[0041] S110. In response to a data import request for a first table, display a target interface; wherein the target interface includes at least one import information setting item; and the import information setting item includes at least an import data setting item.

[0042] The first table may be a table that supports data import. In other words, the first table may be a table that supports automatic and / or manual import of data to be imported into the table. The first table may be any type of table. Optionally, the first table is an independent table or a subtable in the target table. The data import request may be understood as an instruction for requesting the execution of the data import operation. The data import request may include a generation method. Optionally, when a trigger operation for a preset data import control is detected, a data import request may be generated; or, when a trigger word associated with the imported data is detected in the received audio information, a data import request may be generated; or, when a data import trigger instruction input by a user (such as a shortcut instruction composed of at least one key) is received, a data import request may be generated. The target interface may be understood as a visual interface presented to the user end for receiving a data import operation. The target interface includes at least one import information setting item. The import information setting item may be used to set an operation entry for setting information associated with the data to be imported into the first table. The import information setting item may include at least one setting item for setting information associated with the data to be imported into the first table. The import information setting item at least includes an import data setting item. The import data setting item can be used to set the data to be imported into the first table. The import data setting item can be understood as an operation entry for setting the data to be imported into the first table. In the embodiment of the present disclosure, the data to be finally imported into the first table can be determined by inputting a setting operation into the import data setting item. The import data setting item can at least be used to set the identifier of the data to be imported into the first table and the range of the imported data.

[0043] As a possible implementation of the present disclosure, both the first table and the target table can be database tables, each column of the database table has a fixed field type, and the content filled in the cells of each column needs to correspond to the field type of the column. In other words, the field type can be used to define at least one of the information such as the data format, data type, and data content of the data filled in the cells of the column. Exemplarily, the field type can include but is not limited to one or more of the types such as text type, option type, date type, and numeric type.

[0044] As an optional implementation of an embodiment of the present disclosure, when a trigger operation for a preset data import control associated with the first table is detected, a data import request for the first table can be generated. Further, in response to the data import request, a target interface including an import data setting item is displayed. Furthermore, a setting operation for the import data setting item can be received based on the target interface to determine the data that is ultimately imported into the first table.

[0045] S120: receiving an information setting operation for an import data setting item through a target interface, determining target import data according to the information setting operation, and executing an operation of importing the target import data into a first table.

[0046] Among them, the information setting operation can be understood as an operation for setting the information associated with the data to be imported into the first table. The information setting operation may include an operation for setting a data identifier and an operation for setting the range of imported data. The operation for setting a data identifier may include a data identifier selection operation and / or a data identifier input operation, etc. The operation for setting the range of imported data may include a data range selection operation and / or a data selection operation, etc. The target imported data may be the data that is ultimately imported into the first table. The target imported data may be any type of data. Optionally, the target imported data may be at least part of the table data contained in any table; or, the target imported data may also be at least part of the document data in any document, etc.

[0047] In an embodiment of the present disclosure, when a target interface including an import data setting item is displayed, an information setting operation can be input for the import data setting item based on the target interface. Further, when an information setting operation for the import data setting item is received through the target interface, the target import data to be finally imported into the first table is determined in response to the information setting operation and based on the information setting operation. Further, an operation of importing the target import data into the first table can be performed to import the target import data into the first table.

[0048] As an optional implementation of the first embodiment of the present disclosure, when an information setting operation for an import data setting item is received through the target interface, the data identifier to be imported into the first table can be determined according to the information setting operation, and the data corresponding to the data identifier can be displayed. Further, a data selection operation can be input for the displayed data, and the selected data can be determined according to the data selection operation, and the selected data can be used as the target import data to be imported into the first table.

[0049] As another optional implementation of the disclosed embodiment, the imported data setting item may include a data identification setting item and a data range setting item. A data identification selection operation may be input for the data identification setting item through the target interface, and the data corresponding to the set data identification may be determined according to the data identification selection operation. Further, a data range selection operation may be input for the data range setting item through the target interface, and the data range imported into the first table may be selected according to the data range selection operation. Furthermore, the target import data may be determined according to the determined data and data range.

[0050] In the embodiment of the present disclosure, in order to enable the user to browse the execution status of the data import task more clearly and intuitively, during or after the operation of importing the target import data into the first table, it also includes: displaying import status prompt information corresponding to the target import data.

[0051] Among them, the import status prompt information includes import progress prompt information and / or import result prompt information. The import status prompt information can be used to prompt the execution status of the operation of importing the target import data into the first table. The import progress prompt information can be used to prompt the import progress of importing the target import data into the first table. Optionally, the import progress prompt information can include progress prompt information of the imported data or progress prompt information of the remaining imported data. The import progress prompt information can be based on any form to represent the import progress. Optionally, the import progress prompt information can represent the import progress in the form of a percentage; or, the import progress prompt information can also represent the import progress in the form of a ratio between the amount of imported data and the total amount of data, etc. The import result prompt information can be used to prompt the import result of importing the target import data into the first table. The import result prompt information can include import failure and / or import success.

[0052] It should be noted that, during the operation of importing the target import data into the first table, there may be at least one abnormal operation. When any abnormal operation is detected, an import failure prompt message can be generated to prompt the user that the corresponding target import data has not been successfully imported into the first table. Optionally, the abnormal operation includes the detection of table deletion, column change, source table deletion, restoration of historical records, etc. during the operation, the change of permissions during the operation, the triggering of the number of rows during the operation exceeds the limit, the error that the server cannot handle is detected during the operation, the operation process takes too long, and the operation process has partial failures (partial row addition failure or field matching operation failure, etc.). It should also be noted that when the system crashes and needs to be restarted and the target import data has not been completely imported into the first table, that is, the data import task corresponding to the target import data has not been completed, the unfinished data import task can be obtained after the system is restarted. Further, it is determined whether the data import task has timed out, and when it is determined that the data import task has not timed out, the data import task is re-executed to import the target import data corresponding to the data import task into the first table.

[0053] In the embodiment of the present disclosure, before the operation of importing the target import data into the first table is executed, the determined target import data may be one or more. When the number of the determined target import data is different, the displayed import status prompt information is also correspondingly different.

[0054] Optionally, when the determined target import data is one, the import progress prompt information corresponding to the target import data can be displayed during the operation of importing the target import data into the first table. Further, after the operation of importing the target import data into the first table is performed, the import result prompt information corresponding to the target import data can be displayed.

[0055] Optionally, in the case where there are multiple target import data, the operation of importing the corresponding target import data into the first table can be performed in sequence according to the determined time corresponding to the determined target import data. Further, in the process of executing the operation of importing multiple target import data into the first table, import progress prompt information corresponding to the target import data can be displayed. Afterwards, after executing the operation of importing multiple target import data into the first table, import result prompt information can be displayed, and the import result prompt information can include the data identifier corresponding to each target import data, the import result and / or the number of successful and / or failed imports in the multiple target import data. It should be noted that, in the case where there are multiple target import data, the displayed import progress prompt information can be prompt information including the import progress of each target import data; or, it can also be prompt information including only the import progress of the target import data currently being imported, etc.

[0056] As an optional implementation of the first embodiment of the present disclosure, in the case where the number of the determined target import data is multiple, the operation of importing the target import data into the first table can be performed in sequence according to the order of the determination time of the target import data. Further, in the process of executing the operation of importing the target import data into the first table, an import progress prompt information can be displayed, and the import progress prompt information can display the data identification and import progress of the target import data currently being imported and the data identification and waiting state of the target import data that has not performed the import operation. And, the displayed data identification can be displayed in sequence according to the import order of the target import data. Further, after executing the operation of importing the target import data into the first table, the data identification and import progress corresponding to the target import data can be removed from the import progress prompt information. Further, after executing the operation of importing the last target import data into the first table, the import result prompt information can be displayed according to the import results corresponding to the multiple target import data, and the data identification and import result corresponding to each target import data can be displayed in the import result prompt information, and the number of data successfully imported in the multiple target import data.

[0057] For example, Figure 2 This is a schematic diagram of the effect of the import progress prompt information provided by the embodiment of the present disclosure. Figure 2As shown, the number of target import data to be imported into the first table is 3, and the target import data corresponding to data table 4, the target import data corresponding to data table 6, and the target import data corresponding to data table 3 are sequentially imported according to the determination time of the three target import data. The operation of importing the target import data into the first table can be executed sequentially according to the determination time of the target import data. During the operation of importing the target import data corresponding to data table 4 into the first table, the import progress corresponding to data table 4 can be displayed in the form of percentage and progress bar, as shown in FIG. Figure 2 Further, when a trigger operation for the drop-down control is detected, the import progress of all target import data to be imported can be displayed, such as Figure 2 As shown in the right figure, the target import data corresponding to data table 4 is in the state of being imported, and the target import data corresponding to data table 6 and the target import data corresponding to data table 3 are in the state of waiting to be imported.

[0058] For example, Figure 3 This is a schematic diagram of the effect of the import result prompt information provided by the embodiment of the present disclosure. Figure 3 As shown in the left figure in , when the target import data corresponding to data table 4, the target import data corresponding to data table 6, and the target import data corresponding to data table 3 are all imported successfully, the import result can be displayed as all imported successfully, and the number of successfully imported target import data is displayed as 3. Figure 3 As shown in the right figure in , when the target import data corresponding to data table 4, the target import data corresponding to data table 6, and the target import data corresponding to data table 3 all fail to be imported, the import result can be displayed as all imports failed, and the number of target import data that have been successfully imported is displayed as 0. In addition, the failure prompt information corresponding to each target import data can be displayed (such as Figure 3 The exclamation mark in the right picture in the figure).

[0059] In an embodiment of the present disclosure, in order to ensure that the initiator of the data import request has the authority to perform the operation of importing the target imported data into the first table, and to ensure that the data imported into the first table complies with data security permissions, the target imported data can be verified before the operation of importing the target imported data into the first table is performed, and the operation of importing the target imported data into the first table is performed if the verification passes.

[0060] The data verification includes at least a data operation permission verification and a data security verification. The data operation permission verification can be used to verify the execution permission of the initiator of the data import request to import the target import data into the first table. The data security verification can be used to verify whether the target import data complies with the preset data security rules. The verification passing includes at least a data operation permission verification passing and a data security verification passing.

[0061] As an optional implementation of the first embodiment of the present disclosure, before the operation of importing the target imported data into the first table is executed, data verification including at least data operation authority verification and data security verification can be performed on the target imported data. Further, if the data verification passes, the operation of importing the target imported data into the first table is executed.

[0062] It should be noted that, in addition to the data displayed in the interface, the target imported data may also carry attachment data, and the data access identifier corresponding to the attachment data will be displayed in the target imported data. When it is determined that the number of target imported data imported into the first table is multiple, there may be a situation where the carried attachment data is the same attachment.

[0063] In view of the above situation, in the embodiment of the present disclosure, in the process of importing the target import data into the first table, the attachment data associated with the target import data can be determined, and the attachment deduplication operation can be performed, so that when the associated attachment data is consistent with the stored attachment data, the associated attachment data is not imported into the first table. Thereby, the resource storage space of the client can be effectively reduced, and the import efficiency is improved, and the intelligence and flexibility of the import operation are improved.

[0064] The technical solution of the disclosed embodiment, by responding to a data import request for a first table, displays a target interface including at least one import information setting item, the import information setting item at least including an import data setting item, and can visualize the setting process of importing data, thereby providing a data basis for subsequent execution of data import operations; further, receiving information setting operations for import data setting items through the target interface, determining target import data according to the information setting operations, and executing an operation of importing the target import data into the first table, thereby solving the problems of the data import method in the related art being laborious and time-consuming, the import efficiency being low, and the data import accuracy being low, and achieving the effect of automatically determining the target import data and automatically importing the target import data into the first table with only simple interaction, thereby improving the data import efficiency and the import accuracy, improving the intelligence and flexibility of the data import process, and improving the universality of the data import method.

[0065] Figure 4A flowchart of another data processing method provided by the embodiment of the present disclosure. The technical solution of this embodiment is based on the above-mentioned embodiment, and the import data setting item includes an import table setting item; further, the second table to be imported into the first table can be determined by inputting information setting operation to the import table setting item, and further, the target import data can be determined according to the table data in the second table, so as to import the target import data which is the table data into the first table. The specific implementation method can be referred to the description of this embodiment. Among them, the technical features that are the same or similar to the above-mentioned embodiments are not repeated here. Figure 4 As shown, the method of this embodiment may specifically include:

[0066] S210. In response to a data import request for a first table, display a target interface; wherein the target interface includes at least one import information setting item; the import information setting item includes at least an import data setting item; and the import data setting item includes an import table setting item.

[0067] Among them, the import table setting item is used to set the second table where the data to be imported into the first table is located. The import table setting item can be understood as an operation entry for setting the second table where the data to be imported into the first table is located. Optionally, the import table setting item may include a table identification setting item and a data range setting item. The table identification setting item can be used to set the table identification corresponding to the second table where the data to be imported into the first table is located. The data range setting item can be used to set the data range corresponding to the data to be imported into the first table.

[0068] S220, receiving an information setting operation for an import table setting item through a target interface, determining a second table according to the information setting operation, determining target import data according to table data in the second table, and executing an operation of importing the target import data into the first table.

[0069] Among them, the second table can be a table where the data to be imported into the first table is located. That is to say, in the embodiment of the present disclosure, at least part of the table data in the second table can be used as target import data to be imported into the first table. The first table can be any type of table. Optionally, the first table is an independent one-dimensional table or one of the sub-tables in a target table including multiple sub-tables. In the embodiment of the present disclosure, when a target interface including a table setting item is displayed, an information setting operation can be input for the table setting item based on the target interface. Further, when an information setting operation for an import table setting item is received through the target interface, the second table and the table data in the second table to be imported into the first table can be determined according to the information setting operation. Further, the target import data can be determined based on the table data in the determined second table, and an operation of importing the target import data into the first table can be performed.

[0070] Optionally, the imported table setting item includes a table identification setting item and a data range setting item; receiving an information setting operation for the imported table setting item through the target interface, determining the second table according to the information setting operation, and determining the target imported data according to the table data in the second table, including: receiving an information setting operation for the table identification setting item through the target interface, determining the second table corresponding to the configured target table identification; receiving an information setting operation for the data range setting item through the target interface, and determining the target imported data according to the second table and the configured data range. The advantage of such a setting is that it can be based on the information setting operation

[0071] Among them, the information setting operation for the table identification setting item may include an identification selection operation for the table identification setting item and / or an identification input operation for the table identification setting item. The target table identification can be used to identify the table to be imported into the first table. In the case where the type of the table to be imported into the first table is the target table, the table identification setting item may include a target table identification setting item corresponding to the target table and a sub-table identification setting item corresponding to the sub-table of the target table. Correspondingly, the information setting operation for the table identification setting item may include an information setting operation for the target table identification setting item and an information setting operation for the sub-table identification setting item in the target table. Further, the target table identification configured based on the information setting operation may include a target table identification and a sub-table identification. The target table identification may be any form of information, optionally, at least one of text, numbers or English. The table corresponding to the target table identification is the second table. The information setting operation for the data range setting item may include a range selection operation for the data range setting item and / or a data selection operation for the table data of the second table corresponding to the configured target table identification. The configured data range may be the data range corresponding to the data to be imported into the first table. Optionally, when the imported second table is a sub-table in the target table, the data range may be at least a portion of the table data contained in the sub-table.

[0072] As an optional implementation of an embodiment of the present disclosure, in the case of detecting an information setting operation for a table identifier setting item, at least one candidate table identifier may be displayed. Further, in the case of detecting an identifier selection operation for a candidate table identifier, the selected candidate table identifier may be used as a target table identifier, and a table corresponding to the target table identifier may be determined as a second table. Further, in the case of detecting an information setting operation for a data range setting item, at least one candidate data range corresponding to the second table may be displayed. Further, in the case of detecting a range selection operation for a candidate data range, the selected candidate data range may be used as a configured data range. Further, based on the configured data range, table data within the data range may be determined from the second table, and the determined table data may be used as target import data.

[0073] It should be noted that, when the selected candidate data range is all data, the all data may represent the table data displayed in the client by the second table, and the all data may be at least part of the table data in the all table data included in the second table. For the table data included in the second table and not imported into the first table, these table data may be hidden and displayed so that these table data are not included in the all data imported into the first table.

[0074] As another optional implementation of the disclosed embodiment, when an information setting operation for a table identification setting item is detected, the table identification setting item can be used as an input box. Further, the input box can receive an identification input operation to input a table identification in the input box. When the input completion operation is detected, the table identification displayed in the input box is used as the target table identification, and the table corresponding to the target table identification is determined as the second table. Further, when an information setting operation for a data range setting item is detected, table data corresponding to the second table can be displayed. Afterwards, a data selection operation can be input for the displayed table data, and the selected table data can be used as target import data.

[0075] For example, Figure 5 This is a schematic diagram of a target interface provided by an embodiment of the present disclosure. It is particularly suitable for the case where the second table is a subtable in the target table. Figure 5As shown, the target interface includes an import table setting item 51. The import table setting item 51 includes a table identification setting item 511 and a data range setting item 512. The table identification setting item 511 includes a target table identification setting item 5111 and a data table identification setting item 5112. When an information setting operation for the target table identification setting item 5111 is detected, three candidate target table identifications can be displayed, namely, target table 1, target table 2, and target table 3. Further, when a trigger operation for target table 2 is detected, target table 2 is displayed in the target table identification setting item 5111, and the target table corresponding to target table 2 is used as the target table where the second table is located. Further, when an information setting operation for the data table identification setting item 5112 is detected, the four data table identifications contained in target table 2 can be displayed, namely, data table 1, data table 2, data table 3, and data table 4. Further, when a trigger operation for data table 4 is detected, data table 4 is displayed in data table identification setting item 5112, and the data table corresponding to data table 4 is used as the second table where the data to be imported into the first table is located. Further, when an information setting operation for data range setting item 512 is detected, the identifiers corresponding to the three data ranges corresponding to data table 4 can be displayed, which are all data, table 1 and table 2. Thereafter, when a selection trigger operation for all data is detected, the identifiers corresponding to all data are displayed in data range setting item 512. Further, when a setting completion instruction is received, all data corresponding to data table 4 can be used as target import data.

[0076] The technical solution of the disclosed embodiment receives an information setting operation for an import table setting item through a target interface, determines a second table according to the information setting operation, determines target import data according to table data in the second table, and executes an operation of importing the target import data into the first table, thereby achieving an effect of automatically importing table data in other tables into the first table, thereby improving the intelligence and flexibility of the data import process and enhancing the universality of the data import method.

[0077] Figure 6 A flowchart of another data processing method provided by an embodiment of the present disclosure. The technical solution of this embodiment is based on the above embodiment, and the import information setting item also includes an import rule setting item; the operation of importing the target import data into the first table includes: receiving the information setting operation for the import rule setting item through the target interface, and importing the target import data into the first table according to the set data import rule. The specific implementation method can be found in the description of this embodiment. Among them, the technical features that are the same or similar to the above embodiments are not repeated here. Figure 6 As shown, the method of this embodiment may specifically include:

[0078] S310. In response to a data import request for a first table, display a target interface; wherein the target interface includes at least one import information setting item; the import information setting item includes at least an import data setting item; the import information setting item also includes an import rule setting item.

[0079] The import rule setting item is used to set the rules for importing the data to be imported into the first table into the first table. The import rule setting item can be understood as an operation entry for setting the import rule based on which the data to be imported into the first table is imported into the first table. The import rule setting item may include at least one setting item for setting the import rule, and optionally, a field matching setting item.

[0080] In an embodiment of the present disclosure, when a data import request for a first table is detected, a target interface including at least one import information setting item is displayed in response to the data import request, and the displayed import information setting item may include an import data setting item and an import rule setting item. Furthermore, an operation of importing the determined data into the first table can be performed by inputting information setting operations for the import data setting item and the import rule setting item.

[0081] S320, receiving an information setting operation for an import data setting item through a target interface, determining target import data according to the information setting operation, receiving an information setting operation for an import rule setting item through a target interface, and importing the target import data into a first table according to the set data import rule.

[0082] The information setting operation for the import rule setting item may include a rule selection operation and / or a rule input operation. The data import rule may be used to indicate an import operation of importing data to be imported into the first table into the first table. The data import rule may be used to specify a format, requirement and / or data processing method according to which the data to be imported into the first table is imported into the first table.

[0083] In the embodiment of the present disclosure, when the target import data is determined according to the information setting operation for the import data setting item, the information setting operation can be input for the import rule setting item through the target interface. Further, when the information setting operation for the import rule setting item is received, the data import rule can be determined according to the information setting operation. Then, the target import data can be imported into the first table according to the data import rule.

[0084] In an embodiment of the present disclosure, the data import rule based on which the data to be imported into the first table is imported into the first table may include at least one, optionally, a field matching rule or a data position matching rule.

[0085] Optionally, the import rule setting item includes a field matching setting item; receiving an information setting operation for the import rule setting item through the target interface, and importing the target import data into the first table according to the set data import rule, including: receiving an information setting operation for the field matching setting item through the target interface, and importing the target import data into the first table according to the correspondence between the first field in the set first table and the second field in the data to be imported into the first table. The advantage of such a setting is that the effect of importing the target import data into the corresponding table according to the field matching rule is achieved, thereby improving the data import efficiency and import accuracy.

[0086] Among them, the field matching setting item is used to set the corresponding relationship between the first field in the first table and the second field in the data to be imported into the first table. The field matching setting item can be understood as an operation entry for setting the corresponding relationship between the first field in the first table and the second field in the data to be imported into the first table. That is to say, the mapping relationship between the first field and the second field can be defined by inputting an information setting operation for the field matching setting item. The first field can be a table field included in the first table, and the table field can be used to indicate the data type and data content of the corresponding row or column in the first table. The second field can be a data field in the data to be imported into the first table, and the data field can be used to indicate the corresponding data type and data content under the corresponding field. Exemplarily, in the case where the data to be imported into the first table is table data, the second field can be a table field included in the table data. In the embodiment of the present disclosure, the relationship between the first field and the second field can be set by the information setting operation for the field matching setting item. Then, at least one set of first field and second field with a corresponding relationship is obtained.

[0087] As an optional implementation of an embodiment of the present disclosure, an information setting operation can be input for a field matching setting item based on a target interface to set a correspondence between a first field in a first table and a second field in the data to be imported into the first table according to the information setting operation. Further, in the case of receiving an information setting operation for a field matching setting item, at least one set of first fields and second fields having a correspondence can be determined according to the information setting operation. Further, the data corresponding to the second field in the target imported data can be imported into the corresponding first field in the first table according to the correspondence between the set first field and the second field.

[0088] It should be noted that in order to be able to effectively import the target import data into the first table accurately based on the correspondence between the first field and the second field, at least one field attribute information corresponding to the first field and the second field having a corresponding relationship may be the same. Field attribute information may be any information associated with field attribute characteristics, optionally, a data type or a data format, etc. In an embodiment of the present disclosure, the first field and the second field having a corresponding relationship have the same data type. Among them, the data types may include numeric type, date type, time type, string type, logical type, text type, and option type, etc. Exemplarily, when the data type corresponding to the first field is text type, the data type corresponding to the second field having a corresponding relationship with the first field is also text type.

[0089] In the disclosed embodiment, when inputting information setting operation for the field matching setting item, the corresponding second field can be set according to the data type corresponding to the first field, thereby obtaining a first field and a second field with a corresponding relationship and the same data type.

[0090] Optionally, the field matching setting item includes a first field and a field selection control corresponding to the first field; after determining the target import data according to the information setting operation, it also includes: determining the data type corresponding to the first field, and determining the candidate field corresponding to the first field from the data to be imported into the first table according to the data type; when receiving a control trigger operation for the field selection control, displaying the candidate field corresponding to the first field corresponding to the triggered field selection control. The advantage of such a setting is that it achieves the effect of making the data types corresponding to the two fields that are set to have a corresponding relationship the same through simple interactive operations, reducing the operational difficulty of the field matching process and improving the intelligence of the data import method.

[0091] The field selection control may be used to select and display fields in the data to be imported into the first table. The candidate fields may be fields in the data to be imported into the first table that have the same data type as the first field.

[0092] As an optional implementation of an embodiment of the present disclosure, after determining the target import data, for at least one first field included in the first table, the data type corresponding to the first field can be determined. Further, based on the data type, a field consistent with the data type can be determined from the fields included in the target import data, and the determined field can be used as a candidate field corresponding to the first field. Further, in the case of receiving a control trigger operation for a field selection control, the candidate field corresponding to the first field corresponding to the triggered field selection control can be displayed. Further, in the case of detecting a field selection operation for a candidate field, the selected candidate field can be used as a second field corresponding to the first field.

[0093] For example, Figure 7 This is a schematic diagram of a target interface provided by an embodiment of the present disclosure. Figure 7As shown, the target interface includes a field matching setting item 71. The field matching setting item 71 includes a first field 711 and a field selection control 712 corresponding to the first field 711. The first field 711 may include four first fields, namely, a first field A, a first field B, a first field C, and a first field D. First, it is determined that the data type corresponding to the first field A is a text type. When a control trigger operation is detected for the field selection control 712 corresponding to the first field A, two candidate second fields corresponding to the text type may be displayed, namely, a second field A1 and a second field A2. Thereafter, when a selection trigger operation is detected for the second field A2, the second field A2 may be displayed in the field selection control 712 corresponding to the first field A, and the second field A2 may be used as the second field corresponding to the first field A. It is determined that the data type corresponding to the first field B is a personnel type. When a control trigger operation is detected for the field selection control 712 corresponding to the first field B, two candidate second fields corresponding to the personnel type may be displayed, namely, a second field B1 and a second field B2. Afterwards, when a selection trigger operation for the second field B1 is detected, the second field B1 can be displayed in the field selection control 712 corresponding to the first field B, and the second field B1 can be used as the second field corresponding to the first field B. It is determined that the data type corresponding to the first field C is a single-select type. When a control trigger operation for the field selection control 712 corresponding to the first field C is detected, three candidate second fields corresponding to the single-select type can be displayed, namely, the second field C1, the second field C2, and the second field C3. Afterwards, when a selection trigger operation for the second field C2 is detected, the second field C2 can be displayed in the field selection control 712 corresponding to the first field C, and the second field C2 can be used as the second field corresponding to the first field C. It is determined that the data type corresponding to the first field D is a date type. When a control trigger operation for the field selection control 712 corresponding to the first field D is detected, three candidate second fields corresponding to the date type can be displayed, namely, the second field D1, the second field D2, and the second field D3. Afterwards, when a selection trigger operation for the second field D3 is detected, the second field D3 can be displayed in the field selection control 712 corresponding to the first field D, and the second field D3 can be used as the second field corresponding to the first field D.

[0094] The technical solution of the disclosed embodiment receives information setting operations for import data setting items through a target interface, determines target import data according to the information setting operations, receives information setting operations for import rule setting items through a target interface, and imports the target import data into a first table according to the set data import rules, thereby achieving the effect of setting import rules through simple interactive operations, simplifying the operating steps of the import rule setting process, reducing the operating difficulty of the import rule setting process, and thereby improving data import efficiency and import accuracy.

[0095] Figure 8 A flowchart of another data processing method provided by an embodiment of the present disclosure. The technical solution of this embodiment is based on the above-mentioned embodiment, and performs an operation of importing target import data into the first table data, including: when form limit filling data is set at the data import position in the first table and the target import data at the data import position is not included in the form limit filling data, the target import data is added to the form limit filling data; when the form limit filling data includes the target import data, the target import data is filled in the data import position. The specific implementation method can be found in the description of this embodiment. Among them, the technical features that are the same or similar to those of the above-mentioned embodiments are not repeated here. Figure 8 As shown, the method of this embodiment may specifically include:

[0096] S410. In response to a data import request for a first table, display a target interface; wherein the target interface includes at least one import information setting item; and the import information setting item includes at least an import data setting item.

[0097] S420. Receive an information setting operation for an import data setting item through a target interface, determine target import data according to the information setting operation, and when form limit filling data is set at a data import position in a first table and the target import data at the data import position is not included in the form limit filling data, add the target import data to the form limit filling data.

[0098] Among them, the data import position can be understood as the position in the first form where data is to be imported. The form-limited data can be understood as the data that is limited to be filled in the form. The form-limited data is the data that is allowed to be filled in the data import position. In other words, only the data included in the form-limited data can be filled in the form. Exemplarily, when the data type corresponding to the data import position is an option type, the form-limited data set at the data import position can include 3 candidate options, namely option A, option B and option C. Furthermore, the data imported at the data position is only allowed to be filled in any one of option A, option B and option C.

[0099] It should be noted that form-limited filling data may be set at the data import position in the first form, and thus, when filling data into the data import position in the first form, only the set form-limited filling data can be selected. The data setting rules of the target imported data to be imported into the first form may be different from the data setting rules in the first form. Furthermore, there may be a situation where the form-limited filling data set at the data import position in the first form does not include the target imported data at the data import position, thereby causing the target imported data to be unable to be filled into the data import position.

[0100] In view of the above situation, as an optional implementation of an embodiment of the present disclosure, when the target import data is determined according to the information setting operation, it can be determined whether the form limit filling data is set at the data import position in the first table. Further, when it is determined that the form limit filling data is set at the data import position, it can be determined whether the target import data at the data import position is included in the form limit filling data. Further, when the target import data at the data import position is not included in the form limit filling data, the target import data can be added to the form limit filling data so that the target import data is included in the added form limit filling data.

[0101] Exemplarily, continuing to refer to the above example, it is assumed that the form-limited filling data set at the data import position includes 3 candidate options, namely, option A, option B, and option C, and the target import data at the data import position includes 2 candidate options, namely, option 1 and option 2. Furthermore, it can be determined that the target import data is not included in the form-limited filling data, and further, the target import data can be added to the form-limited filling data, that is, option 1 and option 2 are added to option A, option B, and option C, so that the added form-limited filling data includes option A, option B, option C, option 1, and option 2.

[0102] S430: When the form limited fill-in data includes the target import data, fill the target import data into the data import position.

[0103] In the embodiment of the present disclosure, when the form limited fill-in data includes target import data, the target import data can be filled in the data import position to import the target import data into the first form.

[0104] The technical solution of the disclosed embodiment achieves the effect of adding the target import data to the form limit-fill data when form limit-fill data is set at the data import position in the first table and the target import data at the data import position is not included in the form limit-fill data, and fills the target import data into the data import position when the form limit-fill data includes the target import data. This improves the flexibility and intelligence of the data import process.

[0105] Fig. 9 A structural diagram of a data processing device provided by an embodiment of the present disclosure is shown in FIG. Fig. 9 As shown, the data processing device includes: a data import request module 510 and a data import execution module 520. The data import request module 510 is used to display a target interface in response to a data import request for a first table; the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table; the data import execution module 520 is used to receive an information setting operation for the import data setting item through the target interface, determine the target import data according to the information setting operation, and execute the operation of importing the target import data into the first table.

[0106] The technical solution of the disclosed embodiment, by responding to a data import request for a first table, displays a target interface including at least one import information setting item, the import information setting item at least including an import data setting item, and can visualize the setting process of importing data, thereby providing a data basis for subsequent execution of data import operations; further, receiving information setting operations for import data setting items through the target interface, determining target import data according to the information setting operations, and executing an operation of importing the target import data into the first table, thereby solving the problems of the data import method in the related art being laborious and time-consuming, the import efficiency being low, and the data import accuracy being low, and achieving the effect of automatically determining the target import data through simple interactive operations and automatically importing the target import data into the first table, thereby improving the data import efficiency and import accuracy, improving the intelligence and flexibility of the data import process, and improving the universality of data import operations.

[0107] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the import data setting item includes an import table setting item; the import table setting item is used to set the second table where the data to be imported into the first table is located. Further, the data import execution module 520 can be specifically used to receive an information setting operation for the import table setting item through the target interface, determine the second table according to the information setting operation, and determine the target import data according to the table data in the second table.

[0108] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the import table setting item includes a table identification setting item and a data range setting item. Further, the data import execution module 520 may include: a second table determination unit and an import data determination unit. Among them, the second table determination unit is used to receive the information setting operation for the table identification setting item through the target interface, and determine the second table corresponding to the configured target table identification; the import data determination unit is used to receive the information setting operation for the table identification setting item through the target interface, and determine the target import data according to the second table and the configured data range.

[0109] Based on any optional technical solution in the embodiment of the present disclosure, optionally, the import information setting item also includes an import rule setting item; the import rule setting item is used to set the method of importing the data to be imported into the first table into the first table. Further, the data import execution module 520 can be specifically used to receive the information setting operation for the import rule setting item through the target interface, and import the target import data into the first table according to the set data import rule.

[0110] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the import rule setting item includes a field matching setting item; the field matching setting item is used to set the correspondence between the first field in the first table and the second field in the data to be imported into the first table. Further, the data import execution module 520 can be specifically used to receive an information setting operation for the field matching setting item through the target interface, and import the target import data into the first table according to the set correspondence between the first field in the first table and the second field in the data to be imported into the first table.

[0111] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the data types corresponding to the first field and the second field that have a corresponding relationship are the same.

[0112] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the field matching setting item includes a first field and a field selection control corresponding to the first field. Furthermore, the data processing device may also include: a data type determination module and a candidate field display module. Among them, the data type determination module is used to determine the data type corresponding to the first field after the target import data is determined according to the information setting operation, and determine the candidate field corresponding to the first field from the data to be imported into the first table according to the data type; the candidate field display module is used to display the candidate field corresponding to the first field corresponding to the triggered field selection control when a control trigger operation for the field selection control is received.

[0113] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the data import execution module 520 includes: a data filling unit and a data adding unit. The data filling unit is used to add the target imported data to the form-limited filling data when the form-limited filling data is set at the data import position in the first form and the target imported data is not included in the form-limited filling data; the data import position is the filling position of the target imported data in the first form; the form-limited filling data is the data allowed to be filled in the data import position; the data adding unit is used to fill the target imported data into the data import position when the form-limited filling data includes the target imported data.

[0114] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the data processing device further includes: a prompt information display module. The prompt information display module can be specifically used to display import status prompt information corresponding to the target import data during or after the operation of importing the target import data into the first table, wherein the import status information includes import progress prompt information and / or import result prompt information.

[0115] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the data processing device further includes: a data verification module. The data verification module can be specifically used to perform data verification on the target imported data before the operation of importing the target imported data into the first table is executed, and the operation of importing the target imported data into the first table is executed if the verification passes; wherein the data verification at least includes data operation authority verification and data security verification.

[0116] The data processing device provided in the embodiments of the present disclosure can execute the data processing method provided in any embodiment of the present disclosure, and has the corresponding functional modules and beneficial effects for executing the data processing method.

[0117] It is worth noting that the various units and modules included in the above-mentioned device are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the protection scope of the embodiments of the present disclosure.

[0118] Reference below Fig.10 , which shows an electronic device (eg, Fig.10 The terminal device in the embodiment of the present disclosure may include but is not limited to mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Fig.10 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0119] like Fig.10 As shown, the electronic device 600 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 601, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage device 606 into a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the electronic device 600 are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0120] Typically, the following devices may be connected to the I / O interface 605: an input device 606 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 607 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 606 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 609. The communication device 609 may allow the electronic device 600 to communicate with other devices wirelessly or by wire to exchange data. Although Fig.10 The electronic device 600 is shown with various devices, but 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 instead.

[0121] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device 609, or installed from a storage device 606, or installed from a ROM 602. When the computer program is executed by the processing device 601, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

[0122] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0123] The electronic device provided in the embodiment of the present disclosure and the data processing method provided in the above embodiment belong to the same inventive concept. The technical details not fully described in the embodiment of the present disclosure can be referred to the above embodiment, and the present embodiment has the same beneficial effects as the above embodiment.

[0124] The embodiments of the present disclosure provide a computer storage medium on which a computer program is stored. When the program is executed by a processor, the data processing method provided by the above embodiments is implemented.

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

[0126] According to one or more embodiments of the present disclosure, [Example 1] provides a data processing method, comprising: in response to a data import request for a first table, displaying a target interface; wherein the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table;

[0127] An information setting operation for the import data setting item is received through the target interface, target import data is determined according to the information setting operation, and an operation of importing the target import data into the first table is executed.

[0128] According to one or more embodiments of the present disclosure, [Example 2] provides the method of Example 1, further including: optionally, the import data setting item includes an import table setting item; the import table setting item is used to set a second table where the data to be imported into the first table is located; the receiving of an information setting operation for the import data setting item through the target interface, and determining the target import data according to the information setting operation, includes: receiving an information setting operation for the import table setting item through the target interface, determining the second table according to the information setting operation, and determining the target import data according to the table data in the second table.

[0129] According to one or more embodiments of the present disclosure, [Example Three] provides the method of Example Two, further including: optionally, the import table setting item includes a table identification setting item and a data range setting item; the information setting operation for the import table setting item is received through the target interface, a second table is determined according to the information setting operation, and the target imported data is determined according to the table data in the second table, including: receiving the information setting operation for the table identification setting item through the target interface, and determining the second table corresponding to the configured target table identification; receiving the information setting operation for the table identification setting item through the target interface, and determining the target imported data according to the second table and the configured data range.

[0130] According to one or more embodiments of the present disclosure, [Example 4] provides the method of Example 1, further including: optionally, the import information setting item also includes an import rule setting item; the import rule setting item is used to set a rule for importing the data to be imported into the first table into the first table; the importing of the target import data into the first table includes: receiving an information setting operation for the import rule setting item through the target interface, and importing the target import data into the first table according to the set data import rule.

[0131] According to one or more embodiments of the present disclosure, [Example Five] provides the method of Example Four, further including: optionally, the import rule setting item includes a field matching setting item; the field matching setting item is used to set the correspondence between the first field in the first table and the second field in the data to be imported into the first table; the information setting operation for the import rule setting item is received through the target interface, and the target imported data is imported into the first table according to the set data import rule, including: receiving the information setting operation for the field matching setting item through the target interface, and importing the target imported data into the first table according to the set correspondence between the first field in the first table and the second field in the data to be imported into the first table.

[0132] According to one or more embodiments of the present disclosure, [Example 6] provides the method of Example 5, further including: optionally, the data types corresponding to the first field and the second field that have a corresponding relationship are the same.

[0133] According to one or more embodiments of the present disclosure, [Example 7] provides the method of Example 5, further including: optionally, the field matching setting item includes a first field and a field selection control corresponding to the first field; after the target import data is determined according to the information setting operation, it also includes: determining the data type corresponding to the first field, and determining the candidate field corresponding to the first field from the data to be imported into the first table according to the data type; when a control trigger operation for the field selection control is received, the candidate field corresponding to the first field corresponding to the triggered field selection control is displayed.

[0134] According to one or more embodiments of the present disclosure, [Example 8] provides the method of Example 1, further including: optionally, the operation of importing the target import data into the first table includes: when form limit fill-in data is set at the data import position in the first table and the target import data is not included in the form limit fill-in data, adding the target import data to the form limit fill-in data; wherein, the data import position is the filling position of the target import data in the first table; the form limit fill-in data is data allowed to be filled in the data import position; when the form limit fill-in data contains the target import data, filling the target import data into the data import position.

[0135] According to one or more embodiments of the present disclosure, [Example 9] provides the method of Example 1, further including: optionally, during or after the operation of importing the target import data into the first table, it also includes: displaying import status prompt information corresponding to the target import data, wherein the import status information includes import progress prompt information and / or import result prompt information.

[0136] According to one or more embodiments of the present disclosure, [Example 10] provides the method of Example 1, further including: optionally, before executing the operation of importing the target imported data into the first table, it also includes: performing data verification on the target imported data, and executing the operation of importing the target imported data into the first table if the verification passes; wherein the data verification includes at least data operation permission verification and data security verification.

[0137] According to one or more embodiments of the present disclosure, [Example 11] provides a data processing device, including: a data import request module, used to display a target interface in response to a data import request for a first table; wherein the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table; a data import execution module, used to receive an information setting operation for the import data setting item through the target interface, determine the target import data according to the information setting operation, and execute the operation of importing the target import data into the first table.

[0138] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (Hyper Text Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0139] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0140] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: displays a target interface in response to a data import request for the first table; wherein the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table;

[0141] An information setting operation for the import data setting item is received through the target interface, target import data is determined according to the information setting operation, and an operation of importing the target import data into the first table is executed.

[0142] Computer program code for performing the operations of the present disclosure may be written in one or more programming languages ​​or a combination thereof, including, but not limited to, object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate 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 a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0143] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0144] The units involved in the embodiments described in the present disclosure may be implemented by software or hardware. The name of a unit does not limit the unit itself in some cases. For example, a data import request module may also be described as a "module that responds to a data import request."

[0145] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

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

[0147] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.

[0148] In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.

[0149] Although the subject matter has been described in language specific to structural features and / or methodological logical actions, 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. On the contrary, the specific features and actions described above are merely example forms of implementing the claims.

Claims

1. A data processing method, characterized in that: include: In response to a data import request for a first table, a target interface is displayed; wherein the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table; An information setting operation for the import data setting item is received through the target interface, target import data is determined according to the information setting operation, and an operation of importing the target import data into the first table is executed.

2. The data processing method according to claim 1, characterized in that: The import data setting item includes an import table setting item; the import table setting item is used to set the second table where the data to be imported into the first table is located; The step of receiving, through the target interface, an information setting operation for the imported data setting item and determining target imported data according to the information setting operation includes: An information setting operation for the import table setting item is received through the target interface, a second table is determined according to the information setting operation, and target import data is determined according to the table data in the second table.

3. The data processing method according to claim 2, characterized in that: The import table setting items include a table identification setting item and a data range setting item; The step of receiving, through the target interface, an information setting operation for the import table setting item, determining a second table according to the information setting operation, and determining target import data according to table data in the second table includes: receiving, through the target interface, an information setting operation for the table identifier setting item, and determining a second table corresponding to the configured target table identifier; An information setting operation for the data range setting item is received through the target interface, and target import data is determined according to the second table and the configured data range.

4. The data processing method according to claim 1, characterized in that: The import information setting item further includes an import rule setting item; the import rule setting item is used to set a rule for importing the data to be imported into the first table into the first table; The step of importing the target import data into the first table includes: An information setting operation for the import rule setting item is received through the target interface, and the target import data is imported into the first table according to the set data import rule.

5. The data processing method according to claim 4, characterized in that: The import rule setting item includes a field matching setting item; the field matching setting item is used to set the correspondence between the first field in the first table and the second field in the data to be imported into the first table; The step of receiving the information setting operation for the import rule setting item through the target interface and importing the target import data into the first table according to the set data import rule includes: An information setting operation for the field matching setting item is received through the target interface, and the target import data is imported into the first table according to the correspondence between the first field in the set first table and the second field in the data to be imported into the first table.

6. The data processing method according to claim 5, characterized in that: The first field and the second field that have a corresponding relationship have the same data type corresponding to them.

7. The data processing method according to claim 5, characterized in that: The field matching setting item includes a first field and a field selection control corresponding to the first field; After the target import data is determined according to the information setting operation, the method further includes: Determine a data type corresponding to the first field, and determine a candidate field corresponding to the first field from the data to be imported into the first table according to the data type; When a control triggering operation for the field selection control is received, the candidate field corresponding to the first field corresponding to the triggered field selection control is displayed.

8. The data processing method according to claim 1, characterized in that: The step of importing the target import data into the first table includes: In the case where form-limited filling data is set at the data import position in the first form and the target import data at the data import position is not included in the form-limited filling data, the target import data is added to the form-limited filling data; wherein the data import position is the filling position of the target import data in the first form; the form-limited filling data is the data that is allowed to be filled in the data import position; In the case where the form limited fill-in data includes the target import data, the target import data is filled into the data import position.

9. The data processing method according to claim 1, characterized in that: During or after the operation of importing the target import data into the first table, the method further includes: Import status prompt information corresponding to the target imported data is displayed, wherein the import status information includes import progress prompt information and / or import result prompt information.

10. The data processing method according to claim 1, characterized in that: Before the operation of importing the target import data into the first table is executed, the method further includes: Performing data verification on the target imported data, and if the verification passes, importing the target imported data into the first table; wherein the data verification at least includes data operation authority verification and data security verification.

11. A data processing device, characterized in that: include: A data import request module, configured to display a target interface in response to a data import request for a first table; wherein the target interface includes at least one import information setting item; the import information setting item at least includes an import data setting item, and the import data setting item is used to set the data to be imported into the first table; The data import execution module is used to receive the information setting operation for the import data setting item through the target interface, determine the target import data according to the information setting operation, and execute the operation of importing the target import data into the first table.

12. An electronic device, characterized in that: The electronic device comprises: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the data processing method according to any one of claims 1 to 10.

13. A storage medium containing computer executable instructions, characterized in that: When the computer executable instructions are executed by a computer processor, they are used to perform the data processing method according to any one of claims 1 to 10.

14. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the computer program implements the data processing method according to any one of claims 1 to 10.

Images