CN-121998566-A - Data monitoring and report generating method, device, equipment and storage medium

CN121998566ACN 121998566 ACN121998566 ACN 121998566ACN-121998566-A

Abstract

The application discloses a data monitoring and report generating method, a device, equipment and a storage medium, which relate to the technical field of computers and comprise the steps of acquiring acquisition data from a data channel corresponding to a server based on signals acquired by a sensor, configuring display formats of the acquisition data, information written into a report by the acquisition data and report formats to generate a configuration file, initializing the configuration file to create a target database, controlling the acquisition of the data through a control button, storing the acquisition data to the target database in the data acquisition process, generating data blocks with the number corresponding to the acquisition data, displaying a numerical trend line graph of the data blocks, system operation flow and data acquisition points, acquiring data alarm types and alarm values corresponding to the data acquisition points, monitoring and alarming the real-time values of the data acquisition points based on the data alarm types and the alarm values, and generating corresponding record reports when the data acquisition is completed. The application realizes data test and record.

Inventors

TANG XIAO
ZHANG LIXIN
YANG KAI
XIA HAOYUN
JIANG SHIYU
XIAO FEI
Wu cen

Assignees

重庆齿轮箱有限责任公司

Dates

Publication Date: 20260508
Application Date: 20241106

Claims (10)

1. A data monitoring and report generating method, which is applied to a data monitoring and report generating system, comprising: acquiring acquisition data from a data channel corresponding to a server based on signals acquired by a sensor, and configuring a display format of the acquisition data, information of a report written by the acquisition data and a report format through Excel to generate a configuration file; initializing according to the configuration file, creating a target database, controlling data acquisition through a control button, and storing acquired data to the target database based on a preset time interval in the data acquisition process; generating data blocks with the corresponding quantity of the acquired data, displaying the data blocks, the system operation flow and a numerical trend line graph of the data acquisition points, acquiring data alarm types and alarm values corresponding to the data acquisition points, and monitoring and alarming real-time values of the data acquisition points based on the data alarm types and the alarm values; And when the data acquisition is completed, generating a corresponding record report based on the data stored in the target database.
2. The method for generating data monitoring and reporting according to claim 1, wherein the acquiring the collected data from the data channel corresponding to the server based on the signal collected by the sensor comprises: And converting the signals acquired by the sensors through a signal converter, and transmitting the corresponding converted signals to the server based on an Ethernet bus so as to acquire acquired data from a data channel corresponding to the server.
3. The method for monitoring and generating data according to claim 1, wherein the display format of the collected data includes a user name, an alarm type, an alarm threshold, a channel type definition, and whether a line diagram requires a drawing switch, the information of the collected data writing report includes a report write-once information configuration, a report rewrite information configuration, and a report generation auxiliary parameter configuration, and the report format is a format customized based on a user.
4. The method for generating data monitoring and reporting according to claim 1, wherein the initializing operation according to the configuration file comprises: importing the configuration file, and completing mapping, conversion and state updating operations based on the configuration file.
5. The method of claim 1, wherein the data block includes a name of the data collection point, a communication status, an alarm status, and a real-time value of the data collection point, and wherein the system operation pipeline includes an operation action, an operation time, a location path created by the target database and the record report, a time, a start time of data collection, a pause time, a resume collection time, a stop collection time, an alarm time of the data collection point, and a resume time.
6. The method for generating a data monitoring and report according to claim 1, wherein said monitoring and alarming the real-time value of the data acquisition point based on the data alarm type and the alarm value comprises: and if the real-time value of the data acquisition point exceeds the alarm value, changing the state of the data acquisition point into an alarm state so as to perform corresponding alarm operation according to the data alarm type, and writing the data acquisition point with the state changed into the target database.
7. The method for data monitoring and report generation according to any one of claims 1 to 6, further comprising, before the generating of the corresponding record report based on the data stored in the target database at the completion of data acquisition: opening a data interception function, suspending data acquisition, and judging whether a target time period input by a user exists or not; If so, intercepting target data corresponding to the target time period based on the data intercepting function; if not, displaying interception exception, and prompting the user to input correct time period information.
8. A data monitoring and report generating device, characterized by being applied to a data monitoring and report generating system, comprising: The configuration module is used for acquiring acquisition data from a data channel corresponding to the server based on signals acquired by the sensor, and configuring a display format of the acquisition data, information written into a report by the acquisition data and a report format through Excel to generate a configuration file; The acquisition and storage module is used for carrying out initialization operation according to the configuration file, creating a target database, controlling data acquisition through a control button, and storing the acquired data to the target database based on a preset time interval in the data acquisition process; The display and monitoring module is used for generating data blocks with the corresponding quantity of the acquired data, displaying the data blocks, the system operation flow and a numerical trend line graph of the data acquisition points, acquiring data alarm types and alarm values corresponding to the data acquisition points, and monitoring and alarming real-time values of the data acquisition points based on the data alarm types and the alarm values; And the record report generation module is used for generating a corresponding record report based on the data stored in the target database when the data acquisition is completed.
9. An electronic device, comprising: A memory for storing a computer program; a processor for executing the computer program to implement the data monitoring and report generating method according to any one of claims 1 to 7.
10. A computer readable storage medium for storing a computer program, wherein the computer program when executed by a processor implements the data monitoring and report generating method according to any of claims 1 to 7.

Description

Data monitoring and report generating method, device, equipment and storage medium Technical Field The present invention relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a storage medium for data monitoring and report generation. Background The data acquisition and monitoring of the product by the test bed is an essential link in product delivery and new product research and development, and aims to acquire the data of the product running under the specified working condition, and judge whether the product meets the design requirement through the arrangement and analysis of the data. Under ideal conditions, the acquisition equipment is additionally arranged at the designated position of the product, an operator firstly needs to carefully read the test outline to know the threshold value of the measurement point, then regularly checks the monitoring value through the monitor and records the monitoring value in the report, if the measurement value exceeds the threshold value range, the monitoring value needs to be recorded in time so as to find the reason later, but in actual conditions, the operator has limited energy, can not accurately record the acquired data at any time and record the time for generating an alarm in time, so that part of the test has deviation, the test has to be retested, and the money cost and the time cost of the company product are increased. Meanwhile, even if the test is normally completed and the manually filled test record data amount is small, only one approximate judgment can be made, and the conditions of unclear writing, paper defect, archiving and searching are also accompanied. Therefore, how to accurately and timely monitor data and automatically generate reports is a current urgent problem to be solved. Disclosure of Invention Accordingly, the present invention is directed to a method, apparatus, device and storage medium for data monitoring and report generation, which can accurately and immediately monitor data and generate test reports, thereby reducing the labor intensity of first-line operators and reducing the safety and property loss caused by personnel fatigue. The specific scheme is as follows: In a first aspect, the present application discloses a data monitoring and report generating method, applied to a data monitoring and report generating system, comprising: acquiring acquisition data from a data channel corresponding to a server based on signals acquired by a sensor, and configuring a display format of the acquisition data, information of a report written by the acquisition data and a report format through Excel to generate a configuration file; initializing according to the configuration file, creating a target database, controlling data acquisition through a control button, and storing acquired data to the target database based on a preset time interval in the data acquisition process; generating data blocks with the corresponding quantity of the acquired data, displaying the data blocks, the system operation flow and a numerical trend line graph of the data acquisition points, acquiring data alarm types and alarm values corresponding to the data acquisition points, and monitoring and alarming real-time values of the data acquisition points based on the data alarm types and the alarm values; And when the data acquisition is completed, generating a corresponding record report based on the data stored in the target database. Optionally, the acquiring the acquired data from the data channel corresponding to the server based on the signal acquired by the sensor includes: And converting the signals acquired by the sensors through a signal converter, and transmitting the corresponding converted signals to the server based on an Ethernet bus so as to acquire acquired data from a data channel corresponding to the server. Optionally, the display format of the collected data comprises a user name, an alarm type, an alarm threshold, a channel type definition and whether the line diagram needs a drawing switch, the information of the collected data writing report comprises a report single writing information configuration, a report repetition writing information configuration and a report generation auxiliary parameter configuration, and the report format is a format customized based on a user. Optionally, the initializing operation according to the configuration file includes: importing the configuration file, and completing mapping, conversion and state updating operations based on the configuration file. Optionally, the data block includes a name of the data acquisition point, a communication state, an alarm state and a real-time value of the data acquisition point, and the system operation pipeline includes an operation action, an operation time, a position path created by the target database and the record report, a time, a start time, a pause time, a recovery acquisition time, a stop acquisition time, an