Search

CN-121981076-A - Automatic part processing method based on CATIA and Excel

CN121981076ACN 121981076 ACN121981076 ACN 121981076ACN-121981076-A

Abstract

The invention discloses a part automation processing method based on CATIA and Excel, which comprises the steps of determining a target part list, converting part identifiers in the list into a combined search character string which can be identified by the CATIA in the Excel by utilizing a VBA program, automatically processing special characters in the process, opening a general assembly in the CATIA, entering an advanced search interface, importing the combined search character string, executing search to select 3D digital models corresponding to all target parts in batches at one time, and carrying out subsequent batch processing operation on a selected part set, wherein the batch activation, color changing, copy creation subset or export are carried out. The invention realizes the whole-process automation from the inventory to the three-dimensional model batch processing, shortens the manual operation for a plurality of hours to a plurality of minutes, has hundred percent accuracy, greatly improves the design efficiency and the data quality, and is based on a general software platform, thereby having low implementation cost.

Inventors

  • Beng Wancun
  • BAI JUN
  • DU ZHENGKUN
  • SUN SONGXIANG

Assignees

  • 宜宾凯翼汽车有限公司

Dates

Publication Date
20260505
Application Date
20251231

Claims (10)

  1. 1. The automatic part processing method based on CATIA and Excel is characterized by comprising the following steps: S1, determining a target part list; S2, in Excel, converting the part identifiers in the target part list into a combined search character string which can be identified by CATIA through a VBA program; S3, importing the converted combined search character string into a search interface of CATIA; S4, searching is carried out in the CATIA to select all 3D digital models corresponding to the target part list in batches; S5, carrying out subsequent batch processing operation on the 3D digital models selected in batches.
  2. 2. The automated part handling method according to claim 1, wherein determining the target part list in step S1 comprises screening out procurement level parts based on bill of materials (BOM), or screening out parts of a specified material class based on material properties, or screening out parts of a specified vendor to form the target part list.
  3. 3. The automated part processing method according to claim 1, wherein in step S2, the converting specifically includes converting operator characters that may be included in the part identifiers into text characters using VBA program, and concatenating the plurality of part identifiers into a single combined search string according to CATIA combined search syntax.
  4. 4. A method of automated part handling based on CATIA and Excel according to claim 3, wherein the operator characters comprise at least one of "+", "-" and "&".
  5. 5. The automated part processing method based on CATIA and Excel according to claim 1, wherein in step S2, part identifier text is extracted or concatenated using the PHONETIC function of Excel to assist in generating the combined search string.
  6. 6. The automated part handling method according to claim 1, wherein step S3 is specifically to open the total assembly digital model containing all parts in CATIA and set it to inactive state, open the advanced search interface of CATIA, copy and paste the combined search string generated in Excel to the input box of the search interface.
  7. 7. The automated part handling method of claim 1, wherein in step S5, the subsequent batch processing operation comprises at least one of activating parts in batch, changing part display colors in batch, copying the batch selected parts to a new Product to create a specified dataset, and deriving a 3D model of the selected parts in batch.
  8. 8. The automated part processing method of claim 1, further comprising copying the Excel cell content that generated the combined search string to a plain text value and pasting to a designated cell or area for delivering data to the CATIA, between step S2 and step S3.
  9. 9. The automated part handling method based on CATIA and Excel according to claim 1, wherein the method is used for structured view design in CATIA, and the subsequent batch processing operation is used for one-key generation of structured views conforming to the target part list.
  10. 10. The automated part handling method based on CATIA and Excel according to claim 1, further used for verifying consistency of the target part list and CATIA digital-to-analog information.

Description

Automatic part processing method based on CATIA and Excel Technical Field The invention relates to the technical field of automobile electronics, in particular to a system capable of ensuring emergency starting of a vehicle when a low-frequency driving chip of a keyless entry and starting system is abnormal and an implementation method thereof. Background In the field of complex product design for automobiles, aerospace and the like, three-dimensional computer aided design software (CAD) such as CATIA is widely used for digital modeling of products. In the design, review, analysis, and production preparation process, it is often necessary to base a given part list, such as a procurement bill, a bill of parts for a particular material, a supplier's bill of goods, and so forth. In a three-dimensional model of a complete vehicle or assembly containing thousands of parts, these target parts are quickly located, extracted, and subjected to a series of subsequent operations, such as changing the display colors to highlight the differences, counting the total weight, creating a simplified sub-assembly for simulation, or deriving geometric data thereof. Currently, the traditional method commonly employed in the industry is manual operation by designers. The specific process is that the operator opens the general assembly model in CATIA software, inputs the part numbers or names in the list one by one in the search function of the software, and each time a part is found, the part is selected manually, and then the operations of activating, modifying the color, etc. are carried out or the part is copied into another new assembly file. If attribute statistics is needed, the attributes of the parts need to be recorded manually or calculated by other tools after the parts are selected. In the field of three-dimensional digital design of complex products, it is a common requirement to quickly extract and process specified parts from a large assembly. In the prior art, solutions for improving automation by combining CATIA and Excel are known, for example, publication No. (CN 121028683 a) discloses a method for automatically compiling an assembly process procedure based on CATIA and Excel secondary development. The method automatically screens hole making and connection information related to the parts and counts standard parts by inputting part drawing numbers, and the core purpose of the method is to generate a structured process file, wherein the processing object is process association attribute data among the parts. The method is mainly used for data extraction and documentation of process information, but cannot solve the problem of how to perform one-key full-automatic accurate batch searching, selecting and visualizing operation on the geometrical operation level of the geometrical entity of the part in a three-dimensional space according to a list containing hundreds or thousands of part numbers. Engineers still need to perform a large number of repeated manual search and click operations for this purpose, which is inefficient and prone to error. Therefore, there is a need in the art for a completely new automated solution that is directly oriented to batch retrieval and manipulation of three-dimensional geometric entities. Disclosure of Invention The invention aims to overcome the defects of low efficiency, high error rate and complicated processing process caused by manual operation one by one in the prior art, and provides a method capable of realizing batch automatic processing of parts in a three-dimensional design model. In order to achieve the above purpose, the invention adopts the following technical scheme: a part automation processing method based on CATIA and Excel comprises the following steps: S1, determining a target part list; s2, in Excel, converting the part identifiers in the target part list into a combined search character string which can be identified by CATIA through a VBA program; s3, importing the converted combined search character string into a search interface of the CATIA; s4, searching is executed in the CATIA, and all 3D digital models corresponding to the target part list are selected in batches; S5, carrying out subsequent batch processing operation on the 3D digital models selected in batches. Further, in step S1, determining a target part list includes screening out procurement level parts based on a bill of materials (BOM), or screening out parts of a specified material class based on a material property, or screening out parts of a specified vendor to form the target part list. Further, in step S2, the converting specifically includes converting operator characters that may be included in the part identifiers to text characters using a VBA program, and concatenating the plurality of part identifiers into a single combined search string according to the CATIA combined search grammar. Further, the operator character includes at least one of "+", "-" and "&". Further, in step S2,