CN110059121B - Method, system, device and storage medium for rapidly exporting bill of materials - Google Patents
Method, system, device and storage medium for rapidly exporting bill of materials Download PDFInfo
- Publication number
- CN110059121B CN110059121B CN201910185501.4A CN201910185501A CN110059121B CN 110059121 B CN110059121 B CN 110059121B CN 201910185501 A CN201910185501 A CN 201910185501A CN 110059121 B CN110059121 B CN 110059121B
- Authority
- CN
- China
- Prior art keywords
- bill
- preset
- content
- cells
- cell
- 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
Images
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/15—Vehicle, aircraft or watercraft design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/20—Design optimisation, verification or simulation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Geometry (AREA)
- Computer Hardware Design (AREA)
- Databases & Information Systems (AREA)
- Evolutionary Computation (AREA)
- Pure & Applied Mathematics (AREA)
- Computational Mathematics (AREA)
- Mathematical Optimization (AREA)
- Aviation & Aerospace Engineering (AREA)
- Automation & Control Theory (AREA)
- Human Computer Interaction (AREA)
- Mathematical Analysis (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method, a system, a device and a storage medium for rapidly exporting a bill of materials, wherein the method comprises the following steps: after a plurality of objects needing to be exported are selected through a CATIA software interface, a plurality of bill of material files are obtained and exported according to input information; and processing the exported bill of material files sequentially through a secondary development interface of Excel, and outputting the final bill of material files in batches. According to the invention, after the bill of material file is exported from the CATIA software, the bill of material file is automatically opened in the Excel software, and the final bill of material file is output in batch after corresponding processing is carried out according to the preset program, so that the complicated operation is not required to be carried out manually, the speed of exporting the file is greatly improved, the production efficiency is indirectly improved, the error caused by the manual operation is avoided, the quality of design and production is improved, and the method can be widely applied to the technical field of file export of CATIA software.
Description
Technical Field
The invention relates to the technical field of file export of CATIA software, in particular to a method, a system, a device and a storage medium for rapidly exporting a bill of materials.
Background
At present, the three-dimensional design software CATIA under Dasuo flag is widely applied to tool design of automobile equipment integrators, curved surface design of automobiles and airplanes and the like. In the production process, since the design downstream department needs to provide the material quantity and the characteristics of the related attribute data of the material, the designer needs to export the designed object to one or more bill of materials.
When exporting the bill of materials of the design object in the application software CATIA, the designer now does the process of organizing the design object according to the corresponding industry standard form, then selects the design object needing to export the bill of materials on the structure tree, opens the new window, picks up the member needing to export the bill of materials in the attribute of the child member of the object, after confirming that there is no error, makes the design object enter the CATIA assembly module, double-clicks the design object node, then finds the "bill of materials" command in the "analysis" menu bar of the CATIA, clicks the definition format again in the popped-up window, arranges the attribute correctly according to the format required by the bill of materials, closes the pop-up window, clicks the alternative storage in the bill of materials interface, fills in the file name of the bill of materials of the design object, and stores in the ". xls" format, then opens the file by Excel, deletes the redundant and wrong rows and columns, and the rest content is sorted or filled correctly according to the corresponding industry standard format. When the equipment objects with multiple bills of materials need to be exported, the designer needs to repeat the above process for many times. The method is too tedious, the designer needs to spend more time for operation, the working time of the designer is seriously consumed, the production efficiency is also reduced, errors are easy to occur in the operation process, and the quality of design and production is influenced.
Disclosure of Invention
In order to solve the technical problems, the invention aims to provide a method, a system, a device and a storage medium for automatically and rapidly exporting bills of materials in batches.
The first technical scheme adopted by the invention is as follows:
a method for rapidly exporting a bill of materials comprises the following steps:
after a plurality of objects needing to be exported are selected through a CATIA software interface, a plurality of bill of material files are obtained and exported according to input information;
and processing the exported bill of material files sequentially through a secondary development interface of Excel, and outputting the final bill of material files in batches.
Further, the step of processing the exported bill of material file sequentially through the secondary development interface of Excel specifically includes the following steps:
deleting corresponding contents in the bill of material file sequentially through a secondary development interface of Excel;
and modifying the deleted content and adjusting the position of the content.
Further, the step of deleting corresponding contents in the bill of material file sequentially through the secondary development interface of Excel specifically comprises the following steps:
after a bill of material file is opened in an Excel format, sequentially identifying the contents of cells in a first preset row in the bill of material file, and deleting the rows before the row number after the row number of the first cell with the contents as a first preset identifier is obtained;
sorting the bill of material files according to the contents of the cells in the first preset column;
and sequentially obtaining second cells of a second preset column of the bill of material file, judging whether the second cells are empty, and deleting the row where the second cells are located when the second cells are judged to be empty.
Further, the step of sorting the bill of material file according to the contents of the cells in the first preset column specifically includes:
and performing ascending sequencing on the expanded selected areas of the bill of material file according to the contents of the cells in the first preset column.
Further, the step of modifying the deleted content and adjusting the position of the content specifically includes the following steps:
sequentially acquiring third cells of a third preset column, judging whether the content of the third cells is a second preset identifier, and replacing the content of the third cells with preset content when the content of the third cells is judged to be the second preset identifier;
respectively acquiring a fourth cell with the cell content being a third preset identifier and a fifth cell with the cell content being a fourth preset identifier in the first preset column, and exchanging the row where the fourth cell is located with the row where the fifth cell is located;
and judging whether the content of the cell in the fourth preset column of the row in which the fourth cell is positioned is a fifth preset identifier, and displaying the cell in the fourth preset column by adopting a preset display format when the content is judged not to be the fifth preset identifier.
The second technical scheme adopted by the invention is as follows:
a system for rapidly exporting bills of material, comprising:
the export module is used for acquiring and exporting a plurality of bill of material files according to input information after a plurality of objects needing to be exported are selected through a CATIA software interface;
and the sorting module is used for processing the exported bill of material files sequentially through a secondary development interface of the Excel and then outputting the final bill of material files in batches.
Further, the sorting module comprises a deleting unit and a modifying unit;
the deleting unit is used for deleting corresponding contents in the bill of material file sequentially through a secondary development interface of Excel;
the modification unit is used for modifying the deleted content and adjusting the position of the content.
Further, the deleting unit deletes the contents of the bill of material file by:
after a bill of material file is opened in an Excel format, sequentially identifying the contents of cells in a first preset row in the bill of material file, and deleting the rows before the row number after the row number of the first cell with the contents as a first preset identifier is obtained;
sorting the bill of material files according to the contents of the cells in the first preset column;
and sequentially obtaining second cells of a second preset column of the bill of material file, judging whether the second cells are empty, and deleting the row where the second cells are located when the second cells are judged to be empty.
The third technical scheme adopted by the invention is as follows:
an automatic computer code generation device comprises a memory and a processor, wherein the memory is used for storing at least one program, and the processor is used for loading the at least one program to execute the method.
The fourth technical scheme adopted by the invention is as follows:
a storage medium having stored therein processor-executable instructions for performing the method as described above when executed by a processor.
The invention has the beneficial effects that: according to the invention, after the bill of material file is exported from CATIA software, the bill of material file is automatically opened in Excel software, and the final bill of material file is output in batch after corresponding processing is carried out according to the preset program, so that the complicated operation is not required to be carried out manually, the speed of exporting the file is greatly improved, the production efficiency is indirectly improved, the error caused by the manual operation is avoided, and the quality of design and production is improved.
Drawings
FIG. 1 is a flow chart of the steps of a method for rapidly exporting a bill of materials in accordance with the present invention;
FIG. 2 is a block diagram of a system for rapidly exporting a bill of materials according to the present invention.
Detailed Description
Example one
As shown in fig. 1, the present embodiment provides a method for rapidly exporting a bill of materials, including the following steps:
s1, after a plurality of objects needing to be exported are selected through a CATIA software interface, obtaining and exporting a plurality of bill of material files according to input information;
and S2, processing the exported bill of material files through a secondary development interface of Excel in sequence, and outputting the final bill of material files in batches.
The existing technology for exporting the bill of material files still operates manually, is very complicated and consumes more time and cost of workers. Taking the example of using CATIA to export the positioning welding fixture equipment of the automobile side wall, the process of manufacturing the bill of materials comprises the following steps: selecting a node of a clamp unit needing to be exported, opening the clamp unit in a new window, checking self-made parts, fasteners, purchased parts and factory marks under the clamp unit one by one, checking and checking material list attributes, enabling the clamp to enter an assembly design module, double-clicking the node of the clamp unit, clicking a material list command in an analysis menu bar, arranging the material list attributes in the order of 'SAP', 'comment', 'version', 'blank', 'part number', 'source', 'quantity', 'product description', 'blank 1', 'definition', filling the unit part number into a file name and storing the unit part number into a 'xls' format after closing the window, opening the file by Excel, deleting redundant useless rows and columns, and enabling a first column at the head of a list to be in the order of 'serial number', 'parent item picture number (must be filled', 'parent item name', 'parent item material group', 'child item picture number/model (must be filled)'), The sub-item 2D figure number, the sub-item quantity (necessary filling), the sub-item name, the sub-item material group and the sub-item brand are filled in sequence, the rest rows are arranged in the sequence of the self-made parts, the purchased parts, the factory standard parts and the fasteners, and the rest contents are filled in the standard mode. The operation method needs more repetitive work and has certain requirements on the standard familiarity of operators, for example, under the condition that the quantity of objects needing to be exported is large, the use process of the bill of materials command is complicated and time-consuming, and designers are easy to make mistakes in the modification and sequencing processes, so that the modification is continuously returned in the later period, and the working hours are increased by times.
The embodiment provides a method for rapidly exporting a bill of material, which utilizes the characteristics of high repeatability and fixed format of a traditional process for exporting the bill of material to determine information required to be exported by a bill of material provider (CATSAFI) secondary development interface Assembly Secondondary Format (CATSAFEARRAyVariant ilsistPROPs); then the process of exporting the bill of materials by the CATIA is realized through the AssemblyConverter Print (CATBSSTR iFileType, CATBSSTR iFile, CATIAProduct iProduct); and then processing the exported bill of material file by using a secondary development interface of Excel to form a bill of material file which meets the production requirement. Specifically, the user only needs to select an object (unit) of a product on the CATIA software, and then exports a bill of material file of each product object through a secondary development interface of the CATIA software, wherein the exported format can be predefined by the user. Specifically, a user can directly select an object (unit) on an image interface of the CATIA software, the selected object can be highlighted, and after the selection is completed, the CATIA software secondary development macro program is called and operated, and finally output. The method for calling the macro program is various, namely calling a macro command window through an Alt + F8 shortcut key and then performing single-click operation, or generating a button in a tool bar or a menu bar in advance and then performing single-click operation, and the essence is that the macro program which is programmed in advance is called and operated. After the bill of material file is exported, the bill of material file is opened through a secondary development interface of Excel software, the file is processed, and a final bill of material file is output, for example, redundant and wrong rows and columns are deleted from the file, and the files are arranged or filled correctly according to a corresponding industry standard format, so that the files become a bill of material file which can be used for production. According to the method, the bill of material files are automatically exported without repeated and complicated operations, so that the efficiency of exporting the bill of material files is improved, and the production efficiency is indirectly improved; avoids the occurrence of manual errors and improves the production quality.
The step of processing the exported bill of material file sequentially through the secondary development interface of Excel in step S2 specifically includes steps a1 to a 2:
a1, deleting corresponding contents in the bill of material file through a secondary development interface of Excel in sequence.
And A2, modifying the deleted content and adjusting the position of the content.
After a program is written, a secondary development interface is utilized to carry out cross-software operation, redundant contents in the bill of material file, such as some blank rows or columns without information contents, are deleted by means of an Excel software function through the secondary development interface, then the contents of the bill of material file are sorted or filled, and some more important data are displayed in front of the file so as to meet corresponding requirements.
The step A1 specifically comprises the following steps A11-A13:
a11, after the bill of material file is opened in an Excel format, sequentially identifying the contents of the cells in the first preset row in the bill of material file, and deleting the rows before the row number after the row number of the first cell with the contents as the first preset identification is obtained.
And A12, sorting the bill of material files according to the contents of the cells of the first preset column. The method specifically comprises the following steps: and performing ascending sequencing on the expanded selected areas of the bill of material file according to the contents of the cells in the first preset column.
A13, sequentially obtaining second cells in a second preset column of the bill of material file, judging whether the second cells are empty, and deleting the row where the second cells are located when the second cells are judged to be empty.
The step A2 specifically comprises the steps A21-A23:
a21, sequentially acquiring third cells of a third preset column, judging whether the content of the third cells is a second preset identifier, and replacing the content of the third cells with preset content when the content of the third cells is judged to be the second preset identifier;
a22, respectively acquiring a fourth cell with cell content as a third preset identifier and a fifth cell with cell content as a fourth preset identifier in a first preset column, and exchanging a row where the fourth cell is located with a row where the fifth cell is located;
and A23, judging whether the content of the cell in the fourth preset column of the row where the fourth cell is located is a fifth preset identifier, and displaying the cell in the fourth preset column by adopting a preset display format when the content is judged not to be the fifth preset identifier.
When the Excel secondary development interface is used for processing, firstly, through a Range (Row, Column) Value interface in Excel, the content of a cell in a first preset Column is identified, and after the line number of a first cell with the content being a first preset identification is obtained, the line before the line number is deleted. In this embodiment, the first preset column is a first column of the bill of materials file, the first preset identifier is "SAP", that is, a cell whose cell content is "SAP" in the first column is identified and its row number is obtained, and then all rows before the row number are deleted. Then, performing expanded selected area sequencing by taking the ascending order of the first column of the Excel table as a basis through a Worksheet. And then, sequentially obtaining second cells in a second preset column of the bill of material file, judging whether the second cells are empty, and deleting the row where the second cells are located when the second cells are judged to be empty. In this embodiment, the second predetermined column is the 5 th column (i.e. the "sub-item map number/model (must fill)" column) of the bill of materials file, and if the cell of the column is empty, the whole row is deleted. Through the above operation, redundant or erroneous rows are deleted, and then the remaining contents are adjusted and filled. Acquiring a third cell of a third preset column, judging whether the content of the third cell is a second preset identifier, and replacing the content of the third cell with preset content when the content of the third cell is judged to be the second preset identifier; in this embodiment, the third preset column is the 6 th column (i.e. the "sub-item 2D diagram number" column) of the bill of materials file, the second preset identifier is "home-made", the preset content is the content of the 5 th column of cells in the same row, that is, when it is determined that the content of the cell in the 6 th column (i.e. the "sub-item 2D diagram number" column) is "home-made", the content of the cell in the 5 th column of the row where the cell is located is copied to the cell, and at the same time, the content in the 9 th column (i.e. the "sub-item material group" column) is changed to "C0300". Then, respectively acquiring a fourth cell with the cell content being a third preset identifier and a fifth cell with the cell content being a fourth preset identifier in the first preset column, and exchanging the line where the fourth cell is located with the line where the fifth cell is located; in this embodiment, the third preset identifier is "D01", the identifier corresponds to a row where the "procurement piece" is located, the fourth preset identifier is "C02", the identifier corresponds to a row where the "factory standard piece" is located, that is, the rows where the "factory standard piece" and the "procurement piece" are located are obtained by identifying whether the first 3 bits of the cell content in the first column (i.e., the "SAP" column) are "C02" and "D01", and the positions of the rows are interchanged; the line where the 'purchasing parts' are located can be lifted to the front of the purchasing parts through interchange, and the line is convenient for related personnel to check. Finally, judging whether the content of the cell in the fourth preset column of the row where the fourth cell is located is a fifth preset identification or not, and displaying the cell in the fourth preset column by adopting a preset display format when the content is judged not to be the fifth preset identification; in this embodiment, the cell in the fourth preset column is the cell in the 5 th column, the fifth preset flag is whether the first 3 bits are "M-J", and the preset display format is to modify the cell into red, that is, to determine whether the first 3 bits of the cell in the 5 th column where the "factory standard article" is located are "M-J", and if not, modify the cell into red. Through the processing steps of the Excel software, the bill of material files are finally output in batches, and the bill of material files can be directly applied to downstream departments, so that the efficiency of exporting the bill of material is greatly improved.
Example two
As shown in fig. 2, the present embodiment provides a system for rapidly exporting a bill of materials, including:
the export module is used for acquiring and exporting a plurality of bill of material files according to input information after a plurality of objects needing to be exported are selected through a CATIA software interface;
and the sorting module is used for processing the exported bill of material files sequentially through a secondary development interface of the Excel and then outputting the final bill of material files in batches.
Further as a preferred embodiment, the sorting module includes a deleting unit and a modifying unit;
the deleting unit is used for deleting corresponding contents in the bill of material file sequentially through a secondary development interface of Excel;
the modification unit is used for modifying the deleted content and adjusting the position of the content.
Further preferably, the deleting unit deletes the contents of the bill of material file by:
after a bill of material file is opened in an Excel format, sequentially identifying the contents of cells in a first preset row in the bill of material file, and deleting the rows before the row number after the row number of the first cell with the contents as a first preset identifier is obtained;
sorting the bill of material files according to the contents of the cells in the first preset column;
and sequentially obtaining second cells of a second preset column of the bill of material file, judging whether the second cells are empty, and deleting the row where the second cells are located when the second cells are judged to be empty.
The system for rapidly exporting the bill of materials according to the embodiment of the present invention can execute the method for rapidly exporting the bill of materials provided in the first embodiment of the method of the present invention, can execute any combination of the implementation steps of the method embodiments, and has corresponding functions and advantages of the method.
EXAMPLE III
The embodiment provides a computer code automatic generation device which comprises a memory and a processor, wherein the memory is used for storing at least one program, and the processor is used for loading the at least one program to execute the method of the embodiment I.
The automatic computer code generation device of the embodiment can execute the method for rapidly exporting the bill of materials provided by the first embodiment of the method of the invention, can execute any combination implementation steps of the embodiments of the method, and has corresponding functions and beneficial effects of the method.
Example four
The present embodiment provides a storage medium having stored therein processor-executable instructions, which when executed by a processor, are configured to perform a method according to an embodiment.
The storage medium of this embodiment may execute the method for rapidly exporting the bill of materials provided in the first embodiment of the method of the present invention, may execute any combination of the implementation steps of the method embodiments, and has corresponding functions and advantages of the method.
While the preferred embodiments of the present invention have been illustrated and described, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (5)
1. A method for rapidly exporting a bill of materials is characterized by comprising the following steps:
after a plurality of objects needing to be exported are selected through a CATIA software interface, a plurality of bill of material files are obtained and exported according to input information;
processing the exported bill of material files sequentially through a secondary development interface of Excel, and outputting final bill of material files in batches;
the step of processing the exported bill of material file through the secondary development interface of Excel in sequence specifically comprises the following steps:
deleting corresponding contents in the bill of material file sequentially through a secondary development interface of Excel;
modifying the deleted content and adjusting the position of the content;
the step of deleting corresponding contents in the bill of material file through the secondary development interface of Excel in sequence specifically comprises the following steps:
after a bill of material file is opened in an Excel format, sequentially identifying the contents of cells in a first preset row in the bill of material file, and deleting the rows before the row number after the row number of the first cell with the contents as a first preset identifier is obtained;
sorting the bill of material files according to the contents of the cells in the first preset column;
sequentially acquiring second cells in a second preset column of the bill of material file, judging whether the second cells are empty or not, and deleting the row where the second cells are located when the second cells are judged to be empty;
the step of modifying the deleted content and adjusting the position of the content specifically comprises the following steps:
sequentially acquiring third cells of a third preset column, judging whether the content of the third cells is a second preset identifier, and replacing the content of the third cells with preset content when the content of the third cells is judged to be the second preset identifier;
respectively acquiring a fourth cell with the cell content being a third preset identifier and a fifth cell with the cell content being a fourth preset identifier in the first preset column, and exchanging the row where the fourth cell is located with the row where the fifth cell is located;
and judging whether the content of the cell in the fourth preset column of the row in which the fourth cell is positioned is a fifth preset identifier, and displaying the cell in the fourth preset column by adopting a preset display format when the content is judged not to be the fifth preset identifier.
2. The method according to claim 1, wherein the step of sorting the bill of material file according to the contents of the cells in the first preset column specifically comprises:
and performing ascending sequencing on the expanded selected areas of the bill of material file according to the contents of the cells in the first preset column.
3. A system for rapidly exporting bills of material, comprising:
the export module is used for acquiring and exporting a plurality of bill of material files according to input information after a plurality of objects needing to be exported are selected through a CATIA software interface;
the sorting module is used for processing the exported bill of material files through a secondary development interface of Excel in sequence and then outputting the final bill of material files in batches;
the sorting module comprises a deleting unit and a modifying unit;
the deleting unit is used for deleting corresponding contents in the bill of material file sequentially through a secondary development interface of Excel;
the modification unit is used for modifying the deleted content and adjusting the position of the content;
the deleting unit deletes the content of the bill of material file in the following way:
after a bill of material file is opened in an Excel format, sequentially identifying the contents of cells in a first preset row in the bill of material file, and deleting the rows before the row number after the row number of the first cell with the contents as a first preset identifier is obtained;
sorting the bill of material files according to the contents of the cells in the first preset column;
sequentially acquiring second cells in a second preset column of the bill of material file, judging whether the second cells are empty or not, and deleting the row where the second cells are located when the second cells are judged to be empty;
the step of modifying the deleted content and adjusting the position of the content specifically comprises the following steps:
sequentially acquiring third cells of a third preset column, judging whether the content of the third cells is a second preset identifier, and replacing the content of the third cells with preset content when the content of the third cells is judged to be the second preset identifier;
respectively acquiring a fourth cell with the cell content being a third preset identifier and a fifth cell with the cell content being a fourth preset identifier in the first preset column, and exchanging the row where the fourth cell is located with the row where the fifth cell is located;
and judging whether the content of the cell in the fourth preset column of the row in which the fourth cell is positioned is a fifth preset identifier, and displaying the cell in the fourth preset column by adopting a preset display format when the content is judged not to be the fifth preset identifier.
4. An apparatus for automatic generation of computer code, comprising a memory for storing at least one program and a processor for loading the at least one program to perform the method of any of claims 1-2.
5. A storage medium having stored therein processor-executable instructions, which when executed by a processor, are configured to perform the method of any one of claims 1-2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910185501.4A CN110059121B (en) | 2019-03-12 | 2019-03-12 | Method, system, device and storage medium for rapidly exporting bill of materials |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910185501.4A CN110059121B (en) | 2019-03-12 | 2019-03-12 | Method, system, device and storage medium for rapidly exporting bill of materials |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110059121A CN110059121A (en) | 2019-07-26 |
| CN110059121B true CN110059121B (en) | 2021-09-03 |
Family
ID=67316950
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910185501.4A Active CN110059121B (en) | 2019-03-12 | 2019-03-12 | Method, system, device and storage medium for rapidly exporting bill of materials |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110059121B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110471653A (en) * | 2019-08-16 | 2019-11-19 | 四川长虹电器股份有限公司 | BOM automatic arranging method based on C# |
| CN112508520A (en) * | 2020-12-08 | 2021-03-16 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly checking bill of material |
| CN112860701B (en) * | 2021-03-01 | 2023-06-30 | 成都理工大学 | System and method for modeless frame data transmission based on Revit |
| CN112860245B (en) * | 2021-03-10 | 2022-07-19 | 厦门极致互动网络技术股份有限公司 | Batch remarking method based on Jira system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102096727A (en) * | 2009-12-15 | 2011-06-15 | 鸿富锦精密工业（深圳）有限公司 | System and method for generating bill of materials |
| CN104050206A (en) * | 2013-10-12 | 2014-09-17 | 惠州华阳通用电子有限公司 | Material bill rapid exporting method and system thereof |
| CN104657512A (en) * | 2015-03-19 | 2015-05-27 | 中铁二局第五工程有限公司 | Method and device for realizing steel truss arch bridge engineering quantity statistics by employing BIM (building information modeling) |
| CN108334724A (en) * | 2018-05-08 | 2018-07-27 | 滨州学院 | A kind of construction method of civil engineering BIM quantities models |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2001288611A1 (en) * | 2000-09-06 | 2002-03-22 | Proficiency Ltd. | Boundary representation per feature methods and systems |
| CN105005642B (en) * | 2015-06-25 | 2017-11-21 | 北京航空航天大学 | A kind of threedimensional model batch format conversion and light weight method |
| CN105205038B (en) * | 2015-09-18 | 2019-04-05 | 昆山龙腾光电有限公司 | Complete material inventory table generating method and device |
| US10176436B2 (en) * | 2015-12-15 | 2019-01-08 | International Business Machines Corporation | Extracting skill-level-based command execution patterns from CATIA command log |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN107480374B (en) * | 2017-08-14 | 2020-06-02 | 中国铁道科学研究院铁道建筑研究所 | Bridge BIM model creation method based on CATIA |
-
2019
- 2019-03-12 CN CN201910185501.4A patent/CN110059121B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102096727A (en) * | 2009-12-15 | 2011-06-15 | 鸿富锦精密工业（深圳）有限公司 | System and method for generating bill of materials |
| CN104050206A (en) * | 2013-10-12 | 2014-09-17 | 惠州华阳通用电子有限公司 | Material bill rapid exporting method and system thereof |
| CN104657512A (en) * | 2015-03-19 | 2015-05-27 | 中铁二局第五工程有限公司 | Method and device for realizing steel truss arch bridge engineering quantity statistics by employing BIM (building information modeling) |
| CN108334724A (en) * | 2018-05-08 | 2018-07-27 | 滨州学院 | A kind of construction method of civil engineering BIM quantities models |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110059121A (en) | 2019-07-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110059121B (en) | Method, system, device and storage medium for rapidly exporting bill of materials | |
| CN111062196B (en) | Batch process flow card generation method based on CAD and Excel | |
| CN112270116B (en) | Product package transportation statics analysis method, platform, storage medium and application | |
| CN110069892B (en) | FPGA pin allocation design method and device | |
| CA2476871A1 (en) | Electronic component design, procurement and manufacturing collaboration | |
| CN108830554B (en) | Task model-based intelligent detection method and system for data result information quality | |
| CN113051885B (en) | AutoCAD-based design drawing rapid typesetting method | |
| CN113326558B (en) | Rapid drawing method for detailed diagrams of parameterized doors and windows based on Grasshopper platform secondary development | |
| CN111177825A (en) | Parameterized modeling method and device | |
| US20080091942A1 (en) | Automated two dimensional technical data packaging | |
| CN111596824B (en) | Drawing standardization compilation method and system and electronic equipment | |
| US7197696B1 (en) | System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same | |
| CN114357596B (en) | BIM component resource rapid design method and system | |
| Nevliudov et al. | Development of a software module for operational dispatch control of production based on cyber-physical control systems | |
| CN109086985B (en) | Professional test information management system for spacecraft assembly | |
| US20080243890A1 (en) | Automated two and three dimensional technical data packaging | |
| CN113806114B (en) | Goods presentation page contraband word checking method based on RPA robot | |
| CN112508520A (en) | Method, system, device and storage medium for rapidly checking bill of material | |
| CN112861282B (en) | System and method for realizing data transmission among multiple software | |
| US7987203B2 (en) | Method of processing data for a system model | |
| CN112163834A (en) | Detection report generation method, device, electronic equipment and medium | |
| CN111985015A (en) | System and method for automatically generating BOM (Bill of Material) by using VBA (visual basic Access) function | |
| JP3770805B2 (en) | CAD apparatus, CAD system, and component design method | |
| CN117932764B (en) | MBD-based component three-dimensional text annotation creation method and system | |
| CN109582942B (en) | Borrowing piece automatic generation system based on VBA language |
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 |