CN112084758A - Automatic extraction method of compressor quality inspection data - Google Patents
Automatic extraction method of compressor quality inspection data Download PDFInfo
- Publication number
- CN112084758A CN112084758A CN202010989387.3A CN202010989387A CN112084758A CN 112084758 A CN112084758 A CN 112084758A CN 202010989387 A CN202010989387 A CN 202010989387A CN 112084758 A CN112084758 A CN 112084758A
- Authority
- CN
- China
- Prior art keywords
- data
- recording
- compressor
- quality inspection
- wincc
- 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
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/174—Form filling; Merging
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Control Of Positive-Displacement Pumps (AREA)
Abstract
The invention discloses an automatic extraction method of compressor quality inspection data, which automatically fills data required to be recorded by compressor quality inspection into an EXCEL recording form through a WINCC script function and stores the data in a special recording folder, thereby simplifying the process steps of searching and extracting the compressor data and facilitating the quality inspection of the compressor; the time period for recording the data of the compressor can be manually controlled through the data recording start and stop buttons, and the accuracy for extracting the quality inspection data of the compressor is improved; the WINCC script function program cycle automatic recording improves the data accuracy, can also satisfy the simultaneous recording of multiple equipment data, reduces the labor intensity and improves the quality inspection efficiency of the compressor.
Description
Technical Field
The invention relates to the technical field of data storage of compressors, in particular to an automatic extraction method of quality inspection data of a compressor.
Background
The monitoring data record of the compressor in the prior art is automatically filed by adopting WINCC or other upper computer software, a stored data template is stored for time set by a manufacturer well, the record is exported and the desired content is extracted, the process is complicated, when the data is exported, time nodes are difficult to grasp, the data export is incomplete, the exported data volume is large, in the process of quality inspection of the compressor, relevant personnel have difficulty in searching and recording relevant detection data, the data is easy to omit or make mistakes, and the accuracy of quality inspection results is influenced.
Disclosure of Invention
The method aims at the problems that in the prior art, data recording templates need to be converted, the compressor data extraction time nodes are difficult to grasp, the manual recording efficiency is low, and the quality inspection efficiency and accuracy are affected.
The invention provides the following technical scheme: an automatic extraction method of compressor quality inspection data comprises the following steps:
step 1: uploading the compressor data read by the compressor control system to WINCC, and respectively establishing pictures for each set of compressor control system;
step 2: respectively compiling script functions aiming at different compressor control systems according to the data and the recording frequency required by the quality inspection of the compressor, and automatically screening and recording the required data on the WINCC picture through the script functions;
and step 3: establishing an output window of monitoring data on a WINCC picture, setting a recording mode button on the WINCC picture, and automatically screening and recording required data on the WINCC picture after a script function starts a compressor if automatic recording is selected; if manual recording is selected, a WINCC picture is provided with a data recording start button and a data recording stop button, when relevant data needs to be recorded, the recording start button is clicked, and when the recording is stopped midway, the recording stop button is clicked;
and 4, step 4: and different EXCEL recording tables are established according to standard templates aiming at different compressor control systems, and the required data on the WINCC picture is stored in a special data recording folder after being filled into the EXCEL recording tables by a script function.
Further, the script function is triggered circularly, after the data record is started, the script function background periodically and circularly automatically opens the EXCEL record form and fills the data, after the data filling is finished, the background automatically closes the record form, and after the record period is finished, the record form is automatically stored into a form document according to the current time and the related information to be stored in the special record folder.
Furthermore, when the recording mode selects automatic recording, in order to ensure that each WINCC picture can record data, a recording script function can be automatically triggered in each picture.
Furthermore, the script function allows a plurality of groups of data recording requirements to be carried out simultaneously, meets the data recording requirements of a plurality of devices,
in conclusion, the invention has the following beneficial effects: the data required to be recorded by the compressor quality inspection is automatically filled into an EXCEL recording table through a WINCC script function and is stored in a special recording folder, so that the process steps of searching and extracting the compressor data are simplified, and the quality inspection of the compressor is facilitated; the time period for recording the data of the compressor can be manually controlled through the data recording start and stop buttons, and the accuracy for extracting the quality inspection data of the compressor is improved; the WINCC script function program cycle automatic recording improves the data accuracy, can also satisfy the simultaneous recording of multiple equipment data, reduces the labor intensity and improves the quality inspection efficiency of the compressor.
Drawings
FIG. 1 is a flow chart of the present invention for automatically storing quality inspection data of a compressor;
FIG. 2 is a flow diagram of the script function auto-save data of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings.
The invention discloses an automatic extraction method of compressor quality inspection data, which comprises the following steps as shown in figures 1-2:
step 1: uploading the compressor data read by the compressor control system to WINCC, and respectively establishing pictures for each set of compressor control system;
step 2: respectively compiling script functions aiming at different compressor control systems according to the data and the recording frequency required by the quality inspection of the compressor, and automatically screening and recording the required data on the WINCC picture through the script functions;
and step 3: establishing an output window of monitoring data on a WINCC picture, setting a recording mode button on the WINCC picture, and automatically screening and recording required data on the WINCC picture after a script function starts a compressor if automatic recording is selected; if manual recording is selected, a WINCC picture is provided with a data recording start button and a data recording stop button, when relevant data needs to be recorded, the recording start button is clicked, and when the recording is stopped midway, the recording stop button is clicked;
and 4, step 4: and different EXCEL recording tables are established according to standard templates aiming at different compressor control systems, and the required data on the WINCC picture is stored in a special data recording folder after being filled into the EXCEL recording tables by a script function.
Further, the script function is triggered circularly, after the data record is started, the script function background periodically and circularly automatically opens the EXCEL record form and fills the data, after the data filling is finished, the background automatically closes the record form, and after the record period is finished, the record form is automatically stored into a form document according to the current time and the related information to be stored in the special record folder.
Furthermore, when the recording mode selects automatic recording, in order to ensure that each WINCC picture can record data, a recording script function can be automatically triggered in each picture.
Furthermore, the script function allows multiple groups of data recording requirements to be performed simultaneously, and data recording of multiple devices is met.
The data required to be recorded by the compressor quality inspection is automatically filled into an EXCEL recording table through a WINCC script function and is stored in a special recording folder, so that the process steps of searching and extracting the compressor data are simplified, and the quality inspection of the compressor is facilitated; the time period for recording the data of the compressor can be manually controlled through the data recording start and stop buttons, and the accuracy for extracting the quality inspection data of the compressor is improved; the WINCC script function program is periodically and circularly automatically recorded, so that the data accuracy is improved, the simultaneous recording of data of a plurality of devices can be met, the labor intensity is reduced, and the quality inspection efficiency of the compressor is improved; the EXCEL recording form is the same as the quality inspection form, and the EXCEL recording form stored by the script function can be directly printed without manually picking and copying the quality inspection form.
Although the embodiments of the present invention have been described with reference to the accompanying drawings, it is not intended to limit the scope of the present invention, and it should be understood by those skilled in the art that various modifications and variations can be made without inventive efforts by those skilled in the art based on the technical solution of the present invention.
Claims (4)
1. The automatic extraction method of the compressor quality inspection data is characterized by comprising the following steps of:
step 1: uploading the compressor data read by each set of compressor control system to WINCC, and respectively establishing pictures for each set of compressor control system;
step 2: respectively compiling script functions aiming at different compressor control systems according to the data and the recording frequency required by the quality inspection of the compressor, and automatically screening and recording the required data on the WINCC picture through the script functions;
and step 3: establishing an output window of monitoring data on a WINCC picture, setting a recording mode button on the WINCC picture, and automatically screening and recording required data on the WINCC picture after a script function starts a compressor if automatic recording is selected; if manual recording is selected, a WINCC picture is provided with a data recording start button and a data recording stop button, when relevant data needs to be recorded, the recording start button is clicked, and when the recording is stopped midway, the recording stop button is clicked;
and 4, step 4: and different EXCEL recording tables are established according to standard templates aiming at different compressor control systems, and the required data on the WINCC picture is stored in a special data recording folder after being filled into the EXCEL recording tables by a script function.
2. The method for automatically extracting compressor quality inspection data according to claim 1, wherein the method comprises the following steps: and the script function is triggered circularly, after the data record is started, the background of the script function periodically and circularly automatically opens the EXCEL record form and fills data, after the data filling is finished, the background automatically closes the record form, and after the record period is finished, the record form is automatically stored into a form document according to the current time and related information to be stored in a special record folder.
3. The method for automatically extracting the quality inspection data of the compressor according to claim 2, wherein the method comprises the following steps: when the recording mode selects automatic recording, in order to ensure that each WINCC picture can record data, a recording script function can be automatically triggered in each picture.
4. The method for automatically extracting compressor quality inspection data according to claim 3, wherein the method comprises the following steps: the script function allows multiple groups of data recording requirements to be carried out simultaneously, and data recording of multiple devices is met.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010989387.3A CN112084758A (en) | 2020-09-19 | 2020-09-19 | Automatic extraction method of compressor quality inspection data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010989387.3A CN112084758A (en) | 2020-09-19 | 2020-09-19 | Automatic extraction method of compressor quality inspection data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112084758A true CN112084758A (en) | 2020-12-15 |
Family
ID=73738966
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010989387.3A Pending CN112084758A (en) | 2020-09-19 | 2020-09-19 | Automatic extraction method of compressor quality inspection data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112084758A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114051230A (en) * | 2021-10-25 | 2022-02-15 | 智昌科技集团股份有限公司 | Excel platform-based data transmission method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799675A (en) * | 2012-07-18 | 2012-11-28 | 天津市天锻压力机有限公司 | Status data storage method for quick forging press |
| CN107943009A (en) * | 2017-12-21 | 2018-04-20 | 安徽马钢自动化信息技术有限公司 | A kind of industrial control system Fault Locating Method |
| CN111324625A (en) * | 2019-11-22 | 2020-06-23 | 广东奥瑞特新能源设备科技有限公司 | Upper computer data report application method |
-
2020
- 2020-09-19 CN CN202010989387.3A patent/CN112084758A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799675A (en) * | 2012-07-18 | 2012-11-28 | 天津市天锻压力机有限公司 | Status data storage method for quick forging press |
| CN107943009A (en) * | 2017-12-21 | 2018-04-20 | 安徽马钢自动化信息技术有限公司 | A kind of industrial control system Fault Locating Method |
| CN111324625A (en) * | 2019-11-22 | 2020-06-23 | 广东奥瑞特新能源设备科技有限公司 | Upper computer data report application method |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114051230A (en) * | 2021-10-25 | 2022-02-15 | 智昌科技集团股份有限公司 | Excel platform-based data transmission method |
| CN114051230B (en) * | 2021-10-25 | 2023-10-13 | 智昌科技集团股份有限公司 | Data transmission method based on Excel platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6400890B1 (en) | Image retrieving method and apparatuses therefor | |
| CN109885581A (en) | Synchronous method, device, equipment and the storage medium of database | |
| CN110008875B (en) | Face recognition video clip screening method and system based on key frame backtracking | |
| EP2297940B1 (en) | Method to control image processing apparatus, image processing apparatus, and image file | |
| US7225203B2 (en) | Information storage system and information management system | |
| CN104951400B (en) | The method and apparatus that product is tested | |
| CN108307235A (en) | A kind of screen parameter configuration system | |
| CN114902687A (en) | Game screen recording method and device and computer readable storage medium | |
| EP2680169A1 (en) | Operation management support device, operation management support method, and program | |
| CN112084758A (en) | Automatic extraction method of compressor quality inspection data | |
| CN113518187A (en) | Video editing method and device | |
| JP5967164B2 (en) | Form system, processing method thereof, and program | |
| CN110659393B (en) | Method and system for generating xml code | |
| CN107562766B (en) | Data file writing method, device and system | |
| CN111611026A (en) | NC file fast loading implementation method based on side hole machine | |
| CN109376073B (en) | Test environment memory and recovery method | |
| CN104135628A (en) | Video editing method and terminal | |
| CN104392506B (en) | Data syn-chronization and data managing method are patrolled and examined in a kind of power station water conservancy project for supporting multiple terminals platform | |
| WO2015131651A1 (en) | Slide generation method and device | |
| CN111831341A (en) | Configuration file loading method, device and system and computer readable medium | |
| CN104980603B (en) | A kind of USB_3G network interface cards User space automatic identification and Dialing Method and device | |
| CN110489432B (en) | Model-based database automatic synchronization method, medium, equipment and device | |
| CN113915890A (en) | Refrigerator and control method thereof | |
| CN111123744A (en) | Menu recording method and device, storage medium and electronic equipment | |
| CN106960010B (en) | Device metadata generation apparatus |
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 |