Data monitoring and report generation method and device, equipment and storage medium

Abstract

The invention discloses a data monitoring and report generation method and device, equipment and a storage medium, and relates to the technical field of computers, and the method comprises the steps: obtaining collection data from a data channel corresponding to a server based on a signal collected by a sensor, configuring a display format of the collection data, information of writing the collection data into a report, and a report format, generating a configuration file; performing 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 in the data acquisition process; generating data blocks with the number corresponding to that of the collected data, displaying the data blocks, a system operation pipeline and a numerical value trend broken line graph of the data collection points, obtaining data alarm types and alarm values corresponding to the data collection points, and carrying out monitoring alarm on real-time values of the data collection points based on the data alarm types and the alarm values; and when data acquisition is completed, generating a corresponding record report. According to the invention, data testing and recording are realized.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a data monitoring and report generation method, apparatus, device, and storage medium. Background Technology

[0002] Data acquisition and monitoring of products using testing benches is an essential part of product manufacturing and new product development. Its purpose is to obtain data on the product's operation under specified conditions, and to determine whether the product meets design requirements through data processing and analysis. Ideally, data acquisition devices would be installed at designated locations on the product. Operators would first carefully read the test outline to understand the threshold values ​​for measurement points, then periodically check the monitoring values ​​on the monitor and record them in reports. If the measured values ​​exceed the threshold range, they would need to be recorded promptly for subsequent investigation. However, in reality, operators have limited time and energy, making it impossible to record the acquired data accurately and promptly, and to record the time of alarms immediately. This leads to deviations in some tests, necessitating retesting and increasing the company's financial and time costs. Furthermore, even when tests are completed normally, manually entered test records are limited in volume, allowing only a rough assessment, and are often plagued by illegible handwriting, damaged paper, and difficulties in archiving and retrieval. Therefore, how to accurately and promptly monitor data and automatically generate reports is a pressing issue that needs to be addressed. Summary of the Invention

[0003] In view of this, the purpose of this invention is to provide a data monitoring and report generation method, apparatus, device, and storage medium that can accurately and promptly monitor data and generate test reports, thereby reducing the labor intensity of frontline operators and reducing safety and property losses caused by personnel fatigue. The specific solution is as follows:

[0004] In a first aspect, this application discloses a data monitoring and report generation method, applied to a data monitoring and report generation system, comprising:

[0005] Data is acquired from the data channel of the server based on the signals collected by the sensor. The display format of the acquired data, the information for writing the acquired data into the report, and the report format are configured in Excel to generate a configuration file.

[0006] The initialization operation is performed according to the configuration file to create a target database, and the data collection is controlled by the control button. During the data collection process, the collected data is stored in the target database based on a preset time interval.

[0007] Generate a number of data blocks corresponding to the collected data, display the trend line graphs of the data blocks, system operation flow, and data collection points, obtain the data alarm type and alarm value corresponding to each data collection point, and monitor and alarm the real-time value of the data collection point based on the data alarm type and alarm value.

[0008] Upon completion of data collection, a corresponding record report is generated based on the data stored in the target database.

[0009] Optionally, the acquisition of data based on the sensor-collected signal from the corresponding data channel of the server includes:

[0010] The signals collected by the sensor are converted by a signal converter, and the converted signals are sent to the server via an Ethernet bus so that the collected data can be obtained from the data channel of the server.

[0011] Optionally, the display format of the collected data includes user name, alarm type, alarm threshold, channel type definition, and whether the line chart needs to be plotted; the information for writing the collected data into the report includes single report write information configuration, repeated report write information configuration, and report generation auxiliary parameter configuration; the report format is based on a user-defined format.

[0012] Optionally, the initialization operation based on the configuration file includes:

[0013] Import the configuration file and perform mapping, conversion, and status update operations based on the configuration file.

[0014] Optionally, the data block includes the name, communication status, alarm status, and real-time value of the data acquisition point; the system operation log includes operation actions, operation time, the location path and time of the target database and the record report creation, the start time, pause time, resumption time, stop time of data acquisition, alarm time and recovery time of the data acquisition point.

[0015] Optionally, the monitoring and alarming of the real-time values ​​of the data collection points based on the data alarm type and alarm value includes:

[0016] If the real-time value of the data acquisition point exceeds the alarm value, the status of the data acquisition point is changed to an alarm status, and corresponding alarm operations are performed according to the data alarm type. The data acquisition point whose status has changed is then written into the target database.

[0017] Optionally, before generating the corresponding record report based on the data stored in the target database upon completion of data collection, the method further includes:

[0018] Enable the data capture function, pause data collection, and determine if the target time period entered by the user exists.

[0019] If it exists, then the target data corresponding to the target time period is extracted based on the data extraction function;

[0020] If the time period does not exist, an error message will be displayed, and the user will be prompted to enter the correct time period information.

[0021] Secondly, this application discloses a data monitoring and report generation device, applied to a data monitoring and report generation system, comprising:

[0022] The configuration module is used to acquire data from the corresponding data channel of the server based on the signals collected by the sensor, and to configure the display format of the acquired data, the information for writing the acquired data into the report, and the report format through Excel to generate a configuration file;

[0023] The data acquisition and storage module is used to perform initialization operations according to the configuration file, create a target database, and control data acquisition through control buttons. During the data acquisition process, the acquired data is stored in the target database based on a preset time interval.

[0024] The display and monitoring module is used to generate a number of data blocks corresponding to the collected data, display the data blocks, system operation flow and numerical trend line graphs of the data collection points, obtain the data alarm type and alarm value corresponding to each data collection point, and monitor and alarm the real-time value of the data collection point based on the data alarm type and alarm value.

[0025] The record report generation module is used to generate a corresponding record report based on the data stored in the target database when data collection is completed.

[0026] Thirdly, this application discloses a memory for storing computer programs;

[0027] A processor is used to execute the computer program to implement the data monitoring and report generation method described above.

[0028] Fourthly, this application discloses a computer-readable storage medium for storing a computer program, wherein the computer program, when executed by a processor, implements the aforementioned data monitoring and report generation method.

[0029] In this application, the data monitoring and report generation system first acquires data from the corresponding data channel of the server based on signals collected by sensors. It then configures the display format of the acquired data, the information for writing the acquired data into the report, and the report format using Excel, generating a configuration file. Next, it performs initialization operations according to the configuration file, creates a target database, and controls data acquisition via control buttons. During data acquisition, the acquired data is stored in the target database at preset time intervals. Then, it generates a number of data blocks corresponding to the acquired data, displays the data blocks, system operation flow, and numerical trend line graphs of the data acquisition points, obtains the data alarm type and alarm value corresponding to each data acquisition point, and monitors and alarms the real-time values ​​of the data acquisition points based on the data alarm type and alarm value. Finally, when data acquisition is complete, it generates a corresponding record report based on the data stored in the target database. As can be seen, this application, by pre-writing the parameters to be set in an Excel spreadsheet, can automatically complete all pre-experiment configurations by reading the spreadsheet, greatly reducing the operational complexity of data acquisition configuration. Furthermore, it can monitor the status of each acquisition point, clearly identify changes in the status of each acquisition point, and enhance the system's monitoring and alarm capabilities. At the same time, automatically generating records and reports can reduce the labor intensity of front-line operators and reduce safety and property losses caused by personnel fatigue. Attached Figure Description

[0030] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on the provided drawings without creative effort.

[0031] Figure 1 This is a flowchart of a data monitoring and report generation method disclosed in this application;

[0032] Figure 2 This is a schematic diagram of a module relationship disclosed in this application;

[0033] Figure 3 This is a schematic diagram illustrating the structure of a data acquisition module disclosed in this application;

[0034] Figure 4 This is a schematic diagram of one template configuration disclosed in this application;

[0035] Figure 5 This is a schematic diagram of a report output style disclosed in this application;

[0036] Figure 6 This is a schematic diagram of the control flow of a system control module disclosed in this application;

[0037] Figure 7 This application discloses a flowchart of an alarm module monitoring process.

[0038] Figure 8 This is a flowchart of a data storage module disclosed in this application;

[0039] Figure 9 This is a data capture flowchart disclosed in this application;

[0040] Figure 10 This is a schematic diagram of the display content displayed by a display module disclosed in this application;

[0041] Figure 11 This is a schematic diagram of the structure of a data monitoring and report generation device disclosed in this application;

[0042] Figure 12 This is a structural diagram of an electronic device disclosed in this application. Detailed Implementation

[0043] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0044] Currently, when data acquisition devices are installed at designated locations on the product, operators first need to carefully read the test outline to understand the threshold values ​​for each measurement point. They then periodically check the monitored values ​​on a monitor and record them in a report. If the measured value exceeds the threshold range, it needs to be recorded promptly for subsequent investigation. However, in reality, operators have limited time and energy, making it impossible to record the collected data accurately and promptly, and to record the time of alarms immediately. This leads to deviations in some tests, necessitating retesting and increasing the company's financial and time costs. Furthermore, even when tests are completed normally, the manually entered test records are small in volume, allowing only a rough assessment, and are often plagued by illegible handwriting, damaged paper, and difficulties in archiving and retrieval. To address these technical problems, this application discloses a data monitoring and report generation method that can accurately and promptly monitor data and generate test reports, thereby reducing the workload of frontline operators and minimizing safety and property losses caused by personnel fatigue.

[0045] See Figure 1 As shown, this embodiment of the invention discloses a data monitoring and report generation method, applied to a data monitoring and report generation system, including:

[0046] Step S11: Based on the signals collected by the sensors, acquire the collected data from the corresponding data channel of the server, and configure the display format of the collected data, the information for writing the collected data into the report, and the report format through Excel to generate a configuration file.

[0047] In this embodiment, the data monitoring and report generation system includes a data acquisition module, a data receiving module, a system control module, a data storage module, a data alarm module, a display module, and a data processing module, whose relationships are as follows: Figure 2 As shown, the data acquisition module obtains the raw data and sends it to the system control module via the receiving module as the data processing and transmission channel. The system control module processes the data uniformly and distributes it to the subsequent four modules. Firstly, during data acquisition, a signal converter transforms the signals collected by the sensors. The transformed signals are then sent to the server via an Ethernet bus to retrieve the acquired data from the server's corresponding data channel. Specifically, the data acquisition module is structured as follows: Figure 3 As shown, the system integrates sensors, signal converters, data acquisition units, and an Ethernet bus into a single acquisition box. The sensors acquire resistance signals, which are converted into current signals by the signal converter. The data acquisition unit identifies the analog current signal connected to the corresponding channel, converts the analog signal into a digital signal, and sends it to the computer via the Ethernet bus. The raw sensor signal is converted and sent to the data acquisition unit, which then converts the signal again and sends it to the OPC (Object Linking and Embedding for Process Control) server via the Ethernet bus. The monitoring system / OPC client then obtains the necessary data from the server. The OPC server and monitoring system reside within the same terminal and exchange data via the OPC protocol. The OPC client is integrated into the monitoring system and serves as a fundamental component for its functionality. This approach utilizes the Ethernet bus for data transmission using the common TCP / IP (Transmission Control Protocol / Internet Protocol) protocol. In scenarios where multiple data acquisition units from different manufacturers are simultaneously connected to the OPC server, using a unified protocol format facilitates standardized template creation, allowing technicians to perform non-hardware operations without needing to know the specific hardware model. Meanwhile, using the OPC server / client model, the server will dynamically update all mapped channels in the collectors connected to the terminal via the Ethernet bus. If subsequent experiments require the system to use channel data from multiple collectors due to a number of collectors exceeding the number of a single collector, the corresponding channel of the server can simply be written into the template configuration.

[0048] This application configures the display format of the collected data, the information for writing the collected data into the report, and the report format using Excel. First, it should be noted that the data acquisition module is the hardware part of the entire system for data acquisition, while the data receiving module is the part for data transmission and system initialization configuration. The TCP communication function is a communication function using an Ethernet bus between the collector and the OPC server, sending data to the corresponding mapped channel on the server via IP address. The OPC communication function enables data transmission between the OPC server and the monitoring system. The monitoring system can obtain data from the mapped channel in real time from the server as needed for subsequent system processing. The template configuration function enables rapid initialization of the monitoring system. Its file is an Excel file with a fixed format, which can be easily written according to requirements with simple learning. The content of the template configuration function is as follows: Figure 4 As shown, the template configuration is used for system parameter configuration. The display format of the collected data includes the user name, alarm type, alarm threshold, channel type definition, and whether the line chart needs to be plotted. The information for writing collected data to the report includes configuration for single report write information, repeated report write information, and auxiliary parameters for report generation. The report format is based on a user-defined format. Specifically, the template configuration is mainly divided into three parts:

[0049] The first part is the parameter mapping configuration for the acquisition points. Its purpose is to implement the data channels on the server required for the monitoring system connection and to configure the presentation style of the acquired data from these channels in the system. This includes the user name, alarm type, alarm threshold, channel type definition, and whether the line graph needs to be plotted. For example: the required channel name on the server is "A Brand TCP / IP Connection.192-168-2-1.AIW16", the user name is "#1 Input Bearing", the alarm type is 21, the alarm value is 75, the variable type is 1, and the line graph plotting switch is 1. Connecting to the "A Brand TCP / IP Connection.192-168-2-1.AIW18" channel on the server, the monitoring system displays this channel as "#1 Input Bearing". If the sensor value is greater than a floating-point value of 75, an alarm is generated. This channel uses the temperature sensor processing method for conversion and display, and this channel allows plotting line graphs.

[0050] The second part consists of configurations for single-write information, repeated-write information, and auxiliary parameters for report generation. Single-write information configuration refers to information that is repeatedly input and used in the report, such as test name, serial number, and product model. This mainly configures the content to be written and its position in the report. Repeated-write information configuration specifies the configuration information for writing collected data to the report at fixed time intervals, indicating the position of the first value entered in the report. The auxiliary parameter configuration function assists with repeated-write information. The interval output time indicates the time interval between two adjacent lines of collected data entered in the report, and the maximum number of report data lines refers to the maximum number of lines of collected data that can be entered on a single report page. If this number is exceeded, the data will be automatically entered again at the first line position on the next page.

[0051] The third part is the report template, which is the final format of the generated report. This report template can be customized into various formats according to user needs, but it should be noted that the report must at least have a corresponding field for the "Repeated Report Input" configuration, and it must be ensured that data collected at the same time in the designed report template are on the same data line. For example, if data is collected at 1-minute intervals, the data collected at 11:20:13 (11:20:13) is 13.5 for "#1" and 9.1 for "#2"; and at 11:21:13 (11:21:13) the data collected at "#1" is 13.1 and "#2" is 9.9. The final output format must be as follows: Figure 5 As shown.

[0052] Step S12: Perform initialization operations according to the configuration file, create a target database, and control data collection through control buttons. During the data collection process, store the collected data into the target database based on a preset time interval.

[0053] In this embodiment, the completed template configuration file is imported into the monitoring system according to the description in the previous step. The system will then automatically complete the mapping, conversion, and status update functions based on the configuration, i.e., perform the initialization operation. Therefore, the template configuration function is written in Excel, reducing the difficulty and time of configuring experimental parameters. This allows designers to write experimental configuration information without much programming knowledge, and allows users to use the system simply by filling in some basic information without worrying about the specific parameter settings.

[0054] In this embodiment, since each module in the system has its own specific function to implement business operations, but the timing for starting and stopping these operations cannot be set, this module uses buttons controlled by the operator as triggers to ensure that the business functions of each module operate according to design requirements. This function also includes enabling and disabling the logical sequence of buttons controlled by the interface; for example, without importing the configuration template, the corresponding button for data acquisition cannot be enabled, and clicking the pause button without resuming acquisition will not stop acquisition, etc. Data is sent from the receiving module, and its destination is the final four modules (storage, alarm, display, and processing). These modules have different functions, therefore their data input formats and triggering times are also different. Data from the receiving module cannot be directly sent to each module; it must be processed by the control module before being distributed. Therefore, the system control module, as... Figure 6 As shown, a target database is created, and data collection is controlled by control buttons. During the data collection process, the collected data is stored in the target database based on a preset time interval.

[0055] Step S13: Generate the number of data blocks corresponding to the collected data, display the trend line graph of the data blocks, system operation flow, and data collection points, obtain the data alarm type and alarm value corresponding to each data collection point, and monitor and alarm the real-time value of the data collection point based on the data alarm type and alarm value.

[0056] In this embodiment, after the database is established, a corresponding number of data blocks are generated. Then, the data blocks, system operation logs, and line charts showing the numerical trends of the data collection points are displayed. Each data block includes the name, communication status, alarm status, and real-time value of the data collection point. The system operation log includes the operation action, operation time, target database, location path and time of record report creation, start time, pause time, resumption time, stop time, alarm time, and recovery time of the data collection point.

[0057] Meanwhile, the data monitoring and report generation system in this application also includes a data alarm module, whose function is to add an automatic monitoring and alarm function to each data collection point of the system. It acquires the data alarm type and alarm value corresponding to each data collection point, and monitors and alarms the real-time values ​​of the data collection points based on the data alarm type and alarm value. The monitoring work of the alarm module is as follows: Figure 7As shown, after system initialization, the system obtains the alarm type and alarm value for each parameter at the acquisition point. The essence of status updating is to cyclically scan the real-time values ​​of the acquisition points. If the value exceeds the alarm range, the acquisition point's status changes from normal to alarm until it returns to the range. The linked data storage module writes the acquisition points whose status has changed into the database. In actual testing scenarios, testing normally continues until the test ends. Scenarios requiring pauses often involve handling unexpected events that don't significantly impact the overall test and cause failure. For example, if individual sensors fall off or are damaged, requiring repositioning and continued measurement, the test point is in an unstable state, and whether it exceeds the alarm range is irrelevant. The monitoring pause function stops status updates while retaining data refresh functionality. This allows monitoring of the status of each acquisition point, and any change in the status (alarm or recovery) of any acquisition point is recorded in the system. Simultaneously, monitoring pause provides operators with the ability to handle special situations during testing, preventing unstable signals generated during handling from affecting the user's judgment of the tested product's condition.

[0058] Step S14: When data acquisition is completed, generate a corresponding record report based on the data stored in the target database.

[0059] In this embodiment, the workflow of the data storage module is as follows: Figure 8 As shown, the system operates within a data acquisition loop. Pressing the pause and stop buttons halts the process. Initially, a database is established according to the set template. During the loop writing phase, as long as data acquisition is not stopped or paused, the system writes the current time value of each acquisition point to the database once per second. Note: Regular database writing (once per second) and status change monitoring point writing (related to the alarm module) are executed in parallel. In special operation writing (performing data acquisition pause and resume operations), the first two types of writing are not executed between a pair of operation commands (referring to the pause-resume sequence). Therefore, the selection of once per second for data acquisition parameter writing considers the type of physical quantity being acquired and the data processing capacity of the terminal. The temperature and pressure changes of the measured objects on the test bench are not rapid. For temperature, even under the most severe test conditions, changes within a 1°C range are calculated in minutes. The pressure measurement object is oil pressure, which is typically a stable value. Only when the oil temperature rises to a certain level and the viscosity of the lubricating oil decreases, resulting in smoother flow and a pressure decrease, will the pressure change. Furthermore, storing data once per second for the current number of acquisition points does not place a significant load on the terminal, allowing the software to be applied to terminals that do not require high performance.

[0060] In addition, the header style for writing the collected parameters into the table is shown in Table 1:

[0061] Table 1

[0062]

[0063] The status change is written as a record of any monitored acquisition parameter exceeding the set alarm range or returning to the range. countID is the cumulative number of acquisitions, timeData is the acquisition time of this row, and the next two columns are a pair. The first column is the data of this acquisition point at this moment, and the second column is a flag indicating whether the signal connection of this acquisition point is normal.

[0064] The status change is recorded in the table, and its header is shown in Table 2:

[0065] Table 2

[0066]

[0067] Comparing parameter writing to the table and status change writing to the table, it can be seen that the former's single-row data length increases with the increase of the collected parameters, allowing for a more comprehensive view of the collected data status; the latter's single-row data length is fixed, using countID to quickly locate the row position of the status change in the parameter writing table, timeData to display the time of the row, the collection point name to indicate which collection point changed, facilitating quick location of the column position in the parameter writing table, setting the alarm value to the alarm value written by the collection point in this test, the current value to the value of the collection point when the alarm was generated, and the status to indicate whether the operation that generated the data in this row was an alarm or an alarm triggered.

[0068] The special operation write function is designed to handle unexpected situations during testing that have little impact on the overall experiment. Shielding data from handling these unexpected situations allows for more consistent data collection. This function also provides characteristic markers for various functions in the data processing module, enabling the system to skip data segments in this table during automatic data processing.

[0069] Special operations are entered into a table, and its header is shown in Table 3:

[0070] Table 3

[0071]

[0072] The usage of countID and tmeData is the same as that of the state change table, with the operation type distinguishing whether the data behavior that caused the operation is paused or resumed.

[0073] In this embodiment, the data processing module includes a data extraction function and an automatic report generation function. The data extraction function must be executed during the data acquisition process; it disables once acquisition stops. The automatic report generation function is generally used when the system stops acquisition by pressing the stop button, automatically generating a report in a specified folder. To handle special cases where automatic report generation fails, this function can also generate a report by manually selecting a database and report template. The workflow of the data extraction function is as follows: Figure 9 As shown, the user data capture function extracts the start and end times. This function automatically determines whether these two points exist (i.e., whether they exist in the database as parameters written to the table) and whether the input is correct. If they don't exist or are incorrect, the user will be prompted to enter the correct data in the operation log display. If the input is correct, the data between the two points (including the two points) will be automatically printed in an Excel file in the format specified in the parameter table and placed in a designated folder. In other words, when the data capture function is enabled, data collection is paused, and it checks whether the target time period entered by the user exists. If it exists, the target data corresponding to the target time period is captured based on the data capture function; if it does not exist, a capture error is displayed, and the user is prompted to enter the correct time period information.

[0074] The automatic report generation function is generally divided into three main parts: initialization, filtering, and writing. Initialization imports the report generation settings from the template. Filtering reads parameters from the database and writes them into a table. A special table is used in conjunction with the parameters read during initialization to filter the necessary rows of data. Writing further processes the filtered rows and writes them into the report template, outputting them to a specified folder according to regulations. In other words, upon completion of data collection, a corresponding record report is generated based on the data stored in the target database. It should be noted that reports can be generated based on user-customized templates. This allows for the automatic generation of test record reports after testing, resulting in more accurate and realistic data. Compared to the existing method of manually reviewing and recording data, this improves work efficiency. The format is already adjusted during the template setup stage, and the generated report can be printed directly without any adjustments.

[0075] In summary, the data monitoring and report generation system in this application first acquires data from the corresponding data channel of the server based on the signals collected by sensors. It then configures the display format of the acquired data, the information for writing the acquired data into the report, and the report format using Excel to generate a configuration file. Next, it performs initialization operations according to the configuration file, creates a target database, and controls data acquisition via control buttons. During data acquisition, the acquired data is stored in the target database at preset time intervals. Then, it generates a number of data blocks corresponding to the acquired data, displays the data blocks, system operation flow, and numerical trend line graphs of the data acquisition points, obtains the data alarm type and alarm value corresponding to each data acquisition point, and monitors and alarms the real-time values ​​of the data acquisition points based on the data alarm type and alarm value. Finally, when data acquisition is complete, it generates a corresponding record report based on the data stored in the target database. It is evident that this application, by pre-writing the parameters to be set in an Excel spreadsheet, can automatically complete all pre-test configurations by reading the spreadsheet, greatly reducing the operational complexity of data acquisition configuration. Furthermore, it can monitor the status of each acquisition point, clearly identify changes in the status of each acquisition point, and enhance the system's monitoring and alarm capabilities. At the same time, automatically generating records and reports can reduce the labor intensity of front-line operators and reduce safety and property losses caused by personnel fatigue.

[0076] As can be seen from the previous embodiment, this application can display line graphs showing the numerical trends of data blocks, system operation flows, and data acquisition points. The specific display content will be described below.

[0077] like Figure 10 As shown, the display module mainly consists of three parts:

[0078] The purpose of the operation log display is to record the operator's actions and times within the system, the location and time of files read by the system, the location and time of creating series folders (containing the database, extracted data, and reports for a single experiment), the start time of data acquisition, the time of pausing and resuming acquisition, the time of stopping acquisition, the time of alarms and recovery at acquisition points, etc. When the system is not closed, the historical records can be scrolled up and down. After closing the monitoring system software, it is automatically saved as a notepad file containing the experiment name and corresponding time for later archiving and retrieval. This facilitates the review and archiving of the overall system operation.

[0079] Data block display refers to creating a module from the information needed for monitoring a single data acquisition point. This module is dynamically generated after configuration; for example, monitoring eight parameters would generate eight data blocks. Each data block contains the data acquisition point's name, communication status, alarm status, and real-time value. When the point's status is abnormal, its alarm light turns red, providing a more convenient and intuitive understanding of the current status of all parameters, facilitating monitoring and testing by on-site operators. Furthermore, integrating the information monitored from various data acquisition points together allows on-site operators to better understand the data.

[0080] The line chart can simultaneously display the trend of up to 8 data points over a 2-hour period. When the recorded trend curve exceeds 2 hours, each update shifts all points one grid to the left and writes the current value of the data point to the rightmost position of the image, achieving a translational update effect. The line chart supports zooming for overall and partial data monitoring. It also provides a 2-hour historical data review function. Clicking anywhere on the image automatically generates a vertical dashed line perpendicular to the horizontal axis (time axis), displays the time at that point on the row axis, and shows the data point's value in a view window within the system.

[0081] As can be seen, this application facilitates the review and archiving of the overall system operation through a workflow display. Data block display integrates the information that needs to be monitored at each collection point, allowing on-site operators to have a detailed understanding of the data. Line graph display provides the function of monitoring the trend changes of the collection points, enabling real-time understanding of the changes in the collection points during the monitoring process. It also provides historical data review and zoom-in / zoom-out functions within 2 hours, allowing for viewing of specific local values ​​while monitoring the overall picture.

[0082] See Figure 11 As shown, this embodiment of the invention discloses a data monitoring and report generation device, applied to a data monitoring and report generation system, comprising:

[0083] Configuration module 11 is used to acquire data from the data channel corresponding to the server based on the signal collected by the sensor, and to configure the display format of the acquired data, the information for writing the acquired data into the report, and the report format through Excel to generate a configuration file;

[0084] The acquisition and storage module 12 is used to perform initialization operations according to the configuration file, create a target database, and control the acquisition of data through control buttons. During the data acquisition process, the acquired data is stored in the target database based on a preset time interval.

[0085] The display and monitoring module 13 is used to generate a number of data blocks corresponding to the collected data, display the data blocks, system operation flow and numerical trend line graphs of the data collection points, obtain the data alarm type and alarm value corresponding to each data collection point, and monitor and alarm the real-time value of the data collection point based on the data alarm type and alarm value.

[0086] The record report generation module 14 is used to generate a corresponding record report based on the data stored in the target database when the data collection is completed.

[0087] In summary, the data monitoring and report generation system in this application first acquires data from the corresponding data channel of the server based on the signals collected by sensors. It then configures the display format of the acquired data, the information for writing the acquired data into the report, and the report format using Excel to generate a configuration file. Next, it performs initialization operations according to the configuration file, creates a target database, and controls data acquisition via control buttons. During data acquisition, the acquired data is stored in the target database at preset time intervals. Then, it generates a number of data blocks corresponding to the acquired data, displays the data blocks, system operation flow, and numerical trend line graphs of the data acquisition points, obtains the data alarm type and alarm value corresponding to each data acquisition point, and monitors and alarms the real-time values ​​of the data acquisition points based on the data alarm type and alarm value. Finally, when data acquisition is complete, it generates a corresponding record report based on the data stored in the target database. It is evident that this application, by pre-writing the parameters to be set in an Excel spreadsheet, can automatically complete all pre-test configurations by reading the spreadsheet, greatly reducing the operational complexity of data acquisition configuration. Furthermore, it can monitor the status of each acquisition point, clearly identify changes in the status of each acquisition point, and enhance the system's monitoring and alarm capabilities. At the same time, automatically generating records and reports can reduce the labor intensity of front-line operators and reduce safety and property losses caused by personnel fatigue.

[0088] In some specific embodiments, the configuration module 11 may specifically include:

[0089] The signal transmitting unit is used to convert the signals collected by the sensor through a signal converter, and send the corresponding converted signals to the server based on the Ethernet bus so as to obtain the collected data from the data channel corresponding to the server.

[0090] In some specific embodiments, the acquisition and storage module 12 may specifically include:

[0091] The configuration file import unit is used to import the configuration file and perform mapping, conversion and status update operations based on the configuration file.

[0092] In some specific embodiments, the display and monitoring module 13 may specifically include:

[0093] The status change unit is used to change the status of the data acquisition point to an alarm status if the real-time value of the data acquisition point exceeds the alarm value, so as to perform corresponding alarm operations according to the data alarm type, and write the data acquisition point whose status has changed to the target database.

[0094] In some specific embodiments, the apparatus may further include:

[0095] The judgment module is used to enable the data capture function, pause data collection, and determine whether the target time period input by the user exists.

[0096] The first judgment result execution module is used to extract the target data corresponding to the target time period based on the data extraction function if the data exists.

[0097] The second judgment result execution module is used to display a truncation exception if the condition does not exist, and prompt the user to input the correct time period information.

[0098] Furthermore, embodiments of this application also disclose an electronic device, Figure 12 This is a structural diagram of an electronic device 20 according to an exemplary embodiment. The content of the diagram should not be construed as limiting the scope of this application.

[0099] Figure 12 This is a schematic diagram of the structure of an electronic device 20 provided in an embodiment of this application. Specifically, the electronic device 20 may include: at least one processor 21, at least one memory 22, a power supply 23, a communication interface 24, an input / output interface 25, and a communication bus 26. The memory 22 stores a computer program, which is loaded and executed by the processor 21 to implement the relevant steps in the data monitoring and report generation method disclosed in any of the foregoing embodiments. Furthermore, the electronic device 20 in this embodiment may specifically be an electronic computer.

[0100] In this embodiment, the power supply 23 is used to provide operating voltage for each hardware device on the electronic device 20; the communication interface 24 can create a data transmission channel between the electronic device 20 and external devices, and the communication protocol it follows can be any communication protocol applicable to the technical solution of this application, and is not specifically limited here; the input / output interface 25 is used to acquire external input data or output data to the outside world, and its specific interface type can be selected according to specific application needs, and is not specifically limited here.

[0101] In addition, the memory 22, as a carrier for resource storage, can be a read-only memory, random access memory, disk, or optical disk, etc. The resources stored thereon can include an operating system 221, computer programs 222, etc., and the storage method can be temporary storage or permanent storage.

[0102] The operating system 221 is used to manage and control the various hardware devices on the electronic device 20 and the computer program 222, which may be Windows Server, Netware, Unix, Linux, etc. In addition to including computer programs capable of performing the data monitoring and report generation method executed by the electronic device 20 as disclosed in any of the foregoing embodiments, the computer program 222 may further include computer programs capable of performing other specific tasks.

[0103] Furthermore, this application also discloses a computer-readable storage medium for storing a computer program; wherein, when the computer program is executed by a processor, it implements the aforementioned disclosed data monitoring and report generation method. Specific steps of this method can be found in the corresponding content disclosed in the foregoing embodiments, and will not be repeated here.

[0104] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on its differences from other embodiments. Similar or identical parts between embodiments can be referred to interchangeably. For the apparatus disclosed in the embodiments, since it corresponds to the method disclosed in the embodiments, the description is relatively simple; relevant parts can be referred to in the method section.

[0105] Those skilled in the art will further recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the components and steps of the various examples have been generally described in terms of functionality in the foregoing description. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this application.

[0106] The steps of the methods or algorithms described in conjunction with the embodiments disclosed herein can be implemented directly by hardware, a software module executed by a processor, or a combination of both. The software module can be located in random access memory (RAM), main memory, read-only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, removable disk, CD-ROM, or any other form of storage medium known in the art.

[0107] Finally, it should be noted that in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

[0108] The technical solutions provided in this application have been described in detail above. Specific examples have been used to illustrate the principles and implementation methods of this application. The descriptions of the above embodiments are only for the purpose of helping to understand the methods and core ideas of this application. At the same time, for those skilled in the art, there will be changes in the specific implementation methods and application scope based on the ideas of this application. Therefore, the content of this specification should not be construed as a limitation of this application.

Claims

1. A data monitoring and report generation method, characterized in that, Applications include data monitoring and report generation systems, including: Data is acquired from the data channel of the server based on the signals collected by the sensor. The display format of the acquired data, the information for writing the acquired data into the report, and the report format are configured in Excel to generate a configuration file. The initialization operation is performed according to the configuration file to create a target database, and the data collection is controlled by the control button. During the data collection process, the collected data is stored in the target database based on a preset time interval. Generate a number of data blocks corresponding to the collected data, display the trend line graphs of the data blocks, system operation flow, and data collection points, obtain the data alarm type and alarm value corresponding to each data collection point, and monitor and alarm the real-time value of the data collection point based on the data alarm type and alarm value. Upon completion of data collection, a corresponding record report is generated based on the data stored in the target database.

2. The data monitoring and report generation method according to claim 1, characterized in that, The data acquired from the sensor-collected signals is obtained from the corresponding data channel of the server, including: The signals collected by the sensor are converted by a signal converter, and the converted signals are sent to the server via an Ethernet bus so that the collected data can be obtained from the data channel of the server.

3. The data monitoring and report generation method according to claim 1, characterized in that, The display format of the collected data includes user name, alarm type, alarm threshold, channel type definition, and whether the line chart needs to be plotted; the information for writing the collected data into the report includes single report write information configuration, repeated report write information configuration, and report generation auxiliary parameter configuration; the report format is based on a user-defined format.

4. The data monitoring and report generation method according to claim 1, characterized in that, The initialization operation based on the configuration file includes: Import the configuration file and perform mapping, conversion, and status update operations based on the configuration file.

5. The data monitoring and report generation method according to claim 1, characterized in that, The data block includes the name, communication status, alarm status, and real-time value of the data acquisition point; the system operation log includes operation actions, operation time, the location path and time of the target database and the creation of the record report, the start time, pause time, resumption time, stop time of data acquisition, alarm time and recovery time of the data acquisition point.

6. The data monitoring and report generation method according to claim 1, characterized in that, The monitoring and alarming of the real-time values ​​of the data collection points based on the data alarm type and alarm value includes: If the real-time value of the data acquisition point exceeds the alarm value, the status of the data acquisition point is changed to an alarm status, and corresponding alarm operations are performed according to the data alarm type. The data acquisition point whose status has changed is then written into the target database.

7. The data monitoring and report generation method according to any one of claims 1 to 6, characterized in that, Before generating a corresponding record report based on the data stored in the target database upon completion of data collection, the process further includes: Enable the data capture function, pause data collection, and determine if the target time period entered by the user exists. If it exists, then the target data corresponding to the target time period is extracted based on the data extraction function; If the time period does not exist, an error message will be displayed, and the user will be prompted to enter the correct time period information.

8. A data monitoring and report generation device, characterized in that, Applications include data monitoring and report generation systems, including: The configuration module is used to acquire data from the corresponding data channel of the server based on the signals collected by the sensor, and to configure the display format of the acquired data, the information for writing the acquired data into the report, and the report format through Excel to generate a configuration file; The data acquisition and storage module is used to perform initialization operations according to the configuration file, create a target database, and control data acquisition through control buttons. During the data acquisition process, the acquired data is stored in the target database based on a preset time interval. The display and monitoring module is used to generate a number of data blocks corresponding to the collected data, display the data blocks, system operation flow and numerical trend line graphs of the data collection points, obtain the data alarm type and alarm value corresponding to each data collection point, and monitor and alarm the real-time value of the data collection point based on the data alarm type and alarm value. The record report generation module is used to generate a corresponding record report based on the data stored in the target database when data collection is completed.

9. An electronic device, characterized in that, include: Memory, used to store computer programs; A processor for executing the computer program to implement the data monitoring and report generation method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, Used to store a computer program, wherein the computer program, when executed by a processor, implements the data monitoring and report generation method as described in any one of claims 1 to 7.

Images