Data processing method and apparatus and terminal

[0071] Example one

[0072] Such as figure 1 As shown, the data processing method in the first embodiment of the present invention is applied to data verification of a process card, and the data processing method includes:

[0073] Step 11: Obtain the start instruction;

[0074] Step 12: Read the data information of the process card and the data information in the trial material list according to the start instruction;

[0075] Step 13: Pack and sum the data information in the trial-manufactured material list;

[0076] Step 14: Compare the data information in the trial-manufactured bill of materials after packing and summing with the data information of the process card, generate a verification result, and output it.

[0077] The data processing method provided in the first embodiment of the present invention directly reads the data information of the process card and the data information in the trial-manufactured bill of materials after obtaining the start instruction, and processes the data information in the trial-manufactured bill of materials to communicate with the process card. To compare the data information and output the verification results to complete the data verification of the process card, it is convenient and quick, saves manpower and time, and improves the efficiency and accuracy of verification.

[0078] Wherein, the step of reading the data information of the process card according to the start instruction and the data information in the trial-produced bill of materials includes: reading the data information of the process card according to the start instruction; reading the data information of the process card After fetching, read the data information in the trial material list.

[0079] Specifically, the step of reading the data information of the process card according to the start instruction includes: reading the configuration rule of the process card; traversing the data line of the process card according to the configuration rule to find the row where the preset parameter is located; , Read the location information of other related parameters according to the configuration rule and the row where the preset parameters are located, and obtain the data information of other related parameters according to the location information of the other related parameters, and set the preset parameters The data information of and the data information of the other related parameters are written into the result table according to preset rules; if not found, the step of reading the data information in the trial-produced material list is executed.

[0080] More specifically, the step of comparing the data information in the trial-manufactured bill of materials after the package and summation with the data information of the process card is specifically: the data in the trial-manufactured bill of materials after the package and summation are compared The information is compared with the data information in the result table.

[0081] In this embodiment, the step of packing and summing the trial-produced bill of materials information includes: packing and summing the information according to the three columns of group number, part number, and station respectively.

[0082] In order to ensure the accuracy of the trial-manufactured BOM data, before the acquisition of the start instruction, the data processing method further includes: generating a modified trial-manufactured BOM according to the change information.

[0083] In order to facilitate the management personnel to perform related operations, after the modified trial material list is generated according to the change information, the data processing method further includes: generating a trial material change list according to the change information.

[0084] Further, before generating the modified trial material list according to the change information, the data processing method further includes: processing data information in the trial material list according to the user input information to obtain the change information.

[0085] Wherein, before the acquisition of the start instruction, the data processing method further includes: processing the design bill of materials to obtain the trial-produced bill of materials.

[0086] Specifically, the step of processing the design bill of materials to obtain the trial-produced bill of materials includes: performing attribute checks on the data information of the design bill of materials according to preset rules according to the user's specification, and recording when the attributes are incorrectly filled in, and Remind the user to modify; after the attribute check is completed, remove the purchased subordinate parts in the data information of the design material list; traverse the data rows of the design material list after removing the purchased subordinate parts, and pack according to the specified column and the summation column information Sum, and generate the trial material list.

[0087] Further, before the generation of the trial-manufactured material list, the data processing method further includes: judging whether the traversal is over; if so, execute the step of generating the trial-manufactured material list; if not, traverse again to exclude purchases The data rows of the design bill of materials after the inferior parts are packaged and summed according to the specified column and the summation column information.

[0088] Specifically, the step of packing and summing according to the designated column and the summation column information includes: judging whether the designated column information of the current row is the same as the designated column information of the previous row; if so, the summation column information of the current row and The summation column information of the previous row is summed and recorded in the summation column of the previous row, and the current row is deleted; if not, the specified column information of all subsequent data rows is traversed, and the specified column information is combined with the designation of the current row The designated column information of the data row with the same column information is summed with the designated column information of the current row and recorded in the designated column of the current row, and the data row whose designated column information is the same as the designated column information of the current row is deleted.

[0089] In order to facilitate obtaining the data information of the process card, the corresponding relationship between the preset parameter and the other related parameters is stored in the configuration rule. Optionally, the preset parameters include process numbers and/or part numbers.

[0090] Example two

[0091] In the second embodiment of the present invention, an EBOM data processing plug-in (including the extraction function of the trial-produced BOM parts list and the part packaging processing function) is developed to effectively remove the purchased subordinate parts and merge the EBOM data; the data based on the EXCEL macro The comparison plug-in template is applied to the comparison between the trial-produced BOM versions: put the two different versions of the trial-produced BOM data into the data comparison plug-in template to generate the data change information of the two versions. The change information is based on the content of the change. The color is displayed, which vividly shows the data changes in a certain period of time; the process operation instruction book component information extraction plug-in is developed to extract the required data according to the process operation instruction template requirements and save it according to the specified template , So as to lay a data foundation for trial-produced BOM data verification; also developed trial-manufactured BOM and process card data verification plug-in to verify process card data.

[0092] The following is a brief description of the solution provided in the second embodiment of the present invention-the auxiliary mechanism of the trial-manufactured BOM management based on EXCEL.

[0093] Such as figure 2 As shown, in the trial production BOM management process, you can use the EBOM data processing plug-in, trial BOM data comparison template, process operation guide parts information extraction plug-in, and trial production BOM and process card data verification plug-in to solidify some operations in the business process Transition from manual processing to system processing, greatly improving the work efficiency of BOM management engineers:

[0094] Step 21: Prepare the initial trial production BOM and apply the EBOM data processing plug-in;

[0095] Step 22: Trial production BOM attribute inspection;

[0096] Step 23: Trial production BOM summary and release;

[0097] Step 24: Maintain the trial production BOM change data;

[0098] Step 25: Generate the trial production BOM change list, and apply the trial production BOM data comparison template;

[0099] Step 26: Check whether the process card data update is complete, apply the process operation instruction book component information extraction plug-in and trial-produce BOM and process card data check plug-in.

[0100] Among them, (1) EBOM data processing plug-in

[0101] The EBOM data processing plug-in is an EXCEL-based plug-in written in VBA. It can delete the purchased subordinate parts and merge the data rows; convert EBOM data into trial-produced BOM data, mainly to retain purchased parts, loading parts, and procurement outsourcing Parts and their subordinate parts; and pack the reserved parts, the main rules are as follows:

[0102] EBOM attribute check: make sure that the obtained EBOM data has no attribute filling errors, otherwise it will cause errors to be brought to the trial BOM;

[0103] Extraction of the list of prototype BOM parts: Eliminate the purchase of lower-level parts (the lower-level parts are reserved for loading parts); finally keep the purchased parts, loaded parts, self-made parts, etc.

[0104] Part data packing: Pack the obtained trial-produced BOM parts list, that is: parts with the same part structure and part number. If the part numbers are adjacent to each other, the quantities are superimposed together and one row of data is retained.

[0105] Through the above rules, the EBOM data processing plug-in combines the functions of EBOM attribute checking, subordinate parts (except for loading parts) removal, and data packaging (EBOM attribute checking, subordinate parts removal and data packaging are three independent functions, through EBOM The data processing plug-in unites them together) reduces the manual operation workload and improves the efficiency of EBOM data processing.

[0106] The EBOM data processing flow is as follows image 3 Shown:

[0107] Step 31: Obtain corresponding EBOM attribute information according to the specified data table and reference column information;

[0108] Step 32: Determine whether the EBOM attribute information is correct, if yes, go to step 34, if not, go to step 33;

[0109] Step 33: Record the data row information of the EBOM attribute error, display it, and remind the BOM management engineer to correct the data. After the correction, return to step 32;

[0110] Step 34: Eliminate purchased lower-level parts (except for loaded parts);

[0111] Step 35: Traverse the data rows and read the reference column information in the data table;

[0112] Step 36: Determine whether it is adjacent packing (the current row and the previous row have the same reference column information), if yes, go to step 37, if not, go to step 38;

[0113] Step 37: Sum the reference column, record it in the reference column of the previous row, delete the current row at the same time, and then go to step 39;

[0114] Step 38: According to the reference column information of the current row, traverse all subsequent data row information of the current row. If there is a data row with the same reference column information as the current row, sum the reference column and delete the found data row;

[0115] Step 39: Determine whether the traversal is over, if yes, go to step 310, if not, go back to step 35;

[0116] Step 310: Generate a data packing result.

[0117] (2) Trial production BOM attribute inspection

[0118] The trial-produced BOM attribute inspection mainly includes information such as whether the required items are filled in (such as: the first vehicle model, part number, Chinese name of the part, etc.), whether the vehicle configuration information is complete, whether the torque filling meets the requirements, and whether the procurement status is correct. This information can be achieved through EXCEL's existing screening and other functions, so I won't repeat it here.

[0119] (3) Use the data comparison plug-in template for trial production BOM data comparison

[0120] The comparison of trial-produced BOM data is similar to the comparison of EBOM data. There is no unique identification column in the EBOM data, and the unique identification column is extracted by plug-in; while the trial-produced BOM determines the unique row identifier during the preparation and maintenance process, so no data processing is required, that is Can be compared. For details of the data comparison plug-in, please refer to the document-"An Effective Method for EBOM Data Verification Based on EXCEL", which will not be repeated here.

[0121] (4) Trial production BOM and process card data verification plug-in

[0122] At present, the process operation instruction is to make at least one card of the installation diagram, installation instructions, and information of the parts used in each station. That is to say, the process operation instruction prepared by the process department is composed of multiple processes. Composed of cards.

[0123] If you want to extract the part information of the process operation instruction, you must require that the position of the information on the process card is well-documented. After checking, analyzing, summarizing, testing, etc., the present invention proposes a component information extraction algorithm that meets the current process card format. The algorithm requires that each process card contains two lines of information of process number and part number, and other attribute fields are distributed in these two lines-the distribution in other places is not considered, the relative position of attribute field and process number or part number is not change. Process card data extraction plug-in interface such as Figure 4 As shown, including the file path, you can "browse" to select the required process operation instruction; process number label column, process card number, process card name column, part number column, group number column, component name column, unit usage column , Assembly name label column, assembly name column and station name column.

[0124] The user can click the browse button to select the process operation instruction to be extracted (currently only supports the EXCEL version process card); after filling in the corresponding information, click the OK button to extract the part information of the process operation instruction; click the cancel button, Cancel the data extraction of the process card. The extraction results are as follows Figure 5 The contents of the template shown are saved.

[0125] According to the extracted parts information of the process operation instruction book, the present invention proposes a comparison mechanism (the trial production BOM and the process card data verification algorithm) for the trial-produced BOM and the process operation instruction book, which mainly includes the following steps:

[0126] 1) Sum and summarize the data by station, IA grouping (process card grouping), and part number. In this regard, the data package function introduced above can be used to process the trial-produced BOM and the extracted process card data.

[0127] 2) Combine the station, IA grouping, and part number information into one column, use the data comparison plug-in template to compare the data, and check whether the data is consistent.

[0128] The following is an example to illustrate the algorithm flow of trial production BOM and process card data verification, such as Image 6 Shown.

[0129] Step 61: Read the configuration rules of the process operation instruction;

[0130] Step 62: Traverse the data rows of the process operation instruction book;

[0131] Step 63: Find the row of "Part Number";

[0132] Step 64: Judge whether the attribute position of "part number" is found, if yes, go to step 65, if not, go to step 67;

[0133] Step 65: Find the location information of other attributes according to the row of "Part Number" and the configuration rules;

[0134] Step 66: Read the data information corresponding to the attribute and write the result table according to the template, and return to step 62;

[0135] Step 67: Read the data information of the trial-produced BOM and the data information in the result table of the extracted process operation instruction;

[0136] Step 68: Perform packing and summation according to the three columns of IA group number, part number, and station respectively;

[0137] Step 69: Perform data comparison on the packaged data;

[0138] Step 610: Generate a data comparison result.

[0139] Through the comparison of trial-produced BOM and process card data, the final result is Figure 7 The verification result shown. The main types of problems in the verification results are currently three types: missing parts in the trial-produced BOM, missing parts in the process card, and inconsistent quantities of the trial-produced BOM and process cards.

[0140] It should be noted that after finding the attribute location of the "part number", the solution provided by the present invention can also set the attribute (location) configuration rule of the component in the process card.

[0141] It can be seen from the above that the second embodiment of the present invention mainly provides an EXCEL-based EBOM data processing plug-in and its contained plug-in for subordinate parts removal and parts packaging. This plug-in will not only eliminate duplicate rows of data and purchase subordinate parts, but also The summation of qualified quantities in the designated column greatly reduces the manual workload and improves the data accuracy rate for the data collection of thousands of parts;

[0142] Developed a trial-produced BOM and process card data verification plug-in and its contained process card data extraction algorithm. Through the plug-in, the scattered part information in the process operation instruction book was summarized, and the extracted part information was combined according to the data comparison template Comparing with prototype BOM, finally generated comparison data of prototype BOM and process card;

[0143] The data comparison template is used to compare the different versions of the trial BOM before and after, providing an effective and convenient data update basis for downstream update data.

[0144] In summary, the second embodiment of the present invention mainly focuses on improving the efficiency of trial production preparation, discovering data problems in time, ensuring the consistency of maintenance of change data and submitting change data, and timely discovering process operation guide parts information and trial production BOM parts information. Inconsistent places and other four considerations, a data processing method is provided to achieve the following goals:

[0145] (1) Effectively extract the purchased subordinate parts in EBOM and effectively merge the parts and components information under the same category;

[0146] (2) Inspect the inspection rules of trial-produced BOM attributes;

[0147] (3) Generate trial BOM change results;

[0148] (4) Combine the parts and components information in the scattered process operation instructions and save them in a comparable format;

[0149] (5) Check the process operation instruction data and trial-produced BOM data as required, and display the results in a set form;

[0150] (6) Improve the efficiency of trial-manufactured BOM management and the correctness of maintenance of changed data.

[0151] Example three

[0152] Such as Figure 8 As shown, the data processing device in the third embodiment of the present invention is applied to data verification of a process card, and the data processing device includes:

[0153] The obtaining module 81 is used to obtain a start instruction;

[0154] The reading module 82 is used to read the data information of the process card and the data information in the trial-produced material list according to the start instruction;

[0155] The summation module 83 is used to package and sum the data information in the trial-produced bill of materials;

[0156] The first processing module 84 is configured to compare the data information in the trial-manufactured material list after the packing and summation with the data information of the process card, generate a verification result, and output it.

[0157] The data processing device provided in the third embodiment of the present invention directly reads the data information of the process card and the data information in the trial-manufactured bill of materials after obtaining the start-up instruction, and processes the data information in the trial-manufactured bill of materials with the process card. To compare the data information and output the verification results to complete the data verification of the process card, it is convenient and quick, saves manpower and time, and improves the efficiency and accuracy of verification.

[0158] Wherein, the reading module includes: a first reading sub-module for reading the data information of the process card according to the start instruction; a second reading sub-module for reading the data information of the process card Then, read the data information in the trial-manufactured material list.

[0159] Specifically, the reading module includes: a third reading submodule, which is used to read the configuration rules of the process card; and a search submodule, which is used to traverse the data rows of the process card according to the configuration rules to find the row where the preset parameters are located. ; The first processing sub-module is configured to, if found, read the location information of other related parameters according to the configuration rule and the row where the preset parameters are located, and obtain other related parameters according to the location information of the other related parameters The data information of the related parameters, the data information of the preset parameters and the data information of the other related parameters are written into the result table according to preset rules; the first execution sub-module is used to execute all the data if it is not found. Describe the operation of reading the data information in the trial-produced bill of materials.

[0160] More specifically, the first processing module is specifically configured to compare the data information in the trial-manufactured material list after the package and summation with the data information in the result table.

[0161] In this embodiment, the summation module includes: a summation sub-module, which is used to perform packing and summation according to the three columns of group number, part number and station information respectively.

[0162] In order to ensure the accuracy of the trial-manufactured bill of materials data, the data processing device further includes: a first generation module for generating a modified trial-manufactured bill of materials according to the change information before the acquisition module performs related operations.

[0163] In order to facilitate the management personnel to perform related operations, the data processing device further includes: a second generation module, configured to generate a trial-produced material change list according to the change information after the first generation module performs related operations.

[0164] Further, the data processing device further includes: a second processing module, configured to process the data information in the trial-produced bill of materials according to user input information before the first generation module performs related operations to obtain the change information.

[0165] Wherein, the data processing device further includes: a third processing module, configured to process the design bill of materials to obtain the trial-produced bill of materials before the acquisition module performs related operations.

[0166] Specifically, the third processing module includes: a second processing sub-module, which is used to perform an attribute check on the data information of the design bill of materials according to preset rules according to the user's designation, and record when the attribute is incorrectly filled in, and Remind the user to modify; the elimination sub-module is used to eliminate the purchased subordinate parts in the data information of the design bill of materials after the attribute check is completed; the third processing sub-module is used to traverse the design material list after the purchased subordinate parts are eliminated The data rows of, are packaged and summed according to the specified column and the summation column information to generate the trial material list.

[0167] Further, the data processing device further includes: a first judging sub-module, which is used to judge whether the traversal is over before the third processing sub-module performs related operations; a second execution sub-module, which is used to execute the The operation of generating the trial-produced material list; the fourth processing sub-module is used to traverse again the data rows of the design material list after excluding the purchased subordinate parts, and perform packing and summation according to the designated column and the summation column information.

[0168] Specifically, the third processing submodule includes: a second judging submodule, which is used to judge whether the designated column information of the current row is the same as the designated column information of the previous row; and the fifth processing submodule is used to The summation column information of the row is summed with the summation column information of the previous row, and is recorded in the summation column of the previous row, and the current row is deleted; the sixth processing sub-module is used to traverse all subsequent data rows if not The specified column information of the specified column, and the specified column information of the data row whose specified column information is the same as the specified column information of the current row, and the specified column information of the current row are summed, recorded in the specified column of the current row, and the specified column information is deleted The data row with the same information in the specified column of the current row.

[0169] In order to facilitate obtaining the data information of the process card, the corresponding relationship between the preset parameter and the other related parameters is stored in the configuration rule. Optionally, the preset parameters include process numbers and/or part numbers.

[0170] Wherein, the implementation embodiments of the foregoing data processing method are all applicable to the embodiments of the data processing device, and the same technical effect can also be achieved.

[0171] In order to solve the foregoing technical problem, an embodiment of the present invention also provides a terminal, including: the foregoing data processing device.