Application method of an automatic unpacking program for X-ray fluorescence determination of zinc layer weight of galvanized sheet

Abstract

This invention discloses an application method for an automatic unpacking program for X-ray fluorescence determination of zinc layer weight in galvanized steel sheets. The method includes data acquisition, automatic unpacking, raw data storage, data rounding, and data updating. By developing an automatic unpacking program for X-ray fluorescence zinc layer weight determination, the program automatically reads and unpacks files, writes the data from the text files into the corresponding table in the database, and automatically updates the zinc layer weight data of the galvanized steel sheets according to the sample number. This comprehensively optimizes the X-ray fluorescence data acquisition, storage, and management process, eliminating the need for manual intervention. The unpacking program directly reads the X-ray fluorescence analysis result document at regular intervals, automatically unpacks and stores the test result data in the database, and simultaneously updates the data to the testing system. This eliminates the need for manual entry and transmission, solving the problem of data upload errors caused by manual entry, effectively reducing the workload of employees and improving work efficiency.

Description

Technical Field

[0001] This invention relates to the field of steel rolling technology, specifically to an application method for an automatic unpacking program for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence. Background Technology

[0002] With the reform and innovation of steel rolling technology, the output and product variety of steel rolling mills have been increasing. As a result, the contradiction between the increased workload and insufficient personnel in the steel finished product inspection area has become increasingly prominent. Improving work quality and labor efficiency through computer technology has become an urgent task.

[0003] In daily production in the work area, the zinc layer weight needs to be measured six times for each batch of samples. The sample number is manually entered, and the X-ray fluorescence SuperQ software will write a text document called onlyfile in the corresponding directory of the system. If the data is manually opened and entered, not only is the workload large, but data entry errors will also occur. Summary of the Invention

[0004] The purpose of this invention is to provide an application method for an automatic unpacking program for X-ray fluorescence determination of zinc layer weight in galvanized sheets. By researching and developing an automatic unpacking program for X-ray fluorescence zinc layer weight determination, the program automatically reads and unpacks files, writes the data from the text file into the corresponding table in the database, and automatically updates the zinc layer weight data of the galvanized sheet according to the sample number. This comprehensively optimizes the X-ray fluorescence data acquisition, storage, and management process, solves the problem of data upload errors caused by manual input errors, effectively reduces the labor intensity of employees, and improves work efficiency, thereby addressing the problems mentioned in the background art.

[0005] To achieve the above objectives, the present invention provides the following technical solution:

[0006] An application method for an automated unpacking procedure for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence spectrometry includes the following steps:

[0007] S1: Data Acquisition: Automatically read the text file of X-ray fluorescence zinc layer weight analysis results via a timer;

[0008] S2: Data unpacking: Loop through each line of data in the text, get the total number of lines of data, and check for non-empty data. If there is data, perform unpacking; otherwise, exit the program.

[0009] S3: Modify document name immediately after reading document: When the unpacking program reads a new zinc layer weight text document, it needs to change the name immediately. If the currently unpacked document has the same name as the newly written document, change the name of the currently unpacked document.

[0010] S4: Raw data saving: After unpacking, the raw data of the completed analysis is saved to the laboratory secondary database;

[0011] S5: Data Processing: For test results in the text that do not meet the requirements of the testing system, the data needs to be rounded. After the rounding is standardized, the data is then updated in the testing system.

[0012] S6: Data Display: After unpacking, the data is displayed according to the sample number and its corresponding element, making it convenient for users to query the test results.

[0013] Furthermore, it also includes automatically reading and sending data, the specific process of which is as follows:

[0014] S101: Start the timer to collect data periodically, read data from the text document at fixed intervals, and save the original data;

[0015] S102: Second- and third-level interface data synchronization, saving the original data while connecting to the third-level database and updating the data to the third-level data table in real time;

[0016] S103: Web page data query. The original data of zinc layer weight can be directly queried through a web page.

[0017] Furthermore, the specific method in S1 is as follows: by setting a timer, every 5 seconds, the text document in the corresponding directory of the system is read. If there is a new document, the text is unpacked; if there is no new document, the program exits.

[0018] Furthermore, in S2, the unpacking program reads each line of data in the document according to keywords. The first three lines are public data, and the following lines are real-time element verification data.

[0019] Furthermore, in S3, if the currently unpacked document has the same name as the newly written document, a document opening error will occur, causing the document writing program built into the X-ray fluorescence machine to malfunction.

[0020] Furthermore, the original data storage in S4 facilitates data retrieval and traceability. If data unpacking fails, the reason for the failure can be analyzed by querying the original data, including format errors or incorrect sample number input causing data mismatch. At the same time, it can prevent human modification of the data.

[0021] Furthermore, in S6, all test data is automatically uploaded by the testing and analysis system and then manually sent to the MES system for judgment.

[0022] Compared with the prior art, the beneficial effects of the present invention are:

[0023] 1. The present invention provides an application method for an automatic unpacking program for determining the zinc layer weight of galvanized sheets using X-ray fluorescence, which can completely collect and store various parameters during X-ray fluorescence operation.

[0024] 2. The present invention provides an application method for an automatic unpacking program for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence. The collected data can be uploaded to the corresponding data table in the testing and analysis system, achieving seamless integration with the testing and analysis system and providing comprehensive and detailed data support for the MES system.

[0025] 3. The present invention provides an application method for an automatic unpacking program for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence. Through a web query platform, users can conveniently and quickly query the test results data in real time.

[0026] 4. The present invention provides an application method for an automatic unpacking program for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence. The entire process is automated, requiring no manual intervention. It automatically collects, analyzes, and stores data, avoiding errors caused by manual entry of test results, improving work efficiency, and saving labor costs. Attached Figure Description

[0027] Figure 1 This is a data processing flowchart of the present invention;

[0028] Figure 2 This is a flowchart of the method of the present invention. Detailed Implementation

[0029] 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.

[0030] This invention provides an application method for an automatic unpacking program for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence, comprising the following steps:

[0031] Step 1: Data Acquisition: Automatically read the text file containing the X-ray fluorescence zinc layer weight analysis results using a timer; set the timer to read the text document in the corresponding directory of the system every 5 seconds; if a new document is found, unpack the text file; if no new document is found, the program exits.

[0032] Step 2: Data Unpacking: Loop through each line of data in the text file, determine the total number of lines, and check for non-empty data. If data is found, unpacking continues; otherwise, the program exits. Use special characters, such as the Sample name field, to find the corresponding sample number field. -1, -2, etc., after this field indicate the current sample's value number. Application represents the machine information for the current experiment. Measurement time is the time the sample analysis was completed and needs to be recorded in the corresponding sample information table. After Measurement time are the experimental data, including elements such as Si, Zn, and Cr. Each document contains one element corresponding to one value. After looping and unpacking, write the data to the original value data table, and simultaneously update the data in the testing system according to the sample number and element.

[0033] Step 3: Immediately change the document name after reading the document: When the unpacking program reads the new zinc layer weight text document, it needs to change the name immediately because new documents may be written during the unpacking process. If the currently unpacked document has the same name as the newly written document, a document opening error will occur, causing the document writing program built into the X-ray fluorescence machine to malfunction. Changing the name of the currently unpacked document can solve the problem of conflict between the written document and the opened document having the same name.

[0034] Step 4: Saving Raw Data: After unpacking, save the analyzed raw data to the laboratory's secondary database. Saving raw data is beneficial for data retrieval and traceability. If unpacking fails, the reason for the failure can be analyzed by querying the raw data. It may be due to format errors or incorrect sample number input, which may cause the data to not match properly. At the same time, it can prevent human modification of the data.

[0035] Step 5: Data Processing: For test results in the text that do not meet the requirements of the testing system, the data needs to be rounded. After rounding, the data should be updated to the testing system. For example, if "49." appears, it will not be able to be uploaded to the MES system after being directly updated to the testing system. Therefore, the "." needs to be removed. If there are decimals, the data also needs to be rounded according to the rounding principle of odd to even. After the rounding is completed, the data should be updated to the testing system.

[0036] Step 6: Data Display: After unpacking, the data is displayed according to the sample number and its corresponding element, making it convenient for users to query the test results; all test data are automatically uploaded by the testing system and then manually sent to the MES system for judgment.

[0037] The application method of the automatic unpacking program for determining the zinc layer weight of galvanized steel by X-ray fluorescence according to an embodiment of the present invention further includes automatic data reading and data transmission. The specific process is as follows:

[0038] (1) Start the timer to collect data periodically, read the data in the text document at fixed intervals, and save the original data;

[0039] (2) Second- and third-level interface data synchronization: while saving the original data, connect to the third-level database and update the data to the third-level data table in real time;

[0040] (3) Web page data query: The original data of zinc layer weight can be directly queried through the web page.

[0041] Through the research and implementation of the automatic unpacking program for the zinc layer weight of X-ray fluorescent galvanized steel sheets in this invention, the zinc layer weight data is automatically and in real time transmitted to the testing system, reducing errors caused by manual data entry and saving labor costs.

[0042] To further explain and illustrate the present invention, the following specific embodiments are also provided:

[0043] As attached Figure 2 As shown, the steps employed in this embodiment include data acquisition, automatic unpacking, raw data storage, data rounding, and data updating in sequence; wherein:

[0044] The data acquisition function is to periodically read the text documents written to the system by X-ray fluorescence.

[0045] The automatic unpacking function reads each line of data in the document according to keywords. The first three lines are common data, and the following lines are real-time element verification data.

[0046] The function of raw data storage is to save the analyzed raw data to the laboratory secondary database after unpacking.

[0047] The function of data rounding update is to standardize and round the test results in the text.

[0048] Data update: Update the revised and valid data to the testing and analysis system to ensure that the data meets the requirements of the MES system.

[0049] like Figure 1 As shown, the data processing flow in the above embodiments includes the following steps:

[0050] Step 1: Automatic Data Acquisition via Timer: The timer automatically reads text documents from the corresponding directory in the system;

[0051] Step 2: Unpacking raw data: Loop through each line of data in the text, unpack the raw data, and save the raw data in the secondary database;

[0052] Step 3: Data Rounding Update: The test results in the text may not meet the requirements of the testing system. The data needs to be rounded according to the principle of rounding to the nearest even or odd number. After the rounding is completed, the data is updated to the testing system.

[0053] Step 4: Manual transmission: After all test data is automatically uploaded in the testing system, it is manually transmitted to the MES system.

[0054] In summary, this invention provides an application method for an automatic unpacking program for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence. By researching and developing this automatic unpacking program, the system automatically reads and unpacks files, writes the data from the text files into the corresponding table in the database, and automatically updates the zinc layer weight data of the galvanized steel sheets according to the sample number. This comprehensively optimizes the X-ray fluorescence data acquisition, storage, and management process, eliminating the need for manual intervention. The unpacking program directly reads the X-ray fluorescence analysis result documents at regular intervals, automatically unpacks and stores the test result data in the database, and simultaneously updates the data to the testing system. This eliminates the need for manual entry and transmission, solving the problem of data upload errors caused by manual entry, effectively reducing the workload of employees and improving work efficiency.

[0055] The above description is only a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any equivalent substitutions or modifications made by those skilled in the art within the scope of the technology disclosed in the present invention, based on the technical solution and inventive concept of the present invention, should be covered within the scope of protection of the present invention.

Claims

1. An application method for an automatic unpacking program for determining the zinc layer weight of galvanized steel sheets using X-ray fluorescence, characterized in that... Includes the following steps: S1: Data Acquisition: Automatically read the text file of X-ray fluorescence zinc layer weight analysis results via a timer; S2: Data Unpacking: Loop through each line of data in the text, obtain the total number of lines, and perform a non-empty check. If data is found, unpacking continues; otherwise, the program exits. Locate the corresponding sample number field using special characters. Application indicates the machine information for the current experiment. Measurement time is the time the sample analysis was completed and recorded in the corresponding sample information table. Following Measurement time is the experimental data, containing elements such as Si, Zn, and Cr. In each document, one element corresponds to one value. After looping and unpacking, the data is written to the original value data table, and simultaneously, the data is updated in the testing system according to the sample number and element. S3: Modify document name immediately after reading document: When the unpacking program reads a new zinc layer weight text document, if the currently unpacked document has the same name as the newly written document, change the name of the currently unpacked document; S4: Raw data saving: After unpacking, the raw data of the completed analysis is saved to the laboratory secondary database; S5: Data Processing: For test results in the text that do not meet the requirements of the testing system, the data is rounded and then updated to the testing system after the rounding is standardized. S6: Data Display: After unpacking, the data is displayed according to the sample number and its corresponding element, making it convenient for users to query the test results; the data in the text file is written into the corresponding table in the database, and automatically updated to the zinc layer weight data of the galvanized sheet according to the sample number; It also includes automatically reading and sending data, the specific process of which is as follows: S101: Start the timer to collect data periodically, read data from the text document at fixed intervals, and save the original data; S102: Second- and third-level interface data synchronization, saving the original data while connecting to the third-level database and updating the data to the third-level data table in real time; S103: Web page data query. Raw data on zinc layer weight can be directly queried through a web page. The specific method in S1 is as follows: By setting a timer, the text document in the corresponding directory of the system is read every 5 seconds. If a new document is found, the text is unpacked; if no new document is found, the program exits. In S2, the unpacking program reads each line of data in the document according to the keyword. The first three lines are common data, and the following lines are real-time element test data. In S3, if the currently unpacked document has the same name as the newly written document, a document opening error will occur, causing the document writing program built into the X-ray fluorescence machine to malfunction. The original data saving in S4 facilitates data retrieval and traceability. If the unpacking of the data fails, the reason for the failure to unpack can be analyzed by querying the original data. This may include format errors or incorrect sample number input, which may cause the data to not match properly. At the same time, it can prevent human modification of the data.

Images