JPH03137739A - Method and device for updating data of product specification data base - Google Patents

Abstract

PURPOSE:To automatically update data in a place concerned in a data base by comparing real data of product repair and displayed specification data, correcting and storing them on a display device and updating data on the data base. CONSTITUTION:When there is the request of repair on an elevator from a customer, a repairman operates a computer 3, takes in product specification data on the elevator concerned, which is stored in the data base 14 in a host computer 1, displays it in a screen 31 and prints it out. The repairman carries printed out data to the scene, compares the specification of the elevator including a repair part with printed out data, checks them, and talks with the customer over a repair content. Then, the repairman returns to a business office, takes out again product specification data of the elevator to be repaired from the data base 14 and displays it in the screen 31 for generating an estimation in repair expense. The repairman collates the screen with real specification data of the elevator which is checked in the scene and corrects difference point.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention provides product specifications for updating the specifications of products delivered to customers stored in a database and for calculating the repair cost of the products. The present invention relates to a database data update method and apparatus.

[Conventional technology]

Generally, when a manufacturer/seller delivers a product to a customer,
It is necessary to store detailed specification data of these products for maintenance, modification, repair, replacement, etc. after delivery. For example, an elevator manufacturer and distributor delivers various types of elevators to various customers according to their needs, but the specification data for each customer and each model of the delivered elevators is recorded. It is kept. When such specification data is large in number, it is usually stored in a computer database.

In addition, in the event that modifications, repairs, or replacements (hereinafter simply referred to as repairs) are performed after delivery of the above-mentioned products, the workers involved in the repairs will estimate the repairs based on the parts unit price list and the man-hour list. Calculate renovation costs.

[Problem to be solved by the invention]

By the way, specification data is stored in a database by a person operating a keyboard, but since this is done manually, input errors cannot be avoided. therefore,
Specification data stored in a database is rarely completely accurate. The number of incorrect specification data in the database may increase each time a new product is delivered or an already delivered product is modified. This will be explained by taking elevator repair as an example and referring to the flowchart shown in FIG.

When a customer requests an elevator to be renovated (or when the need for refurbishment arises), the renovator must print out the specification data for the elevator from the database (step S+ shown in Figure 4), and then use the printed data. The elevator is brought to the site, the specifications of the elevator to be repaired are checked, and the results of this check are compared with the printed data (step Sz). When the meeting and investigation regarding the repairs at the delivery site are completed, the repair staff will extract the parts where the printed data differs from the actual data and the parts to be repaired as a result of the above checks, write them on the printed paper, and report them to the sales office. After returning to the factory, a correction form is created based on this information to correct or change the erroneous data and the data of the repaired parts (step S3). The created correction slip is sent to the host computer room (step S4), and a staff member in the host computer room updates the database based on the correction slip (step SS).

During these procedures, there is a great possibility that the repair staff will make incorrect entries when creating a correction form, and there is also a large possibility that the staff will make incorrect entries when updating the database.

Furthermore, the renovator needs to create an estimate of the cost required for the refurbishment. This estimation work is performed by extracting the unit price of the parts required for the repair from the parts unit price list and multiplying this by the number of parts listed on the above-mentioned corrected printout. However, since the above-mentioned estimation work is performed manually, it requires a lot of effort and time, and there are problems in that errors occur.

The purpose of the present invention is to solve the above-mentioned problems of the prior art, and to be able to automatically calculate the repair cost and at the same time accurately update the specification data stored in the database, thereby ensuring that errors in the specification data in the database are avoided. The object of the present invention is to provide a method and apparatus for updating data in a product specification database, which can reduce the amount of data in a product specification database.

[Means to solve the problem]

In order to achieve the above object, the present invention has a main database in which specification data for each of a large number of products of a large number of customers is accumulated, and the present invention calculates the number of man-hours and the unit price of repair parts for the content of repair work for each product. We have set up other databases to store information when refurbishing a specific product for a specific customer.
Displaying the work details and the specification data of the specific product stored in the main database on a computer screen, comparing the displayed specification data with actual specification data including the repaired parts, and displaying according to the actual specification data. The revised specification data is changed, and the repair cost is calculated from the changed data regarding the work contents and the data stored in the other database, and the changed data is temporarily stored in another storage device, and the repair cost is calculated from the changed data regarding the work contents and the data stored in the other database. The method is characterized in that the specification data of the specific product stored in the database is updated based on the changed data.

Furthermore, the present invention has a main database in which specification data of a large number of products of a large number of customers are accumulated, and another database that stores man-hours and unit prices of repaired parts for the content of repair work for each product. , a computer for retrieving and displaying specification data of a specific product of a specific customer accumulated therein from the main database and storing the displayed specification data; and a computer for storing the displayed specification data, and a computer for obtaining this specification data when repairing the specific product. a data changing means for changing into actual data; a calculation means for calculating a repair cost based on the changed data regarding the contents of the repair work and data stored in the other database; and a calculation means for temporarily storing the changed data. The present invention is characterized in that it includes a storage device for storing data, and a database updating means for updating the contents of the main database at a predetermined time based on the data stored in the storage device.

[Effect]

When modifying a product, the repair tool retrieves the product's specification data from the database and displays it, and compares the displayed data with the actual data obtained when considering the modification to identify incorrect data and repair points. Modify and display the data. Then, the repair cost is automatically calculated from the correct data displayed by manually inputting the work contents of the repair work, and the number of man-hours and unit prices of parts stored in other databases. At the same time, the displayed correct data is temporarily stored in a suitable storage device, and the stored data in the corresponding part of the database is automatically updated.

〔Example〕

An embodiment of the present invention will be described below with reference to FIGS. 1 to 3. FIG. 1 shows a system block diagram for updating data in a product specification database according to the present invention. In the figure 1
is a host computer, 2 is a communication line, and 3 is one computer among one or more computers connected to the host computer 1 via the communication line 2 and located in a remote location, for example, installed in a business office or the like. . 11 is a communication device of the host computer 1, 12 is a control device that controls data processing, etc. of the host computer 1, 13 is a storage device of the host computer 1, 14 is a database that stores product specification data, and 15 constitutes each product. This is a database that stores unit prices of parts and man-hours for each type of repair work. 31 is a keyboard of the computer 3. 33 indicates the main body of the computer 3. The computer main body 33 is a control device for the computer 3 (
(not shown), a storage device (not shown), a communications W (not shown), etc., are housed inside the communication device 11 via the line 2.
Contact! It transmits and receives data to and from the host computer 1, displays the screen 31, calculates and processes data input from the keyboard 32, and stores data.

FIG. 2 is one of the images displayed on the screen 31 of the computer 3 of the present invention, and is an example of a product specification confirmation screen displaying specifications for each elevator product stored in the database 14. Now, when a customer requests elevator renovation, for example, to replace the elevator main lobe and governor lobe, the repair tool operates the computer 3 and stores it in the database 14 in the host computer 1 via the communication line 2. The product specification data of the elevator in question is taken in, displayed on the screen 31, and printed out.

For repair tools, the customer goes to the site with the printed data, compares the specifications of the elevator including the parts to be repaired with the printed data, and consults with the customer about the details of the repair. Thereafter, the repair tool returns to the office, and in order to create an estimate of the repair cost, first, the product specification data of the elevator to be repaired is again retrieved from the database 14 and displayed on the screen 31. This displayed screen is shown in FIG. Here, the repair staff compares this screen with the actual specification data of the elevator that they have checked on site, and corrects any differences between the screen display and the actual specification data. For example, if there are actually 4 main ropes in use, but the data displayed on the screen shows 3 as shown in Figure 2, or the diameter of the governor rope is actually 10φ. However, if the displayed data indicates 8φ as shown in FIG. 2, use the keyboard 32 to correct or change these points. The modified or changed data is stored in the storage device (
(not shown).

Next, the repair worker inputs a code for the repair work (replacement of the main rope and hoist bearing) using the keyboard 32.

This code is prepared in advance at the business office. According to the code input into the computer main body 33, the unit price and man-hours of the repaired parts (in this case, the main rope and the hoist bearing) are retrieved from the database 15, and the quantity based on the data that was corrected or changed earlier (in this case) is retrieved from the database 15. length of 4 main ropes)
is multiplied by the unit price, and a predetermined wage (for example, 31,500 yen) is multiplied by the number of man-hours, and the results are displayed on the screen 31. This display content is shown in FIG. Next, processing of corrected or changed data stored in the storage device within the computer main body 33 will be explained. Normally, the host computer 1 and the computer 3 exchange data with each other via the communication line 2 at a predetermined time every day. During this transmission and reception, the changed data stored in the computer main body 33 is transmitted to the host computer 1 and temporarily stored in its storage device 13. The control device 12 in the host computer l is modified at a predetermined time,
The product usage data in the database 14 corresponding to the change is rewritten with the change data stored in the storage device 13, and the database regarding product specification data is corrected and changed.

In this way, the elevator product specification data can be corrected or changed by displaying the product specification confirmation data on the screen 31 of the computer 3 and inputting the changes using the keyboard when creating a repair cost estimate. The changed data is stored in the storage device, later transmitted to the host computer 1, and then stored in the storage device 13, and the database 1 is updated at a predetermined time using the stored data.
Since the relevant product specification data in step 4 is updated, corrections are made manually while looking at the correction points on the computer screen, so there are no errors in manual input, and no correction slips are created to make changes, so there are no typos. will not occur, and the reliability of the database will increase. Furthermore, since the database is updated at a predetermined time on the host computer, it does not interfere with the use of the database in other systems.

Furthermore, the host computer is equipped with a database that stores not only product specification data, but also part unit prices and repair work man-hours, and this is used to estimate repair costs, so estimates are automatically generated just by inputting the work details. This allows estimation work to be performed easily, accurately, and quickly.

〔Effect of the invention〕

As described above, in the present invention, when creating a repair cost estimate when renovating a product, the specification data of a specific product to be renovated is displayed on a display device, and the actual data of the specific product and the displayed specifications are displayed. data, correct the incorrect data and the data of the repaired parts on the display device, temporarily store this corrected data in the storage device, and update the data in the database at a predetermined time based on this stored data. Since the data is updated, the data can be updated accurately as part of the estimation work, and the data in the database can be steadily reduced. Furthermore, since data updates in the database are simultaneously executed at appropriate fixed times, the normal use of the database is not hindered at all.

Furthermore, since a database is provided on the host computer side to store unit prices of parts and man-hours for each repair work, it is possible to estimate repair costs easily, accurately, and quickly.

[Brief explanation of the drawing]

Figure 1 is a system block diagram for updating data in a product specification database according to an embodiment of the present invention, Figure 2 is a diagram showing a product specification confirmation screen for checking the contents of the product specification database shown in Figure 1, and Figure 3. 4 is a diagram showing a repair cost estimation screen, and FIG. 4 is a flowchart for updating data in a conventional product specification database. 1...Host computer, 2...Communication line, 3...Computer, 11...
・Communication device, 14.15...Database, 3
1...Screen, 32...Keyboard, 3
3... Computer body. I5: Deke A for land acquisition Figure 2

Claims (1)

[Scope of Claims] 1. In a main database in which specification data of multiple products of multiple customers are accumulated, there is another database that stores man-hours and unit prices of repaired parts for the content of repair work for each product. A database is provided, and when a specific product of a specific customer is repaired, the work details and the specification data of the specific product stored in the main database are displayed on a computer screen, and the displayed specification data and repair parts are included. The displayed specification data is compared with the actual specification data, and the displayed specification data is changed according to the actual specification data, and the repair cost is calculated from the changed data regarding the work contents and the data stored in the other database. Data updating of the product specification database, characterized in that the data is temporarily stored in another storage device, and at a predetermined time, the specification data of the specific product stored in the database is updated based on the changed data. Method. 2. In a system that has a main database that stores specification data for each of a large number of products of a large number of customers, another database that stores man-hours and unit prices of repaired parts for the repair work content of each product, and the main database. A computer that retrieves and displays the specification data of a specific product of a specific customer accumulated therein, and a computer that stores the displayed specification data, and converts this specification data into actual data obtained when the specific product is renovated. a data changing means to be changed; a calculation means for calculating a repair cost based on the changed data regarding the content of the repair work and data stored in the other database; and a memory for temporarily storing the changed data. 1. A data updating device for a product specification database, comprising: a device; and a database updating means for updating the contents of the main database at a predetermined time based on data stored in the storage device.