CN106503222A - Batch based on Excel imports the method and device of management data base - Google Patents
Batch based on Excel imports the method and device of management data base Download PDFInfo
- Publication number
- CN106503222A CN106503222A CN201610962871.0A CN201610962871A CN106503222A CN 106503222 A CN106503222 A CN 106503222A CN 201610962871 A CN201610962871 A CN 201610962871A CN 106503222 A CN106503222 A CN 106503222A
- Authority
- CN
- China
- Prior art keywords
- data
- configuration item
- excel
- imports
- importing
- 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/22—Indexing; Data structures therefor; Storage structures
-
- 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)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of batch based on Excel imports the method and device of management data base, the method comprising the steps of：Data in original Excel forms per string are corresponded with configuration item attribute and sets up mapping relations, the data for mapping are completed so as to obtain；Data by the data for completing to map according to allocation models rule to having stored carry out verification computing, import the data for meeting allocation models rule；Process and there is between the configuration item of incidence relation the sequencing of data inputting and carry out data mediation；The mabage report for importing work is generated, the mabage report includes：Always import record number, import successfully record number, importing failure record number, importing failure cause and data point reuse suggestion.The present invention can be based on the free template batches of Excel and import configuration management data base, support that user is freely disposably imported using Excel template, the multiple configuration items of support.
Description
Technical field
The present invention relates to a kind of batch imports the method and device of management data base, more particularly to a kind of based on Excel's
Batch imports the method and device of management data base.
Background technology
With the IT architecture of enterprise increasingly huge, to IT environment in all entity elements management increasingly important.Match somebody with somebody
Put management data base (Configuration Management database, abbreviation CMDB) configuration management data base and refer to this
A kind of data base of sample, all relevant informations of the component of information system that its IT service comprising a tissue is used and these
Relation between component.Configuration management data base provides and a kind of grinds to the structured walkthrough of data and from any angle that wants
The method for studying carefully data.The component of the information system being mentioned above also referred to as configuration item (configuration items,
CI), configuration item can be any it is contemplated that IT components, including software, hardware, file and personnel, and they it
Between coalition.The process of configuration management tries hard to describe, control and follow the trail of configuration project in detail and configuration item purpose is all complete
Faceization and systematized change.In CMDB, each configuration item has its privately owned attribute, publicly-owned attribute and and other configurations
The reference attribute existed because of incidence relation between.
Due to the importance of CMDB, the collection and typing of its data are then one of its key-point management.Data main at present
Collect and typing mode is that typing, the filling of automatic discovery procedure and batch are imported one by one by Configuration Management Officer.Wherein, batch is imported
Mode be best able to combine with existing way to manage in enterprise (managing IT related datas using Excel electrical forms),
Carry out the transition of the smooth management from labor management to software system.
CMDB manufacturers in the market all come with the function that the batch based on Excel imports data, but need to use
Specified template allows to provide self-defined template but need to carry out function step by step, and needs the Configuration Management Officer that specifies to carry out
Operation.
Current technology scheme is primarily present problems with：
1st, the function of importing configuration management database data based on Excel batches needs to specify template, with the existing pipe of enterprise
There is conflict in the Excel data in reason, be unfavorable for being transitioned into software system management from labor management.
2nd, the function of importing configuration management data base based on Excel batches allows the self-defined importing template of Configuration Management Officer,
However it is necessary that multiple step operations are realized, operating procedure is more, loaded down with trivial details, and easily malfunctions.
Content of the invention
The technical problem to be solved is to provide a kind of method that batch based on Excel imports management data base
And device, without the need for the key importing that complex configurations can complete Excel, greatly save the time and reliability is high.
The technical scheme that the present invention is adopted for solving above-mentioned technical problem is to provide a kind of batch based on Excel and imports
The method of management data base, comprises the steps：By one a pair of data and configuration item attribute in original Excel forms per string
Mapping relations should be set up, and the data for mapping are completed so as to obtain；Will be right according to allocation models rule for the data for completing to map
The data for having stored carry out verification computing, import the data for meeting allocation models rule；Process the configuration item that there is incidence relation
Between data inputting sequencing and carry out data mediation.
The method that the above-mentioned batch based on Excel imports management data base, wherein, also includes step：Generate and import work
The mabage report of work, the mabage report include：Total importing records number, imports successfully record number, importing failure record number, importing
Failure cause and data point reuse suggestion.
The method that the above-mentioned batch based on Excel imports management data base, wherein, the allocation models rule setting is such as
Under：Generate for describing the attribute list of each configuration item, and the data type of each attribute, data constraint rule are set
And the incidence relation with other configurations item；Judge whether the data for importing a certain configuration item meet allocation models rule and refer to this
Whether the mapping of data is whether a property value in the configuration item, the data meet the data type and data constraint rule
Then and if data mapping be an incidence relation attribute, then need to further determine whether exist using the category
Property association.
The method that the above-mentioned batch based on Excel imports management data base, wherein, closes when a certain configuration item has association
During the configuration item of system, the sequencing of the data inputting is as follows：Before importing the configuration item data, need first to import what which associated
Configuration item data, then imports the configuration item, again to reach the integrity of data；The harmonic process of the data is as follows：When entering
When row data are imported, the configuration item is associated with the case that relation configuration item all imports data, then according to default priority,
The high data of priority are taken as actual data, and priority low then as reconciled data；The actual data is the configuration
Item can externally provide the instance data of consumption, and the reconciled data can be used for people then as the reference data inside configuration item
Work is adjusted, and replaces existing actual data.
The method that the above-mentioned batch based on Excel imports management data base, wherein, the batch based on Excel is led
Enter and completed by WEB guidings, graphic interface.
The present invention also provides the dress that a kind of batch based on Excel imports management data base for solving above-mentioned technical problem
Putting, module being assembled including mapping relations, which is suitable to one a pair of data and configuration item attribute in original Excel forms per string
Mapping relations should be set up, and the data for mapping are completed so as to obtain；Data check module, its are suitable to the data for completing and mapping
The data for having stored are carried out with verification computing according to allocation models rule, the data for meeting allocation models rule are imported；Parsing mould
Block, its are suitable to process between the configuration item that there is incidence relation the sequencing of data inputting and carry out data mediation.
The above-mentioned batch based on Excel imports the device of management data base, wherein, also includes：Report generation module, its
It is suitable to generate the mabage report for importing work, the mabage report includes：Total importing records number, imports successfully record number, importing
Failure record number, importing failure cause and data point reuse suggestion.
The above-mentioned batch based on Excel imports the device of management data base, and wherein, the allocation models rule setting is such as
Under：Generate for describing the attribute list of each configuration item, and the data type of each attribute, data constraint rule are set
And the incidence relation with other configurations item；Judge whether the data for importing a certain configuration item meet allocation models rule and refer to this
Whether the mapping of data is whether a property value in the configuration item, the data meet the data type and data constraint rule
Then and if data mapping be an incidence relation attribute, then need to further determine whether exist using the category
Property association.
The above-mentioned batch based on Excel imports the device of management data base, wherein, closes when a certain configuration item has association
During the configuration item of system, the sequencing of the data inputting is as follows：Before importing the configuration item data, need first to import what which associated
Configuration item data, then imports the configuration item, again to reach the integrity of data；The harmonic process of the data is as follows：When entering
When row data are imported, the configuration item is associated with the case that relation configuration item all imports data, then according to default priority,
The high data of priority are taken as actual data, and priority low then as reconciled data；The actual data is the configuration
Item can externally provide the instance data of consumption, and the reconciled data can be used for people then as the reference data inside configuration item
Work is adjusted, and replaces existing actual data.
The above-mentioned batch based on Excel imports the device of management data base, and wherein, the batch based on Excel is led
Enter and completed by WEB guidings, graphic interface.
Present invention contrast prior art has following beneficial effect：The batch ingress pipe based on Excel that the present invention is provided
The method and device of reason data base, mapping relations of the original Excel forms with configuration item attribute are completed by each configuration item
Being managed, the data for mapping being completed so as to obtain, the key that can complete Excel without the need for complex configurations is imported；Will be described complete
Data into mapping carry out verification computing with allocation models rule and the data for having stored so that only meet allocation models rule
Data could import, shield all complexity configuration item datas verifications and the pass between preservation, configuration item and configuration item
System process with reconcile, it is only necessary to finish relation map, you can realize a key import, time-consuming.
Description of the drawings
Fig. 1 is the flow chart of the method that the batch based on Excel in the embodiment of the present invention imports management data base；
Fig. 2 is the module map of the device that the batch based on Excel in the embodiment of the present invention imports management data base；
Fig. 3 is to set up data mapping relations schematic diagram by graphic interface in the embodiment of the present invention；
Fig. 4 is the alteration schematic diagram that preview will import data in the embodiment of the present invention；
Fig. 5 is importing failure reporting file display schematic diagram in the embodiment of the present invention.
Specific embodiment
In the embodiment of the present invention, original Excel forms are completed to configure by each with the mapping relations of configuration item attribute
Item is managed, and completes the data for mapping so as to obtain, and the key that can complete Excel without the need for complex configurations is imported.
Further, the data for completing to map are carried out verification fortune with allocation models rule and the data for having stored
Calculate so that only meet allocation models rule data could import, shield all complexity configuration item datas verifications with
Preserve, the Automated generalization between configuration item and configuration item and mediation, it is only necessary to finish relation maps, you can realize a key import,
Time-consuming.
Understandable for enabling above-mentioned purpose, feature and the beneficial effect of the present invention to become apparent from, below in conjunction with the accompanying drawings to this
The specific embodiment of invention is described in detail.
Fig. 1 is the flow chart of the method that the batch based on Excel in the embodiment of the present invention imports management data base.
As shown in figure 1, the data in original Excel forms per string are corresponded by step 101 with configuration item attribute building
Vertical mapping relations, complete the data for mapping so as to obtain；Step 102 is by the data for completing to map according to allocation models rule
The data for having stored are carried out with verification computing, the data for meeting allocation models rule are imported；There is incidence relation in step 103 process
Configuration item between data inputting sequencing and carry out data mediation；Step 104 generates the mabage report for importing work.
Wherein described mabage report includes：Total importing records number, imports successfully record number, importing failure record number, importing
Failure cause and data point reuse suggestion.
In a specific embodiment, the allocation models rule includes：For describe each configuration item attribute list,
The data type of each attribute and data constraint rule (such as whether major key, whether can empty, whether editable etc.) and and its
The list of the incidence relation of his configuration item.Therefore, judge whether the data for importing a certain configuration item meet allocation models rule and be
Whether the mapping for referring to the data is whether a property value in the configuration item, the data meet the data type and data constraint
Rule and if data mapping be an incidence relation attribute, then need to further determine whether to exist using should
This incidence relation of Attribute Association.
In a specific embodiment, the sequencing of the data inputting includes：When a certain configuration item has incidence relation
Configuration item when, before importing the configuration item data, need first to import its configuration item data for associating, then import the configuration again
, to reach the integrity of data.It is a kind of process rule of configuration item incidence relation data that the data reconcile, i.e., according to reality
Border business demand, for the incidence relation configuration item of some configuration item, for the configuration item, its between any two excellent
First level height.When carrying out data and importing, the configuration item is associated with the case that relation configuration item all imports data, then basis
Default priority, takes the high data of priority as actual data, and priority low then as reconciled data.Actual data
The instance data that the configuration item can externally provide consumption is, and reconciled data is then as the reference data inside configuration item,
Can be used to manually adjust, replace existing actual data.
In being embodied as, the batch based on Excel is directed through WEB guidings, graphic interface and completes.
In the embodiment of the present invention, original Excel forms are completed to configure by each with the mapping relations of configuration item attribute
Item is managed, and completes the data for mapping so as to obtain, and the key that can complete Excel without the need for complex configurations is imported.
Further, the data for completing to map are carried out verification fortune with allocation models rule and the data for having stored
Calculate so that only meet allocation models rule data could import, shield all complexity configuration item datas verifications with
Preserve, the Automated generalization between configuration item and configuration item and mediation, it is only necessary to finish relation maps, you can realize a key import,
Time-consuming.
Fig. 2 is the module map of the device that the batch based on Excel in the embodiment of the present invention imports management data base.
As shown in Fig. 2 a kind of batch based on Excel imports the device of management data base, including：Mapping relations group is die-filling
Block 201, which is suitable to correspond the data in original Excel forms per string with configuration item attribute sets up mapping relations, from
And obtain the data for completing to map；Data check module 202, its are suitable to advise the data for completing to map according to allocation models
Then the data to having stored carry out verification computing, import the data for meeting allocation models rule；Parsing module 203, its are suitable to locate
There is between the configuration item of incidence relation the sequencing of data inputting and carry out data mediation in reason；Report generation module 204, its
It is suitable to generate the mabage report for importing work.
Wherein, the mabage report includes：Total importing records number, imports successfully record number, importing failure record number, importing
Failure cause and data point reuse suggestion.
In being embodied as, the allocation models is regular, the problem of the data inputting priority and data reconciliation process
Ibid, this is no longer going to repeat them for process.
In being embodied as, the batch based on Excel is directed through WEB guidings, graphic interface and completes.
In the embodiment of the present invention, original Excel forms are completed to configure by each with the mapping relations of configuration item attribute
Item is managed, and completes the data for mapping so as to obtain, and the key that can complete Excel without the need for complex configurations is imported.
Further, the data for completing to map are carried out verification fortune with allocation models rule and the data for having stored
Calculate so that only meet allocation models rule data could import, shield all complexity configuration item datas verifications with
Preserve, the Automated generalization between configuration item and configuration item and mediation, it is only necessary to finish relation maps, you can realize a key import,
Time-consuming.
Fig. 3 is to set up data mapping relations schematic diagram by graphic interface in the embodiment of the present invention；Fig. 4 is of the invention real
Apply the alteration schematic diagram that preview in example will import data；Fig. 5 is to import failure reporting file to show in the embodiment of the present invention
Show schematic diagram.
The embodiment of the present invention is described further with reference to Fig. 3 to Fig. 5.As shown in figure 3, by the data in Excel
Mapping relations foundation is carried out with configuration item attribute, by graphic interface, is intuitively operated.As shown in figure 4, click on opening
After beginning to import, the alteration that preview will import data can be carried out.As shown in Figure 4, in embodiments of the present invention, data are total
Bar number is 113, wherein increases data strip number 3 newly, without data strip number 0 is changed, has change data strip number 110.Such as Fig. 5 institutes
Show, after completing to import, obtain batch and import mabage report, if there is failure record is imported, then provide file download.Import and lose
Losing the reason for show in report file failure.As shown in Figure 5, in embodiments of the present invention, the total line number 113 of data is imported altogether
OK, 109 row of successful line number, failure 4 row of line number, can click on failed download row data carries out checking importing failure cause.
In embodiments of the present invention, compared to the prior art, with advantages below：
1. importing configuration management database data based on the free template batches of Excel supports user freely using Excel moulds
Plate, the multiple configuration items of support are disposably imported.
2. batch processing device is shielded between verification and preservation, configuration item and the configuration item of the configuration item data of all complexity
Automated generalization and mediation, user only need finish relation map, you can realize a key import, time-consuming.
3. the full self-help operation of user can achieve, and without the need for specific personnel (such as Configuration Management Officer), it is special that batch imports processor
Mabage report that have, detailed, can directly instruct user to complete the adjustment of data and import again.
One of ordinary skill in the art will appreciate that all or part of step in the various methods of above-described embodiment is can
Completed with instructing the hardware of correlation by program, the program can be stored in computer-readable recording medium, storage is situated between
Matter can include：ROM, RAM, disk or CD etc..
Although the present invention is disclosed as above with preferred embodiment, so which is not limited to the present invention, any this area skill
Art personnel, without departing from the spirit and scope of the present invention, when a little modification and perfect can be made, therefore protection model of the invention
Enclose when by being defined that claims are defined.
Claims (10)
1. a kind of method that batch based on Excel imports management data base, it is characterised in that comprise the following steps：
Data in original Excel forms per string are corresponded with configuration item attribute and sets up mapping relations, so as to obtain
Data into mapping；
Data by the data for completing to map according to allocation models rule to having stored carry out verification computing, import to meet and match somebody with somebody
Put the data of model rule；
Process and there is between the configuration item of incidence relation the sequencing of data inputting and carry out data mediation.
2. the method that the batch based on Excel according to claim 1 imports management data base, it is characterised in that also wrap
Include step：
The mabage report for importing work is generated, the mabage report includes：Total importing records number, imports successfully record number, importing
Failure record number, importing failure cause and data point reuse suggestion.
3. the method that the batch based on Excel according to claim 1 imports management data base, it is characterised in that described
Allocation models rule setting is as follows：Generate for describing the attribute list of each configuration item, and the number of each attribute is set
Incidence relation according to type, data constraint rule and with other configurations item；Judge whether the data for importing a certain configuration item accord with
Close allocation models rule and refer to whether the mapping of the data is whether a property value in the configuration item, the data meet the number
According to type and data constraint rule and if data mapping be an incidence relation attribute, then need further to sentence
Disconnected whether there is uses the Attribute Association.
4. the method that the batch based on Excel according to claim 1 imports management data base, it is characterised in that when certain
When one configuration item has the configuration item of incidence relation, the sequencing of the data inputting is as follows：Before importing the configuration item data,
Need first to import its configuration item data for associating, then import the configuration item again, to reach the integrity of data；The data
Harmonic process is as follows：When carrying out data and importing, the configuration item is associated with the case that relation configuration item all imports data, then
According to default priority, take the high data of priority as actual data, and priority low then as reconciled data；Described
Actual data is the instance data that the configuration item can externally provide consumption, and the reconciled data is then as the ginseng inside configuration item
Data are examined, can be used to manually adjust, replace existing actual data.
5. the method that the batch based on Excel according to claim 1 imports management data base, it is characterised in that described
WEB guidings, graphic interface are directed through based on the batch of Excel to complete.
6. a kind of batch based on Excel imports the device of management data base, it is characterised in that include：
Mapping relations assemble module, and which is suitable to correspond the data in original Excel forms per string with configuration item attribute
Mapping relations are set up, and the data for mapping are completed so as to obtain；
Data check module, which is suitable to the data for completing to map the data according to allocation models rule to having stored is carried out
Verification computing, imports the data for meeting allocation models rule；
Parsing module, its are suitable to process between the configuration item that there is incidence relation the sequencing of data inputting and carry out data tune
With.
7. the batch based on Excel according to claim 6 imports the device of management data base, it is characterised in that also wrap
Include：
Report generation module, its are suitable to generate the mabage report for importing work, and the mabage report includes：Total importing record number,
Import successfully record number, importing failure record number, importing failure cause and data point reuse suggestion.
8. the batch based on Excel according to claim 6 imports the device of management data base, it is characterised in that described
Allocation models rule setting is as follows：Generate for describing the attribute list of each configuration item, and the number of each attribute is set
Incidence relation according to type, data constraint rule and with other configurations item；Judge whether the data for importing a certain configuration item accord with
Close allocation models rule and refer to whether the mapping of the data is whether a property value in the configuration item, the data meet the number
According to type and data constraint rule and if data mapping be an incidence relation attribute, then need further to sentence
Disconnected whether there is uses the Attribute Association.
9. the batch based on Excel according to claim 6 imports the device of management data base, it is characterised in that when certain
When one configuration item has the configuration item of incidence relation, the sequencing of the data inputting is as follows：Before importing the configuration item data,
Need first to import its configuration item data for associating, then import the configuration item again, to reach the integrity of data；The data
Harmonic process is as follows：When carrying out data and importing, the configuration item is associated with the case that relation configuration item all imports data, then
According to default priority, take the high data of priority as actual data, and priority low then as reconciled data；Described
Actual data is the instance data that the configuration item can externally provide consumption, and the reconciled data is then as the ginseng inside configuration item
Data are examined, can be used to manually adjust, replace existing actual data.
10. the batch based on Excel according to claim 6 imports the device of management data base, it is characterised in that described
WEB guidings, graphic interface are directed through based on the batch of Excel to complete.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610962871.0A CN106503222A (en) | 2016-11-04 | 2016-11-04 | Batch based on Excel imports the method and device of management data base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610962871.0A CN106503222A (en) | 2016-11-04 | 2016-11-04 | Batch based on Excel imports the method and device of management data base |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106503222A true CN106503222A (en) | 2017-03-15 |
Family
ID=58322583
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610962871.0A Pending CN106503222A (en) | 2016-11-04 | 2016-11-04 | Batch based on Excel imports the method and device of management data base |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106503222A (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106930335A (en) * | 2017-03-18 | 2017-07-07 | 辽宁工程技术大学 | A kind of foundation bearing capacity determines checking method |
| CN107016096A (en) * | 2017-04-07 | 2017-08-04 | 北京六古广告传媒有限责任公司 | A kind of data import system and the data lead-in method based on the system |
| CN107247767A (en) * | 2017-06-05 | 2017-10-13 | 山东浪潮通软信息科技有限公司 | A kind of method and device that database is imported by formatted data files |
| CN107368593A (en) * | 2017-07-25 | 2017-11-21 | 万帮充电设备有限公司 | Data lead-in method, device and server |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN108628872A (en) * | 2017-03-17 | 2018-10-09 | 广州康昕瑞基因健康科技有限公司 | Genetic analysis database batch data introduction method and system |
| CN109120453A (en) * | 2018-08-31 | 2019-01-01 | 上海新炬网络信息技术股份有限公司 | A kind of overall situation shows the method for IT infrastructure data in CMDB |
| CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
| CN109408555A (en) * | 2018-09-19 | 2019-03-01 | 智器云南京信息科技有限公司 | Data type recognition methods and device, data storage method and device |
| CN111268993A (en) * | 2020-03-18 | 2020-06-12 | 江苏博厦矿山科技有限公司 | Fire prevention grouting material formula determination system |
| CN111950250A (en) * | 2020-08-17 | 2020-11-17 | 浪潮云信息技术股份公司 | Government affair service item combing method based on Excel template |
| CN112163024A (en) * | 2020-09-11 | 2021-01-01 | 重庆誉存大数据科技有限公司 | Configuration information exporting and importing method based on hierarchical association structure |
| CN114356864A (en) * | 2021-12-09 | 2022-04-15 | 浪潮云信息技术股份公司 | Method and system for importing excel files in batch in domestic environment |
| CN115357563A (en) * | 2022-10-18 | 2022-11-18 | 北京国铁华晨通信科技有限公司 | Data entry method and system for railway communication equipment and computer equipment |
| CN116029271A (en) * | 2023-02-01 | 2023-04-28 | 南京维拓科技股份有限公司 | Method for importing tree-type structure data in batches based on easy excel |
| CN116226255A (en) * | 2023-03-15 | 2023-06-06 | 中大体育产业集团股份有限公司 | Efficient batch importing method and system for body measurement data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN103309945A (en) * | 2013-05-15 | 2013-09-18 | 上海证券交易所 | Device for importing data to database |
| CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and device |
-
2016
- 2016-11-04 CN CN201610962871.0A patent/CN106503222A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN103309945A (en) * | 2013-05-15 | 2013-09-18 | 上海证券交易所 | Device for importing data to database |
| CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and device |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108628872A (en) * | 2017-03-17 | 2018-10-09 | 广州康昕瑞基因健康科技有限公司 | Genetic analysis database batch data introduction method and system |
| CN106930335B (en) * | 2017-03-18 | 2019-10-01 | 辽宁工程技术大学 | A kind of foundation bearing capacity determines checking method |
| CN106930335A (en) * | 2017-03-18 | 2017-07-07 | 辽宁工程技术大学 | A kind of foundation bearing capacity determines checking method |
| CN107016096A (en) * | 2017-04-07 | 2017-08-04 | 北京六古广告传媒有限责任公司 | A kind of data import system and the data lead-in method based on the system |
| CN107247767A (en) * | 2017-06-05 | 2017-10-13 | 山东浪潮通软信息科技有限公司 | A kind of method and device that database is imported by formatted data files |
| CN107247767B (en) * | 2017-06-05 | 2020-08-04 | 浪潮通用软件有限公司 | Method and device for importing formatted data file into database |
| CN107368593A (en) * | 2017-07-25 | 2017-11-21 | 万帮充电设备有限公司 | Data lead-in method, device and server |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN109120453A (en) * | 2018-08-31 | 2019-01-01 | 上海新炬网络信息技术股份有限公司 | A kind of overall situation shows the method for IT infrastructure data in CMDB |
| CN109120453B (en) * | 2018-08-31 | 2021-04-23 | 上海新炬网络信息技术股份有限公司 | Method for globally showing IT basic architecture data in CMDB |
| CN109408555A (en) * | 2018-09-19 | 2019-03-01 | 智器云南京信息科技有限公司 | Data type recognition methods and device, data storage method and device |
| CN109408555B (en) * | 2018-09-19 | 2022-11-11 | 智器云南京信息科技有限公司 | Data type identification method and device and data storage method and device |
| CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
| CN111268993A (en) * | 2020-03-18 | 2020-06-12 | 江苏博厦矿山科技有限公司 | Fire prevention grouting material formula determination system |
| CN111268993B (en) * | 2020-03-18 | 2021-10-15 | 江苏博厦矿山科技有限公司 | Fire prevention grouting material formula determination system |
| CN111950250A (en) * | 2020-08-17 | 2020-11-17 | 浪潮云信息技术股份公司 | Government affair service item combing method based on Excel template |
| CN112163024A (en) * | 2020-09-11 | 2021-01-01 | 重庆誉存大数据科技有限公司 | Configuration information exporting and importing method based on hierarchical association structure |
| CN112163024B (en) * | 2020-09-11 | 2024-03-19 | 重庆誉存大数据科技有限公司 | Configuration information export and import method based on hierarchical association structure |
| CN114356864A (en) * | 2021-12-09 | 2022-04-15 | 浪潮云信息技术股份公司 | Method and system for importing excel files in batch in domestic environment |
| CN115357563A (en) * | 2022-10-18 | 2022-11-18 | 北京国铁华晨通信科技有限公司 | Data entry method and system for railway communication equipment and computer equipment |
| CN116029271A (en) * | 2023-02-01 | 2023-04-28 | 南京维拓科技股份有限公司 | Method for importing tree-type structure data in batches based on easy excel |
| CN116226255A (en) * | 2023-03-15 | 2023-06-06 | 中大体育产业集团股份有限公司 | Efficient batch importing method and system for body measurement data |
| CN116226255B (en) * | 2023-03-15 | 2023-08-11 | 中大体育产业集团股份有限公司 | Efficient batch importing method and system for body measurement data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106503222A (en) | Batch based on Excel imports the method and device of management data base | |
| CN111061817B (en) | Adaptive business construction system, method and computer readable medium | |
| CN112668968B (en) | Warehouse management modeling method and system based on field drive design | |
| CN102436473B (en) | Menu management device and menu managing method | |
| CN112395325A (en) | Data management method, system, terminal equipment and storage medium | |
| CN112396404A (en) | Data center system | |
| CN107391653A (en) | A kind of distributed NewSQL Database Systems and image data storage method | |
| CN109635426A (en) | The modeling and model verification method of BIM project | |
| CN106484716A (en) | Organizational structure method of adjustment and system | |
| CN103606037A (en) | Query and configuration method of business data and device thereof | |
| CN106651092A (en) | Configurable data change flow monitoring method | |
| US20060047723A1 (en) | Custom database system and method of building the same | |
| CN110008104A (en) | A kind of management method of log information, system, equipment and storage medium | |
| CN111190814B (en) | Method and device for generating software test case, storage medium and terminal | |
| CN111666355A (en) | Model construction method and device for three-layer model of field, data and scene | |
| US20100011018A1 (en) | Custom database system and method of building the same | |
| US20240036890A1 (en) | System and method of a modular framework for configuration and reuse of web components | |
| US20120166406A1 (en) | Information Integrity Rules Framework | |
| CN116226092A (en) | Database updating method and device | |
| KR100922526B1 (en) | Method and system of managing data quality through provisioning of metadata in the execution of business process | |
| EP2742443A1 (en) | Database record repair | |
| CN111813880B (en) | Homeland space planning project management method, system and storage medium | |
| CN115730022A (en) | Data processing construction method and platform system adopting event triggering and process arrangement | |
| CN108920137A (en) | A kind of system of creation web project and code based on eclipse frame | |
| CN112256978B (en) | Data processing method, device and medium based on data model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 |
Application publication date: 20170315 |
|
| RJ01 | Rejection of invention patent application after publication |