CN108170653B - Multi-template calibration certificate automatic generation method based on information fusion - Google Patents
Multi-template calibration certificate automatic generation method based on information fusion Download PDFInfo
- Publication number
- CN108170653B CN108170653B CN201711280791.8A CN201711280791A CN108170653B CN 108170653 B CN108170653 B CN 108170653B CN 201711280791 A CN201711280791 A CN 201711280791A CN 108170653 B CN108170653 B CN 108170653B
- Authority
- CN
- China
- Prior art keywords
- certificate
- data
- metering
- document
- content
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to the technical field of data report generation, and particularly relates to an automatic multi-template calibration certificate generation method based on information fusion. The method comprises the following steps: automatically or manually generating a TXT/EXCEl original record document with feature identification; analyzing a data task, verifying original records, and screening and matching certificate contents; the data task analysis means that after relevant TXT/EXCEL is uploaded to a server, a program in the server analyzes the title of a relevant file and the feature identification of a specific position in a document; automatically generating accurate original record and certificate formats; verifying certificate data and storing documents; the data verification and document storage means that data in the original record is calculated by using a formula stored in the server, certificate data are verified according to index range information stored in a database, the consistency of the type of a certificate result to be issued and the type of a final certificate is matched, and the certificate data are uploaded to the server for storage. The invention can improve the efficiency of metrological verification work.
Description
Technical Field
The invention belongs to the technical field of data report generation, and particularly relates to an automatic multi-template calibration certificate generation method based on information fusion.
Background
One of the contents of the metering work is to develop a metering calibration service, and finally, calibration \ verification original records and certificates are provided for customers in the process of the metering calibration service developed around specialties such as long, hot, force, electricity and the like. Because metering rules are different, metering items and process data are different, and therefore in most use environments, metering certificates need to be manually generated or adaptively modified. Along with the deepening of the automation degree of the metering equipment, aiming at a plurality of electrical metering equipment, the automatic control of the operation of the metering equipment and the automatic acquisition of data can be completed by programming an automatic control program.
Disclosure of Invention
The invention aims to provide an automatic multi-template calibration certificate generation method based on information fusion, which aims to solve the problems of automatic generation of original records and certificates of various automatic metering projects and automatic generation of certificates of related projects of manual metering and improve the efficiency of metering and verification work.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
a multi-template calibration certificate automatic generation method based on information fusion comprises the following steps:
step one, automatically or manually generating a TXT/EXCEl original record document with feature identification;
step two, analyzing and verifying original records of the data task and screening and matching certificate contents; the data task analysis means that after relevant TXT/EXCEL is uploaded to a server, a program in the server analyzes the title of a relevant file and the feature identification of a specific position in a document;
step three, automatically generating accurate original records and certificate formats according to the table types and contents analyzed in the step two;
step four, certificate data check and document storage; the data verification and document storage means that data in the original record is calculated by using a formula stored in the server, certificate data are verified according to index range information stored in a database, the consistency of the type of a certificate result to be issued and the type of a final certificate is matched, and the certificate data are uploaded to the server for storage.
In the first step, the characteristic mark is composed of the following basic format, namely a task number, a measuring instrument group mark and a measuring object mark, wherein the task number is generated by a superior task scheduling system, is connected through a network cable and acquires related information through a TCP/IP protocol; the task number part is automatically generated by the server no matter manual measurement or automatic measurement is carried out, and when automatic measurement is carried out, the measurement instrument group mark and the measurement object mark are automatically generated in the measurement software and filled in the TXT document, the XML file title and the document; when manual measurement is performed, an operator needs to add a measurement instrument group flag and a measurement object flag to the title of the EXCEL document and the relevant position inside the document on the basis of the job number.
In the second step, firstly, the first screening is carried out according to the measuring instrument and the measuring object, and the required table contents to which the original records and the certificates belong are screened; and secondly, performing secondary judgment according to content options preset by a machine in the filled TXT document or the EXCEL document, verifying whether the filled content of the operator is correct or not, if the filled content of the operator is not correct, feeding back the operator, and if the filled content of the operator is not correct, screening out related form content according to the file data content.
In the third step, the generated table comprises the content of the fixed part of the format and the content of the changed format; the content of the format fixed part comprises head raising and metering rules, and the content of format change is variable due to different metering contents, different operation times and different number of columns needing to be displayed; for the content of the format fixed part, through the screening and selection of the second step, the relevant metering rule information is obtained through the matching of the metering standard and the metering object, and the relevant head-up fixed part is obtained through the information input in the server; for format change contents, determining main variable data table contents by utilizing the screening of a metering standard and a metering object, matching column numbers according to related data in TXT or EXCEL, performing re-matching, and determining the row number of display contents; and the final original record and the output of the certificate are realized through the combination of the format fixed part content and the format change content.
The screening process of the method comprises the steps of judging whether the metering standard is consistent with a metering object or not, whether the metering standard is consistent with a document code or not, judging whether the obtained metering result is in common agreement with a preset standard column number or not, reminding an operator to check when the three parts are inconsistent with a preset condition, and generating a variable part in a certificate by using the three parts; whether the obtained metering result is common with the preset standard column number or not is judged, and when the obtained metering result and the preset standard column number are completely approximate, the ratio is used as the row number of the result data; when the two cannot be completely eliminated, the operator needs to be reminded to check the manual inspection result data.
The beneficial effects obtained by the invention are as follows:
the invention provides an automatic multi-template calibration certificate generation method based on information fusion, which comprises an original record and a final result certificate. The method solves the problems of screening, checking and combining of the fixed part and the variable part in the template certificate, solves the problem of automatic generation of the certificate under the conditions of automatic metering and manual metering, and improves the efficiency of metering work.
Drawings
FIG. 1 is a flow diagram of a method for automatic generation of a multi-template calibration certificate;
FIG. 2 is a flow chart of variable part screening and fixed part screening in the examples.
Detailed Description
The invention is described in detail below with reference to the figures and specific embodiments.
As shown in fig. 1, the method for automatically generating a multi-template calibration certificate based on information fusion according to the present invention includes the steps of acquiring a task, acquiring txt/excel data, analyzing the txt/excel data, generating an original record, and generating a certificate, and specifically includes the following steps:
step one, automatically or manually generating a TXT/EXCEl original record document with feature identification.
The characteristic mark comprises a task number, a measuring instrument group mark and a measuring object mark, wherein the task number is mainly generated by a superior task scheduling system and is connected through a network cable to acquire related information through a TCP/IP protocol. The task number is automatically generated by the server whether manual measurement or automatic measurement is performed, and when automatic measurement is performed, the measuring instrument group mark and the measuring object mark are automatically generated in the measuring software and filled in the TXT document, the XML file header and the document. When manual metering is performed, an operator needs to add a metering instrument group and a metering object mark on the basis of a task number on the basis of the title of an EXCEL document and the related position inside the document.
And step two, analyzing the data task, verifying the original record and screening and matching the certificate content.
The data task analysis refers to the analysis of the program in the server on the related file title and the feature mark of the specific position in the document after the related TXT/EXCEL is uploaded to the server. The method mainly screens relevant instruments and measuring objects, and performs first-time screening according to the measuring instruments and the measuring objects to screen required table contents to which relevant original records and certificates belong. Secondly, according to content options preset by a machine in the filled TXT document or the filled EXCEL document, carrying out secondary judgment, verifying whether the filled content of an operator is correct or not, if the filled content of the operator is not correct, feeding back the operator, and if the filled content of the operator is not correct, screening out related form content according to the file data content.
Step three, generating original record and certificate
And the generation of the original record and the certificate is a process of automatically generating an accurate original record and certificate format according to the table type and content analyzed in the step two. The generated table contains two parts of contents, one is format fixed part of contents, and the other is format variable contents. The fixed format part mainly comprises head-up, metering rules and the like, and the variable format content mainly refers to the variable content caused by different metering contents, different operation times and different required display columns. And for the fixed format part, screening and selecting in the step two, acquiring information related to metering rules and the like through metering standards and metering object matching, and acquiring fixed parts related to head-up and the like through information input in the server. For the variable format part, the content of a main variable data table is determined by utilizing the screening of a metering standard and a metering object, and the column number is matched and raised according to related data in TXT or EXCEL to carry out re-matching, so that the row number of the displayed content is determined. The combination of the fixed part and the variable part realizes the output of the final original record and the certificate.
Step four, checking the certificate data and saving the document
The data verification and document storage means that data in the original record is calculated by using a formula stored in the server, and certificate data are verified according to index range information stored in the database and are used for matching the consistency of the type of the certificate result to be issued and the type of the final certificate. And uploading to a server for storage.
As shown in fig. 2, the screening process of the method includes whether the measurement standard is consistent with the measurement object, whether the measurement standard is consistent with the document code, whether the obtained measurement result is common with the preset standard column number, and when the three parts are inconsistent with the preset condition, the operator is prompted to check and generate the variable part in the certificate.
If the sum of the obtained data and the preset column number is common, the ratio can be used as the row number of the result data when the sum of the obtained data and the preset column number is completely approximate. When the two cannot be completely eliminated, the operator needs to be reminded to check the manual inspection result data.
Claims (4)
1. A multi-template calibration certificate automatic generation method based on information fusion is characterized in that: the method comprises the following steps:
step one, automatically or manually generating a TXT/EXCEl original record document with feature identification;
step two, analyzing and verifying original records of the data task and screening and matching certificate contents; the data task analysis means that after relevant TXT/EXCEL is uploaded to a server, a program in the server analyzes the title of a relevant file and the feature identification of a specific position in a document;
step three, automatically generating accurate original records and certificate formats according to the table types and contents analyzed in the step two;
step four, certificate data check and document storage; the data verification and document storage means that data in an original record is calculated by using a formula stored in a server, certificate data are verified according to index range information stored in a database, the certificate data are used for matching the consistency of the type of a certificate result to be issued and the type of a final certificate, and the certificate data are uploaded to the server for storage;
in the third step, the generated table comprises the content of the fixed part of the format and the content of the changed format; the content of the format fixed part comprises head raising and metering rules, and the content of format change is variable due to different metering contents, different operation times and different number of columns needing to be displayed; for the content of the format fixed part, through the screening and selection of the second step, the relevant metering rule information is obtained through the matching of the metering standard and the metering object, and the relevant head-up fixed part is obtained through the information input in the server; for format change contents, determining main variable data table contents by utilizing the screening of a metering standard and a metering object, matching column numbers according to related data in TXT or EXCEL, performing re-matching, and determining the row number of display contents; and the final original record and the output of the certificate are realized through the combination of the format fixed part content and the format change content.
2. The method for automatically generating the multi-template calibration certificate based on the information fusion according to claim 1, characterized in that: in the first step, the characteristic mark is composed of the following basic format, namely a task number, a measuring instrument group mark and a measuring object mark, wherein the task number is generated by a superior task scheduling system, is connected through a network cable and acquires related information through a TCP/IP protocol; the task number part is automatically generated by the server no matter manual measurement or automatic measurement is carried out, and when automatic measurement is carried out, the measurement instrument group mark and the measurement object mark are automatically generated in the measurement software and filled in the TXT document, the XML file title and the document; when manual measurement is performed, an operator needs to add a measurement instrument group flag and a measurement object flag to the title of the EXCEL document and the relevant position inside the document on the basis of the job number.
3. The method for automatically generating the multi-template calibration certificate based on the information fusion according to claim 1, characterized in that: in the second step, firstly, the first screening is carried out according to the measuring instrument and the measuring object, and the required table contents to which the original records and the certificates belong are screened; and secondly, performing secondary judgment according to content options preset by a machine in the filled TXT document or the EXCEL document, verifying whether the filled content of the operator is correct or not, if the filled content of the operator is not correct, feeding back the operator, and if the filled content of the operator is not correct, screening out related form content according to the file data content.
4. The method for automatically generating the multi-template calibration certificate based on the information fusion according to claim 1, characterized in that: the screening process of the method comprises the steps of judging whether the metering standard is consistent with a metering object or not, whether the metering standard is consistent with a document code or not, judging whether the obtained metering result is in common agreement with a preset standard column number or not, reminding an operator to check when the three parts are inconsistent with a preset condition, and generating a variable part in a certificate by using the three parts; whether the obtained metering result is common with the preset standard column number or not is judged, and when the obtained metering result and the preset standard column number are completely approximate, the ratio is used as the row number of the result data; when the two cannot be completely eliminated, the operator needs to be reminded to check the manual inspection result data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711280791.8A CN108170653B (en) | 2017-12-05 | 2017-12-05 | Multi-template calibration certificate automatic generation method based on information fusion |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711280791.8A CN108170653B (en) | 2017-12-05 | 2017-12-05 | Multi-template calibration certificate automatic generation method based on information fusion |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108170653A CN108170653A (en) | 2018-06-15 |
| CN108170653B true CN108170653B (en) | 2021-07-20 |
Family
ID=62525445
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711280791.8A Active CN108170653B (en) | 2017-12-05 | 2017-12-05 | Multi-template calibration certificate automatic generation method based on information fusion |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108170653B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667172A (en) * | 2009-09-14 | 2010-03-10 | 成都市科陆洲电子有限公司 | Method for making spreadsheet by utilizing word |
| CN106302776A (en) * | 2016-08-24 | 2017-01-04 | 杨朝钰 | A kind of cloud platform processing continuous data and method |
| CN106909604A (en) * | 2015-12-22 | 2017-06-30 | 清华大学 | The automatic check method and system of rule-based EXCEL lists and ACCESS databases |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599141A (en) * | 2009-03-25 | 2009-12-09 | 西安计量技术研究院 | The system and method that validity control is carried out in report to the Zheng Shu of measurement technology mechanism |
| CN102479351B (en) * | 2010-11-25 | 2015-11-25 | 西安计量技术研究院 | A kind of intelligent management method and system to newly-built measurement standard |
| CN104111919A (en) * | 2013-04-16 | 2014-10-22 | 无锡南理工科技发展有限公司 | Certificate compilation method for measuring and testing service system |
| CN104111436A (en) * | 2014-08-05 | 2014-10-22 | 上海市计量测试技术研究院 | Automatic detection system and method for digital multimeter |
| EP3236668A1 (en) * | 2016-04-18 | 2017-10-25 | ABB Schweiz AG | Method and system for reproducing an instrument`s calibration certificate |
| CN107194266B (en) * | 2017-05-12 | 2020-09-04 | 江苏诺安科技有限公司 | Method for verifying whether paper certificate is tampered |
-
2017
- 2017-12-05 CN CN201711280791.8A patent/CN108170653B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667172A (en) * | 2009-09-14 | 2010-03-10 | 成都市科陆洲电子有限公司 | Method for making spreadsheet by utilizing word |
| CN106909604A (en) * | 2015-12-22 | 2017-06-30 | 清华大学 | The automatic check method and system of rule-based EXCEL lists and ACCESS databases |
| CN106302776A (en) * | 2016-08-24 | 2017-01-04 | 杨朝钰 | A kind of cloud platform processing continuous data and method |
Non-Patent Citations (2)
| Title |
|---|
| 基于OLE的校准证书自动生成技术;潘光斌 等;《中国计量》;20071130;第71-72页 * |
| 计量检定与校准及其证书有效性的区别;冯林;《中国计量》;20170430;第43-44页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108170653A (en) | 2018-06-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107943768B (en) | A kind of measurement verification calibration digital certificates intelligent editing method and system | |
| CN110378446B (en) | Electric power safety tool test management system | |
| CN106934630B (en) | Measuring instrument quantity value tracing method | |
| CN114519498B (en) | Quality inspection and evaluation method and system based on BIM model | |
| CN108334484B (en) | Data entry method and device | |
| CN106570232A (en) | Inspection procedure automatic generation method | |
| CN102479351A (en) | Method for intelligently managing newly established measurement standard and system thereof | |
| CN105893340A (en) | Efficient data processing system used during detection and analysis | |
| US20130197842A1 (en) | Streamlined parts approval process | |
| CN104714429A (en) | Coal sample experiment data acquisition and analysis system and method | |
| CN107797910A (en) | A kind of evaluation method of dispatch automated system software quality | |
| CN112102117A (en) | Electronic file quality inspection and supervision system | |
| CN110659289B (en) | Material quality detection test report management method and system | |
| CN110991150B (en) | Data format conversion method, device and account reporting system | |
| CN103577647A (en) | Evaluation analysis method and device of steam turbine and steam turbine speed adjusting system model | |
| CN111967839A (en) | BIM-based construction quality acceptance method and system for building components | |
| CN113837598B (en) | Information acquisition method based on intelligent manufacturing | |
| CN108170653B (en) | Multi-template calibration certificate automatic generation method based on information fusion | |
| CN102654570A (en) | Method for semi-automatically testing/calibrating instrument without programmable interface | |
| CN106155665B (en) | Conformity evidence-presenting system and method | |
| CN112699022B (en) | Method and system for real-time efficient automatic contract testing | |
| CN114219336A (en) | Production process quality detection system based on MES system of moulding plastics | |
| KR101717597B1 (en) | The dimensional control system based on mobile | |
| CN106066860A (en) | A kind of method of electric power meter management | |
| US20140303922A1 (en) | Integrated Tool for Compliance Testing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |