JP2003345863A - Apparatus and method for mill sheet retrieval - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an apparatus and a method for mill sheet retrieval, which retrieve a mill sheet. <P>SOLUTION: The mill sheet retrieving apparatus 21 which retrieves a mill sheet according to retrieval information from a terminal connected through a communication line 23 is constituted by being equipped with information receiving means 32-1 and 33 which receive retrieval information through the communication line 23, a storage means 32 which stores various element data by dividing the mill sheet into various element data consisting of a plurality of elements and image data for a mill sheet form, a retrieving means 32-3 which extracts a mill sheet matching the retrieval information by retrieving the various element data according to the retrieval information, an acquiring means 32-3 which obtains various element data of the mill sheet extracted by the retrieving means 32-3, and transfer means 32-1 and 33 which transfer the various element data obtained by the acquiring means 32-3 to the terminal through the communication line 23. <P>COPYRIGHT: (C)2004,JPO

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a search device for searching for a desired certificate via a communication line, and more particularly to a mill sheet search device for searching for a mill sheet. And
The present invention relates to a mill sheet search method used in the mill sheet search device.

[0002]

2. Description of the Related Art Primary companies that manufacture products such as steel products are:
When a product is delivered to a secondary company to which it is sold, a product inspection certificate generally called a mill sheet is also delivered. This mill sheet is a data sheet showing product contents, for example, dimensions, number of members, mass, product number, steel making number (steel material number), various mechanical properties such as tension, bending, impact, etc., and chemical components. The values of various mechanical properties and chemical components are actually measured test results. For this reason,
Mill sheets can also be used as product inspection certificates to prove product quality.

[0003] This mill sheet is conventionally made on a paper medium. The prepared mill sheets are manually sorted by customer, enclosed in an envelope, and addressed by hand, and distributed by mail or directly to the customer. On the other hand, the created mill sheet is stored in a primary company or a secondary company in case it becomes necessary in the future. In a secondary company, for example, when a secondary company processes and processes a product delivered from a primary company and manufactures and sells a processed product, the secondary company or a government agency, etc., to which the secondary company sells the product, certifies the quality of the processed product. It is stored in case it is attached as one, or when it is proved after sales that there is no problem with the product which became the material of the processed product when the sold processed product was involved in a trouble. Also, in such a case, the primary company keeps it in case a secondary company or a tertiary company (including a government office or the like) needs to reissue it.

This storage is performed by an image reading device such as a scanner in a bitmap format or JPEG (Joint Photogra
After converting the millsheet into image data in a file format such as a phic coding expert group (Phic Coding Experts Group), a database (hereinafter abbreviated as “DB”) is stored in a computer.
Was done by storing as.

[0005]

However, such a method for storing a mill sheet has a large data capacity because it is image data. Therefore, the auxiliary storage device for storing the mill sheet DB also needs to have a large storage capacity. There was a problem.

When it becomes necessary to search for a desired mill sheet from the stored mill sheets, it is difficult to search as it is because the mill sheet is stored in a database with image data. There was a problem. In addition, in order to enable the search of the mill sheet, it is necessary to prepare a search word associated with the image data of each mill sheet registered in the DB, and to construct this as a search database separately from the mill sheet DB. The problem arises.

[0007] In particular, in the case of steel products, a large quantity of, for example, 10,000 steel materials is ordered at one time, and 10,000 mill sheets are issued and delivered in accordance with this order. Storage and retrieval of mill sheets became a serious problem for the second company.

The present invention has been made in view of the above-mentioned problems, and the present invention divides a mill sheet into a style part common to each mill sheet and a specification part different for each mill sheet to separate image data and text data. It is an object of the present invention to provide a mill sheet search device that is electronically stored in a primary company and is searched and obtained by a secondary company via a communication line as needed. It is another object of the present invention to provide a mill sheet search method used in the mill sheet search device.

[0009]

According to the present invention, there is provided a mill sheet searching apparatus for searching for a mill sheet based on search information from a terminal connected via a communication line. Receiving means for receiving the data via the communication line, and storing a plurality of the specification data for each of the plurality of mill sheets by dividing the specification data including a plurality of specifications and image data of the mill sheet paper. Means, a search means for extracting a mill sheet matching the search information by searching from a plurality of the specification data based on the search information, and obtaining specification data corresponding to the mill sheet extracted by the search means Acquisition means, and transfer means for transferring the specification data acquired by the acquisition means to the terminal via the communication line. That.

As described above, the mill sheet searching apparatus according to the present invention divides the mill sheet into the specification data including a plurality of specifications and the image data of the mill sheet paper, and stores the specification data in the storage unit. When the number of mill sheets increases, the specification data that differs for each mill sheet increases, but the image data does not increase because the same type of mill sheet uses the same paper. The specification data has a relatively small data capacity. For this reason, the present invention can efficiently store the mill sheet in the storage unit with a smaller storage capacity than in the case where the mill sheet is directly stored as image data. Further, when searching for a desired mill sheet, it is possible to efficiently and easily search using specification data which is text data.

In the mill sheet searching apparatus according to the present invention, preferably, the storage means includes:
While storing a plurality of the image data, further stores a combining program for combining the specification data and the image data,
The transfer unit transfers the specification data acquired by the acquisition unit, one or more of the image data, and the combining program to the terminal. With this configuration, the terminal can obtain the mill sheet of the search result by using the combining program.

Preferably, in the mill sheet search apparatus according to the present invention, the storage means stores a plurality of the image data and further stores a synthesizing program for synthesizing the specification data and the image data. The search means further extracts image data corresponding to the extracted mill sheet from a plurality of the image data, and combines the specification data acquired by the acquisition means and the image data searched by the search means with the synthesizing program. And a synthesizing unit that generates mill sheet data by synthesizing the mill sheet data, and the transfer unit transfers the mill sheet data generated by the synthesizing unit to the terminal. With this configuration, the terminal can immediately obtain the mill sheet of the search result.

Further, in such a mill sheet search apparatus according to the present invention, preferably, the storage means has a customer code which is a code for identifying a customer and a right to use the mill sheet search apparatus among the customers. A customer management database in which IDs for identifying users are registered in association with each other, and the mill sheet is divided into specification data including a plurality of specifications and image data of mill sheet paper to divide the specification data into the aforementioned data. A mill sheet specification data database registered in association with the customer code,
Further comprising customer code extracting means for extracting a customer code from the customer management database based on an ID from the terminal, wherein the search means searches a mill sheet specification data database based on the search information. Thus, a mill sheet that matches the search information is extracted from the specification data including the customer code extracted by the customer code extraction unit.

[0014] Further, in such a mill sheet search apparatus according to the present invention, preferably, a contract, a customer, a standard,
An order management master database in which contract numbers, customer codes, standard codes, type codes and specification numbers, which are codes for identifying types and specifications, respectively, are registered in association with each other, and codes for identifying steel materials. A steel material number, a test number that is a code for identifying test inspection information that is a result of the test inspection of the steel material, a production management database in which the contract number is registered in association with each other, and the test number. A material test database in which the test / inspection information is registered in association with each other, and a standard database in which the standard codes and standard description items, which are description items of a mill sheet corresponding to the standard, are registered in association with each other. And the specification number and the customer-described item that is a description item of the mill sheet according to the customer's request are registered in association with each other. A second storage unit for storing a customer specification database, and searching the production management database based on the steel material number to obtain a contract number and a test number corresponding to the steel material number, and based on the obtained test number. The material test database is searched to obtain test / inspection information corresponding to the test number, and the order management master database is searched based on the obtained contract number, and the standard code and specification number corresponding to the contract number are obtained. Acquired, searching the standard master database based on the acquired standard code to obtain a standard description item corresponding to the standard code, searching the customer specification master database based on the obtained specification number, and Acquisition means for acquiring customer-described items corresponding to the above, and acquisition based on acquired standard-described items and customer-described items Composed of testing the test information further comprising a creating means for creating specification data stored in the storage means. With this configuration, it is possible to provide a customer with a mill sheet in which specifications meeting specifications and customer requirements are described.

Further, in the mill sheet searching apparatus according to the present invention, preferably, the customer management database further registers the contact information of the customer in association with the customer code, and stores new specification data. Contact point acquisition means for, when registered in the mill sheet specification database, searching the customer management database based on the customer code in the new specification data and acquiring a contact point of a customer corresponding to the customer code; Notification means for notifying the acquired contact information of the customer that a mill sheet of the new specification data has been created. With this configuration, the customer can know that the mill sheet has been created.

[0016] In the mill sheet search apparatus according to the present invention, preferably, the storage means includes a tertiary customer code which is a code for identifying a tertiary company which is a customer of the customer, and the mill sheet. The ID of the tertiary company for identifying a user who has the right to use the search device, the customer code, and the disclosure information for specifying the mill sheet that can be disclosed to the tertiary company are registered in association with each other. The tertiary customer management database is further stored, and the search unit further extracts the mill sheet based on the disclosure information of the tertiary customer management database. Preferably, the tertiary customer management database is further operable from a terminal located at the customer. With this configuration, the mill customer can search for the mill sheet within a range permitted by the secondary customer.

[0017]

Embodiments of the present invention will be described below with reference to the drawings. In each drawing, the same components are denoted by the same reference numerals, and description thereof will be omitted.

FIG. 1 is a block diagram schematically showing an overall configuration of a mill sheet search system according to the present invention.

In FIG. 1, a mill sheet search system 1
00 is roughly composed of a creation system 101 and an external search system 102. Creation system 101
Is a host computer 11, a database (hereinafter, referred to as
Abbreviated as "DB". ) 12, a communication device 13, an order processing system 14, a manufacturing processing system 15, a test processing system 16, and a terminal device 17. The external search system 102 includes a web server 21 and a customer terminal 22.
And a communication line 23. Here, the web server 21 and the creation system 101 of the external search system 102 are installed in a primary company that is a product manufacturer. On the other hand, the customer terminal 22 of the external search system 102
It is installed in a secondary company (for example, a processing maker or a trading company) where the primary company delivers products. Further, when the mill sheet is distributed to the tertiary company to which the processed product or the product is delivered from the secondary company as described later, the terminal device 22
It is set up in tertiary companies.

Host computer 11, order processing system 14, manufacturing processing system 15, test processing system 1
6, terminal device 17, web server 21 and customer terminal 2
2 is a name corresponding to the function, and is a so-called computer in terms of hardware. That is, a storage unit for storing a program and various data during execution of the program, an input unit (for example, a keyboard and a mouse) for inputting commands (commands) and data, and an output for outputting images and various data to the outside (For example, a display and a printer) and a central processing unit (hereinafter abbreviated as “CPU”) that performs various arithmetic processing such as control of these storage units, input units and output units, and execution of programs. And an auxiliary storage device, an external storage device, or various interfaces as necessary. The order processing system 14 is not limited to a single computer system, but has a plurality of sales bases and is installed in a secondary company such as a trading company. In some cases, a network including a communication device for exchanging data with each other is formed. Similarly, the manufacturing processing system 15 and the test processing system 16 may form a network because there are a plurality of manufacturing sites and test / inspection sites.

First, the configuration and operation of the creation system 101 will be described, and then the configuration and operation of the external search system 102 will be described.

(Configuration of Creation System) Creation System 10
In summary, the creation system 101 processes each piece of information related to a mill sheet by distributed processing. That is, the distributed processing system includes an order receiving system 14, a manufacturing processing system 15, and a test processing system 16. The distributed processing system divides the processing steps from receiving an order of a product to production, through test and inspection to shipment, and dividing the process into a plurality of processes. Information generated in the divided processing steps is managed by each of the processing systems 14 to 16. Then, each of the processing systems 14 to 16 transfers information required by the centralized management system. The centralized management system includes a host computer 11, a DB 12, and a communication device 13.
And a terminal device 17. The centralized management system processes various information transferred from each of the processing systems 14 to 16 and registers the processed information in the DB 12, and the terminal device 17.
And DB1 according to the request from each processing system 14-16.
2 is searched and information corresponding to the request is transferred to the request source, thereby centrally managing the information and creating mill sheet specification data. Hereinafter, this will be described in more detail.

The host computer 11 is connected to the DB 12, the communication device 13, the terminal device 17, and the web server 21. Here, from the viewpoint of preventing unauthorized access to the creation system 101 from outside the primary company, a device that functions as a firewall may be installed between the host computer 11 and the web server 21. .

The order processing system 14 is a system for handling order information, and is connected to the communication device 13 via a communication line (dedicated line or exchange line). Order information
It is input from a terminal device installed on the secondary customer side such as a trading company or input by a sales department. When the order information is input, the order processing system 14 transfers the order information to the communication device 13 via a line, and the communication device 13 further transfers the order information to the host computer 11.

The order information includes, for example, a form title (mill sheet title), a contract number, a customer code, a kind code, a standard code, the number of ordered members, an ordered mass, a specification number, and a delivery date. The form title is the name of the mill sheet, and is, for example, a combination of a product type name, a steel material manufacturing base name, and an alphabet. The contract number is a number issued for each contract to identify each contract. The customer code is a code assigned to each customer in order to individually identify a secondary company as a customer. The type code is a code assigned to each type to identify the type of each steel material. The varieties are, for example, plates, wires, steel bars,
There are thin sheet hot rolling and thin sheet cold rolling. The number of order members is the number of manufactured products, ie, steel materials, ordered in the order. The order mass is the mass of the steel material ordered in the order. The specification number is a number that determines the specification of the steel material ordered in the order, and the specification is obtained by searching the customer specification master DB 12-5 based on the specification number. Specifications are special requirements from customers regarding various mechanical properties such as appearance, yield point or yield strength, tensile strength, elongation, bending, impact properties and hardness and chemical composition. The delivery date is the delivery deadline of the product ordered under the contract.

The standard code is a code assigned to each standard in order to identify each standard. Standards are defined by the Japanese Industrial Standards (JIS) or industry standardization organizations, and the items to be listed on the mill sheet are mainly based on the standards, applications (for example, for automobiles, bridges, etc.) or special requests from customers. It is determined. For this reason, even if the mill sheet is of the same type, the items to be described in the mill sheet may be different depending on the standard.

The manufacturing processing system 15 is a system that handles product progress information and shipping information of steel products, and is connected to the communication device 13 via a communication line. Product progress information
For example, a steel material number, a production start date, a production end date, and an end date of each production process as necessary. The steel number is
It is a number issued for each steel material to identify each steel material. One coil or a plurality of sheets are packed and assembled according to the type of the steel material, and the steel materials are delivered as a product according to the number of customers. Therefore, a plurality of steel numbers may correspond to one contract number. The production start date and the production end date are the start date and the end date of the production of the steel material, respectively. The shipping information is the date when the product was shipped. When the product progress information and the shipping information are input to the manufacturing processing system 15, the manufacturing processing system 14 transmits the product progress information and the shipping information to the communication device 13 via a line.
And the communication device 13 further transfers these to the host computer 11.

The test processing system 16 is a system for handling test and inspection information of a product, and is connected to the communication device 13 via a communication line. When the steel material is completed, it is inspected for its appearance, shape and dimensions, a part of the steel material is transported as a test piece to a test and inspection site, and the test items specified by the standards and specifications are measured. When these are measured, a test number is issued for each steel material. The measurement result is used as test / inspection information together with the chemical components obtained in the manufacturing stage, and is input to the test processing system 16 together with the steel material number and the test number. When these are input, the test processing system 16
The test / inspection information, the steel material number, and the test number are transferred to the communication device 13 via the line, and the communication device 13 further transfers these to the host computer 11.

The communication device 13 includes a host computer 11
And an order processing system 14, a manufacturing processing system 15, and a test processing system 16 for mutually transferring information in accordance with a communication protocol. The terminal device 17 is a device that operates the host computer 11 by inputting data, commands, and the like to the host computer 11.

The DB 12 is an auxiliary storage device that uses a magnetic tape, a hard disk, an optical storage medium, or the like as a storage medium. Database (hereinafter abbreviated as “production management DB”) 1
2-2, Material test database (hereinafter referred to as “Material test D”
B ". ) 12-3, a standard master database (hereinafter abbreviated as “standard master DB”) 12-4 and a customer specification master database (hereinafter abbreviated as “customer specification master DB”) 12-5.

The order management master DB 12-1 is a database for managing order information. The fields are
It is determined according to the order information, and in the case of the above example, it includes a form title, a contract number, a customer code, a kind code, a standard code, the number of ordered members, an ordered mass, a specification number, a delivery date, and the like. The record is created for each contract number. The production management DB 12-2 is a database that manages information on steel materials to be produced or produced. The fields include a steel material number, a contract number, a production start date, a production end date, a production end date, a test number, and the like, and a record is created for each steel material number. Material test DB
Reference numeral 12-3 denotes a database for managing test and inspection information of steel materials, and its fields include test numbers and test and inspection information, ie, mass, appearance, dimensions, and physical properties (yield point or proof stress, tensile strength, elongation, bending). , Impact properties and hardness) and chemical components (carbon (C), silicon (Si), manganese (Mn), phosphorus (P), sulfur (S), copper (Cu),
Nickel (Ni), chromium (Cr), molybdenum (M
o), vanadium (V), niobium (Nb), aluminum (Al), nitrogen (N), etc.), and a record is created for each test number.

The standard master DB 12-4 is a database for managing information indicating the correspondence between the standard of the steel material and the description items to be posted on the mill sheet.
A standard code and a description item of a mill sheet are provided, and a record is created for each standard code. The customer specification master DB 31-5 is a database that manages information indicating the correspondence between the specification number, the specification of the customer, and the items to be described in the mill sheet according to the customer's request. With the provision of the customer specification master DB 31-5, steel materials can be manufactured according to the specifications of the customer, and the description items of the mill sheet can meet the requirements of the customer. This is because even in the case of the same standard, the description items of the mill sheet may be increased or decreased by the customer. The field includes a specification number, a specification, and a description item of a mill sheet, and a record is created for each specification number.

(Operation of Creation System) When an order is received from a secondary company as a customer, order information is input to the order processing system 14. The order processing system 14 issues a contract number when inputting order information. Further, since the manufacturing base is also specified by the type, the order processing system 14 may create the form title based on the type code. The input order information is transmitted to the order processing system 14.
The data is transferred to the host computer 11 via the communication device 13. The host computer 11 registers the transferred order information in the order management master DB 12-1 by creating a record for each contract number. The host computer 11 further transfers the order information to the manufacturing processing system 15 via the communication device 13 to the manufacturing processing system 15.

When the order information is transferred, the manufacturing processing system 15 formulates a manufacturing plan for a steel material to be a product of the order information in consideration of the current manufacturing status, other order information, the delivery date of the product, and the like. Then, the production start date and the production end date are determined. At the time of this planning, the steel material number of the steel material assigned to the product is issued by the manufacturing processing system 15. The steel material to be manufactured or manufactured uniquely corresponds to the steel material number. For this reason, steel materials can be managed by steel material numbers. The number of steel materials to be manufactured is one or more depending on the ordered product.
There are cases where a plurality of steel numbers correspond to one contract number. The production processing system 15 transmits the steel material number, the contract number, the production start date and the planned production end date to the communication device 13.
Is transferred to the host computer 11 via. The host computer 11 registers the transferred steel material number, contract number, production start date, and planned production end date in the production management DB 12-2 by creating a record for each steel material number.

When the production of the steel material of the product is completed through various production steps, the production department inputs to the production processing system 15 an input for confirming the completion of the production. When manufacturing completion is input, the manufacturing processing system 15 transfers the steel material number and the manufacturing end date to the host computer 11 via the communication device 13. The host computer 11 searches the production management DB 12-2 based on the steel material number, and registers the production end date in the record of the steel material number. On the other hand, the manufacturing department analyzes chemical components at a certain manufacturing stage, and after manufacturing, looks, shapes,
Measure the dimensions etc. Then, the test specimen is sent to the test department together with the actual measurement results.

Here, every time one manufacturing process of a steel material is completed, the end date of the manufacturing process is input to the manufacturing processing system 15, and the end date of the manufacturing process is further registered in the production management DB 12-2. By doing so, the production progress may be finely managed. By doing so, the sales department can refer to the production management DB 12-2 using the communication device 13 and the host computer 11 from the order processing system 14 when the customer inquires about the progress of the product. Thereby, it is possible to accurately respond to the customer about the progress.

When the steel test piece is sent, the test department
Measure various mechanical properties. The test section inputs the steel material number and test / inspection results such as appearance, dimensions, various physical properties, and chemical components to the test processing system 16. In addition, the shipping department collects the steel materials so as to become the ordered product and ships the steel products to the customer.

When the steel material number and the test / inspection result are input, the test processing system 16 issues a test number and transfers the steel material number, the test number and the test / inspection result to the host computer 11 via the communication device 13. . The host computer 11 registers the transferred test number and test inspection result in the material test DB 12-3 by creating a record for each test number. Then, the host computer 11 executes the production management DB based on the steel material number.
12-2 is searched, and the test number is registered in the record of the steel material number.

The host computer 11 has a material test DB
When the test and inspection results are registered in 12-3, the creation of mill sheet specification data is started. That is, the host computer 11 first stores a storage area for temporary specification data (temporary specification data storage area) in a storage unit (not shown) and a storage area for specification data of description items to be described in the mill sheet ( (Specification data storage area) is secured. The host computer 11
The production management DB 12-2 is searched based on the steel number, and the contract number and the test number corresponding to the steel number are acquired. Next, the host computer 11 searches the material test DB 12-3 based on the obtained test number, obtains a test inspection result of the steel material corresponding to the test number, and stores it in the temporary specification data storage area. I do.

Next, the host computer 11 searches the order management master DB 12-1 based on the acquired contract number, and acquires a standard code and a specification number. next,
The host computer 11 searches the standard master DB 12-4 based on the obtained standard code, and obtains the description item of the mill sheet corresponding to the standard code. Next, the host computer 11 according to the acquired description items,
Data is extracted from each data of the test inspection result stored in the temporary specification data storage area. The host computer 11 stores the extracted data in the specification data storage area.

Next, the host computer 11 searches the customer specification master DB 12-5 based on the obtained specification number, and obtains the description item of the mill sheet corresponding to the specification number. Next, the host computer 11 extracts data from the data of the test and inspection results stored in the temporary specification data storage area according to the acquired description items, and adds and stores the extracted data to the specification data storage area. Alternatively, the host computer 11 deletes unnecessary data according to the description items obtained from the data stored in the specification data recording area.

Thus, the host computer 11
Creates mill sheet specification data in the specification data storage area of the storage unit, which includes description items that meet specifications and customer requirements. Then, the host computer 11 transfers the mill sheet specification data to the web server 21.

In the above-described embodiment, the steel material number is issued by the manufacturing processing system 15 and the test number is issued by the test processing system 16. However, when the order information is input, the order processing system is issued. 14 may issue the steel number and the test number. In this case, the order processing system 14 transfers the issued contract number, steel material number, and test number to the host computer 11 via the communication device 13. The host computer 11 creates a record for each contract number and registers order information in the order management master DB 12-1, and creates a record for each steel material number to store the steel material number and test number in the production management DB1.
In 2-2, a record is created for each test number, and the test number is registered in the material test DB 12-3. Then, the host computer 11 notifies the manufacturing processing system 15 of the contract number and the steel material number and the steel material number and the test number to the test processing system 16 via the communication device 13, respectively.

In the above-described embodiment, the mill sheet specification data is created when the data of the test / inspection result is transferred from the test processing system 16 to the host computer 11. There is no limitation, and any time after the results of the test and inspection are available. For example, a terminal device connected to the host computer 11 via the communication device 13 is further installed in the shipping department, and the shipping department notifies the host computer 11 that the product has been shipped using the terminal device after shipping the product. The host computer 11 may generate the mill sheet specification data upon receiving the notification.

In the above-described embodiment, the created mill sheet specification data is transferred to the web server 21 so that the mill sheet specification data is not stored in the mill sheet search system 100. A database for the mill sheet specification data to be registered is further constructed, and the host computer 11 may transfer the created mill sheet specification data to the web server 21 and register the mill sheet specification data in the database for the mill sheet specification data. .

(Configuration of External Retrieval System) To summarize the external retrieval system 102, the web server 21 notifies the customer terminal 22 connected via the communication line 23 of the completion of the mill sheet, In accordance with the mill sheet search request from the customer, the user is permitted or rejected to log in, and the mill sheet data is searched and transmitted. In addition, 3
Search and send to the next company. Hereinafter, this will be described in more detail.

In FIG. 1, a web server 21 is connected to one or a plurality of customer terminals 22 via a communication line 23, and exchanges information with the customer terminals 22 via a communication line 23.

FIG. 2 is a block diagram showing the configuration of the web server 21.

In FIG. 2, the web server 21 has a DB
31, a CPU 32, a communication interface 33, an external input / output device 34, an output device 35, a memory 36, an input device 37, and a bus 38.

The DB 31 is an auxiliary storage device, and is a customer management master database (hereinafter, “customer management master DB”).
Abbreviated. ) 31-1, a mill sheet specification data database (hereinafter abbreviated as "mill sheet specification data DB") 31-2 and a mill sheet form image data database (hereinafter, a mill sheet form image data DB). ) 31-3.

The customer management master DB 31-1 is a database for managing information on customers of the secondary company. The fields are customer code, ID (Identificatio
n), a password, an e-mail address, etc., and a record is created for each ID. The ID is a code (identifier) for identifying a client that can use the mill sheet search system 100. By managing clients accessing the web server 21 by IDs separately from customer codes, a plurality of rights to use the mill sheet search system 100 can be given to one secondary company. Further, since it is not necessary to disclose the customer code to the secondary company, even if the secondary company accesses the mill sheet specification data DB 31-2, it is difficult to extract mill sheet specification data relating to itself.
The direct use of the mill sheet specification data DB 31-2 can be suppressed. Note that the customer code may also serve as the ID.

The mill sheet specification data DB 31-2 is a database for managing mill sheet specification data created and transferred by the creation system 101. The fields are the steel material number and the description items of the mill sheet, for example,
Folder information, form title, customer code, type code, test / inspection information, number of pages, date and time of creation, etc., and the record is created for each steel material number.

Mill sheet form image data DB3
1-3 is a database for managing information indicating the correspondence between the type code and the mill sheet paper data. The fields are a product code and mill sheet paper data, and a record is created for each product code. The mill sheet paper data is obtained by converting mill sheet paper before describing the specifications of the mill sheet into image data. Specifically, for example, when the type of steel material is a thick plate, the mill sheet paper is the paper shown in FIG. 3, and the mill sheet paper data of the thick plate is obtained by converting FIG. 3 into image data. It should be noted that the mill sheet shown in FIG. 4 may be designated by a customer even if the type of steel material is the same thick plate. In this case, even if the product code of the same thick plate is
And a product code corresponding to FIG. 4 must be prepared. When the type of steel material is a wire, the mill sheet paper is the paper shown in FIG. 5, and the mill sheet paper data of the wire is the image data of FIG. When the type of steel material is hot rolled thin sheet, the mill sheet paper is the paper shown in FIG. 6, and the mill sheet paper data of hot rolled thin sheet is obtained by converting FIG. 6 into image data. When the type of steel is cold rolled thin sheet, the mill sheet paper is the paper shown in FIG.
Is converted into image data. The data conversion of the mill sheet paper is performed by, for example, reading the mill sheet paper with an image reading device such as an image scanner. Here, the mill sheet paper shown in FIGS. 3 to 7 is an example of each type, and the mill sheet paper shown in FIG. 5 is an example in which numerical values based on test results are also entered. That is, in the column for entering chemical components, 1 is assigned to C (carbon), 1 is assigned to Si (silicon), and Mn (manganese) is assigned.
20 for P, 10 for P (phosphorus), 7 for S (sulfur), C
1 for u (copper), 1 for Ni (nickel), and Cr
(Chrome) is marked with 3 respectively.

As can be seen from FIGS. 3 to 7, the mill sheet paper data is composed of a first part (for example, 5 in FIG. 3) composed of each column of the mill sheet paper and a description of each column.
This is image data of 1) and a second part (for example, 52 in FIG. 3) composed of a sign and a red seal of a person in charge of testing and inspecting the steel material. In the present embodiment, since the first part and the second part are integrated image data, if at least one of the mill sheet paper and the person responsible for the test and inspection is changed, the mill sheet form image is changed. It is necessary to update the entire data DB 31-3. Therefore, the mill sheet form image data DB 31-3 is created by dividing the first part and the second part.
In this case, mill sheet form image data DB
Reference numeral 31-3 denotes a database for managing information indicating the correspondence between the product code and the data of the first part of the mill sheet paper, and the data of the second part of the mill sheet paper is DB31.
Alternatively, it is stored in the memory 36 or the like. As a result, only the changed portion needs to be updated, and the time and effort for updating can be further reduced.

The CPU 32 cooperates with a control unit (not shown in FIG. 2) for controlling each unit of the web server 21 and a control unit for controlling the communication interface 33 via the communication line 23 and the customer terminal 22. Transfer receiving section 32-1 for exchanging information with the information transfer section 32-1, an information analyzing section 32-2 for analyzing the contents of the information transfer receiving section 32-1, and each DB 31 based on the analysis result analyzed by the information analyzing section 32-2. -1 to 31-4
Database operation unit (hereinafter, “DB operation unit”) that operates
Abbreviated. 32-3) A synthesizing unit 32-3 that creates millsheet data from millsheet specification data and millsheet form image data based on the analysis result analyzed by the information analysis unit 32-2 and the output of the DB operation unit 32-3.
4 and an e-mail creating unit 3 for creating an e-mail
2-5 and the like. The DB operation unit 32-3 creates a record in the DB when registering new data and registers the data in each field, a search unit that searches the DB based on search information, and a search. And an acquisition unit for acquiring each data registered in each field from the record searched by the unit.

The communication interface 33 is a device for converting data containing information in accordance with a communication protocol so that information can be exchanged between the web server 21 and the host computer 11 or the customer terminal 22. Yes, for example, modem and DSU / TA (Digital Service U)
nit / Terminal Adapter).

The external input / output device 34 is an external auxiliary storage device for recording a program executed by the CPU 32, data processed by the CPU 32, and the like. For example, a floppy (registered trademark) disk drive device, a CD-ROM (Co
mpact Disc Read Only Memory), CD-R (Compact D)
isc Recordable), CD-RW (Compact Disc ReWrita)
ble), DVD-RAM (Digital Versatile Disc Rand)
The drive device handles an optical storage medium such as an om Access Memory (MO) and a magneto-optic (MO).

The output device 35 is an output device for displaying or printing the result of processing the information by the web server 21.
For example, a cathode ray tube (CRT) display, an LCD (liquid crystal display), an organic EL (organic photoluminescence) display, a printer, and the like.

The memory 36 is a semiconductor memory for storing various programs, various data, and the like.
nly Memory) and RAM (Random Access Memory). The various programs are, for example, an execution program executed by the CPU 32 and a synthesis program.
This synthesizing program is a program for synthesizing mill sheet specification data and mill sheet form image data, and is programmed by a well-known method of synthesizing numerical value / text data and image data. The input device 37 is a device that inputs data, instructions, and the like to the web server 21, and is, for example, a keyboard, a mouse, and a trackpad. These DB31, CPU
32, communication interface 33, external input / output device 3
4. The output device 35, the memory 36 and the input device 37
Mutually connected via a bus 38, a DB31 communication interface 33, an external input / output device 34, an output device 35,
The operations of the memory 36 and the input device 37 are controlled by the CPU 32. The communication line 23 is a communication network using a switched line such as a telephone line and a digital line or a dedicated line.

FIG. 8 is a block diagram showing the configuration of the customer terminal.

In FIG. 8, a customer terminal 22 includes a hard disk 41, a CPU 42, a communication interface 4
3, external input / output device 44, display device 45, printing device 4
6, an input device 47, a memory 48, and a bus 49. Communication interface 43, external input / output device 44, input device 47, memory 48, and bus 49
Is the communication interface 3 described with reference to FIG.
3, the external input / output device 34, the input device 37, the memory 36, and the bus 38 are the same as those described above, and the description thereof is omitted.

The hard disk 41 is an auxiliary storage device for recording programs executed by the CPU 42, data processed by the CPU 42, and the like. The program is, for example, O
Examples include S (operating system) and browser (browser). The display device 45 is a display device that displays data transferred from the web server 21 and data processed by the CPU 42, and is, for example, the above-described CRT (cathode ray tube) display. The printing device 46 is a web server 2
1 and the data processed by the CPU 42, especially the mill sheet. Here, the communication line 23
Are temporarily stored in the memory 48 or the hard disk 41.

The CPU 42 cooperates with a control unit (not shown in FIG. 8) for controlling each unit of the customer terminal 22 and a control unit for controlling the communication interface 43.
Information transfer receiving unit 42-1 for exchanging information with the web server 21 via the Internet, and the information transfer receiving unit 42-1
And an information analysis unit 42-2 for analyzing the contents of the information.

(Operation of External Search System) FIG. 9 is a flowchart (part 1) showing the operation of the external search system. FIG. 10 is a flowchart (part 2) illustrating the operation of the external search system.

Here, the web server 21 and the customer terminal 22
Means that the data to be exchanged is converted using the information transfer receiving units 32-1 and 42-1 and the communication interfaces 33 and 43 according to the communication protocol, and the data is exchanged between the two via the communication line 23. In the following description, the description of this process will be omitted.

9 and 10, when the CPU 32 of the web server 21 receives the mill sheet specification data from the host computer 11 using the information transfer receiving unit 32-1 or the like, it uses the DB operation unit 32-3 or the like. And the mill sheet specification data into the mill sheet specification data DB 31-
2 (S11W). At this time, the CPU 32
The date and time when the mill sheet specification data is received is acquired from a calendar and a clock built in the OS or the like, and registered in the creation date and time of the mill sheet specification data DB 31-2. Then, the CPU 32 extracts the customer code, the contract number, and the steel material number from the mill sheet specification data by using the DB operation unit 32-3 and the like, and searches the customer management master DB 31-1 based on the customer code, and The e-mail address corresponding to the customer code is acquired by using the e-mail creating unit 32-5 or the like. The CPU 32 creates an e-mail notifying that the mill sheet with the contract number has been created, and sends it to the acquired e-mail address (S12W). The customer terminal 22 is connected to the information transfer receiving unit 4
The e-mail is received using 2-1 or the like (S1).
01C). By reading this e-mail, the customer of the secondary company can know that the mill sheet of the contract number has been created.

On the other hand, when the customer of the secondary company needs the mill sheet, it starts up the browser (browser) installed in the terminal device 22 and the URL (Uniform Resource Loc) of the mill sheet search site providing this service.
ator) (S102C). CP of customer terminal 22
CPU of web server 21 accessed from U42
32 transfers the data to the customer terminal 22 using the information transfer receiving unit 32-1 or the like, for example, displays an initial screen as shown in FIG. 11, and requests input of the user ID and password (S13W ). As shown in FIG. 11, the initial screen is "W" indicating that the site is a mill sheet search site.
elcome! Welcome to Kobe Steel Mill Sheet Delivery System! "And a window portion 62 for prompting login. The window part 62 includes a user ID input part 63 for inputting a user ID.
And a password input part 64 for inputting a password;
The system is provided with a button of “Execute” 65 for causing the CPU 42 to transmit each of these data to the web server 21 after the input, and a button of “Cancel” 66 for canceling the input data when the input is incorrect after the input. Is done.

The customer inputs the user ID and the password using the input device 47 such as a keyboard, and clicks “execute”.
An instruction is given to the CPU 42 by clicking a button 65 using the input device 47 such as a mouse. Also, customers
If you enter a wrong user ID or password,
By clicking the “cancel” button 66 using the input device 47 such as a mouse, the CPU 42 is instructed. CPU
When the content of the instruction is "cancel", the user 42 blanks out the user ID input portion 63 and the password input portion 64 and waits for these inputs again. On the other hand, the CPU 42
When the content of the instruction is executed using the information transfer receiving unit 42-1 or the like, the user ID and the password are transferred to the web server 21 (S103C).

The CPU 32 of the web server 21 uses the information transfer receiving unit 32-1, the information analyzing unit 32-2, the DB operating unit 32-3, and the like to store the customer management master DB 31-1 based on the received user ID. Search and get customer code and password. The CPU 32 is a client terminal 2
2 and the password received from customer management master DB 31-
It is determined whether or not the password obtained from No. 1 matches (S14W). If the passwords do not match, the CPU 32 determines that the user is an unauthorized access person without the right to use the system, and returns the process to S13W to display the initial screen again on the customer terminal 22. On the other hand, if the two passwords match, the CPU 32
It is determined that the customer is a legitimate customer who has a right to use this system, and login is permitted (S15W).

The CPU 32 of the web server 21 searches the mill sheet specification data DB 31-2 based on the customer code obtained in S14W using the DB operation unit 32-3 or the like, and reads the mill sheet specification corresponding to the customer code. Get the data. The CPU 32 displays the folder structure and the list of the mill sheet corresponding to the customer on the customer terminal 22 using the information transfer receiving unit 32-1 or the like.
A part of the mill sheet specification data that can specify the mill sheet is transferred. By transferring only a part, the data capacity to be transferred can be reduced. For example, the CPU 32 determines, among the mill sheet specification data,
The folder information, the form title, the creation date and time, and the steel material number are extracted from the mill sheet specification data and are transferred to the customer terminal 22 (S16W).

The CPU 42 of the customer terminal 22 uses the information transfer receiving section 42-1 and the information analyzing section 42-2 to
A part of the received mill sheet specification data is displayed on the display device 45 as a created mill sheet list.
For example, as shown in FIG. 12, the CPU 42 creates a folder display 70 that displays the folder structure in a tree structure based on the folder information and a creation display that displays a serial number, a form title, the number of pages, a creation date, and a creation time in a list format. The completed mill sheet list 71 is displayed.

Displayed Mill Sheet List 71 Displayed
When a search for a mill sheet is performed to obtain a desired mill sheet from the customer, the customer uses the input device 47 of the customer terminal 22 to input that the search is to be performed.

In the present embodiment, the search can be performed in any of the inside-form search and the cell search mode. Further, in each search mode, any of a folder search in which a search is performed only in a folder (directory) and a total search in which a search is performed in all mill sheets can be designated as a search range. Here, the search within the form is performed by the customer terminal 2
In each of the mill sheets in the prepared mill sheet list 71 displayed in FIG. 2, a search is performed to determine whether or not there is data matching the search word in all fields of the mill sheet specification data DB 31-2. A mill sheet having matching data is set as a search result. In the cell search, in each mill sheet of the created mill sheet list 71 displayed on the customer terminal 22, a search is performed to determine whether there is data matching a search word for a specific field of the mill sheet specification data DB 31-2, A mill sheet having data matching the search word in this specific field is set as a search result. The specific field is designated by the customer using the input device 47 of the customer terminal 22. In the folder, the mill sheets are classified and stored on the basis of certain conditions, for example, on the basis of a steel material manufacturing base or a test / inspection place for each customer. In this embodiment, the folder is created for each of the manufacturing bases in Kakogawa and Kobe for each customer, and the mill sheet is used when the original mill sheet specification data is registered in the mill sheet specification data DB 31-2.
For example, by referring to a customer code or a form title, the CPU 32 is classified into either Kakogawa or Kobe for each customer.

Using the input device 47 of the customer terminal 22, the customer first determines whether to perform a form search or a cell search, and then determines whether to perform a folder search or a full search. Next, a search word is input together with search conditions.
At this time, the CPU 42 determines whether the customer input is a form search or a cell search, respectively. Is determined (S105C), and is it folder search or full search? Is determined (S106C), and information relating to the search of these, the search word and the search condition is transferred to the web server 21 (S107C).
Thus, a desired mill sheet is searched.

First, the case where the customer performs a search in a form will be described in more detail. When the customer performs a full search in the form search, for example, as shown in FIG. 12, the customer uses the input device 47 such as a mouse to display a “folder screen (F)” pull-down menu on the toolbar. .
The pull-down menu of “Folder screen (F)” is “Folder update (R)” instructing the update of the folder.
And a "full-text search (S)" for instructing a form search and an "item search (K)" for instructing a cell search. Then, the customer selects “full-text search (S)” using the input device 47 and displays a pull-down menu of “full-text search (S)”. The pull-down menu of "full text search (S)" includes "only that folder (C)" for instructing folder search and "all (A)" for instructing full search.
And is provided. The customer further inputs the input device 47
To select "All (A) below". In this way, the customer uses the input device 47 to input to the customer terminal 22 that a full search is to be performed in the form search.

When input, the CPU 42 of the customer terminal 22
Determines the contents of each input (S105C, S106
C) In the above-described example, the search word input screen 7 in the form for inputting a search word when performing a full search in the form search
2 is displayed on the display device 45. Note that the CPU 42 of the customer terminal 22 transfers to the web server 21 a message indicating that the search is to be performed, and in the above example, a search in the form is to be entirely performed. When the CPU 32 of the web server 21 receives that all searches are performed in the form search, the CPU 32 inputs the search word to the customer terminal 22.
Then, the data is transferred to the customer terminal 22 in order to obtain the search word, and a form search word input screen 72 for inputting a search word when performing a full search in the form search is displayed on the customer terminal 22. Thus, the search word input screen may be displayed on the customer terminal 22 by the web server 21.

FIG. 13 is a diagram showing an example of a form search word input screen.

In FIG. 13, in this embodiment, the form search word input screen 72 includes a search character string input field 81, a search condition specification field 82, a “clear condition” 83, and a “search” 8
4. “Cancel” 85 and search word type selection field 86
It comprises. The search character string input field 81 includes a plurality of input fields (four in this embodiment) so that a plurality of search words can be input, and a search character string serving as a search word is input. The search condition specification field 82 is an input field for specifying a search condition for each search character string. In the present embodiment, an “AND condition” for specifying that each search word is searched by an AND condition, An "OR condition" that specifies that a word is searched with an OR condition,
"Case-sensitivity" for specifying whether or not the search word is case-sensitive. "Clear condition" 83 is a button for instructing whether or not to return the search character string input field 81 to the non-input state. “Search” 84 is a button for instructing execution of a search based on the input search character string and search conditions. “Cancel” 85 is a button for instructing to stop the execution of the search. The search word type selection column 86 includes a character string search 86-1 using a search word as a character string, a numerical search 86-2 using a search word as a numerical value, and other 86-3 using a search word other than this. It is composed.

The customer selects a search word type using the input device 47 such as a keyboard or a mouse, and inputs a search word and a search condition. Then, the customer selects “search” 8
The user instructs CPU 42 by clicking button 4 using input device 47 such as a mouse. In order to stop the search, the customer clicks the “cancel” 85 button to instruct the CPU 42. In addition, if the customer enters a search word or makes a mistake in the search condition, the customer can click "Clear the condition".
The user instructs the CPU 42 by clicking the button 83. C
When the contents of the instruction are clear of the condition, the PU 42 blanks the search character string input field 81 and the search condition specification field 82 and waits for these inputs again. On the other hand, the CPU 42
Using the information transfer receiving unit 42-1 or the like, if the content of the instruction is a cancellation, the fact is indicated. Transfer to the server 21 (S107
C). Here, in the example of FIG. 13, the search range is all searches within the form, the search word type is a character string, and the search word is KC.
H and a case where the case of the AND condition is not distinguished. Of course, if there is only one search word, A
Specifying the ND condition is substantially meaningless in the search.

The CPU 32 of the web server 21 uses the information transfer receiving unit 32-1 and the information analyzing unit 32-2 to transfer the data if the received content is cancelled, and displays the created mill sheet list. If the received content is a search, the mill sheet specification data D is displayed on the basis of the specified search range, search word type, search word, and search condition using the DB operation unit 32-3 or the like.
All fields are searched for each record of B31-2 (S17W).

In the present embodiment, the mill sheet is not directly converted into image data by the image reading device and registered in the DB, but the mill sheet is divided into a style part common to each mill sheet and a specification part different for each mill sheet. Since the image data and the text data are respectively registered in the mill sheet form image data DB 31-3 and the mill sheet specification data DB 31-2, the search word type specified using the mill sheet specification data DB 31-2 which is text data. , A mill sheet that matches the search word and the search condition can be easily searched.

The CPU 32 stores the search result in the customer terminal 2
2 and display (S18W). The CPU 42 of the customer terminal 22 displays the received search result (S108).
C).

FIG. 14 is a diagram showing an example of a search result display screen.

In FIG. 14, in the present embodiment, the search result includes a list part 73 of the search result and a mill sheet display part 74. Search result list display part 7
Reference numeral 3 denotes a part of the mill sheet specification data of the searched mill sheet that can specify the mill sheet. For example, the form title, the number of pages, and the number of items in the mill sheet specification data are displayed. The mill sheet display portion 74 displays mill sheet specification data more detailed than the list display. In the present embodiment, for example, the product type, steel material number (steel number), dimensions, delivery state, and quantity of the mill sheet specification data are displayed. Of course, even more data may be displayed, or the mill sheet itself may be displayed. Further, from the viewpoint of clearly indicating the word in the mill sheet that matches the search word, the matching word may be emphasized by, for example, coloring or inverting the word. The search result list display portion 73 and the mill sheet display portion 74 have scroll bars for scrolling the data to be displayed.

Here, when displaying the mill sheet itself, the CPU 32 synthesizes the mill sheet form image data and the mill sheet specification data by the synthesizing unit 32-4 using the synthesizing program, and retrieves and displays the mill sheet to be displayed. Create mill sheet data for And
The CPU 32 uses the information transfer receiving unit 32-1 or the like to
The created mill sheet data is transferred to the customer terminal 22.
Further, when the customer wants to print the displayed mill sheet, he or she clicks “Print” (not shown in FIG. 13) from the “Operation” pull-down menu of the toolbar using the input device 47 such as a mouse. Then, the client terminal 22 is requested to print. Upon receiving a print request, the CPU 42
Executes printing. In this way, a customer using the mill sheet search system according to the present embodiment can not only search for a desired mill sheet, but also obtain a mill sheet printed on a paper medium.

On the other hand, when the customer performs a folder search by searching in a form, for example, first, in FIG. 12, a desired folder is designated by the input device 47 such as a mouse from a plurality of folders displayed in the folder display 70. I do. Then, the customer displays a pull-down menu of “Folder screen (F)” on the toolbar, selects “Full-text search (S)”, and further, selects “Only that folder ( C) ". Hereinafter, as described with reference to FIG.
A search may be performed by designating a search word and search conditions.

Next, a case where the customer performs a cell search will be described in more detail. When the customer performs a full search by cell search, for example, in FIG. 12, the customer uses the input device 47 such as a mouse to display a pull-down menu of “Folder screen (F)” on the toolbar, and performs “item search”. (K) ", and further," All (A) "is selected from the pull-down menu of" Full text search (S) ". As described above, the customer uses the input device 47 to input to the customer terminal 22 that a full search is to be performed by cell search.

When input, the CPU 42 of the customer terminal 22
Determines the contents of each input (S105C, S106
C) In this example, a cell search word input screen 75 for inputting a search word when performing a full search in the cell search is displayed on the display device 45. The CPU of the customer terminal 22
Reference numeral 42 indicates to the web server 21 that a search is to be performed, in this example, a full search is to be performed by cell search. When the CPU 32 of the web server 21 receives that the full search is performed in the cell search, the CPU 32 transfers the data to the customer terminal 22 in order to request the customer terminal 22 to input a search word, and performs a full search in the cell search. A cell search word input screen 75 for inputting a search word is displayed on the customer terminal 22. Thus, the search word input screen may be displayed on the customer terminal 22 by the web server 21.

FIG. 15 is a diagram showing an example of a cell search word input screen.

In FIG. 15, in this embodiment, the cell search word input screen 75 includes a search character string input field 81, a search condition specification field 82 ', a "clear condition" 83, and a "search" 8
4 and a "cancel" 85, a field item selection field 87, an item condition specification field 88, and a search result display method specification field 89 are provided. Field item selection field 87
Is a field for designating a field to be searched, and includes fields for output, field name, attribute, type, and search character string. A plurality of fields to be searched can be specified. The item condition specification column 88 is a column for specifying a combination condition of each field when a plurality of fields are specified, and can specify an AND condition or an OR condition. The search result display method specification column 89 is a column for specifying whether or not to display the search results by name identification. The search condition specification column 82 'includes "blank cells" to be specified when searching for an item having no character string, in addition to "AND conditions", "OR conditions", and "case identification".

The customer designates one or more desired fields from a plurality of fields displayed in the field item selection field 87 using the input device 47 such as a keyboard and a mouse. A search word and a search condition are input in the condition specification field 82 '. Here, when a search word is input in the search character string input field 81, the search word is also displayed in the search character string field in the field item selection field 87. To specify a plurality of fields, such field specification, search word input, and search condition input are repeated. When the customer specifies a plurality of fields, the customer specifies the relationship between the fields using the item condition specification column 88. Further, when it is desired to display the search result in the name identification display, the search result is specified using the search result display method specification column 89. The customer can click "Search"
An instruction is given to the CPU 42 by clicking the button 84 using the input device 47 such as a mouse.

When the customer wants to cancel the search, he clicks the "cancel" button 85 and instructs the CPU 42. Further, when the customer inputs a search word or makes a mistake in a search condition, the customer clicks a “clear condition” 83 button to instruct the CPU 42. When the content of the instruction is that the condition is clear, the CPU 42 determines whether the search character string
1 and the search condition specification field 82 are blank, and the system waits for these inputs again. On the other hand, the CPU 42 determines whether the information transfer
If the content of the instruction is cancelled, the effect is indicated, and if the content of the instruction is a search, the search range, target field, search word, search condition, item combination condition, and search result display method are used. The data is transferred to the web server 21 (S107C). Here, in the example of FIG. 15, the search range is all cell search, the search target field is the type, the search word is KCH, the search condition is the AND condition, the item combination condition is the AND condition, and the search result display method is the name identification. This is the case where the display is not displayed.

The CPU 32 of the web server 21 uses the information transfer receiving unit 32-1 and the information analyzing unit 32-2 to transfer the data if the received content is canceled, and to display the created mill sheet list. If the received content is a search, the records of the mill sheet specification data DB 31-2 are displayed on the basis of the specified search word, search condition, and item combination condition using the DB operation unit 32-3 or the like. Is searched for the designated field (S17W).

In the present embodiment, the mill sheet is not converted into image data by the image reading apparatus as it is and registered in the DB.
Since it is registered in 1-2, when a certain specification of the mill sheet is to be searched, it can be easily specified and searched.

The CPU 32 stores the search result in the customer terminal 2
2 and display (S18W). The CPU 42 of the customer terminal 22 displays the received search result (S109)
C). For example, as shown in FIG. 16, the search results are displayed as a list in the search result list portion 73, and the mill sheet is displayed in the mill sheet display portion 74.

On the other hand, when the customer performs a folder search by cell search, for example, first, in FIG. 12, a desired folder is designated from the plurality of folders displayed on the folder display 70 with the input device 47 such as a mouse. . Then, the customer displays a pull-down menu of “Folder screen (F)” on the toolbar, selects “Cell search (S)”, and further, selects “Only that folder () from the pull-down menu of“ Cell search (S) ”. C) ". Hereinafter, as described with reference to FIG. 15, a search may be performed by designating a search target field, a search word, a search condition, an item combination condition, and a search result display method.

In S18W of the above-described embodiment, the CPU 32 of the web server 21 sends the retrieval result to the customer terminal 22 in a data format that can be handled by spreadsheet software, for example, CSV (Comma Separated Valuable).
e) The data may be transferred in a format or a SYLK (Symbolic Link file) format. By transferring the search results in such a data format, the customer terminal 22 can display the search results using general spreadsheet software, for example, as shown in FIG. Various data processing such as graphing can be easily performed.

In the above-described embodiment, the host computer 11 creates the mill sheet specification data and transfers it to the web server 21. The data, that is, each data stored in the temporary specification data storage area is transferred to the web server 21 as original mill sheet specification data, and the web server 21 converts the original mill sheet specification data into mill sheet specifications according to the standard and the customer. Original data may be created. With this configuration, each data of the original mill sheet specification data can be left in the DB 12 of the creation system.

In the above-described embodiment, the web server 21 combines the mill sheet specification data and the mill sheet form image data with the combining program, and transfers the mill sheet data to the customer terminal 22.
Transfers the mill sheet specification data, the mill sheet form image data, and the combining program to the customer terminal 22 so that the customer terminal 22 combines the mill sheet specification data and the mill sheet form image data by the combining unit 42-3 using the combining program. You may. Particularly in this case, the mill sheet form image data and the synthesizing program are transmitted from the web server 21 to the customer terminal 22.
It is preferable to transfer the information only once. In this way, when the customer searches a plurality of times during one access, the web server 21 transfers the mill sheet form image data having a large data capacity and the synthesizing program each time the search result is transferred to the customer terminal 22. Since there is no need and only the transfer of the mill sheet specification data having a small data capacity is required, the response speed of the search result can be increased. In such a case, the mill sheet form image data and the synthesizing program are required at the time of synthesizing.
The transfer may be performed before the transfer to 2. For example, these are transferred in S13W or S16W. The mill sheet form image data is 1
Mill sheet form image data of all types may be transferred each time, or may be transferred as needed.

In the case of transferring data whenever necessary, for example, a product code, a transferred flag indicating whether or not the data has been transferred, and an identifier for identifying the customer terminal 22 (for example, the IP address of the customer terminal 22) are provided. The prepared form transferred correspondence table is prepared in the memory 36. The CPU 32 determines whether or not the acquired mill sheet form image data has been transferred to the customer terminal 22 by referring to the form transfer correspondence table. CPU32
Determines that the acquired mill sheet form image data is discarded if it has been transferred, and changes the transferred flag to transferred if it has not been transferred.

Finally, an embodiment will be described in which the present embodiment is modified so that a tertiary company can search for a mill sheet in the mill sheet search system of the above-described embodiment.

When a tertiary company (including government offices) can also search for a mill sheet, a tertiary customer management database (hereinafter, referred to as a “tertiary customer management DB”) that manages a tertiary company that permits mill sheet search is provided. 31-4).
Is further provided in the DB 31 of the web server 21. Fields of the tertiary customer management DB include an ID, a password, a secondary customer code, a tertiary customer code, and a steel material number array.
A record is created for each ID. Third customer management DB
The ID of 31-4 is the ID of the tertiary company, and the password of the tertiary customer management DB is the password of the tertiary company.
The secondary customer code is a customer code of the secondary company that has permitted the tertiary company to search and distribute the mill sheet, and is the customer code in the customer management master DB 31-1 described above. The tertiary customer code is a tertiary company customer code. The correspondence between the secondary company and the tertiary company is clarified by the secondary customer code and the tertiary customer code. The steel material number sequence is
This is a set of steel sheet numbers of the mill sheets that the sub-company has permitted the tertiary company to search and distribute. Here, the third customer management DB
May be registered / updated by the primary company in accordance with the request of the secondary company, or may be performed by the secondary company via the customer terminal 22 and the communication line 23.

A storage area for storing the tertiary customer flag table is provided in the memory 36. The tertiary customer flag table is a flag indicating whether or not the customer terminal 22 accessing the mill sheet search site is a tertiary company,
An area for storing information (for example, an IP address) specifying the customer terminal 22, an area for storing a flag indicating whether or not the customer is a tertiary company, an area for storing a secondary customer code, and an area for storing a steel material number array Is provided.

Such a tertiary customer management DB and a tertiary customer flag table are provided in the web server 21, and the CPU 32 of the web server 21 operates as follows in the operations shown in FIGS. 9 and 10. Good.

That is, in S14W, the CPU 32
Is the customer management master DB based on the received user ID
In addition to searching for 31-1, it also searches the tertiary customer management DB to obtain a customer code and password. Then, the CPU 32 compares the password received from the customer terminal 22 with the customer management master DB 31-1 or the tertiary customer management D
It is determined whether the password acquired from B31-4 matches.

In S15W, if the passwords do not match, the CPU 32 determines that the user is an unauthorized access person who does not have the right to use the system, and displays the initial screen again on the customer terminal 22. Processing is S1
Return to 3W. On the other hand, if the two passwords match, the CPU 32 determines that the customer is a legitimate customer who has a right to use this system, and permits login. Further, the customer code and password are stored in the tertiary customer management DB 31-4.
, The secondary customer code and the steel material number array are also acquired from the tertiary customer management DB 31-4, and the tertiary customer flag table indicates the information for specifying the customer terminal 22 and indicates the tertiary company. The flag, the secondary customer code, and the steel material number array are stored.

Then, in S16W, the CPU 32
First, it is determined whether or not the accessing customer terminal 22 is a tertiary company by referring to the tertiary customer flag table based on the information specifying the customer terminal 22.
If the result of the determination is that the company is not a tertiary company, it is determined that the company is a secondary company, and the operation is performed as described above. On the other hand, in the case of a tertiary company, the mill sheet specification data DB 31-2 is searched based on the steel number sequence to obtain the original mill sheet specification data corresponding to the steel number. CPU32
In order to display the acquired list of mill sheets on the customer terminal 22, a part of the mill sheet specification data capable of specifying the mill sheet is transferred.

At S17, the CPU 32 conducts a search in accordance with the information on the search transferred from the customer terminal 22 of the tertiary customer, taking the steel material number arrangement into consideration. S18W
When transferring mill sheet specification data at
The PU 32 creates mill sheet specification data according to the secondary customer code acquired in S16W.

In this way, the tertiary company can search for the mill sheet from the customer terminal 22 located in the tertiary company. And since the tertiary customer management DB 31-4 is provided, the mill sheet disclosed to the tertiary company can be restricted by the steel material number arrangement. For this reason,
The tertiary company is the primary company's business partner and transaction details and 2
Since it is not possible to browse the business partners and transaction contents of the secondary company, the trade secrets of the primary company and the secondary company can be protected.

[0110]

As described above, according to the present invention, the mill sheet is divided into the specification data including a plurality of specifications and the image data of the mill sheet paper, and the specification data is stored in the storage unit.
When the number of mill sheets increases, the specification data that differs for each mill sheet increases, but the image data does not increase because the same type of mill sheet uses the same paper. Further, the specification data has a relatively small data capacity. For this reason, the present invention can efficiently store the mill sheet in the storage unit with a smaller storage capacity than in the case where the mill sheet is directly stored as image data. Further, when searching for a desired mill sheet, it is possible to efficiently and easily search using specification data which is text data.

[Brief description of the drawings]

FIG. 1 is a block diagram schematically showing an overall configuration of a mill sheet search system according to the present invention.

FIG. 2 is a block diagram illustrating a configuration of a web server.

FIG. 3 is a diagram illustrating an example of a thick mill sheet sheet.

FIG. 4 is a diagram showing another example of a thick mill sheet paper.

FIG. 5 is a diagram showing an example of a mill sheet of wire.

FIG. 6 is a view showing an example of a hot-rolled mill sheet.

FIG. 7 is a diagram illustrating an example of a cold rolled mill sheet.

FIG. 8 is a block diagram illustrating a configuration of a customer terminal.

FIG. 9 is a flowchart (part 1) illustrating an operation of the external search system.

FIG. 10 is a flowchart (2) showing the operation of the external search system.

FIG. 11 is a diagram showing an example of an initial screen of the mill sheet delivery system.

FIG. 12 is a diagram showing an example of a screen for designating a search target and a search range.

FIG. 13 is a diagram showing an example of a search word input screen in a form.

FIG. 14 is a diagram illustrating an example of a search result display screen.

FIG. 15 is a diagram showing an example of a cell search word input screen.

FIG. 16 is a diagram illustrating another example of a search result display screen.

FIG. 17 is a diagram showing an example in which search results are displayed by spreadsheet software.

[Explanation of symbols]

11 Host Computer 12, 31 Database 12-1 Order Management Master Database 12-2 Production Management Database 12-3 Material Test Database 12-4 Standard Master Database 12-5 Customer Standard Master Database 13 Communication Device 14 Order Processing System 15 Manufacturing Processing System 16 Test Processing System 17 Terminal Device 21 Web Server 22 Customer Terminal 23 Communication Line 31-1 Customer Management Master Database 31-2 Mill Sheet Specification Data Database 31-3 Mill Sheet Form Image Data Database 31-4 Tertiary Customer Management Master Database 32, 42 Central Processing Units 32-1 and 42-1 Information Transfer Receiving Unit 32-2, 42-2 Information Analyzing Unit 32-3 Database Operating Unit 32-4, 42-3 Synthesizing Unit 32-5 E-mail Creating Unit 45 Display device 46 Printing device 63 User ID input portion 64 Password input portion 70 Folder display 71 Created mill sheet list table 72 Search word input screen in form 73 Search result list portion 74 Mill sheet display portion 75 Cell search word input screen 81 Search characters Column input field 82 Search condition specification field 83 "Clear condition" 84 "Search" 85 "Cancel" 86 Search word type selection field 87 Field item selection field 88 Item condition specification field 89 Search result display method specification field 100 Mill sheet search system 101 Creation system 102 Search system

   ────────────────────────────────────────────────── ─── Continuation of front page    (72) Inventor Yoshiyuki Nakatani             1 Kanazawacho, Kakogawa City, Hyogo Prefecture             Toko Works Kakogawa Works (72) Inventor Akito Azumi             1 Kanazawacho, Kakogawa City, Hyogo Prefecture             Toko Works Kakogawa Works F term (reference) 5B075 ND02 ND07 PQ32

Claims (9)

[Claims] 1. A mill sheet search apparatus for searching for a mill sheet based on search information from a terminal connected via a communication line, comprising: an information receiving means for receiving the search information via the communication line; Storage means for storing a plurality of the specification data for each of the specification data divided into a plurality of specification data and image data of mill sheet paper, and searching from the plurality of the specification data based on the search information. Searching means for extracting a mill sheet that matches the search information, obtaining means for obtaining specification data corresponding to the mill sheet extracted by the searching means, and obtaining the specification data obtained by the obtaining means. Transfer means for transferring the data to the terminal via a communication line. 2. The storage means stores a plurality of the image data, and further stores a synthesizing program for synthesizing the specification data and the image data. The mill sheet search device according to claim 1, wherein data, one or more of the image data, and the synthesizing program are transferred to the terminal. 3. The storage means stores a plurality of the image data, and further stores a synthesizing program for synthesizing the specification data and the image data. The search means stores the image data corresponding to the extracted mill sheet. A synthesizing unit for extracting mill data from the plurality of image data, and synthesizing the specification data obtained by the obtaining unit and the image data searched by the searching unit by the synthesizing program to create mill sheet data; 2. The apparatus according to claim 1, wherein the transfer unit transfers the mill sheet data created by the combining unit to the terminal.
The mill sheet search device according to 1. 4. The storage means associates a customer code which is a code for identifying a customer with an ID for identifying a user who has a right to use the mill sheet search device among the customers. A customer management database to be registered and mill sheet specifications that are registered by associating the mill data with the customer code by dividing the mill sheet into specification data including a plurality of specifications and image data of the mill sheet paper. And a customer code extracting unit for extracting a customer code from the customer management database based on an ID from the terminal. The search unit includes a mill sheet specification data database based on the search information. By searching for, the search is performed in the specification data including the customer code extracted by the customer code extraction means. Mill sheet search apparatus according to claim 1, characterized in that extracting the mill sheet matching the information. 5. An order management master database in which a contract number, a customer code, a standard code, a type code, and a specification number, which are codes for identifying a contract, a customer, a standard, a type, and a specification, respectively, are registered in association with each other. When,
A steel material number, which is a code for identifying a steel material, a test number, which is a code for identifying test inspection information that is a result of the test inspection of the steel material, and the contract number are registered in association with each other. A production management database, a material test database in which the test numbers and the test / inspection information are registered in association with each other, and a standard description item, which is a description item of a mill sheet according to the standard code and the standard, are mutually associated. And a customer specification database in which the specification number and the customer description items, which are the description items of the mill sheet according to the customer's request, are registered in association with each other. A second storage unit, searching the production management database based on the steel number, acquiring a contract number and a test number corresponding to the steel number, acquiring The material test database is searched based on the obtained test number to obtain test / inspection information corresponding to the test number, and the order management master database is searched based on the obtained contract number, and the standard corresponding to the contract number is obtained. A code and a specification number are obtained, the standard master database is searched based on the obtained standard code, a standard description item corresponding to the standard code is obtained, and the customer specification master database is searched based on the obtained specification number. Acquiring means for acquiring the customer-described item corresponding to the specification number, and creating means for creating specification data to be stored in the storage means from the acquired standard-described item and the test and inspection information acquired based on the customer-described item The mill sheet searching device according to claim 1, further comprising: 6. The customer management database further registers the contact information of the customer in association with the customer code, and when new specification data is registered in the mill sheet specification database, the new specification Contact point acquisition means for searching the customer management database based on the customer code in the original data to acquire the contact information of the customer corresponding to the customer code; and the new specification data for the acquired contact information of the customer. The mill sheet searching device according to claim 4, further comprising a notification unit that notifies that the mill sheet has been created. 7. The storage means includes a tertiary customer code that is a code for identifying a tertiary company that is a customer of the customer, and a user that has a right to use the mill sheet search device. Further storing a tertiary customer management database in which the ID of the tertiary company, the customer code, and disclosure information specifying a mill sheet that can be disclosed to the tertiary company are registered in association with each other; The mill sheet search device according to claim 4, wherein the mill sheet further extracts the mill sheet based on disclosure information of the tertiary customer management database. 8. The mill sheet search device according to claim 7, wherein the tertiary customer management database is further operable from a terminal located at the customer. 9. A mill sheet retrieving apparatus, comprising: a mill sheet retrieving apparatus including a storage unit for dividing a mill sheet into specification data including a plurality of specifications and image data of a mill sheet sheet and storing the specification data, connected via a communication line. A mill sheet search method for searching for a mill sheet based on search information from a terminal, comprising: receiving the search information via the communication line; and searching the specification data based on the search information to obtain the search information. A retrieval step of extracting a mill sheet matching the above, an acquisition step of acquiring specification data in the mill sheet extracted in the search step, and the specification data acquired in the acquisition step to the terminal via the communication line. And a transfer step of transferring the mill sheet.