CN101308495A - Office data checking and manufacture method - Google Patents
Office data checking and manufacture method Download PDFInfo
- Publication number
- CN101308495A CN101308495A CNA2007101396082A CN200710139608A CN101308495A CN 101308495 A CN101308495 A CN 101308495A CN A2007101396082 A CNA2007101396082 A CN A2007101396082A CN 200710139608 A CN200710139608 A CN 200710139608A CN 101308495 A CN101308495 A CN 101308495A
- Authority
- CN
- China
- Prior art keywords
- data
- template
- standard
- checking
- module
- 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.)
- Granted
Links
Images
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention relates to an office data checking preparation method, which is applicable to the telecommunications industry and has the following steps: (1), a standard data module formats the standard data with changing format and standardizes the data into a standard data template, according to the settable corresponding relation between the standard data and the standard data template; (2), a present network data module adopts a regular expression to format the present network data with various formats and standardize the data into the corresponding present network data template; (3), a data checking module compares the difference between the data in the standard data template and the data in the present network data template through configurable comparison rules, and lists the checking results; (4), a data preparation module makes a template and generates the corresponding script according to the checking results and the preparation rules. The method of the invention has the advantages that the method can rapidly adapt to the changes of standard data and achieve the data checking of the exchangers of various manufacturers; besides, the method has high expansibility and makes fast response to the checking of business changes and the newly increased checking preparation business.
Description
Technical field
The present invention relates to a kind of office data checking and manufacture method, be applicable to telecommunications industry.
Background technology
Office data checking is the different of contrast standard data and existing network exchange data (hereinafter to be referred as the existing network data), and difference is generated the verification report.But normal data and existing network data have following characteristics:
(1) normal data: form is changeable, and it is various to originate; The general standard data provide with the Excel form, and the variation of form might take place the form that at every turn provides, and exert an influence no matter the variation size all can be verified module to data, cause the data check module to write again.
(2) existing network data: class of exchange is various, and form is various; Move with Hebei and to be example, existing network is using the switch of producers such as NORTEL, Huawei, Ericsson, Siemens, Bel, Eastcom-BUPT, the data memory format of the switch of each producer is different, or even it is far from each other, and for the switch of same producer the data layout during at different business also is Protean, if taking these data directly verifies, the workload of system development is inconceivable, when if the switch of different manufacturers is arrived in a certain cut over, verifying code must rewrite.
(3) make script: after data check was intact, some was to need to generate to make script, and the script format of different manufacturers also is inequality.
Generally speaking, office data checking and make the miscellaneous data layout of being not only face more is faced with the careless change problem of data layout.If the exploitation of directly verifying and making will bring inconceivable difficulty to the maintenance and the upgrading of system.
The office data checking method that uses is to be fixed in the code of verification procedures verifying rule at present.Its shortcoming is the code of necessary update routine when verifying the rule variation, the maintenance cost height.
Summary of the invention
The technical solution adopted for the present invention to solve the technical problems:
Method step of the present invention is as follows:
(1) normal data module:
By the normal data that can be provided with and the corresponding relation of normal data template, the changeable standard data formatization of form, and standard is in the normal data template;
Above-mentioned " corresponding relation " refers to " value of the field that data sense is identical ";
(2) existing network data module:
With regular expression the various existing network number of form is analyzed, and the analysis result standard in corresponding existing network data template;
(3) data check module:
By configurable contrast rule, the data difference in data in the contrast standard data template and the existing network data template, and list the verification result;
Described " configurable contrast rule " is to use the expression formula of conformance with standard SQL grammer;
(4) data creating module:
Is that script is made template according to the verification result with making rule, generates corresponding script, and promptly the text description that the verification result is directly replaced in the script making template promptly is final script as a result;
Described " making rule " refers to above-mentioned described " replacement ".
Beneficial effect of the present invention is as follows:
(1) variation that can the fast adaptation normal data has improved the work efficiency of office data checking greatly.
(2) exchange data that can realize each producer is verified.
(3) has highly scalable, fast response verification business change and the newly-increased business of making of verifying.
Description of drawings
Fig. 1 is a theory diagram of the present invention.
Fig. 2 is the theory diagram of normal data module.
Fig. 3 is the theory diagram of existing network data module.
Fig. 4 is the specific embodiment synoptic diagram of existing network data module.
Fig. 5 is the theory diagram of data check module.
Fig. 6 is the theory diagram of data creating module.
Embodiment
By the embodiment shown in Fig. 1-6 as can be known, the concrete grammar of present embodiment is as follows:
(1) normal data module:
This module has realized that normal data is unitized, and standard is in the normal data template; Normal data is the Excel file that reaches tens kinds of forms, and the meaning major part of data wherein is identical; So just can be to 2 normal data templates, as shown in Figure 2 uniform data to 1 by formulating a rule (corresponding relation of normal data that can be provided with and normal data template).
Among Fig. 2, among normal data 1 and the normal data n the＜2 〉,＜3 〉,＜5〉field name is different, but their paired field meanings are identical, the customize standard data template is written to the value of the field of same meaning in the corresponding normal data template respectively, that is to say, field 1 in the normal data 1, field 2, field 8, field 4, the value of field 5 is written to the field 11 in the normal data template respectively, field 12, field 13, field 14, in the field 15, and the field 1 among the normal data n, field 6, field 9, field 4, the value of field 7 is written to the field 11 in the normal data template respectively, field 12, field 13, field 14, in the field 15; So promptly realized the unified and standard of data.
Illustrate: the normal data template is a table in the database in this system.
For example: normal data template " mobile subscriber's section " is arranged, comprise contents such as " province ", " city ", " area code ", " number section "; Contents such as " province ", " city ", " area code ", " No. thousand section/No. ten thousand sections " are arranged in the normal data " intelligent network account number ", wherein " number section " of normal data template do not have corresponding field name in normal data, but " No. thousand section/No. ten thousand sections " in the normal data promptly is " number section " of normal data template, at this moment the value in " No. thousand section/No. ten thousand sections " is written in " number section " field of normal data template by corresponding relation (referring to the line among Fig. 2); Other normal data therewith roughly the same.
(2) existing network data module:
The existing network data are documents of plain text format, and it has also comprised the meaning of each field, just are hidden in text and have suffered, and by using regular expression data pick-up are come out, and standard is in corresponding existing network data template, as shown in Figure 3 then.
Illustrate: the existing network data template is a table in the database in this system, as shown in Figure 4.
(3) data check module:
Data check is data in the contrast standard data template and the data difference in the existing network data template, and control methods as shown in Figure 5.
In Fig. 5, shown contrast rule is the simplest a kind of, only for to say something: under the value of " field " 21 of " existing network data template " situation identical with the value of " field 11 " of " normal data template ", if the value of " field 23 " in " existing network data template " is different with the value of " field 13 " of " normal data template ", it is wrong then to draw current these data, points out that the value of " field 23 " in " existing network data template " should be the value of " field 13 " of " normal data template ".Above described principle can simply describe with following statement formula:
[" existing network data template "] [" field 21 "]=[" normal data template "] [" field 11 "] AND[" existing network data template "] [" field 23 "]＜[" normal data template "] [" field 13 "].
For example: it is 03FFB8 that the signaling point code of existing network user number section 1340020 is arranged, and number section 1340020 signaling point codes in the normal data are 03FFF0, illustrates that then the sensing of signalling point of No. 1340020 sections of existing network data is wrong.
Illustrate: in program run, above-mentioned expression formula is interpreted into the standard SQL statement.
(4) data creating module:
Generate corresponding script according to verifying the result and making rule, as shown in Figure 6.
Illustrate: it promptly is final script as a result that the value of verifying the result is directly replaced the description of making rule (text) Chinese words.
Claims (1)
1, office data checking and manufacture method is characterized in that its method step is as follows:
(1) normal data module:
By the normal data that can be provided with and the corresponding relation of normal data template, the changeable standard data formatization of form, and standard is in the normal data template;
Above-mentioned " corresponding relation " refers to " value of the field that data sense is identical ";
(2) existing network data module:
With regular expression the various existing network number of form is analyzed, and the analysis result standard in corresponding existing network data template;
(3) data check module:
By configurable contrast rule, the data difference in data in the contrast standard data template and the existing network data template, and list the verification result;
Described " configurable contrast rule " is to use the expression formula of conformance with standard SQL grammer;
(4) data creating module:
Is that script is made template according to the verification result with making rule, generates corresponding script, and promptly the text description that the verification result is directly replaced in the script making template promptly is final script as a result;
Described " making rule " refers to above-mentioned described " replacement ".
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101396082A CN101308495B (en) | 2007-10-24 | 2007-10-24 | Office data checking and manufacture method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101396082A CN101308495B (en) | 2007-10-24 | 2007-10-24 | Office data checking and manufacture method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101308495A true CN101308495A (en) | 2008-11-19 |
| CN101308495B CN101308495B (en) | 2011-05-25 |
Family
ID=40124953
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2007101396082A Active CN101308495B (en) | 2007-10-24 | 2007-10-24 | Office data checking and manufacture method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101308495B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102076116A (en) * | 2009-11-25 | 2011-05-25 | 中国移动通信集团辽宁有限公司 | Data comparing method and device |
| CN102082686A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团河北有限公司 | Office data checking control method and device |
| CN101772043B (en) * | 2008-12-31 | 2012-09-26 | 亿阳信通股份有限公司 | Office data checking method and device |
| CN102780574A (en) * | 2011-05-13 | 2012-11-14 | 中国移动通信集团广东有限公司 | Service-oriented office data collocation method and device as well as service-oriented office data inspection method and device |
| CN103188094A (en) * | 2011-12-28 | 2013-07-03 | 中国移动通信集团贵州有限公司 | Resource data verification system and resource data verification method |
| CN103365864A (en) * | 2012-03-28 | 2013-10-23 | 上海商派网络科技有限公司 | Front-end website data positioning method |
| CN103793462A (en) * | 2013-12-02 | 2014-05-14 | 北京奇虎科技有限公司 | URL (uniform resource locator) purifying method and device |
| CN104732344A (en) * | 2015-03-18 | 2015-06-24 | 浪潮通信信息系统有限公司 | Resource data checking system and method |
| CN108874649A (en) * | 2017-05-08 | 2018-11-23 | 中兴通讯股份有限公司 | Generation method, device and its computer equipment of automatic test script |
| CN109542774A (en) * | 2018-11-02 | 2019-03-29 | 平安医疗健康管理股份有限公司 | Script code format batch detector methods, device, terminal and readable storage medium storing program for executing |
| CN111639079A (en) * | 2020-05-29 | 2020-09-08 | 杭州东方通信软件技术有限公司 | Office data checking method and device for content charging service |
| CN113468401A (en) * | 2020-03-31 | 2021-10-01 | 中移系统集成有限公司 | Office data checking and making method and device, computer equipment and storage medium |
-
2007
- 2007-10-24 CN CN2007101396082A patent/CN101308495B/en active Active
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101772043B (en) * | 2008-12-31 | 2012-09-26 | 亿阳信通股份有限公司 | Office data checking method and device |
| CN102076116B (en) * | 2009-11-25 | 2013-09-18 | 中国移动通信集团辽宁有限公司 | Data comparing method and device |
| CN102076116A (en) * | 2009-11-25 | 2011-05-25 | 中国移动通信集团辽宁有限公司 | Data comparing method and device |
| CN102082686A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团河北有限公司 | Office data checking control method and device |
| CN102780574A (en) * | 2011-05-13 | 2012-11-14 | 中国移动通信集团广东有限公司 | Service-oriented office data collocation method and device as well as service-oriented office data inspection method and device |
| CN102780574B (en) * | 2011-05-13 | 2015-10-07 | 中国移动通信集团广东有限公司 | The collocation method of the office data of service-oriented, device and check method, device |
| CN103188094A (en) * | 2011-12-28 | 2013-07-03 | 中国移动通信集团贵州有限公司 | Resource data verification system and resource data verification method |
| CN103365864A (en) * | 2012-03-28 | 2013-10-23 | 上海商派网络科技有限公司 | Front-end website data positioning method |
| CN103365864B (en) * | 2012-03-28 | 2016-06-08 | 上海商派网络科技有限公司 | A kind of method of webpage front-end positioning data |
| CN103793462B (en) * | 2013-12-02 | 2016-08-31 | 北京奇虎科技有限公司 | Network address purification method and device |
| CN103793462A (en) * | 2013-12-02 | 2014-05-14 | 北京奇虎科技有限公司 | URL (uniform resource locator) purifying method and device |
| CN104732344A (en) * | 2015-03-18 | 2015-06-24 | 浪潮通信信息系统有限公司 | Resource data checking system and method |
| CN108874649A (en) * | 2017-05-08 | 2018-11-23 | 中兴通讯股份有限公司 | Generation method, device and its computer equipment of automatic test script |
| CN109542774A (en) * | 2018-11-02 | 2019-03-29 | 平安医疗健康管理股份有限公司 | Script code format batch detector methods, device, terminal and readable storage medium storing program for executing |
| CN109542774B (en) * | 2018-11-02 | 2023-10-17 | 深圳平安医疗健康科技服务有限公司 | Script coding format batch detection method and device, terminal and readable storage medium |
| CN113468401A (en) * | 2020-03-31 | 2021-10-01 | 中移系统集成有限公司 | Office data checking and making method and device, computer equipment and storage medium |
| CN113468401B (en) * | 2020-03-31 | 2023-04-28 | 中移系统集成有限公司 | Office data checking and making method, device, computer equipment and storage medium |
| CN111639079A (en) * | 2020-05-29 | 2020-09-08 | 杭州东方通信软件技术有限公司 | Office data checking method and device for content charging service |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101308495B (en) | 2011-05-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101308495B (en) | Office data checking and manufacture method | |
| CN110889270B (en) | Form page document generation method, form page rendering method and device | |
| CN104410667B (en) | Conversion method and system of a kind of XML message to JSON messages | |
| CN101673199A (en) | Terminal parameter configuration server and automatic generating method of software interface thereof | |
| US20080155519A1 (en) | Code translator | |
| CN102663094A (en) | IEC61970CIM model checking method | |
| CN105117431A (en) | Dynamic configuration method and system for external imported data | |
| CN102043626A (en) | Method and device for encapsulating extjs component, and method and system for generating user interface | |
| CN106095837A (en) | It is applicable to data system and the data processing method of industrial and commercial all kinds of business | |
| CN108762743A (en) | Data table operation code generation method and device | |
| CN104049976A (en) | System for automatically generating interlocking software based on Boolean logic | |
| CN102650995A (en) | Multi-dimensional data analyzing model generating system and method | |
| CN107608669A (en) | A kind of method based on database table structure automatic generation function and the page | |
| CN110058853A (en) | A kind of API procedure method controlled based on workflow and permission | |
| CN101930362B (en) | Method for integrating TTCN language and data description language | |
| CN109683886A (en) | A kind of diversification interface document generation method | |
| CN104021500A (en) | Product quality tracing device based on two-dimensional bar code technology | |
| CN106599058B (en) | RCD file model verification method and device | |
| CN111245633B (en) | Configuration file of micro-grid main equipment and operation method thereof | |
| CN107577498A (en) | One method for automatically generating interface Java resolution files | |
| CN107193906B (en) | Method and device for generating process pipeline instrument diagram bill of materials | |
| CN109684403A (en) | Dispatching of power netwoks information query method | |
| CN103049619A (en) | Method for completing chip design integrated functions by forms | |
| CN100468406C (en) | Automatic information data update method | |
| CN109522528A (en) | A kind of word document is converted to the method that can calculate automatically html document |
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 | ||
| C56 | Change in the name or address of the patentee |
Owner name: CHINA MOBILE QUANTONG SYSTEM INTEGRATION CO., LTD. Free format text: FORMER NAME: HEBEI QTONG COMMUNICATION CO., LTD. |
|
| CP01 | Change in the name or title of a patent holder |
Address after: 050021 No. 220 Tsing Yuen Street, Shijiazhuang, Hebei Patentee after: CHINA MOBILE QUANTONG SYSTEM INTEGRATION CO., LTD. Address before: 050021 No. 220 Tsing Yuen Street, Shijiazhuang, Hebei Patentee before: Hebei Qtong Communication Co., Ltd. Address after: 050021 No. 220 Tsing Yuen Street, Shijiazhuang, Hebei Patentee after: CHINA MOBILE QUANTONG SYSTEM INTEGRATION CO., LTD. Address before: 050021 No. 220 Tsing Yuen Street, Shijiazhuang, Hebei Patentee before: Hebei Qtong Communication Co., Ltd. |
|
| CP01 | Change in the name or title of a patent holder |
Address after: 050021 No. 220 Tsing Yuen Street, Shijiazhuang, Hebei Patentee after: China Mobile System Integration Co., Ltd Address before: 050021 No. 220 Tsing Yuen Street, Shijiazhuang, Hebei Patentee before: CHINA MOBILE QUANTONG SYSTEM INTEGRATION Co.,Ltd. |
|
| CP01 | Change in the name or title of a patent holder |