CN108197207A - Batch data matches introduction method - Google Patents
Batch data matches introduction method Download PDFInfo
- Publication number
- CN108197207A CN108197207A CN201711459982.0A CN201711459982A CN108197207A CN 108197207 A CN108197207 A CN 108197207A CN 201711459982 A CN201711459982 A CN 201711459982A CN 108197207 A CN108197207 A CN 108197207A
- Authority
- CN
- China
- Prior art keywords
- data
- matching
- list data
- title
- system field
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of batch data matching introduction method, list data is imported into information system, including step：S1, matching scheme table, the title of list data, the system field of system information, interim table and traffic table are defined；S2, according to matching scheme table, check whether title and system field match and check matching result；S3, according to matching result, user is confirmed to obtain according to first five row data of list data to matching result corresponding confirms result；S4, according to confirming as a result, all importing list data in interim tables and verifying list data and obtain corresponding check results；S5, according to check results, list data is imported into traffic table, the present invention has the advantages that different field formatted data is supported to import, import data field and system field can need not repeatedly change importing data in completely the same and importing process.
Description
Technical field
The invention belongs to technical field of data processing, and in particular to a kind of batch data matches introduction method.
Background technology
Excel is one of common office software, is usually used in the processing and statistical analysis of various data, a large amount of in Excel
Formula function can apply selection, calculatings can be performed using Microsoft Excel, analysis information simultaneously manages electrical form
Or the data information list in webpage and data information chart production, it can realize many convenient functions, bring user side
Just, in enterprise management system, it is the heavy thing of workload that often batch data, which imported into database, at present partial data
Introduction method only supports batch to import the list data of fixed field form, and title must be with field present in system complete one
Cause, an error in data need to remodify and again import system the problems such as.
A kind of list data introduction method of patent and system (publication number CN107145537A), disclose a kind of list data
Introduction method and system, repeated authentication and ORM objects asking of sharing and reuse during solving the problems, such as that list data batch imports
Topic.This method includes：S1, the list data of importing is grouped according to preset rules；Every group of data after the grouping have jointly
Point or similitude；S2, whether the list data is judged by verification, if it is not, terminating to perform；If so, by every group of list data
A corresponding newly-built ORM object.List data is imported using multithreading, improves importing efficiency；The present invention will have altogether
It is grouped with the data put, then using the mode of batch validation, improves verification efficiency, saved computer resource；This
Invention shares an ORM object using a grouping, improves memory service efficiency, reduces memory consumption, but of the invention
Data lead-in mode is too simple, can not use and be imported with the data of different system field format, and one time error in data needs again
It changes and import system, process is cumbersome again.
Therefore need one kind that can support that the importing of different field formatted data, importing data field and system field need not be complete
The batch data matching introduction method for importing data can be repeatedly changed in complete consistent and importing process.
Invention content
The object of the present invention is to provide a kind of batch datas to match introduction method, solves existing batch data introduction method
Free typesetting form document can not be supported to import, document field and the inconsistent matching problem of system field is solved, solve
The problem of repeatedly modification repeats to import.
The present invention provides following technical solutions：
A kind of batch data matches introduction method, list data is imported into information system, including step：
S1, matching scheme table, the title of list data, the system field of system information, interim table and traffic table are defined；
S2, according to matching scheme table, check whether title and system field match and check matching result；
S3, according to matching result, user confirms matching result to obtain phase according to first five row data of list data
It should confirm result；
S4, according to confirming as a result, all importing list data in interim tables and verifying list data and accordingly verified
As a result；
S5, according to check results, list data is imported into traffic table.
Preferably, in the S1,
The Data Matching of different user is imported into history table and is defined as matching scheme table；
It is title by the first row each column data definition of list data；
It is traffic table by the form definition that data are stored in information system；
It is system field by the gauge outfit data definition of traffic table each column；
It is interim table by the form definition comprising system field created in Data Matching importing process temporarily.
Preferably, in the S2, whether matching way is consistent with system field character to check title；
If so, user changes the system field of title match or no longer changes matching result manually；
It selects corresponding system field or ignores to match inconsistent title if it is not, user is the inconsistent title of matching
Under list data.
Check matching result mode be, if the corresponding system field of each column title match；
If so, into S3；If it is not, then reset S2 steps.
Preferably, in the S3, confirmation process is, user is according in first five row data and S2 of preview list data
With as a result, it is secondary it is manual change title match system field or no longer change matching result, if it is secondary it is manual change
It then needs to check again for matching result with result.
Preferably, according to the title of secondary manual change matching result and system field and the data pair in matching scheme table
Than inconsistent data will preserve as new scheme and update matching scheme table.
Preferably, in the S4,
Verification mode is to check the legitimacy of each column list data, the legitimacy is each column list data and the row system
Field of uniting is corresponding.
Preferably, in the S5,
Check results include verifying successfully and verification failure, the mode that list data is imported to traffic table are,
If verified successfully, the list data in interim table is imported into traffic table；
If verification failure, user changes the list data of verification failure and is verified again manually.
The beneficial effects of the invention are as follows：The present invention provides a kind of batch data matching introduction method, and list data is imported
Into information system, matching scheme table, the title of list data, the system field of system information, interim table and industry are defined first
Business table, therefore a variety of list datas for being not fixed field format are imported suitable for batch, then according to matching scheme table, check mark
Whether topic and system field match and check matching result, and the matched system field of manual modification is carried out if mismatching, and solve
There are problems that the importing of the inconsistent list data of field in award of bid topic and system, then according to matching result, user is according to table
First five row data of data, which confirm matching result, accordingly to be confirmed as a result, carry out secondary manual modification matching result,
Then according to confirming as a result, all importing list data in interim tables and verifying list data and obtain corresponding check results, root
According to check results, after modification verifies successfully again, list data is imported into traffic table, solving an error in data need to remodify
And again import system the problem of.
Description of the drawings
Attached drawing is used to provide further understanding of the present invention, and a part for constitution instruction, the reality with the present invention
Example is applied together for explaining the present invention, is not construed as limiting the invention.In the accompanying drawings：
Fig. 1 is flow diagram of the present invention.
Specific embodiment
As shown in Figure 1, a kind of batch data matching introduction method, list data is imported into information system, including step
Suddenly：
S1, matching scheme table, the title of list data, the system field of system information, interim table and traffic table are defined；
S2, according to matching scheme table, check whether title and system field match and check matching result；
S3, according to matching result, user confirms matching result to obtain phase according to first five row data of list data
It should confirm result；
S4, according to confirming as a result, all importing list data in interim tables and verifying list data and accordingly verified
As a result；
S5, according to check results, list data is imported into traffic table.
Specifically, in the S1,
The Data Matching of different user is imported into history table and is defined as matching scheme table；
It is title by the first row each column data definition of list data；
It is traffic table by the form definition that data are stored in information system；
It is system field by the gauge outfit data definition of traffic table each column；
It is interim table by the form definition comprising system field created in Data Matching importing process temporarily.
Specifically, in the S2, whether matching way is consistent with system field character to check title；
If so, user changes the system field of title match or no longer changes matching result manually；
It selects corresponding system field or ignores to match inconsistent title if it is not, user is the inconsistent title of matching
Under list data.
Check matching result mode be, if the corresponding system field of each column title match；
If so, into S3；If it is not, then reset S2 steps.
Specifically, in the S3, confirmation process is, user is according in first five row data and S2 of preview list data
With as a result, it is secondary it is manual change title match system field or no longer change matching result, if it is secondary it is manual change
It then needs to check again for matching result with result.
Specifically, according to the title of secondary manual change matching result and system field and the data pair in matching scheme table
Than inconsistent data will preserve as new scheme and update matching scheme table.
Specifically, in the S4,
Verification mode is to check the legitimacy of each column list data, the legitimacy is each column list data and the row system
Field of uniting is corresponding.
Specifically, in the S5, check results include verifying successfully to fail with verification, and list data is imported traffic table
Mode is,
If verified successfully, the list data in interim table is imported into traffic table；
If verification failure, user changes the list data of verification failure and is verified again manually.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, although with reference to aforementioned reality
Example is applied the present invention is described in detail, it for those skilled in the art, still can be to aforementioned each implementation
Technical solution recorded in example modifies or carries out equivalent replacement to which part technical characteristic.All essences in the present invention
With within principle, any modification, equivalent replacement, improvement and so on should all be included in the protection scope of the present invention god.
Claims (7)
1. a kind of batch data matches introduction method, list data is imported into information system, which is characterized in that including step
Suddenly：
S1, matching scheme table, the title of list data, the system field of system information, interim table and traffic table are defined；
S2, according to matching scheme table, check whether title and system field match and check matching result；
S3, according to matching result, user matching result is confirmed to obtain according to first five row data of list data it is corresponding really
Recognize result；
S4, according to confirming as a result, all importing list data in interim tables and verifying list data and obtain corresponding check results；
S5, according to check results, list data is imported into traffic table.
2. a kind of batch data matching introduction method according to claim 1, which is characterized in that, will be different in the S1
The Data Matching of user imports history table and is defined as matching scheme table；
It is title by the first row each column data definition of list data；
It is traffic table by the form definition that data are stored in information system；
It is system field by the gauge outfit data definition of traffic table each column；
It is interim table by the form definition comprising system field created in Data Matching importing process temporarily.
3. a kind of batch data matching introduction method according to claim 1, which is characterized in that in the S2, match party
Whether formula is consistent with system field character to check title；
If so, user changes the system field of title match or no longer changes matching result manually；
It selects corresponding system field or ignores to match under inconsistent title if it is not, user is the inconsistent title of matching
List data.
Check matching result mode be, if the corresponding system field of each column title match；
If so, into S3；If it is not, then reset S2 steps.
4. a kind of batch data matching introduction method according to claim 1, which is characterized in that acknowledged in the S3
Cheng Wei, user according to the matching result in first five row data and S2 of preview list data, secondary manual change title match
System field no longer changes matching result, needs to check again for matching result if secondary manual change matching result.
5. a kind of batch data matching introduction method according to claim 4, which is characterized in that according to secondary manual change
The title and system field of matching result and the data comparison in matching scheme table, inconsistent data will be as new scheme
It preserves and updates matching scheme table.
6. a kind of batch data matching introduction method according to claim 1, which is characterized in that in the S4, verification side
Formula is to check the legitimacy of each column list data, the legitimacy is that each column list data is corresponding with the row system field.
7. a kind of batch data matching introduction method according to claim 1, which is characterized in that in the S5, verification knot
Fruit includes verifying successfully and verification failure, the mode that list data is imported to traffic table are,
If verified successfully, the list data in interim table is imported into traffic table；
If verification failure, user changes the list data of verification failure and is verified again manually.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711459982.0A CN108197207A (en) | 2017-12-28 | 2017-12-28 | Batch data matches introduction method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711459982.0A CN108197207A (en) | 2017-12-28 | 2017-12-28 | Batch data matches introduction method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108197207A true CN108197207A (en) | 2018-06-22 |
Family
ID=62585318
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711459982.0A Pending CN108197207A (en) | 2017-12-28 | 2017-12-28 | Batch data matches introduction method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108197207A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109656985A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Data lead-in method, system, terminal and storage medium |
| CN110297833A (en) * | 2019-07-05 | 2019-10-01 | 税安科技(杭州)有限公司 | A kind of bordereau error correction method |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN111476661A (en) * | 2020-05-04 | 2020-07-31 | 武汉众邦银行股份有限公司 | General ledger system batch processing method for cyclic check entry |
| CN114416832A (en) * | 2022-01-26 | 2022-04-29 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101866364A (en) * | 2010-06-22 | 2010-10-20 | 用友软件股份有限公司 | Data lead-in method and device |
| CN102609769A (en) * | 2011-01-19 | 2012-07-25 | 上海中信信息发展股份有限公司 | Data acquisition tool and data acquisition method |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104978333A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Automatic matching method based on Excel statistical form and web technology |
| CN105824849A (en) * | 2015-01-08 | 2016-08-03 | ***通信集团河南有限公司 | Data import method and adapter |
-
2017
- 2017-12-28 CN CN201711459982.0A patent/CN108197207A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101866364A (en) * | 2010-06-22 | 2010-10-20 | 用友软件股份有限公司 | Data lead-in method and device |
| CN102609769A (en) * | 2011-01-19 | 2012-07-25 | 上海中信信息发展股份有限公司 | Data acquisition tool and data acquisition method |
| CN104978333A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Automatic matching method based on Excel statistical form and web technology |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN105824849A (en) * | 2015-01-08 | 2016-08-03 | ***通信集团河南有限公司 | Data import method and adapter |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109656985A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Data lead-in method, system, terminal and storage medium |
| CN110297833A (en) * | 2019-07-05 | 2019-10-01 | 税安科技(杭州)有限公司 | A kind of bordereau error correction method |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN111476661A (en) * | 2020-05-04 | 2020-07-31 | 武汉众邦银行股份有限公司 | General ledger system batch processing method for cyclic check entry |
| CN111476661B (en) * | 2020-05-04 | 2023-07-11 | 武汉众邦银行股份有限公司 | Batch processing method of general ledger system for cyclic check-in account |
| CN114416832A (en) * | 2022-01-26 | 2022-04-29 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
| CN114416832B (en) * | 2022-01-26 | 2022-11-15 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108197207A (en) | Batch data matches introduction method | |
| CN108460115A (en) | Information push method, device, computer equipment and storage medium | |
| CN107463348B (en) | Method and system for realizing Web end custom format printing based on B/S architecture | |
| CN104317618B (en) | A kind of firmware partition treating method and apparatus | |
| CN106097058A (en) | E-commerce platform heterogeneous data processing method and system | |
| CN109117172B (en) | Method and device for identifying terminal version number of target terminal | |
| CN111369290A (en) | Method and system for automatically generating data acquisition module | |
| CN108021468A (en) | The method of calibration and device of business datum in medical treatment endowment cooperative system | |
| CN112486997A (en) | Data processing method, device, equipment and storage medium | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| US9084131B2 (en) | Data cut-over method and apparatus | |
| CN113487337A (en) | Product information storage method, tracing method and block chain platform | |
| CN109857806B (en) | Synchronous verification method and device for database table | |
| CN114386853A (en) | Data auditing processing method, device and equipment based on universal auditing model | |
| CN112132291B (en) | Intelligent brain optimization method, device, medium and terminal applied to government affair system | |
| CN103678413A (en) | Method and device for displaying dynamic column of report | |
| CN109857450B (en) | Verification service arrangement method and device | |
| CN107784064B (en) | Webpage data processing method and device, computer equipment and computer storage medium | |
| US20160267172A1 (en) | Constraint free model | |
| CN104735079A (en) | Payment verification method and device based on domain name system (DNS) | |
| CN109034834A (en) | Commercial subject business scope register method, device, terminal device and storage medium | |
| CN107729156A (en) | A kind of application collision solves method and device | |
| CN109993590B (en) | Electronic invoice issuing method and device, electronic equipment and medium | |
| CN109255690A (en) | Choosing method, device and the computer readable storage medium of bid supplier | |
| CN111507447A (en) | Label identification method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |