A method and computer equipment for automatically constructing DMU process data based on RPA

By using an RPA-based automation method, efficient and automatic construction of DMU data was achieved, solving the problems of large workload, high operational difficulty and inconsistent data management in existing technologies, and improving data upload efficiency and accuracy.

CN123069478APending Publication Date: 2026-11-10FAW VOLKSWAGEN AUTOMOTIVE CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202510593611.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-05-09
Publication Date
2026-11-10

AI Technical Summary

Technical Problem

In modern manufacturing, the process of building DMU data involves a large workload, low efficiency, high difficulty for designers, and is prone to errors and confusion, resulting in inconsistent data management.

Method used

An RPA-based automation method is adopted. By pre-setting RPA to receive commission emails, identify part and attachment information, and automatically attach the parts to the corresponding positions in the DMU, ​​the collaborative work of information acquisition, login, operation and notification modules is carried out to realize the automatic uploading and management of part data.

Benefits of technology

It improves the efficiency of DMU data setup, reduces the learning cost and time of manual operation, ensures data accuracy and consistency, and allows designers to upload parts simply by sending an email, reducing design risks and development schedule risks.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN123069478A_ABST
    Figure CN123069478A_ABST
Patent Text Reader

Abstract

This invention discloses an RPA-based method and storage medium for automatically building DMU process data, comprising: compiling a DMU process data building delegation email template according to data building requirements, the delegation email template including multiple part attachment items, each including part data address, part attachment position, part attachment node, variant, part number, part version, quantity, and PR number; sending a delegation email according to the delegation email template, the delegation email including multiple part crossover item information; using a preset RPA to receive the delegation email, identifying the parts and part attachment item information in the delegation email, and automatically attaching the parts to the corresponding positions in the DMU; the preset RPA responding to the part attachment completion information by taking a screenshot of the attached parts and sending a reply email.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the technical field of automatic DMU component attachment methods, specifically to an automatic DMU process data construction method and computer equipment based on RPA. Background Technology

[0002] In modern manufacturing, a Digital Mock-Up (DMU) is a virtual prototype created using 3D modeling technology in automotive R&D. Typically, a newly developed vehicle project involves over 10,000 parts in the DMU. This is crucial for summarizing R&D results and demonstrating the quality and maturity of automotive development. Simultaneously, part designers need environmental data for better collaborative design. Therefore, building a complete vehicle DMU dataset ensures timely identification of design issues in automotive R&D data. This allows for problem detection and resolution early in the project, reducing development costs and time constraints caused by later changes. Thus, building a DMU process dataset is an important tool for companies to improve R&D efficiency, reduce physical development costs, and enhance the quality of designers' work.

[0003] A brand-new vehicle model has over 2,000 DMU data entries. For each part, multiple versions of data need to be created during the design process, resulting in over 10,000 entries in total. Manually collecting part data and building the DMU data would be extremely labor-intensive and inefficient.

[0004] Currently, designers from various disciplines upload data from the part design process through the data management system. The main actions and issues designers encounter during the data upload process are as follows:

[0005] First, log in to the DMU data management system and open the corresponding vehicle structure. However, due to the large number of designers and the limited number of login permissions for the data management system, it is insufficient to support all designers logging in at the same time.

[0006] Secondly, designers upload data to the corresponding nodes, adjust position coordinates, and set PR number parameters. However, designers from various disciplines rarely use the DMU data management system. This system is difficult to operate, and designers are prone to encountering various operational problems that delay the development progress of parts. Therefore, designers using the DMU data management system to upload data is not a value-added service.

[0007] Third, designers from different disciplines have their own naming habits when uploading data, which makes it inconvenient for us to manage and check DMU data in a unified manner.

[0008] In summary, the existing technology has the following problems: First, data uploads are all done manually, which is labor-intensive and extremely inefficient. Second, relying on designers to perform the data upload operation is prone to errors and confusion, and makes unified management of DMU data inconvenient. Summary of the Invention

[0009] To address at least one aspect of the aforementioned problems, this invention provides an RPA-based method for automatically building DMU process data, comprising: compiling a DMU process data building delegation email template according to data building requirements, the delegation email template including multiple part attachment items, each part attachment item including part data address, part attachment position, part attachment node, variant, part number, part version, quantity, and PR number; sending a delegation email according to the delegation email template, the delegation email including multiple part crossover item information; using a preset RPA to receive the delegation email, identifying the parts and part attachment item information in the delegation email, and automatically attaching the parts to the corresponding positions in the DMU; the preset RPA responding to the part attachment completion information by taking a screenshot of the attached parts and sending a reply email.

[0010] Preferably, the preset RPA includes an information acquisition module, a login module, an operation module, and a notification module. The information acquisition module is used to receive the entrustment email and identify the parts and part attachment information in the entrustment email, and download the part attachment data to the specified connection according to the part attachment information. The login module is used to log in to the DMU data management system and determine the DMU structure of the corresponding vehicle model project according to the part attachment information. The operation module is used to copy the structure from the DMU data management system and open the part attachment data in CATIA, upload the parts to the DMU data management system, convert the part attachment data to JT format, find the target node to be attached according to the part attachment information, upload the part attachment data to the target node, configure the PR number and configuration location information, modify the part attachment data status, and output the part attachment completion information when the part data attachment is completed and the corresponding PR number and location information are configured. The notification module is used to receive the part attachment completion information, take a screenshot of the attached part, and send a reply email.

[0011] Preferably, the information acquisition module is further configured to identify preset keywords based on the email name of the entrusted email, and filter the entrusted email when the email name does not contain preset keyword information.

[0012] Preferably, the login module is configured to pop up a login page in response to the opening operation of the DMU data management system. When the login page pops up, it receives login information and pops up an interface to select the DMU structure of the corresponding vehicle model. When the login page does not pop up, it closes the DMU data management system and reopens it.

[0013] Preferably, the operation module is configured to upload part attachment information to the DMU data management system in response to the opening of the CATIA pop-up window.

[0014] Preferably, the operation module is configured to delete the original data of the target node and then upload the part attachment information to the target node when there is original data under the target node.

[0015] Preferably, the operation module is configured to modify the part attachment data when the part attachment information does not include PR number control or location information.

[0016] Preferably, the entrustment email template also includes the path to obtain the parts attachment information.

[0017] On the other hand, a computer device is provided, including a memory and a processor, the memory including computer program instructions, and the processor being configured to execute the computer instructions to implement the RPA-based DMU process data automatic construction method as described in any one of claims 1-8.

[0018] The embodiments of the present invention have the following beneficial effects: In traditional methods, designers complain that the learning cost of data management systems is high and delays the development progress of parts. Compared with traditional methods, this tool can automatically build DMU process data, solving the designers' complaints. Designers only need to send an email to upload their parts to the DMU, ​​which also enables them to discover the assembly relationship between the parts they are responsible for and their environmental parts as early as possible, reducing the design risk of parts and providing early warning of development progress risks. Attached Figure Description

[0019] To better understand the above and other objects, features, advantages, and functions of the present invention, reference can be made to the embodiments shown in the accompanying drawings. The same reference numerals in the drawings refer to the same parts. Those skilled in the art should understand that the drawings are intended to schematically illustrate preferred embodiments of the invention and do not limit the scope of the invention in any way; the parts in the drawings are not drawn to scale.

[0020] Figure 1 The schematic diagram illustrates the development process of an RPA-based automatic data construction method for DMU processes according to an embodiment of the present invention.

[0021] Figure 2 A schematic diagram of a delegated email template for an RPA-based method for automatically building DMU process data according to an embodiment of the present invention is shown. Detailed Implementation

[0022] The exemplary embodiments of this disclosure are described below with reference to the accompanying drawings, including various details of the embodiments to aid understanding, and should be considered merely exemplary. Therefore, those skilled in the art will recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of this disclosure. Similarly, for clarity and brevity, descriptions of well-known functions and structures are omitted in the following description.

[0023] The term "comprising" and its variations as used herein signify open inclusion, i.e., "including but not limited to". Unless otherwise stated, the term "or" means "and / or". The term "based on" means "at least partially based on". The terms "one example embodiment" and "one embodiment" mean "at least one example embodiment". The term "another embodiment" means "at least one additional embodiment". The terms "first", "second", etc., may refer to different or the same objects. Other explicit and implicit definitions may also be included below.

[0024] To at least partially address one or more of the above-mentioned problems and other potential problems, embodiments of this disclosure propose an RPA-based method for automatically building DMU process data, including: Step S1, compiling a DMU process data building delegation email template according to data building requirements. The delegation email template includes multiple part attachment items, which include part data address, part attachment location, part attachment node, variant, part number, part version, quantity, and PR number.

[0025] Specifically, such as Figure 2 As shown, the commission email template is provided for designers to refer to when composing commission emails, ensuring a unified data format for the pre-defined RPA and facilitating data recognition and information extraction. The commission email template includes a data attachment request form, which contains multiple component attachment items to prompt designers to provide the corresponding component attachment information. The KVS information includes the component attachment location coordinates and component version information. The component version information is the component data address (i.e., the storage location of the component data in the KVS system).

[0026] Step S2: Send a delegation email according to the delegation email template. The delegation email includes information on multiple parts bridging items.

[0027] Specifically, each part designer fills out a data connection application form according to the actual needs and the template in the commission email, and provides information on the connection items for each part in the data connection application form.

[0028] In some implementations, the commission email template also includes the path to obtain information on parts attachment items.

[0029] like Figure 2As shown, the commission email template retrieves the specific part attachment information from the stored part attachment information, prompting the designer to provide the relevant part attachment details.

[0030] Step S3: Use a preset RPA to receive the commission email, identify the parts and part attachment information in the commission email, and automatically attach the parts to the corresponding positions in the DMU.

[0031] Specifically, the default RPA (Robotic Process Automation) is a pre-built RPA tool, such as... Figure 1 As shown, the default RPA is used to receive commission emails from various designers. Based on the received commission emails, it identifies the parts and their associated information, and automatically attaches the parts to the corresponding locations on the DMU according to the identified associated information.

[0032] Step S4: The default RPA response to the part attachment completion information is to take a screenshot of the attached part and send a reply email.

[0033] Specifically, such as Figure 1 As shown, the default RPA automatically sends a reply email and screenshots after the part data is built, for designers to refer to the build effect.

[0034] In some embodiments, the default RPA includes an information acquisition module, a login module, an operation module, and a notification module.

[0035] The information acquisition module receives commission emails, identifies the parts and their attachments within the emails, and downloads the attachment data to a designated connection based on the attachment information. Specifically, the information acquisition module includes an inbox for receiving commission emails. It extracts attachment application form attachments from the commission emails, identifies the parts and their attachments, and downloads the attachment data from the data address to the designated connection.

[0036] In some embodiments, the information acquisition module is further configured to identify preset keywords based on the email name of the entrusted email, and filter entrusted emails when the email name does not contain preset keyword information. Specifically, emails received in the inbox come from multiple senders, and the system assesses whether an email is an entrusted email by identifying information in the email name. For example, the preset keyword might be "parts attachment application," etc. Filtering emails that do not contain preset keywords can improve the efficiency of entrusted email processing.

[0037] In some embodiments, the RPA is pre-configured to identify the designer based on the sender's email address in the commission email. For example, if the DMU data management system pre-stores vehicle model project information corresponding to the designer, the project for the attached part can be determined by identifying the designer.

[0038] like Figure 1 As shown, the login module is used to log in to the DMU data management system and determine the DMU structure of the corresponding vehicle model item based on the part attachment information. Specifically, the login module opens the DMU data management system in response to the data attachment application form extracted by the information acquisition module. In some embodiments, the login module is configured to pop up a login page in response to the opening operation of the DMU data management system. When the login page pops up, it receives login information and displays an interface to select the DMU structure of the corresponding vehicle model. When the login page does not pop up, it closes the DMU data management system and reopens it.

[0039] In some embodiments, the login module includes a login information storage unit, which includes a pre-stored username and password. The login information storage unit outputs login information in response to a pop-up login page, thus enabling login and causing the system main interface to appear. In another embodiment, the login module receives login information from an administrator, enabling login and displaying the system main interface. In some embodiments, the login module further includes a DMU structure selection unit, used to select the DMU structure of the corresponding vehicle model item based on the part bridging item information.

[0040] The operation module is used to copy the structure from the DMU data management system and open the part attachment data in CATIA, upload the part to the DMU data management system, convert the part attachment data to JT format, find the target node to be attached according to the part attachment item information, upload the part attachment data to the target node, configure the PR number and location information, modify the part attachment data status, and output the part attachment completion information when the part data attachment is completed and the corresponding PR number and location information are configured.

[0041] Specifically, such as Figure 1 As shown, the operation module opens the structure through the DMU data management system.

[0042] The operation module is used to open the structure from the DMU data management system and to open part attachment information in CATIA. In some embodiments, the operation module is configured to upload part attachment information to the DMU data management system in response to the opening of the CATIA pop-up window.

[0043] The component attachment data uploaded to the DMU management system database is converted into JT format, and the target node to be attached is found based on the extracted component attachment item information.

[0044] In some embodiments, the operation module is configured to determine whether a node has data. If there is original data under the target node, the module deletes the original data of the target node and then uploads the part attachment information to the target node. If there is no data under the target node, the module directly uploads the data to the target node.

[0045] In some embodiments, the operation module is configured to determine whether the attachment data has PR number control or location information. When the attachment item information does not include PR number control or location information, the operation module modifies the attachment data status to wfix. When the data does not have PR number control or location information, the data status is directly modified to wfix (correction or repair).

[0046] Check if the data has been attached and configure the corresponding PR number and location information. When the data attachment is complete and the corresponding PR number and location information are configured, output a attachment completion message to the notification module. If the data attachment is not complete, repeat the steps of copying the structure from the DMU data management system.

[0047] The notification module is used to receive information that the part has been attached, take a screenshot of the attached part, and send a reply email.

[0048] Specifically, such as Figure 1 As shown, the notification module is configured to take a screenshot of the DMU structure in the attachment area in response to the part attachment completion information, and send the screenshot to the administrator and designer.

[0049] On the other hand, a computer device is provided, including a memory and a processor, the memory including computer program instructions, and the processor being configured to execute the computer instructions to implement any of the aforementioned RPA-based DMU process data automatic construction methods.

[0050] Specifically, the processor can be a central processing unit, or other general-purpose processors, digital signal processors, application-specific integrated circuits, field-programmable gate arrays, etc. General-purpose processors can be microprocessors, etc.

[0051] Memory can include various storage units, such as read-only memory (ROM) and permanent storage devices. ROM is used to store static data or instructions required by the processor or other modules of the computer. Permanent storage devices can be read-write storage devices or non-volatile storage devices. Alternatively, permanent storage devices may use magnetic or optical discs, flash memory, etc., as permanent storage devices. Furthermore, memory includes any combination of computer-readable storage media, including various types of semiconductor memory chips; magnetic disks and / or optical discs may also be used. Memory can include removable storage devices that are readable and / or writable, such as read-only digital versatile optical discs, read-only Blu-ray discs, ultra-high-density optical discs, flash memory cards, magnetic floppy disks, etc. Computer-readable storage media do not contain carrier waves or transient electronic signals transmitted wirelessly or via wired connections.

[0052] The memory stores computer programs, which, when processed by a processor, can cause the processor to execute some or all of the methods described above.

[0053] The various embodiments of this disclosure have been described above. These descriptions are exemplary and not exhaustive, nor are they limited to the disclosed embodiments. Many modifications and variations will be apparent to those skilled in the art without departing from the scope and spirit of the described embodiments. The terminology used herein is chosen to best explain the principles, practical application, or technical improvements to the embodiments in the market, or to enable others skilled in the art to understand this document.

Claims

1. A method for automatically constructing DMU process data based on RPA, characterized in that, include: Based on the data setup requirements, a data delegation email template for the DMU setup process was developed. The delegation email template includes multiple component attachment items, which include component data address, component attachment location, component attachment node, variant, component number, component version, quantity, and PR number. Send an authorization email according to the authorization email template. The authorization email includes information on multiple parts bridging items. The system uses a pre-defined RPA to receive commission emails, identifies the parts and their attachment information in the emails, and automatically attaches the parts to the corresponding locations in the DMU. The default RPA response is to take a screenshot of the attached part and send a reply email upon receiving the part attachment completion message.

2. The method according to claim 1, characterized in that, The default RPA includes an information acquisition module, a login module, an operation module, and a notification module. The information acquisition module receives commission emails and identifies the parts and part attachment information in the emails. It then downloads the part attachment data to a specified connection based on the attachment information. The login module logs into the DMU data management system and determines the DMU structure of the corresponding vehicle model project based on the part attachment information. The operation module opens the structure from the DMU data management system and opens the part attachment data in CATIA. It uploads the parts to the DMU data management system, converts the part attachment data to JT format, finds the target node to be attached based on the attachment information, uploads the part attachment data to the target node, configures the PR number and location information, modifies the part attachment data status, and outputs part attachment completion information when the part data attachment is completed and the corresponding PR number and location information are configured. The notification module receives the part attachment completion information, takes a screenshot of the attached part, and sends a reply email.

3. The method according to claim 2, characterized in that, The information acquisition module is also configured to identify preset keywords based on the email name of the entrusted email, and filter the entrusted email if the email name does not contain preset keyword information.

4. The method according to claim 2, characterized in that, The login module is configured to pop up a login page in response to the opening operation of the DMU data management system. When the login page pops up, it receives login information and displays an interface to select the DMU structure of the corresponding vehicle model. When the login page does not pop up, it closes the DMU data management system and reopens it.

5. The method according to claim 4, characterized in that, The operation module is configured to upload part attachment information to the DMU data management system in response to the CATIA pop-up window opening.

6. The method according to claim 4, characterized in that, The operation module is configured to delete the original data of the target node and then upload the part attachment information to the target node when there is original data under the target node.

7. The method according to claim 1, characterized in that, The operation module is configured to modify the part attachment data when the part attachment information does not include PR number control or location information.

8. The method according to claim 1, characterized in that, The delegation email template also includes the path to obtain information on parts attachment items.

9. A computer device, characterized in that, It includes a memory and a processor, the memory including computer program instructions, and the processor executing the computer instructions to implement any of the RPA-based DMU process data automatic construction methods as described in claims 1-8.