Method and device for building virtual process environment of welding line based on ETL, and storage medium

Abstract

The application discloses an ETL-based welding line virtual process environment building method and device and a storage medium, belongs to the technical field of software development, and comprises the following steps: preparation: establishing a two-dimensional plane legend library and a PD three-dimensional model resource library with corresponding names; calling legends in the two-dimensional plane legend library to create a two-dimensional plane map; data extraction: filling in the work station information of the equipment in the two-dimensional plane map and generating an automatic layout table; data conversion: reading the work station information in the automatic layout table to automatically generate a resource tree Input table; data loading: generating a corresponding resource tree according to the information in the resource tree Input table, inserting an equipment node under the resource tree and modifying the spatial position of the equipment when the PD-ID in the automatic layout table is empty, and completing the virtual process environment building; the method optimizes the working method, improves the working efficiency and accuracy, and can realize the traceability of data changes.

Description

Technical Field

[0001] This invention belongs to the field of software development technology, specifically relating to a method, equipment, and storage medium for building a virtual process environment for a welding line based on ETL. Background Technology

[0002] The four major processes in automobile manufacturing are stamping, welding, painting, and final assembly. Before each process's corresponding production line can be put into operation and begin production, it must undergo several stages: preliminary design, installation, and commissioning. The main tasks in the preliminary design stage of an automotive body-in-white welding production line are process planning and feasibility simulation verification.

[0003] Siemens Tecnomatix is ​​a comprehensive portfolio of digital manufacturing solutions, including Process Designer (PD) and Process Simulation (PS), which are professional engineering software. In the automotive welding field, PD is mainly used to plan the production process and equipment layout of the body-in-white; PS is used to refine and optimize process feasibility, interference, and production line layout.

[0004] Before performing detailed process planning and feasibility verification in PS, it is necessary to first build the production line environment project in PD. The main elements of a project in PD include four major elements: resources (equipment), operation (process), MFG (process information such as weld points), and product (body parts).

[0005] In traditional environment setup methods, engineers need to extract information based on a pre-planned two-dimensional layout diagram and equipment list, manually create resource tree nodes one by one in process planning and simulation software, and place the three-dimensional models corresponding to each node of the resource tree into the correct spatial position. This method is inefficient and the accuracy is difficult to guarantee. Summary of the Invention

[0006] To address the problem of engineers wasting a significant amount of time in building PD data and setting up models in existing technologies, this invention provides a method, equipment, and storage medium for building a virtual process environment for welding lines based on ETL. This method optimizes the work process, improves work efficiency and accuracy, and enables the tracking of data changes.

[0007] This invention is achieved through the following technical solution:

[0008] The method for building a virtual process environment for a soldering line based on ETL includes the following steps:

[0009] S1: Preparations:

[0010] 1) Establish a library of two-dimensional planar illustrations and a PD three-dimensional digital model resource library with corresponding names;

[0011] 2) Use legends from the 2D planar legend library to create a 2D planar diagram;

[0012] S2: Data Extraction

[0013] Fill in the equipment's workstation information in the 2D plan view and generate an automatic layout table;

[0014] S3: Data Transformation

[0015] Read the workstation information from the automatic layout table and automatically generate the resource tree input table;

[0016] S4: Data Loading

[0017] Generate the corresponding resource tree based on the information in the resource tree input table. If the PD-ID in the automatic layout table is empty, insert the device node under the resource tree and modify the device space position to complete the virtual process environment setup.

[0018] S5: Information Comparison and Tracking

[0019] When updating the device location, a new automatic layout table is exported from the updated 2D plan view. Based on the new automatic layout table, a resource tree output table is exported from the PD. The information in the resource tree input table and the resource tree output table are compared to generate a comparison result table.

[0020] Furthermore, an automatic layout table is generated using 2D plan engineering software, a resource tree input table is generated using Office, and a resource tree output table is generated using PD.

[0021] Further, in step S2, the automatic layout table includes the device's ID number Microstation-ID in the two-dimensional plan engineering software, the device's ID number PD-ID in PD, workstation, fourth-level node, name, and spatial location information elements of X, Y, Z, Rx, Ry, and Rz.

[0022] Furthermore, the Microstation-ID, workstation, name, and location coordinate information X, Y, Z, Rx, Ry, and Rz are read from the floor plan file, the PD-ID is read from the PD, and the fourth-level node is automatically generated after being judged according to the rules. Different types of equipment correspond to different fourth-level node names.

[0023] Furthermore, in step S4, if the PD-ID has a value, it is determined whether there is a device in the resource tree. If there is a device, the device location is automatically updated. If there is no device in the resource tree, the device information in the table is exported.

[0024] Furthermore, in step S5, the comparison result table can identify newly added and deleted items based on PD-ID and Microstation-ID information, and identify changes in coordinate information, thereby achieving the effect of tracking information changes.

[0025] Secondly, embodiments of the present invention also provide a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, it implements the method for building a virtual process environment for a soldering line based on ETL as described in any of the embodiments of the present invention.

[0026] Thirdly, embodiments of the present invention also provide a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the method for building a virtual process environment for a soldering line based on ETL as described in any of the embodiments of the present invention.

[0027] Compared with the prior art, the advantages of the present invention are as follows:

[0028] The present invention relates to a method, equipment, and storage medium for building a virtual process environment for a welding line based on ETL. This method optimizes the working process, improves work efficiency and accuracy, and enables the tracking of data changes. Attached Figure Description

[0029] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the accompanying drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. In all the drawings, similar elements or parts are generally identified by similar reference numerals. In the drawings, the elements or parts are not necessarily drawn to scale.

[0030] Figure 1 This is a flowchart illustrating the ETL-based virtual process environment construction method for welding lines according to the present invention.

[0031] Figure 2 This is a schematic diagram of the structure of an electronic device according to Embodiment 3 of the present invention. Detailed Implementation

[0032] To clearly and completely describe the technical solution and its specific working process of the present invention, the specific embodiments of the present invention are as follows, in conjunction with the accompanying drawings:

[0033] In this invention, unless otherwise explicitly specified and limited, the terms "installation," "connection," "linking," and "fixing," etc., should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral part; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; they can refer to the internal communication of two components or the interaction between two components, unless otherwise explicitly limited. Those skilled in the art can understand the specific meaning of the above terms in this invention according to the specific circumstances.

[0034] In this invention, unless otherwise explicitly specified and limited, "above" or "below" the second feature can mean that the first feature is in direct contact with the second feature, or that the first feature is in indirect contact with the second feature through an intermediate medium. Furthermore, "above," "over," and "on top" of the second feature can mean that the first feature is directly above or diagonally above the second feature, or simply that the first feature is at a higher horizontal level than the second feature. "Below," "below," and "under" the second feature can mean that the first feature is directly below or diagonally below the second feature, or simply that the first feature is at a lower horizontal level than the second feature.

[0035] In the description of this specification, the references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the present invention. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of different embodiments or examples.

[0036] Example 1

[0037] like Figure 1 The diagram shown is a flowchart illustrating the method for building a virtual process environment for a soldering line based on ETL in this embodiment. The method specifically includes the following steps:

[0038] The method for building a virtual process environment for a soldering line based on ETL includes the following steps:

[0039] S1: Preparations:

[0040] 1. Establish a library of two-dimensional planar illustrations and a PD three-dimensional digital model resource library with corresponding names;

[0041] 2. Use legends from the 2D planar legend library to create a 2D planar diagram;

[0042] S2: Data Extraction

[0043] Fill in the equipment's workstation information in the 2D plan view and generate an automatic layout table;

[0044] The automatic layout table includes the equipment's ID number Microstation-ID in the 2D plan engineering software, the equipment's ID number PD-ID in PD, workstation, fourth-level node, name, and spatial location information elements such as X, Y, Z, Rx, Ry, and Rz.

[0045] Among them, Microstation-ID, workstation, name and location coordinate information X, Y, Z, Rx, Ry and Rz are read from the plan drawing file, PD-ID is read from PD, and the fourth-level node is automatically generated after being judged according to the rules. Different types of equipment correspond to different fourth-level node names.

[0046] S3: Data Transformation

[0047] Read the workstation information from the automatic layout table and automatically generate the resource tree input table;

[0048] S4: Data Loading

[0049] The corresponding resource tree is generated based on the information in the resource tree input table. If the PD-ID in the automatic layout table is empty, a device node is inserted under the resource tree and the device space position is modified to complete the virtual process environment construction. If the PD-ID has a value, it is determined whether there is a device in the resource tree. If there is a device, the device position is automatically updated. If there is no device in the resource tree, the device information in the table is exported.

[0050] S5: Information Comparison and Tracking

[0051] When updating the device location, a new automatic layout table is exported from the updated 2D plan view. Based on the new automatic layout table, a resource tree output table is exported from the PD. The information in the resource tree input table and the resource tree output table is compared to generate a comparison result table. The comparison result table can identify newly added and deleted items based on PD-ID and Microstation-ID information, and identify changes in coordinate information, thus achieving the effect of tracking information changes.

[0052] In this embodiment, an automatic layout table is generated using two-dimensional planar engineering software, an input table for the resource tree is generated using Office, and an output table for the resource tree is generated using PD.

[0053] Example 2

[0054] The method for building a virtual process environment for a soldering line based on ETL in this embodiment specifically includes the following:

[0055] I. Preparatory work:

[0056] 1. Establish a library of two-dimensional planar illustrations and a PD three-dimensional digital model resource library with corresponding names;

[0057] 2. Perform secondary development on the 2D plan engineering software (Microstation in this case) to realize the function of automatically exporting "automatic layout table";

[0058] 3. Develop a plugin for Office to automatically generate a "Resource Tree Input Table" after the process information for each workstation is filled in the "Auto Layout Table".

[0059] 4. Perform secondary development on PD to realize the function of automatically generating resource trees after importing "Resource Tree Input Table" and the function of automatically placing digital models after importing "Automatic Layout Table";

[0060] 5. Perform secondary development on PD to enable the function of exporting the existing resource tree structure and location information to the "Resource Tree Output Table";

[0061] 6. Perform secondary development on PD to implement the information comparison function of "Resource Tree Input / Output Table" and output the comparison results to "Comparison Result Table".

[0062] II. Data Extraction:

[0063] In the two-dimensional plan view, fill in the workstation information for the equipment;

[0064] Using the export function developed in this invention, export an "automatic layout table";

[0065] The "Automatic Layout Table" includes elements such as Microstation-ID, PD-ID, workstation, fourth-level node, name, and X, Y, Z, Rx, Ry, and Rz position coordinates. The Microstation-ID, workstation, name, and X, Y, Z, Rx, Ry, and Rz coordinates are read directly from the floor plan file by the program. The PD-ID is read from the PD (Design Processing Unit), while the fourth-level nodes are automatically generated by the program based on rules.

[0066] III. Data Transformation

[0067] a) Using the Office Excel plugin developed in this invention, read the workstation information in the "Auto Layout Table" and automatically generate the "Resource Tree Input Table" according to the template.

[0068] IV. Data Loading

[0069] a) Create a new project in PD;

[0070] b) Import the "Resource Tree Input Table" into PD, and the corresponding resource tree will be automatically generated in PD;

[0071] c) Import the "Automatic Layout Table" into PD. The software first checks if there is a value for PD-ID in the table. If it is empty, the software inserts the device node into the corresponding workstation and device node under the resource tree generated in step 2, and modifies the spatial position of the device according to the coordinate information to achieve the effect of keeping the spatial position of the 3D digital model in PD consistent with the 2D plan view. If there is a value for PD-ID, the software checks if there is a device in the resource tree. If there is a device, the software automatically updates the device position. If there is no device in the resource tree, the software exports the device information in the table.

[0072] V. Information Comparison and Tracking

[0073] a) When the 2D floor plan information is updated, export a new version of the "Automatic Layout Table" based on the new floor plan;

[0074] b) Using the functions developed in this invention, export the "Resource Tree Output" table from PD;

[0075] c) Using the functions developed in this invention, the information in the "Resource Tree Input Table" and the "Resource Tree Output Table" is compared, and a "Comparison Result Table" is output. The "Comparison Result Table" can identify newly added and deleted items based on PD-ID and Microstation-ID information, and identify changes in coordinate information. This achieves the effect of tracking information changes.

[0076] Example 3

[0077] Figure 2 This is a schematic diagram of the structure of a computer device in Embodiment 3 of the present invention. Figure 2 A block diagram of an exemplary computer device 12 suitable for implementing embodiments of the present invention is shown. Figure 2 The computer device 12 shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of the present invention.

[0078] like Figure 2 As shown, the computer device 12 is represented in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, system memory 28, and bus 18 connecting different system components (including system memory 28 and processing unit 16).

[0079] Bus 18 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. For example, these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.

[0080] Computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0081] System memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 may be used to read and write non-removable, non-volatile magnetic media (…). Figure 2 Not shown; usually referred to as a "hard drive"). Although Figure 2 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk") and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 via one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the embodiments of the present invention.

[0082] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28. Such program modules 42 include—but are not limited to—an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include an implementation of a network environment. Program modules 42 typically perform the functions and / or methods described in the embodiments of the present invention.

[0083] The computer device 12 can also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), and with one or more devices that enable a user to interact with the computer device 12, and / or with any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network card, modem, etc.). This communication can be performed via the input / output (I / O) interface 22. Furthermore, in this embodiment, the display 24 of the computer device 12 is not an independent entity, but is embedded in a mirror, so that when the display surface of the display 24 is not displayed, the display surface of the display 24 and the mirror surface visually blend together. Moreover, the computer device 12 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via the network adapter 20. As shown, the network adapter 20 communicates with other modules of the computer device 12 via the bus 18. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0084] The processing unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, such as implementing the ETL-based virtual process environment construction method for welding lines provided in the embodiments of the present invention.

[0085] Example 3

[0086] Embodiment 3 of the present invention provides a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the method for building a virtual process environment for a soldering line based on ETL as provided in all embodiments of the present application.

[0087] Any combination of one or more computer-readable media may be used. A computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. A computer-readable storage medium can be, for example—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples (a non-exhaustive list) of computer-readable storage media include: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this document, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in connection with an instruction execution system, apparatus, or device.

[0088] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including—but not limited to—electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, capable of transmitting, propagating, or transmitting programs for use by or in connection with an instruction execution system, apparatus, or device.

[0089] The program code contained on a computer-readable medium may be transmitted using any suitable medium, including—but not limited to—wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.

[0090] Computer program code for performing the operations of this invention can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as "C" or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0091] Note that the above description is merely a preferred embodiment of the present invention and the technical principles employed. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and various obvious changes, readjustments, and substitutions can be made without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and may include many other equivalent embodiments without departing from the concept of the present invention, the scope of which is determined by the scope of the appended claims.

Claims

1. A method for building a virtual process environment for a welding line based on ETL, characterized in that, Specifically, the steps include the following: S1: Preparations: 1) Establish a library of two-dimensional planar illustrations and a PD three-dimensional digital model resource library with corresponding names; 2) Use legends from the 2D planar legend library to create a 2D planar diagram; S2: Data Extraction Fill in the workstation information of the equipment in the 2D plan view and generate an automatic layout table; S3: Data Transformation Read the workstation information from the automatic layout table and automatically generate the resource tree input table; S4: Data Loading Generate the corresponding resource tree based on the information in the resource tree input table. If the PD-ID in the automatic layout table is empty, insert the device node under the resource tree and modify the device space position to complete the virtual process environment setup. S5: Information Comparison and Tracking When updating the device location, a new automatic layout table is exported from the updated 2D plan view. Based on the new automatic layout table, a resource tree output table is exported from the PD. The information in the resource tree input table and the resource tree output table are compared to generate a comparison result table. Generate automatic layout tables using 2D plan engineering software, generate resource tree input tables using Office, and generate resource tree output tables using PD. In step S2, the automatic layout table includes the device's ID number Microstation-ID in the two-dimensional plan engineering software, the device's ID number PD-ID in PD, workstation, fourth-level node, name, and spatial location information elements of X, Y, Z, Rx, Ry, and Rz. Microstation-ID, workstation, name, and location coordinate information X, Y, Z, Rx, Ry, Rz are read from the floor plan file. PD-ID is read from PD. The fourth-level node is automatically generated after being judged according to the rules. Different types of equipment correspond to different fourth-level node names.

2. The method for building a virtual process environment for a welding line based on ETL as described in claim 1, characterized in that, In step S4, if the PD-ID has a value, it is determined whether there is a device in the resource tree. If there is a device, the device location is automatically updated. If there is no device in the resource tree, the device information in the table is exported.

3. The method for building a virtual process environment for a welding line based on ETL as described in claim 1, characterized in that, In step S5, the comparison result table identifies newly added and deleted items based on PD-ID and Microstation-ID information, and identifies changes in coordinate information, thereby achieving the effect of tracking information changes.

4. A computer device, characterized in that, It includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the method for building a virtual process environment for a soldering line based on ETL as described in any one of claims 1-3.

5. A computer-readable storage medium, characterized in that, It stores a computer program that, when executed by a processor, implements the method for building a virtual process environment for a welding line based on ETL as described in any one of claims 1-3.

Images