CN100388676C - Method for auto-forming reporting forms of telecommunication equipment performance - Google Patents
Method for auto-forming reporting forms of telecommunication equipment performance Download PDFInfo
- Publication number
- CN100388676C CN100388676C CNB2004100660188A CN200410066018A CN100388676C CN 100388676 C CN100388676 C CN 100388676C CN B2004100660188 A CNB2004100660188 A CN B2004100660188A CN 200410066018 A CN200410066018 A CN 200410066018A CN 100388676 C CN100388676 C CN 100388676C
- Authority
- CN
- China
- Prior art keywords
- report
- data
- data collection
- excel
- node
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000013500 data storage Methods 0.000 claims abstract description 11
- 238000001914 filtration Methods 0.000 claims abstract description 3
- 238000013480 data collection Methods 0.000 claims description 29
- 238000000465 moulding Methods 0.000 abstract 3
- 238000007726 management method Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 239000006185 dispersion Substances 0.000 description 1
- 230000009977 dual effect Effects 0.000 description 1
- 238000005429 filling process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a performance report automatic generation method of telecommunication devices, which comprises: collecting report metadata from each data source; filtering the collected report metadata according to specified requirements to generate a report data set; adjusting the report data set according to a specified format of the report; parsing the data set of the report and filling the data. By the method of the present invention, an Excel molding board given by the user is directly read, the outputted report extremely maintains in the same format with the molding board, and optional changes of the Excel molding board without the change of report system codes are supported. The report automatic generation method presented by the present invention also supports various methods of data storage.
Description
Technical field
The present invention relates to the automatic generation technique of the telecommunication apparatus performance report in telecommunicatioin network management field, the Excel form that is specifically related to be used for telecommunication administration generates method automatically.
Background technology
At present, the report capability in the telecom network management system receives much concern, because information such as the performance index of whole Telecommunication network equipment, the detailed situation of operation all need to obtain from reporting system, report capability is one of the most used function of network management system attendant.Therefore ease for operation, flexibility and the extensibility of reporting system to the user, all are crucial.
The realization of current form has a variety of methods, but also do not have a kind of method, can remove the process of statement form customization from and directly reads in the given Excel file of user (.xls file).
Summary of the invention
The present invention is directed to problems of the prior art, propose a kind of form and generate method automatically, can remove the cumbersome procedure of custom formats masterplate from, can also support the several data storage mode.
The method that the present invention proposes mainly may further comprise the steps:
(1) from each data source, gathers the form metadata; If data storage method is a distributed way, directly traces back on the bottom node and obtain; If data storage method is a centralized fashion, directly obtain at node at the corresponding levels; If data storage method is distributed and centralized and deposit, then obtaining according to data templates different in each node of form metadata carried out according to aforementioned manner respectively;
(2), generate required report data collection according to the form metadata in the specified requirements filtration step (1);
(3) adjust the report data collection according to the form specified format, this report data collection comprises report data and statement form, adjust the process of report data collection, read the order of the field information of configuration file exactly, and according to this order of the field information corresponding process of adjusting the structure of report data collection in code;
(4) resolve report data collection, padding data.At first read in Excel form masterplate, in internal memory, form the example of a proprietary class; Resolve the report data collection then, resolve the report data collection then, carry out the Excel data and fill; Preserve the path of Excel form at last to user's appointment.
Utilize method of the present invention, directly the excel template that the user is given is read in, and Shu Chu form has kept and the on all four form of template at last, comprises various aspects such as color, font, formula; And, under the constant situation of reporting system code, supporting the random variation of Excel masterplate, the user will do only just changes a small amount of configuration file.Allow user's operating in a key just can export the Excel form of user's given format, the given Excel file of user changes in any case, reporting system can read in automatically, then report data is filled in the masterplate location automatically, the result of one-touch output directly is exactly the Excel form that the user wants.
Simultaneously, form set forth in the present invention generates method automatically and also supports the several data storage mode, comprises Distributed Storage, centralized storage or dual mode and deposits.Distributed Storage is meant storage in the database of this locality, and data are not concentrated the mode that reports; Centralized storage is meant data except being stored in the local database, also with real-time report in integrated data store.For the data extract of the distributed and centralized storage and the complex network structures of depositing, the present invention also can support.
Description of drawings
Fig. 1 is a flow chart of the present invention;
Fig. 2 generates report data collection flow chart;
Fig. 3 is the resolution data collection and finishes the flow chart that Excel fills.
Embodiment
At first, some nouns of using among the present invention are made an explanation:
Node: for a large-scale network with cascade connection, each unit in the network is node.Usually node is formed tree-like cascade connection, and form requires usually in the output of the root node place of the superiors, and the Reporting Requirements of root node obtains the data cases of the whole network.
Cascade file: the configuration file of record the whole network node topology relation.
Data acquisition: data acquisition refers to the data statistics process of each node, for example data acquisition can realize with the mode of storing process, the process of data acquisition be exactly carry out storing process and with the value output of each performance field in the table as a result of storing process.
The form metadata: what obtain from the table as a result of the storing process of each node is exactly the form metadata.
Timing data is gathered: utilize the timed task of reporting system, carry out data acquisition when system is not in a hurry, promptly the storing process that regularly goes to carry out each node in midnight or other time that is not in a hurry is finished data acquisition.
Real-time data acquisition: the data acquisition that in output report, just removes to carry out each node.
Distributed Storage: be meant that the data dispersion is stored in the local data base of each node in the network.Each node and inquire about each node database in the distributed query mode traverses network.
Centralized storage: be meant data and report in the database that is stored in a superior node except also concentrating in the database that disperses to be stored in each node.Deposit the node of all data in the centralized inquiry mode traverses network and inquire about this node database.
The report data collection: the report data collection in the literary composition refers to all to be got the form metadata of the whole network node, and with the total set of whole network data of certain data structure mode performance.The report data collection will be used to fill the usefulness of form.
Below in conjunction with accompanying drawing the present invention is done detailed explanation.
Fig. 1 is a flow chart of the present invention, the existing description in summary of the invention.
Fig. 2 generates report data collection flow chart, corresponding to the first two step of summary of the invention.
Image data generates the form metadata from each node, and its acquisition mode can be divided into timing acquiring and gather two kinds in real time.The time that but user's specific data is gathered in the timing acquiring mode, formulate some tasks by the user when not being in a hurry and carry out data acquisition in system; Data acquisition carries out when the user adds up in the acquisition mode in real time.The metadata that data acquisition generates leaves in as a result and calls in order to report program in the table, generates the report data collection.
Node number according to the cascade file obtains in the system to be disposed travels through all nodes.Judge the data storage method of each node,, then remove data query to its downstream site if be the distributed storage mode; If be centralized data storage method, then remove data query to node at the corresponding levels.If in table as a result, can inquire the data of specified requirements, then it is added to report data and concentrate; If data are empty, also execution of data acquisition is described, then call data acquisition, and then the Query Result table is got metadata: have data just to add the report data collection to; If this moment, data still were empty, then directly continue to carry out the work of fetching data of next node.Data query is that the table as a result in the Query Database obtains the value of required field according to the field of defined in the form masterplate.All nodes are repeated this process, finish, generated the data set that comprises all joint behavior data up to all node traversals.
Fig. 3 is the resolution data collection and finishes the flow chart that Excel fills, corresponding to back two steps of summary of the invention.
If statement form puts in order to node and field puts in order etc. has requirement, need and carry out some with the format configuration file contrast and adjust in proper order the report data collection that obtains previously.This stage work mainly is to utilize XML technology and code to realize.Specifically: have a configuration file to write down putting in order and locating information of each field in the Excel file; Adjust the process of report data collection, read the order of the field information of configuration file exactly, and in code the corresponding process of adjusting the structure of report data collection.
The data filling process is exactly the process of data set and Excel statement form masterplate coupling, just generated the required form of user after this process is finished.At first read in Excel form masterplate, in internal memory, form the example of a proprietary class; Resolve the report data collection then, the data filling algorithm is finished the filling of Excel data; Preserve the path of Excel form at last to user's appointment.Annotate: the data filling algorithm can be realized one or more data filling algorithms, to reach multiplexing purpose according to the concrete condition of field value location in the Excel file.
The explanation that has flexibility and autgmentability about this report method:
Excel statement form masterplate can be provided by the user, allows the random adjustment of form masterplate, need make corresponding modify to the XML configuration file for corresponding, and the reporting system code need not be changed fully;
Increase new business, the code that the Excel data are filled also need not be revised.Increase a business, such as increasing the 3GBSS business, only need in corresponding catalogue, to increase by one should business the XML configuration file, and in the configuration file of data filling mode corresponding relation " professional and " corresponding relation of interpolation Added Business and algorithm.
Claims (4)
1. the automatic generation method of a telecommunication apparatus performance report may further comprise the steps:
(1) from each data source, gathers the form metadata;
(2), generate required report data collection according to the form metadata in the specified requirements filtration step (1);
(3) adjust the report data collection according to the form specified format, this report data collection comprises report data and statement form;
(4) resolve report data collection, padding data.
2. the automatic generation method of the described telecommunication apparatus performance report of claim 1 is characterized in that, when from each data source, gathering the form metadata:
2.1 if data storage method is a distributed way, directly traces back on the bottom node and obtain;
2.2 if data storage method is a centralized fashion, directly obtain at node at the corresponding levels;
2.3 if data storage method is distributed and centralized and deposit, then obtaining according to data templates different in each node of form metadata carried out according to the mode in 2.1 and 2.2 respectively.
3. the automatic generation method of the described telecommunication apparatus performance report of claim 1, it is characterized in that, describedly adjust the report data collection, be meant the order of the field information that reads configuration file according to the form specified format, and according to this order of the field information corresponding structure of adjusting the report data collection in code.
4. the automatic generation method of the described telecommunication apparatus performance report of claim 1 is characterized in that, described parsing report data collection, and padding data comprises: at first read in Excel form masterplate, form the example of a proprietary class in internal memory; Resolve the report data collection then, carry out the Excel data and fill; Preserve the path of Excel form at last to user's appointment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2004100660188A CN100388676C (en) | 2004-12-06 | 2004-12-06 | Method for auto-forming reporting forms of telecommunication equipment performance |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2004100660188A CN100388676C (en) | 2004-12-06 | 2004-12-06 | Method for auto-forming reporting forms of telecommunication equipment performance |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1787448A CN1787448A (en) | 2006-06-14 |
| CN100388676C true CN100388676C (en) | 2008-05-14 |
Family
ID=36784775
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2004100660188A Expired - Fee Related CN100388676C (en) | 2004-12-06 | 2004-12-06 | Method for auto-forming reporting forms of telecommunication equipment performance |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100388676C (en) |
Families Citing this family (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101141754B (en) * | 2006-09-05 | 2010-05-12 | 中兴通讯股份有限公司 | Value-added service analysis system and method thereof |
| CN101661460B (en) * | 2009-09-18 | 2014-09-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN101957811A (en) * | 2010-10-18 | 2011-01-26 | 中兴通讯股份有限公司 | Method for filtering and analyzing data set of report form and report form processing equipment |
| CN102467696A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件（中国）有限公司 | Process control method for articles being processed and system thereof |
| CN102567491A (en) * | 2011-12-21 | 2012-07-11 | 北京数码大方科技有限公司 | Method and device for acquiring report data |
| CN103248513A (en) * | 2012-06-19 | 2013-08-14 | 谷尼国际软件(北京)有限公司 | Network information data collection method and system based on Office suite |
| CN103823804B (en) * | 2012-11-19 | 2017-10-17 | 广州汽车集团股份有限公司 | CAN network file is converted to the method and device of Excel file |
| CN103914438A (en) * | 2012-12-30 | 2014-07-09 | 航天信息股份有限公司 | Template and tag implementation based excel display and export method and system |
| CN104239024B (en) * | 2013-06-20 | 2017-07-18 | 深圳市华傲数据技术有限公司 | A kind of list data acquisition methods and device |
| CN104601627B (en) * | 2013-11-01 | 2019-05-14 | 北大方正集团有限公司 | Server, terminal, file on-line processing method and system |
| CN104699681A (en) * | 2013-12-04 | 2015-06-10 | 航天信息股份有限公司 | Data processing method based on metadata base |
| CN104462166A (en) * | 2014-08-28 | 2015-03-25 | 大唐移动通信设备有限公司 | Report generation method and system |
| CN108647260A (en) * | 2018-04-27 | 2018-10-12 | 厦门南讯软件科技有限公司 | A kind of personalization big data analysis system and method |
| CN112099801A (en) * | 2020-11-03 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Excel analysis method and system based on metadata driving |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1322067A2 (en) * | 2001-12-19 | 2003-06-25 | Alcatel Canada Inc. | Dynamically configurable human-machine interface |
| WO2003092241A1 (en) * | 2002-04-23 | 2003-11-06 | Alcatel | Device for managing data filters |
| CN1482766A (en) * | 2002-09-13 | 2004-03-17 | 华为技术有限公司 | Method for automatic generating of net management report form |
-
2004
- 2004-12-06 CN CNB2004100660188A patent/CN100388676C/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1322067A2 (en) * | 2001-12-19 | 2003-06-25 | Alcatel Canada Inc. | Dynamically configurable human-machine interface |
| WO2003092241A1 (en) * | 2002-04-23 | 2003-11-06 | Alcatel | Device for managing data filters |
| CN1482766A (en) * | 2002-09-13 | 2004-03-17 | 华为技术有限公司 | Method for automatic generating of net management report form |
Non-Patent Citations (6)
| Title |
|---|
| 一个自适应报表生成器的设计与实现. 张积友，王兰波.现代计算机，第12期. 2000 |
| 一个自适应报表生成器的设计与实现. 张积友，王兰波.现代计算机，第12期. 2000 * |
| 实时系统中的报表自动生成模型. 甘早斌，陈传波，宋善德，裴先登.华中理工大学学报，第27卷第S1期. 1999 |
| 实时系统中的报表自动生成模型. 甘早斌，陈传波，宋善德，裴先登.华中理工大学学报，第27卷第S1期. 1999 * |
| 用Excel和Delphi实现自由报表. 杨庆.浙江万里学院学报，第17卷第2期. 2004 |
| 用Excel和Delphi实现自由报表. 杨庆.浙江万里学院学报，第17卷第2期. 2004 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1787448A (en) | 2006-06-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100388676C (en) | Method for auto-forming reporting forms of telecommunication equipment performance | |
| AU2011201067B2 (en) | Collaborative web page authoring | |
| CN101141754B (en) | Value-added service analysis system and method thereof | |
| CN101146152B (en) | Information collection and search system for telecommunication information station | |
| CN110399420A (en) | A kind of deriving method, electronic equipment and the medium of configurableization Excel format | |
| CN109325158A (en) | A kind of electronic document automation archiving method and system | |
| CN102368261A (en) | Expandable running maintenance report generation method | |
| CN106250424A (en) | The searching method of a kind of daily record context, Apparatus and system | |
| EP1626526B1 (en) | Method and device for configuring data in communication device | |
| CN109213819A (en) | Information resource sharing system | |
| CN102279848A (en) | Method and device for generating report template | |
| CN109308296A (en) | A kind of generation method, device and the computer readable storage medium of business datum table | |
| CN101807306A (en) | Three-dimensional animation producing method and material independently exporting and importing method | |
| CN109271561A (en) | A kind of profile information search method and device | |
| CN101782851B (en) | Method for updating displayed page | |
| CN101615205A (en) | Report server, instant report implementation method and system | |
| CN201654777U (en) | Dynamic data acquisition device | |
| CN102982034B (en) | The searching method and search system of Internet website information | |
| CN101795425B (en) | Gigabit passive optical network (GPON) service management system based on OMCI (Operation Management Communication Interface) entity relationship model | |
| CN101815012A (en) | Method and device for acquiring performance data | |
| CN109408494B (en) | Model production record generation method based on form self-defining function | |
| CN102316128A (en) | A kind ofly be used to generate network service method and device | |
| CN101141318A (en) | Event integrated method and device thereof | |
| CN101552695B (en) | A unified network management method and system for multi-disciplinary networks | |
| CN101741621B (en) | Resource name generation method, system and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080514 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |