CN107818161A - A kind of data capture method and device - Google Patents
A kind of data capture method and device Download PDFInfo
- Publication number
- CN107818161A CN107818161A CN201711052383.7A CN201711052383A CN107818161A CN 107818161 A CN107818161 A CN 107818161A CN 201711052383 A CN201711052383 A CN 201711052383A CN 107818161 A CN107818161 A CN 107818161A
- Authority
- CN
- China
- Prior art keywords
- data
- document table
- return value
- interface
- value tables
- 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
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000013481 data capture Methods 0.000 title claims abstract description 21
- 238000006243 chemical reaction Methods 0.000 claims abstract description 28
- 238000007726 management method Methods 0.000 claims description 19
- 238000003860 storage Methods 0.000 claims description 16
- 238000013506 data mapping Methods 0.000 claims description 6
- 241000208340 Araliaceae Species 0.000 claims description 5
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims description 5
- 235000003140 Panax quinquefolius Nutrition 0.000 claims description 5
- 235000008434 ginseng Nutrition 0.000 claims description 5
- 230000005055 memory storage Effects 0.000 claims description 3
- 238000013500 data storage Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 238000000151 deposition Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of data capture method and device, this method can include：According to the configuration information of outside input, interface is configured；The column information inputted respectively according to outside, create parametric data table and return value tables of data；Determine default parameter document table corresponding with the parametric data table and target document table corresponding with the return value tables of data；When receiving the acquisition instruction of the corresponding interface, the specified data in the parameter document table are converted into the recognizable data of the interface, and the specified data after conversion are correspondingly stored into the parametric data table；Returned data corresponding to the parametric data table for the specified data being stored with by the interface from outside acquisition after conversion, and store into the return value tables of data；The data that conformability management system where returned data in the return value tables of data is converted to can recognize that, and the returned data after conversion is correspondingly stored into the target document table.This programme can improve the efficiency of data acquisition.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of data capture method and device.
Background technology
Comprehensive Budget Management system is a kind of conformability management system, has the ability controlled comprehensively.Comprehensive Budget Management
System needs to obtain data from the operation systems such as financial accounting, logistics and the cost of outside, and it is accurate to carry out science with this
Budget.
At present, when needing the operation system from outside to obtain data, largely hard compile mainly is carried out by developer
Code is realized.However, when needs obtain different numbers respectively from multiple operation systems acquisition data, or from an operation system
According to when, carrying out different hard codeds respectively by developer will expend the plenty of time, so as to cause the efficiency of data acquisition
It is relatively low.
The content of the invention
The embodiments of the invention provide a kind of data capture method and device, it is possible to increase the efficiency of data acquisition.
In a first aspect, the embodiments of the invention provide a kind of data capture method,
According to the configuration information of outside input, interface is configured；
The column information inputted respectively according to outside, create parametric data table and return value tables of data；
Determine default parameter document table corresponding to the parametric data table and corresponding with the return value tables of data
Target document table；Also include：
When receiving the acquisition instruction of the corresponding interface, the specified data in the parameter document table are converted into institute
The recognizable data of interface are stated, and the specified data after conversion are correspondingly stored into the parametric data table；
Corresponding to the parametric data table for the specified data being stored with by the interface from outside acquisition after conversion
Returned data, and store into the return value tables of data；
The data that conformability management system where returned data in the return value tables of data is converted to can recognize that,
And the returned data after conversion is correspondingly stored into the target document table.
Preferably,
It is described determine default parameter document table corresponding with the parametric data table and with the return Value Data
After target document table corresponding to table, and be converted to the interface in the specified data by the parameter document table and can know
Before other data, further comprise：
First corresponding relation of the row and the row in the parameter document table in the parametric data table is set；
Data corresponding relation corresponding to respective column in the parametric data table is set；
The specified data by the parameter document table are converted to the recognizable data of the interface, including：
According to first corresponding relation, the data in respective column in the parameter document table are obtained；
According to the data corresponding relation, the data got from respective column are changed.
Preferably,
It is described determine default parameter document table corresponding with the parametric data table and with the return Value Data
After target document table corresponding to table, and be converted to the interface in the specified data by the parameter document table and can know
Before other data, further comprise：
Second corresponding relation of the row and the row in the target document table in the return value tables of data is set；
Data corresponding relation corresponding to respective column in the return value tables of data is set；
What the conformability management system that the returned data by the return value tables of data is converted to place can recognize that
Data, including：
According to second corresponding relation, the data of taking-up respective column from the return value tables of data；
According to the data corresponding relation, the data taken out from respective column are changed.
Second aspect, the embodiments of the invention provide a kind of data acquisition facility, including：Dispensing unit, the first conversion are single
Member, data capture unit and the second converting unit, wherein,
The dispensing unit, for the configuration information according to outside input, configure interface；The row inputted respectively according to outside
Information, create parametric data table and return value tables of data；And determine default parameter list corresponding with the parametric data table
According to table and target document table corresponding with the return value tables of data；
First converting unit, for when receiving the acquisition instruction of the corresponding interface, by the parameter document
Specified data in table are converted to the recognizable data of the interface, and the specified data after conversion are correspondingly stored to the ginseng
In number tables of data；
The data capture unit, for being stored with the institute of the specified data after conversion from outside acquisition by the interface
The returned data corresponding to parametric data table is stated, and is stored into the return value tables of data；
Second converting unit, for the conformability where the returned data in the return value tables of data is converted to
The recognizable data of management system, and the returned data after conversion is correspondingly stored into the target document table.
Preferably,
Further comprise：First setting unit；
First setting unit, for determining default ginseng corresponding with the parametric data table in the dispensing unit
After number document table and target document table corresponding with the return value tables of data, and in first converting unit by described in
Before specified data in parameter document table are converted to the recognizable data of the interface, the row in the parametric data table are set
Corresponding to the respective column in the first corresponding relation of the row in the parameter document table, and the setting parametric data table
Data corresponding relation；
First converting unit, for according to first corresponding relation, obtaining respective column in the parameter document table
In data；According to the data corresponding relation, the data got from respective column are changed.
Preferably,
Further comprise：Second setting unit；
Second setting unit, for determining default ginseng corresponding with the parametric data table in the dispensing unit
After number document table and target document table corresponding with the return value tables of data, and in first converting unit by described in
Before specified data in parameter document table are converted to the recognizable data of the interface, set in the return value tables of data
Second corresponding relation of row and the row in the target document table, and set the respective column institute in the return value tables of data right
The data corresponding relation answered；
Second converting unit, for according to second corresponding relation, phase to be taken out from the return value tables of data
The data that should be arranged；According to the data corresponding relation, the data taken out from respective column are changed.
Preferably,
The data corresponding relation, including：Any one in direct value, data mapping and constant.
The third aspect, the embodiments of the invention provide a kind of computer-readable medium, including computer executed instructions, when depositing
When storing up computer executed instructions described in the computing device of controller, the storage control is performed described in any of the above-described embodiment
Data capture method.
Fourth aspect, the embodiments of the invention provide a kind of storage control, including：Processor, memory and bus；
The memory is used to store computer executed instructions, and the processor is connected with the memory by the bus
Connect, when the storage control is run, the computer executed instructions of memory storage described in the computing device, with
The storage control perform claim is set to require the method described in 1 to 4 any one.
The embodiments of the invention provide a kind of data capture method and device, and number is obtained when needing the operation system from outside
According to when, the configuration of interface can be completed according to the configuration information of input, and according to the column information inputted respectively, create and the interface
Corresponding parametric data table and return value tables of data, and be created that and the parameter number from default parameters document table
According to the corresponding parameter document table of table, and for storing the target document table of final data, so, receiving accordingly afterwards
Acquisition instruction after, it is possible to the data in parameter document table are converted to the data in parametric data table first, then called
The interface, with the returned data corresponding to the data from outside acquisition parametric data table, and store into return value tables of data,
After the data that finally the conformability management system where being converted to can identify, by final data storage to corresponding target
In document table.During due to obtaining data each time, it is no longer necessary to developer carries out substantial amounts of hard coded, and according to outside input
Configuration information can complete the configuration of interface, and then complete the acquisition of data, therefore this programme can improve data acquisition
Efficiency.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
These accompanying drawings obtain other accompanying drawings.
Fig. 1 is a kind of flow chart for data capture method that one embodiment of the invention provides；
Fig. 2 is a kind of flow chart for data capture method that another embodiment of the present invention provides；
Fig. 3 is a kind of structural representation for data acquisition facility that one embodiment of the invention provides；
Fig. 4 is a kind of structural representation for data acquisition facility that another embodiment of the present invention provides；
Fig. 5 is a kind of structural representation for data acquisition facility that another embodiment of the invention provides.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, rather than whole embodiments, based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained on the premise of creative work is not made, belongs to the scope of protection of the invention.
As shown in figure 1, the embodiments of the invention provide a kind of data capture method, this method may comprise steps of：
Step 101：According to the configuration information of outside input, interface is configured.
Step 102：The column information inputted respectively according to outside, create parametric data table and return value tables of data.
Step 103：Determine default parameter document table corresponding with the parametric data table and with the return value number
According to target document table corresponding to table.
Step 104：When receiving the acquisition instruction of the corresponding interface, by the specified data in the parameter document table
The recognizable data of the interface are converted to, and the specified data after conversion are correspondingly stored into the parametric data table.
Step 105：It is stored with the institute of the specified data after conversion from outside acquisition by the interface by the interface
The returned data corresponding to parametric data table is stated, and is stored into the return value tables of data.
Step 106：Conformability management system where returned data in the return value tables of data is converted to can be known
Other data, and the returned data after conversion is correspondingly stored into the target document table.
The embodiments of the invention provide a kind of data capture method, when needing the operation system from outside to obtain data,
The configuration of interface can be completed, and according to the column information inputted respectively, create corresponding with the interface according to the configuration information of input
Parametric data table and return value tables of data, and be created that and the parametric data table phase from default parameters document table
Corresponding parameter document table, and for storing the target document table of final data, so, receiving corresponding acquisition afterwards
After instruction, it is possible to the data in parameter document table are converted to the data in parametric data table first, then call the interface,
With the returned data corresponding to the data from outside acquisition parametric data table, and store into return value tables of data, finally exist
After the data that conformability management system where being converted to can identify, by final data storage to corresponding target document table
In.During due to obtaining data each time, it is no longer necessary to developer carries out substantial amounts of hard coded, and according to the configuration of outside input
Information can complete the configuration of interface, and then complete the acquisition of data, therefore this programme can improve the efficiency of data acquisition.
In an embodiment of the invention, after the step 103, and before the step 104, further wrap
Include：First corresponding relation of the row and the row in the parameter document table in the parametric data table is set；The parameter is set
Data corresponding relation corresponding to respective column in tables of data；
The embodiment of the step 104, it may include：According to first corresponding relation, the parameter list is obtained
According to the data in respective column in table；According to the data corresponding relation, the data got from respective column are changed.
For example, the parametric data table created for the interface of configuration is as shown in table 1 below；
Table 1
| Sell product | Month | Area |
It is Shandong District product as shown in table 2 below with the parameter document table corresponding to the parametric data table table 1 of the interface
Sell parameter document table；
Table 2
| Name of product | Model | Month | Sales volume | Average price | The amount of money |
| Product 01 | Wp-1 | 2017.01 | 500 | ||
| Product 01 | Qe-5 | 2017.01 | 600 | ||
| … | … | … | … |
In the embodiment of the present invention, the first corresponding relation between the row of the table 1 of foundation and the row of table 2 may include have：
(1) product --- --- name of product+model is sold；
(2) --- --- month in month；
The data corresponding relation of foundation may include have：
(1) direct value (sale product --- --- name of product+model)；
(2) data mapping (month --- --- month), the month form after specific mapping is the rear two-month in time
(such as 17-01)；
(3) regional --- --- constant (Shandong)；
According to the first corresponding relation and data corresponding relation of above-mentioned foundation, the data in parameter document table are converted to
The recognizable data of the interface, and the data after conversion are correspondingly stored into the respective column in table 1, in the embodiment of the present invention
In, can be as shown in table 3 below in final table 1 after the data are stored；
Table 3
| Sell product | Month | Area |
| Product 01Wp-1 | 17-01 | Shandong |
| Product 01Qe-5 | 17-01 | Shandong |
| … | … | … |
So after the parametric data table (as shown in upper table 3) for the data for obtaining being stored with after changing, it is possible to obtain
The webservice addresses of the pre-defined interface interchange and method, the data of parametric data table table 3 are then passed to method
In parameter in, calling interface, to get required data from outside corresponding operation system.
In an embodiment of the invention, after the step 103, and before the step 104, further wrap
Include：Second corresponding relation of the row and the row in the target document table in the return value tables of data is set；Returned described in setting
The data corresponding relation corresponding to respective column returned in Value Data table；
The embodiment of the step 106, it may include：According to second corresponding relation, from the return value number
According to the data that respective column is taken out in table；According to the data corresponding relation, the data taken out from respective column are changed.
In embodiments of the present invention, by setting the second corresponding relation and corresponding data corresponding relation, mainly it is
The data that conformability management system where the data got from outside are converted into itself can identify, specifically,
Process contrary with being converted to the data in parametric data table in above-described embodiment by the data in parameter document table, herein no longer
Repeat.
In an embodiment of the invention, the data corresponding relation, including：Direct value, data mapping and constant
In any one.
A kind of data capture method provided in an embodiment of the present invention is described more detail below, as shown in Fig. 2 this method can be with
Comprise the following steps：
Step 201：According to the configuration information of outside input, interface is configured.
In embodiments of the present invention, can be then defeated on the surface according to user by showing a configuration interface to user
The configuration information entered, interface is configured, specifically, outside webservice addresses, method and the parameter of configuration interface interchange.
For example, the configuration information inputted respectively according to user, is configured with two interfaces, the numbering of first interface is 001,
Interface name is Shandong District production marketing price interface, and the numbering of second interface is 002, interface name be accounting system with
Demonstrate,prove interface.
Step 202：The column information inputted respectively according to outside, create parametric data table and return value tables of data.
For each interface, at least one parametric data table can be created according to actual demand, and with each parameter
The corresponding return value tables of data of tables of data.At the same time, the conformability management system (such as Comprehensive Budget Management system) at place
In there is also the parameter document table corresponding with each parametric data table.
In embodiments of the present invention, exemplified by creating a parametric data table.
Step 203：Determine default parameter document table corresponding to parametric data table and corresponding with return value tables of data
Target document table.
In embodiments of the present invention, parameter document table and target document table are likely to be a table, so, finally can
To be changed to the data in return value tables of data, and by the data storage after conversion into parameter document table before.
Step 204：First corresponding relation of row and the row in parameter document table in arrange parameter tables of data.
Step 205：Data corresponding relation corresponding to respective column in arrange parameter tables of data.
Step 206：Second corresponding relation of the row and the row in target document table in return value tables of data is set.
Step 207：Data corresponding relation corresponding to respective column in return value tables of data is set.
Step 208：When receiving the acquisition instruction of the corresponding interface, according to the first corresponding relation, get parms list
According to the data in respective column in table.
After two interfaces in having configured step 201, the interface of an acquisition data can be shown to user, is opened up in interface
Show the information of the two interfaces, so, user may be selected by corresponding interface, then according to each corresponding pass of above-mentioned foundation
System, corresponding data are obtained by corresponding interface.
Step 209：The data got are entered by the data corresponding relation corresponding to the respective column in parametric data table
Row conversion, to be converted to the recognizable data of interface, and the data after conversion are correspondingly stored into parametric data table.
Should be the interface institute energy first by corresponding Parameter Switch when obtaining data from outside in the embodiment of the present invention
The data of identification, namely meet the data format of corresponding external service system.
Step 210：Corresponding to the parametric data table for obtaining the specified data after being stored with conversion from outside by interface
Returned data, and store into return value tables of data.
Step 211：According to the second corresponding relation, the data of taking-up respective column from return value tables of data.
Step 212：According to the data corresponding relation corresponding to the respective column set in return value tables of data, to from respective column
The data of taking-up are changed, with the recognizable data of the conformability management system where being converted to, and by the return after conversion
Data are correspondingly stored into target document table.
As shown in figure 3, the embodiments of the invention provide a kind of data acquisition facility, the device can include：Dispensing unit
301st, the first converting unit 302, the converting unit 304 of data capture unit 303 and second, wherein,
The dispensing unit 301, for the configuration information according to outside input, configure interface；Inputted respectively according to outside
Column information, create parametric data table and return value tables of data；And determine default ginseng corresponding with the parametric data table
Number document table and target document table corresponding with the return value tables of data；
First converting unit 302, for when receiving the acquisition instruction of the corresponding interface, by the parameter list
The recognizable data of the interface are converted to according to the specified data in table, and the specified data after conversion are correspondingly stored to described
In parametric data table；
The data capture unit 303, for being stored with the specified data after conversion from outside acquisition by the interface
The parametric data table corresponding to returned data, and store into the return value tables of data；
Second converting unit 304, for whole where the returned data in the return value tables of data is converted to
The recognizable data of conjunction property management system, and the returned data after conversion is correspondingly stored into the target document table.
As shown in figure 4, in an embodiment of the invention, further comprise：First setting unit 401；
First setting unit 401, for determining the default and parametric data table pair in the dispensing unit 301
After the parameter document table and target document table corresponding with the return value tables of data answered, and in first converting unit
Before specified data in the parameter document table are converted to the recognizable data of the interface by 302, the parameter number is set
According to the first corresponding relation of row and the row in the parameter document table in table, and set corresponding in the parametric data table
The corresponding data corresponding relation of row；
First converting unit 302, for according to first corresponding relation, obtaining corresponding in the parameter document table
Data in row；According to the data corresponding relation, the data got from respective column are changed.
As shown in figure 5, in an embodiment of the invention, further comprise：Second setting unit 501；
Second setting unit 501, for determining the default and parametric data table pair in the dispensing unit 301
After the parameter document table and target document table corresponding with the return value tables of data answered, and in first converting unit
Before specified data in the parameter document table are converted to the recognizable data of the interface by 302, the return value is set
Second corresponding relation of row and the row in the target document table in tables of data, and set in the return value tables of data
Data corresponding relation corresponding to respective column；
Second converting unit 304, for according to second corresponding relation, being taken out from the return value tables of data
The data of respective column；According to the data corresponding relation, the data taken out from respective column are changed.
In an embodiment of the invention, the data corresponding relation, including：Direct value, data mapping and constant
In any one.
The contents such as the information exchange between each unit, implementation procedure in said apparatus, due to implementing with the inventive method
Example is based on same design, and particular content can be found in the narration in the inventive method embodiment, and here is omitted.
The embodiments of the invention provide a kind of computer-readable medium, including computer executed instructions, work as storage control
Computing device described in computer executed instructions when, the data that the storage control performs described in any of the above-described embodiment obtain
Take method.
The embodiments of the invention provide a kind of storage control, including：Processor, memory and bus；The memory
For storing computer executed instructions, the processor is connected with the memory by the bus, when the storage control
When device is run, the computer executed instructions of memory storage described in the computing device, so that the storage control
Perform the data capture method described in any of the above-described embodiment.
To sum up, each embodiment of the present invention at least has the advantages that：
1st, in embodiments of the present invention, can be according to the configuration of input when needing the operation system from outside to obtain data
Information, the configuration of interface is completed, and according to the column information inputted respectively, create the parametric data table corresponding with the interface and return
Value Data table is returned, and the parameter document corresponding with the parametric data table is created that from default parameters document table
Table, and for storing the target document table of final data, so, afterwards after corresponding acquisition instruction is received, it is possible to
Data in parameter document table are converted to the data in parametric data table first, then call the interface, to be obtained from outside
Returned data in the parametric data table corresponding to data, and store into return value tables of data, finally where being converted to
After the data that conformability management system can identify, by final data storage into corresponding target document table.Due to each
During secondary acquisition data, it is no longer necessary to which developer carries out substantial amounts of hard coded, and can be complete according to the configuration information of outside input
Into the configuration of interface, and then the acquisition of data is completed, therefore this programme can improve the efficiency of data acquisition.
2nd, in embodiments of the present invention, by pre-setting between the row of parametric data table and the row of parameter document table
One corresponding relation, and the data corresponding relation corresponding to the respective column of parametric data table, then in the operation system from outside
When obtaining data, the data in default parameter document table can be converted to and can connect first according to the two corresponding relations
The data of mouth identification, and correspondingly store into the row of corresponding parametric data table, it can be obtained so as to after in calling interface
Get the returned data corresponding with the parametric data table.
3rd, in embodiments of the present invention, by pre-setting the row in return value tables of data and the row in target document table
Data corresponding relation corresponding to respective column in second corresponding relation, and return value tables of data, so, by interface from
, can be whole where the data got are converted to according to the two corresponding relations after outside gets required data
The data that conjunction property management system can identify, and correspondingly store into corresponding target document table, final number is completed with this
According to acquisition.
4th, in embodiments of the present invention, when obtaining data, substantial amounts of hard coded is avoided, reduces cost input, and
And configured by unified, flexible software interface, the mode that traditional hardness coding calls external interface is effectively changed, is reduced
The maintenance of program and development amount.
It should be noted that herein, such as first and second etc relational terms are used merely to an entity
Or operation makes a distinction with another entity or operation, and not necessarily require or imply and exist between these entities or operation
Any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant be intended to it is non-
It is exclusive to include, so that process, method, article or equipment including a series of elements not only include those key elements,
But also the other element including being not expressly set out, or also include solid by this process, method, article or equipment
Some key elements.In the absence of more restrictions, the key element limited by sentence " including one ", is not arranged
Except other identical factor in the process including the key element, method, article or equipment being also present.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing program can be stored in computer-readable storage medium, the program
Upon execution, the step of execution includes above method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
It is last it should be noted that：Presently preferred embodiments of the present invention is the foregoing is only, is merely to illustrate the skill of the present invention
Art scheme, is not intended to limit the scope of the present invention.Any modification for being made within the spirit and principles of the invention,
Equivalent substitution, improvement etc., are all contained in protection scope of the present invention.
Claims (10)
- A kind of 1. data capture method, it is characterised in thatAccording to the configuration information of outside input, interface is configured；The column information inputted respectively according to outside, create parametric data table and return value tables of data；Determine default parameter document table corresponding with the parametric data table and mesh corresponding with the return value tables of data Mark document table；Also include：When receiving the acquisition instruction of the corresponding interface, the specified data in the parameter document table are converted into described connect The recognizable data of mouth, and the specified data after conversion are correspondingly stored into the parametric data table；Return corresponding to the parametric data table for the specified data being stored with by the interface from outside acquisition after conversion Data, and store into the return value tables of data；The data that conformability management system where returned data in the return value tables of data is converted to can recognize that, and will Returned data after conversion is correspondingly stored into the target document table.
- 2. according to the method for claim 1, it is characterised in thatIt is described determine default parameter document table corresponding with the parametric data table and with the return value tables of data pair After the target document table answered, and be converted to what the interface can recognize that in the specified data by the parameter document table Before data, further comprise：First corresponding relation of the row and the row in the parameter document table in the parametric data table is set；Data corresponding relation corresponding to respective column in the parametric data table is set；The specified data by the parameter document table are converted to the recognizable data of the interface, including：According to first corresponding relation, the data in respective column in the parameter document table are obtained；According to the data corresponding relation, the data got from respective column are changed.
- 3. according to the method for claim 1, it is characterised in thatIt is described determine default parameter document table corresponding with the parametric data table and with the return value tables of data pair After the target document table answered, and be converted to what the interface can recognize that in the specified data by the parameter document table Before data, further comprise：Second corresponding relation of the row and the row in the target document table in the return value tables of data is set；Data corresponding relation corresponding to respective column in the return value tables of data is set；The returned data by the return value tables of data is converted to the data that the conformability management system at place can recognize that, Including：According to second corresponding relation, the data of taking-up respective column from the return value tables of data；According to the data corresponding relation, the data taken out from respective column are changed.
- 4. according to the method in claim 2 or 3, it is characterised in thatThe data corresponding relation, including：Any one in direct value, data mapping and constant.
- A kind of 5. data acquisition facility, it is characterised in that including：Dispensing unit, the first converting unit, data capture unit and Two converting units, wherein,The dispensing unit, for the configuration information according to outside input, configure interface；The row inputted respectively according to outside are believed Breath, create parametric data table and return value tables of data；And determine default parameter document corresponding with the parametric data table Table and target document table corresponding with the return value tables of data；First converting unit, for when receiving the acquisition instruction of the corresponding interface, by the parameter document table Specified data be converted to the recognizable data of the interface, and the specified data after conversion are correspondingly stored to the parameter number According in table；The data capture unit, for being stored with the ginseng of the specified data after conversion from outside acquisition by the interface Returned data corresponding to number tables of data, and store into the return value tables of data；Second converting unit, for the conformability management where the returned data in the return value tables of data is converted to The recognizable data of system, and the returned data after conversion is correspondingly stored into the target document table.
- 6. device according to claim 5, it is characterised in thatFurther comprise：First setting unit；First setting unit, for determining default parameter list corresponding with the parametric data table in the dispensing unit After table and target document table corresponding with the return value tables of data, and in first converting unit by the parameter Before specified data in document table are converted to the recognizable data of the interface, the row in the parametric data table and institute are set The first corresponding relation of the row in parameter document table is stated, and the data corresponding to the respective column in the parametric data table are set Corresponding relation；First converting unit, for according to first corresponding relation, obtaining in the parameter document table in respective column Data；According to the data corresponding relation, the data got from respective column are changed.
- 7. device according to claim 5, it is characterised in thatFurther comprise：Second setting unit；Second setting unit, for determining default parameter list corresponding with the parametric data table in the dispensing unit After table and target document table corresponding with the return value tables of data, and in first converting unit by the parameter Before specified data in document table are converted to the recognizable data of the interface, set row in the return value tables of data with Second corresponding relation of the row in the target document table, and set corresponding to the respective column in the return value tables of data Data corresponding relation；Second converting unit, for according to second corresponding relation, respective column to be taken out from the return value tables of data Data；According to the data corresponding relation, the data taken out from respective column are changed.
- 8. according to any described device of claim 6 or 7, it is characterised in thatThe data corresponding relation, including：Any one in direct value, data mapping and constant.
- 9. a kind of computer-readable medium, it is characterised in that including computer executed instructions, when the processor of storage control is held During the row computer executed instructions, the storage control perform claim requires the method described in 1 to 4 any one.
- A kind of 10. storage control, it is characterised in that including：Processor, memory and bus；The memory is used to store computer executed instructions, and the processor is connected with the memory by the bus, When the storage control is run, the computer executed instructions of memory storage described in the computing device, so that The storage control perform claim requires the method described in 1 to 4 any one.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711052383.7A CN107818161A (en) | 2017-10-30 | 2017-10-30 | A kind of data capture method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711052383.7A CN107818161A (en) | 2017-10-30 | 2017-10-30 | A kind of data capture method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107818161A true CN107818161A (en) | 2018-03-20 |
Family
ID=61603551
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711052383.7A Pending CN107818161A (en) | 2017-10-30 | 2017-10-30 | A kind of data capture method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107818161A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112925803A (en) * | 2021-04-09 | 2021-06-08 | 泰康保险集团股份有限公司 | Data processing method and device of interface |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222060A (en) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | Receipt conversion device and receipt conversion method |
| CN105094707A (en) * | 2015-08-18 | 2015-11-25 | 华为技术有限公司 | Method and device for storing and reading data |
| CN105447200A (en) * | 2015-12-30 | 2016-03-30 | 金蝶软件（中国）有限公司 | Data processing method and data processing apparatus |
| US20170161291A1 (en) * | 2015-12-03 | 2017-06-08 | Sap Se | Database table conversion |
| CN106897434A (en) * | 2017-02-27 | 2017-06-27 | 济南浪潮高新科技投资发展有限公司 | A kind of data lead-in method, apparatus and system |
-
2017
- 2017-10-30 CN CN201711052383.7A patent/CN107818161A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222060A (en) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | Receipt conversion device and receipt conversion method |
| CN105094707A (en) * | 2015-08-18 | 2015-11-25 | 华为技术有限公司 | Method and device for storing and reading data |
| US20170161291A1 (en) * | 2015-12-03 | 2017-06-08 | Sap Se | Database table conversion |
| CN105447200A (en) * | 2015-12-30 | 2016-03-30 | 金蝶软件（中国）有限公司 | Data processing method and data processing apparatus |
| CN106897434A (en) * | 2017-02-27 | 2017-06-27 | 济南浪潮高新科技投资发展有限公司 | A kind of data lead-in method, apparatus and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112925803A (en) * | 2021-04-09 | 2021-06-08 | 泰康保险集团股份有限公司 | Data processing method and device of interface |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106875110A (en) | Operational indicator layered calculation method and device, distributed computing method and system | |
| CN109409005B (en) | DCS design document generation method, device, equipment and readable storage medium | |
| CN107274023A (en) | Flow of insuring generation method, insure request processing method and device and electronic equipment | |
| CN108595276A (en) | Processing method, system, computer equipment and the storage medium of service logic | |
| CN110880097B (en) | Project progress simulation display method and device | |
| CN102222285B (en) | Multi-dimensional data linkage computing device and multi-dimensional data linkage computing method | |
| CN106327100A (en) | Change list generation method and device | |
| CN111563075B (en) | Service verification system, method and equipment and storage medium | |
| CN101504742A (en) | Service documents verifying and cancelling method and system | |
| Rotstein et al. | A product portfolio approach in the pharmaceutical industry | |
| CN109409933A (en) | Intelligent fee counting method, computer readable storage medium and terminal device | |
| CN107818161A (en) | A kind of data capture method and device | |
| CN103235847A (en) | Dynamic model allocating method based on matrix transformation | |
| CN109446499A (en) | Contract template generation method, device, equipment and medium based on XML | |
| CN107450975A (en) | A kind of task executing method and device based on layering | |
| Kaveh et al. | A simulated annealing algorithm for aggregate production planning with considering of ancillary costs | |
| CN102968305B (en) | Logical process method, device and evaluation system | |
| US20160180034A1 (en) | Claim reimbursement valuation and remittance validation | |
| CN101650650A (en) | Realization method of application system | |
| Salmasnia et al. | A redundancy allocation problem by using utility function method and ant colony optimization: tradeoff between availability and total cost | |
| CN112348403B (en) | Wind control model construction method and device and electronic equipment | |
| US7467105B2 (en) | Price calculator | |
| CN104572134B (en) | A kind of optimization method and device | |
| CN107203506A (en) | A kind of report form generation method and device | |
| CN101719239A (en) | MRP data processing method and device and MRP system |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180320 |