CN1963849A - The Integration Method of Product Data Management System - Google Patents

Abstract

The invention relates to a material list integration system and a material list integration method which achieve product data list integration by computer software and can share material data together. The invention can make the identification module read the identification information connected with the design object in the design drawing drawn by the computer drawing software, then make the checking module compare the material data connected with the identification information with the data of the resource database, after comparing, if the material data is the same as the data of the resource database, make the window generating module generate the bill of materials, if the material data is not corresponding to the data of the resource database, make the filling window generating module generate the filling window, and input the new material data. And finally, the new material data are imported into the resource database by the compiling module to be updated, and the compiled data are used for generating a complete material list containing new materials by the window generating module.

Description

The Integration Method of Product Data Management System

technical field

The present invention relates to a product data integration system and method, in particular to a material list integration system and method that achieves product data list integration with computer software and can share material data.

Background technique

With the advancement of science and technology, the R&D, design and manufacturing of industrial products have quite different operating modes from traditional ones. Powerful computer-aided software combined with sophisticated equipment makes today's industrial production more efficient and precise. Especially in the early stages of R&D and design, computer-aided software has become an indispensable tool. After product development and design, it enters the manufacturing process. During the production process, material management and maintenance is one of the most important key elements in manufacturing cost, quality and efficiency. In order to enhance the competitiveness of enterprises, improve operating efficiency and reduce production costs, from design to manufacturing to quality management, all enterprises take efficiency and accuracy as their improvement goals.

Generally speaking, from design to mass production of industrial products, it is related to the participation of professional personnel such as design engineers, manufacturing engineers, procurement personnel, quality management personnel, and R&D management personnel. Among them, the production and maintenance of the bill of materials (BOM) must be changed or updated frequently in terms of design improvement or process improvement. However, the change or update of the bill of materials will involve the changes of the bills of materials made by the personnel of several aforementioned different units. If the personnel of each unit amends and changes, it will not only increase the operating cost, but also easily cause the content of the list to be changed due to human error. mistake.

At present, the most commonly used material management method is to use the list generated by application software such as word or excel to manage. This kind of form is only the details of the relevant information of each part, and the relationship between the parts cannot be displayed, let alone connected Some back-end resource databases are integrated. Taking the combined design drawing of the known two-dimensional mechanical structure as an example, as shown in Figure 1, after the designer uses computer-aided software to complete the combined design drawing in step 10, he must add new parts, All part data such as used parts and commercially available standard parts are entered manually. To generate a bill of material report, you need to go to step 12, and enter all the part data in the word or excel software for the second time. In addition, regarding resource databases, such as enterprise resource planning (enterprise resource planning, ERP) or material requirement planning (material resource planning, MRP) systems, it is necessary to perform step 13 and input all parts through the bill of materials for the third time. If the combination diagram is further disassembled into a part diagram in step 14, the new part data must be input in the frame of each part diagram for the fourth time in step 141. This will not only increase labor costs, but also may cause errors in data content after repeated input, which will cause unexpected damage to design or manufacturing.

Another common product design method is shown in Figure 2. After the designer completes the part design drawing in step 20, in step 21, the data of each part is manually entered into the frame of each part drawing on the part drawing middle. To generate a bill of material report, it is necessary to proceed to step 22, and enter all the part data in the word or excel software for the second time. Then step 23 must be carried out in the ERP or MRP system and the bill of materials for all parts entered a third time. If each part diagram is further combined into a combination diagram in step 24, all part data such as new parts, old parts and standard parts must be input into the combination diagram for the fourth time in step 241. As mentioned above, this method has the disadvantages of high labor cost and the accuracy of material content.

Contents of the invention

In order to improve the above-mentioned shortcomings of high labor costs and the accuracy of material content, the bill of materials can be automatically produced during the process from design to manufacturing, without the need to spend the labor and time required to repeatedly enter the data of the bill of materials, to ensure the accuracy of the bill of materials Correctness, and at the same time, it can integrate the data of new parts, old parts and standard parts, so that the content of the bill of materials in the back-end resource database can be updated, and then achieve the integration of the computer graphics system and the back-end resource database system, so that the bill of materials in each system It can be automatically generated and has the purpose of maintaining and updating functions.

In order to achieve the above-mentioned purpose, the present invention will provide a product data management system, which uses computer software to integrate the material data established by the computer graphics software and the resource database, so that the material data can be shared and updated at the same time. The product data management system includes: an identification module, which can be used to read the identification information linked to the design object in the design drawing drawn by the computer drawing software, the identification information is stored in a specific data structure, and can be linked with the resource database The data for comparison; the check module can be used to compare and integrate the material data linked by the identification information with the data read from the resource database. The check module includes: a comparison module that can be used to compare all Comparing the material data linked by the identification information with the data read by the resource database; the fill-in form generating module, which can be used to generate the fill-in form window, enabling new material data to be input; and the collection module , which can be used to integrate the input new material data with the original data of the resource database, and at the same time import the new material data into the resource database to update the data in the database; and the form generation module can be used to integrate the aforementioned collected Complete bill data yields a bill of materials.

Using the product data management system of the present invention, the identification module can be made to read the identification information linked to the design object in the design drawing drawn by the computer drawing software, and then the checking module can be used to compare the material data linked by the identification information with The data read by the resource database is compared. After the comparison, if the material data is the same as the data in the resource database, the form generation module is ordered to generate a list of materials. If the material data cannot correspond to the data in the resource database, Then make the fill-in form generating module generate a fill-in form window to input new material data. Finally, the assembly module is instructed to import the new material data into the resource database for updating, and at the same time, the aforementioned form generation module is used to generate a complete bill of materials including the new materials from the collected data. Wherein, the design drawing drawn by the computer drawing software may be a two-dimensional or three-dimensional mechanical structure assembly drawing or part drawing, or an electronic circuit diagram, but is not limited thereto. The resource database can be an enterprise resource planning or material requirements planning system, or other systems that can maintain the bill of materials.

Therefore, through the system and method of the present invention, the bill of materials of old parts and standard parts can be automatically generated through identification information on the design drawing, enterprise resource planning or material requirement planning system, list report, or dismantling and assembly drawing, If a new part is added, the new data input can be used to generate a complete bill of materials including the material data of the new part, which does not require manual additional repetitive input, so the cost of labor and time can be greatly reduced. The created bill of materials containing new parts can be further imported into the enterprise resource planning or material requirements planning system, so that it can also be updated at any time to maintain its integrity and correctness.

Description of drawings

Fig. 1 is a schematic diagram of a bill of materials integration method of a known invention;

Fig. 2 is a schematic diagram of another known invention of bill of material integration method;

3 is a schematic diagram of an overview of the integrated system of the product data management system of the present invention;

Fig. 4 is a schematic diagram of the integration method of the product data management system of the present invention;

FIG. 5A is a schematic diagram of the application of the integration method of the product data management system of the present invention to the combination diagram;

5B is a schematic diagram of the software interface of the integration method of the product data management system of the present invention applied to the combination diagram;

5C is a schematic diagram of the software interface of the integration method of the product data management system of the present invention applied to the combination diagram;

5D is a schematic diagram of the software interface of the integration method of the product data management system of the present invention applied to the combination diagram;

Fig. 5E is a schematic diagram of the software interface of the integration method of the product data management system of the present invention applied to the combination diagram;

FIG. 5F is a schematic diagram of the software interface of the integration method of the product data management system of the present invention applied to the combination diagram;

FIG. 5G is a schematic diagram of the software interface when the integration method of the product data management system of the present invention is applied to the assembly diagram when it is disassembled into a part diagram;

FIG. 5H is a schematic diagram of the software interface when the integration method of the product data management system of the present invention is applied to the assembly diagram when it is disassembled into a part diagram;

Fig. 6 is a schematic diagram of the application of the integration method of the product data management system of the present invention to the part diagram;

7 is a schematic diagram of the integration method of the product data management system of the present invention applied to a 3D part drawing;

8A is a schematic diagram of the integration method of the product data management system of the present invention applied to an electronic circuit diagram;

8B is a schematic diagram of the software interface of the integration method of the product data management system of the present invention applied to the electronic circuit diagram.

Embodiments of the present invention will be further described below in conjunction with the accompanying drawings. The following examples are used to illustrate the present invention and are not intended to limit the scope of the present invention. Any ordinary skilled person will not depart from the spirit and scope of the present invention. , can be changed and modified, so the protection scope of the present invention should be defined by the scope of the appended claims.

in the picture

10The design department completes the combined design drawing

11 Enter part data

12 Create a bill of materials report

13Enter parts data in enterprise resource planning or material requirements planning system

14 Disassembled into parts diagram

141 Enter new part data into the drawing frame

20The design department completes the part design drawing

21 Enter part data in the frame

22 Create Bill of Materials report

23Enter parts data in enterprise resource planning or material requirements planning system

24 combinations into a combination chart

241 Input part data in combination diagram

30 product data management system

301 Order the identification module to read the identification information

302 order check module to compare

303 generate bill of materials

304 command to fill in the form generation module to generate the fill in form window

305 Instructs the compilation module to update data and generate a bill of materials

31 identification module

32 checking module

321 comparison module

322 fill in the form to generate the module

323 assembler module

33 Form generation module

40 Computer Graphics Systems

41 combination design drawing

411 identification information

412 Fill in the new part data in the form window

42 parts design drawing

420 Fill the part data into the frame

421 identification information

422 Fill part data into the frame

43 parts design drawing

431 Input new part data and generate bill of materials

432 Generate BOM report

443D parts design drawing

441 projection into three views

442 assembled into combination diagrams

443 assembled into combination diagram

50 enterprise resource planning or material requirements planning systems

60 bill of materials

61 Generate BOM report

70 electronic circuit diagram

701 Export simple bill of materials

71 Select and determine the material form

72 Generate bill of materials

Detailed ways

Please refer to FIG. 3 , which is a schematic diagram of an integrated system overview of the product data management system of the present invention. Through the product data management system 30 of the present invention, the data of all materials can be integrated between the computer graphics system 40 and the back-end resource database, such as the enterprise resource planning or material demand planning system 50, and automatically generated in each system Bill of Materials60. Allow all material information to be shared and established in the aforementioned system, and improve the known missing data that may be caused by manual multiple input.

Please refer to FIG. 4 , which is a schematic diagram of the integration method of the product data management system of the present invention. First, step 301 is performed to make the identification module read the identification information on the design drawing drawn by the computer drawing software. The identification information is established during drawing and is information data that can be connected with the drawing components. At the same time, the identification information is stored in a specific data structure, and can be compared with the data structure of the resource database. Then proceed to step 302 to make the checking module compare the material data of the identification information linked with the identification information with the data read from the resource database, and generate a comparison result. According to the comparison result, if the material data is the same as the data in the resource database, then proceed to step 303 to make the form generating module generate a list of materials; if the material data cannot correspond to the data in the resource database, then proceed to step 304 to make the filled The input form generation module generates and fills in the form window to input new material data. Then, through step 305, the assembly module imports the new material data into the resource database for updating, and at the same time uses the above-mentioned form generation module to generate a complete bill of materials including the new materials from the collected data.

Please refer to FIG. 5A , which is a schematic diagram of the application of the integration method of the product data management system of the present invention to the combination diagram. The product data management system 30 of the present invention includes: an identification module 31 , a verification module 32 and a form generation module 33 . The check module 32 includes a comparison module 321 , a fill-in form generation module 322 and a collection module 323 .

The identification module 31 can be used to read the identification information 411 linked to each design part object in the design drawing 41 drawn by the computer graphics system 40. The identification information 411 is stored in a specific data structure, and can be related to enterprise resource planning or material The data structure of the demand planning system 50 is compared. The identification information 411 can be the Chinese product name, English product name, material number or other information of each part object, wherein it is better to use the more absolute part material number as the identification information 411; the checking module 32 can be used to identify the The material data linked by the information 411 is compared and integrated with the data of the ERP or MRP system 50 . The material data and the data of the enterprise resource planning or material demand planning system 50 can be imported into the product data management system 30 when the product data management system 30 is connected with it. Compare with database data stored in .

The comparison module 321 included in the checking module 32 can be used to compare the material data linked by the identification information 411 with the data of the enterprise resource planning or material requirement planning system 50 . As mentioned above, it can also be directly compared with the database data imported into the product data management system 30 . After the foregoing data is compared, if the data cannot be corresponding, then the form window can be generated by filling in the form generation module 322. At this time, step 412 is manually performed to fill in the new part data in the form window. to input new material data. The integration module 323 can be used to integrate the input new material data with the data of the original enterprise resource planning or material requirement planning system 50, and at the same time import the new material data into the enterprise resource planning or material requirement planning system 50 to update the resource The data of the database, and the updated database data can also be further imported into the product data management system 30 . As for the form generation module 33 , it can be used to generate the bill of materials 60 in the design drawing 41 from the above-mentioned assembled complete list data. The form generation module 33 can also automatically generate the BOM report 61 in the application software word or excel at the same time. The BOM 60 or the BOM report 61 may include fields such as drawing layer name, part name, model, specification, English product name, drafter and product description, but not limited thereto, which can be determined according to user needs. Therefore, whether it is the bill of materials 60, the bill of materials report 61, and the enterprise resource planning or material requirements planning system 50, through the integration of the product data management system 30 of the present invention, not only can the bill of materials be automatically generated, but also new parts data can be supplemented, so that The database can have and maintain the function of updating data.

Please also refer to FIG. 5B to FIG. 5F , which are schematic diagrams of the software interface of the integration method of the product data management system of the present invention applied to the combination diagram. What is shown in Fig. 5B is the combination diagram of the design completion, and the bill of materials has not been established in this diagram, and before the product data management system of the present invention is not connected with the enterprise resource planning or material demand planning system, it is also as shown in Fig. 5C , only the drawing name but no other material data. After the product data management system of the present invention is connected with the enterprise resource planning or material demand planning system, through the identification module and the verification module, the product data management system can import the material data of old parts and standard parts, as shown in Figure 5D , if the comparison module compares the new part identification information that cannot correspond, then the form window that requires input of new part data as shown in Figure 5E is generated by the fill-in form generation module. After inputting the new part data one by one, after the collection module, the form generation module will automatically generate the bill of materials as shown in Fig. 5F in the combination diagram.

Please continue to refer to FIG. 5A , when the design drawing 41 is disassembled into the component drawing 42 , each design component assembly still has identification information 421 for identification. After the identification information 421 is read by the identification module 31, the comparison module 321 compares and obtains the corresponding part data in the enterprise resource planning or material requirements planning system 50, or the data previously imported by the product data management system 30, and then through Step 422 can be performed through the form generation module 33, and the data of each part is automatically filled into the frame of each part drawing. Therefore, when the combination diagram is split into a parts diagram, since the data of the enterprise resource planning or material requirements planning system 50 has added new parts data in the process of establishing the bill of materials in the combination diagram, it is an updated and complete database, while the product data The data of the database stored in the management system 30 is also a complete database after being compiled previously, so no matter whether the part data is obtained by the product data management system 30 or the enterprise resource planning or material requirement planning system 50, in each part diagram All can input frame data automatically and completely, without manual repetitive input actions.

Please refer to FIG. 5G and FIG. 5H at the same time. These figures are schematic diagrams of the software interface when the integration method of the product data management system of the present invention is applied to the disassembly of the assembly diagram into a component diagram. As mentioned above, after the combination diagram is disassembled into a part diagram, the product data management system of the present invention can import the data of each part in the enterprise resource planning or material requirement planning system (as shown in Figure 5G), and then use the window The volume generation module automatically fills the data of each part into the frame of each part drawing (as shown in FIG. 5H ).

Please refer to FIG. 6 , which is a schematic diagram of the application of the product data management system integration method of the present invention to a part diagram. After the designer completes a series of part design drawings 43 , the required part drawings can be inserted into the combination drawing for combination, so as to further assemble into the combination drawing 431 . At this time, the product data management system 30 integrates the material data at the same time. It first obtains the corresponding parts from the data previously imported from the enterprise resource planning or material demand planning system 50 or the product data management system 30 according to the identification information of each part. Data, the data of old parts and standard parts are imported into the bill of materials presented by the product data management system 30 . If new parts need to be added to the combination diagram, new parts can be designed on the combination diagram. Since the new part does not have corresponding data in the enterprise resource planning or material requirements planning system 50 or the product data management system 30, as mentioned above, the product data management system 30 will request to fill in the form window generated Fill in the material data of the new parts, and then use the above-mentioned collection module to collect the new and old data. On the one hand, perform data update operations on the database of the enterprise resource planning or material demand planning system 50, and further generate from the form The module automatically generates a complete bill of materials on the combination diagram 431 and creates a material structure tree at the same time. On the other hand, the form generation module can also create and generate the BOM report 432 in word or excel format according to the updated data collected in the ERP or MRP system 50 or the product data management system 30 database.

Please refer to FIG. 7 , which is a schematic diagram of the integration method of the product data management system of the present invention applied to a three-dimensional (3D) part drawing. After the designer completes the 3D part design drawing 44 , the attribute data (including new parts) of each part will be established at the same time. Afterwards, step 441 may be performed first, projecting the 3D part drawing into three views, and exporting a 2D part drawing file. Then mark the size on the 2D part drawing, and create frame attribute data at the same time. Then, as mentioned above, the material data integration is started through the product data management system 30 . The product data management system 30 will first obtain the corresponding part data from the enterprise resource planning or material requirement planning system 50 or the data previously imported by the product data management system 30, and then automatically form a bill of materials on the assembly diagram 442 of the parts assembled , and create a material structure tree. Since the new part data has been input in the 3D part drawing, after the verification module checks, although there is no corresponding material data in the comparison result, the 3D part drawing already has these new part data, so the product data management system 30 A complete bill of materials including new parts can be automatically generated directly through the form generation module, without having to fill in the function of the form generation module to generate a form window that requires input of new part data. After the product data management system 30 reads in the material data in the 2D drawing file in step 441, in addition to directly generating the bill of materials mentioned above, it can also simultaneously transfer the new part data not stored in the original database to the enterprise resource planning or material demand planning system 50 The database performs data update operations. In addition, these three-dimensional (3D) component design drawings 44 can also be directly assembled into a 3D assembly drawing 443 with 3D parts without projection, and the dimensions are indicated in the 3D assembly drawing. At this time, as mentioned above, through the integration of the product data management system 30, a complete bill of materials including new parts can be automatically generated directly through the form generation module on the combination diagram 443, and a material structure tree can be established. The latter is the better data integration method in which the 3D part diagram is directly assembled into a combination diagram, because when the original 3D part diagram changes, the 3D parts in the combination diagram can be updated at the same time, and the correctness of the design components can be maintained, so it is not necessary There will be the disadvantage of not being able to update the part data according to the part change after the former is projected into a 2D part.

Please refer to FIG. 8 , which is a schematic diagram of the integration method of the product data management system of the present invention applied to an electronic circuit diagram. In addition to the part diagram and assembly diagram of the aforementioned mechanical structure, the present invention can also integrate the electronic circuit diagram 70 designed by electronic circuit computer aided design software. The biggest difference between the electronic circuit diagram 70 and the bill of materials of the aforementioned organization is that it usually does not have so-called new electronic parts, and especially the same electronic part can be produced by different manufacturers, so when designing and adopting, it is not simply to select its specifications, but also to choose the manufacturer to be used electronic parts of this specification.

Please continue to refer to FIG. 8A. After the circuit configuration design is completed, the electronic circuit diagram 70 can automatically export a simple bill of materials 701. The bill of materials 701 is then processed by the data from the product data management system 30 and the enterprise resource planning or material requirements planning system 50. Material data comparison and integration. The product data management system 30 can also directly read the electronic component data from the electronic circuit diagram 70 without going through the bill of materials 701 . After reading the preliminary material data of the electronic parts, the product data management system 30 obtains the corresponding electronic part data from the data previously imported by the enterprise resource planning or material requirements planning system 50 or the product data management system 30, and finds after comparison Parts with a single specification object/identification information, but manufactured by different manufacturers, can be further generated by filling in the form generation module to select and determine the material form 71 window (as shown in Figure 8B), so as to select and determine the manufacturer to be used parts. After selecting the manufacturer to be used, the part data of this manufacturer can be collected by using the collection module. The consolidated material data can not only automatically generate a complete material list and material structure tree 72 by using the form generation module, but also can perform data update actions on the database of the enterprise resource planning or material demand planning system 50 at the same time.

Claims (10)

1. An integration method of a product data management system, using computer software to integrate the material data established by computer graphics software and resource databases, enabling intercommunication, sharing and updating at the same time, the integration method of the product data management system includes: Make the identification module read the identification information linked to the design object in the design drawing drawn by the computer drawing software, the identification information is stored in a specific data structure and can be compared with the data in the resource database; make the checking module compare the material data linked by the identification information with the data in the resource database, and generate a comparison result, and according to the comparison result, if the material data is the same as the data in the resource database, make the The generation module generates a bill of materials, if the material data cannot correspond to the data in the resource database, the fill-in form generation module generates a fill-in form window to input new material data; and The assembly module is instructed to import the new material data into the resource database for updating, and at the same time use the above-mentioned form generation module to generate a complete bill of materials containing new materials from the collected data. 2. The integration method of the product data management system according to claim 1, wherein when the data of the resource database is connected with the product data management system, it is immediately imported into the product data management system, so that the checking module can directly use Compare with the resource database data stored in the product data management system. 3. The integration method of the product data management system according to claim 1, wherein the design diagram drawn by the computer graphics software is a combination diagram of a two-dimensional mechanical structure. 4. The integration method of the product data management system according to claim 1, wherein the design drawing drawn by the computer drawing software is a part drawing of a two-dimensional mechanical structure. 5. The integration method of the product data management system according to claim 1, wherein the design diagram drawn by the computer graphics software is a combined diagram of a three-dimensional mechanical structure. 6. The integration method of the product data management system according to claim 1, wherein the design diagram drawn by the computer graphics software is a three-dimensional mechanical structure part diagram. 7. According to the integration method of the product data management system described in claim 1, 5 or 6, wherein the comparison result generated by the comparison module, if there is new part data that the resource database cannot correspond to, but the design drawing has a complete The form generation module directly generates a complete bill of material including the new part when part material data is obtained. 8. The integration method of the product data management system according to claim 1, wherein the design diagram drawn by the computer graphics software is an electronic circuit diagram. 9. According to the integration method of the product data management system described in claim 1 or 8, wherein the comparison result generated by the comparison module, if there is a single identification information but there are materials that can be selected by different manufacturers, the filling in the form generation module Further generate the selection and determination material form, so as to select and determine the materials of the adopted manufacturer. 10. A product data management system, using computer software to integrate the material data established by computer graphics software and resource databases, enabling intercommunication, sharing and updating at the same time, the product data management system includes: The identification module is used to read the identification information connected to the design object in the design drawing drawn by the computer drawing software, the identification information is stored in a specific data structure, and can be compared with the data in the resource database; A check module, used to compare and integrate the material data linked to the identification information with the data in the resource database, the check module includes: a comparison module, configured to compare the material data linked to the identification information with the data in the resource database; The fill-in form generation module is used to generate the fill-in form window to enable the input of new material data; an integration module, used to integrate the input new material data with the original data of the resource database, and at the same time import the new material data into the resource database, so as to update the data in the database; and The form generation module is used to generate the bill of materials from the above-mentioned collected complete list data.

Images