CN111737202B - Software searching method for quickly searching duplicate drawings - Google Patents
Software searching method for quickly searching duplicate drawings Download PDFInfo
- Publication number
- CN111737202B CN111737202B CN202010412225.3A CN202010412225A CN111737202B CN 111737202 B CN111737202 B CN 111737202B CN 202010412225 A CN202010412225 A CN 202010412225A CN 111737202 B CN111737202 B CN 111737202B
- Authority
- CN
- China
- Prior art keywords
- file
- files
- establishing
- bom
- searching
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000010586 diagram Methods 0.000 description 6
- 230000010076 replication Effects 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/144—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/156—Query results presentation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/172—Caching, prefetching or hoarding of files
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a software searching method for quickly searching a reproduction drawing, which comprises the following operation steps: establishing an Excel file (xxls) and establishing a table name of a library file; establishing two columns of 'total graphs', 'subgraphs' in a library file; establishing a table name of 'map number to be searched', creating a column of 'total map', and filling in the file name to be searched; opening the program, setting data (1) to be checked, a drawing path (2), a storage path (3), an execution button and an execution result, and selecting a corresponding file; pressing an execution button; the 'queried data' is newly added at the position of the storage path (3), and all files collected in the folder are stored layer by layer in a BOM mode and clearly presented to a user. By means of the method, the system and the device, file retrieval and copying work in a single file or BOM form can be performed, the copied files can be accurately and rapidly queried, and the files are presented to a user in a BOM layer.
Description
Technical Field
The invention relates to the technical field of communication, in particular to a software searching method for quickly searching a replication drawing.
Background
Most search software in the market only meets the index function, can quickly search for required files, then performs copying and pasting, has no such function for searching product drawings (including subset drawings) in batches, and can align the drawings if the drawings are collected according to the traditional software, BOM is required to be collected first, then searching is performed according to the BOM, and copying and pasting are found again and repeated actions are performed continuously; if the method is adopted, the efficiency is extremely low, the labor cost is also extremely high, the prior art needs to be improved based on the defects and shortcomings, and a software searching method for quickly searching the copying drawing is designed.
Disclosure of Invention
The invention mainly solves the technical problem of providing a software searching method for quickly searching and copying drawings, wherein the program establishes a BOM relation in Excel, autonomously analyzes a BOM structure through the program, performs file retrieval and copying work in a single file or BOM form, can accurately and quickly search and copy files, and presents the files to a user in a BOM layer; the batch copying method copies files according to the BOM level, so that time is saved for users, tedious work is reduced, and the method is efficient and accurate.
In order to solve the technical problems, the invention adopts a technical scheme that: the software searching method for quickly searching the duplicate drawings comprises the following operation steps:
step one: establishing an Excel file (xxls) and establishing a table name of a library file;
step two: establishing two columns of total pictures and sub-pictures in a library file, filling upper-level picture numbers into the total picture column and filling corresponding lower-level picture numbers into the sub-picture column according to the upper-level and lower-level relation of the BOM, and establishing a multi-level BOM;
step three: establishing a table name of a map number to be searched, creating a column of a total map, and filling in a file name to be searched, a full name or a partial name;
step four: opening the program, wherein the software operation interface is provided with data to be checked (1), a drawing path (2), a storage path (3), an execution button and an execution result, and corresponding files are selected, wherein the Excel files established in the previous steps 1-3 are selected in the step (1), and the data are basic data of the query; (2) selecting the position of an original file library to be queried, wherein the file library has complete data, otherwise, the file cannot be found; (3) the process selects where to store the files screened by inquiry, the files can be added into a folder, and if the folder does not exist, the process can establish a new file by itself;
step five: pressing an execution button, at this time, the program starts to execute quickly, after execution, a completion dialog box pops up to inform the user, and all the inquired files are listed in the list below for review by the user;
step six: the 'queried data' is newly added at the position of the storage path (3), and files collected in the folder are all stored layer by layer in a BOM mode, so that the files can be clearly presented to a user.
Compared with the prior art, the invention has the beneficial effects that:
a duplicate single file may be retrieved;
a copy BOM hierarchy file may be retrieved;
the method has high speed and high efficiency, 50 BOM files are used as columns, the workload of manual inquiry and replication is at least 3 hours, and the program is only needed within 10 seconds;
the technical skill requirements of operators are reduced, and as shown in the description 4, the operators need the skills of common technicians, and common clerks can complete work by using the software;
accurate high-efficient: the program is executed through the set BOM data, so that the problems of error watching, error selection, error copying, error analysis and the like during manual operation are avoided;
the repeated errors are greatly reduced: if the provided library file has a problem once, the library file needs to be adjusted once, and the later stage can be completely avoided.
Drawings
Fig. 1 is a diagram of an operation interface of the present software.
FIG. 2 is a diagram of a multi-level BOM in a file library.
Fig. 3 is a table diagram of the map to be checked.
Fig. 4 is an indication diagram of the operation interface of the present software.
Fig. 5 is a diagram of the software execution interface.
FIG. 6 is a diagram of a data interface queried by the present software save path.
Detailed Description
The preferred embodiments of the present invention will be described in detail below with reference to the accompanying drawings so that the advantages and features of the present invention can be more easily understood by those skilled in the art, thereby making clear and defining the scope of the present invention.
Referring to fig. 1 to 6, an embodiment of the present invention includes:
a software searching method for quickly searching duplicate drawings comprises the following operation steps:
step one: establishing an Excel file (xxls) and establishing a table name of a library file;
step two: establishing two columns of total pictures and sub-pictures in a library file, filling upper-level picture numbers into the total picture column and filling corresponding lower-level picture numbers into the sub-picture column according to the upper-level and lower-level relation of the BOM, and establishing a multi-level BOM as shown in figure 2;
step three: establishing a table name of 'map number to be searched', creating a new column of 'total map', and filling in the file name, full name or partial name to be searched, as shown in fig. 3;
step four: opening the program, as shown in fig. 4, the software operation interface is provided with data to be checked (1), a drawing path (2), a storage path (3), an execution button and an execution result, and selecting a corresponding file, wherein the Excel file established in the previous steps 1-3 is selected in the step (1), and the data is basic data of the query; (2) selecting the position of an original file library to be queried, wherein the file library has complete data, otherwise, the file cannot be found; (3) the process selects where to store the files screened by inquiry, the files can be added into a folder, and if the folder does not exist, the process can establish a new file by itself;
step five: pressing the execution button, the program starts to execute quickly, after execution, the completion dialog box pops up to inform the user, and all the inquired files are listed in the list below for review by the user, as shown in fig. 5;
step six: the queried data is newly added at the position of the storage path (3), and files collected in the folder are all stored layer by layer in a BOM form, so that the files can be clearly presented to a user; as shown in fig. 6.
According to the software searching method for quickly searching the replication drawings, the program establishes the BOM relation in Excel, autonomously analyzes the BOM structure through the program, performs file searching and replication work in a single file or BOM form, can accurately and quickly search and replicate files, and presents the files to a user in a BOM layer; the batch copying method copies files according to the BOM level, so that time is saved for users, tedious work is reduced, and the method is efficient and accurate.
The foregoing description is only illustrative of the present invention and is not intended to limit the scope of the invention, and all equivalent structures or equivalent processes or direct or indirect application in other related technical fields are included in the scope of the present invention.
Claims (1)
1. A software searching method for quickly searching duplicate drawings is characterized in that: the software searching method for quickly searching the duplicate drawings comprises the following operation steps:
step one: establishing an Excel file (xxls) and establishing a table name of a library file;
step two: establishing two columns of total pictures and sub-pictures in a library file, filling upper-level picture numbers into the total picture column and filling corresponding lower-level picture numbers into the sub-picture column according to the upper-level and lower-level relation of the BOM, and establishing a multi-level BOM;
step three: establishing a table name of a map number to be searched, creating a column of a total map, and filling in a file name to be searched, a full name or a partial name;
step four: opening the program, wherein the software operation interface is provided with data to be checked (1), a drawing path (2), a storage path (3), an execution button and an execution result, and corresponding files are selected, wherein the Excel files established in the previous steps 1-3 are selected in the step (1), and the data are basic data of the query; (2) selecting the position of an original file library to be queried, wherein the file library has complete data, otherwise, the file cannot be found; (3) the process selects where to store the files screened by inquiry, the files can be added into a folder, and if the folder does not exist, the process can establish a new file by itself;
step five: pressing an execution button, at this time, the program starts to execute quickly, after execution, a completion dialog box pops up to inform the user, and all the inquired files are listed in the list below for review by the user;
step six: the 'queried data' is newly added at the position of the storage path (3), and files collected in the folder are all stored layer by layer in a BOM mode, so that the files can be clearly presented to a user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010412225.3A CN111737202B (en) | 2020-05-15 | 2020-05-15 | Software searching method for quickly searching duplicate drawings |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010412225.3A CN111737202B (en) | 2020-05-15 | 2020-05-15 | Software searching method for quickly searching duplicate drawings |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111737202A CN111737202A (en) | 2020-10-02 |
| CN111737202B true CN111737202B (en) | 2023-12-19 |
Family
ID=72647302
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010412225.3A Active CN111737202B (en) | 2020-05-15 | 2020-05-15 | Software searching method for quickly searching duplicate drawings |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111737202B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20120122392A (en) * | 2011-04-29 | 2012-11-07 | 현대로템 주식회사 | BOM management method of product data management system and BOM management system |
| CN103440550A (en) * | 2013-08-22 | 2013-12-11 | 山西煤矿机械制造有限责任公司 | Two-dimensional drawing baseline management method in PDM system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7437358B2 (en) * | 2004-06-25 | 2008-10-14 | Apple Inc. | Methods and systems for managing data |
-
2020
- 2020-05-15 CN CN202010412225.3A patent/CN111737202B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20120122392A (en) * | 2011-04-29 | 2012-11-07 | 현대로템 주식회사 | BOM management method of product data management system and BOM management system |
| CN103440550A (en) * | 2013-08-22 | 2013-12-11 | 山西煤矿机械制造有限责任公司 | Two-dimensional drawing baseline management method in PDM system |
Non-Patent Citations (3)
| Title |
|---|
| CAXA图纸管理系统在技术文件管理上的应用;蒋建军;CAD/CAM与制造业信息化(08);全文 * |
| 基于EXCEL图库图形查询系统的实现;王;王继仁;刘伟;;计算机时代(04);全文 * |
| 基于PDM的数控图文档管理;周晓虹;;装备机械(01);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111737202A (en) | 2020-10-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11468103B2 (en) | Relational modeler and renderer for non-relational data | |
| US8099400B2 (en) | Intelligent storing and retrieving in an enterprise data system | |
| US20070214104A1 (en) | Method and system for locking execution plan during database migration | |
| JP3779431B2 (en) | Relational database management device, intermediate link table automatic creation processing method, and program storage medium | |
| CN101356527A (en) | File system dump/restore by node numbering | |
| WO2015162588A1 (en) | Database interface creation system and method | |
| JP2002189757A (en) | Device and method for data retrieval | |
| CN111737202B (en) | Software searching method for quickly searching duplicate drawings | |
| CN116737113B (en) | Metadata catalog management system and method for mass scientific data | |
| CN113792026A (en) | Deployment method and device of database script and computer readable storage medium | |
| CN117709306A (en) | Literature review generation method based on large language model | |
| CN108388589B (en) | Device for automatically generating sql query statement of database | |
| JP2004145706A (en) | Multimedia data retrieval system | |
| CN112579456B (en) | Web automatic testing method and device | |
| CN114564463A (en) | Automatic script generation method and device | |
| CN108038144B (en) | Method and tool for quickly modifying man-machine interaction engineering information of complex system | |
| CN105069174A (en) | Configurable A+B mode record navigation method | |
| CN118445308B (en) | Method, system and product for testing correctness of column transfer function based on storage process | |
| CN115408474B (en) | Block chain mass data storage certificate system and method for multi-source database | |
| JPH06214768A (en) | Program part generation method and automatic program generation method | |
| CN114443728B (en) | Detection report searching method and device based on Elasticissearch | |
| US20240354330A1 (en) | Dynamic bin creation | |
| CN115982104A (en) | Tool for quickly retrieving modified items in folder based on computer | |
| JPH0934906A (en) | Book management device | |
| JP3375860B2 (en) | Observation data analyzer and medium recording analysis processing procedure management program |
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 | ||
| CB02 | Change of applicant information |
Address after: 2599 Linhu Avenue, Lili Town, Wujiang District, Suzhou City, Jiangsu Province Applicant after: Jiangsu Youli Intelligent Equipment Co.,Ltd. Address before: 2599 Linhu Avenue, Lili Town, Wujiang District, Suzhou City, Jiangsu Province Applicant before: JIANGSU YOULI INTELLIGENT EQUIPMENT Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |