Import Method and System for Batch Import of Fixture Historical Data into PDM System

Abstract

The present invention discloses an import method for batch importing historical data of work jigs and fixtures into a PDM system. The method includes: first, respectively establishing standard format templates for Item import, BOM import, dataset import, and classification object import; then performing Item import to create data objects to be imported in the PDM system; then performing BOM import to establish the hierarchical structure relationship of the imported data; then performing dataset import to batch import relevant attachments into the corresponding object attachments; and finally performing classification object import to add the imported work jig and fixture data to the corresponding classification attribute list in the PDM system. The present invention discloses an import system for implementing the above solution. The operation of the present invention is simple, realizes batch import of data, eliminates the need to manually establish data information in the PDM system, is applicable to batch import of BOM structure data information such as cutting tools, tools, and fixtures, and improves work efficiency.

Description

Technical Field

[0001] The present invention relates to the field of machining design, and in particular, to a method and system for batch importing historical data of work jigs and fixtures into a PDM system. Background Art

[0002] In the process of enterprise development, it often happens that the internal information system of the enterprise is updated or a new system is developed for management. In both cases, there is a problem of how to efficiently migrate historical data to the new system. Without a batch import tool, only manual sorting of historical data can be carried out, and then imported into the new system one by one. This method is inefficient and error-prone, and it is almost an impossible task for facing a large amount of historical data.

[0003] As a professional data management software, the PDM system is being used by more and more manufacturing enterprises for product and manufacturing data management, and the information of work jigs and fixtures is an essential process resource information in manufacturing enterprises. A typical work jig and fixture is an assembly, and its data is a tree structure containing parent-child hierarchical relationships. With the development of the enterprise over the years, the total amount of data is tens of thousands. If the method of manually creating data and hierarchical relationships is adopted, the workload is huge, the efficiency is extremely low, and it is easy to make mistakes, seriously affecting the normal use of the system.

[0004] At present, no description or report of similar technologies to the present invention has been found, and no similar materials at home and abroad have been collected. Summary of the Invention

[0005] In view of the above deficiencies in the prior art, the present invention provides a method and system for batch importing historical data (BOM) of work jigs and fixtures into a PDM system.

[0006] According to one aspect of the present invention, there is provided a method for batch importing historical data of work jigs and fixtures into a PDM system, including:

[0007] Constructing a standard format template for importing historical data of work jigs and fixtures, and sorting the required imported Item work jig and fixture data, BOM data, dataset data, and classification object data according to the standard format template for historical data;

[0008] Importing the sorted Item work jig and fixture data into the PDM system to create a work jig and fixture data object;

[0009] Importing the sorted BOM data into the PDM system to establish a hierarchical structure relationship of the Item work jig and fixture data;

[0010] Importing the sorted dataset data into the PDM system and uploading the dataset data to the corresponding Item work jig and fixture data;

[0011] Import the sorted classified object data into the PDM system, and add the imported Item tooling data to the corresponding classification attribute list pre-established in the PDM system;

[0012] After the above steps, the batch import of tooling historical data is completed.

[0013] Preferably, the standard format template is established in Excel format, including the standard format template for Item data import, the standard format template for BOM data import, the standard format template for dataset data import, and the standard format template for classified object data import.

[0014] Preferably, the standard format template is provided with corresponding attribute information as needed.

[0015] Preferably, when importing the sorted Item tooling data into the PDM system to create a tooling data object, it includes:

[0016] Use the Item import function to import the sorted Item tooling data into the PDM system;

[0017] The sorted Item tooling data includes any one or more of the following attribute information:

[0018] - Type;

[0019] - Item Name;

[0020] - Rev;

[0021] - Process Equipment Name;

[0022] - Description;

[0023] - UOM;

[0024] - Owner;

[0025] - All Groups;

[0026] - English Name;

[0027] - Resource Category;

[0028] Create a tooling data object based on the imported Item tooling data.

[0029] Preferably, when importing the sorted BOM data into the PDM system to establish the hierarchical structure relationship of Item tooling data, it includes:

[0030] Use the BOM import function to import the sorted BOM data into the PDM system, and establish the hierarchical structure of the imported Item tooling data according to the hierarchical relationship of the BOM data;

[0031] The sorted BOM data includes any one or more of the following attribute information:

[0032] - Parent part ID;

[0033] - Subpart ID;

[0034] - Location number;

[0035] - Quantity;

[0036] - Material;

[0037] - Part number;

[0038] - Drawing size.

[0039] Preferably, when importing the sorted data set into the PDM system, the relevant attachment information of the tooling data in the data set is imported into the corresponding Item tooling data, including:

[0040] Using the data set import function, the data in the data set is imported into the corresponding Item tooling data, and the data in the data set includes: drawings, models, and / or documents;

[0041] The format types of the data in the data set include: word, xls, PDF, DWG, Image, and / or JPEG formats.

[0042] Preferably, when importing the sorted classified object data into the PDM system and adding the imported Item tooling data to the corresponding classification attribute list pre-established in the PDM system, it includes:

[0043] Using the classified object data import function, the imported Item tooling data is added to the classification attribute list pre-established in the PDM system, and the imported Item tooling data can be viewed in the corresponding classification attribute list library already established in the PDM system.

[0044] According to another aspect of the present invention, there is provided an import system for batch importing tooling historical data into a PDM system, including:

[0045] A standard format template construction module, which constructs a standard format template for importing tooling historical data and sorts the required imported Item tooling data, BOM data, data set data, and classified object data according to the standard format template;

[0046] An Item data import module, which imports the sorted Item tooling data into the PDM system to create a tooling data object;

[0047] The BOM data import module imports the sorted BOM data into the PDM system to establish the hierarchical structure relationship of the Item tooling data;

[0048] The data set data import module imports the sorted data set data into the PDM system and uploads the data set data to the corresponding Item tooling data;

[0049] The classification object data import module imports the sorted classification object data into the PDM system and adds the imported tooling data to the corresponding classification attribute list pre-established in the PDM system.

[0050] Preferably, the import system is installed on a smart terminal.

[0051] Due to the adoption of the above technical solutions, compared with the prior art, the present invention has at least one of the following beneficial effects:

[0052] The import method and system for batch importing the historical data of tooling into the PDM system provided by the present invention solve the problems of large workload and low efficiency caused by a large amount of data and complex data relationship levels during the process of batch importing the historical data (BOM) of tooling into the PDM system. By using the tools and methods of the present invention, the efficiency of data import can be greatly improved.

[0053] The import method and system for batch importing the historical data of tooling into the PDM system provided by the present invention can sort out the information of the tooling historical data through the established standard formats of "Item import", "BOM import", "data set import", and "classification object import", screen out the valid information, delete the redundant information, and streamline the information data imported into the PDM system.

[0054] The import method and system for batch importing the historical data of tooling into the PDM system provided by the present invention are simple to operate, realizing batch import of data. There is no need to manually establish data information in the PDM system, which is applicable to batch import of BOM structure data information such as cutting tools, tools, and fixtures, improving work efficiency.

[0055] The import method and system for batch importing the historical data of tooling into the PDM system provided by the present invention are simple and effective, and are conducive to popularization. BRIEF DESCRIPTION OF THE DRAWINGS

[0056] By reading the following detailed description of the non-restrictive embodiments with reference to the accompanying drawings, other features, objects, and advantages of the present invention will become more apparent:

[0057] Figure 1 It is a schematic diagram of the steps of the import method for batch importing the historical data (BOM) of tooling into the PDM system in an embodiment of the present invention.

[0058] Figure 2 Schematic diagram of the import method steps for batch importing the historical data (BOM) of work jigs and fixtures into the PDM system in a preferred embodiment of the present invention.

[0059] Figure 3 Schematic diagram of the standard format template in a preferred embodiment of the present invention. Among them, (a) is the standard format template for Item work jig and fixture data, (b) is the standard format template for BOM data, (c) is the standard format template for dataset data, and (d) is the standard format template for classification object data;

[0060] Figure 4 Schematic diagram of the function entry for Item import, BOM import, dataset import, and classification object import.

[0061] Figure 5 Schematic diagram of the import result of Item work jig and fixture data in a preferred embodiment of the present invention.

[0062] Figure 6 Schematic diagram of the import result of BOM data in a preferred embodiment of the present invention.

[0063] Figure 7 Schematic diagram of the import result of dataset data in a preferred embodiment of the present invention. After completing the Item data import and BOM import, by clicking Figure 4 the "dataset import" function in

[0064] Figure 8 Schematic diagram of the import result of classification object data in a preferred embodiment of the present invention.

[0065] Figure 9 Schematic diagram of the composition structure of the import system for batch importing the historical data (BOM) of work jigs and fixtures into the PDM system in an embodiment of the present invention. Detailed implementation method

[0066] The following is a detailed description of the embodiments of the present invention: These embodiments are implemented on the premise of the technical solution of the present invention, and detailed implementation methods and specific operation processes are given. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present invention, several deformations and improvements can still be made, and these all belong to the protection scope of the present invention.

[0067] Figure 1 Schematic diagram of the import method steps for batch importing the historical data of work jigs and fixtures into the PDM system provided by an embodiment of the present invention.

[0068] As Figure 1 shown, the import method for batch importing the historical data (BOM) of work jigs and fixtures into the PDM system provided by this embodiment may include the following steps:

[0069] S100. Construct a standard format template for importing historical data of work jigs and fixtures, and organize the historical data of Item work jigs and fixtures data, BOM data, dataset data, and classification object data to be imported according to the standard format template respectively;

[0070] S200. Import the organized Item work jigs and fixtures data into the PDM system to create work jig and fixture data objects;

[0071] S300. Import the organized BOM data into the PDM system to establish the hierarchical structure relationship of Item work jigs and fixtures data;

[0072] S400. Import the organized dataset data into the PDM system and upload the dataset data to the corresponding Item work jigs and fixtures data;

[0073] S500. Import the organized classification object data into the PDM system and add the imported work jig and fixture data to the corresponding classification attribute list pre-established in the PDM system;

[0074] After the above steps, the batch import of historical data of work jigs and fixtures is completed.

[0075] In S100 of this embodiment, as a preferred embodiment, the standard format template is established in Excel format, including the standard format template for Item data import, the standard format template for BOM data import, the standard format template for dataset data import, and the standard format template for classification object data import.

[0076] Further, as a preferred embodiment, the standard format template is provided with corresponding attribute information as needed.

[0077] In S200 of this embodiment, as a preferred embodiment, importing the organized Item work jigs and fixtures data into the PDM system to create work jig and fixture data objects includes:

[0078] Use the Item import function to import the organized Item work jigs and fixtures data into the PDM system.

[0079] Further, as a preferred embodiment, the organized Item work jigs and fixtures data includes any one or any combination of the following attribute information:

[0080] - Type;

[0081] - Item name;

[0082] - Rev;

[0083] - Name of process device;

[0084] - Description;

[0085] - UOM;

[0086] - Owner;

[0087] - All groups;

[0088] - English name;

[0089] - Resource category;

[0090] According to the imported Item fixture data, a fixture data object is created.

[0091] In S300 of this embodiment, as a preferred embodiment, the sorted BOM data is imported into the PDM system to establish the hierarchical structure relationship of the fixture data, including:

[0092] Using the BOM import function, the sorted BOM data is imported into the PDM system, and according to the hierarchical relationship of the BOM data, the hierarchical structure of the imported Item fixture data is established.

[0093] Furthermore, as a preferred embodiment, the sorted BOM data includes any one or any combination of the following attribute information:

[0094] - Parent part ID;

[0095] - Sub - part ID;

[0096] - Location number;

[0097] - Quantity;

[0098] - Material;

[0099] - Part number;

[0100] - Drawing size.

[0101] In S400 of this embodiment, as a preferred embodiment, the sorted data set is imported into the PDM system, and the relevant attachment information of the fixture data in the data set is imported into the corresponding Item fixture data, including:

[0102] Using the data set import function, the data set data is imported into the corresponding Item fixture data, and the data set data includes: drawings, models, and / or documents.

[0103] Furthermore, as a preferred embodiment, the format types of the data set data include: word, xls, PDF, DWG, Image, and / or JPEG formats.

[0104] In S500 of this embodiment, as a preferred embodiment, the sorted classified object data is imported into the PDM system, and the imported tooling data is added to the corresponding classification attribute list pre-established in the PDM system, including:

[0105] Using the classified object data import function, the imported Item tooling data is added to the corresponding classification attribute list pre-established in the PDM system, and the imported Item tooling data can be viewed in the corresponding classification attribute list library pre-established in the PDM system.

[0106] In this embodiment, as a specific application example, the pre-established classification attribute list can be established manually before data import.

[0107] The import method for batch importing the historical tooling data into the PDM system provided by the above embodiments of the present invention establishes a standard format template for all data, and through the data import function, the data sorted according to the standard template format is imported into the PDM system. For Item import, all Item tool clamp data is first imported; for BOM import, the imported Item tool clamp data is divided into a hierarchical and tree-like structure; for dataset import, some related attachments are batch imported to the attachment location of the corresponding Item tool clamp data; for classified object import, the previously imported Item tool clamp data is stored in the classification library in the PDM system according to the corresponding class, and the classification library contains a corresponding hierarchical structure, that is, the classification attribute list.

[0108] Figure 2 It is a schematic diagram of the steps of the import method for batch importing the historical tooling data (BOM) into the PDM system provided by a preferred embodiment of the present invention.

[0109] As Figure 2 shown, the import method for batch importing the historical tooling data (BOM) into the PDM system provided by this preferred embodiment may include the following steps:

[0110] Step 1: Sort the local historical tooling data according to the made standard format templates of "Item import", "BOM import", "dataset import", and "classified object import". The standard format templates are as shown in (a) to (d) in Figure 3 , and the import function entry is as shown in Figure 4 ;

[0111] Step 2: Perform "Item import", and import the "Item import file" sorted in Step 1 into the PDM system through the import function, and create an import data object in the PDM system. The result is as shown in Figure 5 ;

[0112] Step 3: Perform "BOM Import". Import the "BOM Import File" sorted in Step 1 into the PDM system through the import function, and establish the hierarchical structure relationship of the imported data in the PDM system. The result is as shown in Figure 6 shown;

[0113] Step 4: Perform "Dataset Import". Batch import the "Dataset Import File" (such as drawings, models, etc.) sorted in Step 1 into the corresponding object attachments through the import function. The result is as shown in Figure 7 shown;

[0114] Step 5: Perform "Classification Object Import". Import the "Classification Object Import File" sorted in Step 1 through the import function. This step adds the imported tooling data to the corresponding classification attribute list in the PDM system. The result is as shown in Figure 8 shown.

[0115] After the above steps, the batch import of the tooling historical data is completed.

[0116] In some embodiments of the present invention:

[0117] In Step 1, the standard format templates for Item Import, BOM Import, Dataset Import, and Classification Object Import are established using Excel files to standardize the data information required for import and perform unified batch import.

[0118] The standard format template includes attributes such as Type, Item Name, Rev, Tool Name, Parent ID, Child ID, Dataset Name, etc.

[0119] In Step 2, the prepared Item tooling data format is imported into the PDM system using the developed Item import function. The standard format template for Item Import includes attribute information such as Type, Item Name, Rev, and Process Device Name.

[0120] Furthermore, the standard format template for Item Import can also include attribute information such as Description, UOM, Owner, All Groups, English Name, Resource Category, etc.

[0121] In Step 3, the hierarchical structure of the imported data is established using the developed BOM import function. The standard format template for BOM Import includes attribute information such as Parent ID, Child ID, Location Number, Quantity, etc.

[0122] Furthermore, the standard format template for BOM Import can also include attribute information such as Material, Part Number, Drawing Size, etc.

[0123] In step 4, use the developed dataset import function to batch import relevant attachments into the corresponding object attachments. The attachments include files such as drawings and models, and the attachment format types include formats such as word, xls, PDF, DWG, Image, and JPEG.

[0124] In step 5, use the developed classified object import to add the imported data to the corresponding classified attribute column in the PDM system. The imported tooling data can be viewed in the classification library of the PDM system.

[0125] Use the Figure 4 shown import function entry to fill the data to be imported into the template format according to the designed standard format, and then strictly import the tooling data in the order of Item import, BOM import, dataset import, and classified object import.

[0126] By clicking on the Figure 4 "Item import" function shown in, manually select the Excel data file that has been sorted according to the Item import template, and it will jump to display the form of the Item data to be imported for confirmation. As Figure 5 shown, after clicking confirm, batch import the Item data into the PDM system.

[0127] After completing the Item data import, by clicking on the Figure 4 "BOM import" function shown in, manually select the Excel data file that has been sorted according to the BOM import template, and it will jump to display the form of the BOM data to be imported for confirmation. As Figure 6 shown, after clicking confirm, batch import the BOM data into the PDM system. This function realizes the hierarchical structure division of the data imported by "Item import".

[0128] For the Excel data file sorted according to the dataset import template, and place the dataset file in the corresponding path, it will jump to display the form of the dataset data to be imported for confirmation. As Figure 7 shown, after clicking confirm, batch import the dataset data into the PDM system. This function realizes the upload of tooling attachment data.

[0129] After completing the Item data import, BOM import, and dataset import, by clicking on the Figure 4 "classified object import" function shown in, manually select the Excel data file that has been sorted according to the classified object import template, and it will jump to display the form of the classified object data to be imported for confirmation. As Figure 8 shown, after clicking confirm, batch import the classified object data into the PDM system. This function realizes the classified storage of the tooling data imported by Item according to the set categories. Figure 9Schematic diagram of the component modules of the import system for batch importing historical fixture data into a PDM system provided by an embodiment of the present invention.

[0130] As Figure 9 shown, the import system for batch importing historical fixture data into a PDM system provided by this embodiment may include: a standard format template construction module, an Item data import module, a BOM data import module, a dataset data import module, and a classification object data import module. Among them:

[0131] The standard format template construction module constructs a standard format template for importing historical fixture data, and organizes the required imported Item fixture data, BOM data, dataset data, and classification object data according to the standard format template for historical data.

[0132] The Item data import module imports the organized Item fixture data into the PDM system to create a fixture data object.

[0133] The BOM data import module imports the organized BOM data into the PDM system to establish a hierarchical structure relationship for the Item fixture data.

[0134] The dataset data import module imports the organized dataset data into the PDM system and uploads the dataset data to the corresponding Item fixture data.

[0135] The classification object data import module imports the organized classification object data into the PDM system and adds the imported fixture data to the corresponding classification attribute list pre-established in the PDM system.

[0136] In this embodiment, as a preferred embodiment, the import system is installed on a smart terminal.

[0137] According to the above method and system, it can be developed into an application program for batch importing historical fixture data (BOM) into a PDM system, and this application program can be randomly installed on a smart terminal.

[0138] The import method and system for batch importing historical data of jigs and fixtures into the PDM system provided by the above embodiments of the present invention achieve batch data import, eliminating the need to manually create data information in the PDM system, and are applicable to batch importing of BOM structure data information such as cutting tools, tools, and jigs. It solves the problems of large workload and low efficiency caused by a large amount of data and complex data relationship levels during the process of importing tooling historical data into the PDM system. By using the tools and methods of the present invention, the efficiency of data import can be greatly improved. The standard formats of "Item import", "BOM import", "dataset import", and "classification object import" are formulated to sort out the tooling historical data information, screen out valid information, delete redundant information, and streamline the information data imported into the PDM. The import method and system for batch importing historical data of jigs and fixtures into the PDM system provided by the above embodiments of the present invention are simple to operate, achieve batch data import, eliminate the need to manually create data information in the PDM system, and are applicable to batch importing of BOM structure data information such as cutting tools, tools, and jigs; the method and system are simple and effective, and are conducive to popularization.

[0139] It should be noted that the steps in the method provided by the present invention can be implemented by corresponding modules, devices, units, etc. in the system. Those skilled in the art can refer to the technical solution of the method to implement the composition of the system, that is, the embodiments in the method can be understood as preferred examples for constructing the system, which will not be elaborated here.

[0140] Those skilled in the art know that in addition to implementing the system and its various devices provided by the present invention in the form of pure computer-readable program code, the method steps can be logically programmed to enable the system and its various devices provided by the present invention to be implemented in the form of logic gates, switches, application-specific integrated circuits, programmable logic controllers, and embedded microcontrollers to achieve the same functions. Therefore, the system and its various devices provided by the present invention can be regarded as a hardware component, and the devices included therein for implementing various functions can also be regarded as the structure within the hardware component; the devices for implementing various functions can also be regarded as both software modules for implementing the method and the structure within the hardware component.

[0141] The specific embodiments of the present invention have been described above. It should be understood that the present invention is not limited to the above specific embodiments, and those skilled in the art can make various deformations or modifications within the scope of the claims, which do not affect the essence of the present invention.

Claims

1. An import method for batch importing historical data of jigs and fixtures into a PDM system, characterized in that, it includes: Construct a standard format template for importing historical data of jigs and fixtures, and organize the required imported Item jig and fixture data, BOM data, dataset data, and classification object data according to the standard format template for historical data; Import the organized Item jig and fixture data into the PDM system to create jig and fixture data objects; Import the organized BOM data into the PDM system to establish the hierarchical structure relationship of the Item jig and fixture data; Import the organized dataset data into the PDM system, and upload the dataset data to the corresponding Item jig and fixture data; Import the organized classification object data into the PDM system, and add the imported Item jig and fixture data to the corresponding classification attribute list pre-established in the PDM system; After the above steps, the batch import of historical data of jigs and fixtures is completed; wherein: The standard format template is established in Excel format, including the standard format template for importing Item data, the standard format template for importing BOM data, the standard format template for importing dataset data, and the standard format template for importing classification object data; The standard format template is provided with corresponding attribute information as needed.

2. The import method for batch importing historical data of jigs and fixtures into a PDM system according to claim 1, characterized in that, The step of importing the organized Item jig and fixture data into the PDM system to create jig and fixture data objects includes: Using the Item import function, import the organized Item jig and fixture data into the PDM system; The organized Item jig and fixture data includes any one or more of the following attribute information: - Type; - Item name; - Rev; - Name of process device; - Description; - UOM; - Owner; - All groups; - English name; - Resource category; Create jig and fixture data objects based on the imported Item jig and fixture data.

3. The import method for batch importing historical data of jigs and fixtures into a PDM system according to claim 1, characterized in that, The step of importing the organized BOM data into the PDM system to establish the hierarchical structure relationship of the Item jig and fixture data includes: Using the BOM import function, import the organized BOM data into the PDM system, and establish the hierarchical structure of the imported Item jig and fixture data according to the hierarchical relationship of the BOM data; The organized BOM data includes any one or more of the following attribute information: - Parent part ID; - Sub-part ID; - Location number; - Quantity; - Material; - Part number; - Drawing size.

4. The import method for batch importing historical data of jigs and fixtures into a PDM system according to claim 1, characterized in that, The step of importing the organized dataset into the PDM system and importing the relevant attachment information of the jig and fixture data in the dataset into the corresponding Item jig and fixture data includes: Using the dataset import function, import the dataset data into the corresponding Item jig and fixture data, and the dataset data includes: drawings, models, and / or documents; The format types of the data in the dataset include: word, xls, PDF, DWG, Image, and / or JPEG format.

5. The import method for batch importing fixture historical data into the PDM system according to claim 1, characterized in that importing the sorted classified object data into the PDM system and adding the imported Item fixture data to the corresponding classification attribute list pre-established in the PDM system, including: Using the classified object data import function, adding the imported Item fixture data to the corresponding classification attribute list pre-established in the PDM system, and the imported Item fixture data can be viewed in the corresponding classification attribute list library pre-established in the PDM system.

6. An import system for batch importing fixture historical data into the PDM system, characterized in that it includes: A standard format template construction module, which constructs a standard format template for importing fixture historical data, and sorts the required imported Item fixture data, BOM data, dataset data, and classified object data according to the standard format template respectively; An Item data import module, which imports the sorted Item fixture data into the PDM system to create a fixture data object; A BOM data import module, which imports the sorted BOM data into the PDM system to establish the hierarchical structure relationship of the Item fixture data; A dataset data import module, which imports the sorted dataset data into the PDM system and uploads the dataset data to the corresponding Item fixture data; A classified object data import module, which imports the sorted classified object data into the PDM system and adds the imported fixture data to the corresponding classification attribute list pre-established in the PDM system; wherein: The standard format template is established in Excel format, including a standard format template for importing Item data, a standard format template for importing BOM data, a standard format template for importing dataset data, and a standard format template for importing classified object data; The standard format template is provided with corresponding attribute information as needed.

7. The import system for batch importing fixture historical data into the PDM system according to claim 6, characterized in that the import system is installed on a smart terminal.

Images