CN106897434A - A kind of data lead-in method, apparatus and system - Google Patents
A kind of data lead-in method, apparatus and system Download PDFInfo
- Publication number
- CN106897434A CN106897434A CN201710110347.5A CN201710110347A CN106897434A CN 106897434 A CN106897434 A CN 106897434A CN 201710110347 A CN201710110347 A CN 201710110347A CN 106897434 A CN106897434 A CN 106897434A
- Authority
- CN
- China
- Prior art keywords
- data
- source data
- list head
- head
- list
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of data lead-in method, apparatus and system, the method includes：Create data and import mapping table, wherein the data import mapping table includes at least one source data list head and the corresponding relation of receiving terminal list head, also include：Obtain source data table to be imported；Determine at least one intended recipient end list head included by data receiver；Mapping table is imported according to the data, the corresponding target source data list head of each intended recipient end list is determined；It is directed to each described target source data list head, extract the lower data of target source data list head from the source data table, and the data that will be extracted are imported under corresponding with the target source data list intended recipient end list in the data receiver.The device includes：Creating unit, acquiring unit, processing unit, import unit.Data lead-in method, the apparatus and system that this programme is provided are with stronger applicability.
Description
Technical field
The present invention relates to computer realm, more particularly to a kind of data lead-in method, apparatus and system.
Background technology
It is system engineering and the basic link for automatically controlling to carry out data processing with computer.This data processing method
Through social production and the every field of social life, its development and application greatly affect entering for human social development
Journey.During computer processing data, it is an essential link to import data.
At present when data importing is carried out, generally store data into Excel, incited somebody to action by the importing rule write in advance
The data stored in Excel imported into data receiver.
Current data lead-in method is directed to, after the completion of importing rule is write, is merely able to regular from Excel according to importing
Middle importing data, when required data change, it is necessary to write importing rule again, than if desired for increasing or decreasing data line,
Then need to be modified to importing corresponding code in rule.Therefore, the applicability of available data introduction method is poor.
The content of the invention
A kind of data lead-in method, apparatus and system are the embodiment of the invention provides, with stronger applicability.
In a first aspect, the embodiment of the invention provides a kind of data lead-in method, create data and import mapping table, wherein institute
State data and import corresponding relation of the mapping table including at least one source data list head and receiving terminal list head, also include：
Obtain source data table to be imported；
Determine at least one intended recipient end list head included by data receiver；
Mapping table is imported according to the data, the corresponding target source data of each intended recipient end list is determined
List head；
Each described target source data list head is directed to, the target source data row are extracted from the source data table
Data under gauge outfit, and the data that will be extracted imported into the data receiver it is relative with target source data list head
Under the intended recipient end list head answered.
Preferably, the source data table includes：Excel tables of data.
Preferably, it is described to be directed to each described target source data list head, extract described from the source data table
Data under target source data list head, including：
Determine the active operation book in the Excel tables of data；
Each described target source data list head is directed to, the target source data is determined in the active operation book
Gauge outfit line number where list head, the gauge outfit line number and null mark are located in the extraction target source data list head column
Data between knowledge.
Preferably, it is described to be directed to each described target source data list head, extract described from the source data table
Data under target source data list head, including：
Determine the active operation book in the Excel tables of data；
Each described target source data list head is directed to, is located in the extraction target source data list head column
Preassign the data between initial row and predesignated termination row.
Preferably, after the establishment data import mapping table, further include：
According to the modification instruction for receiving, any one of source data included in mapping table is imported to the data
List head is modified with the corresponding relation of receiving terminal list head.
Preferably, after the establishment data import mapping table, further include：
According to the deletion instruction for receiving, any one of source data included in mapping table is imported to the data
List head is deleted with the corresponding relation of receiving terminal list head.
Preferably, after the establishment data import mapping table, further include：
According to the addition instruction for receiving, newly-built source data list head and receiving terminal row in the data import mapping table
The corresponding relation of gauge outfit.
Second aspect, the embodiment of the present invention additionally provides a kind of data importing device, including：Creating unit, acquiring unit,
Processing unit, import unit；
The creating unit, mapping table is imported for creating data, wherein the data import mapping table includes at least one
The corresponding relation of individual source data list head and receiving terminal list；
The acquiring unit, for obtaining source data table to be imported；
The processing unit, for determining at least one intended recipient end list head included by data receiver；And root
The data created according to the creating unit import mapping table, determine each corresponding mesh of intended recipient end list
Mark source data list head；
The import unit, for being directed to each described target source data list that the processing unit is determined
Head, extracts the data under the target source data list head from the source data table that the acquiring unit gets, and will
The data extracted imported into corresponding with the target source data list intended recipient end row in the data receiver
Under gauge outfit.
Preferably, when the source data table includes Excel tables of data,
The import unit includes：First extracts subelement；
The extraction subelement, for determining the active operation book in the Excel tables of data；And it is directed to each
The target source data list head, the gauge outfit row where the target source data list head is determined in the active operation book
Number, extracts the data being located between the gauge outfit line number and null mark in the target source data list head column.
Preferably, when the source data table includes Excel tables of data,
The import unit includes：Second extracts subelement；
Described second extracts subelement, for determining the active operation book in the Excel tables of data；And be directed to every
One target source data list head, extract be located in target source data list head column preassign initial row with
Preassign the data between termination row.
Preferably, the processing unit, is further used for, according to the modification instruction for receiving, importing the data and mapping
Any one of source data list head included in table is modified with the corresponding relation of receiving terminal list head.
Preferably, the processing unit, is further used for, according to the deletion instruction for receiving, importing the data and mapping
Any one of source data list head included in table is deleted with the corresponding relation of receiving terminal list head.
Preferably, the processing unit, is further used for, according to the addition instruction for receiving, being imported in the data and being mapped
The corresponding relation of newly-built source data list head and receiving terminal list in table.
The third aspect, the embodiment of the present invention additionally provides a kind of data import system, including：Data receiver and above-mentioned reality
Any one data importing device of example offer is provided；
The data receiver, for receiving the data that the data importing device is imported.
A kind of data lead-in method, apparatus and system are the embodiment of the invention provides, at least one is determined from data receiver
After the gauge outfit of individual intended recipient end, import mapping table according to the data for creating and determine each corresponding mesh of intended recipient end gauge outfit
Mark source data list head, extracts the data under target source data list head from source data table, and the data that will be extracted are imported
Under corresponding with target source data list intended recipient end list head in data receiver.Therefore the present invention can basis
Demand determines different intended recipient end list heads, and importing mapping table by data determines corresponding target source data list head
The data needed for source data table are imported into data receiver afterwards, and then flexibly change is led can to import demand according to data
The data for entering, meet different data and import demand, thus with stronger applicability.
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
The accompanying drawing to be used needed for having technology description is 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 of data lead-in method that one embodiment of the invention is provided；
Fig. 2 is a kind of flow chart of data lead-in method that another embodiment of the present invention is provided；
Fig. 3 is a kind of schematic diagram of data importing device that one embodiment of the invention is provided；
Fig. 4 is a kind of schematic diagram of data import system that one embodiment of the invention is provided.
Specific 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
A part of 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 embodiment of the invention provides a kind of data lead-in method, the method may comprise steps of：
Step 101, creates data and imports mapping table, wherein the data import mapping table being arranged including at least one source data
The corresponding relation of gauge outfit and receiving terminal list head；
Step 102, obtains source data table to be imported；
Step 103, determines at least one intended recipient end list head included by data receiver；
Step 104, mapping table is imported according to the data, determines each corresponding mesh of intended recipient end list
Mark source data list head；
Step 105, is directed to each described target source data list head, and the target is extracted from the source data table
Data under source data list head；
Step 106, and the data that will be extracted are imported into the data receiver and the target source data list head
Under corresponding intended recipient end list head.
A kind of data lead-in method is the embodiment of the invention provides, at least one intended recipient end is determined from data receiver
After gauge outfit, import mapping table according to the data for creating and determine each corresponding target source data list of intended recipient end gauge outfit
Head, extracts the data under target source data list head from source data table, and the data that will be extracted imported into data receiver
In under corresponding with target source data list intended recipient end list head.Therefore the present invention can according to demand determine difference
Intended recipient end list head, imported source data table after mapping table determines corresponding target source data list head by data
Needed for data imported into data receiver, and then the data that demand flexibly change importing can be imported according to data, it is full
The different data of foot import demand, thus with stronger applicability.
In one embodiment of the invention, the source data table described in step 102 can be Excel tables of data.Due to
Excel tables of data is general data storage medium, and the data being widely used in data handling procedure are imported, therefore with
Excel tables of data carries out data importing as source data table, further increases the data importing that the embodiment of the present invention is provided
The applicability of method.
In an embodiment of the invention, when the source data table is Excel tables of data, from source data in step 105
The process of target data is extracted in table, there can be following two modes：
Mode one, according to target source data list head and null marker extraction data；
Mode two, data are extracted according to initial row and termination row.
Below for above two data extraction method, it is described separately,
For mode one：
First, it is expert at according to active operation book, list head, null is identified, and determines the line range of target data source；So
Afterwards, according to row span, combined with the line range of target data source, read the column data in the line range of target data source.
For example, an Excel tables of data includes two active operation books of Sheet1, Sheet2, tables of data row scope A-F.
Target data ranges are that active operation book is Sheet1, and behavior the first row where list head, null is designated the 6th row, row value
Scope B-E, active operation book of this method according to residing for target data ranges, list head are expert at, null mark determines extraction
Data line range is the second row to the 6th row in Sheet1；It is expert on scope, determines that extracting B arranges E row according to row value
Target data, i.e. in Sheet1 between the second row and the 6th row, B row and E row between data.
For mode two：
First, active operation book, list head the initial row and termination row being expert at, set are received, target data source is determined
Line range；Then, row span is received, is combined with the line range of target data source, read the line range of target data source
Interior column data.
For example, an Excel tables of data includes two active operation books of Sheet1, Sheet2, tables of data row scope A-F.
Target data ranges are that active operation book is Sheet1, and behavior the first row where list head, the initial behavior fourth line of setting is whole
Only behavior fifth line, row span B-E, where active operation book, list head of this method according to residing for target data ranges
Row, the initial row that set and termination row determine extraction data line range as Sheet1 in fourth line to fifth line；In line range base
On plinth, the target data that B row are arranged to E is extracted according to the determination of row value, i.e. in Sheet1 between fourth line and fifth line, B is arranged and E
Data between row.
In one embodiment of the invention, after step 101, according to the modification instruction for receiving, to the data
Any one of source data list head included in mapping table is imported to be modified with the corresponding relation of receiving terminal list head；
For example, original corresponding relation is A → B, former corresponding relation is changed to A → C after performing modification instruction.
Any one included or many in mapping table can also be imported to the data according to the deletion instruction for receiving
Individual source data list head is deleted with the corresponding relation of receiving terminal list head；
For example, legacy data imports mapping table includes corresponding relation for A → B, according to the deletion instruction for receiving, by original
There are data to import corresponding relation A → B that mapping table includes to delete.
Can also according to the addition instruction for receiving, in the data import mapping table newly-built source data list head with connect
The corresponding relation of receiving end list head.
For example legacy data is imported only includes corresponding relation A → B in mapping table, according to the addition instruction for receiving, in original
There are data to import and corresponding relation C → D is added in mapping table, perform after addition instruction, data import mapping table includes correspondence
Relation becomes A → B and C → D.
According to the modification instruction for receiving, instruction and addition instruction are deleted, source data in mapping table can be imported to data
List head is updated with the corresponding relation of receiving terminal list head, so that data import corresponding relation included in mapping table more
Plus it is comprehensive and accurate, the adaptability of the data lead-in method is further increased, and guarantee is carried out by the data lead-in method
The accuracy that data are imported.
Below by taking the target data imported in source data from Excel tables of data as an example, to provided in an embodiment of the present invention
Data lead-in method is described in further detail, as shown in Fig. 2 the method may comprise steps of：
Step 201, the demand according to receiving terminal determines target data range to import；
Demand according to receiving terminal determines that the active operation book of target data, list head are expert at, null is identified, row value
Scope, or determine initial row and termination row, column value model that the active operation book of target data, list head are expert at, set
Enclose.It is expert at by active operation book, list head below, null is identified, illustrate as a example by row span, such as target data
Scope is that active operation book is Sheet1, and behavior the first row where list head, null is designated the 6th row, row span B-D.
Step 202, sets up data and imports mapping table；
The list head of the source data in range to import is extracted, the list head with data receiver is bound, example
List head such as target data B-D is followed successively by " fragment number ", " batch ", " cutting ", in the list of data receiver, looks for respectively
To " fragment number ", " batch ", " cutting " list head, three Groups List heads are set up mapping relations successively.
Step 203, sets up import plan, and to import plan name, numbering；
Target data ranges, step 202 data according to step 201 import mapping table, import plan are set up, according to business
Scene is named scheme, numbering, for example the scenario name production ship type segmentation duration, and corresponding numbering is SCCXFDGQ.
Step 204, target data is imported according to the import plan set up；
Step 205, calls import plan；
When importing data again, import plan is called by being input into import plan title, numbering.
Step 206, changes import plan；
According to actual needs, the range to import of target data is changed, such as the range to import of target data is in former scheme
Active operation book is Sheet1, and behavior the first row where list head, null is designated the 6th row, row span B-D.New departure
The range to import of middle target data is that active operation book is Sheet2, and behavior the first row where list head, null is designated the 5th
OK, row span E-G.Can be directly in the scheme for recalling by range to import parameter modification the leading into new departure of original scheme
Enter range parameter.According to actual needs, can also data be imported with source data list head and receiving terminal list head in mapping table
The operation that corresponding relation is modified, deletes and added, for example, having " fragment number ", existing scheme in original scheme in mapping table
Do not have in mapping table, deletion map operation can be carried out；As not having " fragment number " in original scheme mapping table, existing scheme mapping
Have in table, can carry out solving newly-built map operation；As existing scheme is want to modify the mapping relations of " fragment number ", Ke Yijin
Row modification map operation.
Step 207, according to the data that amended scheme is imported under target data list head.
As shown in figure 3, one embodiment of the invention provides a kind of data importing device, as on a logical meaning
Device, is during corresponding computer program instructions in nonvolatile memory are read into internal memory by the CPU of equipment where it
What operation was formed.A kind of data importing device that the present embodiment is provided, including：Creating unit 301, processing unit 302, acquisition are single
Unit 303, import unit 304；
The creating unit 301, for create data import mapping table, including at least one source data list head with
The corresponding relation of receiving terminal list head；
The processing unit 302, for determining at least one intended recipient end list head included by data receiver；And
The data created according to the creating unit 301 import mapping table, determine each corresponding target of intended recipient end list
Source data list head；
The acquiring unit 303, for obtaining source data table to be imported；
The import unit 304, for each the target source data list head determined according to the processing unit 302
In, the data under target source data list head are extracted in the source data table got from the acquiring unit 303, and will extract
Data imported under corresponding with target source data list intended recipient end list head in data receiver.
In an embodiment of the invention, when the source data table that the acquiring unit 303 gets is Excel tables of data
When, the import unit 304 includes：First extraction unit；
First extraction unit, for the active operation book in Excel tables of data, target source data list head, in work
Gauge outfit line number where target source data list head is determined in dynamic book, is located in extraction target source data list head column
Data between the gauge outfit line number and null mark.
In an embodiment of the invention, when the source data table that the acquiring unit 303 gets is Excel tables of data
When, the import unit 304 includes：Second extraction unit；
Second extraction unit, for the active operation book in Excel tables of data, target source data list head is extracted
The data preassigned between initial row and predesignated termination row are located in target source data list head column.
In an embodiment of the invention, the processing unit 302, is further used for according to the modification instruction for receiving,
Any one of source data list head imported in mapping table to data is modified with the corresponding relation of receiving terminal list head；
Can also be further used for according to the deletion instruction for receiving, any one of source data row that data are imported in mapping table
Gauge outfit is deleted with the corresponding relation of receiving terminal list head；Can also be further used for according to the addition instruction for receiving,
Data import the corresponding relation of newly-built source data list head and receiving terminal list in mapping table.
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.
Shown in Fig. 4, a kind of data import system is the embodiment of the invention provides, including：Provided in an embodiment of the present invention
Anticipate a kind of data importing device 401 and data receiver 402；
The data receiver 402, the data for receiving the importing of data importing device 401.
One embodiment of the invention additionally provides a kind of computer-readable recording medium, including execute instruction, when the treatment of storage control
When device performs the execute instruction, the method that the storage control performs the data importing that the various embodiments described above are provided.
One embodiment of the invention additionally provides a kind of storage control, including：Processor, memory and bus；
The memory is used to store execute instruction, and the processor is connected with the memory by the bus, when
When the storage control runs, the execute instruction of memory storage described in the computing device, so that the storage
The method that controller performs the data importing that the various embodiments described above are provided.
Each embodiment of the invention at least has the advantages that：
1st, in data lead-in method provided in an embodiment of the present invention, apparatus and system, determine at least from data receiver
After one intended recipient end gauge outfit, import mapping table according to the data for creating and determine that each intended recipient end gauge outfit is corresponding
Target source data list head, extracts the data under target source data list head from source data table, and the data that will be extracted are led
Enter in data receiver under the list head in intended recipient end corresponding with target source data list.Therefore the present invention can be with root
Determine different intended recipient end list heads according to demand, importing mapping table by data determines corresponding target source data list
The data needed for source data table are imported into data receiver after head, and then demand can be imported according to data and flexibly changed
The data of importing, meet different data and import demand, thus with stronger applicability.
2nd, it is Excel data in source data table in data lead-in method provided in an embodiment of the present invention, apparatus and system
During table, it is expert at according to active operation book, list head, null is identified, row span determines the data extracted, or according to work
Initial row and termination row that dynamic book, list head are expert at, set, row span determine the data extracted, there is provided above-mentioned
Two kinds of data extracting modes, to meet the demand of different user, so as to further increase the applicability of the data lead-in method.
3rd, in data lead-in method provided in an embodiment of the present invention, apparatus and system, modification instruction, the deletion for receiving
After instruction, addition instruction, the source data list head imported in mapping table to data is carried out with the corresponding relation of receiving terminal list head
Corresponding operation.By changing the corresponding relation of data list head and receiving terminal list head, and then it is actual to meet import plan
Demand, solves the problems, such as to need to write introduction method again, further increases the applicability of introduction method.
4th, in data lead-in method provided in an embodiment of the present invention, apparatus and system, can be with by data importing device
Self-defined introduction method according to actual needs, and customized introduction method is named, is numbered；Title according to scheme,
Numbering gatherer can transfer already present introduction method, improve the durability of existing introduction method, further increase
The applicability of introduction method.
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 these entities or exist between operating
Any this actual relation or order.And, term " including ", "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 key elements not only include those key elements,
But also other key elements including being not expressly set out, or also include by this process, method, article or equipment are solid
Some key elements.In the absence of more restrictions, the key element limited by sentence " including a 〃 ", does not arrange
Except also there is other identical factor in the process including the key element, method, article or equipment.
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 the storage medium of embodied on computer readable, the program
Upon execution, the step of including above method embodiment is performed；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, skill of the invention is merely to illustrate
Art scheme, is not intended to limit the scope of the present invention.All any modifications made within the spirit and principles in the present invention,
Equivalent, improvement etc., are all contained in protection scope of the present invention.
Claims (10)
1. a kind of data lead-in method, it is characterised in that create data and import mapping table, wherein the data import mapping table bag
At least one source data list head and the corresponding relation of receiving terminal list head are included, is also included：
Obtain source data table to be imported；
Determine at least one intended recipient end list head included by data receiver；
Mapping table is imported according to the data, the corresponding target source data list of each intended recipient end list is determined
Head；
Each described target source data list head is directed to, the target source data list head is extracted from the source data table
Under data, and the data that will be extracted imported into it is corresponding with the target source data list in the data receiver
Under intended recipient end list head.
2. method according to claim 1, it is characterised in that
The source data table includes：Excel tables of data.
3. method according to claim 2, it is characterised in that
It is described to be directed to each described target source data list head, the target source data row are extracted from the source data table
Data under gauge outfit, including：
Determine the active operation book in the Excel tables of data；
Each described target source data list head is directed to, the target source data list is determined in the active operation book
Gauge outfit line number where head, is located at the gauge outfit line number and identifies it with null in the extraction target source data list head column
Between data.
4. method according to claim 2, it is characterised in that
It is described to be directed to each described target source data list head, the target source data row are extracted from the source data table
Data under gauge outfit, including：
Determine the active operation book in the Excel tables of data；
Each described target source data list head is directed to, is located in the extraction target source data list head column advance
Specify the data between initial row and predesignated termination row.
5. according to any described method in Claims 1-4, it is characterised in that
After the establishment data import mapping table, further include：
According to the modification instruction for receiving, any one of source data list included in mapping table is imported to the data
Head is modified with the corresponding relation of receiving terminal list head；
And/or,
According to the deletion instruction for receiving, any one of source data list included in mapping table is imported to the data
Head is deleted with the corresponding relation of receiving terminal list head；
And/or,
According to the addition instruction for receiving, newly-built source data list head and receiving terminal list head in the data import mapping table
Corresponding relation.
6. a kind of data importing device, it is characterised in that including：Creating unit, acquiring unit, processing unit, import unit；
The creating unit, mapping table is imported for creating data, wherein the data import mapping table includes at least one source
The corresponding relation of data list head and receiving terminal list；
The acquiring unit, for obtaining source data table to be imported；
The processing unit, for determining at least one intended recipient end list head included by data receiver；And according to institute
The data for stating creating unit establishment import mapping table, determine each corresponding target source of intended recipient end list
Data list head；
The import unit, for being directed to each described target source data list head that the processing unit is determined, from
The data under the target source data list head are extracted in the source data table that the acquiring unit gets, and will be extracted
Data imported under corresponding with the target source data list intended recipient end list head in the data receiver.
7. device according to claim 6, it is characterised in that when the source data table includes Excel tables of data,
The import unit includes：First extracts subelement；
The extraction subelement, for determining the active operation book in the Excel tables of data；And be directed to described in each
Target source data list head, the gauge outfit line number where the target source data list head is determined in the active operation book, carries
Take the data being located between the gauge outfit line number and null mark in the target source data list head column.
8. device according to claim 6, it is characterised in that when the source data table includes Excel tables of data,
The import unit includes：Second extracts subelement；
Described second extracts subelement, for determining the active operation book in the Excel tables of data；And it is directed to each
The target source data list head, extract be located in target source data list head column preassign initial row with it is advance
Specify the data between termination row.
9. according to any described device in claim 6 to 8, it is characterised in that
The processing unit, is further used for, according to the modification instruction for receiving, importing the data included in mapping table
Any one of source data list head modified with the corresponding relation of receiving terminal list；
And/or,
The processing unit, is further used for, according to the deletion instruction for receiving, importing the data included in mapping table
Any one of source data list head deleted with the corresponding relation of receiving terminal list
And/or,
The processing unit, is further used for according to the addition instruction for receiving, the newly-built source in the data import mapping table
The corresponding relation of data list head and receiving terminal list.
10. a kind of data import system, it is characterised in that including：It is any described in data receiver and claim 6 to 9
Data importing device；
The data receiver, for receiving the data that the data importing device is imported.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710110347.5A CN106897434A (en) | 2017-02-27 | 2017-02-27 | A kind of data lead-in method, apparatus and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710110347.5A CN106897434A (en) | 2017-02-27 | 2017-02-27 | A kind of data lead-in method, apparatus and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106897434A true CN106897434A (en) | 2017-06-27 |
Family
ID=59184904
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710110347.5A Pending CN106897434A (en) | 2017-02-27 | 2017-02-27 | A kind of data lead-in method, apparatus and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106897434A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107818161A (en) * | 2017-10-30 | 2018-03-20 | 山东浪潮通软信息科技有限公司 | A kind of data capture method and device |
| CN109656985A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Data lead-in method, system, terminal and storage medium |
| CN112749216A (en) * | 2019-10-30 | 2021-05-04 | 北京国双科技有限公司 | Rule analysis-based data import method, device and equipment |
| CN112749216B (en) * | 2019-10-30 | 2024-07-26 | 北京国双科技有限公司 | Data importing method, device and equipment based on rule analysis |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7113936B1 (en) * | 2001-12-06 | 2006-09-26 | Emc Corporation | Optimizer improved statistics collection |
| CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
| CN104021123A (en) * | 2013-02-28 | 2014-09-03 | 国际商业机器公司 | Method and system for data transfer |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
| CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and device |
| CN105373630A (en) * | 2015-12-18 | 2016-03-02 | 河南思维自动化设备股份有限公司 | Automatic identification and creation method for LKJ basic data filling table |
-
2017
- 2017-02-27 CN CN201710110347.5A patent/CN106897434A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7113936B1 (en) * | 2001-12-06 | 2006-09-26 | Emc Corporation | Optimizer improved statistics collection |
| CN104021123A (en) * | 2013-02-28 | 2014-09-03 | 国际商业机器公司 | Method and system for data transfer |
| CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
| CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and device |
| CN105373630A (en) * | 2015-12-18 | 2016-03-02 | 河南思维自动化设备股份有限公司 | Automatic identification and creation method for LKJ basic data filling table |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107818161A (en) * | 2017-10-30 | 2018-03-20 | 山东浪潮通软信息科技有限公司 | A kind of data capture method and device |
| CN109656985A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Data lead-in method, system, terminal and storage medium |
| CN112749216A (en) * | 2019-10-30 | 2021-05-04 | 北京国双科技有限公司 | Rule analysis-based data import method, device and equipment |
| CN112749216B (en) * | 2019-10-30 | 2024-07-26 | 北京国双科技有限公司 | Data importing method, device and equipment based on rule analysis |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105094707B (en) | A kind of data storage, read method and device | |
| CN104182484B (en) | A kind of method and apparatus for realizing HBase data and the mapping of Java field object | |
| CN106484785B (en) | A kind of method of efficient Automatic Adaptation Data field mapping | |
| CN102279749A (en) | Method and equipment for merging codes | |
| CN110866024B (en) | Vector database increment updating method and system | |
| CN104021123A (en) | Method and system for data transfer | |
| CN106528821A (en) | Method for importing change column data into database | |
| CN109857803A (en) | Method of data synchronization, device, equipment, system and computer readable storage medium | |
| CN108536745A (en) | Tables of data extracting method, terminal, equipment and storage medium based on Shell | |
| CN106484892A (en) | Data manipulation method and device | |
| CN108089821A (en) | A kind of method of micro controller data storage management | |
| CN111249736A (en) | Code processing method and device | |
| CN105488471B (en) | A kind of font recognition methods and device | |
| CN109597979A (en) | Inventory table generation method, device, computer equipment and storage medium | |
| CN106897434A (en) | A kind of data lead-in method, apparatus and system | |
| CN117238433A (en) | Method for automatically isolating document data based on Libreoffice | |
| CN104408128B (en) | A kind of reading optimization method indexed based on B+ trees asynchronous refresh | |
| CN105512096B (en) | A kind of optimization method and device based on font embedded in document | |
| CN107766519B (en) | Method for visually configuring data structure | |
| JP6377743B2 (en) | Method and apparatus for building an intermediate character library | |
| CN104636471A (en) | Procedure code finding method and device | |
| CN109902085B (en) | Configuration storage structure optimization method and system | |
| CN107133391A (en) | The generation method and system of construction drawing | |
| CN113001538B (en) | Command analysis method and system | |
| CN104516971A (en) | Method for combining background pictures in CSS style file |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170627 |
|
| RJ01 | Rejection of invention patent application after publication |