CN114398857A - Automatic batch filling method for attribute information of picture frame title bar of CAD drawing - Google Patents
Automatic batch filling method for attribute information of picture frame title bar of CAD drawing Download PDFInfo
- Publication number
- CN114398857A CN114398857A CN202111410810.0A CN202111410810A CN114398857A CN 114398857 A CN114398857 A CN 114398857A CN 202111410810 A CN202111410810 A CN 202111410810A CN 114398857 A CN114398857 A CN 114398857A
- Authority
- CN
- China
- Prior art keywords
- attribute information
- title bar
- filling
- storing
- database table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an automatic batch filling method for drawing frame title bar information of CAD drawings, and relates to the field of CAD drawing frame title bar information filling methods. In the power design industry, attribute information of title bar drawing frames of CAD drawings is mostly manually filled, the workload is large, and the efficiency is low. The method comprises the steps of 1) establishing a database table of attribute information and a dwg signature file; 2) reading the drawing number in the database table and storing the drawing number in a set; 3) drawing numbers are extracted, and drawings are opened; 4) detecting attribute information required to be filled; 5) calculating the insertion position of the attribute information; 6) extracting attribute information according to the drawing number; 7) inserting attribute information; 8) and detecting whether the drawing which is filled in currently is the last drawing in the set, if so, finishing, otherwise, returning to the step 3). The method conveniently realizes automatic filling of the title bar and the drawing frame attributes of a large number of drawings, and reduces the workload of filling the title bar of the CAD drawing frame compared with the traditional method of manually opening the drawing frame title bar.
Description
Technical Field
The invention relates to the field of CAD (computer-aided design) drawing frame title bar information filling methods, in particular to an automatic batch filling method for drawing frame title bar information of a CAD drawing.
Background
Because CAD has advantages such as commonality, ease of use, in the electric power design industry, the drawing work of design drawing is mainly accomplished through CAD software. The picture frame information needs to be filled in the final stage of design, at present, the work is still completed through manual form filling, because the number of drawings in the construction drawing design stage in the power design industry is large, the information data of a picture frame title bar is large, the manual form filling operation mode is low in efficiency, consumes time for a long time, is greatly influenced by human factors in correctness, and often requires a great deal of energy of designers to repeat operation and inspection.
At present, with the wide application of the PDM software, the technology for automatically filling in the drawing frames in batches is relatively widely applied, but the automatic filling technology is mainly realized in an auditing stage in a PDM system, only aiming at a personnel signature module, the PDM is high in price, large in implementation workload and large in use limitation, and aiming at the problem that when the PDM management software is not used, the automatic filling of various attribute information of a large number of drawing files cannot be solved, only various attribute information and personnel signatures can be manually filled, the workload is large, and the working efficiency is low.
Disclosure of Invention
The technical problem to be solved and the technical task to be solved by the invention are to perfect and improve the prior technical scheme, and provide an automatic batch filling method for the information of the drawing frame title bar of the CAD drawing, so as to reduce the workload of filling the drawing frame title bar of the CAD drawing. Therefore, the invention adopts the following technical scheme.
An automatic batch filling method for attribute information of a drawing frame title bar of a CAD drawing comprises the following steps:
1) storing various attribute information including drawing names and drawing numbers to be filled in drawing frames and title columns of all drawings in a database table file, wherein signature blocks related to personnel names are correspondingly stored in a folder in a dwg format according to the names of the personnel names through mapping relations in the database table;
2) traversing a database table, reading the drawing numbers of all drawings, and storing the drawing numbers into a set;
3) traversing the drawing numbers in the set, obtaining a drawing file opening path by combining the drawing storing folder path with the drawing numbers, and opening the corresponding drawing according to the drawing file path;
4) traversing all objects of the 'Text' type in the opened drawing, and recording the coordinates of the traversed 'Text' objects if the character string contents of the traversed 'Text' objects are consistent with the filling targets;
5) according to the filling target coordinate, determining an insertion position by increasing a horizontal coordinate value;
6) extracting each attribute information from a database table storing the association relation according to the drawing number, and storing the attribute information into a set of mapping relations;
7) extracting attribute information in the set according to the corresponding relation, inserting the corresponding attribute information into the insertion position calculated in the step 5), wherein the inserted attribute information comprises a signature block obtained according to the mapping relation, and storing and closing the current drawing;
8) and detecting whether the drawing which is filled in currently is the last drawing in the set, if so, finishing, otherwise, returning to the step 3). Compared with the traditional mode of manually opening the drawing to fill in the title column of the drawing frame one by one, the method improves the work efficiency and the filling quality of the drawing design, reduces the work load of filling in the title column of the CAD drawing frame, can realize the comprehensive filling of the attribute information in the title column of the drawing frame without using PDM software, and can effectively reduce the cost.
As a preferable technical means: in the step 1), the database table file adopts an EXCEL table. The use is universal, and the maintenance is simple.
As a preferable technical means: in the step 1), the attribute information comprises a construction unit, a project name, a picture size, approval, design, verification, date, proportion, a drawing number and a signature of an approval, design, verification and verification person corresponding to the drawing number. And the complete filling of the attribute information is realized.
Has the advantages that: compared with the traditional mode of manually opening the drawing to fill in the title bar of the drawing frame one by one, the method improves the work efficiency and the filling quality of the drawing design, reduces the work load of filling in the title bar of the CAD drawing frame, can realize the comprehensive filling of the attribute information in the title bar of the drawing frame without using PDM software, and can effectively reduce the cost.
Drawings
FIG. 1 is a schematic flow diagram of the present invention.
Detailed Description
The technical scheme of the invention is further explained in detail by combining the drawings in the specification.
As shown in fig. 1, an automatic batch filling method for attribute information of a frame title bar of a CAD drawing includes the following steps:
1) storing various attribute information including drawing names and drawing numbers to be filled in drawing frames and title columns of all drawings in a database table file, wherein signature blocks related to personnel names are correspondingly stored in a folder in a dwg format according to the names of the personnel names through mapping relations in the database table;
2) running CAD software, calling a picture frame automatic filling program, traversing a database table, importing corresponding drawings, reading drawing numbers of all the drawings, and storing the drawing numbers into a set;
3) traversing the drawing numbers in the set, obtaining a drawing file opening path by combining the drawing storing folder path with the drawing numbers, and opening the corresponding drawing according to the drawing file path;
4) traversing all objects of the 'Text' type in the opened drawing, and recording the coordinates of the traversed 'Text' objects if the character string contents of the traversed 'Text' objects are consistent with the filling targets;
5) determining an insertion position by adding a horizontal coordinate value according to the filling target coordinate, taking a text object named as 'approved' as an example, acquiring coordinates (x, y) of the text object, adding the value on the x coordinate to be used as a new x coordinate x1, keeping the value unchanged to obtain an insertion coordinate, and then acquiring a signature attribute insertion coordinate of the insertion coordinate;
6) extracting each attribute information from a database table storing the association relation according to the drawing number, and storing the attribute information into a set of mapping relations;
7) extracting attribute information in the set according to the corresponding relation, inserting the corresponding attribute information into the insertion position calculated in the step 5), wherein the inserted attribute information comprises a signature block obtained according to the mapping relation, and storing and closing the current drawing;
8) and detecting whether the drawing which is filled in currently is the last drawing in the set, if so, finishing, and if not, returning to the step 3), and continuously processing by opening a new drawing until traversal is finished.
In this example, the database table file takes EXCEL tables. The use is universal, and the maintenance is simple.
In this example, the attribute information includes a construction unit, a project name, a drawing size, approval, design, verification, date, proportion, a drawing number, and a signature of an approval, design, verification, and verification person corresponding to the drawing number. And the complete filling of the attribute information is realized.
In this example, the programming language adopts Python to perform secondary development of CAD software, and an array or a list container is used as a storage set.
The method for automatically filling the attribute information of the frame title bar of the CAD drawing shown in fig. 1 is a specific embodiment of the present invention, has shown the outstanding substantive features and significant progress of the present invention, and can make equivalent modifications in terms of shape, structure, etc. according to the practical use requirements, and is within the scope of protection of the present invention.
Claims (3)
1. An automatic batch filling method for attribute information of a drawing frame title bar of a CAD drawing is characterized by comprising the following steps:
1) storing various attribute information including drawing names and drawing numbers to be filled in drawing frames and title columns of all drawings in a database table file, wherein signature blocks related to personnel names are correspondingly stored in a folder in a dwg format according to the names of the personnel names through mapping relations in the database table;
2) traversing a database table, reading the drawing numbers of all drawings, and storing the drawing numbers into a set;
3) traversing the drawing numbers in the set, obtaining a drawing file opening path by combining the drawing storing folder path with the drawing numbers, and opening the corresponding drawing according to the drawing file path;
4) (ii) a Traversing all objects of the 'Text' type in the opened drawing, and recording the coordinates of the traversed 'Text' objects if the character string contents of the traversed 'Text' objects are consistent with the filling targets;
5) according to the filling target coordinate, determining an insertion position by increasing a horizontal coordinate value;
6) extracting each attribute information from a database table storing the association relation according to the drawing number, and storing the attribute information into a set of mapping relations;
7) extracting attribute information in the set according to the corresponding relation, inserting the corresponding attribute information into the insertion position calculated in the step 5), wherein the inserted attribute information comprises a signature block obtained according to the mapping relation, and storing and closing the current drawing;
8) and detecting whether the drawing which is filled in currently is the last drawing in the set, if so, finishing, otherwise, returning to the step 3).
2. The method according to claim 1, wherein the method comprises the following steps: in the step 1), the database table file adopts an EXCEL table.
3. The method according to claim 1, wherein the method comprises the following steps: in the step 1), the attribute information comprises a construction unit, a project name, a picture size, approval, design, verification, date, proportion, a drawing number and a signature of an approval, design, verification and verification person corresponding to the drawing number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111410810.0A CN114398857B (en) | 2021-11-19 | 2021-11-19 | Automatic batch filling method for attribute information of frame title bar of CAD drawing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111410810.0A CN114398857B (en) | 2021-11-19 | 2021-11-19 | Automatic batch filling method for attribute information of frame title bar of CAD drawing |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114398857A true CN114398857A (en) | 2022-04-26 |
| CN114398857B CN114398857B (en) | 2025-08-15 |
Family
ID=81225372
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111410810.0A Active CN114398857B (en) | 2021-11-19 | 2021-11-19 | Automatic batch filling method for attribute information of frame title bar of CAD drawing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114398857B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2025021229A1 (en) * | 2023-07-25 | 2025-01-30 | 邓克凡 | Engineering design preamble information generation method, information display method and drawing examination method |
| CN119513950A (en) * | 2024-09-05 | 2025-02-25 | 长江勘测规划设计研究有限责任公司 | A method and system for batch generating AutoCAD drawing layouts with automatic title bar updates |
| CN119622885A (en) * | 2024-11-29 | 2025-03-14 | 佛山轨道交通设计研究院有限公司 | A method and system for information management and automatic layout of engineering design drawing frames |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6199079B1 (en) * | 1998-03-09 | 2001-03-06 | Junglee Corporation | Method and system for automatically filling forms in an integrated network based transaction environment |
| CN101055601A (en) * | 2006-04-12 | 2007-10-17 | 鸿富锦精密工业（深圳）有限公司 | Quick inserting pattern frame system and method |
| CN102830979A (en) * | 2012-08-30 | 2012-12-19 | 江苏省交通科学研究院股份有限公司 | CAD (computer-aided design) drawing information batch processing method based on ObjectArx |
| CN108090256A (en) * | 2017-11-30 | 2018-05-29 | 江西洪都航空工业集团有限责任公司 | A kind of lever diagram Automatic Drawing method based on CAD |
| CN110750840A (en) * | 2019-09-17 | 2020-02-04 | 东莞市超图软件科技有限公司 | Method and device for automatically generating two-dimensional part view based on three-dimensional model |
| CN111353284A (en) * | 2020-02-18 | 2020-06-30 | 广州明珞汽车装备有限公司 | Part drawing title bar filling method, system and storage medium |
| CN111739119A (en) * | 2020-05-15 | 2020-10-02 | 广州明珞汽车装备有限公司 | Method, system, device and storage medium for inserting picture frame |
| US20200364310A1 (en) * | 2019-05-17 | 2020-11-19 | Autodesk, Inc. | Seamless three-dimensional design collaboration |
| CN112116011A (en) * | 2020-09-21 | 2020-12-22 | 上海晓材科技有限公司 | Feature coding method and similarity comparison method for CAD graph |
-
2021
- 2021-11-19 CN CN202111410810.0A patent/CN114398857B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6199079B1 (en) * | 1998-03-09 | 2001-03-06 | Junglee Corporation | Method and system for automatically filling forms in an integrated network based transaction environment |
| CN101055601A (en) * | 2006-04-12 | 2007-10-17 | 鸿富锦精密工业（深圳）有限公司 | Quick inserting pattern frame system and method |
| CN102830979A (en) * | 2012-08-30 | 2012-12-19 | 江苏省交通科学研究院股份有限公司 | CAD (computer-aided design) drawing information batch processing method based on ObjectArx |
| CN108090256A (en) * | 2017-11-30 | 2018-05-29 | 江西洪都航空工业集团有限责任公司 | A kind of lever diagram Automatic Drawing method based on CAD |
| US20200364310A1 (en) * | 2019-05-17 | 2020-11-19 | Autodesk, Inc. | Seamless three-dimensional design collaboration |
| CN110750840A (en) * | 2019-09-17 | 2020-02-04 | 东莞市超图软件科技有限公司 | Method and device for automatically generating two-dimensional part view based on three-dimensional model |
| CN111353284A (en) * | 2020-02-18 | 2020-06-30 | 广州明珞汽车装备有限公司 | Part drawing title bar filling method, system and storage medium |
| CN111739119A (en) * | 2020-05-15 | 2020-10-02 | 广州明珞汽车装备有限公司 | Method, system, device and storage medium for inserting picture frame |
| CN112116011A (en) * | 2020-09-21 | 2020-12-22 | 上海晓材科技有限公司 | Feature coding method and similarity comparison method for CAD graph |
Non-Patent Citations (2)
| Title |
|---|
| P. VAXIVIERE等: "Celesstin: CAD conversion of mechanical drawings", COMPUTER, vol. 25, no. 07, 6 August 2002 (2002-08-06) * |
| 矫健等: "AutoCAD图形参数化设计在快速绘图过程中的应用", 万方, 21 April 2012 (2012-04-21) * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2025021229A1 (en) * | 2023-07-25 | 2025-01-30 | 邓克凡 | Engineering design preamble information generation method, information display method and drawing examination method |
| CN119513950A (en) * | 2024-09-05 | 2025-02-25 | 长江勘测规划设计研究有限责任公司 | A method and system for batch generating AutoCAD drawing layouts with automatic title bar updates |
| CN119622885A (en) * | 2024-11-29 | 2025-03-14 | 佛山轨道交通设计研究院有限公司 | A method and system for information management and automatic layout of engineering design drawing frames |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114398857B (en) | 2025-08-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114398857A (en) | Automatic batch filling method for attribute information of picture frame title bar of CAD drawing | |
| WO2020233330A1 (en) | Batch testing method, apparatus, and computer-readable storage medium | |
| CN107220274B (en) | Visual data interface market realization method | |
| CN112418812A (en) | Distributed full-link automatic intelligent clearance system, method and storage medium | |
| CN101859303A (en) | Metadata management method and management system | |
| CN115017272B (en) | Intelligent verification method and device based on registration data | |
| CN111680487B (en) | Method and equipment for real-time online checking of archived files | |
| CN101996380A (en) | Method, device and system for searching incorrect account | |
| CN108280562A (en) | A kind of method of specification electric power enterprise data resource | |
| CN111931780A (en) | Intelligent management method and equipment for accounting documents | |
| CN118708604A (en) | SQL database query method, question-answering method and system with intention recognition | |
| CN113722352B (en) | Intelligent data verification method, system and storage medium for price reporting scheme | |
| Minggao et al. | Research on the application of llm in power finance middle platform | |
| CN111626029B (en) | Project consultation budget method and device and electronic equipment | |
| CN114549014A (en) | Supply chain financial wind control method and system based on combination of automatic and manual auditing | |
| CN118297037A (en) | Method and device for generating examination manuscript, electronic equipment and storage medium | |
| CN115034917B (en) | A method and device for screening risk information of social security fund disbursement data | |
| CN117992523A (en) | Method and device for generating data acquisition flow | |
| CN113610594B (en) | Equipment review price data processing method and system | |
| CN113610512A (en) | Electronic signature generation method, device, equipment and storage medium | |
| CN116956837A (en) | Project determining method and device for engineering quantity list | |
| CN119693153B (en) | A method and system for automatically generating bond project implementation plans | |
| CN114089957A (en) | Method, device and equipment for acquiring service logic code set of insurance service | |
| TW201327432A (en) | Scalable order data validation method | |
| CN114119938B (en) | A batch processing method for verifying and assigning urban building data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |