CN105653525A - Data importing method and system between data set - Google Patents
Data importing method and system between data set Download PDFInfo
- Publication number
- CN105653525A CN105653525A CN201410629180.XA CN201410629180A CN105653525A CN 105653525 A CN105653525 A CN 105653525A CN 201410629180 A CN201410629180 A CN 201410629180A CN 105653525 A CN105653525 A CN 105653525A
- Authority
- CN
- China
- Prior art keywords
- data
- importing
- source
- target
- verification rule
- 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.)
- Granted
Links
Landscapes
- Computer And Data Communications (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a data importing method between data sets; the method comprises the following steps: obtaining a preset data type selected by a user and to-be imported to a target data set; obtaining a source data sheet corresponding to the data type from a source data set, and obtaining a target data sheet corresponding to the data type from the target data set; determining whether the data in the source data sheet complies with verification rules or not according to a preset sequence, if yes, importing the data of the source data sheet into the target data sheet, and if not, the data import fails. The method and system can use the preset sequence and verification rules to help personnel to complete correct importing of each data type, the import personnel need not to record the import sequence, thus improving importing efficiency; in addition, intermediate template file output is not needed in the importing progress, so the data importing can be directly and conveniently finished between two data sets; in addition, the invention also provides a data importing system between data sets.
Description
Technical field
The present invention relates to microcomputer data processing field, particularly relate to method and the system of data importing between a kind of account cover.
Background technology
Account cover refers to an independence, complete data acquisition, and this data acquisition comprises a whole set of independent, complete system control parameters, user's authority, basic archives, accounting information, document, account table inquiry etc., is exactly an independent database. In prior art, data import another account cover from an account cover, are realized by middle file Excel. As first logged in source account cover, require to derive client's archive information according to template, and preserve as Excel file is stored in this locality, and then log in target account cover, enter client's archives, select above-mentioned Excel file to import as importing file, it is achieved the importing of data between 2 accounts covers. Between existing account cover during data importing, at least there is the following problem causing the importing efficiency of data between account cover low, inconvenient:
1) a large amount of middle file can be produced, store inconvenience.
2) once source account sets of data changes, can only again deriving and generate new Excel file, efficiency is not high.
3) having strict demand to importing and exporting template, once database adds field, template style will not be inconsistent, it is necessary to readjusts template.
4) when there are multiple importing data, each relation importing often existence successively dependence between data, it is necessary to importing personnel record importing order voluntarily, if note mistake, then import failure, seriously affect working efficiency.
Summary of the invention
Based on this, it is necessary to for the problems referred to above, it is provided that the method for data importing between a kind of efficient cover of account easily and system.
A method for data importing between account cover, described method comprises:
Obtain the preset data classification needing importing target account cover that user selects;
In source account is overlapped, obtain the source data table corresponding with data classification, in target account is overlapped, obtain the target data sheet corresponding with data classification;
Judge whether the data in source data table meet verification rule by preset order, if meeting verification rule, then by the data importing target data sheet in source data table;
If the data in source data table do not meet verification rule, then import failure.
Wherein in an embodiment, before obtaining the step of the preset data classification needing importing target account cover that user selects, also comprise:
Obtain the title of the source account cover of user's input or IP address, the title of target account cover or IP address;
Obtain the login information of source account cover and the login information of target account cover of user's input;
The login information registration source account cover of the title overlapped according to source account or IP address and source account cover;
The login information registration target account cover of the title overlapped according to target account or IP address and target account cover.
Wherein in an embodiment, judge whether the data in source data table meet the step of verification rule by preset order, comprising:
Judge that the data in source data table are the need of importing target data sheet by preset order, if desired importing, then judge whether the associated data of described data exists in target data sheet, if existing, being judged as meeting verification rule, if not existing, then it is judged as not meeting verification rule;
If the data in source data table do not need to import target data sheet, then do not deal with.
Wherein in an embodiment, judge whether the data in source data table meet verification rule by preset order, if meeting verification rule, then by the data importing target data sheet in source data table; If the data in source data table do not meet verification rule, then import failed step and comprise:
By the data copy in source data table to the first temporary table;
Judge whether the data in the first temporary table meet verification rule by preset order;
If meeting verification rule, then by the data importing target data sheet in the first temporary table;
If the data in source data table do not meet verification rule, then obtain and the first temporary table imports failed data, and by importing failed data copy to the 2nd temporary table, delete the first temporary table.
Wherein in an embodiment, described method also comprises:
Exporting information, described information comprises the number, the failed number of data of importing and the reason of data importing failure that import successful data in the first temporary table;
Reason according to data importing failure adjusts the data in source data table or target data sheet, again imports the data in source data table.
Wherein in an embodiment, according to the data in the reason of data importing failure adjustment source data table or target data sheet, the step again importing the data in source data table comprises:
By the data copy in source data table in the first temporary table;
If the data in the first temporary table exist in the 2nd temporary table, then by described data importing target data sheet;
If the data in the first temporary table do not exist in the 2nd temporary table, then do not deal with.
A system for data importing between account cover, described system comprises:
Data classification acquisition module, for obtaining the preset data classification needing importing target account cover that user selects;
Data sheet acquisition module, obtains the source data table corresponding with data classification in overlapping in source account, obtains the target data sheet corresponding with data classification in target account is overlapped;
By preset order, data importing module, for judging whether the data in source data table meet verification rule, if meeting verification rule, then by the data importing target data sheet in described source data table; If the data in described source data table do not meet verification rule, then import failure.
Wherein in an embodiment, described system also comprises login module, for obtaining the title of the source account cover of user's input or IP address, the title of target account cover or IP address;Obtain the login information of source account cover and the login information of target account cover of user's input; The login information registration source account cover of the title overlapped according to source account or IP address and source account cover; The login information registration target account cover of the title overlapped according to target account or IP address and target account cover.
Wherein in an embodiment, by preset order, data importing module is also for judging that the data in source data table are the need of importing target data sheet, if desired import, then judge whether the associated data of described data exists in target data sheet, if existing, it is judged as meeting verification rule, if not existing, then it is judged as not meeting verification rule; If the data in source data table do not need to import target data sheet, then do not deal with.
Wherein in an embodiment, data importing module comprises:
Copy cell, for by the data copy in source data table to the first temporary table;
By preset order, verification unit, for judging whether the data in the first temporary table meet verification rule;
Temporary table imports unit, if for the data fit verification rule in the first temporary table, then by the data importing target data sheet in the first temporary table;
Processing unit, if not meeting verification rule for the data in the first temporary table, then obtains and imports failed data in the first temporary table, and by importing failed data copy to the 2nd temporary table, deletes the first temporary table.
Wherein in an embodiment, described system also comprises:
Information alert module, for exporting information, described information comprises the number, the failed number of data of importing and the reason of data importing failure that import successful data in the first temporary table;
Again import module, for the data in the reason adjustment source data table according to data importing failure or target data sheet, again import the data in source data table;
Wherein in an embodiment, again import module also for by the data copy in source data table in the first temporary table; If the data in the first temporary table exist in the 2nd temporary table, then by described data importing target data sheet; If the data in the first temporary table do not exist in the 2nd temporary table, then do not deal with.
The method of data importing between above-mentioned account cover and system, the preset data classification importing target account cover that needs selected by obtaining user obtains the source data table corresponding with data classification, target data sheet respectively in source account is overlapped and target account is overlapped; The data importing target data sheet being undertaken verifying by preset order and will meet in the regular source data table of verification. Importing personnel are helped to complete the correct importing of each data classification by preset order and verification rule, it is not necessary to importing personnel record importing order voluntarily, it is to increase importing efficiency. Meanwhile, importing process does not need middle masterplate file output yet, between two accounts are overlapped, directly completes the importing of data, convenient and swift.
Accompanying drawing explanation
Fig. 1 is the schema of the method for data importing between account cover in an embodiment;
Fig. 2 is the Operation interface diagram of data importing between account cover in an embodiment;
By preset order, Fig. 3 judges whether the data in source data table meet the schema of verification rule in an embodiment;
Fig. 4 is the schema of the method for data importing between account cover in another embodiment;
Fig. 5 is the data in reason adjustment source data table according to data importing failure or target data sheet in an embodiment, again imports the schema of the data in source data table;
Fig. 6 is the structure block diagram of the system of data importing between account cover in an embodiment;
Fig. 7 is the structure block diagram of data importing module in an embodiment;
Fig. 8 is the structure block diagram of the system of data importing between account cover in another embodiment.
Embodiment
In order to make the object of the present invention, technical scheme and advantage clearly understand, below in conjunction with drawings and Examples, the present invention is further elaborated. It is to be understood that specific embodiment described herein is only in order to explain the present invention, it is not intended to limit the present invention.
In an embodiment, as shown in Figure 1, it provides a kind of account overlap between the method for data importing, the method be can be applicable in the system realized by computer program, and the method comprises:
Step S110, obtains the preset data classification needing importing target account cover that user selects.
In the present embodiment, preset data classification can comprise measure unit, currency, material, client, supplier, department, employee etc. Each data classification is in source account cover and a target account cover corresponding data sheet respectively, and what deposit inside data sheet is the data relevant to data classification. User can need the preset data classification importing target account cover by unrestricted choice as required, it is possible to selects one or more. An interface for users can be provided to select preset data classification, received the preset data classification needing importing target account cover of user's selection by this interface.
Step S120, obtains the source data table corresponding with data classification in source account is overlapped, and obtains the target data sheet corresponding with data classification in target account is overlapped.
In the present embodiment, such as user have selected this data classification of material, then in source account is overlapped, there is a source data table corresponding with material, as shown in table 1, this source data table comprises MaterialNo, Name, Number3 field, and field value 001 corresponding with this 3 field respectively, computer, 50. Also having a target data sheet corresponding with material in target account is overlapped, as shown in table 2, this target data sheet comprises MaterialNo, Name, Number3 field, and field value 002 corresponding with this 3 field respectively, pen, 65. It should be appreciated that source data table and target data sheet may containing identical fields, it is possible to the meaning of self-defined each field references, such as MaterialNo represents the coding of material, Name represents material title, Number represent the number of material.
Table 1
| MaterialNo | 001 |
| Name | computer |
| Number | 50 |
Table 2
| MaterialNo | 002 |
| Name | pen |
| Number | 65 |
By preset order, step S130, judging whether the data in source data table meet verification rule, if meeting verification rule, then entering step S140, if not meeting verification rule, then importing failure.
In the present embodiment, if user have selected multiple data classification, successively dependence may be there is between data in the data sheet that then this multiple data classification is corresponding, such as user have selected measure unit and material two data classifications, the data sheet that material is corresponding there is a field be the number of material, this field depends on " platform " this field in data sheet corresponding to this classification of measure unit, so need first to import the data in the data sheet corresponding to measure unit when importing. The present invention does not need importing person to record these importing orders voluntarily, but according to default correct order, the data of source data table are processed according to the selection of user by system, such as first judge that in the source data table that measure unit is corresponding, whether data meet verification rule, will first import if met.
Further, verification rule can also be self-defined, such as defines source data table simultaneously identical with field value with certain field name in target data sheet, then for not needing the data imported. Or it is simultaneously identical with field value to define multiple field name, then for not needing the data imported.
Step S140, by the data importing target data sheet in source data table.
In the present embodiment, can be self-defined by the mode of the data importing target data sheet in source data table, such as according to the data in certain rules selection source data table be in a covered manner import target data sheet, still in the way to insert import target data sheet. Data in such as source data table are table 1, and the data in target data sheet are table 2. Definition MaterialNo is crucial field, if crucial field is different, then imports in the way to insert. Then by, after the data importing target data sheet 2 in source data table 1, target data sheet is as shown in table 3.
Table 3
| MaterialNo | 001 |
| Name | computer |
| Number | 50 |
| MaterialNo | 002 |
| Name | pen |
| Number | 65 |
If the data in source data table are table 4, the data in target data sheet are table 5. Definition MaterialNo is crucial field, if crucial field is identical, then imports in a covered manner. Then by, after the data importing target data sheet 5 in source data table 4, target data sheet is as shown in table 6.
Table 4
| MaterialNo | 001 |
| Name | computer |
| Number | 50 |
Table 5
| MaterialNo | 001 |
| Name | computer |
| Number | 65 |
Table 6
| MaterialNo | 001 |
| Name | computer |
| Number | 50 |
In the present embodiment, the preset data classification importing target account cover that needs selected by user obtains the source data table corresponding with data classification, target data sheet respectively in source account cover and target account overlap; By preset order according to verification rule by the data importing target data sheet in source data table. Importing personnel are helped to complete the correct importing of each data classification by preset order and verification rule, it is not necessary to importing personnel record importing order voluntarily, it is to increase importing efficiency. Meanwhile, importing process does not need middle masterplate file output yet, it is not necessary to safeguard that importing template changes, and directly completes the importing of data between two accounts are overlapped, convenient and swift.
In an embodiment, before step S110, also comprise: obtain the title of the source account cover of user's input or IP address, the title of target account cover or IP address; Obtain the login information of source account cover and the login information of target account cover of user's input; The login information registration source account cover of the title overlapped according to source account or IP address and source account cover; The login information registration target account cover of the title overlapped according to target account or IP address and target account cover.
In the present embodiment, user completes the input of source account cover and target account cover title or IP address by interface as shown in Figure 2, and the input of the user name of the user name of source account cover and password and target account cover and password. After receiving above-mentioned information by this interface, the user name of the user name of the title overlapped according to source account or IP address and source account cover and password login source account cover, the title overlapped according to target account or IP address and target account cover and password login target account cover. It should be appreciated that source account cover and target account cover can on same database server, but must be two database instances. IP address can identical also can be different. User name and password do not have concrete requirement yet, as long as having permission just passable. Also having for the preset data classification that user selects on interface shown in Fig. 2, each data classification is in source account cover and a target account cover corresponding data sheet respectively. Also having shortcut can entirely select with complete clear fast on interface, user just can put after having inputted each information and import the data importing that button carries out account inner room.The importing between material table Material and the material table Material of database D B2014 of such as database D B2013.
In the present embodiment, will log in, and select data classification and import button design at an operation interface, all importing work can be completed at an operation interface, it is to increase the working efficiency of user.
In an embodiment, as shown in Figure 3, step S130 comprises:
By preset order, step S131, judging that the data in source data table are the need of importing target data sheet, if desired import, then enter step S132, if not needing to import, then not dealing with.
In the present embodiment, owing to may there is the relation successively relied on when importing between each data in source data table, the precondition of the importing of such as data B is that data A needs first to import, and preset order here is determined according to above-mentioned dependence. Can also be self-defined the need of the judgment rule importing target data sheet, such as define MaterialNo uniquely to determine, if then the MaterialNo of the material A in source data table is 001, the MaterialNo of the material B in target data sheet is also 001, then system thinks identical, do not need to import, then do not deal with.
Step S132, judges whether the associated data of described data exists in target data sheet, if existing, being judged as meeting verification rule, if not existing, being then judged as not meeting verification rule.
In the present embodiment, the associated data of data needs the dependence data importing target data sheet before referring to data importing. It should be appreciated that the data A needing the data B imported to rely in source data table may exist in source data table, we only need first importing data A just can ensure that data B imports target data sheet in this case. If but the data A that data B relies on is not in source data table, at this moment just need to judge that whether the data A that data B relies on is own through existing in target data sheet. If existing, being judged as meeting verification rule, if not existing, being then judged as not meeting verification rule.
In another embodiment, as shown in Figure 4, it provides the method for data importing between a kind of account cover, described method comprises:
Step S210, obtains the preset data classification needing importing target account cover that user selects.
Step S220, obtains the source data table corresponding with data classification in source account is overlapped, and obtains the target data sheet corresponding with data classification in target account is overlapped.
Step S230, by the data copy in source data table to the first temporary table.
Concrete, newly-built first temporary table in a database, by the data copy in source data table to the first temporary table. When there being multiple data classification, the source data table corresponding with data classification may have multiple, for the ease of searching, here, the data in the number table of multiple sources is all copied to the first temporary table, it is possible to improves the efficiency imported.
By preset order, step S240, judging whether the data in the first temporary table meet verification rule, if meeting verification rule, then entering step S250; If the data in source data table do not meet verification rule, then enter step S260.
In the present embodiment, directly from the first temporary table, judging whether each data meet verification rule by the order of the front and back dependence importing data, if meeting verification rule, then entering step S250, if not meeting verification rule, then entering step S260. Meet the data of verification rule, it is need importing target data sheet and meet the data of importing condition.
Step S250, by the data importing target data sheet in the first temporary table;
Concrete, the data meeting verification rule in the first temporary table are imported target data sheet by self-defined lead-in mode.
Step S260, obtains and imports failed data in the first temporary table, and by importing failed data copy to the 2nd temporary table, deletes the first temporary table.
Concrete, obtain and the first temporary table imports failed data, and failed data copy will be imported to the 2nd temporary table, it is convenient to when importing next time, failed data are imported before only importing these, need not by import before successful data again data with target data sheet compare, it is to increase the speed that imports.
Step S270, exports information.
Concrete, it is possible to export the number, the failed number of data of importing and the reason of data importing failure that import successful data in this first temporary table.
Step S280, according to the data in the reason of data importing failure adjustment source data table or target data sheet, imports the data in source data table again.
In the present embodiment, such as when importing the quantity of material, because its dependence data metering unit does not exist so import and have failed in target data sheet, if now the measure unit in source data table through there is measure unit, is then directly first imported target data sheet by oneself in source data table; If source data table does not exist measure unit, then need first to increase typing measure unit newly, then the measure unit in source data table is imported target data sheet; Or directly can also increase typing measure unit in target data sheet newly. And then again import the quantity of material, at this moment just can successfully import.
In an embodiment, as shown in Figure 5, step S280 comprises:
Step S281, by the data copy in source data table in the first temporary table;
Step S282, judges whether the data in the first temporary table exist in the 2nd temporary table, if existing, then by described data importing target data sheet; If the data in the first temporary table do not exist in the 2nd temporary table, then do not deal with.
In the present embodiment, such as material data is copied in the first temporary table, now the data in the first temporary table and the 2nd temporary table being contrasted, the data only existed in the 2nd temporary table can need the data importing target data sheet imported as this. Such as material data upper once import time major part data all successfully import, only the number of material does not import successfully, then the number of material is now recorded in the 2nd temporary table, when this imports, the data in the 2nd temporary table are not all the data that last time, oneself imported through success, stamp mark ignore to fall as repeating to import data, decrease the data repeating to import, improve the performance of importing.
As shown in Figure 6, in an embodiment, it provides the system of data importing between a kind of account cover, comprising:
Data classification acquisition module 310, for obtaining the preset data classification needing importing target account cover that user selects.
Data sheet acquisition module 320, obtains the source data table corresponding with data classification in overlapping in source account, obtains the target data sheet corresponding with data classification in target account is overlapped.
By preset order, data importing module 330, for judging whether the data in source data table meet verification rule, if meeting verification rule, then by the data importing target data sheet in described source data table; If the data in described source data table do not meet verification rule, then import failure.
In an embodiment, said system also comprises login module, for obtaining the title of the source account cover of user's input or IP address, the title of target account cover or IP address;Obtain the login information of source account cover and the login information of target account cover of user's input; The login information registration source account cover of the title overlapped according to source account or IP address and source account cover; The login information registration target account cover of the title overlapped according to target account or IP address and target account cover.
In an embodiment, by preset order, data importing module 330 is also for judging that the data in source data table are the need of importing target data sheet, if desired import, then judge whether the associated data of described data exists in target data sheet, if existing, it is judged as meeting verification rule, if not existing, then it is judged as not meeting verification rule; If the data in source data table do not need to import target data sheet, then do not deal with.
In an embodiment, as shown in Figure 7, data importing module 330 comprises:
Copy cell 331, for by the data copy in source data table to the first temporary table;
By preset order, verification unit 332, for judging whether the data in the first temporary table meet verification rule;
Temporary table imports unit 333, if for the data fit verification rule in the first temporary table, then by the data importing target data sheet in the first temporary table;
Processing unit 334, if not meeting verification rule for the data in the first temporary table, then obtains and imports failed data in the first temporary table, and by importing failed data copy to the 2nd temporary table, deletes the first temporary table.
In another embodiment, as shown in Figure 8, on the basis of said system, also comprise:
Information alert module 340, for exporting information, described information comprises the number, the failed number of data of importing and the reason of data importing failure that import successful data in the first temporary table.
Again import module 350, for the data in the reason adjustment source data table according to data importing failure or target data sheet, again import the data in source data table.
In an embodiment, again import module 350 also for by the data copy in source data table in the first temporary table; If the data in the first temporary table exist in the 2nd temporary table, then by described data importing target data sheet; If the data in the first temporary table do not exist in the 2nd temporary table, then do not deal with.
The above embodiment only have expressed several enforcement modes of the present invention, and it describes comparatively concrete and detailed, but therefore can not be interpreted as the restriction to patent scope of the present invention. , it is also possible to make some distortion and improvement, it should be appreciated that for the person of ordinary skill of the art, without departing from the inventive concept of the premise these all belong to protection scope of the present invention. Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (12)
1. a method for data importing between account cover, described method comprises:
Obtain the preset data classification needing importing target account cover that user selects;
In source account is overlapped, obtain the source data table corresponding with described data classification, in target account is overlapped, obtain the target data sheet corresponding with described data classification;
Judge whether the data in source data table meet verification rule by preset order, if meeting verification rule, then by the data importing target data sheet in described source data table;
If the data in described source data table do not meet verification rule, then import failure.
2. method according to claim 1, it is characterised in that, before the step of the preset data classification needing importing target account cover of described acquisition user's selection, also comprise:
Obtain the title of the source account cover of user's input or IP address, the title of target account cover or IP address;
Obtain the login information of source account cover and the login information of target account cover of user's input;
The login information registration source account cover of the title overlapped according to described source account or IP address and source account cover;
The login information registration target account cover of the title overlapped according to described target account or IP address and target account cover.
3. method according to claim 1, it is characterised in that, judge whether the data in source data table meet the step of verification rule by preset order, comprising:
Judge that the data in source data table are the need of importing target data sheet by preset order, if desired importing, then judge whether the associated data of described data exists in target data sheet, if existing, being judged as meeting verification rule, if not existing, then it is judged as not meeting verification rule;
If the data in source data table do not need to import target data sheet, then do not deal with.
4. method according to claim 1, it is characterised in that, described by preset order judge the data in source data table whether meet verification rule, if meet verification rule, then by the data importing target data sheet in described source data table; If the data in described source data table do not meet verification rule, then import failed step and comprise:
By the data copy in described source data table to the first temporary table;
Judge whether the data in the first temporary table meet verification rule by preset order;
If meeting verification rule, then by the data importing target data sheet in described first temporary table;
If the data in source data table do not meet verification rule, then obtain in described first temporary table and import failed data, and import failed data copy to the 2nd temporary table by described, delete described first temporary table.
5. method according to claim 4, it is characterised in that, described method also comprises:
Exporting information, described information comprises the number, the failed number of data of importing and the reason of data importing failure that import successful data in described first temporary table;
Reason according to described data importing failure adjusts the data in described source data table or target data sheet, again imports the data in described source data table.
6. method according to claim 5, it is characterised in that, the described reason according to described data importing failure adjusts the data in described source data table or target data sheet, and the step again importing the data in described source data table comprises:
By the data copy in described source data table in the first temporary table;
If the data in the first temporary table exist in the 2nd temporary table, then by target data sheet described in described data importing;
If the data in the first temporary table do not exist in the 2nd temporary table, then do not deal with.
7. the system of data importing between an account cover, it is characterised in that, described system comprises:
Data classification acquisition module, for obtaining the preset data classification needing importing target account cover that user selects;
Data sheet acquisition module, obtains the source data table corresponding with described data classification in overlapping in source account, obtains the target data sheet corresponding with described data classification in target account is overlapped;
By preset order, data importing module, for judging whether the data in source data table meet verification rule, if meeting verification rule, then by the data importing target data sheet in described source data table; If the data in described source data table do not meet verification rule, then import failure.
8. system according to claim 7, it is characterised in that, described system also comprises:
Login module, the login information of the login information that the title or IP address, the title of target account cover or the source account of IP address acquisition user's input for obtaining the source account cover that user inputs is overlapped and target account cover;The login information registration source account cover of the title overlapped according to described source account or IP address and source account cover; The login information registration target account cover of the title overlapped according to described target account or IP address and target account cover.
9. system according to claim 7, it is characterized in that, by preset order, described data importing module is also for judging that the data in source data table are the need of importing target data sheet, if desired import, then judge whether the associated data of described data exists in target data sheet, if existing, being judged as meeting verification rule, if not existing, being then judged as not meeting verification rule; If the data in source data table do not need to import target data sheet, then do not deal with.
10. system according to claim 7, it is characterised in that, described data importing module comprises:
Copy cell, for by the data copy in described source data table to the first temporary table;
By preset order, verification unit, for judging whether the data in the first temporary table meet verification rule;
Temporary table imports unit, if for the data fit verification rule in the first temporary table, then by the data importing target data sheet in described first temporary table;
Processing unit, if not meeting verification rule for the data in the first temporary table, then obtains in described first temporary table and imports failed data, and imports failed data copy to the 2nd temporary table by described, deletes described first temporary table.
11. systems according to claim 10, it is characterised in that, described system also comprises:
Information alert module, for exporting information, described information comprises the number, the failed number of data of importing and the reason of data importing failure that import successful data in described first temporary table;
Again import module, for the data adjusted according to the reason of described data importing failure in described source data table or target data sheet, again import the data in described source data table.
12. systems according to claim 11, it is characterised in that, described again import module also for by the data copy in described source data table in the first temporary table; If the data in the first temporary table exist in the 2nd temporary table, then by target data sheet described in described data importing; If the data in the first temporary table do not exist in the 2nd temporary table, then do not deal with.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410629180.XA CN105653525B (en) | 2014-11-10 | 2014-11-10 | Method and system for importing data between account sets |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410629180.XA CN105653525B (en) | 2014-11-10 | 2014-11-10 | Method and system for importing data between account sets |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105653525A true CN105653525A (en) | 2016-06-08 |
| CN105653525B CN105653525B (en) | 2020-04-10 |
Family
ID=56483374
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410629180.XA Active CN105653525B (en) | 2014-11-10 | 2014-11-10 | Method and system for importing data between account sets |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105653525B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109271611A (en) * | 2018-09-06 | 2019-01-25 | 阿里巴巴集团控股有限公司 | A kind of data verification method, device and electronic equipment |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060045789A (en) * | 2004-04-16 | 2006-05-17 | 캐논 가부시끼가이샤 | Document processing apparatus, control method therefor, and computer-readable storage medium |
| CN103279542A (en) * | 2013-06-05 | 2013-09-04 | 中国电子科技集团公司第十五研究所 | Data importing processing method and data processing device |
| CN103309977A (en) * | 2013-06-14 | 2013-09-18 | 广东电网公司电力科学研究院 | Heterogeneous data resource integration method |
| US20140040188A1 (en) * | 2012-08-02 | 2014-02-06 | Samsung Electronics Co., Ltd. | Method and apparatus for updating personal information in communication system |
| CN103793424A (en) * | 2012-10-31 | 2014-05-14 | 阿里巴巴集团控股有限公司 | Database data migration method and database data migration system |
| CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
-
2014
- 2014-11-10 CN CN201410629180.XA patent/CN105653525B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060045789A (en) * | 2004-04-16 | 2006-05-17 | 캐논 가부시끼가이샤 | Document processing apparatus, control method therefor, and computer-readable storage medium |
| US20140040188A1 (en) * | 2012-08-02 | 2014-02-06 | Samsung Electronics Co., Ltd. | Method and apparatus for updating personal information in communication system |
| CN103793424A (en) * | 2012-10-31 | 2014-05-14 | 阿里巴巴集团控股有限公司 | Database data migration method and database data migration system |
| CN103279542A (en) * | 2013-06-05 | 2013-09-04 | 中国电子科技集团公司第十五研究所 | Data importing processing method and data processing device |
| CN103309977A (en) * | 2013-06-14 | 2013-09-18 | 广东电网公司电力科学研究院 | Heterogeneous data resource integration method |
| CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109271611A (en) * | 2018-09-06 | 2019-01-25 | 阿里巴巴集团控股有限公司 | A kind of data verification method, device and electronic equipment |
| CN109271611B (en) * | 2018-09-06 | 2023-05-12 | 创新先进技术有限公司 | Data verification method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105653525B (en) | 2020-04-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109815991B (en) | Training method and device of machine learning model, electronic equipment and storage medium | |
| US10257187B2 (en) | Prompting login account | |
| CN105868679B (en) | The dynamic updating method and fingerprint identification device of finger print information | |
| US8228542B2 (en) | Systems and methods for storing multiple records using identifiers, storage locations, and attributes associated with electronic documents | |
| US11669549B2 (en) | Identity mapping for cloud migrations | |
| CN107733869B (en) | Equipment identification method and device | |
| CN105337925B (en) | A kind of user account management method and device | |
| CN110162516B (en) | Data management method and system based on mass data processing | |
| CN109145003B (en) | Method and device for constructing knowledge graph | |
| CN106611064B (en) | Data processing method and device for distributed relational database | |
| CN106815725B (en) | Transaction verification method and device | |
| CN108629196A (en) | Method, apparatus, electronic equipment and the readable storage medium storing program for executing of data storage and query | |
| CN110245145A (en) | Structure synchronization method and apparatus of the relevant database to Hadoop database | |
| CN110598107A (en) | Management method of query system and computer storage medium | |
| CN105205451A (en) | Fingerprint verification method, fingerprint verification device and terminal | |
| CN102521713B (en) | Data processing equipment and data processing method | |
| CN105205365A (en) | Registration and authentication method and device for biological feature information | |
| CN109067767B (en) | Face recognition authentication method and system | |
| US11449628B2 (en) | System and method for data security grading | |
| CN105653525A (en) | Data importing method and system between data set | |
| US20100082579A1 (en) | Identification Of Data Objects Within A Computer Database | |
| CN109460318A (en) | It is a kind of can rollback archives acquisition data introduction method, computer installation and computer readable storage medium | |
| CN110704501B (en) | User account correlation method and device | |
| CN111459936B (en) | Data management method, data management device and server | |
| CN113886242A (en) | Data processing method, device, terminal 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |