Drawing automatic generation method and device, electronic equipment and storage medium

Abstract

The application relates to the technical field of electrical computer-aided design, in particular to an automatic generation method and device of drawings, an electronic device and a storage medium, which comprises the following steps: obtaining a plurality of structured data input in a target Excel template and performing verification, obtaining first target structured data satisfying a preset verification condition, and automatically generating a Typical table based on the first target structured data and a pre-constructed standardized macro template library; and synchronizing the Typical table to a target software platform, and automatically generating at least one drawing according to the Typical table by using the target software platform. Therefore, the problems of long design period, high error rate and low standardization degree caused by high equipment repetition rate, various design standards and manual operation depending on experience in the electrical drawing design process are solved, so that the electrical drawing design period and error rate are reduced, and the design efficiency, design standardization level and reusability are improved.

Description

Technical Field

[0001] This application relates to the field of electrical computer-aided design technology, and in particular to a method, apparatus, electronic device and storage medium for automatically generating drawings. Background Technology

[0002] Electrical drawings are core technical documents in fields such as industrial automation, intelligent manufacturing, and power engineering. Their design efficiency and quality directly affect equipment manufacturing, installation, commissioning, and subsequent operation and maintenance.

[0003] In related technologies, electrical drawing design is mainly based on code-level secondary development. Drawings are generated by directly manipulating the EPLAN database using C#, or by linking Excel with the EEC one (EPLAN Engineering Center One) plugin, using Excel spreadsheets to drive EPLAN's built-in functions to achieve automation, or by using Excel VBA (Visual Basic for Applications) and template filtering, using functions and macros to delete and configure preset full templates to generate drawings.

[0004] However, the above electrical drawing design has the following main problems: (1) In new projects, the amount of repetition of similar electronic components and electrical equipment is extremely large. Designers need to repeatedly search for equipment templates and manually draw similar drawings. The repetitive labor accounts for more than 70%; (2) With the increase of design standards, the layout and symbol rules of the same equipment are different under different standards, which prolongs the design cycle; (3) The drawing design relies heavily on the experience of senior engineers. It is difficult to train new employees and control the design quality, which needs to be solved urgently. Summary of the Invention

[0005] This application provides a method, apparatus, electronic device, and storage medium for automatically generating drawings, in order to solve problems such as long design cycles, high error rates, and low standardization caused by high equipment duplication, diverse design standards, and reliance on experience in manual operation during the electrical drawing design process.

[0006] The first aspect of this application provides a method for automatically generating drawings, comprising the following steps: Retrieve multiple structured data entries entered into the target Excel template; The multiple structured data are validated, and a first target structured data that meets the preset validation conditions is obtained. Based on the first target structured data and a pre-built standardized macro template library, a Typical table is automatically generated. The Typical table is synchronized to the target software platform, and the target software platform automatically generates at least one drawing based on the Typical table.

[0007] Furthermore, in some embodiments, before acquiring the multiple structured data entered in the target Excel template, the method further includes: Based on at least one classification result from equipment type, equipment function, and equipment voltage level, design a standardized macro template library for each category; The standardized macro template library is uploaded to the target software platform template library to obtain the index relationship between each structured data and the corresponding standardized macro template library.

[0008] Furthermore, in some embodiments, the step of validating the plurality of structured data and obtaining first target structured data that meets preset validation conditions includes: Perform at least one of the following checks on the multiple structured data: integrity check, format check, and logical rationality check; Obtain first target structured data that meets preset verification conditions, and mark second target structured data that does not meet the preset verification conditions as abnormal.

[0009] Furthermore, in some embodiments, the automatic generation of the Typical table further includes: Based on the Typical table, the matching relationship between the device and the corresponding standardized macro template library is obtained; Determine whether there are any abnormalities in the matching relationship; If the matching relationship has the above-mentioned abnormal situation, then the abnormal device and the corresponding standardized macro template library will be detected and an early warning will be issued.

[0010] Furthermore, in some embodiments, synchronizing the Typical table to the target software platform and automatically generating at least one drawing based on the Typical table using the target software platform includes: The automatic generation and synchronization module of the target software platform is invoked, and the Typical table is automatically synchronized to the target software platform through the target component enhancement interface; At least one drawing is automatically generated based on the drawing generation instructions in the Typical table.

[0011] The automatic drawing generation method according to embodiments of this application involves acquiring and validating multiple structured data entries entered into a target Excel template, obtaining a first target structured data entry that meets preset validation conditions, and automatically generating a typical table based on the first target structured data and a pre-built standardized macro template library. The typical table is then synchronized to a target software platform, which automatically generates at least one drawing based on the typical table. This solves the problems of long design cycles, high error rates, and low standardization in electrical drawing design caused by high equipment duplication rates, diverse design standards, and reliance on experience for manual operation. By constructing a standardized macro template library and introducing a typical table, the structured data entered into the standardized Excel template is automatically converted into a matching relationship between the equipment and the macro template library after multi-dimensional validation. This drives the EPLAN platform to automatically generate various types of electrical drawings, thereby reducing the electrical drawing design cycle and error rate, and improving design efficiency, design standardization, and reusability.

[0012] A second aspect of this application provides an automatic drawing generation apparatus, comprising: The acquisition module is used to acquire multiple structured data entries entered into the target Excel template; The first generation module is used to verify the multiple structured data and obtain the first target structured data that meets the preset verification conditions. Based on the first target structured data and the pre-built standardized macro template library, a Typical table is automatically generated. The second generation module is used to synchronize the Typical table to the target software platform, and use the target software platform to automatically generate at least one drawing based on the Typical table.

[0013] Furthermore, in some embodiments, before acquiring the multiple structured data entered in the target Excel template, the acquisition module further includes: Design unit, used to design a standardized macro template library for each category based on at least one of the classification results of equipment type, equipment function and equipment voltage level; The first acquisition unit is used to upload the standardized macro template library to the target software platform template library to obtain the index relationship between each structured data and the corresponding standardized macro template library.

[0014] Furthermore, in some embodiments, the first generation module includes: The verification unit is used to perform at least one of the following on the plurality of structured data: integrity verification, format verification, and logical rationality verification. The marking unit is used to acquire first target structured data that meets preset verification conditions, and to mark second target structured data that does not meet the preset verification conditions as abnormal.

[0015] Furthermore, in some embodiments, the first generation module further includes: The second acquisition unit is used to obtain the matching relationship between the device and the corresponding standardized macro template library based on the Typical table; The judgment unit is used to determine whether there is any abnormality in the matching relationship; The detection unit is used to detect and issue an early warning for the abnormal device and the corresponding standardized macro template library if the abnormal situation exists in the matching relationship.

[0016] Furthermore, in some embodiments, the second generation module includes: The calling unit is used to call the automatic generation and synchronization module of the target software platform, and automatically synchronize the Typical table to the target software platform through the target component enhancement interface; The generation unit is used to automatically generate at least one drawing based on the drawing generation instructions of the Typical table.

[0017] The automatic drawing generation device according to an embodiment of this application acquires and verifies multiple structured data entered in a target Excel template, obtains a first target structured data that meets preset verification conditions, and automatically generates a typical table based on the first target structured data and a pre-built standardized macro template library. The typical table is then synchronized to a target software platform, which automatically generates at least one drawing based on the typical table. This solves the problems of long design cycles, high error rates, and low standardization in electrical drawing design caused by high equipment repetition rates, diverse design standards, and reliance on experience for manual operation. By constructing a standardized macro template library and introducing a typical table, the structured data entered in the standardized Excel template is automatically converted into a matching relationship between the equipment and the macro template library after multi-dimensional verification, thereby driving the EPLAN platform to automatically generate various types of electrical drawings. This reduces the electrical drawing design cycle and error rate, and improves design efficiency, design standardization, and reusability.

[0018] A third aspect of this application provides an electronic device, including: 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 automatic drawing generation method as described in the above embodiments.

[0019] A fourth aspect of this application provides a computer-readable storage medium storing computer instructions for causing the computer to execute the automatic drawing generation method as described in the above embodiments.

[0020] A fifth aspect of this application provides a computer program product, including a computer program that is executed to implement the automatic drawing generation method described in the above embodiments.

[0021] Additional aspects and advantages of this application will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of this application. Attached Figure Description

[0022] The above and / or additional aspects and advantages of this application will become apparent and readily understood from the following description of the embodiments taken in conjunction with the accompanying drawings, wherein: Figure 1 This is a flowchart of an automatic drawing generation method provided according to an embodiment of this application; Figure 2 This is a schematic diagram of the overall process according to one embodiment of this application; Figure 3 This is an example diagram of an automatic drawing generation apparatus according to an embodiment of this application; Figure 4 This is a schematic diagram of the structure of an electronic device according to an embodiment of this application. Detailed Implementation

[0023] The embodiments of this application are described in detail below. Examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and intended to explain this application, and should not be construed as limiting this application.

[0024] The following description, with reference to the accompanying drawings, describes an automatic drawing generation method, apparatus, electronic device, and storage medium according to embodiments of this application. Addressing the problems mentioned in the background art, such as high equipment repetition, diverse design standards, and reliance on experience in manual operation during electrical drawing design, resulting in long design cycles, high error rates, and low standardization, this application provides an automatic drawing generation method. In this method, multiple structured data entries are obtained from a target Excel template and validated to obtain a first target structured data that meets preset validation conditions. Based on the first target structured data and a pre-built standardized macro template library, a typical table is automatically generated. The typical table is synchronized to a target software platform, and the target software platform automatically generates at least one drawing based on the typical table. This solves the problems of long design cycles, high error rates, and low standardization in electrical drawing design caused by high equipment duplication, diverse design standards, and reliance on experience for manual operation. By building a standardized macro template library and introducing Typical tables, the structured data entered in the standardized Excel templates is automatically converted into a matching relationship between equipment and the macro template library after multi-dimensional verification. This drives the EPLAN platform to automatically generate various types of electrical drawings, thereby reducing the electrical drawing design cycle and error rate, and improving design efficiency, design standardization, and reusability.

[0025] Specifically, before introducing the embodiments of this application, we will first introduce the relevant technologies and existing technical problems of this application.

[0026] In the industrial sector, especially in automotive welding workshops, electrical drawing design mainly involves two types: modification and new manufacturing. Among these, the design time for new manufacturing projects is particularly heavy. At the same time, the number of similar electronic components and electrical equipment used in new manufacturing projects is extremely large. Finding templates for electrical equipment drawings and drawing the same equipment takes up a lot of time. Moreover, as the number of drawing design standards encountered gradually increases, the design layout of the same equipment differs under different standards, which can cause some confusion for designers who are not familiar with a particular standard, thus prolonging the drawing design time.

[0027] Companies in the industry are gradually moving towards intelligentization, digitalization, and automation. In electrical drawing design, although current standards are gradually becoming more unified and the drawing design process time has improved, limitations still exist due to the differences among designers, failing to fully realize the potential of intelligentization and automation. Therefore, how to further reduce reliance on designers' experience, improve the automation and standardization of drawing design, shorten the design cycle, and reduce the error rate are urgent technical problems to be solved in this field.

[0028] Therefore, based on the aforementioned technical problems, this application addresses the issue by filling in the name of the new project and the quantity and model of the electrical equipment, cabinets, robots, and other electronic devices in the Excal form, importing them into the EEC one software, and retrieving the equipment model and quantity from the EEC one equipment library (equipment templates already designed by maintenance personnel) in the Excal form. This generates corresponding electrical drawings of the specified quantity and type in the Eplan platform, including the drawing name, hierarchy, etc. Subsequently, designers only need to fill in the corresponding terminal names and wiring positions to complete the design of a set of electrical drawings, thus saving design time and costs.

[0029] Specifically, Figure 1 This is a flowchart illustrating an automatic drawing generation method provided in an embodiment of this application.

[0030] like Figure 1 As shown, the automatic generation method for this drawing includes the following steps: In step S101, multiple structured data entries are obtained from the target Excel template.

[0031] Furthermore, in some embodiments, before acquiring the multiple structured data entered in the target Excel template, the method further includes: designing a standardized macro template library for each category based on at least one classification result among device type, device function, and device voltage level; uploading the standardized macro template library to the target software platform template library to obtain the index relationship between each structured data and the corresponding standardized macro template library.

[0032] Specifically, such as Figure 2 As shown, firstly, based on at least one of the classification dimensions of equipment type, equipment function, and equipment voltage level, standardized macro template libraries for corresponding categories are designed and produced in the target software platform, namely the EPLAN platform. The equipment type includes, but is not limited to, at least one of motor, sensor, PLC (Programmable Logic Controller), and circuit breaker. The equipment function includes, but is not limited to, at least one of control, protection, communication, and power supply. The voltage level includes, but is not limited to, at least one of 24V DC (Direct Current), 220V AC (Alternating Current), and 380V AC.

[0033] Secondly, each standardized macro template library needs to predefine at least one variable parameter, which includes, but is not limited to, at least one of the following: device model, rated power, IO (Input / Output) address, and wire number prefix, in order to support parameterized configuration and batch modification. At the same time, it can enable the same standardized macro template to be adapted to the same type of device with different models, different power, and different addresses.

[0034] Finally, the completed standardized macro template library is uploaded to the target software platform's template library, namely the EPLAN template library, and version management, access control, and categorized indexing are implemented. For example, in version management, the creation and modification history of each standardized macro template is recorded, supporting version rollback and update notifications; in access control, different access permissions for different roles are set (e.g., read-only, editable, deleteable) to ensure the security and consistency of the standardized macro template library; in the categorized indexing, a mapping index relationship is established between each structured data and the corresponding standardized macro template library, so that the corresponding standardized macro template can be quickly retrieved and called based on the structured data in subsequent steps.

[0035] Furthermore, after designing and completing the standardized macro template library, it is necessary to perform Excel structured data entry and validation.

[0036] Specifically, such as Figure 2 As shown, firstly, designers in this field need to download the target Excel template from the system. The target Excel template in this application is a standardized Excel template, which includes worksheets such as "Equipment List," "IO List," "Cable List," and "Cabinet Layout." Secondly, designers enter multiple structured data into the target Excel template according to the requirements of the standardized macro template. This mainly includes: filling in the corresponding equipment name, model, quantity, installation location, etc. in the "Equipment List" worksheet; filling in the PLC input / output point addresses, signal types, etc. in the "IO List" worksheet; filling in the cable specifications, cable model, connection relationship, starting equipment, ending equipment, etc. in the "Cable List" worksheet; and filling in the equipment distribution in each electrical cabinet in the "Cabinet Layout" worksheet. After completing the entry of each structured data, subsequent verification work is performed.

[0037] In step S102, multiple structured data are validated, and a first target structured data that meets the preset validation conditions is obtained. Based on the first target structured data and a pre-built standardized macro template library, a Typical table is automatically generated.

[0038] Furthermore, in some embodiments, multiple structured data are validated, and a first target structured data that meets preset validation conditions is obtained, including: performing at least one of integrity validation, format validation, and logical rationality validation on the multiple structured data; obtaining the first target structured data that meets the preset validation conditions, and marking the second target structured data that does not meet the preset validation conditions as abnormal.

[0039] The preset verification conditions can be set by those skilled in the art based on the design requirements of the drawings, equipment performance, etc., and are not specifically limited here.

[0040] Specifically, after the input of each structured data is completed, it is necessary to further verify the structured data. That is, to automatically verify at least one of the following for each structured data: data integrity, format correctness, and logical rationality. Then, the structured data that meets the preset verification conditions is selected as the first target structured data that passes the verification, and the second target structured data that does not meet the preset verification conditions is marked as abnormal, for example, the erroneous data is highlighted in red, and one-click correction is supported.

[0041] Specifically, the system performs data integrity checks on all structured data, including verifying that all required fields have been filled in. For example, the "Equipment Model" field in the equipment list cannot be empty, the "IO Address" field in the IO list cannot be empty, and the "Starting Device" and "Ending Device" fields in the cable list cannot both be empty. It also performs format correctness checks on all structured data, ensuring that the data in each field conforms to preset format specifications. For example, the "Equipment Model" field should conform to encoding rules, and the "IO Address" field should conform to the PLC manufacturer's address format. Finally, it performs logical rationality checks on all structured data, checking for logical contradictions or inconsistencies between the data in each field. For example, it checks for duplicate IO addresses in the entire IO list; the same address cannot be assigned to two different measurement points or devices. If a duplicate address is detected, the system determines it as an "address conflict."

[0042] Furthermore, for any of the above-mentioned second structured data that fails the verification, it is determined that the second structured data does not meet the preset verification conditions. At this time, the system will make a visual anomaly mark in the Excel cell, such as a red highlight or error message. Designers can quickly locate the erroneous data according to the red highlight and make one-click correction or manual modification according to the prompt. After the correction is completed, the system will re-execute the verification until all structured data meets the preset verification conditions.

[0043] If all the above checks pass, the structured data is determined to meet the preset check conditions. At this time, the system outputs the first target structured data that has passed the check, which will be used as the input for the subsequent automatic generation of Typical tables.

[0044] Furthermore, in some embodiments, automatically generating a Typical table further includes: obtaining the matching relationship between the device and the corresponding standardized macro template library based on the Typical table; determining whether there are any abnormalities in the matching relationship; if there are any abnormalities in the matching relationship, performing anomaly detection and issuing an early warning for the abnormally matched device and the corresponding standardized macro template library.

[0045] Specifically, based on the verified first target structured data and standardized macro template library, the system automatically completes at least one of the following operations: matching equipment with standardized macro templates, assigning variable parameters, pre-assigning line numbers, and mapping connection relationships. Then, it performs conflict detection on the generated Typical table, including at least one of line number duplication detection and macro mapping error detection. If a conflict is detected, an early warning is issued, and designers can fine-tune, supplement, and confirm the Typical table. In response to the designer's confirmation operation, the Typical table is locked and used as input for automatic drawing generation.

[0046] Specifically, such as Figure 2 As shown, the system reads the verified first target structured data and, in conjunction with a pre-built standardized macro template library, automatically generates a Typical table with one click. The generation of the Typical table includes the following automated operations: setting the matching relationship between equipment and the corresponding standardized macro template library; that is, the system classifies and matches the equipment model, equipment type, voltage level, and function information in the first target structured data with macro templates in the standardized macro template library. After a successful macro template match, the system automatically assigns the specific values ​​from the first target structured data to the predefined variable parameters in the macro template. Then, the system automatically generates a unique wire number for each electrical connection point according to preset wire number coding rules and records it in the Typical table. After the wire number pre-assignment is completed, the system automatically establishes a one-to-one correspondence between wire numbers and equipment terminals, avoiding repetitive work and error risks associated with manual wire number labeling. Finally, the system automatically generates the electrical connection logic between devices based on the connection relationship fields in the first target structured data (such as "starting device - ending device" in the cable list) and records the mapping results in the Typical table.

[0047] Furthermore, after the Typical table is generated, the system automatically performs conflict detection to identify potential configuration errors. This mainly includes wire number duplication detection, macro mapping error detection, connection integrity detection, and voltage level consistency detection. Wire number duplication detection involves the system scanning all pre-assigned wire numbers in the Typical table to check for duplicate wire numbers assigned to different connection points. If a duplicate is detected, the system determines it as a "wire number conflict" and lists the conflicting wire number and its corresponding device terminal. Macro mapping error detection involves the system checking whether the macro template matching result for each device is valid. Connection integrity detection involves the system checking whether the connection relationships between devices are complete; for example, whether the connections recorded in the cable list have corresponding terminal mappings in the Typical table, and whether there are any isolated devices (without any connection relationships). Voltage level consistency detection involves the system checking whether devices in the same circuit have the same voltage level.

[0048] Furthermore, when any of the above conflicts are detected, an alert is issued, such as marking the cell containing the conflicting item in yellow or red in the Typical table, or popping up an error list window that lists all conflict types, locations, and suggested solutions.

[0049] Furthermore, designers can fine-tune, supplement, and confirm the Typical table based on the warning prompts. For example, they can manually modify the matching results (such as changing the macro template), adjust the line numbers, and supplement missing connection relationships; add devices or connections that the system cannot automatically match; review all configurations, and perform a locking operation after confirming that they are correct before entering the drawing generation stage.

[0050] Furthermore, after the Typical table is generated, the system also supports optimizing the sorting of the entries in the table, including but not limited to sorting by equipment type, cabinet location, and signal type, thereby improving the review experience for designers.

[0051] It should be noted that once the Typical table is locked, it enters a read-only state, and the system will no longer accept automatic or manual modifications to the table to ensure the consistency and traceability of data in subsequent drawing generation processes.

[0052] In step S103, the Typical table is synchronized to the target software platform, and the target software platform automatically generates at least one drawing based on the Typical table.

[0053] Furthermore, in some embodiments, the Typical table is synchronized to the target software platform, and the target software platform automatically generates at least one drawing based on the Typical table, including: calling the automatic generation and synchronization module of the target software platform, automatically synchronizing the Typical table to the target software platform through the target component enhancement interface; and automatically generating at least one drawing based on the drawing generation instructions of the Typical table.

[0054] Specifically, after generating the Typical table, the automatic generation and synchronization module of the EPLAN platform is invoked. Through the target component enhancement interface (i.e., the EEC One enhancement interface), the confirmed and locked Typical table data is automatically synchronized to the EPLAN platform. Then, based on the drawing generation instructions in the Typical table, schematic diagrams, wiring diagrams, terminal diagrams, and layout diagrams are generated in batches; the EPLAN equipment library is automatically associated; wire numbers are labeled; and BOM (Bill of Materials), equipment lists, and component lists are generated.

[0055] Specifically, firstly, the system calls the built-in automatic generation and synchronization module of the EPLAN platform. Through the EECOne enhanced interface, the Typical table data confirmed and locked in the previous stage is automatically synchronized to the EPLAN platform. The EECOne enhanced interface is a secondary development interface provided by EPLAN based on the .NET API (Application Programming Interface), which enables bidirectional read and write operations between external data and EPLAN projects. This application performs the following operations through this interface: reads the device matching relationship, variable assignment results, wire number allocation results, and connection mapping results of each record in the Typical table; converts the above data into project objects (such as pages, macro instances, connections, terminals, wire numbers, etc.) that the EPLAN platform can recognize; and creates the corresponding structural hierarchy in the EPLAN project.

[0056] Secondly, based on the configuration information in the Typical table, the system generates schematic diagrams, wiring diagrams, terminal diagrams, and layout diagrams in batches. The schematic diagram generation process involves batch inserting corresponding symbol macros and page macros into the EPLAN project according to the matching relationship between the device and the macro template, automatically completing page creation, macro placement, and connection line drawing. Each device corresponds to one or more schematic diagram pages, and the page name and description are automatically obtained from the Typical table. The wiring diagram generation process involves automatically generating wiring diagrams between local devices and field devices based on the connection mapping results, labeling cable types, core wire colors, terminal numbers, and other information. The terminal diagram generation process involves automatically generating terminal block diagrams based on wire number pre-assignment results and terminal block configuration information. The number, connection object, and wire number of each terminal are read from the Typical table and automatically labeled. The layout diagram generation process involves automatically generating electrical cabinet layout diagrams based on the cabinet layout information in the cabinet layout table, including cabinet dimensions, equipment installation positions, and guide rail layout.

[0057] Furthermore, while the drawings are being generated, the system automatically performs the following operations: automatically associating with the EPLAN equipment library, automatically labeling wire numbers, and generating a BOM (Bill of Materials), equipment list, and component list. Specifically, automatically associating with the EPLAN equipment library involves automatically associating the corresponding part number, technical parameters, order number, manufacturer, and other information from the EPLAN equipment library based on the equipment model matching results, ensuring the accuracy and completeness of the material information in the BOM. Automatically labeling wire numbers involves automatically labeling the wire numbers to the corresponding connection lines in the schematic diagram and wiring diagram based on the pre-assigned wire numbers in the Typical table, eliminating the need for designers to manually label each wire. Generating a BOM summarizes the model, quantity, and manufacturer information of all equipment, components, cables, and terminals used in the project. Automatically generating an equipment list categorizes all equipment and their technical parameters by equipment type. Automatically generating a component list lists the location and specifications of each component by page or cabinet.

[0058] Finally, after the drawings are generated, dynamic preview of the drawings is supported. The generated drawing preview window will automatically open in the EPLAN interface, allowing designers to intuitively view the content and layout of each page. Single-page viewing is also supported, meaning designers can flip through the drawings page by page to check the drawings, make local adjustments where necessary, and batch export the drawings of the entire project to common formats (such as PDF (Portable Document Format), DWG (Drawing), etc.). The generated drawing project will be automatically saved as a new version, and a backup copy will be created, allowing designers to roll back to previous versions and prevent data loss.

[0059] This application uses a specific project design drawing as an example for illustration: In the process of creating new drawings for a project, the designers first design the project themselves based on their own understanding and electrical knowledge. After the design is completed, the same designer redesigns the project using EEC one's automatic drawing generation method. The design time and accuracy of the two designs are compared to determine the time saved in the design.

[0060] Compared to the normal design time for drawings, designers unfamiliar with automatic drawing generation can save 30% of design time in projects by using EECone to automatically generate drawings. After the design is completed, the number of errors in error checking is reduced by 63%, which shows that automatic drawing production has great development potential.

[0061] In summary, this application can achieve the following beneficial effects: (1) Improve the efficiency of automatic drawing generation: realize the fully automatic generation of electrical drawings, shorten the design cycle of medium-sized projects (500-1000 points) from 15-30 days to 1-3 days, improve efficiency by 80%-90%, and reduce manual repetitive labor by more than 90%; (2) Significantly reduced error rate: Through structured data verification, intelligent matching, electrical rule verification, and one-click error correction, the error rate of drawings is reduced from 15%-30% to less than 1%, improving design quality and reliability; (3) Strong standardization and reusability: A standardized macro template library is built to support template reuse, parameterized configuration and version management; newcomers can get started with simple training, reducing the dependence on the experience of senior engineers and improving the overall design level of the team.

[0062] The automatic drawing generation method according to embodiments of this application involves acquiring and validating multiple structured data entries entered into a target Excel template, obtaining a first target structured data entry that meets preset validation conditions, and automatically generating a typical table based on the first target structured data and a pre-built standardized macro template library. The typical table is then synchronized to a target software platform, which automatically generates at least one drawing based on the typical table. This solves the problems of long design cycles, high error rates, and low standardization in electrical drawing design caused by high equipment duplication rates, diverse design standards, and reliance on experience for manual operation. By constructing a standardized macro template library and introducing a typical table, the structured data entered into the standardized Excel template is automatically converted into a matching relationship between the equipment and the macro template library after multi-dimensional validation. This drives the EPLAN platform to automatically generate various types of electrical drawings, thereby reducing the electrical drawing design cycle and error rate, and improving design efficiency, design standardization, and reusability.

[0063] Next, with reference to the accompanying drawings, an automatic drawing generation apparatus according to an embodiment of this application is described.

[0064] Figure 3 This is a block diagram of an automatic drawing generation device according to an embodiment of this application.

[0065] like Figure 3 As shown, the automatic drawing generation device 10 includes: an acquisition module 100, a first generation module 200, and a second generation module 300.

[0066] Among them, the acquisition module 100 is used to acquire multiple structured data entered in the target Excel template; The first generation module 200 is used to validate multiple structured data and obtain the first target structured data that meets the preset validation conditions. Based on the first target structured data and the pre-built standardized macro template library, it automatically generates a Typical table. The second generation module 300 is used to synchronize the Typical table to the target software platform and use the target software platform to automatically generate at least one drawing based on the Typical table.

[0067] Furthermore, in some embodiments, before acquiring the multiple structured data entered in the target Excel template, the acquisition module 100 further includes: Design unit, used to design a standardized macro template library for each category based on at least one of the classification results of equipment type, equipment function and equipment voltage level; The first acquisition unit is used to upload the standardized macro template library to the target software platform template library to obtain the index relationship between each structured data and the corresponding standardized macro template library.

[0068] Furthermore, in some embodiments, the first generation module 200 includes: A verification unit is used to perform at least one of the following checks on multiple structured data: integrity verification, format verification, and logical rationality verification. The marking unit is used to acquire the first target structured data that meets the preset verification conditions and to mark the second target structured data that does not meet the preset verification conditions as abnormal.

[0069] Furthermore, in some embodiments, the first generation module 200 further includes: The second acquisition unit is used to obtain the matching relationship between the device and the corresponding standardized macro template library based on the Typical table; The judgment unit is used to determine whether there are any abnormalities in the matching relationship; The detection unit is used to detect and issue warnings for devices with abnormal matching and their corresponding standardized macro template libraries if there are any abnormalities in the matching relationship.

[0070] Furthermore, in some embodiments, the second generation module 300 includes: The calling unit is used to call the automatic generation and synchronization module of the target software platform, and automatically synchronize the Typical table to the target software platform through the target component enhancement interface; The generation unit is used to automatically generate at least one drawing based on the drawing generation instructions of the Typical table.

[0071] The automatic drawing generation device according to an embodiment of this application acquires and verifies multiple structured data entered in a target Excel template, obtains a first target structured data that meets preset verification conditions, and automatically generates a typical table based on the first target structured data and a pre-built standardized macro template library. The typical table is then synchronized to a target software platform, which automatically generates at least one drawing based on the typical table. This solves the problems of long design cycles, high error rates, and low standardization in electrical drawing design caused by high equipment repetition rates, diverse design standards, and reliance on experience for manual operation. By constructing a standardized macro template library and introducing a typical table, the structured data entered in the standardized Excel template is automatically converted into a matching relationship between the equipment and the macro template library after multi-dimensional verification, thereby driving the EPLAN platform to automatically generate various types of electrical drawings. This reduces the electrical drawing design cycle and error rate, and improves design efficiency, design standardization, and reusability.

[0072] Figure 4 A schematic diagram of the structure of an electronic device provided in an embodiment of this application. The electronic device may include: The memory 401, the processor 402, and the computer program stored on the memory 401 and capable of running on the processor 402.

[0073] When the processor 402 executes the program, it implements the automatic drawing generation method provided in the above embodiments.

[0074] Furthermore, electronic devices also include: Communication interface 403 is used for communication between memory 401 and processor 402.

[0075] The memory 401 is used to store computer programs that can run on the processor 402.

[0076] Memory 401 may include high-speed RAM memory, and may also include non-volatile memory, such as at least one disk storage device.

[0077] If the memory 401, processor 402, and communication interface 403 are implemented independently, then the communication interface 403, memory 401, and processor 402 can be interconnected via a bus to complete communication between them. The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. Buses can be categorized into address buses, data buses, control buses, etc. For ease of representation, Figure 4 The bus is represented by a single thick line, but this does not mean that there is only one bus or one type of bus.

[0078] Optionally, in a specific implementation, if the memory 401, processor 402, and communication interface 403 are integrated on a single chip, then the memory 401, processor 402, and communication interface 403 can communicate with each other through an internal interface.

[0079] Processor 402 may be a central processing unit (CPU), an application specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of this application.

[0080] This embodiment also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the above-described method for automatically generating drawings.

[0081] This embodiment also provides a computer program product, including a computer program that is executed to implement the automatic drawing generation method of the above embodiment.

[0082] 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 this application. 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.

[0083] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of that feature. In the description of this application, "N" means at least two, such as two, three, etc., unless otherwise explicitly specified.

[0084] Any process or method described in the flowchart or otherwise herein can be understood as representing a module, segment, or portion of code comprising one or more N executable instructions for implementing custom logic functions or processes, and the scope of the preferred embodiments of this application includes additional implementations in which functions may be performed not in the order shown or discussed, including substantially simultaneously or in reverse order depending on the functions involved, as should be understood by those skilled in the art to which embodiments of this application pertain.

[0085] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as a sequenced list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by, or in conjunction with, an instruction execution system, apparatus, or device (such as a computer-based system, a processor-included system, or other system that can fetch and execute instructions from, an instruction execution system, apparatus, or device). For the purposes of this specification, "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transmit programs for use by, or in conjunction with, an instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of computer-readable media include: an electrical connection having one or more wires (electronic device), a portable computer disk drive (magnetic device), random access memory (RAM), read-only memory (ROM), erasable and editable read-only memory (EPROM or flash memory), fiber optic devices, and portable optical disc read-only memory (CDROM). Furthermore, computer-readable media can even be paper or other suitable media on which programs can be printed, because programs can be obtained electronically, for example, by optically scanning the paper or other media, followed by editing, interpreting, or otherwise processing as necessary, and then stored in computer memory.

[0086] It should be understood that the various parts of this application can be implemented using hardware, software, firmware, or a combination thereof. In the above embodiments, the N steps or methods can be implemented using software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware as in another embodiment, it can be implemented using any one or a combination of the following techniques known in the art: discrete logic circuits having logic gates for implementing logical functions on data signals, application-specific integrated circuits (ASICs) having suitable combinational logic gates, programmable gate arrays (PGAs), field-programmable gate arrays (FPGAs), etc.

[0087] Those skilled in the art will understand that all or part of the steps of the methods described in the above embodiments can be implemented by a program instructing related hardware, and the program can be stored in a computer-readable storage medium. When executed, the program includes one or a combination of the steps of the method embodiments.

[0088] Furthermore, the functional units in the various embodiments of this application can be integrated into a processing module, or each unit can exist physically separately, or two or more units can be integrated into a module. The integrated module can be implemented in hardware or as a software functional module. If the integrated module is implemented as a software functional module and sold or used as an independent product, it can also be stored in a computer-readable storage medium.

[0089] The storage medium mentioned above can be a read-only memory, a disk, or an optical disk, etc. Although embodiments of this application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting this application. Those skilled in the art can make changes, modifications, substitutions, and variations to the above embodiments within the scope of this application.

Claims

1. A method for automatically generating drawings, characterized in that, Includes the following steps: Retrieve multiple structured data entries entered into the target Excel template; The multiple structured data are validated, and a first target structured data that meets the preset validation conditions is obtained. Based on the first target structured data and a pre-built standardized macro template library, a Typical table is automatically generated. The Typical table is synchronized to the target software platform, and the target software platform automatically generates at least one drawing based on the Typical table.

2. The method according to claim 1, characterized in that, Before retrieving the multiple structured data entries entered into the target Excel template, the process also includes: Based on at least one classification result from equipment type, equipment function, and equipment voltage level, design a standardized macro template library for each category; The standardized macro template library is uploaded to the target software platform template library to obtain the index relationship between each structured data and the corresponding standardized macro template library.

3. The method according to claim 1, characterized in that, The step of validating the plurality of structured data and obtaining the first target structured data that meets the preset validation conditions includes: Perform at least one of the following checks on the multiple structured data: integrity check, format check, and logical rationality check; Obtain first target structured data that meets preset verification conditions, and mark second target structured data that does not meet the preset verification conditions as abnormal.

4. The method according to claim 1, characterized in that, The automatic generation of Typical tables also includes: Based on the Typical table, the matching relationship between the device and the corresponding standardized macro template library is obtained; Determine whether there are any abnormalities in the matching relationship; If the matching relationship has the above-mentioned abnormal situation, then the abnormal device and the corresponding standardized macro template library will be detected and an early warning will be issued.

5. The method according to claim 1, characterized in that, The step of synchronizing the Typical table to the target software platform and using the target software platform to automatically generate at least one drawing based on the Typical table includes: The automatic generation and synchronization module of the target software platform is invoked, and the Typical table is automatically synchronized to the target software platform through the target component enhancement interface; At least one drawing is automatically generated based on the drawing generation instructions in the Typical table.

6. An automatic drawing generation device, characterized in that, include: The acquisition module is used to acquire multiple structured data entries entered into the target Excel template; The first generation module is used to verify the multiple structured data and obtain the first target structured data that meets the preset verification conditions. Based on the first target structured data and the pre-built standardized macro template library, a Typical table is automatically generated. The second generation module is used to synchronize the Typical table to the target software platform, and use the target software platform to automatically generate at least one drawing based on the Typical table.

7. The apparatus according to claim 6, characterized in that, Before acquiring the multiple structured data entries entered into the target Excel template, the acquisition module further includes: Design unit, used to design a standardized macro template library for each category based on at least one of the classification results of equipment type, equipment function and equipment voltage level; The first acquisition unit is used to upload the standardized macro template library to the target software platform template library to obtain the index relationship between each structured data and the corresponding standardized macro template library.

8. The apparatus according to claim 6, characterized in that, The first generation module includes: The verification unit is used to perform at least one of the following on the plurality of structured data: integrity verification, format verification, and logical rationality verification. The marking unit is used to acquire first target structured data that meets preset verification conditions, and to mark second target structured data that does not meet the preset verification conditions as abnormal.

9. An electronic device, characterized in that, include: A memory, a processor, and a computer program stored in the memory and capable of running on the processor, the processor executing the program to implement the automatic drawing generation method as described in any one of claims 1-5.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, The program is executed by the processor to implement the automatic drawing generation method as described in any one of claims 1-5.

Images