CN111026800B - Data export method and device, electronic equipment and storage medium - Google Patents
Data export method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN111026800B CN111026800B CN201911262705.XA CN201911262705A CN111026800B CN 111026800 B CN111026800 B CN 111026800B CN 201911262705 A CN201911262705 A CN 201911262705A CN 111026800 B CN111026800 B CN 111026800B
- Authority
- CN
- China
- Prior art keywords
- export
- data
- script
- item
- scheme
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Information Transfer Between Computers (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a data export method, a data export device, electronic equipment and a storage medium. The data export method comprises the following steps: determining at least one export item of the target program, and determining export parameters corresponding to the at least one export item; determining at least one data export scheme according to the determined export parameters, and generating an export script according to the at least one data export scheme; and running the export script, and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme. According to the scheme provided by the embodiment, the data export work originally processed manually can be realized in an automatic mode, so that the required cost is greatly reduced, and the situation of data errors caused by manual errors is avoided as much as possible.
Description
Technical Field
The embodiment of the application relates to the technical field of data processing, in particular to a data export method, a data export device, electronic equipment and a storage medium.
Background
In general, the function of data maintenance in a database is mostly implemented by a data processing program. However, when it is necessary to export data to a third party, it is sometimes necessary to export data by manually operating a data processing program so that the exported data is made available to the third party.
However, when data is manually exported, the operation is complicated, the workload is large, the required labor cost is high, and when the data is manually operated, the conditions of data errors and the like caused by manual errors exist, so that the accuracy of the exported data is low.
In view of this, a technical problem to be solved in the prior art is how to provide another data export scheme.
Disclosure of Invention
In view of the foregoing, one of the technical problems to be solved by the embodiments of the present application is to provide a data deriving method, apparatus, electronic device and storage medium for overcoming some of the defects in the prior art.
The embodiment of the application provides a data export method, which comprises the following steps: determining at least one export item of the target program, and determining export parameters corresponding to the at least one export item; determining at least one data export scheme according to the determined export parameters, and generating an export script according to the at least one data export scheme; and running the export script, and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme.
Optionally, in any embodiment of the present application, the determining at least one export item of the target program and determining an export parameter corresponding to the at least one export item includes: simulating input operation of a user to open a data export interface of the target program through the simulated input operation; and searching the at least one export item in the data export interface, and determining export parameters corresponding to the at least one export item.
Optionally, in any embodiment of the present application, the type of the at least one derived term includes at least one of: buttons, check boxes, edit boxes, combo boxes, list boxes, scroll bars, and date controls.
Optionally, in any embodiment of the present application, the determining at least one data export scheme according to the determined export parameter, generating an export script according to the at least one data export scheme includes: performing enumeration combination on the export parameters of the at least one export item to determine the at least one data export scheme; and generating an export script according to the determined at least one data export scheme.
Optionally, in any embodiment of the present application, the export script corresponds to the data export scheme one-to-one; or the export script comprises export item setting schemes, the export item setting schemes are in one-to-one correspondence with the data export schemes, and the export item setting schemes are used for automatically setting the export items.
Optionally, in any embodiment of the present application, the method further comprises: storing data derived from the target program in a temporary file manner; and encrypting and transmitting the stored temporary file, so that the server receives the data, decrypts the received data, and stores the decrypted data.
Optionally, in any embodiment of the present application, encrypting and sending the stored temporary file, so that after the server receives the data and decrypts the received data, storing the decrypted data includes: encrypting the stored temporary file, transmitting the encrypted data in the form of data packets, enabling the server to determine whether the received data is complete or not according to the number of the received data packets and the total number of the data packets, decrypting the received data packets if the received data is complete, and storing the decrypted data.
The embodiment of the application provides a data export device, which comprises: the parameter determining module is used for determining at least one export item of the target program and determining export parameters corresponding to the at least one export item; the script generation module is used for determining at least one data export scheme according to the determined export parameters and generating an export script according to the at least one data export scheme; and the script running module is used for running the export script and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme.
The embodiment of the application provides electronic equipment, which comprises: one or more processors; and a memory for storing one or more programs that, when executed by the one or more processors, cause the one or more processors to implement the data derivation method as described above.
The embodiment of the application provides a computer readable storage medium having a computer program stored thereon, wherein the program when executed by a processor implements the data deriving method as described above.
According to the scheme, at least one data export scheme can be automatically determined according to the export parameters, and an export script is automatically generated according to the data export scheme; after the export script is generated, the export item can be automatically set according to the export script in the process of running the export script, so that the data in the target program can be automatically exported according to the data export scheme, namely, the data export work originally processed manually can be realized in an automatic mode, the required cost is greatly reduced, and the situation of data errors caused by manual errors is avoided as far as possible.
Drawings
Some specific embodiments of the present application will be described in detail below by way of example and not by way of limitation with reference to the accompanying drawings. The same reference numbers will be used throughout the drawings to refer to the same or like parts or portions. It will be appreciated by those skilled in the art that the drawings are not necessarily drawn to scale. In the accompanying drawings:
Fig. 1 is a flow chart of a data export method in the first embodiment of the present application;
fig. 2 is a flow chart of a data export method in the second embodiment of the present application;
fig. 3 is a schematic structural diagram of a data deriving device in a third embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device in a fourth embodiment of the present application.
Detailed Description
It is not necessary for any of the embodiments of the present application to be practiced with all of the advantages described above.
In order to better understand the technical solutions in the embodiments of the present application, the following descriptions will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, but not all embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the embodiments of the present application shall fall within the scope of protection of the embodiments of the present application.
Embodiments of the present application are further described below with reference to the accompanying drawings of embodiments of the present application.
Fig. 1 is a flow chart of a data export method in the first embodiment of the present application; as shown in fig. 1, it comprises the steps of:
Step S101: at least one export item of the target program is determined, and export parameters corresponding to the at least one export item are determined.
Steps S101 to 103 in this embodiment may be executed by the terminal in which the target program is installed, or may be executed by another terminal, and this embodiment is not limited thereto.
The target program may be a data processing program for managing the database, or may be another program, which is not limited in this embodiment.
The target program may include at least one export item, where the export item may correspond to a plurality of export parameters, and by selecting the export parameter corresponding to the export item, exported data content, data format, etc. may be defined. For example, if the export parameters of the export item are selected to be in XLS format, the exported data can be opened by excle; for another example, if the export parameter of the export item is selected as today, data with the modification date as today may be exported.
Step S102: at least one data export scheme is determined from the determined export parameters, and an export script is generated from the at least one data export scheme.
In this embodiment, when the data export scheme includes two or more data export parameters corresponding to different data export schemes, the export parameters may be different, for example, the data exported by scheme a is data with a date of modification of yesterday, and the data exported by scheme B is data with a date of modification of today. The method for generating the export script according to the data export scheme may refer to related technologies, and this embodiment will not be described in detail. For example, an XML-formatted export script may be generated from each export item and its corresponding export parameters in the data export scheme.
By determining the data export scheme according to the export parameters, the data export scheme can cover all the situations of exported data as much as possible, and the integrity of the exported data is further ensured.
Step S103: and running the export script, and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme.
The process of running the export script may refer to the related art, and this embodiment is not described herein.
Since the export script is generated according to the data export scheme, the data in the target program is exported by the export script automatically setting the export item determined in the above step, i.e., according to the data export scheme determined in the above step, during the execution of the export script.
By automatically setting the export item and conducting data export in the process of running the export script, the data export work originally processed manually can be realized in an automatic mode. The required cost is greatly reduced, and the situation of data errors caused by manual errors is avoided as much as possible.
In the embodiment of the present application, the execution sequence of the steps S101 to S103 is not limited, and may be determined by those skilled in the art according to actual needs. For example, steps S101-S102 may be performed once each time data is exported, i.e. once each time data is exported, an export script is generated; for another example, steps S101 to S102 may be executed once when data is exported for the first time to generate an export script, and step S103 may be executed directly when data is exported again subsequently, that is, data in the target program may be exported directly from the export script that has been generated.
According to the scheme provided by the embodiment of the application, at least one export item of the target program is determined, and export parameters corresponding to the at least one export item are determined; determining at least one data export scheme according to the determined export parameters, and generating an export script according to the at least one data export scheme; and running the export script, and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme. According to the scheme provided by the embodiment of the application, at least one data export scheme can be automatically determined according to the export parameters, and an export script is automatically generated according to the data export scheme; after the export script is generated, the export item can be automatically set according to the export script in the process of running the export script, so that the data in the target program can be automatically exported according to the data export scheme, namely, the data export work originally processed manually can be realized in an automatic mode, the required cost is greatly reduced, and the situation of data errors caused by manual errors is avoided as far as possible.
The data export method of the present embodiment may be performed by any suitable electronic device having data processing capabilities, including but not limited to: servers, mobile terminals (such as tablet computers, mobile phones and the like), PCs and the like.
Fig. 2 is a flow chart of a data export method in the second embodiment of the present application, in which the data export process is illustrated by sending the exported data to the server for storage, but the present application is not limited thereto.
As shown in fig. 2, the data deriving method includes the steps of:
step S201, simulating an input operation of a user, so as to open a data export interface of the target program through the simulated input operation.
A data export interface, i.e. an interface for presenting export items to a user, which can set exported data by manipulating the export items of the data export interface.
In general, when manually exporting data, a user operates a mouse to click, inputs data through a keyboard, and opens an export interface of a target program. In this embodiment, the input operation of the user when exporting data, such as the mouse click operation and keyboard input described above, can be simulated, and the export interface of the target program can be automatically opened without modifying the target program.
In addition, when some application programs are opened, the application programs need to log in by using the account passwords, and in this embodiment, before step S201, the method may further include: and logging in the target program according to the account number and the password input by the user.
Alternatively, the account number and password of the user may be stored in advance, and the target program may be automatically logged in through the pre-stored account number and password before step S201.
In addition, in order to ensure the security of the data, a scheme of inputting the account password by the user is preferably selected.
Step S202, the at least one export item is found in the data export interface, and export parameters corresponding to the at least one export item are determined.
Since export items are typically presented centrally through a data export interface. Therefore, the search range can be reduced, the speed of searching the derived items is increased, and the speed of generating the derived script is further increased by searching the data derived page to determine the derived items.
In addition, the types of the derived items are various, and the type of the at least one derived item includes at least one of the following: buttons, check boxes, edit boxes, combo boxes, list boxes, scroll bars, and date controls.
The button corresponds to a relatively fixed and single function, i.e. a button generally corresponds to only one derived parameter.
The check box is a basic control which can check multiple items at the same time, a plurality of derived parameters can be corresponding to the check box, and the derived parameters can be checked.
A list box (ListBox) is used to provide a set of entries (data items), one of which in this application may be a derived parameter, one or more of which may be selected but not directly edited. When the list box can not display all the items at the same time, a scroll bar can be automatically added in the list box, so that a user can scroll to review all the items.
The combo box can comprise a text box and a list box, the content of the list box is similar to that described above, the export parameters corresponding to the combo box in the application are the items in the list box comprised by the combo box, when the items in the list box are selected, the detailed information of the selected items can be displayed in the text box, and the user can modify the detailed information of the items through the text box; alternatively, new entries may be defined by text boxes and added to the list boxes.
The date control may be used to select a date, where an optional date may correspond to a derived parameter, and the date in the date control may change as the date in real life changes.
Step S203, enumerating and combining the export parameters of the at least one export item, to determine the at least one data export scheme.
According to the scheme provided by the embodiment, all data export schemes can be determined by enumerating and combining the export parameters of the export items, so that the integrity of exported data is ensured.
Step S204, generating a export script according to the determined at least one data export scheme.
The specific method for generating the export script may refer to related technology, and this embodiment is not described herein.
In an alternative scheme of the present application, the export scripts are in one-to-one correspondence with the data export schemes, and in step S205, when the export scripts are executed, the corresponding export scripts may be sequentially executed according to the order of the data export schemes, so that the exported data is in one-to-one correspondence with the data export schemes. And when the export script is run, part of the export script can be ignored according to the selection of a user, so that the data export scheme provided by the embodiment is more flexible in use.
In another alternative scheme of the application, the export script includes export item setting schemes, where the export item setting schemes are in one-to-one correspondence with the data export schemes, and the export item setting schemes are used for automatically setting the export items. When the export script is run, export items can be automatically set according to the sequence of the data export schemes and the corresponding export item setting schemes in turn, so that exported data corresponds to the data export schemes one by one. And a plurality of export item setting schemes are arranged in one export script, so that the number of running export scripts can be reduced, and the time consumption of the data export process is shortened.
Step S205, the export script is operated, and the export item is automatically set through the export script in the operation process, so that the data in the target program is exported according to the at least one data export scheme.
The specific implementation manner of this step may refer to step S103, and this embodiment is not described herein.
Step S206, storing the data derived from the target program in a temporary file mode.
The temporary file may be created by the target program, and after the subsequent step S207 is performed, the created temporary file is deleted by the target program, however, if the export script is a program other than the target program, the temporary file may also be created by a program that executes the export script, which is not limited in this embodiment.
Step S207, encrypting and transmitting the stored temporary file, so that the server receives the data, decrypts the received data, and stores the decrypted data.
In addition, in the step S205, the data to be exported corresponds to the data export scheme one by one, and when the number of data export schemes is two or more, the data to be exported is also two or more groups. Then, step S207 may be performed once for exporting a set of data; alternatively, step S207 may be performed after all the data exports are completed.
Specifically, the encryption manner of the data may include:
symmetric encryption, i.e. encryption and decryption use the same key, ensures the integrity of data, but cannot solve the problem of insufficient confidentiality degree during key exchange, and common symmetric encryption algorithms include DES, 3DES, AES, and the like.
The public key encryption, namely generating a key pair (a private key and a public key), encrypting by the private key during encryption, decrypting by the public key during decryption, and avoiding the problem of insufficient confidentiality degree during key exchange by the public key encryption mode. However, when encrypting data with a large data volume, the encryption speed is slow.
The method comprises the steps of one-way encryption, namely extracting the feature codes of data to be encrypted, wherein the length of the output feature codes is fixed when the data to be encrypted is encrypted in one way, the data to be encrypted can not be reversely obtained through the feature codes, but the feature codes are one-to-one objects with the data to be encrypted, and the integrity of the data can be checked through the feature codes. But one-way encryption does not guarantee confidentiality of data.
Since the three encryption methods have advantages and disadvantages, in the embodiment of the application, the three encryption methods may be used in combination, and the encryption steps when used in combination are as follows:
1) Carrying out one-way encryption on the derived data, and determining a feature code of the derived data;
2) Encrypting the feature code by using a private key of a sender to generate S1;
3) Symmetrically encrypting the S1 and the derived data to generate S2;
4) The S2 and symmetrically encrypted passwords are encrypted using the public key of the receiving party.
The decryption steps when used in combination are as follows:
1) The receiver decrypts the received data by using the private key of the receiver to obtain S2 and a symmetric encrypted password;
2) Decrypting the S2 by using a symmetric encrypted password to obtain S1 and derived data;
3) Decrypting the S1 by using a public key of the sender, if the public key can be decrypted, the obtained data is sent by the sender, the decrypted feature code is obtained, and if the public key cannot be decrypted, the obtained data is wrong;
4) Calculating the feature code of the derived data, comparing the calculated feature code with the decoded feature code, if the two feature codes are the same, indicating that the derived data is not modified, and if the two feature codes are different, indicating that the derived data is modified.
By the scheme, the integrity and confidentiality of the derived data can be ensured in the transmission process of the derived data, and the identity of the sender can be verified.
In another alternative of the present application, step S205 may specifically include: encrypting the stored temporary file, transmitting the encrypted data in the form of data packets, enabling the server to determine whether the received data is complete or not according to the number of the received data packets and the total number of the data packets, decrypting the received data packets if the received data is complete, and storing the decrypted data.
The encryption method is similar to the above, and will not be described again here.
When the encrypted data is sent in a data packet mode, the data to be sent can be divided into a plurality of data packets, each data packet is numbered, the total number of the divided data packets is determined, and the data packets can be specifically transmitted based on the HTTP protocol.
When the server receives the data packets, whether all the data packets are received or not can be determined according to the numbers of the received data packets and the total number of the predetermined data packets, so that whether the received data are completed or not is judged, if the received data are complete, the received data can be continuously decrypted, and if the received data are incomplete, the numbers of the data packets which are not received can be sent to the terminal, so that the terminal where the target program is located can resend the corresponding data packets. Through the scheme, the server side can conveniently count whether the received data is complete or not, and then conveniently judge whether all the data are received or not.
In addition, it should be noted that a fault-tolerant mechanism may be set in the data export scheme provided in this embodiment, and the fault-tolerant mechanism may specifically be: judging whether the current abnormal operation is matched with the preset abnormal operation type, and if so, rerun the export script.
The type of abnormal operation set in advance may be determined according to an operation affecting the integrity or accuracy of data, or may be set by those skilled in the art according to other criteria, which is not limited in this embodiment.
According to the scheme provided by the embodiment of the application, the data export interface of the target program is automatically opened through simulating the input operation of the user, and the data of the target program is automatically exported through the export script, so that the export script can be automatically generated through the automatic operation and the automation, and the export script is automatically executed, so that the whole export process is automatically executed without manual participation; and then, the exported data can be uploaded to a server for backup storage, the integrity of the data can be ensured by an encryption mode in the uploading process to the server, and the identity of a data sender can be verified in the encryption and decryption process.
The data export method of the present embodiment may be performed by any suitable electronic device having data processing capabilities, including but not limited to: servers, mobile terminals (such as tablet computers, mobile phones and the like), PCs and the like.
Fig. 3 is a schematic structural diagram of a data deriving device in a third embodiment of the present application; as shown in fig. 3, it includes: a parameter determination module 301, a script generation module 302, and a script running module 303.
The parameter determining module 301 is configured to determine at least one export item of the target program, and determine export parameters corresponding to the at least one export item.
The script generation module 302 is configured to determine at least one data export scheme according to the determined export parameter, and generate an export script according to the at least one data export scheme.
And the script running module 303 is configured to run the export script, and automatically set the export item through the export script during the running process, so as to export the data in the target program according to the at least one data export scheme.
Optionally, in any embodiment of the present application, the parameter determining module 301 includes: the simulation module is used for simulating input operation of a user so as to open a data export interface of the target program through the simulated input operation; and the searching module is used for searching the at least one export item in the data export interface and determining export parameters corresponding to the at least one export item.
Optionally, in any embodiment of the present application, the type of the at least one derived item includes at least one of: buttons, check boxes, edit boxes, combo boxes, list boxes, scroll bars, and date controls.
Optionally, in any embodiment of the present application, the script generating module 302 includes: a scheme determining module, configured to enumerate and combine derived parameters of the at least one derived item, and determine the at least one data derived scheme; and the script generation sub-module is used for generating an export script according to the determined at least one data export scheme.
Optionally, in any embodiment of the present application, the export script corresponds to the data export scheme one to one; or the export script comprises export item setting schemes, the export item setting schemes are in one-to-one correspondence with the data export schemes, and the export item setting schemes are used for automatically setting the export items.
Optionally, in any embodiment of the present application, the apparatus further includes: a storage module for storing data derived from the target program in a temporary file manner; the encryption module is used for encrypting the stored temporary file; and the sending module is used for sending the encrypted data, so that the server receives the data, decrypts the received data and stores the decrypted data.
Optionally, in any embodiment of the present application, the sending module is specifically configured to send encrypted data in a data packet manner, so that the server determines, according to a number of the received data packet and a total packet number, whether the received data is complete, and if so, decrypts the received datagram, and stores the decrypted data.
According to the scheme provided by the embodiment of the application, at least one export item of the target program is determined, and export parameters corresponding to the at least one export item are determined; determining at least one data export scheme according to the determined export parameters, and generating an export script according to the at least one data export scheme; and running the export script, and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme. According to the scheme provided by the embodiment of the application, at least one data export scheme can be automatically determined according to the export parameters, and an export script is automatically generated according to the data export scheme; after the export script is generated, the export item can be automatically set according to the export script in the process of running the export script, so that the data in the target program can be automatically exported according to the data export scheme, namely, the data export work originally processed manually can be realized in an automatic mode, the required cost is greatly reduced, and the situation of data errors caused by manual errors is avoided as far as possible.
The data deriving means of the present embodiment may be performed by any suitable electronic device having data processing capabilities, including but not limited to: servers, mobile terminals (such as tablet computers, mobile phones and the like), PCs and the like.
Fig. 4 is a schematic diagram of a hardware architecture of some electronic devices for performing the data export method of the present application. As shown in fig. 4, the apparatus includes:
one or more processors 410, and a memory 420, one processor 410 being illustrated in fig. 4.
The apparatus for performing the data export method may further include: an input device 430 and an output device 440.
The processor 410, memory 420, input device 430, and output device 440 may be connected by a bus or other means, for example in fig. 4.
The memory 420 is used as a non-volatile computer readable storage medium for storing non-volatile software programs, non-volatile computer executable programs, and modules, such as program instructions/modules corresponding to the data export method in the embodiments of the present application. The processor 410 executes various functional applications of the server and data processing, i.e., implements the data export method in the method embodiments described above, by running non-volatile software programs, instructions, and modules stored in the memory 420.
Memory 420 may include a storage program area that may store an operating system, at least one application program required for functionality, and a storage data area; the storage data area may store data created according to the use of the data deriving means, etc. In addition, memory 420 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid-state storage device. In some embodiments, memory 420 optionally includes memory 420 remotely located relative to processor 410, such remote memory 420 being connectable to the data export device via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 430 may receive input numeric or character information and generate key signal inputs related to user settings and function control of the data-deriving device. The input device 430 may include a keyboard, a touch screen, and the like.
The one or more modules are stored in the memory 420 that, when executed by the one or more processors 410, perform the data export method of any of the method embodiments described above.
The product can execute the method provided by the embodiment of the application, and has the corresponding functional modules and beneficial effects of the execution method. Technical details not described in detail in this embodiment may be found in the methods provided in the embodiments of the present application.
The electronic device of the embodiments of the present application exist in a variety of forms including, but not limited to:
(1) Mobile communication devices, which are characterized by mobile communication functionality and are aimed at providing voice, data communication. Such terminals include smart phones (e.g., iPhone), multimedia phones, functional phones, and low-end phones, among others.
(2) Ultra mobile personal computer equipment, which belongs to the category of personal computers, has the functions of calculation and processing and generally has the characteristic of mobile internet surfing. Such terminals include PDA, MID and UMPC devices, etc., such as iPad.
(3) Portable entertainment devices such devices can display and play multimedia content. Such devices include audio, video players (e.g., iPod), palm game consoles, electronic books, and smart toys and portable car navigation devices.
(4) The server, which is a device for providing computing services, is composed of a processor 810, a hard disk, a memory, a system bus, etc., and is similar to a general computer architecture, but is required to provide highly reliable services, and thus has high requirements in terms of processing power, stability, reliability, security, scalability, manageability, etc.
(5) Other electronic devices with data interaction function.
Thus, particular embodiments of the present subject matter have been described. Other embodiments are within the scope of the following claims. In some cases, the actions recited in the claims can be performed in a different order and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may be advantageous.
In the 90 s of the 20 th century, improvements to one technology could clearly be distinguished as improvements in hardware (e.g., improvements to circuit structures such as diodes, transistors, switches, etc.) or software (improvements to the process flow). However, with the development of technology, many improvements of the current method flows can be regarded as direct improvements of hardware circuit structures. Designers almost always obtain corresponding hardware circuit structures by programming improved method flows into hardware circuits. Therefore, an improvement of a method flow cannot be said to be realized by a hardware entity module. For example, a programmable logic device (Programmable Logic Device, PLD) (e.g., field programmable gate array (Field Programmable Gate Array, FPGA)) is an integrated circuit whose logic function is determined by the programming of the device by a user. A designer programs to "integrate" a digital system onto a PLD without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Moreover, nowadays, instead of manually manufacturing integrated circuit chips, such programming is mostly implemented by using "logic compiler" software, which is similar to the software compiler used in program development and writing, and the original code before the compiling is also written in a specific programming language, which is called hardware description language (Hardware Description Language, HDL), but not just one of the hdds, but a plurality of kinds, such as ABEL (Advanced Boolean Expression Language), AHDL (Altera Hardware Description Language), confluence, CUPL (Cornell University Programming Language), HDCal, JHDL (Java Hardware Description Language), lava, lola, myHDL, PALASM, RHDL (Ruby Hardware Description Language), etc., VHDL (Very-High-Speed Integrated Circuit Hardware Description Language) and Verilog are currently most commonly used. It will also be apparent to those skilled in the art that a hardware circuit implementing the logic method flow can be readily obtained by merely slightly programming the method flow into an integrated circuit using several of the hardware description languages described above.
The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer readable medium storing computer readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, application specific integrated circuits (Application Specific Integrated Circuit, ASIC), programmable logic controllers, and embedded microcontrollers, examples of which include, but are not limited to, the following microcontrollers: ARC 625D, atmel AT91SAM, microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic of the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller in a pure computer readable program code, it is well possible to implement the same functionality by logically programming the method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers, etc. Such a controller may thus be regarded as a kind of hardware component, and means for performing various functions included therein may also be regarded as structures within the hardware component. Or even means for achieving the various functions may be regarded as either software modules implementing the methods or structures within hardware components.
The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function. One typical implementation is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
For convenience of description, the above devices are described as being functionally divided into various units, respectively. Of course, the functions of each element may be implemented in one or more software and/or hardware elements when implemented in the present application.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular transactions or implement particular abstract data types. The application may also be practiced in distributed computing environments where transactions are performed by remote processing devices that are connected through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for system embodiments, since they are substantially similar to method embodiments, the description is relatively simple, as relevant to see a section of the description of method embodiments.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and changes may be made to the present application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc. which are within the spirit and principles of the present application are intended to be included within the scope of the claims of the present application.
Claims (8)
1. A data export method, comprising:
determining at least one export item of the target program, and determining export parameters corresponding to the at least one export item;
determining at least one data export scheme according to the determined export parameters, and generating an export script according to the at least one data export scheme;
running the export script, and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme;
Wherein the determining at least one data export scheme according to the determined export parameters, generating an export script according to the at least one data export scheme, comprises: performing enumeration combination on the export parameters of the at least one export item to determine the at least one data export scheme; generating an export script according to the determined at least one data export scheme, wherein the export script corresponds to the data export scheme one by one; or the export script comprises export item setting schemes, the export item setting schemes are in one-to-one correspondence with the data export schemes, and the export item setting schemes are used for automatically setting the export items.
2. The method of claim 1, wherein determining at least one export item of the target program and determining export parameters corresponding to the at least one export item comprises:
simulating input operation of a user to open a data export interface of the target program through the simulated input operation;
and searching the at least one export item in the data export interface, and determining export parameters corresponding to the at least one export item.
3. The method of claim 1, wherein the type of the at least one derived item comprises at least one of: buttons, check boxes, edit boxes, combo boxes, list boxes, scroll bars, and date controls.
4. The method according to claim 1, wherein the method further comprises:
storing data derived from the target program in a temporary file manner;
and encrypting and transmitting the stored temporary file, so that the server receives the data, decrypts the received data, and stores the decrypted data.
5. The method of claim 4, wherein encrypting and transmitting the stored temporary file such that the server receives data and decrypts the received data, and storing the decrypted data comprises:
encrypting the stored temporary file, transmitting the encrypted data in the form of data packets, enabling the server to determine whether the received data is complete or not according to the number of the received data packets and the total number of the data packets, decrypting the received data packets if the received data is complete, and storing the decrypted data.
6. A data deriving apparatus, comprising:
the parameter determining module is used for determining at least one export item of the target program and determining export parameters corresponding to the at least one export item;
the script generation module is used for determining at least one data export scheme according to the determined export parameters and generating an export script according to the at least one data export scheme;
The script running module is used for running the export script and automatically setting the export item through the export script in the running process so as to export the data in the target program according to the at least one data export scheme;
the script generation module is further used for enumerating and combining the export parameters of the at least one export item to determine the at least one data export scheme; generating an export script according to the determined at least one data export scheme, wherein the export script corresponds to the data export scheme one by one; or the export script comprises export item setting schemes, the export item setting schemes are in one-to-one correspondence with the data export schemes, and the export item setting schemes are used for automatically setting the export items.
7. An electronic device, comprising:
one or more processors;
a memory for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the data derivation method of any one of claims 1-5.
8. A computer-readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements a data export method according to any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911262705.XA CN111026800B (en) | 2019-12-09 | 2019-12-09 | Data export method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911262705.XA CN111026800B (en) | 2019-12-09 | 2019-12-09 | Data export method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111026800A CN111026800A (en) | 2020-04-17 |
| CN111026800B true CN111026800B (en) | 2023-07-21 |
Family
ID=70205551
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911262705.XA Active CN111026800B (en) | 2019-12-09 | 2019-12-09 | Data export method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111026800B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112131247A (en) * | 2020-09-30 | 2020-12-25 | 中国银行股份有限公司 | Method and device for safety isolation of host data query |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104881469A (en) * | 2015-05-27 | 2015-09-02 | 北京京东尚科信息技术有限公司 | Data exporting method and device |
| CN108595644A (en) * | 2018-04-26 | 2018-09-28 | 宁波银行股份有限公司 | A kind of big data platform operation management system |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
| CN109213813A (en) * | 2018-09-14 | 2019-01-15 | 汉能移动能源控股集团有限公司 | Data export method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7610314B2 (en) * | 2005-10-07 | 2009-10-27 | Oracle International Corporation | Online tablespace recovery for export |
| US10268633B2 (en) * | 2016-03-29 | 2019-04-23 | Wipro Limited | System and method for database migration with target platform scalability |
| US11023442B2 (en) * | 2018-02-23 | 2021-06-01 | Accenture Global Solutions Limited | Automated structuring of unstructured data |
-
2019
- 2019-12-09 CN CN201911262705.XA patent/CN111026800B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104881469A (en) * | 2015-05-27 | 2015-09-02 | 北京京东尚科信息技术有限公司 | Data exporting method and device |
| CN108595644A (en) * | 2018-04-26 | 2018-09-28 | 宁波银行股份有限公司 | A kind of big data platform operation management system |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
| CN109213813A (en) * | 2018-09-14 | 2019-01-15 | 汉能移动能源控股集团有限公司 | Data export method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111026800A (en) | 2020-04-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3731488B1 (en) | Login information processing method and device | |
| US10554805B2 (en) | Information processing method, terminal, and computer-readable storage medium | |
| CN111538980B (en) | Account binding method, device and system for application program | |
| US9813393B2 (en) | System and method for client-side analytic data collection | |
| US20210352059A1 (en) | Message Display Method, Apparatus, and Device | |
| CN107528830B (en) | Account login method, system and storage medium | |
| WO2017156983A1 (en) | List callup method and device | |
| CN106412282B (en) | A kind of real-time messages phonetic prompt method and mobile terminal | |
| CN110750437B (en) | Equipment debugging method, device, equipment and system | |
| CN107580013A (en) | The method and device of cross-domain request data | |
| CN110889691B (en) | Information display method, device and equipment | |
| US20150212657A1 (en) | Recommending Mobile Device Settings Based on Input/Output Event History | |
| CN106295379A (en) | Encrypt input method and device, deciphering input method and device and relevant device | |
| CN109657440B (en) | Block chain-based biological characteristic information processing method and device and terminal equipment | |
| CN111026800B (en) | Data export method and device, electronic equipment and storage medium | |
| WO2024109786A1 (en) | Instant messaging session information processing method and apparatus, and electronic device | |
| CN109977692B (en) | Data processing method and device, storage medium and electronic equipment | |
| CN112182509A (en) | Method, device and equipment for detecting abnormity of compliance data | |
| CN106210245B (en) | A kind of setting method and its device of portable terminal do-not-disturb mode | |
| CN107463808B (en) | Method for calling functional module integrated in operating system | |
| US20230413054A1 (en) | Systems and methods for providing a secure notification service for mobile applications | |
| CN108009057B (en) | Test method and device for password input, storage medium and electronic equipment | |
| WO2017000343A1 (en) | Fingerprint unlocking method and terminal | |
| CN103257886A (en) | Information input procedure calling method and electronic equipment | |
| US20150213256A1 (en) | Key control method and associated electronic device for determining whether to perform key operation corresponding to key event |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |