CN107798128B - Data import method, device, medium and electronic equipment - Google Patents
Data import method, device, medium and electronic equipment Download PDFInfo
- Publication number
- CN107798128B CN107798128B CN201711121038.4A CN201711121038A CN107798128B CN 107798128 B CN107798128 B CN 107798128B CN 201711121038 A CN201711121038 A CN 201711121038A CN 107798128 B CN107798128 B CN 107798128B
- Authority
- CN
- China
- Prior art keywords
- data
- identifier
- target file
- imported
- value
- 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
Images
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/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention provides a data import method, a device, a medium and electronic equipment, wherein the data import method comprises the following steps: receiving an object file containing data to be imported, wherein the object file contains a first identifier used for indicating a verification result of the data to be imported; acquiring the value of the first identifier, and judging whether the data to be imported passes the verification according to the value of the first identifier; and when the data to be imported passes the verification according to the value of the first identifier, importing the data in the target file. The technical scheme of the embodiment of the invention can improve the effect of data import efficiency on the premise of avoiding the error data import system to the maximum extent.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data import method, a data import apparatus, a computer readable medium, and an electronic device.
Background
In an application scenario of importing a large amount of data, in order to facilitate operation of workers and reduce repeated work, data is imported in batches by adopting an import template. For example, for the insurance industry, when it is necessary to import underwriting, security and claim data of a certain batch of applicants into the system, the information of the applicants is generally imported into the system in batch by using an import template (e.g., Excel template).
Before data is imported into a system in batch by using an import template, various items of data in the import template usually need to be checked, for example, the insurance industry needs to check the compliance of an insured identity card number, the corresponding relation between various sheet pages of an Excel template, and the like.
However, in practical applications, after the working personnel fills the sorted data into the import template, the sorted data may be uploaded to the system without verification. In order to ensure that the data in question can be verified before the system is imported, the same verification rule needs to be deployed for both the import template and the system, and this obviously has problems, for example, if a worker verifies the data in the import template and then uploads the data to the system, the data needs to be verified again, and repeated work inevitably causes low efficiency.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present invention and therefore may include information that does not constitute prior art known to a person of ordinary skill in the art.
Disclosure of Invention
The embodiment of the invention aims to provide a data importing method, a data importing device, a data importing medium and electronic equipment, and further solves the problem of low efficiency caused by repeated deployment of the same verification rule at least to a certain extent.
Additional features and advantages of the invention will be set forth in the detailed description which follows, or may be learned by practice of the invention.
According to a first aspect of the embodiments of the present invention, there is provided a data importing method, including: receiving an object file containing data to be imported, wherein the object file contains a first identifier used for indicating a verification result of the data to be imported; acquiring the value of the first identifier, and judging whether the data to be imported passes the verification according to the value of the first identifier; and when the data to be imported passes the verification according to the value of the first identifier, importing the data in the target file.
In some embodiments of the present invention, based on the foregoing solution, the target file further includes a second identifier for indicating version information of the target file; the data import method further comprises the following steps: before judging whether the data to be imported passes the verification according to the value of the first identifier, judging whether the version information of the target file meets the requirement according to the value of the second identifier; and if the version information of the target file is judged to meet the requirement according to the value of the second identifier, judging whether the data to be imported passes the verification according to the value of the first identifier.
In some embodiments of the present invention, based on the foregoing solution, the data importing method further includes: and if the version information of the target file is judged to be not in accordance with the requirement according to the value of the second identifier, outputting prompt information.
In some embodiments of the present invention, based on the foregoing solution, determining whether the version information of the target file meets the requirement according to the value of the second identifier includes: judging whether the version of the target file is the latest version or not according to the value of the second identifier and the recorded latest version information of the imported file corresponding to the data to be imported; and if the version of the target file is the latest version, judging that the version information of the target file meets the requirement.
In some embodiments of the present invention, based on the foregoing scheme, the value of the second flag includes: a version code of the target file and/or a date on which a version of the target file was last modified.
In some embodiments of the present invention, based on the foregoing solution, the method further includes: determining the check date of the data to be imported according to the value of the first identifier, and determining the date of the last version modification of the target file according to the value of the second identifier; and when the data to be imported passes the verification according to the value of the first identifier and the date of the last version modification of the target file is earlier than the verification date, importing the data in the target file.
In some embodiments of the present invention, based on the foregoing solution, the method further includes: latest version information of each import file for importing various data is recorded.
In some embodiments of the present invention, based on the foregoing solution, the method further includes: version update track information of each import file for importing various data is recorded.
In some embodiments of the present invention, based on the foregoing solution, the data importing method further includes: and when the data to be imported is judged not to pass the verification according to the value of the first identifier, the data in the target file is forbidden to be imported.
According to a second aspect of the embodiments of the present invention, there is provided a data importing method, including: verifying the data to be imported in the target file to obtain a verification result; generating a first identifier in the target file, and generating a value of the first identifier according to the verification result; and transmitting the target file to a target system so that the target system can import the data in the target file.
In some embodiments of the present invention, based on the foregoing solution, before the target file is transmitted to the target system, the method further includes: generating a second identifier in the target file; and generating the value of the second identifier according to the version information of the target file.
In some embodiments of the present invention, based on the foregoing solution, the data importing method further includes: and if the verification of the data to be imported fails, outputting error prompt information of the verification failure.
According to a third aspect of the embodiments of the present invention, there is provided a data importing apparatus, including: the device comprises a receiving unit, a verification unit and a verification unit, wherein the receiving unit is used for receiving an object file containing data to be imported, and the object file contains a first identifier used for indicating a verification result of the data to be imported; an obtaining unit configured to obtain a value of the first identifier; the judging unit is used for judging whether the data to be imported passes the verification according to the value of the first identifier; and the importing unit is used for importing the data in the target file when the judging unit judges that the data to be imported passes the verification.
According to a fourth aspect of the embodiments of the present invention, there is provided a data import apparatus including: the verification unit is used for verifying the data to be imported in the target file to obtain a verification result; the generating unit is used for generating a first identifier in the target file and generating a value of the first identifier according to the checking result; and the transmission unit is used for transmitting the target file to a target system so that the target system can import the data in the target file.
According to a fifth aspect of embodiments of the present invention, there is provided a computer readable medium, on which a computer program is stored, which when executed by a processor, implements the data import method as described in the first aspect of the embodiments above, and/or implements the data import method as described in the second aspect of the embodiments above.
According to a sixth aspect of an embodiment of the present invention, there is provided an electronic apparatus including: one or more processors; a storage device, configured to store one or more programs, which when executed by the one or more processors, cause the one or more processors to implement the data import method according to the first aspect of the above embodiments, and/or implement the data import method according to the second aspect of the above embodiments.
In the technical solutions provided in some embodiments of the present invention, by obtaining a value of a first identifier included in a target file including data to be imported, and determining whether the data to be imported passes verification according to the value of the first identifier, so as to import the data in the target file when determining that the data to be imported passes verification according to the value of the first identifier, on one hand, a verification process of the data to be imported does not need to be performed when the data enters a system, i.e., the verification process of the data can be completed before the data enters the system, which can reduce processing pressure of the system, especially when system traffic is large. On the other hand, a data verification mechanism which is completely the same as that of the target file side does not need to be repeatedly deployed on the system side, and only the verification result contained in the target file needs to be verified on the system side, so that the effect of improving the data import efficiency on the premise of avoiding the wrong data import into the system to the maximum extent is achieved.
In the technical solutions provided in some embodiments of the present invention, whether the version information of the target file meets the requirement is determined according to the value of the second identifier included in the target file, so that the problem of data import failure due to an error in the version of the target file can be avoided, and the purpose of managing the versions of the imported files (the target file is also an imported file) can be achieved.
In the technical scheme provided by some embodiments of the present invention, by recording the latest version information and/or version update track information of each import file for importing various data, the version of each import file can be effectively managed.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention, as claimed.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention. It is obvious that the drawings in the following description are only some embodiments of the invention, and that for a person skilled in the art, other drawings can be derived from them without inventive effort. In the drawings:
FIG. 1 is a flow chart schematically illustrating a data import method according to a first embodiment of the present invention;
FIG. 2 is a flow chart schematically illustrating a data import method according to a second embodiment of the present invention;
FIG. 3 is a flowchart schematically illustrating a data import method according to a third embodiment of the present invention;
FIG. 4 schematically shows an architecture diagram of a data import system according to an embodiment of the present invention;
FIG. 5 shows a schematic diagram of adding an operation instruction and a button in an import template according to an embodiment of the invention;
FIG. 6 is a schematic diagram illustrating a prompt interface after a failure in checking data to be imported according to an embodiment of the present invention;
FIG. 7 illustrates a partial interface schematic in an EBA system according to an embodiment of the invention;
FIG. 8 illustrates a schematic interface diagram for selecting an import file and confirming the import according to an embodiment of the present invention;
FIG. 9 is a schematic diagram illustrating an interface for a version check failure on an import file according to an embodiment of the present invention;
FIG. 10 is a schematic diagram illustrating an interface for a check failure on data in an import file, according to an embodiment of the invention;
FIG. 11 is a diagram illustrating an interface during file import according to an embodiment of the present invention;
FIG. 12 is a diagram illustrating an interface displayed when an error occurs during importing data according to an embodiment of the invention;
FIG. 13 illustrates a field diagram of an import file version table, according to an embodiment of the present invention;
FIG. 14 is a field diagram illustrating an import file version track table, according to an embodiment of the invention;
fig. 15 schematically shows a block diagram of a data import apparatus according to a first embodiment of the present invention;
fig. 16 schematically shows a block diagram of a data import apparatus according to a second embodiment of the present invention;
FIG. 17 illustrates a schematic structural diagram of a computer system suitable for use with the electronic device to implement an embodiment of the invention.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art.
Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to provide a thorough understanding of embodiments of the invention. One skilled in the relevant art will recognize, however, that the invention may be practiced without one or more of the specific details, or with other methods, components, devices, steps, and so forth. In other instances, well-known methods, devices, implementations or operations have not been shown or described in detail to avoid obscuring aspects of the invention.
The block diagrams shown in the figures are functional entities only and do not necessarily correspond to physically separate entities. I.e. these functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor means and/or microcontroller means.
The flow charts shown in the drawings are merely illustrative and do not necessarily include all of the contents and operations/steps, nor do they necessarily have to be performed in the order described. For example, some operations/steps may be decomposed, and some operations/steps may be combined or partially combined, so that the actual execution sequence may be changed according to the actual situation.
Fig. 1 schematically shows a flowchart of a data import method according to a first embodiment of the present invention. It should be noted that: the execution subject of the data import method shown in fig. 1 is the target system to which data is to be imported, such as system a that needs to import data, and then system a executes the data import method shown in fig. 1.
Referring to fig. 1, a data importing method according to a first embodiment of the present invention includes the following steps:
step S10, receiving an object file containing data to be imported, where the object file contains a first identifier for indicating a verification result of the data to be imported.
In an embodiment of the present invention, the target file is an import file, such as an import template, and optionally, the import template may be an Excel template. The first identifier may be a hidden variable, and after the data to be imported is checked in the target file, the hidden variable may be assigned according to a check result, where a value of the hidden variable is a value of the first identifier.
Step S12, obtaining the value of the first identifier, and determining whether the data to be imported passes the verification according to the value of the first identifier.
In the embodiment of the invention, the verification process of the data to be imported is mainly carried out in the target file, so that when the data is imported, whether the data to be imported passes the verification is determined according to the value of the first identifier contained in the target file.
And step S14, when the data to be imported is judged to pass the verification according to the value of the first identifier, importing the data in the target file.
Optionally, the data importing method shown in fig. 1 further includes: and step S16, prohibiting importing the data in the target file when the data to be imported is determined not to pass the verification according to the value of the first identifier.
The data importing method shown in fig. 1 can reduce the processing pressure of the system, especially in the case of large system traffic, because the verification process of the data to be imported does not need to be performed when the data enters the system. Meanwhile, a data verification mechanism which is completely the same as that of the target file side does not need to be repeatedly deployed on the system side, and only the verification result contained in the target file needs to be verified on the system side, so that the effect of improving the data import efficiency on the premise of avoiding the wrong data import into the system to the maximum extent is achieved.
In addition to the data importing method shown in fig. 1, if the target file further includes a second identifier indicating version information of the target file, referring to fig. 2, a data importing method according to a second embodiment of the present invention, before step S12 shown in fig. 1, further includes:
step S11, determining whether the version information of the target file meets the requirement according to the value of the second identifier, and if it is determined that the version information of the target file meets the requirement according to the value of the second identifier, executing step S12, that is, determining whether the data to be imported passes the verification according to the value of the first identifier.
It should be noted that, in the flowchart shown in fig. 2, the step of acquiring the value of the first flag in step S12 occurs after step S11, and in other embodiments of the present invention, the step of acquiring the value of the first flag in step S12 may occur before step S11 or simultaneously with step S11.
Optionally, in an embodiment of the present invention, as shown in fig. 2, the data importing method shown in fig. 2 may further include step S18, and if it is determined that the version information of the target file is not satisfactory according to the value of the second identifier, outputting a prompt message.
The data importing method shown in fig. 2 enables that before determining whether the data to be imported passes the verification according to the value of the first identifier, whether the version information of the target file meets the requirement is also determined, so that the problem that the data import fails due to the fact that the version of the target file is wrong can be avoided, and meanwhile, the purpose of managing the versions of the imported files can be achieved. It should be noted that the second flag may be a hidden constant.
In an exemplary embodiment of the present invention, step S11 shown in fig. 2 may include: judging whether the version of the target file is the latest version or not according to the value of the second identifier and the recorded latest version information of the imported file corresponding to the data to be imported; and if the version of the target file is the latest version, judging that the version information of the target file meets the requirement.
Optionally, the value of the second identifier comprises: a version code of the target file and/or a date on which a version of the target file was last modified.
In the embodiment of the present invention, for the data import method shown in fig. 1 and fig. 2, more verification mechanisms may be further added to verify the data to be imported and the target file. For example, in an embodiment of the present invention, a check date of the data to be imported may be determined according to the value of the first identifier, and a date on which the version of the target file is modified last time may be determined according to the value of the second identifier; when the data to be imported is judged to pass the verification according to the value of the first identifier (if the version of the target file is judged to meet the requirement according to the value of the second identifier), and when the date of the last modification of the version of the target file is earlier than the verification date of the data to be imported, the data in the target file is allowed to be imported.
The technical scheme of the embodiment adds redundancy check, so that the version of the target file is ensured to be a version meeting the requirements, the check process of the data to be imported is also completed on the basis of the latest version of the target file, and further, the error data can be further prevented from being imported into the system.
In addition, in order to achieve effective management of the version of the import file, in an embodiment of the present invention, latest version information of each import file for importing various data may be recorded. Optionally, version update track information of each import file for importing various data may also be recorded, so as to ensure that the update track of each import file is traceable.
In an embodiment of the present invention, the latest version information and the update track information described above may be recorded by a table.
Fig. 3 schematically shows a flowchart of a data import method according to a third embodiment of the present invention. It should be noted that: the execution main body of the data import method shown in fig. 3 is to check the data to be imported and identify the executing party of the check result, and the executing party may be, for example, an Excel document system.
Referring to fig. 3, a data import method according to a third embodiment of the present invention includes the steps of:
and step S30, verifying the data to be imported in the target file to obtain a verification result.
In the embodiment of the invention, if the target file is an Excel file, the data to be imported can be verified in a macro verification manner.
Step S32, generating a first identifier in the target file, and generating a value of the first identifier according to the verification result.
Step S34, the target file is transmitted to a target system, so that the target system can import the data in the target file.
In the data importing method shown in fig. 3, by verifying the data to be imported in the target file, generating the first identifier in the target file, and generating the value of the first identifier according to the verification result, the target system can determine whether the data to be imported passes the verification based on the value of the first identifier after receiving the target file, and does not need to verify the data to be imported again on the target system side, so that the processing pressure of the target system can be reduced, especially in the case of a large system traffic. Meanwhile, the completely same data verification mechanism is not required to be repeatedly deployed on the target system side, and only the verification result contained in the target file needs to be verified on the target system side, so that the effect of improving the data import efficiency is realized on the premise of avoiding wrong data import into the system to the maximum extent.
In some embodiments of the present invention, the data importing method further includes: and if the verification of the data to be imported fails, outputting error prompt information of the verification failure. Alternatively, the error prompt message may be an error log, which can facilitate a technician to adjust the data according to the error log.
In some embodiments of the present invention, optionally, before step S34 shown in fig. 3, the method may further include: generating a second identifier in the target file; and generating the value of the second identifier according to the version information of the target file.
In this embodiment, the second identifier is generated in the target file, and the value of the second identifier is generated according to the version information of the target file, so that after the target file is transmitted to the target system, the target system can check whether the version of the target file is incorrect, thereby avoiding the problem that the data import fails due to the incorrect version of the target file, and simultaneously achieving the purpose of managing the versions of the imported files.
The data importing method according to the embodiment of the present invention is described in the foregoing embodiment from the target system side and from the two aspects of verifying the data to be imported and identifying the executing party of the verification result, and the following description is made from the perspective of combining the two aspects.
In a specific application scenario of the embodiment of the present invention, the insurance industry is taken as an example, wherein the target system may be an EBA (Employee Benefits administration expert) system, and the import file (i.e., the target file) is an Excel file.
Referring to FIG. 4, in the insurance industry, importing a template may include: an underwriting import template, a claim import template, a security import template, and the like. The technical scheme of the embodiment of the invention adds a template importing mechanism at a template importing end and an EBA mechanism at an EBA system end, and concretely introduces the following steps:
1. a template importing mechanism:
in the embodiment of the invention, an operation description sheet page can be added in the Excel import template, and the sheet page is provided with a button, a hidden variable and a hidden constant.
Specifically, referring to fig. 5, an operation instruction sheet page is added to the Excel import template, and the operation instruction can be conveniently operated by an operator (especially a branch operator), so that the operation and maintenance workload caused by personnel replacement and untimely handover in the later period is reduced. The sheet page includes a button 502, and when the button 502 is clicked, the data imported into the template is checked according to the check rule (such as macro check) in the Excel document.
If the check is correct, the button turns green, and the hidden variable is assigned with the "PASS + 8-bit operation date of the day (e.g. 20170720)", and the encryption transcoding process can also be carried out; if the check fails, the hidden variable will be assigned a plain string of "unpass" and a prompt will pop up "error data, modify! Meanwhile, error logs can be listed on a check error log sheet page, as shown in fig. 6, and the check error logs can help operators to find and correct errors.
Meanwhile, the hidden constant may be assigned as "import template corresponding version code + 8-bit date (e.g. 20170718)", and perform the encryption transcoding process.
It should be noted that the hidden variable is the first identifier in the above embodiment of the present invention, and the hidden constant is the second identifier in the above embodiment. The hidden variables and hidden constants are used for checking when the document is imported into the EBA end.
2. The EBA mechanism:
when the import template is imported into the EBA end, the content in the Excel table is read, and if the hidden constant and the hidden variable are not obtained at the specified position, a prompt is given. If the hidden constant and the hidden variable are obtained, decoding the hidden constant, and then checking whether the hidden constant meets the requirements and whether the date is consistent with the corresponding date of the latest version recorded by the EBA system; after the hidden constant is checked to pass, the EBA end decodes the hidden variable, then checks whether the imported variable meets the requirement, and simultaneously can check whether the date in the hidden variable is later than the date corresponding to the latest version in the hidden constant. If the verification is passed, allowing the data to be imported; otherwise, data import is prohibited.
Specifically, referring to fig. 7, which is a schematic view of a part of an interface of an EBA system, in fig. 7, a button 702 is clicked to trigger import of an insured list, then the interface shown in fig. 8 is entered, a file to be imported is selected in the interface shown in fig. 8, and then a button 802 is clicked to trigger an import process. After clicking the button 802, it is checked whether the version of the imported file is the latest version, and if not, a prompt box as shown in fig. 9 is popped up to display a prompt message "the template of the imported file is incorrect, please download a new template".
If the version of the imported file passes the check, the value of the hidden variable is obtained to determine whether the data passes the check, and if the data does not pass the check, a prompt box as shown in fig. 10 pops up to display prompt information that the quality check of the imported file data fails and the importing of the EBA system is not allowed.
If the version of the import file is verified, and the data in the import file is also verified, a prompt box shown in fig. 11 pops up to display a prompt message of "import, please leave".
If an error occurs in the process of importing data, an error log as shown in fig. 12 is displayed to help operators to troubleshoot the problem.
According to the embodiment of the invention, the template importing mechanism and the EBA mechanism are set, so that the error data can be furthest reduced from being imported into the EBA system, and the operation and maintenance work of developers is reduced due to the error data. Meanwhile, the partial verification mechanism is arranged in front (namely, the import template mechanism is arranged), so that the operating pressure of the EBA system can be reduced.
In addition, in the embodiment of the present invention, two tables, which are an import file version table (ebaimamportfiles) and an import file version track table (ebaimamportfilestrace), may be stored in the EBA system.
The imported file version table is used to record all file versions in the EBA system, and fields of the table are shown in fig. 13 and mainly include a file number, a file version, a file name, a remark description, version control, an entry date, an entry time, a last modification date, a last modification time, a spare field 1, a spare field 2, a spare field 3, and the like.
The track table of the version of the imported file is used for recording the update track of the version of the imported file, namely when the version of the imported file is updated, the content of the original version is transferred to the track table. As shown in fig. 14, the fields of the table mainly include a serial number, a file version, a file name, a remark description, version control, an entry date, an entry time, a last modification date, a last modification time, a spare field 1, a spare field 2, a spare field 3, and the like.
According to the embodiment of the invention, the version management of the imported file can be realized by setting the imported file version table and the imported file version track table, so that developers can be helped to better manage all imported templates of the system, the file is ensured to be traceable, and accidental situations such as file mistaken deletion are reduced.
Fig. 15 schematically shows a block diagram of a data import apparatus according to a first embodiment of the present invention.
Referring to fig. 15, a data import apparatus 1500 according to a first embodiment of the present invention includes: a receiving unit 1502, an acquiring unit 1504, a judging unit 1506, and an importing unit 1508.
Specifically, the receiving unit 1502 is configured to receive an object file containing data to be imported, where the object file contains a first identifier used for indicating a verification result of the data to be imported; the obtaining unit 1504 is configured to obtain a value of the first identifier; the judging unit 1506 is configured to judge whether the data to be imported passes verification according to the value of the first identifier; the importing unit 1508 is configured to import the data in the target file when the determining unit 1506 determines that the data to be imported passes verification.
In some embodiments of the present invention, based on the foregoing solution, the target file further includes a second identifier for indicating version information of the target file; the determination unit 1506 is configured to: before judging whether the data to be imported passes the verification according to the value of the first identifier, judging whether the version information of the target file meets the requirement according to the value of the second identifier, and judging whether the data to be imported passes the verification according to the value of the first identifier when judging that the version information of the target file meets the requirement.
In some embodiments of the present invention, based on the foregoing solution, the data importing apparatus 1500 further includes: and an output unit, configured to output prompt information when the determining unit 1506 determines that the version information of the target file does not meet the requirement according to the value of the second identifier.
In some embodiments of the present invention, based on the foregoing scheme, the determining unit 1506 is configured to: judging whether the version of the target file is the latest version or not according to the value of the second identifier and the recorded latest version information of the imported file corresponding to the data to be imported; and if the version of the target file is the latest version, judging that the version information of the target file meets the requirement.
In some embodiments of the present invention, based on the foregoing scheme, the value of the second flag includes: a version code of the target file and/or a date on which a version of the target file was last modified.
In some embodiments of the present invention, based on the foregoing solution, the data importing apparatus 1500 further includes: the determining unit is used for determining the check date of the data to be imported according to the value of the first identifier, and determining the date of the last version modification of the target file according to the value of the second identifier; the importing unit 1508 is configured to: and when the data to be imported passes the verification according to the value of the first identifier and the date of the last version modification of the target file is earlier than the verification date, importing the data in the target file.
In some embodiments of the present invention, based on the foregoing solution, the data importing apparatus 1500 further includes: a first recording unit for recording latest version information of each import file for importing various data.
In some embodiments of the present invention, based on the foregoing solution, the data importing apparatus 1500 further includes: and a second recording unit for recording version update track information of each import file for importing various data.
In some embodiments of the present invention, based on the foregoing scheme, the importing unit 1508 is further configured to: and when the data to be imported is judged not to pass the verification according to the value of the first identifier, the data in the target file is forbidden to be imported.
Fig. 16 schematically shows a block diagram of a data import apparatus according to a second embodiment of the present invention.
Referring to fig. 16, a data import apparatus 1600 according to a second embodiment of the present invention includes: a verification unit 1602, a generation unit 1604, and a transmission unit 1606.
Specifically, the verification unit 1602 is configured to verify data to be imported in the target file to obtain a verification result; the generating unit 1604 is configured to generate a first identifier in the target file, and generate a value of the first identifier according to the verification result; the transmission unit 1606 is configured to transmit the target file to a target system, so that the target system imports data in the target file.
In some embodiments of the present invention, based on the foregoing scheme, the generating unit 1604 is further configured to: generating a second identifier in the target file before transmitting the target file to the target system; and generating the value of the second identifier according to the version information of the target file.
In some embodiments of the present invention, based on the foregoing solution, the data importing apparatus 1600 further includes: and the output unit is used for outputting error prompt information of verification failure when the verification of the data to be imported fails.
Referring now to FIG. 17, shown is a block diagram of a computer system 1700 suitable for use in implementing an electronic device of an embodiment of the present invention. The computer system 1700 of the electronic device shown in fig. 17 is only an example, and should not bring any limitation to the function and the scope of use of the embodiments of the present invention.
As shown in fig. 17, the computer system 1700 includes a Central Processing Unit (CPU)1701 which can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)1702 or a program loaded from a storage portion 1708 into a Random Access Memory (RAM) 1703. In the RAM 1703, various programs and data necessary for system operation are also stored. The CPU 1701, ROM 1702, and RAM 1703 are connected to each other through a bus 1704. An input/output (I/O) interface 1705 is also connected to bus 1704.
The following components are connected to the I/O interface 1705: an input section 1706 including a keyboard, a mouse, and the like; an output portion 1707 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 1708 including a hard disk and the like; and a communication section 1709 including a network interface card such as a LAN card, a modem, or the like. The communication section 1709 performs communication processing via a network such as the internet. A driver 1710 is also connected to the I/O interface 1705 as necessary. A removable medium 1711 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 1710 as necessary, so that a computer program read out therefrom is mounted into the storage portion 1708 as necessary.
In particular, according to an embodiment of the present invention, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the invention include a computer program product comprising a computer program embodied on a computer-readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via the communication portion 1709, and/or installed from the removable media 1711. The computer program executes the above-described functions defined in the system of the present application when executed by the Central Processing Unit (CPU) 1701.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present invention may be implemented by software, or may be implemented by hardware, and the described units may also be disposed in a processor. Wherein the names of the elements do not in some way constitute a limitation on the elements themselves.
As another aspect, the present application also provides a computer-readable medium, which may be contained in the electronic device described in the above embodiments; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs, which when executed by an electronic device, cause the electronic device to implement the online live broadcast-based message push method as described in the above embodiments.
For example, the electronic device may implement the following as shown in fig. 1: step S10, receiving an object file containing data to be imported, wherein the object file contains a first identifier for indicating a verification result of the data to be imported; step S12, obtaining the value of the first identifier, and judging whether the data to be imported passes the check according to the value of the first identifier; and step S14, when the data to be imported is judged to pass the verification according to the value of the first identifier, importing the data in the target file. Step S16 shown in fig. 1 may also be implemented, and when it is determined that the data to be imported does not pass verification according to the value of the first identifier, the data in the target file is prohibited from being imported.
As another example, the electronic device may implement the various steps shown in fig. 2 and 3.
It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the invention. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.
Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein may be implemented by software, or by software in combination with necessary hardware. Therefore, the technical solution according to the embodiment of the present invention can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a usb disk, a removable hard disk, etc.) or on a network, and includes several instructions to enable a computing device (which can be a personal computer, a server, a touch terminal, or a network device, etc.) to execute the method according to the embodiment of the present invention.
Other embodiments of the invention will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the invention and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the invention being indicated by the following claims.
It will be understood that the invention is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the invention is limited only by the appended claims.
Claims (14)
1. A data import method, comprising:
receiving an object file containing data to be imported, wherein the object file contains a first identifier used for indicating a verification result of the data to be imported;
acquiring the value of the first identifier, and judging whether the data to be imported passes the verification according to the value of the first identifier;
when the data to be imported is judged to pass the verification according to the value of the first identifier, importing the data in the target file;
the target file also comprises a second identifier used for indicating the version information of the target file;
the data import method further comprises the following steps: before judging whether the data to be imported passes the verification according to the value of the first identifier, judging whether the version information of the target file meets the requirement according to the value of the second identifier;
and if the version information of the target file is judged to meet the requirement according to the value of the second identifier, judging whether the data to be imported passes the verification according to the value of the first identifier.
2. The data import method according to claim 1, further comprising:
and if the version information of the target file is judged to be not in accordance with the requirement according to the value of the second identifier, outputting prompt information.
3. The data import method according to claim 1, wherein determining whether the version information of the target file meets the requirement according to the value of the second identifier comprises:
judging whether the version of the target file is the latest version or not according to the value of the second identifier and the recorded latest version information of the imported file corresponding to the data to be imported;
and if the version of the target file is the latest version, judging that the version information of the target file meets the requirement.
4. The data import method of claim 3, wherein the value of the second identifier comprises: a version code of the target file and/or a date on which a version of the target file was last modified.
5. The data import method according to claim 1, further comprising:
determining the check date of the data to be imported according to the value of the first identifier, and determining the date of the last version modification of the target file according to the value of the second identifier;
and when the data to be imported passes the verification according to the value of the first identifier and the date of the last version modification of the target file is earlier than the verification date, importing the data in the target file.
6. The data import method according to claim 1, further comprising:
latest version information of each import file for importing various data is recorded.
7. The data import method according to claim 1, further comprising:
version update track information of each import file for importing various data is recorded.
8. The data import method according to any one of claims 1 to 7, further comprising:
and when the data to be imported is judged not to pass the verification according to the value of the first identifier, the data in the target file is forbidden to be imported.
9. A data import method, comprising:
verifying the data to be imported in the target file to obtain a verification result;
generating a first identifier in the target file, and generating a value of the first identifier according to the verification result;
transmitting the target file to a target system so that the target system can import the data in the target file;
before transmitting the target file to the target system, further comprising:
generating a second identifier in the target file;
and generating the value of the second identifier according to the version information of the target file.
10. The data import method according to claim 9, further comprising:
and if the verification of the data to be imported fails, outputting error prompt information of the verification failure.
11. A data importing apparatus, comprising:
the device comprises a receiving unit, a verification unit and a verification unit, wherein the receiving unit is used for receiving an object file containing data to be imported, and the object file contains a first identifier used for indicating a verification result of the data to be imported;
an obtaining unit configured to obtain a value of the first identifier;
the judging unit is used for judging whether the data to be imported passes the verification according to the value of the first identifier;
the import unit is used for importing the data in the target file when the judgment unit judges that the data to be imported passes the verification;
the target file also comprises a second identifier used for indicating the version information of the target file;
the judging unit is further configured to: before judging whether the data to be imported passes the verification according to the value of the first identifier, judging whether the version information of the target file meets the requirement according to the value of the second identifier; and if the version information of the target file is judged to meet the requirement according to the value of the second identifier, judging whether the data to be imported passes the verification according to the value of the first identifier.
12. A data importing apparatus, comprising:
the verification unit is used for verifying the data to be imported in the target file to obtain a verification result;
the generating unit is used for generating a first identifier in the target file and generating a value of the first identifier according to the checking result;
the transmission unit is used for transmitting the target file to a target system so that the target system can import the data in the target file;
the generation unit is further configured to: generating a second identifier in the target file before transmitting the target file to the target system; and generating the value of the second identifier according to the version information of the target file.
13. A computer-readable medium, on which a computer program is stored, which, when being executed by a processor, implements the data import method of any of claims 1 to 8 and/or implements the data import method of any of claims 9 to 10.
14. An electronic device, comprising:
one or more processors;
storage means for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a data import method as claimed in any one of claims 1 to 8, and/or to implement a data import method as claimed in any one of claims 9 to 10.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711121038.4A CN107798128B (en) | 2017-11-14 | 2017-11-14 | Data import method, device, medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711121038.4A CN107798128B (en) | 2017-11-14 | 2017-11-14 | Data import method, device, medium and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107798128A CN107798128A (en) | 2018-03-13 |
| CN107798128B true CN107798128B (en) | 2021-10-29 |
Family
ID=61534929
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711121038.4A Active CN107798128B (en) | 2017-11-14 | 2017-11-14 | Data import method, device, medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107798128B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489251A (en) * | 2019-08-15 | 2019-11-22 | 中国银行股份有限公司 | A kind of anti-weighing method of data importing, equipment and system based on information system |
| CN111258832B (en) * | 2020-01-22 | 2023-06-20 | 泰康保险集团股份有限公司 | Interface parameter verification method, device, equipment and medium |
| CN113239048B (en) * | 2021-05-26 | 2023-03-03 | 五八有限公司 | Data management method and device, electronic equipment and storage medium |
| CN113887188A (en) * | 2021-10-09 | 2022-01-04 | 上海通联金融服务有限公司 | Implementation method for generating card making file based on excel file analysis |
Family Cites Families (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8229906B2 (en) * | 2004-05-14 | 2012-07-24 | Sap Ag | Multi-level version format |
| US20120296878A1 (en) * | 2010-01-21 | 2012-11-22 | Nec Corporation | File set consistency verification system, file set consistency verification method, and file set consistency verification program |
| US20110191304A1 (en) * | 2010-01-29 | 2011-08-04 | Software Ag, Inc. | System and method for export and import of metadata located in metadata registries |
| CN102945160A (en) * | 2012-10-24 | 2013-02-27 | 浪潮集团山东通用软件有限公司 | General method for importing Excel data independent of rule configurations |
| US9582665B2 (en) * | 2014-01-21 | 2017-02-28 | Operation and Data integrity Ltd. | Technologies for protecting systems and data to prevent cyber-attacks |
| CN104123271B (en) * | 2014-08-01 | 2017-10-31 | 贵阳供电局 | Intelligent substation secondary design system based on Excel |
| CN104331468A (en) * | 2014-10-31 | 2015-02-04 | 深圳市东信时代信息技术有限公司 | Excel verification lead-in system and method |
| CN104361139B (en) * | 2014-12-10 | 2019-04-16 | 用友网络科技股份有限公司 | Data importing device and method |
| CN105808375A (en) * | 2014-12-31 | 2016-07-27 | 航天信息软件技术有限公司 | Data import method and device |
| CN105989021A (en) * | 2015-01-29 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Document processing method and device |
| CN106503222A (en) * | 2016-11-04 | 2017-03-15 | 上海轻维软件有限公司 | Batch based on Excel imports the method and device of management data base |
| CN106874484A (en) * | 2017-02-20 | 2017-06-20 | 济南浪潮高新科技投资发展有限公司 | The method and device that a kind of data are imported |
-
2017
- 2017-11-14 CN CN201711121038.4A patent/CN107798128B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN107798128A (en) | 2018-03-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107798128B (en) | Data import method, device, medium and electronic equipment | |
| CN111158674B (en) | Component management method, system, device and storage medium | |
| US9658842B2 (en) | Application runtime expert for deployment of an application on multiple computer systems | |
| US10261772B2 (en) | Method and device for generating image file | |
| CN106575227B (en) | Automatic software update framework | |
| EP3428828B1 (en) | System and method for locating and correcting vulnerabilites in a target computer system | |
| CN112417178B (en) | Document template definition-based on-chain contract processing method and device and electronic equipment | |
| CN114118047A (en) | Report generation method, device, equipment and computer storage medium | |
| DE602004009639T2 (en) | Method or device for authenticating digital data by means of an authentication plug-in | |
| CN114528008A (en) | Code control method, device and medium based on distributed version control system | |
| CN110597888A (en) | Method, device, medium and equipment for acquiring virtual resources based on block chains | |
| CN111338869B (en) | Configuration parameter management method, device, equipment and storage medium | |
| CN111367531B (en) | Code processing method and device | |
| CN113330419A (en) | Equipment application installation method and device | |
| CN113687858A (en) | Configuration file checking method and device, electronic equipment and storage medium | |
| CN111290961A (en) | Interface test management method and device and terminal equipment | |
| JP2011018322A (en) | System, method and computer program for automating record declaration of electronic document | |
| CN109683942B (en) | Script management method, script management device, script management medium and electronic equipment | |
| CN109558163B (en) | Version generation and management method based on running file in controller | |
| CN110795259A (en) | Method and device for analyzing application collapse | |
| CN114677211A (en) | Credit parameter updating method, apparatus, electronic device, medium, and program product | |
| CN114170006A (en) | Information data acquisition method, device, equipment and medium based on state machine | |
| EP3771139B1 (en) | Operational safety using a distributed ledger | |
| US11947445B2 (en) | Adjustment of operating parameters of arranged software assets | |
| CN112132694B (en) | Method, device, equipment and storage medium for confirming and checking policy and security case |
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 |