Part name updating method and device in CAE (Computer Aided Engineering) model

Abstract

The invention provides a part name updating method and device in a CAE model, and the method specifically comprises the following steps: (1) reading and opening a BOM table of a whole vehicle in ANSA software, and importing the CAE model corresponding to the whole vehicle into the ANSA software; and (2) matching the part names in the BOM table with the part names in the CAE model, and updating the matched part names in the CAE model into the part names containing partial information of the BOM table. The method comprises the following steps: importing a BOM table into ANSA software, automatically extracting part names and corresponding material names in the BOM table, automatically extracting part names and corresponding part thicknesses in a CAE model, automatically matching the part names in the BOM table with the part names in the CAE model, and automatically updating the matched part names in the CAE model to the part names containing the material names and the part thicknesses, automatic updating of the part names in the CAE model is achieved, and the part name changing efficiency and accuracy in the CAE model are greatly improved.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of CAE analysis, and more particularly, the application relates to a part name updating method and device in a CAE model. BACKGROUND

[0002] The simulation process of CAE generally includes the following links: geometric preprocessing, meshing, part material attribute assignment, constraint and load application, calculation solving, result analysis and report generation.

[0003] At present, the CAE industry still stays in manual modification for the renaming of automobile parts, and the work efficiency is relatively low. The work flow is as follows: first, the part name is inquired in the CAE software, then the corresponding material name is found in the BOM table provided by the design department, and then the part name is manually modified in the CAE software, and the above steps are repeated to complete the renaming of the parts of the whole vehicle model.

[0004] Since the number of automobile parts is usually hundreds or thousands, the workload of the part renaming process of the whole vehicle model is huge, and the time cost is long. In addition, due to manual operation, the parts are prone to be incorrectly renamed. SUMMARY

[0005] In view of this, the application provides a part name updating method in a CAE model, which aims to improve at least one of the above problems.

[0006] Specifically, the technical scheme comprises the following:

[0007] On one hand, the application provides a part name updating method in a CAE model, and the method is specifically as follows:

[0008] (1) reading and opening the BOM table of the whole vehicle in the ANSA software, and importing the CAE model corresponding to the whole vehicle into the ANSA software;

[0009] (2) matching the part name in the BOM table with the part name in the CAE model, and updating the matched part name in the CAE model to a part name containing part of the information of the BOM table.

[0010] In some embodiments of the application, the updated part name contains: the part name and the material name of the corresponding part name in the BOM table.

[0011] In some embodiments of the application, the updated part name contains: the part name, the material name of the corresponding part name in the BOM table and the part thickness of the corresponding part name in the CAE model.

[0012] In some embodiments of the application, the forming method of the part name is specifically as follows:

[0013] (21) Traverse the BOM table and extract the part name and its corresponding material name from the BOM table;

[0014] (22) Traverse the set of part names in the CAE model and extract the part thickness corresponding to the part name in the CAE model;

[0015] (23) Match the part names in the BOM table with the part names in the CAE model, extract the material names of the matching part names from the BOM table, and form the updated part names based on the matching part names and their material names.

[0016] In some embodiments of the present invention, the part thickness of the matching part name is extracted from the CAE model, and an updated part name is formed based on the matching part name, the corresponding material name, and the part thickness.

[0017] In some embodiments of the present invention, the matching part name extracted from the CAE model is used as a key, and a container corresponding to the key is constructed in the info dictionary, storing the part name and part thickness in the corresponding container in the form of key-value pairs.

[0018] In some embodiments of the present invention, after opening the BOM table, the BOM table is traversed row by row, and the largest non-empty row number is taken as the largest row number of the BOM table.

[0019] In the BOM table, each row corresponds to a part, and each column corresponds to a part attribute, which includes: part name and material name.

[0020] On the other hand, a part name updating device in a CAE model, the device being integrated into ANSA software, the device comprising:

[0021] BOM table open unit, and material name extraction unit connected to the BOM table open unit;

[0022] The part thickness extraction unit, and the part name update unit connected to the material name extraction unit and the part thickness extraction unit, wherein...

[0023] The BOM table opening unit is used to read and open the BOM table of the entire vehicle in ANSA software;

[0024] The material name extraction unit is used to extract the part names and corresponding material properties from the BOM table;

[0025] After the CAE model of the corresponding vehicle is imported into ANSA software, the part thickness extraction unit is used to extract the part thickness corresponding to the part name from the CAE model.

[0026] The part name update unit is used to match the part names in the BOM table with the part names in the CAE model, and update the matching part names in the CAE model to part names that include some information from the BOM table.

[0027] In some embodiments of the present invention, the updated part name includes: the part name and the material name of the corresponding part name in the BOM table.

[0028] In some embodiments of the present invention, the updated part name includes: the part name, the material name of the corresponding part name in the BOM table, and the part thickness of the corresponding part name in the CAE model.

[0029] This invention imports the Bill of Materials (BOM) into ANSA software, automatically extracts the part names and their corresponding material names from the BOM, and automatically extracts the part names and their corresponding thicknesses from the CAE model. Then, it automatically matches the part names in the BOM with the part names in the CAE model, and automatically updates the matched part names in the CAE model to include the material name and the part thickness. This achieves automatic updating of part names in the CAE model, greatly improving the efficiency and accuracy of changing part names in the CAE model. Attached Figure Description

[0030] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0031] Figure 1 This is a flowchart of a part name update method in a CAE model provided in an embodiment of the present invention;

[0032] Figure 2 This is a schematic diagram of the part name updating device in the CAE model provided in an embodiment of the present invention;

[0033] The accompanying drawings illustrate specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0034] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0035] Unless otherwise defined, all technical terms used in the embodiments of this application have the same meaning as commonly understood by one of ordinary skill in the art.

[0036] Figure 1 The flowchart of the part name update method in the CAE model provided in the embodiment of the present invention is as follows:

[0037] (1) Read and open the BOM of the whole vehicle in ANSA software, and import the corresponding CAE model of the whole vehicle into ANSA software;

[0038] (2) Match the part names in the BOM table with the part names in the CAE model, and update the matching part names in the CAE model to part names that include some information from the BOM table.

[0039] In one embodiment of the present invention, the updated part name includes: the part name and the material name of the part in the BOM table, wherein the method for forming the updated part name is as follows:

[0040] (21) Traverse the BOM table and extract the part name and its corresponding material name from the BOM table;

[0041] (22) Traverse the set of part names in the CAE model and extract the part thickness corresponding to the part name in the CAE model;

[0042] (23) Match the part names in the BOM with the part names in the CAE model, and extract the material names of the matching part names from the BOM.

[0043] (24) The updated part name is generated based on the matching part name and its material name.

[0044] In this embodiment of the invention, after the ANSA software reads and opens the BOM table, it iterates through the BOM table row by row, and takes the largest non-empty row number as the largest row number of the BOM table; wherein, each row of the BOM table corresponds to a part, and each column corresponds to a part attribute, and the part attribute includes: part name and material name.

[0045] In the embodiment of the present invention, the process of reading the BOM table is specifically as follows: Automatically call the file selection function under the utils module of the ANSA software to select a file. In the file selection window, select the BOM table. The file selection function returns a list of file names with paths, and assign the list of file names to the variable file_path.

[0046] In the embodiment of the present invention, the process of opening the BOM table is as follows: Use the path and name of the BOM table returned by the variable file_path (i.e., the 0th element of the list) as the opening object of the EXCEL file opening function, and place this object into the xl_element variable.

[0047] In the embodiment of the present invention, the process of extracting the maximum row number and maximum column number of the BOM table is as follows: Read the maximum row and column numbers of the non-empty table with the worksheet name "Sheet1" in xl_element. The return value of the function XlsxMaxSheetCell is a list of the maximum row and column numbers. For example, if this BOM table (table name is Sheet1) has 100 rows and 100 columns, in Python, the first row and first column are both 0, the maximum row number and column number are both 99, and the value of rowcolumncount is [99, 99].

[0048] In the embodiment of the present invention, the process of extracting the part names and their corresponding material names in the BOM table is specifically as follows:

[0049] (a) Read the content of the cell in the 0th column of the i-th row of the worksheet named "Sheet1" in xl_element through the XlsxGetCellValue function under the utils module of the ANSA software. The 0th column is the part name, and place the part name into the prop_name_bom variable;

[0050] (b) Read the content of the cell in the 1st column of the i-th row of the worksheet named "Sheet1" in xl_element through the XlsxGetCellValue function under the utils module. The 1st column is the material name, and place the material name into the mat_name_bom variable.

[0051] (c) Check whether the current loop count i is less than m - 1. If the check result is yes, then set i += 1 and return to step (a). If the check result is no, then directly output the BOM table.

[0052] Among them, there are m rows in the BOM table. When traversing all row numbers, the loop condition should be i < m - 1. Until i = m - 1, the loop is executed m times in total.

[0053] In another embodiment of the present invention, the updated part name includes: the part name, the material name of the part in the BOM table, and the part thickness of the part in the CAE model. The method for forming the updated part name is as follows:

[0054] (21) Traverse the BOM table and extract the part name and its corresponding material name from the BOM table;

[0055] (22) Traverse the set of part names in the CAE model and extract the part thickness corresponding to the part name in the CAE model;

[0056] (23) Match the part names in the BOM with the part names in the CAE model, extract the material names of the matching part names from the BOM, and extract the part thicknesses of the matching part names from the CAE model.

[0057] (24) The updated part name is generated based on the matching part name, the corresponding material name and the part thickness.

[0058] In this embodiment of the invention, the matching part name extracted from the CAE model is used as the key, and a container corresponding to the key is constructed in the info dictionary. The part name and part thickness are stored in the corresponding container in the form of key-value pairs.

[0059] In this embodiment of the invention, the extraction process of part names and their corresponding part thicknesses from the CAE model is as follows:

[0060] (a) Obtain the set of part names of the CAE model in ANSA software, collect the list of shell parts with the attribute 'SECTION_SHELL' under constants.LSDYNA through the CollectEntities function under the base module, and put it into the variable props;

[0061] (b) In the base module, call the GetEntityCardValues ​​function to put the 'Name' and 'T1' information of the prop part under constants.LSDYNA into the info dictionary.

[0062] (c) Use Python's general get function to retrieve the key value of 'Name' in the dictionary info, which is the part name of the prop part.

[0063] (d) Use Python's get function to obtain the key value of 'T1' in the dictionary info, which is the thickness of the prop part.

[0064] In this embodiment of the invention, the process of generating the updated part name is as follows:

[0065] (a) If the value of prop_name_bom is not empty, that is, the part name in the EXCEL table is not empty, and the part name in the EXCEL is the same as the part name in the ANSA software, if mat_name_bom is not empty, that is, the material name in the EXCEL table is not empty, put the material name in the EXCEL table into the variable mat_name.

[0066] (b) Combine the part name and material name in EXCEL with the part thickness information in ANSA software to form a new part name. For example, if prop_name_bom = P356A5300169, mat_name = B340LA, and thickness = 1.6, then part_new_name = P356A5300169_B340LA_1.6mm.

[0067] (c) Update the prop part name under constants.LSDYNA to part_new_name using the assignment function SetEntityCardValues ​​under the base submodule in the ANSA software.

[0068] This invention imports the Bill of Materials (BOM) into ANSA software, automatically extracts the part names and their corresponding material names from the BOM, and automatically extracts the part names and their corresponding thicknesses from the CAE model. Then, it automatically matches the part names in the BOM with the part names in the CAE model, and automatically updates the matched part names in the CAE model to include the material name and the part thickness. This achieves automatic updating of part names in the CAE model, greatly improving the efficiency and accuracy of changing part names in the CAE model.

[0069] Figure 2 This is a schematic diagram of a part name updating device in a CAE model provided in an embodiment of the present invention. For ease of explanation, only the part name updating device in the CAE model related to the embodiment of the present invention is shown, which is integrated into the ANSA software. The device includes:

[0070] BOM table open unit, and material name extraction unit connected to the BOM table open unit;

[0071] The part thickness extraction unit, and the part name update unit connected to the material name extraction unit and the part thickness extraction unit, wherein...

[0072] The BOM table opening unit is used to read and open the BOM table of the entire vehicle in ANSA software;

[0073] The material name extraction unit is used to extract the part names and corresponding material properties from the BOM table;

[0074] After the CAE model of the corresponding vehicle is imported into ANSA software, the part thickness extraction unit is used to extract the part thickness corresponding to the part name from the CAE model.

[0075] The part name update unit is used to match the part names in the BOM table with the part names in the CAE model, and update the matching part names in the CAE model to part names that include some information from the BOM table.

[0076] In this embodiment of the invention, the updated part name includes: the part name and the material name of the part in the BOM table.

[0077] In this embodiment of the invention, the updated part name includes: the part name, the material name of the part in the BOM table, and the part thickness of the part in the CAE model.

[0078] In this embodiment of the invention, the part thickness extraction unit traverses the set of part names in the CAE model, extracts the part thickness of the matching part name from the CAE model, uses the matching part name extracted from the CAE model as the key, constructs the container corresponding to the key in the info dictionary, and stores the part name and part thickness in the corresponding container in the form of key-value pairs.

[0079] In this embodiment of the invention, the material name extraction unit traverses from the first row of the BOM table, sequentially extracting the information of the column containing the part name and the material name in the BOM table, until the maximum row number of the BOM table is reached, thus completing the extraction of the part name and the corresponding material name from the BOM table.

[0080] In this embodiment of the invention, after the part name update unit completes the matching of the part name in the BOM table with the part name in the CAE model, it generates a new part name by matching the part name and its corresponding material name and part thickness according to the set rules.

[0081] This invention imports the Bill of Materials (BOM) into ANSA software, automatically extracts the part names and their corresponding material names from the BOM, and automatically extracts the part names and their corresponding thicknesses from the CAE model. Then, it automatically matches the part names in the BOM with the part names in the CAE model, and automatically updates the matched part names in the CAE model to include the material name and the part thickness. This achieves automatic updating of part names in the CAE model, greatly improving the efficiency and accuracy of changing part names in the CAE model.

[0082] Other embodiments of this application will readily occur to those skilled in the art upon consideration of the specification and practice of the application disclosed herein. This application is intended to cover any variations, uses, or adaptations of this application that follow the general principles of this application and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only.

[0083] It should be understood that this application is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this application is limited only by the appended claims.

Claims

1. A method for updating part names in a CAE model, characterized in that, The method is as follows: (1) Read and open the BOM of the whole vehicle in ANSA software, and import the corresponding CAE model of the whole vehicle into ANSA software; (2) Match the part names in the BOM table with the part names in the CAE model, and update the matching part names in the CAE model to part names that include some information from the BOM table.

2. The part name update method in the CAE model as described in claim 1, characterized in that, The updated part name includes: the part name and the corresponding material name in the BOM table.

3. The part name update method in the CAE model as described in claim 1, characterized in that, The updated part name includes: the part name, the material name of the corresponding part name in the BOM table, and the part thickness of the corresponding part name in the CAE model.

4. The part name update method based on a CAE model as described in claim 2, characterized in that, The method for forming the part name is as follows: (21) Traverse the BOM table and extract the part name and its corresponding material name from the BOM table; (22) Traverse the set of part names in the CAE model and extract the part thickness corresponding to the part name in the CAE model; (23) Match the part names in the BOM table with the part names in the CAE model, extract the material names of the matching part names from the BOM table, and form the updated part names based on the matching part names and their material names.

5. The part name update method in the CAE model as described in claim 3, characterized in that, Extract the part thickness of the matching part name from the CAE model, and generate an updated part name based on the matching part name, the corresponding material name, and the part thickness.

6. The part name update method in the CAE model as described in claim 5, characterized in that, The matching part name extracted from the CAE model is used as the key. A container corresponding to the key is constructed in the info dictionary, and the part name and part thickness are stored in the corresponding container as key-value pairs.

7. The part name update method in the CAE model as described in claim 4, characterized in that, After opening the BOM table, iterate through the BOM table line by line and take the largest non-empty row number as the largest row number of the BOM table. In the BOM table, each row corresponds to a part, and each column corresponds to a part attribute, which includes: part name and material name.

8. A part name updating device in a CAE model, characterized in that, The device is integrated into ANSA software, and the device includes: BOM table open unit, and material name extraction unit connected to the BOM table open unit; The part thickness extraction unit, and the part name update unit connected to the material name extraction unit and the part thickness extraction unit, wherein... The BOM table opening unit is used to read and open the BOM table of the entire vehicle in ANSA software; The material name extraction unit is used to extract the part names and corresponding material properties from the BOM table; After the CAE model of the corresponding vehicle is imported into ANSA software, the part thickness extraction unit is used to extract the part thickness corresponding to the part name from the CAE model. The part name update unit is used to match the part names in the BOM table with the part names in the CAE model, and update the matching part names in the CAE model to part names that include some information from the BOM table.

9. The part name updating device in the CAE model as described in claim 8, characterized in that, The updated part name includes: the part name and the material name in the BOM.

10. The part name updating device in the CAE model as described in claim 8, characterized in that, The updated part name includes: part name, material name in BOM, and part thickness in CAE model.

Images