Data update method and program

Abstract

To provide a data updating method capable of properly storing a packing style in a database even for a trial product.SOLUTION: There is provided a data updating method including the steps of: acquiring component information for a component to be delivered; acquiring the component information for the ordered component from an order information database; collating the component information for the component to be delivered with the component information for the ordered component; acquiring newly installed or change information for the ordered component from a design information database; determining whether or not packing style data of the component to be delivered is added or updated from the component information for the ordered component and the newly installed or change information for the ordered component; and when the packing style data is determined to be added or updated, adding or updating the packing style data of the component to be delivered.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a data update method and a program.

Background Art

[0002] In the prototype stage, it is necessary to register the loading state of prototype parts in a database for inventory management of the warehouse. However, the number and shape of prototype parts are not stable. In addition, there are many new product numbers for prototype parts, and reference data cannot be used. Furthermore, since the production quantity and turnover opportunities of prototype parts are small, there is a problem that even if the loading state information can be obtained mechanically, it is not easy to link it with the product number.

[0003] Patent Document 1 describes a method for significantly shortening the time required for registering component information in a database of components that support the production of printed circuit boards by an electronic component mounting machine. Store the component number and the corresponding component information in a computer, and store a program for analyzing product information inside the computer. Read the component number in Step 1. Determine the component type in Step 2. Determine the shape and loading state information of the component in Step 3. Determine whether the component information has already been registered in the component database in Step 4. If it is not registered in Step 5, automatically register the component information in the component database.

Prior Art Documents

Patent Documents

[0004]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0005] However, prototype parts are subject to shape changes due to design modifications, or their packaging varies depending on the number delivered, resulting in non-unique part numbers and packaging configurations. Therefore, the purpose of this disclosure is to provide a data update method that allows for the proper storage of packaging configurations in a database, even for prototype parts. [Means for solving the problem]

[0006] The data update method in this disclosure is: Steps include obtaining part information for the parts to be delivered, Steps include obtaining part information for ordered parts from the order information database, The steps include: comparing the parts information of the parts to be delivered with the parts information of the parts that were ordered; The steps include obtaining information on the new installation or modification of the ordered parts from the design information database, A step of determining whether to add or update the packaging data of the parts to be delivered based on the parts information of the ordered parts and the new installation or modification information of the ordered parts, The data update method comprises the step of adding or updating the packaging data of the parts to be delivered when it is determined that the aforementioned packaging data should be added or updated.

[0007] By determining whether to add or update the packaging data of the delivered parts based on the parts information of the ordered parts and the information on the new or modified parts of the ordered parts, a data update method can be provided that allows the packaging details to be properly saved in the database, even for prototype parts.

[0008] The data update method in this disclosure is: The determination step is characterized in that it is performed after the step of obtaining part information of the ordered part and the step of obtaining new installation or modification information of the ordered part, but before the verification step.

[0009] With the above configuration, the packaging details can be properly saved to the database even if the order of data updates is changed.

[0010] The data update method in this disclosure is: The step of obtaining part information of the parts to be delivered is characterized by being performed by inputting images of the parts to be delivered into a machine learning model that stores multiple images of the parts to be delivered, and then identifying the parts to be delivered.

[0011] With the above configuration, artificial intelligence (AI) can be used to automatically identify the parts to be delivered.

[0012] The data update method in this disclosure is: The matching step is performed when the time of photography, location of photography, part number, and supplier name of the parts to be delivered correspond to the scheduled delivery time, receiving location, part number, and supplier name of the ordered parts, respectively.

[0013] The above configuration allows for linking the parts to be delivered with the parts that have been ordered.

[0014] The program disclosed herein is Steps include obtaining part information for the parts to be delivered, Steps include obtaining part information for ordered parts from the order information database, The steps include: comparing the parts information of the parts to be delivered with the parts information of the parts that were ordered; The steps include obtaining information on the new installation or modification of the ordered parts from the design information database, A step of determining whether to add or update the packaging data of the parts to be delivered based on the parts information of the ordered parts and the new installation or modification information of the ordered parts, This program causes an information processing device to perform the following steps when it is determined that the aforementioned packaging data should be added or updated: add or update the packaging data of the parts to be delivered.

[0015] With the above configuration, it is possible to provide a program that causes the information processing device to properly save the packaging details of even prototype parts to the database. [Effects of the Invention]

[0016] According to the present disclosure, even for prototype parts, a data update method capable of appropriately storing the loading posture in a database can be provided.

Brief Description of the Drawings

[0017] [Figure 1] It is a flowchart of the data update method according to Embodiment 1. [Figure 2] It is a flowchart of the data update method according to Embodiment 2.

Modes for Carrying Out the Invention

[0018] Embodiment 1 Hereinafter, embodiments of the present invention will be described with reference to the drawings. However, the invention according to the claims is not limited to the following embodiments. Also, not all of the configurations described in the embodiments are essential as means for solving the problems. For clarity of explanation, the following description and drawings have been appropriately omitted and simplified. In each drawing, the same elements are denoted by the same reference numerals, and duplicate explanations are omitted as necessary.

[0019] (Explanation of the data update method according to Embodiment 1) FIG. 1 is a flowchart of the data update method according to Embodiment 1. The data update method according to Embodiment 1 will be described with reference to FIG. 1.

[0020] First, parts are received (step S101). The parts are prototype parts, that is, prototype components. The loading posture of the prototype parts changes according to the quantity. Also, in some cases, the loading posture changes even for the same parts and quantity. A data update method for appropriately registering such parts in a database will be described.

[0021] Next, the parts are photographed (step S102). The parts are photographed using cameras in the primary storage area after they are unloaded from trucks or other vehicles and brought in. The parts are sorted in the primary storage area and then placed in the delivery area of ​​the warehouse.

[0022] Next, information about the parts is extracted from the captured images (step S103). AI is used to obtain information about the parts to be delivered. The AI ​​identifies the parts to be delivered by inputting images of the parts to be delivered into a machine learning machine that has stored multiple images of multiple parts to be delivered. The information about the parts to be delivered is, for example, as shown in A, 1) time of shooting, 2) location of shooting, 3) 5-digit part number, 4) external dimensions, 5) volume, and 6) supplier name. The time of shooting is the time when the image was taken. The location of shooting is the location where the image was taken, for example, a primary storage warehouse. The 5-digit part number is a number that represents the name of the part, such as a gear or wheel. Using AI, the 5-digit part number representing the name of the part is estimated from the appearance of the delivered part. The external dimensions are the dimensions of the delivered part that can be seen from the appearance. The volume is the volume of the delivered part that can be seen from the appearance. The supplier name is the name of the company that purchased the delivered part. Using AI, the supplier name written on the container of the delivered part is obtained. If the supplier's name is not listed on the container, it is acceptable if the supplier's name cannot be obtained.

[0023] Next, the part numbers are verified (step S104). First, the part information of the ordered parts is obtained from the order information database 101. The order information database 101 contains, for example, the i) scheduled delivery time, ii) receiving location, iii) 10-digit part number, iv) supplier name, and v) ordered quantity of the ordered parts, as shown in B. The scheduled delivery time is the time when the ordered parts will be delivered. The receiving location is the location of the primary storage warehouse where the ordered parts will be received. The 10-digit part number is a number that indicates which prototype the part will be used for, in addition to the part name. The supplier name is the name of the company that purchased the ordered parts. The ordered quantity is the number of parts ordered.

[0024] Then, the part information of the parts to be delivered is compared with the part information of the ordered parts. As shown in C, for example, the 1) time of photography, 2) location of photography, 3) 5-digit part number, and 6) supplier name of the parts to be delivered correspond to the i) time of delivery, ii) location of receipt, iii) 10-digit part number, and iv) supplier name of the ordered parts. From the corresponding data, the 10-digit part number, external dimensions, volume, supplier name, and quantity of the ordered and delivered parts are obtained.

[0025] Next, new and modified information is obtained (step S105). New or modified information for ordered parts is obtained from the design information database 102. The design information database contains new information indicating that a part is new, and modified information indicating that the shape of a part has been changed.

[0026] Next, it is determined whether or not there is a need to add or update packaging data (step S106). Based on the parts information of the ordered parts and the new or modified information of the ordered parts, it is determined whether or not to add or update the packaging data of the parts to be delivered. If it is not necessary (the No. in step S106), the process is terminated.

[0027] If the part is new or its shape has changed, and new or updated packaging data is required (if the answer is Yes in step S106), packaging data is generated as shown in D (step S107). In addition to the photographed packaging, the packaging data includes information such as the 10-digit part number, external dimensions, volume, supplier name, and quantity, obtained from the acquired delivery and ordered parts data. Finally, the packaging data is stored and updated in the packaging database, and the process ends (step S108).

[0028] In this way, by determining whether or not to add or update the packaging data of the delivered parts based on the parts information of the ordered parts and the information on the new or modified parts of the ordered parts, it is possible to provide a data update method that can appropriately save the packaging details in the database, even for prototype parts.

[0029] (Description of the data update method according to Embodiment 2) Figure 2 is a flowchart of the data update method according to Embodiment 2. The data update method according to Embodiment 2 will be explained with reference to Figure 2.

[0030] The data update method according to Embodiment 2 differs from the data update method according to Embodiment 1 in that the determination step is performed after the step of acquiring part information of the ordered part and the step of acquiring new installation or modification information of the ordered part, but before the verification step.

[0031] First, the parts are ordered (step S201). Next, the part information to be updated or added is obtained (step S202). The part information of the ordered parts is retrieved from the order information database 101. The part information of the ordered parts includes, for example, the scheduled delivery time, receiving location, supplier name, 10-digit part number, and the number of units ordered, as shown in A. Next, the new installation or modification information of the ordered parts is retrieved from the design information database 102.

[0032] Next, it is determined whether or not it is necessary to add or update the packaging data (step S203). Based on the parts information of the ordered parts and the new or modified information of the ordered parts, it is determined whether or not to add or update the packaging data of the parts to be delivered. If it is not necessary (the result of step S203 is No), the process is terminated.

[0033] If the ordered parts are new or have a changed shape, and additional or updated packaging data is required (if the answer to step S203 is Yes), determine whether photography is necessary at each receiving location (step S204). This is because the photographic data may change at each receiving location. Next, prepare for photography at each receiving location (step S205). Prepare for photography at the receiving locations where photography is required.

[0034] Next, the parts are delivered (step S206). Then, the delivered parts are photographed (step S207). Next, the images and part information are compared (step S208). First, AI is used to obtain the part information of the parts to be delivered. Similar to Embodiment 1, the part information of the parts to be delivered includes, for example, 1) time of shooting, 2) location of shooting, 3) 5-digit part number, 4) external dimensions, 5) volume, and 6) supplier name. Next, the part information of the parts to be delivered is compared with the part information of the ordered parts. As shown in C, the 1) time of shooting, 2) location of shooting, 3) 5-digit part number, and 6) supplier name of the parts to be delivered correspond to the i) delivery time, ii) receiving location, iii) 10-digit part number, and iv) supplier name of the ordered parts.

[0035] Next, as shown in D, package data is generated (step S209). In addition to the photographed package, the package data includes, for example, a 10-digit product number, external dimensions, volume, supplier name, and quantity. Finally, the package data is stored and updated in the package database, and the process ends (step S210).

[0036] Even if the order of data updates is changed in this way, the packaging details can still be properly saved to the database.

[0037] The data update method described above can be performed using an information processing device. This device may consist of one or multiple information processing devices. The information processing device includes a processor (CPU (Central Processing Unit)) that executes programs to perform the processing, and memory to store those programs. The information processing device may perform some or all of its functions in the cloud.

[0038] Furthermore, some or all of the processing in the information processing device described above can be implemented as a computer program. Such programs can be stored using various types of non-temporary computer-readable media and supplied to a computer. Non-temporary computer-readable media include various types of tangible recording media. Examples of non-temporary computer-readable media include magnetic recording media (e.g., flexible disks, magnetic tapes, hard disk drives), magneto-optical recording media (e.g., magneto-optical disks), CD-ROMs (Read Only Memory), CD-Rs, CD-R / Ws, and semiconductor memories (e.g., mask ROMs, PROMs (Programmable ROMs), EPROMs (Erasable PROMs), flash ROMs, and RAMs (Random Access Memory)). Programs may also be supplied to a computer by various types of temporary computer-readable media. Examples of temporary computer-readable media include electrical signals, optical signals, and electromagnetic waves. Temporary computer-readable media can be supplied to a computer via wired communication channels such as electric wires and optical fibers, or via wireless communication channels.

[0039] It should be noted that the present invention is not limited to the embodiments described above, and can be modified as appropriate without departing from the spirit of the invention. For example, although this disclosure describes prototype parts, it can also be applied to regular mass-produced products. By having a function to determine whether or not it is necessary to add or update packaging data, even if there is a change in packaging for the same mass-produced product, the packaging can be appropriately registered in the database. [Explanation of Symbols]

[0040] 101 Order Information Database 102 Design Information Database

Claims

1. An information processing device, Steps include obtaining part information for the parts to be delivered, Steps include obtaining part information for ordered parts from the order information database, The steps include: comparing the parts information of the parts to be delivered with the parts information of the parts that were ordered; The steps include obtaining information on the new installation or modification of the ordered parts from the design information database, The steps include determining whether to add or update the packaging data of the parts to be delivered based on the parts information of the ordered parts and the new installation or modification information of the ordered parts, A data update method that, when it is determined that the aforementioned packaging data should be added or updated, performs the step of adding or updating the packaging data of the parts to be delivered, The step of obtaining part information for the parts to be delivered is performed by inputting images of the parts to be delivered into a machine learning model that has stored multiple images of the parts to be delivered, and then identifying the parts to be delivered. A data update method in which the matching step is executed when the time of photography, location of photography, part number, and supplier name of the parts to be delivered correspond to the scheduled delivery time, receiving location, part number, and supplier name of the ordered parts, respectively.

2. The data update method according to claim 1, wherein the determination step is performed after the step of obtaining part information of the ordered part and the step of obtaining new installation or modification information of the ordered part, but before the verification step.

3. Steps include obtaining part information for the parts to be delivered, Steps include obtaining part information for ordered parts from the order information database, The steps include: comparing the parts information of the parts to be delivered with the parts information of the parts that were ordered; The steps include obtaining information on the new installation or modification of the ordered parts from the design information database, The steps include determining whether to add or update the packaging data of the parts to be delivered based on the parts information of the ordered parts and the new installation or modification information of the ordered parts, A program that causes an information processing device to perform the steps of adding or updating the packaging data of the parts to be delivered when it is determined that the aforementioned packaging data should be added or updated, The step of obtaining part information for the parts to be delivered is performed by inputting images of the parts to be delivered into a machine learning model that has stored multiple images of the parts to be delivered, and then identifying the parts to be delivered. The program executes the matching step when the time of photography, location of photography, part number, and supplier name obtained by the machine learning machine for the parts to be delivered correspond to the scheduled delivery time, receiving location, part number, and supplier name of the ordered parts.

4. The program according to claim 3, wherein the determination step is performed after the step of obtaining part information of the ordered part and the step of obtaining new installation or modification information of the ordered part, but before the verification step.

Images