Method and system for automatically importing system parallel data
By automatically parsing and mapping the fine rolling pre-set message files of the old system, the problems of manual screening and import workload and error-prone caused by inconsistent parameters of new and old systems in the hot coil production line are solved, and efficient and accurate process parameters are imported to ensure the stable operation of the new system.
Patent Information
- Application Number
- CN202510320584.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-03-18
- Publication Date
- 2025-07-18
AI Technical Summary
After the automatic control system of the hot coil production line is changed, due to the inconsistent process parameters of the new and old systems, manual screening and import workload is large and error-prone, affecting the stable operation and control accuracy of the new system.
By obtaining the old system's fine-rolled pre-set message files, parsing and filtering out the target files, text segmentation and data mapping, data pairs are generated and stored in the target database for setting the new system parameters.
Significantly reduce the workload of manual screening and import, avoid errors, improve process parameters accuracy and stable operation of new systems.
Smart Images
Figure CN120336267A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of steel production applications, and particularly to a method and system for automatically importing parallel data of a system. Background Art
[0002] After the hot coil production line in a rolling mill replaces its automated control system, due to the inconsistent process model parameters between the new system and the old system, the preset calculation parameters for finishing rolling in the new system are quite different from those of the old system. In order to eliminate the setting calculation deviation between the new system and the old system, it is usually necessary to manually screen the process parameters of the old system and then manually import the screened process parameters into the new system. However, the volume of process parameters in the old system is large, resulting in extremely large manual screening and import workloads, and there is also a high risk of manual screening and import errors. Summary of the Invention
[0003] In view of the above problems existing in the prior art, the present invention proposes a method and system for automatically importing parallel data of a system, mainly solving the problem that after the replacement of the automated control system of the existing hot coil production line, parameter screening and import rely on manual work, with extremely large manual repetitive workloads and easy errors.
[0004] In order to achieve the above and other purposes, the technical solutions adopted by the present invention are as follows.
[0005] The present application provides a method for automatically importing parallel data of a system, including: obtaining a finishing preset message file in an old system, and parsing the finishing preset message file to obtain a coil number and corresponding finishing preset parameters; screening the file according to the number of data rows in the finishing preset message file to retain the file with the number of data rows reaching a preset number as a target file; performing text segmentation on the target file to map the variable names and numerical values of the finishing preset parameters in the target file into data pairs; associating the data pairs with the corresponding coil numbers and then converting them into a preset format file for storage in a target database; and setting new system parameters by calling the data in the target database.
[0006] In an embodiment of the present application, the step of setting new system parameters by calling the data in the target database includes: reading and screening data according to the data columns in the target database to obtain target parameters required by the new system; classifying the target parameters into pre-divided data levels in the new system and storing them in a target data table, where the data levels include steel grade level, thickness level, width level, and final rolling temperature level; synchronizing the corresponding finishing preset parameters in the old system associated with the coil number to the target data table, so that the new system writes data according to the data levels.
[0007] In an embodiment of the present application, text segmentation is performed on the target file to map variable names and numerical values corresponding to finish rolling preset parameters in the target file into data pairs, including: obtaining symbols for separating text in the target file; determining the mapping relationship between variable names and numerical values according to the type and position of the symbols, so as to generate the data pairs based on the mapping relationship.
[0008] In an embodiment of the present application, the step of generating the data pairs based on the mapping relationship further includes: generating a data sequence according to the order in which the data pairs appear for storage.
[0009] In an embodiment of the present application, after synchronizing the finish rolling preset parameters corresponding to the coil number in the old system to the target data table, it further includes: screening each data level so that the finish rolling preset parameters of each data level are unique.
[0010] The present application also provides a system parallel data automatic import system, including: a file parsing module, configured to obtain a finish rolling preset message file in the old system and parse the finish rolling preset message file to obtain the coil number and the corresponding finish rolling preset parameters; a file screening module, configured to screen files according to the number of data rows in the finish rolling preset message file to retain files with the number of data rows reaching a preset number of rows as target files; a text segmentation module, configured to perform text segmentation on the target file to map variable names and numerical values corresponding to finish rolling preset parameters in the target file into data pairs; a data storage module, configured to associate the data pairs with the corresponding coil numbers and then convert them into a preset format file for storage in a target database; a data calling module, configured to set new system parameters by calling the data in the target database.
[0011] As described above, a system parallel data automatic import method and system of the present invention have the following beneficial effects.
[0012] By automatically reading the finish rolling preset message of the old system, parsing and screening the message, and obtaining process parameters that meet the format requirements of the new system, the present application automatically saves them to the target database for new system parameter setting, which can greatly reduce the workload of manual screening and import, and also avoid the risk of manual screening and import errors, improving the accuracy of process parameters and the stable operation after the new system is switched. BRIEF DESCRIPTION OF THE DRAWINGS
[0013] Figure 1 It is a schematic flow chart of a system parallel data automatic import method in an embodiment of the present application.
[0014] Figure 2 It is a schematic diagram of a finish rolling preset message file in an embodiment of the present application.
[0015] Figure 3 This is a module diagram of the system parallel data automatic import system in an embodiment of the present application. Specific Embodiments
[0016] The following uses specific specific examples to illustrate the implementation manners of the present invention. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific implementation manners. Various details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present invention. It should be noted that, without conflict, the following embodiments and the features in the embodiments can be combined with each other.
[0017] It should be noted that the diagrams provided in the following embodiments only schematically illustrate the basic concept of the present invention. Therefore, only the components related to the present invention are shown in the diagrams, rather than being drawn according to the number, shape, and size of the components in actual implementation. The types, quantities, and ratios of the components in actual implementation can be arbitrarily changed, and the component layout type may also be more complex.
[0018] The inventor has found through research that:
[0019] In the hot coil production line of the rolling mill, since the secondary system of the rolling line is about to be upgraded and transformed, all the hardware and software of the secondary system of the rolling line are replaced. Currently, the new secondary system and the old secondary system are running in parallel. However, the process and model parameters of the new secondary system are inconsistent with those of the old secondary system. Therefore, the finishing mill setting calculation parameters of the new system are quite different from those of the old system. For example, the relative load of the finishing mill F1 stand in the old system is 41, and the F1 load of the new system is 37. Then, the deviation of the preset calculated rolling force between the new and old systems may reach 300 - 400 tons. In order to eliminate the deviation between the finishing mill preset calculation parameters of the new system and the old system, the process model personnel manually screen and save the process parameters in the finishing mill setting engineering report, and then fill in the selected process parameters into the new system form one by one. The manual data import workload is extremely large, and there is a great risk of manual saving and filling errors.
[0020] The existing main problems are as follows:
[0021] 1. The screening and saving of the data of the existing old system and the filling of the data of the new system are all completed manually. Not only is the data filling workload extremely large, but it is also repetitive operation;
[0022] 2. The existing method has a great risk of manual screening, saving, and filling errors, resulting in incorrect setting calculation parameters of the corresponding layer models after the new system is launched, affecting the stable operation and setting control accuracy after the new system is switched and launched.
[0023] Based on the problems existing in the above prior art, the present application proposes a method and system for automatically importing system parallel data. The technical solution of the present application will be elaborated in detail below with reference to specific embodiments.
[0024] Please refer to Figure 1 , Figure 1 which is a schematic flowchart of the method for automatically importing system parallel data in an embodiment of the present application. The method provided by the embodiment of the present application includes the following steps:
[0025] Step S100, obtain the finish rolling preset message file in the old system, and parse the finish rolling preset message file to obtain the coil number and the corresponding finish rolling preset parameters.
[0026] In one embodiment, the old system and the new system mentioned here are relative concepts. The old system refers to the automated control system used in the hot coil production line before system upgrade and iteration; the new system refers to the control system used in the hot coil production line after upgrade and iteration. After the iteration, the new system and the old system can run in parallel, and the two systems operate independently of each other. The specific system can be selected and adjusted according to the actual production application requirements, which are not limited here. The finish rolling preset parameters used in the old system during production can be saved in the finish rolling preset message file, and this message file can be stored at a specified system address. When setting the parameters of the new system, the finish rolling preset message file can be read from the corresponding address. The specific form of the message file is as Figure 2 shown. The message file format can be in TXT format, or other format files can be used according to requirements, which are not limited here.
[0027] In one embodiment, during the process of parsing the message file, parameters such as the coil number, the finish rolling first preset calculation data, and the finish rolling second preset calculation data in the message file can be locked.
[0028] Step S110, screen the files according to the number of data rows in the finish rolling preset message file, and retain the files whose number of data rows reaches the preset number of rows as target files.
[0029] In one embodiment, by scanning each coil number to determine whether the calculation data of each scanned coil number is normal calculation data. If it is normal finish rolling first and second setting calculation data, since the number of report data rows corresponding to the coil number is relatively fixed, a total of 205 rows, the normal data can be parsed row by row. If the number of report data rows corresponding to the coil number is less than 205 rows, the report data rows corresponding to the coil number are incorrect, which are the coil report data for simulated rolling or non-normal rolling completion, and are automatically excluded without data parsing.
[0030] Step S120: Perform text segmentation on the target file to map the variable names and numerical values corresponding to the finish rolling preset parameters in the target file into data pairs.
[0031] In one embodiment, performing text segmentation on the target file to map the variable names and numerical values corresponding to the finish rolling preset parameters in the target file into data pairs includes: obtaining the symbols for separating text in the target file; determining the mapping relationship between the variable names and numerical values according to the type and position of the symbols, and generating the data pairs based on the mapping relationship. Specifically, perform segmentation on the text of the normal strip report data line, according to various text interval markers:,, ], |, ), space characters, etc., and perform data type conversion; perform paired mapping of the variable names and numerical values of the segmented report data, and record them in the data structure in sequence.
[0032] Step S130: After associating the data pairs with the corresponding coil numbers, convert them into a preset format file and store it in the target database.
[0033] In one embodiment, the target database can be a database database. Print the segmented report data to a.csv file and save it to the DB2 database with the coil number as the keyword, which is convenient for subsequent extraction of relevant important data.
[0034] Step S140: Set new system parameters by calling the data in the target database.
[0035] In one embodiment, the steps of setting new system parameters by calling the data in the target database include: performing data reading and screening according to the data columns in the target database to obtain the target parameters required by the new system; classifying the target parameters into the pre-divided data levels in the new system and storing them in the target data table, where the data levels include steel grade level, thickness level, width level, finish rolling temperature level; synchronize the corresponding finish rolling preset parameters in the old system associated with the coil number to the target data table, so that the new system reads data according to the data levels.
[0036] Specifically, the strip model setting data of the old system stored in the target database after the foregoing steps can be read, and according to the required process parameters, read and screened according to the data columns in the database; according to the new steel grade level, thickness level, width level, finish rolling temperature level classification and level division rules in the new secondary system, calculate the steel grade, thickness, width, and finish rolling temperature levels of the strip in the old secondary system, obtain the four level numbers corresponding to the strip in the new secondary system, and save them in the new table newmap in the DB2 database. For example, if the strip steel grade is Q235B, the steel grade level in the old secondary system is P01, and the steel grade level number in the new secondary system is 25; for a thickness of 5.5 mm, the corresponding thickness level in the old secondary system is 12, and the thickness level number in the new secondary system is 13; for a width of 1510 mm, the corresponding width level in the old secondary system is 5, and the width level number in the new secondary system is 7; for the finish rolling temperature, since there is no corresponding level number in the old secondary system, for example, the finish rolling target temperature is 880 °C, then the finish rolling temperature level number in the new secondary system is 6; after calculating the corresponding level numbers in the new secondary system, they are used for subsequent process parameters to be written according to this level; while calculating the strip levels in the new system, extract the important process parameters (such as finishing mill rack load distribution, threading speed, maximum speed, throwing speed, temperature acceleration, power acceleration, descaling water system, finishing strip cooling water system, rack idling, loop tension and angle, etc.) used by the corresponding coil number in the old system, and synchronously save them in the new table newmap in the DB2 database. Among them, when calculating the strip levels, parameter indexing in the database can be based on the coil number.
[0037] In one embodiment, export the data in the new table newmap in the DB2 database to a csv table file, and perform uniqueness screening on the steel grade, thickness, width, and finish rolling temperature levels to obtain each unique level and the corresponding process parameters. The uniqueness identification can be carried out in the way of offline manual screening or automatically screened by using large model tools, and can be specifically set and adjusted according to production requirements, which is not limited here.
[0038] After completing the uniqueness screening, import the unique level data into the process parameter table of the new system for the new system to read the parameters for model setting calculation.
[0039] Based on the technical solutions of the embodiments of the present application above, the process parameters of the old system can be automatically imported into the new system through the data automatic import tool, greatly reducing the workload of manual data entry by process personnel and significantly reducing the repetitive work labor intensity of process personnel; the accuracy of process parameter import through the tool is high, avoiding the problem of errors in manual screening and filling of process parameters, and ensuring the accuracy of the imported process parameters and the stable operation after the new system is switched.
[0040] Please refer to Figure 3 , Figure 3It is a module diagram of the system parallel data automatic import system in an embodiment of the present application. An embodiment of the present application also provides a system parallel data automatic import system, which includes: a file parsing module 30, configured to obtain a finish rolling preset message file in an old system, and parse the finish rolling preset message file to obtain a coil number and corresponding finish rolling preset parameters; a file screening module 31, configured to screen files according to the number of data rows in the finish rolling preset message file, so as to retain files with the number of data rows reaching a preset number of rows as target files; a text splitting module 32, configured to split the text of the target file, so as to map variable names and numerical values corresponding to the finish rolling preset parameters in the target file into data pairs; a data storage module 33, configured to associate the data pairs with the corresponding coil numbers and then convert them into a preset format file and store it in a target database; a data calling module 34, configured to set new system parameters by calling the data in the target database.
[0041] The running process of the specific system has been elaborated in detail in the foregoing embodiments, and will not be elaborated here.
[0042] The above embodiments are only illustrative of the principles and effects of the present invention, and are not used to limit the present invention. Any person familiar with this technology can modify or change the above embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or changes made by those with ordinary knowledge in the technical field without departing from the spirit and technical ideas disclosed by the present invention should still be covered by the claims of the present invention.
Claims
1. A method for automatically importing system parallel data, characterized in that, including: Obtain the finishing preset message file in the old system, and parse the finishing preset message file to obtain the coil number and the corresponding finishing preset parameters; Perform file screening according to the number of data rows in the finishing preset message file to retain the file with the number of data rows reaching the preset number of rows as the target file; Perform text segmentation on the target file to map the variable names and values corresponding to the finishing preset parameters in the target file into data pairs; Associate the data pairs with the corresponding coil numbers and then convert them into a preset format file and store them in the target database; Set the new system parameters by calling the data in the target database.
2. The method for automatically importing parallel data of the system according to claim 1, wherein The step of setting the new system parameters by calling the data in the target database includes: Read and screen the data according to the data columns in the target database to obtain the target parameters required by the new system; Classify the target parameters into the pre-divided data levels in the new system and store them in the target data table, where the data levels include steel grade level, thickness level, width level, and final rolling temperature level; Synchronize the corresponding finishing preset parameters in the old system associated with the coil number to the target data table, so that the new system writes data according to the data levels.
3. The method for automatically importing parallel data of the system according to claim 1, characterized in that Performing text segmentation on the target file to map the variable names and values corresponding to the finishing preset parameters in the target file into data pairs includes: Obtain the symbol for separating text in the target file; Determine the mapping relationship between the variable name and the value according to the type and position of the symbol, and generate the data pair based on the mapping relationship.
4. The method for automatically importing parallel data of the system according to claim 3, wherein The step of generating the data pair based on the mapping relationship further includes: generating a data sequence according to the order of appearance of the data pair for storage.
5. The method for automatically importing parallel data of the system according to claim 3, characterized in that, After synchronizing the corresponding finishing preset parameters in the old system associated with the coil number to the target data table, it further includes: screening each data level so that the finishing preset parameters of each data level are unique.
6. A system for automatically importing parallel data of a system, characterized in that, including: A file parsing module, configured to obtain the finishing preset message file in the old system and parse the finishing preset message file to obtain the coil number and the corresponding finishing preset parameters; A file screening module, configured to perform file screening according to the number of data rows in the finishing preset message file to retain the file with the number of data rows reaching the preset number of rows as the target file; A text segmentation module, configured to perform text segmentation on the target file to map the variable names and values corresponding to the finishing preset parameters in the target file into data pairs; A data storage module, configured to associate the data pairs with the corresponding coil numbers and then convert them into a preset format file and store them in the target database; A data calling module, configured to set the new system parameters by calling the data in the target database.