A method and device for checking parameter consistency
By checking the parameter consistency of the welding joint list and controller parameter documents, the quality problem of body welding joint connection caused by inconsistency of welding parameters is solved, and automated and efficient parameter control is realized, ensuring the stability of welding joint quality.
Patent Information
- Application Number
- CN202210992119.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-08-17
- Publication Date
- 2025-04-04
- Estimated Expiration
- 2042-08-17
AI Technical Summary
In the process of automobile manufacturing, the inconsistency of welding parameters makes it difficult to ensure the quality of the body welding joint connection, and it is difficult for the existing technology to achieve automated and efficient parameter consistency inspection.
By using the solder joint list and controller parameter document, the offline connection parameter table is checked for parameter consistency, the data is sorted by the slip instruction, the "Match" and "Find" instructions are combined to achieve data matching, and the parameter consistency check is checked using if nesting and count count functions.
It realizes automation and efficient control of welding parameters, ensures the stability of the quality of the body welding joints, simplifies the data processing process, and improves data processing efficiency.
Smart Images

Figure CN115374115B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of automobile manufacturing technology, and in particular to a parameter consistency checking method and device. Background Art
[0002] In today's automotive industry, the main method of connecting car bodies is resistance spot welding. On average, each car has 3,000-5,000 welds. The strength of the weld connection directly affects the results of the body collision test. The current accuracy of equipment in the automotive industry is generally within 3%. Under the premise that the plate overlap and the tooling status remain unchanged, the welding parameters set by the equipment become the main factor affecting the quality of the body weld connection. In summary, it is essential to control the parameters, check whether the changes in the parameters used on site are controlled, and check the consistency of the parameters.
[0003] Therefore, a parameter consistency checking technology is now provided to meet the demand for control of welding parameters in current body welding work. Summary of the invention
[0004] The present application provides a parameter consistency check method and device, which performs parameter consistency check on the offline connection parameter table based on the welding point list and controller parameter document. The inspection process is automatic and efficient, which helps to control the welding parameters, thereby effectively ensuring the quality of the body welding point connection.
[0005] In a first aspect, the present application provides a parameter consistency checking method, the method comprising the following steps:
[0006] Selecting a list of solder joints, and performing column processing on the list of solder joints to obtain a list of solder joints to be checked;
[0007] Select a controller parameter document, obtain the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and form the controller parameter document to be checked;
[0008] Based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, a parameter consistency check is performed, and a parameter consistency check result is output.
[0009] Specifically, the method of performing parameter consistency check based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, and outputting the parameter consistency check result, includes the following steps:
[0010] Select an offline connection parameter table to be checked, define a parameter check area in the offline connection parameter table and a controller parameter name to be checked;
[0011] Based on the list of solder joints to be inspected and the parameter document of the controller to be inspected, associating the controller name with the program number name;
[0012] Based on the list of solder joints to be checked and the parameter check area in the offline connection parameter table, a solder joint number consistency check is performed to obtain a solder joint number consistency check result and a solder joint number that passes the consistency check;
[0013] Based on the program number corresponding to the solder joint number that has passed the consistency check, the controller parameter name to be checked in the offline connection parameter table to be checked and the controller parameter document to be checked are checked for controller parameter consistency, and a controller parameter consistency check result is obtained;
[0014] Based on the solder joint number consistency check result and the controller parameter consistency check result, the parameter consistency check result is output.
[0015] Specifically, the solder joint list is a txt document, and the steps of selecting the solder joint list and performing column processing on the solder joint list to obtain the solder joint list to be checked include the following steps:
[0016] Use the slipt instruction to perform data column separation based on the semicolons and commas in the solder joint list to obtain the solder joint list to be checked.
[0017] Specifically, the controller parameter document is selected, and the name of the controller parameter to be checked and the corresponding controller parameter information are obtained therefrom to form the controller parameter document to be checked, including the following steps:
[0018] Select the controller parameter document and define the name of the controller parameter to be checked;
[0019] Identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract controller parameter information corresponding to the controller parameter name to be checked;
[0020] Based on the name of the controller parameter to be checked and the corresponding controller parameter information, a controller parameter document to be checked is formed.
[0021] Specifically, the controller parameter document is selected, and the name of the controller parameter to be checked and the corresponding controller parameter information are obtained therefrom to form the controller parameter document to be checked, including the following steps:
[0022] Select the controller parameter document and define the name of the controller parameter to be checked;
[0023] Use the slipt instruction to perform data column separation based on the semicolons and commas in the controller parameter document to obtain a column-separated controller parameter document;
[0024] Identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process;
[0025] Based on the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process, obtain the corresponding controller parameter information;
[0026] Based on the name of the controller parameter to be checked and the corresponding controller parameter information, a controller parameter document to be checked is formed.
[0027] In a second aspect, the present application provides a parameter consistency checking device, the device comprising:
[0028] A solder point list selection module is used to select a solder point list and perform column processing on the solder point list to obtain a list of solder points to be checked;
[0029] A controller parameter document selection module is used to select a controller parameter document, obtain the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and form a controller parameter document to be checked;
[0030] The parameter consistency check module is used to perform parameter consistency check based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, and output the parameter consistency check result.
[0031] Specifically, the parameter consistency check module includes:
[0032] A consistency check pre-selection module, which is used to select an offline connection parameter table to be checked, define a parameter check area in the offline connection parameter table and a controller parameter name to be checked;
[0033] An information association module, which is used to associate the controller name with the program number name based on the list of solder joints to be inspected and the parameter document of the controller to be inspected;
[0034] A solder joint number consistency check module, which is used to perform a solder joint number consistency check based on the solder joint list to be checked and the parameter check area in the offline connection parameter table, and obtain a solder joint number consistency check result and a solder joint number that passes the consistency check;
[0035] A controller parameter consistency check module, which is used to perform a controller parameter consistency check on the controller parameter name to be checked in the offline connection parameter table to be checked and the controller parameter document to be checked based on the program number corresponding to the solder joint number that has passed the consistency check, and obtain a controller parameter consistency check result;
[0036] A consistency check result output module is used to output the parameter consistency check result based on the solder joint number consistency check result and the controller parameter consistency check result.
[0037] Specifically, the solder joint list is a txt document;
[0038] The solder joint list selection module is also used to use the slipt instruction to perform data column separation processing based on the semicolons and commas in the solder joint list to obtain the solder joint list to be checked.
[0039] Furthermore, the controller parameter document selection module is also used to select a controller parameter document and define the name of the controller parameter to be checked;
[0040] The controller parameter document selection module is further used to identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the controller parameter information corresponding to the controller parameter name to be checked;
[0041] The controller parameter document selection module is also used to compose a controller parameter document to be checked based on the controller parameter name to be checked and the corresponding controller parameter information.
[0042] Furthermore, the controller parameter document selection module is also used to select a controller parameter document and define the name of the controller parameter to be checked;
[0043] The controller parameter document selection module is further used to use the slipt instruction to perform data column separation based on the semicolons and commas in the controller parameter document to obtain the controller parameter document after column separation;
[0044] The controller parameter document selection module is further used to identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process;
[0045] The controller parameter document selection module is further used to obtain corresponding controller parameter information based on the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process;
[0046] The controller parameter document selection module is also used to compose a controller parameter document to be checked based on the controller parameter name to be checked and the corresponding controller parameter information.
[0047] The beneficial effects of the technical solution provided by this application include:
[0048] This application performs parameter consistency check on the offline connection parameter table based on the welding point list and controller parameter document. The inspection process is automatic and efficient, which helps to control the welding parameters, thereby effectively ensuring the quality of the body welding point connection. BRIEF DESCRIPTION OF THE DRAWINGS
[0049] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.
[0050] Figure 1 A flow chart of the steps of the parameter consistency checking method provided in an embodiment of the present application;
[0051] Figure 2 A flowchart of the steps of the current document processing process corresponding to the parameter consistency checking method provided in the embodiment of the present application;
[0052] Figure 3 A flowchart of the steps of the current consistency check process corresponding to the parameter consistency check method provided in the embodiment of the present application;
[0053] Figure 4 A flowchart of the steps of the solder joint list document processing process in the parameter consistency checking method provided in the embodiment of the present application;
[0054] Figure 5 A flowchart of the steps of the controller parameter document processing process in the parameter consistency checking method provided in an embodiment of the present application;
[0055] Figure 6 A flowchart of the steps of the parameter consistency checking process in the parameter consistency checking method provided in an embodiment of the present application;
[0056] Figure 7 This is a structural block diagram of a parameter consistency checking device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0057] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of this application.
[0058] The embodiments of the present application are further described in detail below in conjunction with the accompanying drawings.
[0059] The embodiment of the present application provides a parameter consistency check method and device, which performs parameter consistency check on the offline connection parameter table based on the welding point list and the controller parameter document. The inspection process is automatic and efficient, which helps to control the welding parameters, thereby effectively ensuring the quality of the vehicle body welding point connection.
[0060] In order to achieve the above technical effects, the overall idea of this application is as follows:
[0061] A parameter consistency checking method, the method comprising the following steps:
[0062] S1. Select a list of solder joints and process the list of solder joints separately to obtain a list of solder joints to be inspected;
[0063] S2. Select a controller parameter document, obtain the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and form the controller parameter document to be checked;
[0064] S3: Based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, perform parameter consistency check and output the parameter consistency check result
[0065] The embodiments of the present application are further described in detail below in conjunction with the accompanying drawings.
[0066] First, see Figures 1 to 6 As shown, the embodiment of the present application provides a parameter consistency checking method, which includes the following steps:
[0067] S1. Select a list of solder joints and process the list of solder joints separately to obtain a list of solder joints to be inspected;
[0068] S2. Select a controller parameter document, obtain the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and form the controller parameter document to be checked;
[0069] S3. Based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, a parameter consistency check is performed, and the parameter consistency check result is output.
[0070] It should be noted that the controller in the embodiment of the present application may be a BOSCH controller.
[0071] In the embodiment of the present application, based on the welding point list and the controller parameter document, the offline connection parameter table is checked for parameter consistency. The inspection process is automatic and efficient, which helps to control the welding parameters, thereby effectively ensuring the quality of the vehicle body welding point connection.
[0072] Specifically, step S3, performing parameter consistency check based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, and outputting the parameter consistency check result, includes the following steps:
[0073] S300, selecting an offline connection parameter table to be checked, defining a parameter check area in the offline connection parameter table and a controller parameter name to be checked;
[0074] S301, associating a controller name with a program number name based on the list of solder joints to be inspected and the parameter document of the controller to be inspected;
[0075] S302, performing a solder point number consistency check based on the solder point list to be checked and the parameter check area in the offline connection parameter table, and obtaining a solder point number consistency check result and a solder point number that passes the consistency check;
[0076] S303, based on the program number corresponding to the solder joint number that has passed the consistency check, the controller parameter name to be checked in the offline connection parameter table to be checked and the controller parameter document to be checked, and the controller parameter consistency check result is obtained;
[0077] S304: output the parameter consistency check result based on the solder joint number consistency check result and the controller parameter consistency check result.
[0078] Specifically, the solder joint list is a txt document, and the steps of selecting the solder joint list and performing column processing on the solder joint list to obtain the solder joint list to be checked include the following steps:
[0079] Use the slipt instruction to perform data column separation based on the semicolons and commas in the solder joint list to obtain the solder joint list to be checked.
[0080] Specifically, the controller parameter document is selected, and the name of the controller parameter to be checked and the corresponding controller parameter information are obtained therefrom to form the controller parameter document to be checked, including the following steps:
[0081] Q1. Select the controller parameter document and define the name of the controller parameter to be checked;
[0082] Q2. Identify whether the controller parameter document contains the controller parameter name to be checked. If so, extract the controller parameter information corresponding to the controller parameter name to be checked;
[0083] Q3. Based on the name of the controller parameter to be checked and the corresponding controller parameter information, a controller parameter document to be checked is formed.
[0084] Specifically, the controller parameter document is selected, and the name of the controller parameter to be checked and the corresponding controller parameter information are obtained therefrom to form the controller parameter document to be checked, including the following steps:
[0085] P1. Select the controller parameter document and define the name of the controller parameter to be checked;
[0086] P2. Use the slipt instruction to perform data column separation based on the semicolons and commas in the controller parameter document to obtain a column-separated controller parameter document;
[0087] P3. Identify whether the controller parameter document contains the controller parameter name to be checked. If so, extract the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process;
[0088] P4. Obtain corresponding controller parameter information based on the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process;
[0089] P5. Based on the name of the controller parameter to be checked and the corresponding controller parameter information, a controller parameter document to be checked is formed.
[0090] Based on the technical solution of the embodiment of the present application, a specific implementation process is given as follows:
[0091] First, the solder joint list document processing flow is carried out, that is, the solder joint list txt document in the BOSCH controller is processed. Considering that the solder joint list parameters are few and have reference significance, only the slipt instruction is added to complete the automatic column processing of the txt data, as shown in the figure of the specification. Figure 4 As shown, the implementation process is as follows:
[0092] A1. Select the list of solder joints to be processed, specifically select the txt file of the list of solder joints to be processed;
[0093] A2. Clear the data content in the preset data storage area;
[0094] A3. Process the content of the solder joint list txt document, such as obtaining the content of the solder joint list txt document;
[0095] A4. Write the contents of the solder joint list txt file into the data storage area;
[0096] A5. Use the slipt command and press “;” or “,” to separate the txt data of the welding point list txt document.
[0097] Secondly, the controller parameter document processing flow is carried out, that is, the controller parameter txt document in the BOSCH controller is processed. Considering that there are 349 controller parameters in total and only 15 items need to be used, the program code is used to define the parameter information names that need to be extracted from the controller parameters. Combined with the slipt instruction, the automatic column separation of the controller parameter txt document is completed, as shown in the figure attached to the instruction manual. Figure 5 As shown, the implementation process is as follows:
[0098] B1. Select the controller parameter file to be processed, specifically, select the controller parameter txt file to be processed;
[0099] B2. Clear the data content in the preset data storage area;
[0100] B3. Define the controller parameter name to be extracted and record it as the controller parameter name to be checked;
[0101] B4. Use the slipt command and press ";" or "," to process the txt data of the controller parameter document in separate columns.
[0102] B5. Determine whether the controller parameter name to be checked exists in the controller parameter txt document. B6. If it exists, record the column number corresponding to the controller parameter name to be checked in the controller parameter txt document;
[0103] B7. Based on the column number corresponding to the controller parameter name to be checked in the controller parameter txt document, the corresponding data content in the controller parameter txt document is written into the data storage area.
[0104] Finally, the parameter consistency check process is carried out. Considering that the parameter consistency check involves the references of three files: offline connection parameter table, solder joint list, and controller parameter, consider using "Match" and "Find" to achieve mutual matching, and use if nesting to achieve parameter consistency check and data statistics, as shown in the attached figure of the manual. Figure 6 As shown, the implementation process is as follows:
[0105] C1. Select the offline connection parameter table that needs to be checked;
[0106] C2. Define the parameter check area in the offline connection parameter table and the controller parameter name to be checked;
[0107] C3. Based on the list of solder joints to be checked and the parameter document of the controller to be checked, process the solder joint list parameters and the controller parameters, and associate the controller name with the program number name. C4. Perform consistency check based on the corresponding parameters of the solder joint number in the offline connection parameter table;
[0108] C5. Check if there are any soldering point numbers in the wireless connection parameter table that need to be checked in the soldering point list;
[0109] C6. Record the controller name and program number in the soldering point list corresponding to the soldering point in the offline connection parameter table to be checked;
[0110] C7. Find the corresponding parameters in the welding parameter list according to the controller name and program number found, and write them into the offline connection parameter table;
[0111] C8. Determine whether the parameters are consistent;
[0112] C9, count the total number and the number of inconsistencies;
[0113] C10. Write the parameter consistency check result into the offline connection parameter table.
[0114] It should be noted that at this stage, when performing parameter consistency check, the specific scheme is as follows:
[0115] First, as shown in the accompanying drawings of the specification Figure 2 The current document processing flow shown is for processing the BOSCH controller solder point list and controller parameter txt files:
[0116] Use the existing macro code on the Internet to process the txt file of the solder joint list and controller parameters in the BOSCH controller, convert it into Excel format, and then use the built-in column separation function of Excel to process the data, and paste the processed data into the blank sheet of the offline connection parameter table that needs to be checked for parameter consistency.
[0117] Furthermore, as shown in the accompanying drawings of the specification Figure 3 The current consistency check process shown here performs parameter consistency check:
[0118] Use the concatena formula in Excel to combine the controller name and program number name in the solder joint list and controller parameters;
[0119] Use the index&match formula to find the controller&program number combination information of the solder point number in the solder point list corresponding to the solder point number in the offline connection parameter, and extract it to the blank column of the offline connection parameter table;
[0120] Then, the controller & program number combination information corresponds to the parameter information in the controller parameters and is extracted to the blank area of the offline connection parameter table;
[0121] Use the exact formula to compare the consistency between the parameters in the offline connection parameter table and the controller parameters, and use sum and countif to calculate the parameter consistency rate.
[0122] When performing parameter consistency checks based on current technical means, the following technical defects exist:
[0123] When converting the solder joint list txt document into Excel data, the data needs to be processed manually and cannot be processed automatically.
[0124] When the controller parameter txt document is converted into Excel data, there are 349 parameters in total, but only 15 are actually required, and the required data cannot be automatically filtered.
[0125] When checking parameter consistency, many formulas are used, which requires high skills of personnel and can easily cause Excel to crash during the check.
[0126] When checking parameter consistency, whether the parameter is critical data requires a summation of current and time, which needs to be determined manually.
[0127] To address the above problems, the technical solutions of the embodiments of the present application can achieve the following technical effects:
[0128] First, in the step of converting the solder point list txt document into excel data, the slipt command is added to perform column splitting processing to solve the problem that the solder point list txt document data needs to be manually split into columns.
[0129] Secondly, in the step of converting the controller parameter txt document into Excel data, the definition operation of the parameter names to be extracted and the column separation processing based on the slipt instruction are added, which solves the problem of extracting only the required parameter information from the controller parameter txt document.
[0130] Thirdly, in the step of extracting controller parameters corresponding to the solder joint number, "Match" and "Find" instructions are added to achieve data matching, which solves the problems of using too many formulas, high requirements on personnel skills, and easy to cause Excel crashes.
[0131] Fourthly, in the parameter consistency check step, we added the if nesting and count functions to solve the problem of manually sorting out the parameter consistency results.
[0132] Fifthly, the technical solution of the embodiment of the present application is simple and convenient to operate, which shortens the data processing time of the solder joint list and controller list txt documents, shortens the data processing time of the parameter consistency check, and improves the data processing efficiency.
[0133] Sixth, the technical solution of the embodiment of the present application can reversely promote the on-site parameter change management. At the same time, by changing the location where the extracted controller parameters are written into the offline connection parameter table, it can become the software for updating the offline connection parameter table, thereby solving the problem of uncontrolled offline management file parameters.
[0134] Seventhly, the technical solution of the embodiment of the present application can mark the solder joint numbers that have not been queried, so as to facilitate the optimization of the on-site solder joint list management problem in reverse.
[0135] Second, see Figure 7 As shown, the embodiment of the present application provides a parameter consistency checking device based on the technical basis of the parameter consistency checking method mentioned in the first aspect, and the device includes:
[0136] A solder point list selection module is used to select a solder point list and perform column processing on the solder point list to obtain a list of solder points to be checked;
[0137] A controller parameter document selection module is used to select a controller parameter document, obtain the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and form a controller parameter document to be checked;
[0138] The parameter consistency check module is used to perform parameter consistency check based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, and output the parameter consistency check result.
[0139] It should be noted that the controller in the embodiment of the present application may be a BOSCH controller.
[0140] In the embodiment of the present application, based on the welding point list and the controller parameter document, the offline connection parameter table is checked for parameter consistency. The inspection process is automatic and efficient, which helps to control the welding parameters, thereby effectively ensuring the quality of the vehicle body welding point connection.
[0141] Specifically, the parameter consistency check module includes:
[0142] A consistency check pre-selection module, which is used to select an offline connection parameter table to be checked, define a parameter check area in the offline connection parameter table and a controller parameter name to be checked;
[0143] An information association module, which is used to associate the controller name with the program number name based on the list of solder joints to be inspected and the parameter document of the controller to be inspected;
[0144] A solder joint number consistency check module, which is used to perform a solder joint number consistency check based on the solder joint list to be checked and the parameter check area in the offline connection parameter table, and obtain a solder joint number consistency check result and a solder joint number that passes the consistency check;
[0145] A controller parameter consistency check module, which is used to perform a controller parameter consistency check on the controller parameter name to be checked in the offline connection parameter table to be checked and the controller parameter document to be checked based on the program number corresponding to the solder joint number that has passed the consistency check, and obtain a controller parameter consistency check result;
[0146] A consistency check result output module is used to output the parameter consistency check result based on the solder joint number consistency check result and the controller parameter consistency check result.
[0147] Specifically, the solder joint list is a txt document;
[0148] The solder joint list selection module is also used to use the slipt instruction to perform data column separation processing based on the semicolons and commas in the solder joint list to obtain the solder joint list to be checked.
[0149] Furthermore, the controller parameter document selection module is also used to select a controller parameter document and define the name of the controller parameter to be checked;
[0150] The controller parameter document selection module is further used to identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the controller parameter information corresponding to the controller parameter name to be checked;
[0151] The controller parameter document selection module is also used to compose a controller parameter document to be checked based on the controller parameter name to be checked and the corresponding controller parameter information.
[0152] Furthermore, the controller parameter document selection module is also used to select a controller parameter document and define the name of the controller parameter to be checked;
[0153] The controller parameter document selection module is further used to use the slipt instruction to perform data column separation based on the semicolons and commas in the controller parameter document to obtain the controller parameter document after column separation;
[0154] The controller parameter document selection module is further used to identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process;
[0155] The controller parameter document selection module is further used to obtain corresponding controller parameter information based on the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process;
[0156] The controller parameter document selection module is also used to compose a controller parameter document to be checked based on the controller parameter name to be checked and the corresponding controller parameter information.
[0157] It should be noted that the technical problems, technical means and technical effects of the parameter consistency checking device in the embodiment of the present application are similar to those of the parameter consistency checking method mentioned in the first aspect at the principle level, and will not be elaborated here.
[0158] It should be noted that, in this application, relational terms such as "first" and "second" are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.
[0159] The above is only a specific implementation of the present application, so that those skilled in the art can understand or implement the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest range consistent with the principles and novel features applied for herein.
Claims
1. A parameter consistency checking method, characterized in that: The method comprises the following steps: Selecting a list of solder joints, and performing column processing on the list of solder joints to obtain a list of solder joints to be checked; Select a controller parameter document, obtain the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and form the controller parameter document to be checked; Based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, a parameter consistency check is performed, and a parameter consistency check result is output; The method of performing parameter consistency check based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, and outputting the parameter consistency check result, includes the following steps: Select an offline connection parameter table to be checked, define a parameter check area in the offline connection parameter table and a controller parameter name to be checked; Based on the list of solder joints to be inspected and the parameter document of the controller to be inspected, associating the controller name with the program number name; Based on the list of solder joints to be checked and the parameter check area in the offline connection parameter table, a solder joint number consistency check is performed to obtain a solder joint number consistency check result and a solder joint number that passes the consistency check; Based on the program number corresponding to the solder joint number that has passed the consistency check, the controller parameter name to be checked in the offline connection parameter table to be checked and the controller parameter document to be checked are checked for controller parameter consistency, and a controller parameter consistency check result is obtained; Based on the solder joint number consistency check result and the controller parameter consistency check result, the parameter consistency check result is output.
2. The parameter consistency checking method according to claim 1, characterized in that: The solder joint list is a txt document, and the steps of selecting the solder joint list and performing column processing on the solder joint list to obtain the solder joint list to be checked include the following steps: Use the slipt instruction to perform data column separation based on the semicolons and commas in the solder joint list to obtain the solder joint list to be checked.
3. The parameter consistency checking method according to claim 1, characterized in that: The step of selecting a controller parameter document, obtaining the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and forming the controller parameter document to be checked includes the following steps: Select the controller parameter document and define the name of the controller parameter to be checked; Identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract controller parameter information corresponding to the controller parameter name to be checked; Based on the name of the controller parameter to be checked and the corresponding controller parameter information, a controller parameter document to be checked is formed.
4. The parameter consistency checking method according to claim 1, characterized in that: The step of selecting a controller parameter document, obtaining the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and forming the controller parameter document to be checked includes the following steps: Select the controller parameter document and define the name of the controller parameter to be checked; Use the slipt instruction to perform data column separation based on the semicolons and commas in the controller parameter document to obtain a column-separated controller parameter document; Identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process; Based on the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process, obtain the corresponding controller parameter information; Based on the name of the controller parameter to be checked and the corresponding controller parameter information, a controller parameter document to be checked is formed.
5. A parameter consistency checking device, characterized in that: The device comprises: A solder point list selection module is used to select a solder point list and perform column processing on the solder point list to obtain a list of solder points to be checked; A controller parameter document selection module is used to select a controller parameter document, obtain the name of the controller parameter to be checked and the corresponding controller parameter information therefrom, and form a controller parameter document to be checked; A parameter consistency check module, which is used to perform parameter consistency check based on the list of solder joints to be checked, the parameter document of the controller to be checked, and the offline connection parameter table to be checked, and output the parameter consistency check result; The parameter consistency checking module comprises: A consistency check pre-selection module, which is used to select an offline connection parameter table to be checked, define a parameter check area in the offline connection parameter table and a controller parameter name to be checked; An information association module, which is used to associate the controller name with the program number name based on the list of solder joints to be inspected and the parameter document of the controller to be inspected; A solder joint number consistency check module, which is used to perform a solder joint number consistency check based on the solder joint list to be checked and the parameter check area in the offline connection parameter table, and obtain a solder joint number consistency check result and a solder joint number that passes the consistency check; A controller parameter consistency check module, which is used to perform a controller parameter consistency check on the controller parameter name to be checked in the offline connection parameter table to be checked and the controller parameter document to be checked based on the program number corresponding to the solder joint number that has passed the consistency check, and obtain a controller parameter consistency check result; A consistency check result output module is used to output the parameter consistency check result based on the solder joint number consistency check result and the controller parameter consistency check result.
6. The parameter consistency checking device according to claim 5, characterized in that: The soldering point list is a txt document; The solder joint list selection module is also used to use the slipt instruction to perform data column separation processing based on the semicolons and commas in the solder joint list to obtain the solder joint list to be checked.
7. The parameter consistency checking device according to claim 5, characterized in that: The controller parameter document selection module is also used to select a controller parameter document and define the name of the controller parameter to be checked; The controller parameter document selection module is further used to identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the controller parameter information corresponding to the controller parameter name to be checked; The controller parameter document selection module is also used to compose a controller parameter document to be checked based on the controller parameter name to be checked and the corresponding controller parameter information.
8. The parameter consistency checking device according to claim 5, characterized in that: The controller parameter document selection module is also used to select a controller parameter document and define the name of the controller parameter to be checked; The controller parameter document selection module is further used to use the slipt instruction to perform data column separation based on the semicolons and commas in the controller parameter document to obtain the controller parameter document after column separation; The controller parameter document selection module is further used to identify whether the controller parameter document contains the controller parameter name to be checked, and if so, extract the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process; The controller parameter document selection module is further used to obtain corresponding controller parameter information based on the column number corresponding to the controller parameter name to be checked in the controller parameter document after the column separation process; The controller parameter document selection module is also used to compose a controller parameter document to be checked based on the controller parameter name to be checked and the corresponding controller parameter information.
Citation Information
Patent Citations
Method and system utilizing Excel format data to process welding performance data
CN105550267A
Welding record data storage and automatic verification method and system
CN111931004A