JP4147009B2 - Data input system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a data input system.
[0002]
[Background Art and Problems to be Solved by the Invention]
For example, when a product catalog is produced by desktop publishing, it is necessary to input data to a database and correct the data. At that time, in order to shorten the time required for catalog production, it is important to efficiently input and correct data. An object of the present invention is to provide a data input system capable of efficiently inputting data into a database.
[0003]
[Means / Actions / Effects to Solve Problems]
The present invention has been made in view of the above circumstances, and provides a data input system having the following features.
[0004]
Data input system of the present invention, a group of 1 consists of a plurality of items and goods subassembly, when to produce a catalog that lists multiple items subassembly in desktop pub re-phishing, in order to provide to the desktop publishing It is a data input system for registering information on each product in a database.
The data entry system, for "each product subassembly, the input and the parent table having attributes that are common to a plurality of items belonging to the product subassembly as input items, the attributes of the plurality of respective products have a unique value A first recording medium storing a database for storing a child table having items, an association table associating the parent table with the child table, and “for inputting data into the parent table stored in the first recording medium” "Second recording medium for storing parent data input form and child data input form for inputting data to child table stored in first recording medium" and "Parent data input form stored in second recording medium" And child data input form in a form that can be switched with tabs on one screen of the display device "and" input form " And an input means for inputting data to the parent data entry forms and child data input form that is displayed (mouse or a keyboard) "by the shown means. And the said child data input form has the input part of the table form form containing a some line, It is characterized by the above-mentioned.
[0005]
In the data input system of the present invention having the above-described configuration, the parent data input form and the child data input form are switched only by switching the tabs, so that the input of the parent data and the child data can proceed simultaneously. Furthermore, since the child data input form has an input part in the form of a table including a plurality of rows, it is possible to input product data for a plurality of products from one input form without switching the input form. And efficient data input can be achieved.
[0006]
The data input system of the present invention is “a search means that is activated by clicking one of the buttons assigned to each row of the child data input form and searches for rows satisfying a certain search condition in the child table”. It is preferable to further include “duplicating means for duplicating the data content of the line retrieved by the retrieving means to the line relating to the clicked button on the child data input form”.
[0007]
When such a configuration is adopted, it is possible to further reduce the time required for data input by effectively utilizing the product data in the already registered child table.
[0008]
The data input system of the present invention can be realized in a stand-alone computer device, but can also be applied to a database and a client terminal connected via a network.
[0009]
DETAILED DESCRIPTION OF THE INVENTION
Catalog booklet and commodity sub-assembly Embodiments of the present invention will be described in detail below with reference to the accompanying drawings, taking a catalog production as an example. FIG. 1 is a schematic view of a catalog as a final product. In this catalog, a predetermined product group is grouped as one product subgroup 1. Here, for the sake of simplicity, two desiccators are shown as one product subgroup. In FIG. 1, only one product subgroup 1 is shown, but actually one or a plurality of product subgroups are posted on one page in the catalog according to the size.
[0010]
Layout work for character information, table sets, product images, etc. in the product sub-group on the catalog paper is performed in DTP (desktop publishing) work. The present invention is intended for data input to a database, which is a stage before DTP work is performed. That is, after the input of product data from the input form displayed on the client terminal to the database by the data input support system of the present invention is completed, catalog production by DTP is performed based on the product data. An input form is created for each product structure of the catalog, and a plurality of input forms are set for each catalog booklet to be produced for the same user.
[0011]
Block diagram Figs . 2 and 3 are block diagrams showing an example of registering data in a database via a network. FIG. 2 shows a client terminal 20 that performs an input operation to the database, and FIG. 3 shows a server system 30 that includes a database in which product data is stored. Both are connected by a transmission / reception unit via a network such as the Internet, an intranet, or a LAN.
[0012]
The client terminal in FIG. 2 is a personal computer equipped with a CPU, and stores a Web browser and other software in the hard disk 21. The Web browser displays an HTML document transmitted from the Web server of the server system. After performing a login operation to be described later, the user operates the operation unit 23 (input means such as a mouse and a keyboard) while viewing the display 22 of the client terminal to input product data.
[0013]
The server system of FIG. 3 is, for example, a computer having a CPU, and a program database 31 includes a Web server, CGI, form creation tool, input support tool (input form display means), database server, authentication server, and the like. A program for realizing the function is recorded. In the product information database 32, product data for catalog creation transmitted from the client terminal is accumulated, and a catalog is created based on this. The merchandise information database 32 is linked to a web page using HTML by CGI. The product data is input from an input form (see FIGS. 5 and 6) displayed on the client terminal by the input support tool. The input screen will be described in detail later.
[0014]
In the input form database 33, various input forms displayed on the client terminal by the input support tool are stored as an HTML document 34.
[0015]
Note that connection authority is set for each of the product information database 32 and the input form database 33 to prevent an unrelated third party from customizing the input form or operating the product data. This is performed by a general method using a user ID and a password.
[0016]
Login operation FIG. 4 shows a home page that is first displayed on the browser screen of the client terminal when the user accesses the site of the database construction support package set in the server system. When the character portion 45 of “input support tool for Web” displayed on the browser screen is clicked, the authentication server is activated and a login screen (not shown) is displayed. The user logs in by entering the database name, user ID, password, and the like. You need to log in for each catalog that you want to produce.
[0017]
When the login procedure is completed, the input support tool placed in the server system 30 displays an input screen on the client terminal. The user can operate (new registration, correction, deletion) on the data in the product information database 32 from this input screen. Note that the input form on the input screen can be customized so as to be adapted to the catalog listed product. In this case, the form creation tool is activated by clicking the character part 46 of “form creation tool”. In the example of FIG. 4, the input support tool and the form creation tool are placed on the same site. However, if the person in charge of input and the person in charge of customization are different, place both tools on separate sites. Also good.
[0018]
Outline Description of Main Screen FIG. 5 schematically shows a main screen that is first displayed by the input support tool. The “list frame” at the left end of the input screen 10 displays a list of a plurality of product sets recorded in the product information database 32 by specifying the product names corresponding to the product sets. That is, each product name listed in the “list frame” corresponds to one product sub-group. By clicking and selecting one product group in the “list frame”, data related to the product group can be input from each input form displayed on the “input sheet” on the right side. The operation panel at the top of the screen is a panel on which various buttons for turning pages, registering in a database, and the like are arranged.
In FIG. 5, the “desiccator” at the top of the list frame is selected, and an input form corresponding to the product sub-group is arranged on the right side of the list frame. This product group corresponds to the product group 1 shown in FIG.
[0019]
Comparison between the input form and the product sub-group In order to efficiently input various data for one product sub-group, three forms of “product spec”, “related link” and “material link” are set as “input form”. By clicking the tab button 11, each input form can be switched. Explaining in comparison with the product subgroup 1 in FIG. 1, the product data in the table set 2 consisting of two rows is input from the “related link” input form (FIG. 6), and other character information is input “product specification”. Each is entered from the form (FIG. 5). Note that the image data of the product image is registered in advance in a database on the server side, and the user associates the image data with the product set on the client terminal.
[0020]
Concept of “parent” and “child” In the example of FIG. 1, for the sake of simplicity, one product subgroup 1 is configured by a product group including two desiccators. Then, while defining attributes common to them as input items in the parent table, attributes defined by values unique to each product are defined as input items in the child table, and the parent table and child table are associated with a predetermined code. The product information database 32 is registered.
That is, the two desiccators differ in height, width, capacity, and price, but they are common in that they belong to the category of desiccator, and have common features and the like. Then, attributes (that is, product names, features, specifications, accessories, etc.) having values common to both desiccators are defined as input items of the parent table. On the other hand, attributes (that is, height, width, capacity, price, etc.) consisting of unique values set for each desiccator are defined as input items of the child table. As can be seen from FIG. 1, the product data recorded in the child table is posted in a matrix-like table form 2 in the product subgroup 1. The other character information excluding the image data is product data recorded in the parent table. As will be described later, “parent data input form for inputting parent data” and “child data input form for inputting child data” can be switched by selecting a tab on the input screen.
[0021]
In addition to the above information, the product information database 32 stores data necessary for functioning as a database system.
[0022]
Relationship between parent table and child table ( Figure 8)
FIG. 8 visually shows the relationship between the parent table and the child table described above. In FIG. 8, each of the product structure 8 and the product structure 9 corresponds to one product subgroup. That is, the merchandise structure 8 and the merchandise subgroup 1 (FIG. 1) correspond, and the merchandise structure 9 corresponds to another merchandise subgroup (not shown).
The product structures 8 a and 8 b as “children” associated with the product structure 8 being “parent” are displayed in the table assembly portion 2 in the product assembly 1. On the other hand, the values of the items “product name”, “feature”, and “specification” included in the product structure 8 are posted as character information in portions other than the table assembly portion 2 as attributes common to both the desiccators. Note that the product image shown in the product subgroup 1 is recorded in the product information database 32 in association with the product subcombination.
[0023]
Parent table ( Figure 9 )
Specifically, as shown in FIG. 9, one parent table is defined for each product subgroup. In the parent table, “product name”, “feature”, “specification”, and other items are set as attributes. The values of these attributes are common to the product group belonging to the product subgroup. The data recorded in the parent table is input from the “product specification” input form in FIG. The parent table is recorded in the product information database 32.
[0024]
Child table (FIG. 10)
On the other hand, as shown in FIG. 10, the child table defines one table for a plurality of products (each product is specified by a code). In the child table, “height”, “width”, “capacity”, “price”, and other items are set as attributes. The value of each of these attributes is unique for each desiccator belonging to the product subgroup. The data recorded in the child table is input from the “related link” input form in FIG. The child table is recorded in the product information database 32.
[0025]
Association table ( Figure 11)
Further, in the product information database 32, a related table in which information related to the association between the parent table and the child table is recorded is defined (FIG. 11).
[0026]
The actual product data input operation will be described below.
[0027]
"Product specification" tab input form ( Figure 5 )
Operate the operation panel to select either the new mode or the diversion mode. When the new mode is selected, the default input form is displayed and new data can be entered. When the diversion mode is selected, the input form in the edit mode is copied, and it is possible to perform editing by inputting only a predetermined change portion.
When the “Register” button 51 on the operation panel is clicked, the data input in the input form is transmitted to the server side, and the DB server performs update registration of the parent table in the product information database 32.
[0028]
Input form of "Related link" tab ( Figure 6 )
In this input form, data to be displayed as a table group is input in the product group selected on the list frame. That is, data input from this input form is data recorded in a child table defined in the product information database 32, and relates to attributes unique to each product. As shown in FIG. 6, the table set includes a plurality of rows, and one row corresponds to a row in the child table of FIG.
( 1 ) New input When data is input to the line where the display of the link selection BOX 61 is “x” and the “registration” button 62 is clicked, the data is transmitted to the server side and the child table is displayed. To be recorded. At the same time, the contents of the association table (FIG. 11) are updated, and the child table is associated with the product group selected on the list frame. Also, the display of the link selection BOX 61 changes from “×” to “◯” to indicate that it is associated.
( 2 ) Utilization of existing data Existing input data can be introduced. For example, to input data to the fifth row of the table set in FIG. 6, when a “reference” button 63-5 associated with the row is clicked, a search screen as shown in FIG. 7 is displayed. First, the key used for the search is specified in the selection box 71. As the search key, a code number or the like that can uniquely identify each row of the child table is designated. Next, when a search condition is entered in the text box 72 and the “search” button 73 is clicked, the search results are displayed in a list in the text area 74. In the example of FIG. 7, the search condition specified in the text box 72 is “66 ◆”, which means the search condition “the first two digits of the code number is 66”. A code number corresponding to this search condition is displayed in the text area 74 (search means).
Clicking the “OK” button in the dialog (not shown) displayed when one of the key items displayed in the list is selected, the data content of the row specified by the key item in the child table is displayed in the fifth row. Poured. That is, it is duplicated in the fifth row of the table set in the input form of FIG. 6 (duplicating means). Here, when the “Register” button 62-5 is clicked, the data is associated with the product sub-group. If necessary, the flowed data may be registered (associated) after the contents are appropriately corrected.
[0029]
Input form for `` Material Link '' tab ( not shown )
In this input form, data displayed as an image is associated with the product group selected on the list frame. As the image data itself, data registered in the database on the server side in advance is used. Here, only the association is performed on the client terminal by the user.
[0030]
When the “Preview” tab “Preview” tab is clicked, a preview screen (not shown) combining the data input in the above-mentioned “product specification”, “related link”, and “material link” tabs is displayed. This preview screen is for confirming whether there is an error in the character string of the input data, and is not for confirming the layout in the product sub-group on the completed catalog sheet. Layout is performed in a later DTP operation.
[0031]
In the “work history” tab and “filtering” tab “work history” tab, the work history for the product group displayed in the list frame is displayed (not shown). On the other hand, the “filtering” tab is for searching for a product group to be displayed in the list frame, and by appropriately setting a search condition, the product group extracted under a specific condition can be displayed in the list frame (not shown). Thereby, the efficiency of the data correction work can be increased.
[0032]
As described above, the product data to be published in the catalog is efficiently accumulated in the database. Based on the accumulated product data, information layout in the product subgroup, distribution to each page, etc. are performed by DTP work, and the catalog is finally completed.
[0033]
In the embodiment described above, an example in which data input is performed from a client terminal connected to a database via a network has been described. However, the data input system of the present invention can also be applied to a computer system used in a stand-alone manner. It is.
[Brief description of the drawings]
FIG. 1 is a schematic diagram illustrating a catalog booklet and a product subgroup.
FIG. 2 is a block diagram illustrating a client terminal connected to a server system via a network.
FIG. 3 is a block diagram illustrating a server system connected to a client terminal via a network.
FIG. 4 is a diagram for explaining a home page of a server system displayed on a browser screen.
FIG. 5 is a schematic diagram illustrating an input form for a product specification tab.
FIG. 6 is a schematic diagram illustrating an input form of a related link tab.
FIG. 7 is a schematic diagram of a search screen.
FIG. 8 is an explanatory diagram visually showing features of the present invention.
FIG. 9 is a schematic diagram of a parent table.
FIG. 10 is a schematic diagram of a child table.
FIG. 11 is a schematic diagram of a related table.
[Explanation of symbols]
1 Product subgroup 2 Table group publication part
20 Client terminal
30 server system

Claims (2)

A group of 1 consists of a plurality of items and goods subassembly, registration Upon to produce a catalog that lists multiple items subassembly in desktop pub re-ashing, the information of each product in order to provide to the desktop publishing in the database A data input system for
The data entry system
For each product subassembly, and the child table having a parent table that has the attributes that are common to the products belonging to the product subassembly as input items, the attributes of the plurality of respective products have a unique value as input items, A first recording medium that stores a database that stores an association table that associates a parent table with a child table;
A second data storage form for inputting data into a parent table stored in the first recording medium and a child data input form for inputting data into the child table stored in the first recording medium. A recording medium;
Input form display means for displaying the parent data input form and the child data input form stored in the second recording medium in a form that can be switched by tabs on one screen of the display device;
Input means for inputting data to the parent data input form and the child data input form displayed by the input form display means,
The data input system, wherein the child data input form has an input part in a table format including a plurality of rows. The common attribute that is an input item to the parent table and the unique attribute that is an input item to the child table are respectively defined in advance.
The input form display means, in the one screen, and displays together by a plurality of items subassembly of the list recorded on the first recording medium, one product subassembly in the list is selected by the user In this case, the data input system according to claim 1, wherein the parent data input form and the child data input form for the product sub- group are displayed in a form that can be switched by a tab on the screen.

Images