Intelligent management system for expansion and contraction measurement data

Abstract

The present application belongs to the field of data management and measurement, in particular to a smart management system for expansion and contraction measurement data, comprising a data acquisition unit, a smart data recognition and automatic matching module, a data reorganization module, a code scanner automatic recognition and folder smart creation unit, a multi-thread asynchronous processing unit, a multi-channel smart notification unit, an Excel data smart storage and merging processing unit, a network fault tolerance and error recovery module and a user permission management module. The present application is rationally designed, automatically matches six kinds of measurement data processing rules through a smart data recognition algorithm, realizes automatic data extraction and standardized storage, realizes the smart creation of network folders in combination with the automatic recognition technology of the code scanner, ensures the system response speed by adopting a multi-thread asynchronous architecture, and realizes real-time information synchronization by integrating a multi-channel notification mechanism. The system significantly improves the data processing efficiency and management level, and is suitable for the measurement data management of the mechanical manufacturing, mold processing and other industries.

Description

Technical Field

[0001] This invention relates to the field of data management and measurement technology, and in particular to an intelligent management system for expansion and contraction measurement data. Background Technology

[0002] In industries such as machinery manufacturing, mold processing, and PCB manufacturing, expansion and contraction measurement is a critical step in quality control. Currently, the industry generally suffers from the following technical deficiencies: Low data collection efficiency: Surveyors record data manually and summarize it on paper or in Excel, which is prone to data entry errors and omissions; Insufficient standardization in data processing: Data formats vary depending on the number of measuring holes and diagonal data, and there is no unified processing standard, making analysis difficult; Dispersed data management: Data is scattered across multiple files and devices, lacking centralized management and effective backup, and security and integrity cannot be guaranteed; Delayed information transmission: Manual notification of relevant personnel results in delayed response, affecting the timeliness of production decisions; Disorganized folder management: Manual creation is prone to problems such as incorrect naming and incorrect paths; This results in problems such as poor versatility of single data processing software, separation of folder management tools from data systems, reliance on email for notifications, insufficient real-time performance, low overall system integration, and insufficient automation and intelligence, making it difficult to adapt to the needs of modern intelligent manufacturing. Therefore, we propose an intelligent management system for expansion and contraction measurement data to solve the above problems. Summary of the Invention

[0003] The purpose of this invention is to address the shortcomings of existing technologies by proposing an intelligent management system for expansion and contraction measurement data.

[0004] To achieve the above objectives, the present invention adopts the following technical solution: The intelligent management system for expansion and contraction measurement data includes: a data acquisition unit, an intelligent data identification and automatic matching module, a data reorganization module, a barcode scanner automatic identification and intelligent folder creation unit, a multi-threaded asynchronous processing unit, a multi-channel intelligent notification unit, an Excel data intelligent storage and merging processing unit, a network fault tolerance and error recovery module, and a user permission management module. The data acquisition unit receives material number information input from the barcode scanner, imports and reads raw measurement data in CSV format, and automates the acquisition of measurement data and material identification. The intelligent data recognition and automatic matching module incorporates intelligent recognition and automatic matching algorithms, enabling real-time reading of expansion and contraction measurement data in CSV format, automatic calculation of the total data volume in the CSV file, and automatic matching of corresponding measurement data processing rules based on the data volume. The data reconstruction module standardizes and reconstructs the measurement data processed by the intelligent data recognition and automatic matching module, converting non-standardized raw data into standardized data in a unified format. The barcode scanner automatic recognition and intelligent folder creation unit listens to the barcode scanner input signal, automatically recognizes the material number, verifies character validity, connects to the network shared path, and automatically creates standardized storage folders according to the "month-day" date rule and material number, achieving one-click association creation of material and data directories. Multi-threaded... The step processing unit employs a thread-separated design to ensure the system maintains good responsiveness when processing large amounts of expansion and contraction measurement data, preventing interface lag. The multi-channel intelligent notification unit automatically sends email notifications via the enterprise SMTP server after successful data processing and sends real-time messages to WeChat / DingTalk robots via a Webhook interface, enabling synchronized push of processing results across multiple platforms and terminals. The Excel data intelligent storage and merging processing unit features dynamic column mapping, intelligent merging of cells, and a dual backup mechanism. The network fault tolerance and error recovery module monitors anomalies in network connection, file access, permission verification, data writing, and notification sending, and executes a three-level retry recovery mechanism. The user permission management module configures multi-level user roles and operation permissions, enabling user account management, function access control, operation log recording, and data security protection, ensuring that different roles use the system according to their permissions.

[0005] Preferably, the measurement data processing rules include: Rule 1: 4 data points correspond to the measurement of 1 hole; Rule 2: 8 data points correspond to the measurement of 2 holes; Rule 3: 12 data points correspond to the measurement of 3 holes; Rule 4: 7 data points correspond to the measurement of 1 hole plus a diagonal line; Rule 5: 14 data points correspond to the measurement of 2 holes plus a diagonal line; Rule 6: 21 data points correspond to the measurement of 3 holes plus a diagonal line; all rules are output to Excel according to a fixed column mapping.

[0006] Preferably, the process of the intelligent identification and automatic matching algorithm includes: selecting a CSV file, reading the column data of the CSV file, extracting non-empty numerical data, counting the number of valid data N, determining whether N is greater than or equal to 4, if yes, proceeding to intelligent rule matching, otherwise determining insufficient data and terminating the processing; matching the corresponding processing rules according to the number of numerical values ​​N, where N equals 4 corresponds to rule 1 for measuring 1 hole, N equals 7 corresponds to rule 4 for measuring 1 hole plus diagonal, N equals 8 corresponds to rule 2 for measuring 2 holes, N equals 12 corresponds to rule 3 for measuring 3 holes, N equals 14 corresponds to rule 5 for measuring 2 holes plus diagonal, and N equals 21 corresponds to rule 6 for measuring 3 holes plus diagonal; performing data recombination and swapping operations between short side 1 and short side 2, implementing data standardization processing, filling the corresponding columns in Excel according to the rules, saving to Excel and generating a backup file, updating statistical data, sending a processing completion notification, and ending the processing flow, thereby realizing the automatic identification, matching, and standardization processing of different measurement types of data.

[0007] Preferably, the automatic barcode scanner identification and intelligent folder creation module includes: a keyboard event monitoring module, a network path dynamic management module, and a material number standardization processing module. The keyboard event monitoring module monitors barcode scanner input in real time and determines scanning completion based on time intervals. The network path dynamic management module automatically connects to a shared network path and creates date folders in "month-day" format. The material number standardization processing module automatically removes illegal characters to ensure folder naming conforms to Windows standards.

[0008] Preferably, the multi-threaded asynchronous processing unit includes: a main thread module, a data processing thread module, a network monitoring thread module, and a notification sending thread module. The main thread module is responsible for GUI rendering and user interaction; The data processing thread module is used for CSV parsing and Excel operations; the network monitoring thread module checks the network connection status in real time; and the notification sending thread module sends email and WeChat notifications synchronously.

[0009] Preferably, the multi-channel intelligent notification unit includes: a technical feature module, an email notification module, a WeChat or DingTalk notification module, and a conditional trigger module. The technical feature module integrates email notifications and WeChat / DingTalk robot notifications, supporting: an email notification module that automatically sends processing results via the enterprise SMTP server; a WeChat or DingTalk notification module that sends real-time notifications via a Webhook interface; and a conditional trigger module that sends notifications only when data processing is successful.

[0010] Preferably, the Excel data intelligent storage and merging processing unit comprises a dynamic column mapping module, a cell merging intelligent processing module, and a dual backup mechanism module. The dynamic column mapping module automatically adjusts the Excel column structure based on data type; the cell merging intelligent processing module automatically merges date, model, and status columns for the same batch of data; and the dual backup mechanism module automatically creates backup files while saving the main file.

[0011] Preferably, the network fault tolerance and error recovery module implements a three-level retry mechanism, including performing network checks during normal system operation; if a connection fails, a three-level retry is triggered: first, an immediate retry; second, a retry after 3 seconds; and third, a retry after 5 seconds. If the retry fails, the user is prompted to check. If file access fails, a second retry is performed after 3 seconds. If there are issues such as insufficient permissions, file locking, or incorrect paths, a third retry is performed after 5 seconds. If data processing verification fails, it is re-verified; if the data is invalid, it is transferred to manual processing. If Excel writes are abnormal, format repair or backup recovery is performed. If a notification fails, it is retried for sending; if the final failure occurs, an emergency alarm is triggered.

[0012] The beneficial effects of this invention are: 1. Data processing efficiency improved by over 97%: The process shifted from manual to automatic, reducing the processing time for a single batch of data from 15 minutes to within 30 seconds; Folder creation efficiency improved by 75%: Automatic creation by barcode scanners replaced manual creation, reducing the creation time for a single folder from 20 seconds to 5 seconds; Notification sending efficiency improved by 75%: Automatic multi-channel notifications replaced manual notifications, reducing notification time from 2 minutes to within 30 seconds. 2. Eliminate manual data entry errors, ensure data source accuracy, avoid data reconstruction errors through intelligent algorithms, and ensure no data loss through a dual backup mechanism; 3. Improved management efficiency: Standardized management enables unified format storage of measurement data, facilitating data traceability and analysis; real-time network path monitoring ensures system availability; and access control and multi-level user access management ensure data security. 4. Saves on labor costs, reducing the need for dedicated data processing personnel; saves on time costs, significantly shortening data processing and notification time; saves on error costs, avoiding quality problems and rework costs caused by data errors. Attached Figure Description

[0013] Figure 1 This is a block diagram of the intelligent management system for expansion and contraction measurement data proposed in this invention; Figure 2 This is a block diagram of the barcode scanner automatic identification and folder intelligent creation unit of the intelligent management system for expansion and contraction measurement data proposed in this invention; Figure 3 This is a block diagram of the multi-threaded asynchronous processing unit of the intelligent management system for expansion and contraction measurement data proposed in this invention; Figure 4 This is a block diagram of the multi-channel intelligent notification unit of the intelligent management system for expansion and contraction measurement data proposed in this invention; Figure 5 This is a block diagram of the Excel data intelligent storage and merging processing unit of the intelligent management system for expansion and contraction measurement data proposed in this invention; Figure 6 This is a flowchart of the intelligent data matching algorithm of the intelligent management system for expansion and contraction measurement data proposed in this invention. Figure 7 Flowchart for creating a barcode scanner folder in the intelligent management system for expansion and contraction measurement data proposed in this invention; Figure 8 This is the data processing rule mapping table for the intelligent management system for expansion and contraction measurement data proposed in this invention; Figure 9 This is a flowchart of the error handling and recovery mechanism of the intelligent management system for expansion and contraction measurement data proposed in this invention. Detailed Implementation

[0014] The following is in conjunction with the appendix Figures 1-9 This application will be described in further detail.

[0015] This application discloses an intelligent management system for expansion and contraction measurement data.

[0016] Example 1 Reference Figures 1-9 The intelligent management system for expansion and contraction measurement data includes: a data acquisition unit, an intelligent data recognition and automatic matching module, a data reorganization module, a barcode scanner automatic recognition and intelligent folder creation unit, a multi-threaded asynchronous processing unit, a multi-channel intelligent notification unit, an Excel data intelligent storage and merging processing unit, a network fault tolerance and error recovery module, and a user access control module. The data acquisition unit receives material number information input from the barcode scanner and supports importing and reading raw measurement data in CSV format. This automates the acquisition of measurement data and material identification, eliminating the need for manual input, reducing human error, and improving data acquisition efficiency and accuracy.

[0017] In this embodiment, the intelligent data recognition and automatic matching module has a built-in intelligent recognition and automatic matching algorithm. It can read expansion and contraction measurement data in CSV format in real time, automatically count the total amount of valid data in the CSV file, and automatically match the corresponding measurement data processing rules according to the different data volumes. This achieves intelligent matching of data processing rules without manual judgment or intervention, improving the efficiency and accuracy of data processing. The measurement data processing rules include: Rule 1: 4 data points correspond to measuring 1 well; Rule 2: 8 data points correspond to measuring 2 wells; Rule 3: 12 data points correspond to measuring 3 wells; Rule 4: 7 data points correspond to measuring 1 well plus a diagonal line; Rule 5: 14 data points correspond to measuring 2 wells plus a diagonal line; Rule 6: 21 data points correspond to measuring 3 wells plus a diagonal line. All rules are output to Excel according to a fixed column mapping.

[0018] The instruction manual specifies the following steps for the intelligent recognition and automatic matching algorithm: First, select a CSV file, read the column data from the CSV file, extract the non-empty numerical data, and count the number of valid data N. Then, determine if N is greater than or equal to 4. If yes, proceed to the intelligent rule matching stage; otherwise, determine that there is insufficient data and terminate the process. Match the corresponding processing rules according to the number of valid data N. For example, N equals 4 corresponds to Rule 1 for measuring one hole, N equals 7 corresponds to Rule 4 for measuring one hole plus the diagonal, N equals 8 corresponds to Rule 2 for measuring two holes, N equals 12 corresponds to Rule 3 for measuring three holes, N equals 14 corresponds to Rule 5 for measuring two holes plus the diagonal, and N equals 21 corresponds to Rule 6 for measuring three holes plus the diagonal. After matching, perform data recombination and swap short side 1 and short side 2, implement data standardization, then fill the corresponding columns in Excel according to the matching rules, save to Excel and generate a backup file, update system statistics, send a processing completion notification, and finally end the processing flow, achieving automatic recognition, matching, and standardization of different measurement types of data.

[0019] In this embodiment, the data recombination module is used to standardize and reconstruct the measurement data processed by the intelligent data recognition and automatic matching module. This module converts non-standardized raw data with inconsistent formats into standardized data with a unified format, ensuring data format consistency and facilitating subsequent data storage, analysis, and reuse.

[0020] In this embodiment, the barcode scanner automatic identification and intelligent folder creation unit monitors the barcode scanner input signal in real time, automatically identifies the material number and verifies the legality of the material number characters, and automatically connects to a network shared path. It then automatically creates standardized storage folders according to the "month-day" date rule and the material number, achieving one-click association between materials and data directories. This solves the problems of inconsistent folder creation and chaotic storage paths in traditional methods, facilitating data retrieval and traceability. Specifically, this unit includes a keyboard event monitoring module, a network path dynamic management module, and a material number standardization processing module. The keyboard event monitoring module monitors the barcode scanner input in real time and determines whether scanning is complete based on the key press interval. The network path dynamic management module automatically connects to a network shared path and creates date folders in the "month-day" format. The material number standardization processing module automatically removes illegal characters from the material number, ensuring that folder naming conforms to Windows system specifications.

[0021] Its workflow is as follows: Users input information via barcode scanner or manually; the keyboard listener captures key press events; the buffer manager caches the input characters and their corresponding timestamps, and displays the buffer contents in real time; the system continuously checks the time interval between adjacent key presses; if the time interval is less than or equal to 100 milliseconds, it continues to listen for input; if the time interval is greater than 100 milliseconds, it determines that the scan is complete and submits the input data; the data validator verifies the submitted data format, and the network manager checks the availability of the network path; if the network is normal, it constructs a complete storage path, creates a date folder in the format of "month-day", creates a folder with the corresponding material number under the date folder, records the operation log, refreshes the directory tree, and displays a success message to the user; if the network is abnormal, it displays an error message, informing the user to check the network connection; this unit also supports manual input of material numbers and executes the same folder creation process as barcode input, improving the flexibility of use.

[0022] In this embodiment, a multi-threaded asynchronous processing unit is implemented. This unit employs a thread separation design, allocating different system functions to different threads to ensure the system maintains good responsiveness when processing large amounts of expansion and contraction measurement data. This avoids issues such as interface lag and response delays, improving system processing efficiency and user experience. Specifically, this unit includes four sub-modules: a main thread module, a data processing thread module, a network monitoring thread module, and a notification sending thread module. The main thread module is responsible for GUI rendering and user interaction, ensuring smooth user operation. The data processing thread module handles CSV file parsing and Excel data manipulation, achieving efficient data processing. The network monitoring thread module checks network connection status in real time to promptly detect network anomalies. The notification sending thread module synchronously sends emails and WeChat / DingTalk notifications, ensuring timely delivery of processing results.

[0023] In this embodiment, a multi-channel intelligent notification unit is used to simultaneously push processing result notifications through multiple channels after successful processing of expansion and contraction measurement data. This ensures that relevant staff can be promptly informed of the data processing status, improving work collaboration efficiency. This unit integrates email notifications and WeChat / DingTalk robot notifications, specifically including an email notification module, a WeChat or DingTalk notification module, and a conditional trigger module. The email notification module automatically sends data processing result emails via the enterprise SMTP server, containing data processing details, storage path, and other information. The WeChat or DingTalk notification module sends real-time messages to the WeChat / DingTalk robot via a Webhook interface, achieving synchronous notifications on mobile and PC terminals. The conditional trigger module controls the timing of notification sending, triggering notifications only when data processing is successful, avoiding invalid notifications that might disturb staff.

[0024] In this embodiment, the Excel data intelligent storage and merging processing unit features dynamic column mapping, intelligent cell merging processing, and a dual backup mechanism. This enables standardized and secure storage of measurement data, preventing data loss and formatting issues. Specifically, the unit comprises three sub-modules: a dynamic column mapping module, an intelligent cell merging processing module, and a dual backup mechanism. The dynamic column mapping module automatically adjusts the Excel column structure based on the type of measurement data, ensuring accurate matching between data and columns without manual adjustment. The intelligent cell merging processing module automatically merges date, model, and status columns for data from the same batch, simplifying data display and improving readability. The dual backup mechanism automatically creates backup files while saving the main file, storing them in different paths. Even if the main file is lost or corrupted, data can be recovered from the backup files, ensuring data storage reliability.

[0025] In this embodiment, the network fault tolerance and error recovery module is used to monitor multiple key aspects of the system operation process, including network connection, file access, permission verification, data writing, and notification sending. Once an anomaly is detected, a three-level retry recovery mechanism is immediately executed to automatically repair the abnormal state and provide alarm prompts, ensuring stable system operation and avoiding data loss or processing interruption caused by anomalies. The three-level retry recovery mechanism includes the following: During normal system operation, a real-time network check is performed. If the network connection fails, a three-level retry is triggered: first, an immediate retry; second, a retry after 3 seconds; and third, a retry after 5 seconds. If all three retries fail, the user is prompted to check the network connection. If file access fails, a second retry is performed after 3 seconds. If issues such as insufficient permissions, file locking, or incorrect paths occur, a third retry is performed after 5 seconds. If data processing verification fails, the verification process is re-executed. If the data is invalid, it is transferred to manual processing for intervention by staff. If an Excel write error occurs, format repair is automatically performed or data is restored from backup files. If notification sending fails, the notification is retried. If sending ultimately fails, an emergency alarm is triggered, alerting staff to handle the situation promptly.

[0026] In this embodiment, the user permission management module is used to configure multi-level user roles and corresponding operation permissions. This enables user account management, function access control, operation log recording, and data security protection, ensuring that staff in different roles can use the system according to their permissions, avoiding risks such as data leakage and misoperation, and guaranteeing data security and the standardized operation of the system. This module can set up multiple levels of roles such as administrator, operator, and viewer according to actual work needs. Administrators have full system operation permissions and can perform operations such as creating user accounts, assigning permissions, and configuring system parameters. Operators have basic operation permissions such as data collection, processing, and storage, and can complete daily data management tasks. Viewers only have data viewing permissions and cannot modify or delete data. Simultaneously, this module records the operation logs of all users in real time, including operation time, operation content, and operation results, facilitating subsequent traceability and auditing.

[0027] Example 2 An intelligent management system for expansion and contraction measurement data includes: Data acquisition: Staff scan the QR code of the material with a barcode scanner. The data acquisition unit receives the material number information input by the barcode scanner and imports the original expansion and contraction measurement data in CSV format, realizing the automated acquisition of material identification and measurement data without manual input. Intelligent recognition and matching: The intelligent data recognition and automatic matching module reads the imported CSV format measurement data in real time, extracts the non-empty numerical data, and counts the number of valid data N=8; the system determines that N≥4, enters the intelligent rule matching stage, and matches the corresponding measurement data processing rule 2 (8 data points correspond to 2 wells) according to N=8. Data Reconstruction: The data reconstruction module standardizes and reconstructs the measurement data after matching, converting the non-standardized raw data into standardized data in a unified format to ensure data format consistency; Intelligent folder creation: The barcode scanner automatically identifies and intelligently creates folders by listening to the material number input by the barcode scanner, verifying the legality of the material number characters (cleaning up illegal characters), automatically connecting to the network shared path, and creating a date folder in the format "10-25" for the current date, and then creating a folder with the corresponding material number under the date folder, realizing the association between the material and the data directory, and displaying a success message to the user; Multi-threaded asynchronous processing: The multi-threaded asynchronous processing unit starts four threads. The main thread is responsible for GUI rendering and user interaction to ensure smooth user operation; the data processing thread is responsible for parsing CSV files and processing Excel data, filling the corresponding columns of Excel with the reorganized standardized data; the network monitoring thread checks the network connection status in real time to ensure that the network is normal; and the notification sending thread prepares to send the processing result notification. Excel Storage and Backup: The intelligent storage and merging unit for Excel data adjusts the column structure through a dynamic column mapping module to ensure accurate matching between data and columns; through an intelligent cell merging module, it automatically merges the date, model, and status columns of data in the same batch; while saving the main Excel file, it automatically creates backup files and stores them in different network paths to ensure data security. Anomaly Monitoring and Recovery: The network fault tolerance and error recovery module monitors for anomalies throughout the data processing process. If a formatting error occurs during Excel writing, the system automatically repairs the format and continues the storage operation after successful repair. If network fluctuations cause notification sending to fail, the system immediately executes a three-level retry mechanism: first, it retryes sending immediately; then, it retryes again after 3 seconds; and finally, it retryes a third time after 5 seconds. After a successful retry, the notification is sent. Multi-channel notification: After successful data processing, the multi-channel intelligent notification unit sends email notifications to relevant staff via the enterprise SMTP server, including data processing details, Excel file storage path, and other information; at the same time, it sends real-time messages to WeChat / DingTalk robots via Webhook interface to achieve multi-terminal synchronous notification; Access control and logging: The user access control module grants corresponding data collection, processing, and storage permissions based on the current user role (such as operator), restricting them from performing operations outside their permissions; at the same time, it records all operation logs for the user, including operation time, operation content (such as importing CSV data, creating folders), operation results, and other information, for easy traceability later.

[0028] Example 3 An intelligent management system for expansion and contraction measurement data includes: Insufficient data scenario: If the number of valid data in the imported CSV file is N=3, the intelligent data recognition and automatic matching module determines that there is insufficient data, terminates the processing flow, and prompts the user "Insufficient data, unable to process, please supplement data"; Network anomaly scenario: If the network monitoring thread detects a network connection anomaly during the folder creation process, the barcode scanner automatically identifies the anomaly and the folder intelligent creation unit displays a message to the user: "Network anomaly, please check your network connection." Once the network is restored, the folder creation process can be re-executed. Invalid data scenario: If data processing and verification fails, and the data is still determined to be invalid after re-verification, the system will transfer to the manual processing stage, send an alarm to the administrator, and the administrator will manually process the invalid data. Manual input scenario: If the barcode scanner malfunctions, staff can manually enter the material number. The barcode scanner will automatically recognize the material number, and the folder creation unit will execute the same process as the barcode input to complete the folder creation.

[0029] In this embodiment, the system achieves automated acquisition, intelligent matching, standardized processing, standardized storage, multi-channel notification, and security control of expansion and contraction measurement data through the collaborative work of various modules. This effectively solves the problems of low data management efficiency, poor accuracy, insufficient stability, and lack of security in the existing technology, improves the intelligence level and work efficiency of data management, and ensures data security and stable system operation.

[0030] In this invention, the combination of a data acquisition unit and a barcode scanner enables automated acquisition of material identification and measurement data, reducing manual operation, avoiding human error, and significantly improving data acquisition efficiency and accuracy. It also achieves intelligent and standardized data processing: through intelligent data recognition and automatic matching modules, it achieves automatic identification, rule matching, and standardized recombination of measurement data without manual intervention, improving data processing efficiency, ensuring uniform data format, and facilitating data reuse and analysis. Furthermore, it achieves standardized data storage: through the barcode scanner's automatic identification and intelligent folder creation unit, it enables one-click creation of material and data directories, with standardized folder naming and clear storage paths, facilitating data retrieval, traceability, and management. Finally, it improves system processing performance: through the thread separation design of the multi-threaded asynchronous processing unit, it solves the problems of interface lag and response delay during large-scale data processing, ensuring smooth system operation and improving data processing efficiency. Timely push notifications of processing results: Through multi-channel intelligent notification units, data processing results are simultaneously pushed across multiple platforms and terminals, ensuring relevant staff are promptly informed of the processing status and improving work collaboration efficiency; Secure and reliable data storage: Dynamic column mapping, intelligent merging of cells, and a dual backup mechanism in the Excel data intelligent storage and merging processing unit prevent data loss and formatting errors, improving the reliability and standardization of data storage; Enhanced system stability: Anomaly monitoring and a three-level retry recovery mechanism in the network fault tolerance and error recovery module quickly repair various anomalies during system operation, reducing system interruptions and ensuring stable system operation; Strengthened data security protection: Multi-level role and permission configuration in the user permission management module strictly differentiates operation permissions. Combined with operation log recording, this effectively prevents risks such as data leakage and misoperation, ensuring data security and standardized system operation.

[0031] The above are all preferred embodiments of this application, and are not intended to limit the scope of protection of this application. Therefore, all equivalent changes made in accordance with the structure, shape and principle of this application should be covered within the scope of protection of this application.

Claims

1. An intelligent management system for expansion and contraction measurement data, characterized in that, include: The data acquisition unit is used to receive the material number information input by the barcode scanner, import and read the raw measurement data in CSV format, and realize the automated acquisition of measurement data and material identification. The intelligent data recognition and automatic matching module has a built-in intelligent recognition and automatic matching algorithm, which can read expansion and contraction measurement data in CSV format in real time, automatically count the total amount of data in the CSV file, and automatically match the corresponding measurement data processing rules according to the amount of data. The data recombination module is used to standardize and reconstruct the measurement data processed by the intelligent data recognition and automatic matching module, converting the non-standardized raw data into standardized data in a unified format. The barcode scanner automatic identification and intelligent folder creation unit is used to listen to the barcode scanner input signal, automatically identify the material number, verify the legality of the characters, connect to the network shared path, and automatically create standardized storage folders according to the "month-day" date rule and the material number, realizing one-click association creation of material and data directories; The multi-threaded asynchronous processing unit, through thread separation design, ensures that the system maintains good responsiveness when processing a large amount of expansion and contraction measurement data, and avoids interface lag; The multi-channel intelligent notification unit is used to automatically send email notifications through the enterprise SMTP server after successful data processing, and send real-time messages to WeChat / DingTalk robots through the Webhook interface, so as to realize the synchronous push of processing results across multiple platforms and terminals. The Excel data intelligent storage and merging processing unit features dynamic column mapping, intelligent processing of merged cells, and a dual backup mechanism. The network fault tolerance and error recovery module is used to monitor anomalies in network connection, file access, permission verification, data writing, and notification sending, and to execute a three-level retry recovery mechanism. The user permission management module is used to configure multi-level user roles and operation permissions, and to realize user account management, function access control, operation log recording and data security protection, so as to ensure that people with different roles use the system according to their permissions.

2. The intelligent management system for expansion and contraction measurement data according to claim 1, characterized in that, The measurement data processing rules include: Rule 1: 4 data points correspond to the measurement of 1 well; Rule 2: 8 data points correspond to measurements of 2 wells; Rule 3: 12 data points correspond to measurements of 3 wells; Rule 4: Seven data points correspond to measurements of one hole plus the diagonal; Rule 5: 14 data points correspond to measurements of 2 holes plus the diagonal; Rule 6: 21 data points correspond to measurements of the diagonal of 3 holes; All rules are output to Excel using a fixed column mapping.

3. The intelligent management system for expansion and contraction measurement data according to claim 1, characterized in that, The process of the intelligent identification and automatic matching algorithm includes: selecting a CSV file, reading the column data of the CSV file, extracting non-empty numerical data, counting the number of valid data N, determining whether N is greater than or equal to 4, if yes, proceeding to intelligent rule matching, otherwise determining insufficient data and terminating the processing; matching the corresponding processing rules according to the number of numerical values ​​N, N equals 4 corresponds to rule 1 for measuring 1 hole, N equals 7 corresponds to rule 4 for measuring 1 hole plus diagonal, N equals 8 corresponds to rule 2 for measuring 2 holes, N equals 12 corresponds to rule 3 for measuring 3 holes, N equals 14 corresponds to rule 5 for measuring 2 holes plus diagonal, N equals 21 corresponds to rule 6 for measuring 3 holes plus diagonal; performing data recombination and swapping operations of short side 1 and short side 2, implementing data standardization processing, filling the corresponding columns in Excel according to the rules, saving to Excel and generating a backup file, updating statistical data, sending a processing completion notification, and ending the processing flow, thereby realizing the automatic identification, matching and standardization processing of different measurement types of data.

4. The intelligent management system for expansion and contraction measurement data according to claim 1, characterized in that, The automatic barcode scanner identification and intelligent folder creation module includes: The keyboard event listening module listens for barcode scanner input in real time and determines the completion of scanning based on time intervals. The network path dynamic management module automatically connects to the network shared path and creates date folders in "month-day" format; The material number standardization module automatically cleans up illegal characters and ensures that folder naming conforms to Windows standards.

5. The intelligent management system for expansion and contraction measurement data according to claim 1, characterized in that, The multi-threaded asynchronous processing unit includes: The main thread module is responsible for GUI rendering and user interaction; The data processing thread module is used for CSV parsing and Excel operations; The network monitoring thread module checks the network connection status in real time. The notification sending thread module synchronously sends email and WeChat notifications.

6. The intelligent management system for expansion and contraction measurement data according to claim 1, characterized in that, The multi-channel intelligent notification unit includes: The technical features module integrates email notifications and WeChat / DingTalk robot notifications, supporting: The email notification module automatically sends processing results via the enterprise's SMTP server. The WeChat or DingTalk notification module sends real-time notifications via a Webhook interface; The condition-triggered module sends a notification only when data processing is successful.

7. The intelligent management system for expansion and contraction measurement data according to claim 1, characterized in that, The Excel data intelligent storage and merging processing unit: The dynamic column mapping module automatically adjusts the Excel column structure based on data type. The intelligent cell merging module automatically merges date, model, and status columns for data in the same batch. The dual backup mechanism module automatically creates a backup file while the main file is saved.

8. The intelligent management system for expansion and contraction measurement data according to claim 1, characterized in that, The network fault tolerance and error recovery module implements a three-level retry mechanism, which includes performing network checks during normal system operation. If the connection fails, a three-level retry is triggered: first, an immediate retry; second, a retry after 3 seconds; and third, a retry after 5 seconds. If the retry fails, the user is prompted to check. If file access fails, a second retry will be performed after 3 seconds; if insufficient permissions, file locking, or incorrect path issues occur, a third retry will be performed after 5 seconds. If data processing verification fails, it should be re-verified; if the data is invalid, it should be transferred to manual processing. If an Excel write error occurs, perform format repair or backup recovery; If the notification fails, it will be resent; if it ultimately fails, an emergency alarm will be triggered.

Images