Table data cross-system migration method and device

Abstract

The invention provides a table data cross-system migration method and device. The method comprises the following steps: detecting whether a click event occurs on a table at a desktop end in real time, and when the click event is detected, recording table coordinates when the click event occurs; detecting whether a clipboard event occurs on the table at the desktop end within a preset duration, and when the clipboard event is detected, storing clipboard content corresponding to the clipboard event; the clipboard content is converted into a hypertext markup language, and the hypertext markup language is converted into JSON data; obtaining a configuration file of the table at the desktop end, and perfecting the JSON data according to the configuration file; and integrating the improved JSON data into a webpage end table from the table coordinates to a preset direction. By adopting the technical means, the problem of high cost of table data cross-system migration in the prior art is solved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a method and device for migrating table data across systems. Background Art

[0002] With the rapid development of information technology, data interaction has become an important part of daily work. In actual applications, users often need to paste data from desktop tables into web tables, but due to the differences in data formats and interaction methods between different systems, this process often faces many difficulties. Existing methods either only support pasting single cell content and cannot meet user needs, or require the integration of third-party plug-ins on the web side. This method requires converting web business data into desktop tables, or transforming the style of desktop tables into the style of web tables, which consumes a lot of web performance, and also has a high cost for the introduction of new functions or the expansion of existing functions. Summary of the invention

[0003] In view of this, embodiments of the present application provide a method, device, electronic device and computer-readable storage medium for migrating table data across systems to solve the problem of high cost of migrating table data across systems in the prior art.

[0004] According to a first aspect of an embodiment of the present application, a method for migrating table data across systems is provided, including: detecting in real time whether a click event occurs on a desktop table, and when a click event is detected, recording the table coordinates when the click event occurs; detecting whether a clipboard event occurs on the desktop table within a preset time period, and when a clipboard event is detected, saving the clipboard content corresponding to the clipboard event; converting the clipboard content into hypertext markup language, and converting the hypertext markup language into JSON data; obtaining a configuration file of the desktop table, and improving the JSON data based on the configuration file; and integrating the improved JSON data into the web page table starting from the table coordinates in a preset direction.

[0005] According to a second aspect of an embodiment of the present application, a device for migrating table data across systems is provided, comprising: a first detection module, configured to detect in real time whether a click event occurs on a desktop table, and when a click event is detected, record the table coordinates when the click event occurs; a second detection module, configured to detect whether a clipboard event occurs on the desktop table within a preset time period, and when a clipboard event is detected, save the clipboard content corresponding to the clipboard event; a conversion module, configured to convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data; a perfection module, configured to obtain a configuration file of the desktop table, and perfect the JSON data according to the configuration file; an integration module, configured to integrate the perfected JSON data into the web page table starting from the table coordinates in a preset direction.

[0006] The third aspect of the embodiment of the present application provides a method for migrating target data across systems, including: detecting in real time whether a click event occurs on the desktop system interface, and when the click event is detected, recording the target coordinates when the click event occurs; detecting whether a clipboard event occurs on the desktop system interface within a preset time period, and when the clipboard event is detected, saving the clipboard content corresponding to the clipboard event; converting the clipboard content into hypertext markup language, and converting the hypertext markup language into JSON data; obtaining a configuration file of the desktop system interface, and improving the JSON data based on the configuration file; integrating the improved JSON data into the web system interface starting from the target coordinates in a preset direction.

[0007] According to a fourth aspect of an embodiment of the present application, an electronic device is provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above method when executing the computer program.

[0008] According to a fifth aspect of an embodiment of the present application, a computer-readable storage medium is provided, which stores a computer program, and when the computer program is executed by a processor, the steps of the above method are implemented.

[0009] Compared with the prior art, the embodiments of the present application have the following beneficial effects: by real-time detection of whether a click event occurs on the desktop table, when a click event is detected, the table coordinates when the click event occurs are recorded; detection of whether a clipboard event occurs on the desktop table within a preset time period, when a clipboard event is detected, the clipboard content corresponding to the clipboard event is saved; the clipboard content is converted into hypertext markup language, and the hypertext markup language is converted into JSON data; the configuration file of the desktop table is obtained, and the JSON data is improved according to the configuration file; the improved JSON data is integrated into the web page table starting from the table coordinates in the preset direction. The above technical means can solve the problem of high cost of cross-system migration of table data in the prior art, thereby reducing the cost of cross-system migration of table data and improving migration efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0010] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0011] Figure 1It is a flowchart of a table data cross-system migration method provided in an embodiment of the present application;

[0012] Figure 2 It is a flowchart of another method for migrating table data across systems provided in an embodiment of the present application;

[0013] Figure 3 It is a structural schematic diagram of a table data cross-system migration device provided in an embodiment of the present application;

[0014] Figure 4 It is a structural schematic diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0015] In the following description, specific details such as specific system structures, technologies, etc. are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present application. However, it should be clear to those skilled in the art that the present application may also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from obstructing the description of the present application.

[0016] A method and device for migrating table data across systems according to an embodiment of the present application will be described in detail below with reference to the accompanying drawings.

[0017] Figure 1 It is a flowchart of a method for migrating table data across systems provided in an embodiment of the present application. Figure 1 The table data cross-system migration method can be executed by a computer or a server, or software on the computer or the server. Figure 1 As shown, the table data cross-system migration method includes:

[0018] S101, detecting in real time whether a click event occurs on a table on the desktop, and when a click event is detected, recording the table coordinates when the click event occurs;

[0019] S102, detecting whether a clipboard event occurs on the table on the desktop within a preset time period, and when a clipboard event is detected, saving the clipboard content corresponding to the clipboard event;

[0020] S103, converting the clipboard content into hypertext markup language, and converting the hypertext markup language into JSON data;

[0021] S104, obtaining a configuration file of the table on the desktop, and completing the JSON data according to the configuration file;

[0022] S105, integrating the improved JSON data into the web page table starting from the table coordinates in a preset direction.

[0023] Desktop spreadsheets are desktop-based applications that use the computer's local resources to run displayed spreadsheets, such as Excel spreadsheets. Web spreadsheets are web-based applications that rely on server-side processing and cloud computing resources. The performance of web spreadsheets depends more on network speed and server response. It may be more efficient for lightweight operations. The disadvantage is that it may not be as smooth as the desktop when processing large data sets. In short, desktop spreadsheets are more suitable for scenarios that require in-depth data analysis and desktop-level functions, while web spreadsheets have advantages in collaboration, mobility, and ease of access. In some cases, data from desktop spreadsheets needs to be migrated to web spreadsheets due to work needs.

[0024] Click event refers to the event of clicking the left button of the mouse, and table coordinates are the coordinates of the table where the left button of the mouse is clicked. Clipboard event refers to the event of clicking the left button of the mouse, dragging the mouse to select the content to be pasted and copied, and executing the paste and copy action. The content to be pasted and copied is the clipboard content. Convert the clipboard content into Hypertext Markup Language (HTML). Then convert the Hypertext Markup Language into JSON data. JSON (JavaScript Object Notation) is a lightweight data exchange format.

[0025] In fact, it converts the clipboard content into HTML format and JSON format in turn. Because HTML is a markup language used to describe the structure of a web page, it is not really a data storage or transmission format, but a way of expressing web page content. JSON is often used for data transmission between servers and clients, so the clipboard content is first converted into HTML format, and then the HTML format data is converted into JSON format.

[0026] The configuration file is the settings or information such as field name, attribute name, read / write, rounding and merge information in the desktop table. The field name and attribute name indicate the field name and attribute name corresponding to the table. Read / write indicates whether the table is in readable mode (this mode cannot write information or modify) or writable mode (this mode can write information or modify). Rounding refers to whether the data saved in the table needs to be rounded and the length of the digits saved. Merge information refers to which rows and columns of the table are merged. The JSON data is improved according to the configuration file. For example, because the table is merged, the JSON data corresponding to the merged rows / columns is parsed and only one table has data, and the other tables are empty. In this case, the "empty" table is supplemented with the data in the table with data...

[0027] Converting the clipboard content into HTML, converting HTML into JSON data, and completing JSON data according to the configuration file may all be done using existing methods, such as calling htmlToGridSettings to convert HTML into JSON data, and calling handleCompleteTableData to complete JSON data according to the configuration file.

[0028] According to the technical solution provided by the embodiment of the present application, by real-time detection of whether a click event occurs on the desktop table, when a click event is detected, the table coordinates when the click event occurs are recorded; detection of whether a clipboard event occurs on the desktop table within a preset time period, when a clipboard event is detected, the clipboard content corresponding to the clipboard event is saved; the clipboard content is converted into hypertext markup language, and the hypertext markup language is converted into JSON data; the configuration file of the desktop table is obtained, and the JSON data is improved according to the configuration file; the improved JSON data is integrated into the web page table starting from the table coordinates in the preset direction. The above technical means can solve the problem of high cost of cross-system migration of table data in the prior art, thereby reducing the cost of cross-system migration of table data and improving migration efficiency.

[0029] Furthermore, after detecting whether a clipboard event occurs on the desktop table within a preset time period, the method also includes: if no clipboard event is detected within the preset time period, ignoring the click event detected this time; and re-detecting whether the next click event occurs on the desktop table.

[0030] Furthermore, before converting the clipboard content into hypertext markup language and converting the hypertext markup language into JSON data, the method also includes: executing the following first loop: detecting in real time whether a click event occurs on the desktop table, and when a click event is detected, recording the table coordinates when the click event occurs; detecting whether a clipboard event occurs on the desktop table within a preset time length; if a clipboard event is detected within the preset time length, saving the clipboard content corresponding to the clipboard event and exiting the first loop; if no clipboard event is detected within the preset time length, ignoring the click event detected this time and continuing the first loop.

[0031] Because under normal circumstances, the user pastes the copied content by clicking the left mouse button at the paste-copy start position (click event), then dragging the mouse to select the content to be pasted and copied, and performing the paste-copy action (clipboard event). The effective operation of pasting the copied content is the occurrence of a clipboard event within a certain period of time after the click event, so whether the clipboard event occurs within the preset time is detected. If detected, the clipboard content corresponding to the clipboard event is saved and the first loop is exited. If not detected, the click event is invalid, the click event detected this time is ignored, and the first loop continues.

[0032] Execute the following second loop: detect in real time whether the i-th click event occurs on the desktop table, and when the i-th click event is detected, record the table coordinates when the i-th click event occurs; detect whether the i-th clipboard event occurs on the desktop table within a preset time period, and when the i-th clipboard event is detected, save the i-th clipboard content corresponding to the i-th clipboard event; convert the i-th clipboard content into the i-th hypertext markup language, and convert the i-th hypertext markup language into the i-th JSON data; obtain the configuration file of the desktop table, and improve the i-th JSON data according to the configuration file; integrate the improved i-th JSON data into the web table in the preset direction starting from the table coordinates at the time of the i-th click event; determine whether the 1st clipboard content to the i-th clipboard content contain all the data in the desktop table; if so, determine that the migration of the table data of the desktop table to the web table is completed, and exit the second loop; if not, update i with the value of i plus 1, and continue the second loop.

[0033] Furthermore, after real-time detection of whether the i-th click event occurs on the desktop table, the method also includes: if the i-th clipboard event is not detected within a preset time period, ignoring the i-th click event; and re-detecting whether the i-th click event occurs on the desktop table.

[0034] If the first clipboard content, the second clipboard content, ... the i-th clipboard content together completely contain all the data in the desktop table, it means that all the table data in the desktop table has been migrated to the web table, then exit the second loop; otherwise, update i with the value of i plus 1, and continue the second loop, that is, detect the i+1th click event.

[0035] Figure 2 FIG. 1 is a flow chart of another method for migrating table data across systems provided in an embodiment of the present application. Figure 2 As shown, the method includes:

[0036] Execute the third loop as follows:

[0037] The fourth loop is executed as follows:

[0038] S201, detecting whether an i-th click event occurs on a table on the desktop, and when the i-th click event is detected, recording the table coordinates when the i-th click event occurs;

[0039] S202, detecting whether the i-th clipboard event occurs on the table on the desktop within a preset time period;

[0040] S203, if the i-th clipboard event is not detected within the preset time, the i-th click event is ignored and the fourth loop is continued;

[0041] S204, if the i-th clipboard event is detected within the preset time, the i-th clipboard content corresponding to the i-th clipboard event is saved, and the fourth loop is exited;

[0042] S205, converting the i-th clipboard content into the i-th hypertext markup language, and converting the i-th hypertext markup language into the i-th JSON data;

[0043] S206, obtaining a configuration file of the desktop table, and completing the i-th JSON data according to the configuration file;

[0044] S207, integrating the improved ith JSON data into the webpage table in a preset direction starting from the table coordinates at the time of the ith click event;

[0045] S208, determining whether the first clipboard content to the ith clipboard content include all the data in the table on the desktop;

[0046] S209, if included, determining that the migration of the table data of the desktop table to the web page table is completed, and exiting the third loop;

[0047] S210, if not included, update i with the value of i plus 1 and continue the third loop.

[0048] The embodiment of the present application is equivalent to combining the first cycle with the second cycle, and other contents remain unchanged, so they will not be repeated here. It should be noted that the fourth cycle is a part of the third cycle.

[0049] In one embodiment, a method for migrating target data across systems may also be provided, including: detecting in real time whether a click event occurs on the desktop system interface, and when a click event is detected, recording the target coordinates when the click event occurs; detecting whether a clipboard event occurs on the desktop system interface within a preset time period, and when a clipboard event is detected, saving the clipboard content corresponding to the clipboard event; converting the clipboard content into hypertext markup language, and converting the hypertext markup language into JSON data; obtaining a configuration file of the desktop system interface, and improving the JSON data based on the configuration file; integrating the improved JSON data into the web system interface starting from the target coordinates in a preset direction.

[0050] To achieve cross-system migration of table data, other forms of target data can also be used, such as text data and image data. The cross-system migration of target data is similar to the cross-system migration of table data, so it will not be repeated here.

[0051] In one embodiment, a method for migrating target data across systems may also be provided, including: detecting in real time whether a click event occurs on the desktop system interface, and when a click event is detected, recording the target coordinates when the click event occurs; detecting whether a clipboard event occurs on the desktop system interface within a preset time period, and when a clipboard event is detected, saving the clipboard content corresponding to the clipboard event; converting the clipboard content into hypertext markup language, and converting the hypertext markup language into JSON data; obtaining a configuration file of the desktop system interface, and improving the JSON data based on the configuration file; integrating the improved JSON data into the second system interface starting from the target coordinates in a preset direction.

[0052] In one embodiment, a method for migrating target data across applications may also be provided, including: detecting in real time whether a click event occurs on the first application interface, and when a click event is detected, recording the target coordinates when the click event occurs; detecting whether a clipboard event occurs on the first application interface within a preset time period, and when a clipboard event is detected, saving the clipboard content corresponding to the clipboard event; converting the clipboard content into hypertext markup language, and converting the hypertext markup language into JSON data; obtaining a configuration file for the first application interface, and improving the JSON data based on the configuration file; and integrating the improved JSON data into the second application interface starting from the target coordinates in a preset direction.

[0053] All the above optional technical solutions can be arbitrarily combined to form optional embodiments of the present application, which will not be described one by one here.

[0054] The following is an embodiment of the device of the present application, which can be used to execute the embodiment of the method of the present application. For details not disclosed in the embodiment of the device of the present application, please refer to the embodiment of the method of the present application.

[0055] Figure 3 Schematic diagram of a table data cross-system migration device provided by an embodiment of the present application. Figure 3 As shown, the table data cross-system migration device includes:

[0056] The first detection module 301 is configured to detect in real time whether a click event occurs on the desktop table, and when a click event is detected, record the table coordinates when the click event occurs;

[0057] The second detection module 302 is configured to detect whether a clipboard event occurs on the desktop table within a preset time period, and when a clipboard event is detected, save the clipboard content corresponding to the clipboard event;

[0058] The conversion module 303 is configured to convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data;

[0059] The improvement module 304 is configured to obtain a configuration file of the desktop table and improve the JSON data according to the configuration file;

[0060] The integration module 305 is configured to integrate the improved JSON data into the web page table starting from the table coordinates in a preset direction.

[0061] According to the technical solution provided by the embodiment of the present application, by real-time detection of whether a click event occurs on the desktop table, when a click event is detected, the table coordinates when the click event occurs are recorded; detection of whether a clipboard event occurs on the desktop table within a preset time period, when a clipboard event is detected, the clipboard content corresponding to the clipboard event is saved; the clipboard content is converted into hypertext markup language, and the hypertext markup language is converted into JSON data; the configuration file of the desktop table is obtained, and the JSON data is improved according to the configuration file; the improved JSON data is integrated into the web page table starting from the table coordinates in the preset direction. The above technical means can solve the problem of high cost of cross-system migration of table data in the prior art, thereby reducing the cost of cross-system migration of table data and improving migration efficiency.

[0062] In some embodiments, the second detection module 302 is further configured to ignore the click event detected this time if no clipboard event is detected within a preset time period; and re-detect whether the next click event occurs on the desktop table.

[0063] In some embodiments, the second detection module 302 is also configured to execute the following first loop: detect in real time whether a click event occurs on the desktop table, and when a click event is detected, record the table coordinates when the click event occurs; detect whether a clipboard event occurs on the desktop table within a preset time length; if a clipboard event is detected within the preset time length, save the clipboard content corresponding to the clipboard event and exit the first loop; if no clipboard event is detected within the preset time length, ignore the click event detected this time and continue the first loop.

[0064] In some embodiments, the second detection module 302 is also configured to execute the following second loop: real-time detection of whether the i-th click event occurs on the desktop table, and when the i-th click event is detected, recording the table coordinates when the i-th click event occurs; detecting whether the i-th clipboard event occurs on the desktop table within a preset time period, and when the i-th clipboard event is detected, saving the i-th clipboard content corresponding to the i-th clipboard event; converting the i-th clipboard content into the i-th hypertext markup language, and converting the i-th hypertext markup language into the i-th JSON data; obtaining the configuration file of the desktop table, and improving the i-th JSON data according to the configuration file; integrating the improved i-th JSON data into the web page table in a preset direction starting from the table coordinates at the time of the i-th click event; judging whether the 1st clipboard content to the i-th clipboard content contain all the data in the desktop table; if so, determining that the migration of the table data of the desktop table to the web page table is completed, and exiting the second loop; if not, updating i with the value of i plus 1, and continuing the second loop.

[0065] In some embodiments, the second detection module 302 is further configured to ignore the i-th click event if the i-th clipboard event is not detected within a preset time period; and re-detect whether the i-th click event occurs on the desktop form.

[0066] In some embodiments, the second detection module 302 is further configured to execute the following third loop: execute the following fourth loop: detect whether the i-th click event occurs on the desktop table, and when the i-th click event is detected, record the table coordinates when the i-th click event occurs; detect whether the i-th clipboard event occurs on the desktop table within a preset time length; if the i-th clipboard event is not detected within the preset time length, ignore the i-th click event and continue the fourth loop; if the i-th clipboard event is detected within the preset time length, save the i-th clipboard content corresponding to the i-th clipboard event and exit the fourth loop; save the i-th clipboard content corresponding to the i-th clipboard event Convert the clipboard content into the ith hypertext markup language, and convert the ith hypertext markup language into the ith JSON data; obtain the configuration file of the desktop table, and improve the ith JSON data according to the configuration file; integrate the improved ith JSON data into the web table in a preset direction starting from the table coordinates at the time of the ith click event; determine whether the 1st clipboard content to the ith clipboard content contains all the data in the desktop table; if so, determine that the migration of the table data of the desktop table to the web table is completed, and exit the third loop; if not, update i with the value of i plus 1, and continue the third loop.

[0067] In some embodiments, the second detection module 302 is also configured to detect in real time whether a click event occurs on the desktop system interface, and when a click event is detected, record the target coordinates when the click event occurs; detect whether a clipboard event occurs on the desktop system interface within a preset time period, and when a clipboard event is detected, save the clipboard content corresponding to the clipboard event; convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data; obtain the configuration file of the desktop system interface, and improve the JSON data based on the configuration file; integrate the improved JSON data into the web system interface starting from the target coordinates in a preset direction.

[0068] In some embodiments, the second detection module 302 is also configured to detect in real time whether a click event occurs on the desktop system interface, and when a click event is detected, record the target coordinates when the click event occurs; detect whether a clipboard event occurs on the desktop system interface within a preset time period, and when a clipboard event is detected, save the clipboard content corresponding to the clipboard event; convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data; obtain the configuration file of the desktop system interface, and improve the JSON data based on the configuration file; integrate the improved JSON data into the second system interface starting from the target coordinates in a preset direction.

[0069] In some embodiments, the second detection module 302 is also configured to detect in real time whether a click event occurs on the first application interface, and when a click event is detected, record the target coordinates when the click event occurs; detect whether a clipboard event occurs on the first application interface within a preset time period, and when a clipboard event is detected, save the clipboard content corresponding to the clipboard event; convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data; obtain the configuration file of the first application interface, and improve the JSON data based on the configuration file; integrate the improved JSON data into the second application interface starting from the target coordinates in a preset direction.

[0070] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0071] Figure 4 Schematic diagram of an electronic device 4 provided in an embodiment of the present application. Figure 4As shown, the electronic device 4 of this embodiment includes: a processor 401, a memory 402, and a computer program 403 stored in the memory 402 and executable on the processor 401. When the processor 401 executes the computer program 403, the steps in the above-mentioned method embodiments are implemented. Alternatively, when the processor 401 executes the computer program 403, the functions of the modules / units in the above-mentioned device embodiments are implemented.

[0072] The electronic device 4 may be a desktop computer, a notebook, a PDA, a cloud server, or other electronic device. The electronic device 4 may include, but is not limited to, a processor 401 and a memory 402. Those skilled in the art will appreciate that Figure 4 The electronic device 4 is merely an example and does not limit the electronic device 4 , and may include more or less components than those shown in the figure, or different components.

[0073] The processor 401 may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc.

[0074] The memory 402 may be an internal storage unit of the electronic device 4, for example, a hard disk or memory of the electronic device 4. The memory 402 may also be an external storage device of the electronic device 4, for example, a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. equipped on the electronic device 4. The memory 402 may also include both an internal storage unit and an external storage device of the electronic device 4. The memory 402 is used to store computer programs and other programs and data required by the electronic device.

[0075] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be assigned to different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiments can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units.

[0076] If the integrated module / unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present application implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and the computer program can implement the steps of the above-mentioned various method embodiments when executed by the processor. The computer program may include computer program code, and the computer program code may be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying computer program code, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable medium does not include electric carrier signals and telecommunication signals.

[0077] The above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical feature diagrams therein. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A method for migrating table data across systems. It is characterized in that include: Detect in real time whether a click event occurs on the desktop table, and when the click event is detected, record the table coordinates when the click event occurs; Detecting whether a clipboard event occurs on the desktop table within a preset time period, and when the clipboard event is detected, saving the clipboard content corresponding to the clipboard event; Convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data; Obtain a configuration file of the desktop table, and complete the JSON data according to the configuration file; The improved JSON data is integrated into the web page table starting from the table coordinates in the preset direction.

2. The method according to claim 1, It is characterized in that After detecting whether a clipboard event occurs on the desktop table within a preset time period, the method further includes: If the clipboard event is not detected within the preset time period, the click event detected this time is ignored; Re-detect whether the next click event occurs on the desktop table.

3. The method according to claim 1, It is characterized in that Before converting the clipboard content into hypertext markup language and converting the hypertext markup language into JSON data, the method further includes: Execute the first loop as follows: detecting in real time whether the click event occurs on the desktop table, and when the click event is detected, recording the table coordinates when the click event occurs; Detecting whether the clipboard event occurs on the desktop form within the preset time period; If the clipboard event is detected within the preset time period, the clipboard content corresponding to the clipboard event is saved and the first loop is exited; If the clipboard event is not detected within the preset time period, the click event detected this time is ignored and the first loop continues.

4. The method according to claim 1, It is characterized in that The method further comprises: Execute the second loop as follows: Detecting in real time whether an i-th click event occurs on the desktop table, and when the i-th click event is detected, recording the table coordinates when the i-th click event occurs; Detecting whether an i-th clipboard event occurs on the desktop table within the preset time period, and when the i-th clipboard event is detected, saving the i-th clipboard content corresponding to the i-th clipboard event; Convert the i-th clipboard content into the i-th hypertext markup language, and convert the i-th hypertext markup language into the i-th JSON data; Obtain the configuration file of the desktop table, and complete the i-th JSON data according to the configuration file; Integrate the improved ith JSON data into the webpage table in the preset direction starting from the table coordinates at the time of the ith click event; Determine whether the first clipboard content to the ith clipboard content include all the data in the desktop table; If included, it is determined that the migration of the table data of the desktop table to the web page table is completed, and the second loop is exited; If not included, update i with the value of i plus 1 and continue the second loop.

5. The method according to claim 1, It is characterized in that After real-time detection of whether an i-th click event occurs on the desktop table, the method further includes: If the i-th clipboard event is not detected within the preset time period, the i-th click event is ignored; Re-detect whether the i-th click event occurs on the desktop table.

6. The method according to claim 1, It is characterized in that The method further comprises: Execute the third loop as follows: The fourth loop is executed as follows: Detecting whether an i-th click event occurs on the desktop table, and when the i-th click event is detected, recording the table coordinates when the i-th click event occurs; Detecting whether the i-th clipboard event occurs on the desktop table within the preset time period; If the i-th clipboard event is not detected within the preset time period, the i-th click event is ignored and the fourth loop continues; If the i-th clipboard event is detected within the preset time period, the i-th clipboard content corresponding to the i-th clipboard event is saved, and the fourth loop is exited; Convert the i-th clipboard content into the i-th hypertext markup language, and convert the i-th hypertext markup language into the i-th JSON data; Obtain the configuration file of the desktop table, and complete the i-th JSON data according to the configuration file; Integrate the improved ith JSON data into the webpage table in the preset direction starting from the table coordinates at the time of the ith click event; Determine whether the first clipboard content to the ith clipboard content include all the data in the desktop table; If included, it is determined that the migration of the table data of the desktop table to the web page table is completed, and the third loop is exited; If not included, update i with the value of i plus 1 and continue the third loop.

7. A method for migrating target data across systems. It is characterized in that include: Detect in real time whether a click event occurs on the desktop system interface, and when the click event is detected, record the target coordinates when the click event occurs; Detecting whether a clipboard event occurs on the desktop system interface within a preset time period, and when the clipboard event is detected, saving the clipboard content corresponding to the clipboard event; Convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data; Obtain a configuration file of the desktop system interface, and complete the JSON data according to the configuration file; The improved JSON data is integrated into the web-side system interface starting from the target coordinates in a preset direction.

8. A device for migrating table data across systems, It is characterized in that include: The first detection module is configured to detect in real time whether a click event occurs on the desktop table, and when the click event is detected, record the table coordinates when the click event occurs; A second detection module is configured to detect whether a clipboard event occurs on the desktop table within a preset time period, and when the clipboard event is detected, save the clipboard content corresponding to the clipboard event; A conversion module, configured to convert the clipboard content into hypertext markup language, and convert the hypertext markup language into JSON data; A perfection module is configured to obtain a configuration file of the desktop table and perfect the JSON data according to the configuration file; The integration module is configured to integrate the improved JSON data into the web page table starting from the table coordinates in a preset direction.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, It is characterized in that When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 or 7 are implemented.

10. A computer-readable storage medium storing a computer program. It is characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 or 7 are implemented.

Images