JP4132971B2 - Name list database creation method, address printing method, and name list database creation device - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates like creating a list database for building list database for IC chip using the existing roster database not for an ID chip.
[0002]
[Prior art]
In general, a new database is constructed by associating data from a plurality of databases. When associating data with each other, all the data is input to each database, and thereafter, the data in the databases are associated with each other. For example, when printing address books on printed materials such as postcards and envelopes, and managing the printed materials with management codes, create a database for address cards, a database of management codes, and other necessary items, Thereafter, a new database is constructed by associating data in these databases. Here, the reason for using multiple databases is not to build a dedicated database from the beginning, but to build multiple databases and then associate the data of each database so that it can be used for various purposes. is there.
[0003]
[Problems to be solved by the invention]
However, as described above, in order to accurately associate data between a plurality of databases, strictly speaking, a plurality of databases in which unique data is registered, confirmation work is required for each association. There is a problem that it takes a lot of time and effort.
Therefore, a technical problem to be solved arises so that the data of the databases can be associated easily and accurately, and the present invention aims to solve this problem.
[0004]
[Means for Solving the Problems]
In order to achieve the above object, the present invention provides a database using an ID chip that transmits unique ID information, a database that records name list data, and a medium that displays a management code associated with each name list data. A database including the information by associating name list data read from the database, management code of the medium , and ID information transmitted by the ID chip As a database creation method, the management code and the ID code can be associated with the name list data.
[0005]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, a first embodiment and a second embodiment of the present invention will be described with reference to the accompanying drawings. In the second embodiment, the same components as those described in the first embodiment are denoted by the same reference numerals, and the description thereof is omitted.
[0006]
(First embodiment)
A computer 5 according to an embodiment of the present invention will be described with reference to FIGS. FIG. 1 is a schematic configuration diagram of a database creation system, FIG. 2 is a block diagram of the database creation system, and FIG. 3 is a configuration diagram of a reading device (scanner).
1 to 3, the database creation system 1 inputs a computer 5, a scanner 2 for inputting print data to the computer 5, and unique ID information (radio wave signal) of the ID chip 3 to the computer 5. A recognition device 4 for printing, and a printer 7 for printing.
The computer 5 is connected to the management database DB2 in which a plurality of management codes are registered, acquires the management codes, and is connected to the Internet IT, and acquires name list data from the name list database DB1 on the Internet IT.
As shown in FIGS. 1 and 3, the recognition device 4 is attached to the scanner 2 on the lower surface of the outlet side tray 2c that is obliquely connected to the outlet 2b. An ID chip 3 is attached to a printing paper (distributed material) P as a medium to be read by the scanner 2. As shown in FIG. 2, the recognition device 4 includes a transmission / reception unit 4a for transmitting and receiving radio waves and an A / D converter (analog / digital converter) 4b, and the A / D converter 4b is used. It is connected to the transmission / reception unit 5a of the computer 5. The ID chip 3 includes a memory (ROM) 3a, a transmission / reception antenna 3b, a power generation circuit 3c, and a transmission circuit 3d. Before or after printing the printing paper (medium) P, the ID chip 3 is printed on the printing paper P by the tag seal L. Pasted in the margin.
The ID chip 3 is a highly flexible microchip, and no damage is caused even if the printed material P is bent while attached to the printed material P such as paper.
[0007]
As shown in FIG. 1, the recognition device 4 is attached to the lower surface of the outlet side tray 2 c connected to the outlet 2 b of the scanner 2.
In this way, the printing paper P is output from the transmission / reception unit 4a of the recognition device 4 while being guided by the outlet tray 2c connected obliquely downward to the outlet 2b of the scanner 2 and sliding down. The power generation circuit 3c of the ID chip 3 can be activated by the electromagnetic wave, and the transmission circuit (signal output circuit) 3d can be activated by this electricity. When the transmission circuit 3d is activated and the ID information read from the memory (ROM) 3a is transmitted to the outside and received by the transmission / reception antenna 4a of the recognition device 4, the received ID information is A / D converted and the computer. 5 is transmitted to the database creation program running on the computer 5.
[0008]
FIG. 4 is a flowchart of such a database creation program.
Referring to FIG. 4 and FIGS. 1 to 3, when the database creation program starts (FIG. 4, S1), the computer 5 is connected to the name list database DB1 and the management database DB2 on the Internet IT. Is read and the management code is read from the management database DB2 (FIG. 4, S2). Subsequently, these acquired data (name list data, management code) are converted into print codes in the order of acquisition and sent to the printer 7 described above to be printed on a printed material P as a distributed material such as a postcard or envelope (FIG. 4, S3). . In this case, there is one name list data and one management code for one name list data. After the name list data and the management code are printed on the printed matter P by the printer 7, the tag sticker L is created as described above (FIG. 4, S4), and the ID chip 3 is pasted on the printed matter P by this tag sticker L (see FIG. 4, S5) When this printed matter P is placed on the inlet side tray 2a of the scanner 2, the printed matter P is moved to the inlet side by a detecting means (not shown) such as a microsensor disposed in the inlet side tray 2a. Whether it is placed on the tray 2a is detected. When the printed matter P is detected, the database creation program switches from the standby mode to the activation mode, and activates a reading program for driving the scanner 2.
[0009]
The reading program of the scanner 2 determines whether or not the printed material P is placed on the inlet side tray 2a via a detecting means (not shown) such as a microsensor disposed on the inlet side tray 2a of the scanner 2 described above. Is always detected. When the detection means (not shown) detects the printed matter, the reading program of the scanner 2 activates a driving device (not shown) and an optical reading device (not shown) of the scanner 2. For this reason, when the detection unit cannot detect the printed matter P, the scanner 2 enters the standby mode.
[0010]
During the standby mode of the scanner 2, the ID chip 3 is attached to the margin of either the front surface or the back surface of the printed material P by the tag seal L (FIG. 4, S5). The tag seal L is obtained by pasting the ID chip 3 on the adhesive surface in advance and then pasting a release paper (release film) coated with a release material on the adhesive surface. When the printed matter P with the tag seal L attached is placed on the entrance-side tray 2a of the scanner 2, the scanner 2 switches to the start mode. When the scanner 2 is driven, the print information of the printed matter P is read by the optical reading device of the scanner 2 (FIG. 4, S6), and then the ID signal is recognized by the recognition device 4 (FIG. 4, S7). . These print information and ID signal are input to the computer 5. When the print information and the ID signal of the printed material are transferred to the database creation program, the database creation program extracts the management code from the print information input from the scanner 2 and registers the management code and the ID information in association with the name list data. This is registered as data (FIG. 4, S8) and registered in the management database DB2 (FIG. 4, S10). The printed matter with the address data, management code, and ID information is mailed or distributed to the address data destination as a distribution (FIG. 4, S9). The management code and the ID information are associated with each other in the order in which each printed matter P is inserted into the scanner 2.
[0011]
Further, the management code is taken out from the printed material P in the printing position of the name list data and the management code, the area ratio of the name list data and the management code, the point ratio of the name list data and the management code or the difference in the typeface, or the computer 5 It is assumed that it is made with reference to at least one of print control information such as the print position and print code of the printer 7 temporarily stored in the stack.
As a result, as shown in FIG. 5, registration data for the number of printed materials P, in other words, registration data for the number of name list data is registered in the management database DB2. In the present embodiment, as shown in FIG. 3, the recognition device 4 is installed not at the preceding stage of the optical reading means of the scanner 2 but at the subsequent stage of the optical reading means so that the conventional scanner 2 can be used. It is to make it. Therefore, when the scanner 2 is newly designed, the recognition device 4 is arranged in front of the optical reading means so that the ID signal is recognized first and then the management code is recognized. However, in order to reduce the cost by standardizing the scanner, it is desirable to attach the outlet tray 2c as an attachment to the outlet 2b of the scanner 2 and attach the recognition device 4 to the outlet tray 2c.
[0012]
By the way, if the management code and the ID information are associated with the name list data as registration data, and the registration data is registered in the management database DB2, various operations of the data are possible.
For example, postcards, envelopes, or tickets printed with name book data and management codes and pasted with an ID chip 3 are distributed as admission tickets for exhibitions and concerts (including paid and free) and installed at distribution sites. When the ID information of the distribution is detected by the recognition device 4 and associated with the registration data having the ID code, it can be used as the database DB2 for knowing the entrance state. In this case, even if the management code is recognized by the scanner 2, an inquiry can be made by the management code, but it is not compatible in terms of responsiveness. That is, since reading of the ID chip 3 is a wireless response, the response is quicker and less time-consuming than a barcode reader. Further, if the recognition device 4 and the gate opening / closing device at the entrance of the venue are interlocked so that the gate is opened when the recognition code is recognized, unmanned operation in the gate opening / closing can be achieved. Furthermore, since the ID chip 3 according to the present invention holds unique ID information for each chip and the ID information cannot be rewritten, the forgery prevention effect is high. Further, since the ID chip 3 according to the present invention is small and inexpensive, the cost effect is high.
[0013]
(Second Embodiment)
Hereinafter, a second embodiment of the present invention will be described with reference to FIGS. 6 is a schematic configuration diagram of a database creation system according to the second embodiment, FIG. 7 is a block diagram of a computer system, FIG. 8 is a configuration diagram of a printer, and FIG. 9 is a database creation program running on the computer. It is a flowchart of.
The computer 5 of the database creation system 11 according to this embodiment takes out the management code transmitted to the printer 7 and associates the management code and ID information with the name list data to obtain registration data, which is then used as the management database. This is registered in DB2. Therefore, in this embodiment, the scanner 2 is removed from the database creation system 1 according to the first embodiment, and instead connected obliquely downward to the upper tray 7c extending the printer outlet 7b. The recognition device 4 is attached to the back surface of the exit side tray 7d, and the process of reading the management code printed on the front surface of the printing paper P and the recognition of the management code by the computer 5 (FIG. 4, S6) is omitted. Yes. Other configurations are the same as those of the first embodiment.
[0014]
The database creation program according to this embodiment will be described with reference to FIG. 9 and FIGS. 6 to 8. When the database creation program is started (FIG. 9, S1), the computer 5 manages the name list database DB1 on the Internet IT. Connected to the database DB2, name list data is read from the name list database DB1 on the Internet IT, and management codes are read from the management database DB2 (S2 in FIG. 9). Subsequently, these acquired data (name list data, management code) are converted into print codes in the order of acquisition and sent from the computer 1 to the printer 7 described above to be printed on a printed material P as a distributed material such as a postcard or envelope (FIG. 9). , S3). In this case, one name list data and one management code are provided for one name list data as in the first embodiment.
[0015]
Before printing the directory data and the management code on the printed matter P by the printer 7, the tag sticker L is created as described above (FIG. 9, S4), and the ID chip 3 is pasted on the printed matter P by the tag seal L. (FIG. 9, S5) When this printed matter P is placed on the inlet side tray 7a of the printer 7, the printed matter is detected by a detecting means (not shown) such as a microsensor disposed on the inlet side tray 7a. Whether or not P is placed on the entrance side tray 7a is detected, and when the printed matter P is detected, the standby mode is switched to the activation mode.
[0016]
While the print mode P is switched to the start mode and the printed printing paper P slides down the outlet tray 7d of the printer 7, the recognition device 4 recognizes the ID chip 3, and the database creation program reads the print information and ID signal of the printed matter P. Is received, the management code output to the printer 7 is taken out, the management code and the ID information are associated with each other in the name list data as registration data (FIG. 9, S8), and this registration data is sequentially registered in the management database DB2. (FIG. 9, S10). The printed matter P to which the address data, management code, and ID information are attached is mailed or distributed to the address data destination as a distribution (FIG. 9, S9). The association between the management code and the ID information is performed in the order in which each printed matter P is inserted into the printer 7.
[0017]
As described above, a print code is used as the management code sent from the computer 5 to the printer 7. Then, since the management code corresponding to the name list data is sent to the printer 7, based on this correspondence, the printer 7 can deliver the correct management data to the database creation program.
As a result, in the management database DB2, registration data for the number of printed materials P, in other words, registration data for the number of name list data is registered.
[0018]
In the description of the first embodiment and the second embodiment, the management database DB2 is described as being directly connected to the computer 5, but may be formed on the Internet or an intranet. Note that the management database and the name list database DB1 on the Internet IT are constructed in a storage device such as a hard disk or an MO. In the description of the first embodiment and the second embodiment, the description is given of acquiring the name list data from the name list database on the Internet IT, but the name list data is acquired before printing. You just have to. Therefore, the name list data may be acquired in real time or in advance. However, in order to reflect the latest data, it is preferable to acquire the name list data in real time.
Further, in each of the above-described embodiments, the management database DB2 is a registration database for registration data, but another database may be used as the registration database.
[0019]
【The invention's effect】
As is apparent from the above description, according to the present invention, it is possible to omit the trouble of associating the management code and the ID code with the name list data, and there are excellent effects such as the rapid construction of the database. Demonstrated.
[Brief description of the drawings]
FIG. 1 is a schematic configuration diagram of a computer system according to a first embodiment of the present invention.
FIG. 2 is a block diagram of the computer system according to the first embodiment of the present invention.
FIG. 3 is a configuration diagram of a scanner according to the first embodiment of the present invention.
FIG. 4 is a flowchart of the database creation program according to the first embodiment of the present invention.
FIG. 5 is a schematic diagram showing a database according to the first embodiment of the present invention.
FIG. 6 is a schematic configuration diagram of a computer system according to a second embodiment of the present invention.
FIG. 7 is a block diagram of a computer system according to a second embodiment of the present invention.
FIG. 8 is a configuration diagram of a printer according to a second embodiment of the present invention.
FIG. 9 is a flowchart of a database creation program running on a computer according to the second embodiment of the present invention.
[Explanation of symbols]
1 Database creation system 2 Scanner (recognition device)
3 ID chip 4 Recognition device 5 Computer 7 Printer 11 Database creation system P Printing paper (medium)
DB1 Directory database DB2 Management database (registration database)

Claims (6)

A scanner that optically reads the surface of the printed medium;
A tag reader that reads unique ID information stored in an ID chip attached to the medium via radio waves;
A printer for printing on the medium;
A name book database creation method for creating a name book database using a computer comprising :
The computer
Obtaining name list data from an existing name list database, obtaining a management code from a management database in which a management code corresponding to the obtained name list data is assigned one-to-one, and using the printer, the name list data and the management code Addressing processing for printing a pair of and on the medium;
After the address writing process, the scanner reads the printed medium optically to recognize read information obtained from the scanner, and obtains a management code displayed on the medium; ,
A process of acquiring ID information of an ID chip attached to a medium printed by the printer from the tag reader;
And management code acquired by the recognition, and the ID information acquired by the tag reader, by performing the processing of registering in the storage means in association with a one and a list data obtained from the existing list database,
The management code in one-to-one correspondence between the list data of the existing roster database, and create your list database that associates the ID information and the list data
To create a directory database characterized by   The scanner is
  A detecting means for detecting the medium on the tray on the entrance side;
  The computer
  When the detecting means detects the presence of the medium, the function of creating the directory database is switched from the standby mode to the start mode.
The name list database creation method according to claim 1. Reading the ID information by the tag reader is as follows:
  The medium is slid down the slope of the outlet tray by a tag reader provided in the outlet tray connected obliquely downward to the outlet of the scanner.
A method for creating a name list database according to claim 1 or 2.   A printer that prints on printable media;
  A tag reader for reading unique ID information stored in an ID chip attached to a printed medium via radio waves;
Creating a name list database using a computer comprising: a name printing method for printing name list data as addresses on the medium,
  The computer
  Obtaining name list data from an existing name list database, obtaining a management code from a management database in which a management code corresponding to the obtained name list data is assigned one-to-one, and using the printer, the name list data and the management code Addressing processing for printing a pair of and on the medium;
  A process of acquiring ID information of an ID chip attached to a medium printed by the printer from the tag reader;
  Management code acquired from the management database and ID acquired by the tag reader By performing a process of registering information and name list data acquired from the existing name list database in a one-to-one correspondence with the storage means,
  Creating a name list database in which the ID information and the name list data are associated with a management code having a one-to-one correspondence with the name list data of the existing name list database;
Address printing method characterized by   A scanner that optically reads the surface of the printed medium;
  A tag reader that reads unique ID information stored in an ID chip attached to the medium via radio waves;
  A printer for printing on the medium;
A name list database creation device for creating a name list database,
  The directory database creation device is:
  Obtaining name list data from an existing name list database, obtaining a management code from a management database in which a management code corresponding to the obtained name list data is assigned one-to-one, and using the printer, the name list data and the management code And addressing processing for printing a pair on the medium;
  After the address writing process, the scanner reads the printed medium optically to recognize read information obtained from the scanner, and obtains a management code displayed on the medium; ,
  A process of acquiring ID information of an ID chip attached to a medium printed by the printer from the tag reader;
  By performing a process of registering the management code acquired by the recognition, the ID information acquired by the tag reader, and the name list data acquired from the existing name list database in a one-to-one correspondence in the storage unit,
  Creating a name list database in which the ID information and the name list data are associated with a management code having a one-to-one correspondence with the name list data of the existing name list database;
Name list database creation device characterized by this. 6. The name book database creation device according to claim 5, wherein the tag reader is configured to be attached to the back surface of an outlet side tray connected obliquely downward to the outlet of the scanner .

Images