CN105808375A - Data import method and device - Google Patents
Data import method and device Download PDFInfo
- Publication number
- CN105808375A CN105808375A CN201410857096.3A CN201410857096A CN105808375A CN 105808375 A CN105808375 A CN 105808375A CN 201410857096 A CN201410857096 A CN 201410857096A CN 105808375 A CN105808375 A CN 105808375A
- Authority
- CN
- China
- Prior art keywords
- data
- template
- importing
- information
- import
- 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.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data import method and device. The method comprises the following steps: obtaining to-be-imported first data and template information of the first data; obtaining a first data template corresponding to the template information; importing the first data into a database according to the first data template; storing the import information of the first data so as to obtain a log file of the first data, wherein the import information is used for describing state information recorded in the process of importing the first data into the database. Through the data import method and device, the problem that the data templates for importing business data are bad in compatibility in the prior art is solved, and the effect of improving the compatibility of the data templates is realized.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of method and apparatus importing data.
Background technology
For client and the enforcement personnel of software or system, when doing business datum or initializing basic data, it is necessary to carry out large batch of data import operation, the workload of operator is very big, burden is very heavy.
Existing data import tool, is typically all the simple importing carrying out some data according to fixing data importing template, such that it is able to the workload of minimizing client and raising work efficiency, but consider the business verification property before data importing and treatability seldom neatly.Some import tool, it is fixing that data import template, lack the importing of document template for different patterns, difference due to the difference of operational data structure (such as the master meter structure to one or more sublists), work organization type (such as finance organization type, management organization type or administrative organization type etc.), the data being difficult to complicated Data Integration together to carry out concentrating import, and are difficult to adapt to different demands and the application scenarios of client.It addition, existing data import tool, although provide the log information of record corrupt data, it is possible to helping client to provide error in data information, but be the absence of importing being accurately positioned of daily record, client cannot navigate to the Data Position made mistakes quickly and easily.
Some data import tool of the prior art, particularly with the Excel instrument being template, it does not have consider its version problem, that is, existing data import tool, or only support the version of Excel2003, only support the version of Excel2007, lack the compatibility to various versions.
For the problem of the poor compatibility of the data template importing business datum in prior art, effective solution is not yet proposed at present.
Summary of the invention
Present invention is primarily targeted at a kind of method and apparatus importing data of offer, with the problem solving to import the poor compatibility of the data template of business datum in prior art.
To achieve these goals, an aspect according to embodiments of the present invention, it is provided that a kind of method importing data, the method includes: obtain the Template Information of the first data to be imported and the first data；Obtain the first data template that Template Information is corresponding；According to the first data template, the first data are imported data base；Preserving the import information of the first data, obtain the journal file of the first data, wherein, import information is for describing the status information of record in the process that the first data import data base.
Further, according to the first data template, the first data are imported data base to include: read the second data of the configuration parameter of corresponding first data template in the first data；Change the form of the second data according to the form of data base, obtain the 3rd data after form conversion；Obtaining the verification condition that the attribute data of the first data is corresponding, wherein, verification condition is what pre-set；Use verification condition that the 3rd data are verified；If the 3rd data check success, then the 3rd data are imported data base；If the 3rd data do not verify successfully, then there is importing the error message of mistake in record the 3rd data.
Further, use verification condition the 3rd data are carried out verification to include: judge the Name Length of the 3rd data whether more than pre-set length threshold, the 3rd data title in whether comprise whether preset characters and data base exist the 3rd data；Do not comprise if the Name Length of the 3rd data is not more than in the title of pre-set length threshold, the 3rd data preset characters and data base are absent from the 3rd data, then judge the 3rd data check success；If the Name Length of the 3rd data more than pre-set length threshold, the 3rd data title in comprise in preset characters or data base existence the 3rd data, then judge that the 3rd data do not verify successfully.
Further, record the 3rd data and occur that the error message importing mistake includes: errors present and the error reason of mistake occur importing in record the 3rd data, wherein, errors present is for describing the data occurring importing mistake position in the first data, and error reason imports, in the 3rd data, the reason occurring importing mistake in the process of data base for describing.
Further, preserving the import information of the first data, the journal file obtaining the first data includes: import number of times, the sum occurring importing the first data of mistake and the importing time of the first data that statistics imports obtain statistical information；Preserve statistical information, each errors present occurring importing the data of mistake and error reason and obtain journal file.
To achieve these goals, another aspect according to embodiments of the present invention, it is provided that a kind of device importing data, this device includes: the first acquisition module, for obtaining the Template Information of the first data to be imported and the first data；Second acquisition module, for obtaining the first data template that Template Information is corresponding；Import module, for the first data being imported data base according to the first data template；Preserving module, for preserving the import information of the first data, obtain the journal file of the first data, wherein, import information is for describing the status information of record in the process that the first data import data base.
Further, import module and include: the first read module, for reading the second data of the configuration parameter of corresponding first data template in the first data；Modular converter, for changing the form of the second data according to the form of data base, obtains the 3rd data after form conversion；3rd acquisition module, the verification condition corresponding for obtaining the attribute data of the first data, wherein, verification condition is what pre-set；Correction verification module, is used for using verification condition that the 3rd data are verified；Import submodule, for, in the 3rd successful situation of data check, the 3rd data being imported data base；Logging modle, for not verifying in successful situation in the 3rd data, there is importing the error message of mistake in record the 3rd data.
Further, correction verification module includes: judge module, for judge the Name Length of the 3rd data whether more than pre-set length threshold, the 3rd data title in whether comprise whether preset characters and data base exist the 3rd data；First determines module, for when the Name Length of the 3rd data be not more than in the title of pre-set length threshold, the 3rd data not comprise preset characters and data base are absent from three data, it is determined that the 3rd data check success；Second determines module, for when the 3rd data Name Length more than pre-set length threshold, the 3rd data title in comprise in preset characters or data base exist three data, it is determined that the 3rd data do not verify successfully.
Further, logging modle includes: record sub module, errors present and the error reason of mistake occur importing for recording the 3rd data, wherein, errors present is for describing the data occurring importing mistake position in the first data, and error reason imports, in the 3rd data, the reason occurring importing mistake in the process of data base for describing.
Further, preserving module and include: statistical module, import number of times, the sum occurring importing the first data of mistake and importing time for adding up the first data of importing obtain statistical information；Preserve submodule, obtain journal file for preserving statistical information, each errors present occurring importing the data of mistake and error reason.
Adopt the embodiment of the present invention, after obtaining the first data to be imported and Template Information thereof, obtaining the first data template that Template Information is corresponding, then according to the first data are imported data base by the first data template, and the import information preserving correspondence obtains journal file.In the above-described embodiments, when carrying out importing business datum (i.e. the first data in above-described embodiment), can neatly according to different Template Information obtain different pieces of information template (as, the data template of different editions and different pattern), avoid data import tool in prior art and the problem of the data template of a kind of version can only be provided, improve the compatibility of data template.By the embodiment of the present invention, the problem solving the poor compatibility of the data template importing business datum in prior art, it is achieved that improve the compatible effect of data template.
Accompanying drawing explanation
The accompanying drawing constituting the part of the application is used for providing a further understanding of the present invention, and the schematic description and description of the present invention is used for explaining the present invention, is not intended that inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the flow chart of the method for importing data according to embodiments of the present invention；
Fig. 2 is the flow chart of the method for a kind of optional importing data according to embodiments of the present invention；
Fig. 3 is a kind of schematic diagram optionally with the main interface of import tool in importing data according to embodiments of the present invention；
Fig. 4 is the download flow chart of a kind of optional data template according to embodiments of the present invention；
Fig. 5 is a kind of schematic diagram optionally with the import tool in importing data according to embodiments of the present invention；
Fig. 6 is the operational flowchart of a kind of optional importing data according to embodiments of the present invention；
Fig. 7 is the surface chart of a kind of optional Template Manager according to embodiments of the present invention；And
Fig. 8 is the schematic diagram of the device of importing data according to embodiments of the present invention.
Detailed description of the invention
It should be noted that when not conflicting, the embodiment in the application and the feature in embodiment can be mutually combined.Describe the present invention below with reference to the accompanying drawings and in conjunction with the embodiments in detail.
In order to make those skilled in the art be more fully understood that the present invention program, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the embodiment of a present invention part, rather than whole embodiments.Based on the embodiment in the present invention, the every other embodiment that those of ordinary skill in the art obtain under not making creative work premise, all should belong to the scope of protection of the invention.
It should be noted that term " first " in description and claims of this specification and above-mentioned accompanying drawing, " second " etc. are for distinguishing similar object, without being used for describing specific order or precedence.Should be appreciated that the data of so use can be exchanged in the appropriate case, in order to embodiments of the invention described herein.In addition, term " includes " and " having " and their any deformation, it is intended to cover non-exclusive comprising, such as, contain series of steps or the process of unit, method, system, product or equipment be not necessarily limited to those steps or the unit clearly listed, but can include clearly not listing or for intrinsic other step of these processes, method, product or equipment or unit.
Embodiments provide a kind of method importing data.
Fig. 1 is the flow chart of the method for importing data according to embodiments of the present invention.As it is shown in figure 1, the method can comprise the following steps that
Step S102, obtains the Template Information of the first data to be imported and the first data.
Step S104, obtains the first data template that Template Information is corresponding.
First data are imported data base according to the first data template by step S106.
Step S108, preserves the import information of the first data, obtains the journal file of the first data.
Wherein, import information is for describing the status information of record in the process that the first data import data base.
In embodiments of the present invention, Template Information can include template version information and formwork style information.
Adopt the embodiment of the present invention, after obtaining the first data to be imported and Template Information thereof, obtaining the first data template that Template Information is corresponding, then according to the first data are imported data base by the first data template, and the import information preserving correspondence obtains journal file.In the above-described embodiments, when carrying out importing business datum (i.e. the first data in above-described embodiment), can neatly according to different Template Information obtain different pieces of information template (as, the data template of different editions and different pattern), avoid data import tool in prior art and the problem of the data template of a kind of version can only be provided, improve the compatibility of data template.By the embodiment of the present invention, the problem solving the poor compatibility of the data template importing business datum in prior art, it is achieved that improve the compatible effect of data template.
In the above embodiment of the present invention, the first data can be business datum (business paper or the basic data such as various complexity, for instance the buying order data of finance tissue)；First data template can be the data template of Excel version, template version indicated by the Template Information of this data template can be Excel2003 version, Excel2007 version or Excel2010 version etc., and the pattern of this template can be the pattern of different rows number and columns.
Pass through the above embodiment of the present invention, record the status of processes information that business datum is imported data base when business datum being imported data base and obtain journal file, journal file can misregistration data accurate location (as, the row and column at wrong data place), such that it is able to the business datum importing mistake is accurately positioned, it is easy to the business datum of time update mistake and again imports, it is achieved that the business datum of mistake when importing data is carried out pinpoint effect.
According to the above embodiment of the present invention, according to the first data template, the first data are imported data base and may include that the second data of the configuration parameter of corresponding first data template in reading the first data；Change the form of the second data according to the form of data base, obtain the 3rd data after form conversion；Obtaining the verification condition that the attribute data of the first data is corresponding, wherein, verification condition is what pre-set；Use verification condition that the 3rd data are verified；If the 3rd data check success, then the 3rd data are imported data base；If the 3rd data do not verify successfully, then there is importing the error message of mistake in record the 3rd data.
Specifically, second data corresponding with the configuration parameter of the first data template are read from the first data, and be that database format obtains the 3rd data by the Data Format Transform of these the second data, then use the verification condition pre-set that the 3rd data are verified, be conducted into data base when the 3rd data check success；Its error message occurring importing mistake is recorded when the 3rd data do not verify success.
Further, use verification condition the 3rd data are verified may include that the Name Length judging the 3rd data whether more than pre-set length threshold, the 3rd data title in whether comprise whether preset characters and data base exist the 3rd data；Do not comprise if the Name Length of the 3rd data is not more than in the title of pre-set length threshold, the 3rd data preset characters and data base are absent from the 3rd data, then judge the 3rd data check success；If the Name Length of the 3rd data more than pre-set length threshold, the 3rd data title in comprise in preset characters or data base existence the 3rd data, then judge that the 3rd data do not verify successfully.
Specifically, the title degree of the 3rd data be not more than in the title of pre-set length threshold, the 3rd data not comprise preset characters and data base are absent from three data time, it is judged that the 3rd data check success, and the 3rd data are imported data base；The 3rd data Name Length more than pre-set length threshold, the 3rd data title in comprise in preset characters or data base exist three data time, it is judged that the 3rd data do not verify successfully, and record its occur import mistake error message.
In the above embodiment of the present invention, record the 3rd data and occur that importing wrong error message may include that errors present and the error reason of mistake occur importing in record the 3rd data, wherein, errors present is for describing the data occurring importing mistake position in the first data, and error reason imports, in the 3rd data, the reason occurring importing mistake in the process of data base for describing.
Specifically, there is importing errors present and the error reason of mistake in record the 3rd data, can be checked specifically which corrupt data in the first data of correspondence by this errors present；Error reason can record the 3rd data in detail and occur importing the reason of mistake in the process importing data base, as Name Length exceedes, pre-set length threshold, title contain forbidden character (i.e. preset characters in above-described embodiment), or data base has existed these data, cannot be capped (as, during these data are present in data base and are currently in use, therefore cannot cover, update or delete these data, or not allow to cover existing data in data base).
In the above embodiment of the present invention, whether the data form that verification condition can also include the 3rd data is correct, and the data form in the row of client gender can not be numeral, "Yes", "No" or null value etc..
Need further illustrate be, do not verify in successful situation in the 3rd data, can generate for pointing out user that the information of data importing mistake occurs, and the error message importing the data of mistake is showed user, to describe the reason that first data (such as business datum) corresponding with the 3rd data are made mistakes in detail.
Passing through the above embodiment of the present invention, it is possible to point out user to import data from the aspect of business datum and the concrete reason of mistake occur, it is simple to user, for this prompting, is precisely located the position of wrong data, data that time update makes mistakes also are conducted into data base again.
The above embodiment of the present invention is discussed in detail below in conjunction with Fig. 2.As in figure 2 it is shown, the method may include steps of:
Step S202, reads template configuration data.
Step S204, processing template configuration data.
Specifically, template configuration data are converted to the code that computer program may identify which.
Step S206, processes file data according to template configuration data.
Wherein, file data and the first data in the above embodiment of the present invention, it can be business datum, such as the business datum (such as user logging forms data) of the business datum (such as buying order data) of finance tissue or management tissue.
Step S208, is converted to database format by the form of file data.
Such as, for these data of the client segmentation in file data, initially set up and safeguard field, this maintenance field for fill in client geographic classification (as, North China), create corresponding client (such as Zhang San), for the major key (this major key is used for identifying client) of client's allocation database, set up the mapping relations of major key and client and the geographic classification of client.
Step S210, the business verification before file data is imported.
3rd data are verified by the use verification condition in the step S210 correspondence the above embodiment of the present invention in this embodiment；Business verification can be realized by verification plug-in unit.
Step S212, the Business Processing before file data is imported.
Specifically, Business Processing can be passed through to process plug-in unit and realize, JDK (JavaDevelopmentKit can be utilized, the i.e. SDK of Java language) reflex mechanism principle, before file data imports, can not stop producing the service of the system of file data, dynamically add or delete verification plug-in unit and process plug-in unit, thus carrying out data check or the process of necessity.
Step S214, imports data base by file data.
Specifically, file data is copied in data template, by data template, file data is imported to data base.
Step S216, by the importing daily record warehousing of file data.
Wherein, the journal file in daily record and the above embodiment of the present invention is imported.
Specifically, importing for a file data, what first do is reading template configuration data from database template allocation list, then further processing template configuration data, as, template configuration data are converted to the code that computer program may identify which, with after the configuration parameter of follow-up acquisition data template by code file data carried out some basic data structures process (as, by POIExcel digital independent analytic technique file data read in the internal memory of computer), then file data is converted to the data (as arranged the form of file data according to the boss's table relation in data base) of database format；Before carrying out the import operation of file data, need file data is carried out the process (i.e. the verification of business in above-described embodiment) of business datum verification aspect, file data is carried out some special handlings by follow-up needs, as, before file data is imported data base, it is updated the part data (such as customer profile data) in file data processing (as inserted in customer profile data by the bank account information of client)；Then file data is imported in data base, and in the importing process of file data, relevant import information is recorded as journal file and is saved in log sheet.
In the above-described embodiments, POI is PoorObfuscationImplementation, i.e. open source code function storehouse, POI can provide API (ApplicationProgrammingInterface, application programming interface) to the java applet function to MicrosoftOffic format file read and write.
Pass through the above embodiment of the present invention, have employed JDK reflex mechanism principle, the business verification of plug-in and the plug-in card configuration of Business Processing are accomplished, by different verification plug-in units and the configuration processing plug-in unit, achieve the flexible personalisation process to wrong data, by file data is verified, it is ensured that the correctness that data import；By import daily record can Wrong localization data exactly, and according to the demand of user, log content can be defined, so that importing the information of log recording closer to the actual application scenarios of user personalizedly.For importing the importing daily record of business datum (i.e. file data), it is possible to accomplish that ranks are accurately positioned, it is possible to accurately determine the position of corrupt data, and the data made mistakes are modified and again imports.
According to the above embodiment of the present invention, preserving the import information of the first data, the journal file obtaining the first data may include that the importing number of times of the first data, the sum occurring importing the first data of mistake and importing time that statistics imports obtain statistical information；Preserve statistical information, each errors present occurring importing the data of mistake and error reason and obtain journal file.
Specifically, add up to data base import data importing number of times (total number of records as shown in Figure 3), import mistake data sum and import the time (importing time 2014-05-0813:43 as shown in Figure 3) obtain statistical information, preserve statistical information, each errors present and error reason thereof occurring importing the data of mistake, generate journal file.
In an optional embodiment, journal file can be saved in log sheet as shown in Figure 3, and (this log sheet is arranged in the client at the main interface of import tool and imports the page, it can include multiple customer premise template) in, the file name of each journal file can be checked by log sheet, the total number of records, error logging number, import result and the time of importing, and each journal file in click logs table can also look at the detailed log information of each journal file, each errors present and error reasons thereof etc. occurring importing the data of mistake in above-described embodiment.
In this embodiment, the main surface chart of unification when the main interface of import tool as shown in Figure 3 is to use import tool importing data, its client imports and is additionally provided with the feature navigator page and customer page on the page, client imports and is additionally provided with importing template in the page, file imports, import daily record, delete daily record, refresh, help and exit etc. option, wherein, import template options and include customer premise template, can check that each imports the data template of data by this option, file data can be imported in data template by file import option, import logging option and can check the detailed content of each journal file of the first data (such as business datum) in log sheet, delete logging option and can delete journal file.
In the above embodiment of the present invention, obtaining the first data template corresponding to Template Information and may include that reading template configuration data indicated by the first data and the second data template, wherein, the second data template is blank data template；Use template configuration data that the configuration parameter of the second data template is set, obtain the 3rd data template；Use Template Information that the version information of the 3rd data template is set and formwork style obtains the first data template.
Specifically, read the template configuration data indicated by the first data, and read blank second data template of the data type meeting the first data, use the template configuration data read that the configuration parameter of the second blank data template is set, the 3rd data template after being arranged, then using Template Information that version and the pattern of the 3rd data template are set, obtaining the first data template for the first data being imported data base.
Pass through the above embodiment of the present invention, can according to different template configuration data dynamically configuration templates, the template configured is used to import document or the basic data of histological types in bulk in data base, without the manual batch input document of user, improve the work efficiency importing document or basic data, different data templates can support that the data of different operational data structures import.
In the above embodiment of the present invention, at the configuration parameter using template configuration data to arrange the second data template, before obtaining the 3rd data template, delete the temporary file of each history template being previously created at the first data template.
The above embodiment of the present invention being discussed in detail below in conjunction with Fig. 4, flow process as shown in Figure 4 comprises the following steps that
Step S402, reads template configuration data.
Specifically, from database template allocation list, the template configuration data of data template corresponding to business datum (i.e. the first data in above-described embodiment) are read.
Step S404, deleting history temporary file.
Specifically, delete the history temporary file of the former generation preserved on server, in order to avoid history temporary file is too much, take the memory space of server.
Step S406, generates template temporary file.
Specifically, the configuration parameter of newly-built clear data template is set according to the template configuration data read in step S402, produces formwork style temporary file, and this temporary file is stored on the server.
Step S408, downloads template temporary file.
Specifically, from server downloads template pattern temporary file to this locality, in downloading process, a dialog box will be ejected, this dialog box will be prompted to user and selects to preserve the formwork style temporary file of which version to local, after user's Template Information as requested determines version and formwork style, this temporary file is preserved to local, the data template (i.e. the first data template in above-described embodiment) that user needs can be obtained, then business datum is placed in data template, it is possible to carry out data importing.
Pass through the above embodiment of the present invention, POI technology is utilized to realize the download of data template, the Excel template (such as Excel2003 version, Excel2007 version or above version) of different editions can be produced, thus meeting user's compatibility requirement to different editions.
In an optional embodiment of the present invention, it is possible to by the method that import tool as shown in Figure 5 realizes importing data in the above embodiment of the present invention.
Import tool as shown in Figure 5, it is possible to include two and operate greatly module: import management module and template management module.Wherein, importing management module and can include file importing module, this document imports module and is mainly used in the business datum in Excel file to carry out data importing according to the configuration parameter of the current data template selected；Import management module can also include importing log pattern, this importing log pattern is mainly used in record traffic operator and imports, to data system (data system such as a subordinate branch company of group) or data base, the error message that business datum is made mistakes, it is possible to accurately show iog location and concrete wrong content (position and error reason such as wrong data) to business operation person；Template management module can include template configuration module, this template configuration module is mainly used in differently configured pattern, the different business organization type (buying order such as finance organization type, or management organization type user logging list etc.) Template Information, provide function newly-increased, that revise and check, it is possible to easily each data template is carried out maintenance and management.Template management module can also include template download module, business operation person can select the data template of different editions to be downloaded, avoid a kind of import tool in prior art and the problem of the data template of a kind of version can only be provided, solve the different user needs of problems to different templates version.
Further, the template of the multiple different patterns of template configuration module configuration (as including the data template of different line number and columns) can be passed through, import for a kind of business datum, the pattern of the business datum of data base can be imported according to the demand adjustment of user, wherein, the template of different patterns, it is possible to different or data item the data of order being data item are different, it is also possible to the differently configured business remark information of each data item.
By the import tool in the above embodiment of the present invention, can while carrying out business datum importing, various template is dynamically configured easily according to user's request, effectively error message is accurately positioned by journal file, and adapt to, with processing plug-in card configuration, the checking treatment demand that user is different by different verifications, improve the development efficiency of individuation data template.
In this embodiment, business operation person can realize this embodiment by business operation flow process as shown in Figure 6.As shown in Figure 6, this business operation flow process may include that
Step S602, newly-increased data template.
Step S604, downloads data template.
Step S606, places business datum.
Specifically, business datum to be imported is placed in the data template of download, waits and business datum is imported data base.
Step S608, imports business datum.
Step S610, checks journal file.
Specifically, for a business operation operator, before carrying out the importing of business datum, first being made is a newly-increased data template, then use relevant template configuration data that the configuration parameter of this data template is set, being saved in data base by the configuration parameter set, then the data template of the version needed for selection user, carries out the download of data template；After download, in data template, place the business datum of different pieces of information structure, re-use ready data template and carry out the importing of business datum；After importing terminates, it is possible to check the correlation log information (the bar number of the business datum as imported, the i.e. total number of records shown in Fig. 3, or error logging number etc. as shown in Figure 3) that business datum imports.
In this embodiment, POI technology and the data structure rule pre-set can be adopted, realize the data structure that can support a table or the corresponding multiple sublists of master meter in an Excel data template tab, and can according to the data template configured, according to current template configuration different business tissue (as, management tissue, finance tissue, budget organization etc.), batch carries out quick business datum importing.
Further, when importing data, according to the organization type signing in import tool, the data template of corresponding organization type is distributed for business operation person, avoid the business operation person of different business tissue in prior art and can check the problem of the business datum of other work organizations, thus having accomplished the isolation of business datum and work organization.
Pass through the above embodiment of the present invention, provide a kind of import tool quickly introducing business datum according to dynamic template, this import tool is adapted to user's data to different pieces of information structure and organization type and imports, by configuring the verification plug-in unit of plug-in and processing plug-in unit, achieve the accurately verification to business datum and accurately process, ensure that the correctness that business datum imports, the data template of personalization can be set for the demand of different user, improve the maintainability of template development, autgmentability and motility, and this import tool can provide the template of different editions to download, improve the compatibility being available for the data template that user uses.
In this embodiment, the configuration parameter of data template can also be configured by Template Manager interface as shown in Figure 7 or adjust by business operation person, as shown in Figure 7, Template Manager interface (this interface is shown with the form of web page dialog box) can provide newly-increased, preserve, amendment, replicate, cancel, delete, line increment, insert row, delete options such as going and exit, template coding can be set at Template Manager interface, template name, initial line number, terminate the template row name of the every string in line number and template (also show the sequence number of every string and row number in Fig. 7), field name, default value, could be empty, quote coding/title and remarks.nullWherein，Title (the sorting code number as shown in Figure 7 of respective column number in template row data template by name、Specific name、Encoder client、Customer name、Mnemonic code、It is called for short、Foreign language title、Industrial and commercial registration number、Business license、Production/business licence、The tax registration number、Legal representative、Bar code、The tax category、The tax rate (%) and address etc.)，Field name is the title (sorting code number as shown in Figure 7 of business datum to be imported、Specific name、Encoder client、Customer name、Mnemonic code、It is called for short、Foreign language title、Industrial and commercial registration number、Business license、Production/business licence、The tax registration number、Legal representative、Bar code、The tax category、The tax rate (%) and address etc.)，Could be used for arranging in data template this row for sky could be sky，This setting is realized with whether choosing，Quote that what can select in the combobox of coding/title that this row in data template quotes is coding or title，Remarks may be used for this row in data template arrange remark information (as，Text formatting is set or number format etc. is set).
By the Template Manager interface of the import tool in the above embodiment of the present invention, foreground dynamic configuration data template neatly can be carried out, relevant configuration parameter is saved in data base and for follow-up, business datum is carried out data structure process, and provide multiple preset data template, add template duplicating function, it is provided that the data template of different patterns；Template configuration data include the template configuration data of the different business organization type being preset in data, it is possible to meet the different business organization type demand to different pieces of information template；Adopt POIExcel digital independent analytic technique, the problem solving the data template needing different pieces of information structure and different editions；Based on JDK reflex mechanism principle, it is achieved that dynamically produce business verification plug-in unit and process plug-in unit, thus solving the problem being accurately positioned and error message accurately being pointed out to the wrong data in log information.
The embodiment of the present invention additionally provides a kind of device importing data.This device can realize its function by the method for the importing data in the above embodiment of the present invention.
Fig. 8 is the schematic diagram of the device of importing data according to embodiments of the present invention.As shown in Figure 8, this device may include that the first acquisition module 10, for obtaining the Template Information of the first data to be imported and the first data；Second acquisition module 30, for obtaining the first data template that Template Information is corresponding；Import module 50, for the first data being imported data base according to the first data template；Preserving module 70, for preserving the import information of the first data, obtain the journal file of the first data, wherein, import information is for describing the status information of record in the process that the first data import data base.
In embodiments of the present invention, Template Information can include template version information and formwork style information.
Adopt the embodiment of the present invention, after obtaining the first data to be imported and Template Information thereof, obtaining the first data template that Template Information is corresponding, then according to the first data are imported data base by the first data template, and the import information preserving correspondence obtains journal file.In the above-described embodiments, when carrying out importing business datum (i.e. the first data in above-described embodiment), can neatly according to different Template Information obtain different pieces of information template (as, the data template of different editions and different pattern), avoid data import tool in prior art and the problem of the data template of a kind of version can only be provided, improve the compatibility of data template.By the embodiment of the present invention, the problem solving the poor compatibility of the data template importing business datum in prior art, it is achieved that improve the compatible effect of data template.
In the above embodiment of the present invention, the first data can be business datum (business paper or the basic data such as various complexity, for instance the buying order data of finance tissue)；First data template can be the data template of Excel version, template version indicated by the Template Information of this data template can be Excel2003 version, Excel2007 version or Excel2010 version etc., and the pattern of this template can be the pattern of different rows number and columns.
Pass through the above embodiment of the present invention, record the status of processes information that business datum is imported data base when business datum being imported data base and obtain journal file, journal file can misregistration data accurate location (as, the row and column at wrong data place), such that it is able to the business datum importing mistake is accurately positioned, it is easy to the business datum of time update mistake and again imports, it is achieved that the business datum of mistake when importing data is carried out pinpoint effect.
According to the above embodiment of the present invention, import module and may include that the first read module, for reading the second data of the configuration parameter of corresponding first data template in the first data；Modular converter, for changing the form of the second data according to the form of data base, obtains the 3rd data after form conversion；3rd acquisition module, the verification condition corresponding for obtaining the attribute data of the first data, wherein, verification condition is what pre-set；Correction verification module, is used for using verification condition that the 3rd data are verified；Import submodule, for, in the 3rd successful situation of data check, the 3rd data being imported data base；Logging modle, for not verifying in successful situation in the 3rd data, there is importing the error message of mistake in record the 3rd data.
Specifically, second data corresponding with the configuration parameter of the first data template are read from the first data, and be that database format obtains the 3rd data by the Data Format Transform of these the second data, then use the verification condition pre-set that the 3rd data are verified, be conducted into data base when the 3rd data check success；Its error message occurring importing mistake is recorded when the 3rd data do not verify success.
Further, correction verification module may include that judge module, for judge the Name Length of the 3rd data whether more than pre-set length threshold, the 3rd data title in whether comprise whether preset characters and data base exist the 3rd data；First determines module, for when the Name Length of the 3rd data be not more than in the title of pre-set length threshold, the 3rd data not comprise preset characters and data base are absent from three data, it is determined that the 3rd data check success；Second determines module, for when the 3rd data Name Length more than pre-set length threshold, the 3rd data title in comprise in preset characters or data base exist three data, it is determined that the 3rd data do not verify successfully.
Specifically, the title degree of the 3rd data be not more than in the title of pre-set length threshold, the 3rd data not comprise preset characters and data base are absent from three data time, it is judged that the 3rd data check success, and the 3rd data are imported data base；The 3rd data Name Length more than pre-set length threshold, the 3rd data title in comprise in preset characters or data base exist three data time, it is judged that the 3rd data do not verify successfully, and record its occur import mistake error message.
In the above embodiment of the present invention, logging modle may include that record sub module, errors present and the error reason of mistake occur importing for recording the 3rd data, wherein, errors present is for describing the data occurring importing mistake position in the first data, and error reason imports, in the 3rd data, the reason occurring importing mistake in the process of data base for describing.
Specifically, there is importing errors present and the error reason of mistake in record the 3rd data, can be checked specifically which corrupt data in the first data of correspondence by this errors present；Error reason can record the 3rd data in detail and occur importing the reason of mistake in the process importing data base, as Name Length exceedes, pre-set length threshold, title contain forbidden character (i.e. preset characters in above-described embodiment), or data base has existed these data, cannot be capped (as, during these data are present in data base and are currently in use, therefore cannot cover, update or delete, or not allow to cover existing data in data base).
In the above embodiment of the present invention, whether the data form that verification condition can also include the 3rd data is correct, and the data form in the row of client gender can not be numeral, "Yes", "No", or null value etc..
Need further illustrate be, do not verify in successful situation in the 3rd data, can generate for pointing out user that the information of data importing mistake occurs, and the error message importing the data of mistake is showed user, to describe the reason that first data (such as business datum) corresponding with the 3rd data are made mistakes in detail.
Passing through the above embodiment of the present invention, it is possible to point out user to import data from the aspect of business datum and the concrete reason of mistake occur, it is simple to user, for this prompting, is precisely located the position of wrong data, data that time update makes mistakes also are conducted into data base again.
According to the above embodiment of the present invention, preserving module and may include that statistical module, import number of times, the sum occurring importing the first data of mistake and importing time for adding up the first data of importing obtain statistical information；Preserve submodule, obtain journal file for preserving statistical information, each errors present occurring importing the data of mistake and error reason.
Specifically, add up to data base import data importing number of times (total number of records as shown in Figure 3), import mistake data sum and import the time (importing time 2014-05-0813:43 as shown in Figure 3) obtain statistical information, preserve statistical information, each errors present and error reason thereof occurring importing the data of mistake, generate journal file.
In the above embodiment of the present invention, the second acquisition module may include that the second read module, is used for reading the template configuration data indicated by the first data and the second data template, and wherein, the second data template is blank data template；First arranges module, for using template configuration data to arrange the configuration parameter of the second data template, obtains the 3rd data template；Second arranges module, for using Template Information to arrange the version information of the 3rd data template and formwork style obtains the first data template.
Specifically, read the template configuration data indicated by the first data, and read blank second data template of the data type meeting the first data, use the template configuration data read that the configuration parameter of the second blank data template is set, the 3rd data template after being arranged, then using Template Information that version and the pattern of the 3rd data template are set, obtaining the first data template for the first data being imported data base.
Pass through the above embodiment of the present invention, can according to different template configuration data dynamically configuration templates, the template configured is used to import document or the basic data of histological types in bulk in data base, without the manual batch input document of user, improve the work efficiency importing document or basic data, different data templates can support that the data of different operational data structures import.
In the above embodiment of the present invention, at the configuration parameter using template configuration data to arrange the second data template, before obtaining the 3rd data template, delete the temporary file of each history template being previously created at the first data template.
The using method that the modules provided in the present embodiment provides with the corresponding step of embodiment of the method is identical, application scenarios can also be identical.It is noted, of course, that the scheme that above-mentioned module relates to can be not limited to the content in above-described embodiment and scene, and above-mentioned module may operate in terminal or mobile terminal, it is possible to is realized by software or hardware.
As can be seen from the above description, present invention achieves following technique effect:
Adopt the embodiment of the present invention, after obtaining the first data to be imported and Template Information thereof, obtaining the first data template that Template Information is corresponding, then according to the first data are imported data base by the first data template, and the import information preserving correspondence obtains journal file.In the above-described embodiments, when carrying out importing business datum (i.e. the first data in above-described embodiment), can neatly according to different Template Information obtain different pieces of information template (as, the data template of different editions and different pattern), avoid data import tool in prior art and the problem of the data template of a kind of version can only be provided, improve the compatibility of data template.By the embodiment of the present invention, the problem solving the poor compatibility of the data template importing business datum in prior art, it is achieved that improve the compatible effect of data template.
Obviously, those skilled in the art should be understood that, each module of the above-mentioned present invention or each step can realize with general calculation element, they can concentrate on single calculation element, or it is distributed on the network that multiple calculation element forms, alternatively, they can realize with the executable program code of calculation element, thus, can be stored in storage device is performed by calculation element, or they are fabricated to respectively each integrated circuit modules, or the multiple modules in them or step are fabricated to single integrated circuit module realize.So, the present invention is not restricted to the combination of any specific hardware and software.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, any amendment of making, equivalent replacement, improvement etc., should be included within protection scope of the present invention.
Claims (10)
1. the method importing data, it is characterised in that including:
Obtain the first data to be imported and the Template Information of described first data；
Obtain the first data template that described Template Information is corresponding；
According to described first data template, described first data are imported data base；
Preserving the import information of described first data, obtain the journal file of described first data, wherein, described import information is for describing the status information of record in the process that described first data import described data base.
2. method according to claim 1, it is characterised in that according to described first data template, described first data are imported data base and include:
Read the second data of the configuration parameter of corresponding described first data template in described first data；
Change the form of described second data according to the form of described data base, obtain the 3rd data after form conversion；
Obtaining the verification condition that the attribute data of described first data is corresponding, wherein, described verification condition is what pre-set；
Use described verification condition that described 3rd data are verified；
If described 3rd data check success, then described 3rd data are imported described data base；
If described 3rd data do not verify successfully, then record described 3rd data and occur importing the error message of mistake.
3. method according to claim 2, it is characterised in that use described verification condition that described 3rd data are carried out verification and include:
Judge the Name Length of described 3rd data whether more than pre-set length threshold, described 3rd data title in whether comprise whether preset characters and described data base exist described 3rd data；
Do not comprise if the Name Length of described 3rd data is not more than in the title of described pre-set length threshold, described 3rd data described preset characters and described data base are absent from described 3rd data, then judge described 3rd data check success；
If the Name Length of described 3rd data more than described pre-set length threshold, described 3rd data title in comprise described preset characters or described data base exist described 3rd data, then judge that described 3rd data do not verify successfully.
4. method according to claim 2, it is characterised in that record described 3rd data and occur that the error message importing mistake includes:
Record described 3rd data and the described errors present importing mistake and error reason occur,
Wherein, described errors present is for describing the data occurring importing mistake position in described first data, and described error reason imports, in described 3rd data, the reason occurring importing mistake in the process of described data base for describing.
5. method according to claim 4, it is characterised in that preserve the import information of described first data, the journal file obtaining described first data includes:
Add up the importing number of times of described first data imported, occur that the sum of described the first data importing mistake and importing time obtain statistical information；
Preserve described statistical information, each described described errors present importing wrong data of appearance and described error reason and obtain described journal file.
6. the device importing data, it is characterised in that including:
First acquisition module, for obtaining the first data to be imported and the Template Information of described first data；
Second acquisition module, for obtaining the first data template that described Template Information is corresponding；
Import module, for described first data being imported data base according to described first data template；
Preserving module, for preserving the import information of described first data, obtain the journal file of described first data, wherein, described import information is for describing the status information of record in the process that described first data import described data base.
7. device according to claim 6, it is characterised in that described importing module includes:
First read module, for reading the second data of the configuration parameter of corresponding described first data template in described first data；
Modular converter, for changing the form of described second data according to the form of described data base, obtains the 3rd data after form conversion；
3rd acquisition module, the verification condition corresponding for obtaining the attribute data of described first data, wherein, described verification condition is what pre-set；
Correction verification module, is used for using described verification condition that described 3rd data are verified；
Import submodule, for, in the described 3rd successful situation of data check, described 3rd data being imported described data base；
Logging modle, for not verifying in successful situation in described 3rd data, records described 3rd data and occurs importing the error message of mistake.
8. device according to claim 7, it is characterised in that described correction verification module includes:
Judge module, for judge the Name Length of described 3rd data whether more than pre-set length threshold, described 3rd data title in whether comprise whether preset characters and described data base exist described 3rd data；
First determines module, when described preset characters and described data base being absent from described three data for being not more than in the title of described pre-set length threshold, described 3rd data not comprise at the Name Length of described 3rd data, it is determined that described 3rd data check success；
Second determines module, for when the Name Length of described 3rd data more than described pre-set length threshold, described 3rd data title in comprise there are described three data in described preset characters or described data base, it is determined that described 3rd data do not verify successfully.
9. device according to claim 7, it is characterised in that described logging modle includes:
, there is the described errors present importing mistake and error reason for recording described 3rd data in record sub module,
Wherein, described errors present is for describing the data occurring importing mistake position in described first data, and described error reason imports, in described 3rd data, the reason occurring importing mistake in the process of described data base for describing.
10. device according to claim 9, it is characterised in that described preservation module includes:
Statistical module, for adding up the importing number of times of described first data of importing, occurring that the sum of described the first data importing mistake and importing time obtain statistical information；
Preserve submodule, obtain described journal file for preserving described statistical information, each described described errors present importing wrong data of appearance and described error reason.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410857096.3A CN105808375A (en) | 2014-12-31 | 2014-12-31 | Data import method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410857096.3A CN105808375A (en) | 2014-12-31 | 2014-12-31 | Data import method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105808375A true CN105808375A (en) | 2016-07-27 |
Family
ID=56465021
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410857096.3A Pending CN105808375A (en) | 2014-12-31 | 2014-12-31 | Data import method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105808375A (en) |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874484A (en) * | 2017-02-20 | 2017-06-20 | 济南浪潮高新科技投资发展有限公司 | The method and device that a kind of data are imported |
| CN107395784A (en) * | 2017-08-02 | 2017-11-24 | 郑州云海信息技术有限公司 | The method and apparatus that a kind of batch imports Internet protocol IP pond |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN107844400A (en) * | 2017-10-16 | 2018-03-27 | 阿里巴巴集团控股有限公司 | The method of calibration and device of a kind of daily record data |
| CN107885885A (en) * | 2017-12-04 | 2018-04-06 | 山东浪潮通软信息科技有限公司 | A kind of data lead-in method and device |
| CN107895047A (en) * | 2017-12-04 | 2018-04-10 | 山东浪潮通软信息科技有限公司 | A kind of list lead-in and lead-out method and device |
| WO2018076739A1 (en) * | 2016-10-26 | 2018-05-03 | 华为技术有限公司 | Data processing method and data processing device |
| CN108228736A (en) * | 2017-12-12 | 2018-06-29 | 深圳市买买提信息科技有限公司 | Data processing method, data processing system and computer readable storage medium |
| CN108364168A (en) * | 2018-03-08 | 2018-08-03 | 广州创阳软件科技有限公司 | A kind of administrative penalty data extraction system and method based on excel templates |
| CN108897765A (en) * | 2018-05-24 | 2018-11-27 | 上海钢联电子商务股份有限公司 | A kind of batch data introduction method and its system |
| CN109726244A (en) * | 2019-01-29 | 2019-05-07 | 北京中电普华信息技术有限公司 | Data lead-in method and device |
| CN110059078A (en) * | 2019-04-19 | 2019-07-26 | 中国航空无线电电子研究所 | A kind of dynamic configuration and method of calibration of navigational route database customization data |
| CN110334536A (en) * | 2019-05-30 | 2019-10-15 | 深圳壹账通智能科技有限公司 | Data save method, device and computer equipment based on block chain |
| CN110389941A (en) * | 2019-06-19 | 2019-10-29 | 平安国际智慧城市科技股份有限公司 | Database method of calibration, device, equipment and storage medium |
| CN110446073A (en) * | 2019-08-20 | 2019-11-12 | 北京奇艺世纪科技有限公司 | A kind of method of calibration and relevant device of video inventory information |
| CN111209324A (en) * | 2019-12-31 | 2020-05-29 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
| CN111460773A (en) * | 2020-03-30 | 2020-07-28 | 京东数字科技控股有限公司 | Data processing method, device and system, electronic equipment and storage medium |
| CN111782493A (en) * | 2020-06-10 | 2020-10-16 | 上海华力集成电路制造有限公司 | Modeling assistance system and method for modeling data validation of MES |
| CN111858647A (en) * | 2020-08-04 | 2020-10-30 | 浪潮卓数大数据产业发展有限公司 | Method for verifying conversion field type between data sources |
| CN112115208A (en) * | 2020-09-04 | 2020-12-22 | 杭州日思夜享数据科技有限公司 | Database data importing method |
| CN112949267A (en) * | 2021-02-05 | 2021-06-11 | 中国建设银行股份有限公司 | Method and system for generating financial analysis chart |
| CN115357563A (en) * | 2022-10-18 | 2022-11-18 | 北京国铁华晨通信科技有限公司 | Data entry method and system for railway communication equipment and computer equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070150447A1 (en) * | 2005-12-23 | 2007-06-28 | Anish Shah | Techniques for generic data extraction |
| CN101888655A (en) * | 2010-06-28 | 2010-11-17 | 中兴通讯股份有限公司 | Method and device for configuring network element data in template way in network management system |
| CN102437920A (en) * | 2011-09-05 | 2012-05-02 | 中兴通讯股份有限公司 | Method and device for processing configuration data and wireless communication device |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
-
2014
- 2014-12-31 CN CN201410857096.3A patent/CN105808375A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070150447A1 (en) * | 2005-12-23 | 2007-06-28 | Anish Shah | Techniques for generic data extraction |
| CN101888655A (en) * | 2010-06-28 | 2010-11-17 | 中兴通讯股份有限公司 | Method and device for configuring network element data in template way in network management system |
| CN102437920A (en) * | 2011-09-05 | 2012-05-02 | 中兴通讯股份有限公司 | Method and device for processing configuration data and wireless communication device |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
Cited By (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018076739A1 (en) * | 2016-10-26 | 2018-05-03 | 华为技术有限公司 | Data processing method and data processing device |
| CN106874484A (en) * | 2017-02-20 | 2017-06-20 | 济南浪潮高新科技投资发展有限公司 | The method and device that a kind of data are imported |
| CN107395784A (en) * | 2017-08-02 | 2017-11-24 | 郑州云海信息技术有限公司 | The method and apparatus that a kind of batch imports Internet protocol IP pond |
| CN107395784B (en) * | 2017-08-02 | 2021-07-27 | 郑州云海信息技术有限公司 | Method and device for importing internet protocol IP pools in batches |
| CN107844400A (en) * | 2017-10-16 | 2018-03-27 | 阿里巴巴集团控股有限公司 | The method of calibration and device of a kind of daily record data |
| CN107844400B (en) * | 2017-10-16 | 2021-07-27 | 创新先进技术有限公司 | Log data verification method and device |
| CN113688006A (en) * | 2017-10-16 | 2021-11-23 | 创新先进技术有限公司 | Log data verification method and device |
| CN113688006B (en) * | 2017-10-16 | 2024-03-29 | 创新先进技术有限公司 | Log data verification method and device |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN107895047A (en) * | 2017-12-04 | 2018-04-10 | 山东浪潮通软信息科技有限公司 | A kind of list lead-in and lead-out method and device |
| CN107885885A (en) * | 2017-12-04 | 2018-04-06 | 山东浪潮通软信息科技有限公司 | A kind of data lead-in method and device |
| CN108228736A (en) * | 2017-12-12 | 2018-06-29 | 深圳市买买提信息科技有限公司 | Data processing method, data processing system and computer readable storage medium |
| CN108364168A (en) * | 2018-03-08 | 2018-08-03 | 广州创阳软件科技有限公司 | A kind of administrative penalty data extraction system and method based on excel templates |
| CN108897765A (en) * | 2018-05-24 | 2018-11-27 | 上海钢联电子商务股份有限公司 | A kind of batch data introduction method and its system |
| CN109726244A (en) * | 2019-01-29 | 2019-05-07 | 北京中电普华信息技术有限公司 | Data lead-in method and device |
| CN110059078A (en) * | 2019-04-19 | 2019-07-26 | 中国航空无线电电子研究所 | A kind of dynamic configuration and method of calibration of navigational route database customization data |
| CN110059078B (en) * | 2019-04-19 | 2022-11-15 | 中国航空无线电电子研究所 | Dynamic configuration and verification method for customized data of navigation database |
| CN110334536A (en) * | 2019-05-30 | 2019-10-15 | 深圳壹账通智能科技有限公司 | Data save method, device and computer equipment based on block chain |
| CN110389941A (en) * | 2019-06-19 | 2019-10-29 | 平安国际智慧城市科技股份有限公司 | Database method of calibration, device, equipment and storage medium |
| CN110389941B (en) * | 2019-06-19 | 2021-01-05 | 平安国际智慧城市科技股份有限公司 | Database checking method, device, equipment and storage medium |
| CN110446073A (en) * | 2019-08-20 | 2019-11-12 | 北京奇艺世纪科技有限公司 | A kind of method of calibration and relevant device of video inventory information |
| CN111209324B (en) * | 2019-12-31 | 2023-11-28 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
| CN111209324A (en) * | 2019-12-31 | 2020-05-29 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
| CN111460773A (en) * | 2020-03-30 | 2020-07-28 | 京东数字科技控股有限公司 | Data processing method, device and system, electronic equipment and storage medium |
| CN111782493A (en) * | 2020-06-10 | 2020-10-16 | 上海华力集成电路制造有限公司 | Modeling assistance system and method for modeling data validation of MES |
| CN111858647A (en) * | 2020-08-04 | 2020-10-30 | 浪潮卓数大数据产业发展有限公司 | Method for verifying conversion field type between data sources |
| CN112115208A (en) * | 2020-09-04 | 2020-12-22 | 杭州日思夜享数据科技有限公司 | Database data importing method |
| CN112949267A (en) * | 2021-02-05 | 2021-06-11 | 中国建设银行股份有限公司 | Method and system for generating financial analysis chart |
| CN115357563A (en) * | 2022-10-18 | 2022-11-18 | 北京国铁华晨通信科技有限公司 | Data entry method and system for railway communication equipment and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105808375A (en) | Data import method and device | |
| US20210049711A1 (en) | Method of automatically transmitting data information and device of automatically transmitting data information | |
| CN105117431A (en) | Dynamic configuration method and system for external imported data | |
| CN106155686A (en) | Interface creating method, device and system | |
| CN108345512A (en) | Data verification method, server and storage medium | |
| CN106934615A (en) | Payment and method for processing business and device based on mobile terminal barcode | |
| CN104361139A (en) | Data importing device and method | |
| CN104657274B (en) | software interface test method and device | |
| CN109635300B (en) | Data verification method and device | |
| CN101572696A (en) | Method and device for validating data on webpage form | |
| CN112217656B (en) | Method and device for synchronizing configuration information of network equipment in SD-WAN (secure digital-to-Wide area network) system | |
| CN107193593A (en) | A kind of upgrade method, set top box and the storage medium of scalable file | |
| CN110473080A (en) | A kind of report processing method, device and computer equipment | |
| CN112380219B (en) | Method for defining block chain cochain data service stipulation and application service stipulation | |
| CN110309099A (en) | Interface managerial method, device, equipment and computer readable storage medium | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN114896634A (en) | Data authority control method and system of enterprise report platform | |
| CN115391439A (en) | Document data export method, device, electronic equipment and storage medium | |
| CN108924185A (en) | Interface creation method and device | |
| CN102238593B (en) | Data cut-over method and device | |
| CN114386853A (en) | Data auditing processing method, device and equipment based on universal auditing model | |
| CN102317942B (en) | Methods and devices for generating theme's properties | |
| CN109005167B (en) | Authentication data processing method and device, server and storage medium | |
| CN109783782A (en) | Generation method, equipment, storage medium and the device of electronic contract template | |
| CN112711414A (en) | Form interface adaptation display method and device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160727 |
|
| RJ01 | Rejection of invention patent application after publication |