JPH11254782A - Lecture class attendance guide direct mail forming system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the working efficiency of respective processes forming the time of formation of a lecture class attendance guide direct mail formed by dividing the mail into a plurality of patterns in compliance with attributes and areas to the time of dispatching the mail. SOLUTION: A system is provided with a customer master 2a for storing the individual information of a number of customers, a postal code table 3a for retrieving the combination of the mail numbers with the required times out of classroom codes, a classroom table 3b for retrieving the combination of curriculum codes with classroom codes out of the attribute information of customers, a classroom map image master 3c for storing classroom map images based on the classroom code, a curriculum image master 3d for storing the curriculum images based on the curriculum codes, a data processing means for reading in data out of the customer master, the classroom table, the mail number table, the classroom map image master and the curriculum image master and forming a printed image and a printer for printing the printed image.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for creating a direct mail for attendance guidance used in a study cram school, a vocational school, and the like. The present invention relates to a system that can easily process direct mail for business use.

[0002]

2. Description of the Related Art As is well known, in a cram school or a vocational school, etc., in order to secure students, there is a direct guide for attending a course that describes the contents of a newly opened curriculum and a map of a classroom where the curriculum is opened. Often, an email is created and mailed to potential customers. This type of direct mail is based on individual customer attributes (grade,
It is preferable to describe only the curriculum according to the science and the like and the classroom close to the customer's address. Conventionally, direct mail is divided into several patterns according to attributes and regions, and Each time a composition was created and printed.

[0003]

However, in the case of the above-mentioned conventional method, since each process such as form processing, sorting, address printing, packing, and shipping after printing must be performed for each pattern, There was a problem that it took time and work efficiency was not good. Due to such circumstances, there is a case where direct mail is not divided into patterns according to attributes and regions, but a curriculum and classrooms are created and sent to all members. In this case, however, the direct mail is very difficult for the recipient to see, and the sender has a problem that the volume of the enclosure becomes bulky and time-consuming to ship, and the cost increases.

[0004] The present invention has been made in view of the above-mentioned circumstances, and its object is to create a direct mail for attendance guidance, which is created in several patterns according to attributes and regions, from sending to sending. It is to improve the work efficiency of each process.

[0005]

In order to achieve the above object, the invention of claim 1 stores personal information including names, zip codes, addresses, attribute information for selecting a curriculum, etc. of many customers. Customer master, a postal code table for searching for a combination of a postal code in an area close to the classroom and the required time from the area to the classroom by the classroom identification code, and a corresponding curriculum identification code by the attribute information A classroom table for searching combinations of classroom identification codes where the curriculum is offered, a classroom map image master that stores classroom map images based on classroom identification codes, and a curriculum identification code for curriculum images Read personal information from curriculum image master stored based on A combination of a curriculum identification code and a classroom identification code retrieved from the classroom table based on the attribute information included in the personal information, and retrieved from the postal code table using the classroom identification code included in the combination. A predetermined number of combinations of postal code and required time whose postal code matches the postal code of the personal information are extracted in ascending order of required time, and the classroom map image master is identified by a classroom identification code corresponding to the obtained combination. And a data processing unit for reading a curriculum image from the curriculum image master based on the curriculum identification code according to the identification code of the curriculum and generating a print image, and printing the print image generated by the data processing unit. And a printer, a direct mail creation system for student guide, characterized in that with.

According to a second aspect of the present invention, in the direct mail creation system for attending guidance according to the first aspect, the data processing means includes a combination of a postal code and a required time retrieved from the postal code table. If there is no predetermined number of postal codes that match the postal code of the personal information, the postal code is extracted in order from the one closest to the postal code of the personal information until the postal code reaches the predetermined number. It is.

According to a third aspect of the present invention, in the direct attendance guidance mail creating system according to the first or second aspect, the attribute information is a school year.

[0008]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, specific embodiments of the present invention will be described with reference to the drawings. 1 is a schematic configuration diagram of an embodiment of the present invention, FIG. 2 is a processing flow showing a processing flow by the system of FIG. 1, FIG. 3 is a diagram showing a format and data example of student master data, and FIG. FIG. 5 is a diagram showing a data format and an example of data of a number table, FIG. 5 is a diagram showing a data format and an example of data of a classroom table, FIG. 6 is a flowchart showing a procedure of print image generation processing of a data processing means, and FIG. FIG. 8 is a plan view of a printed form, and FIG. 8 is a plan view of a printed form.

The system of this embodiment is for a preparatory school having a plurality of classrooms in various places to create direct mails for attending various curriculum such as seminars. As shown in FIG. Processing device 1 comprising a hard disk device and the like
Storage device 2 and MO (magneto-optical disk) or CD-RO
A second storage device 3 including a floppy disk device or the like using M as a recording medium, a kanji printer 4, a display device 5 including a CRT or the like, and an input device 6 including a keyboard, a mouse, and the like are provided.

The processing device 1 has data processing means 1a shown in FIG. 2, and this data processing means 1a is for generating a print image, and is constituted by software.

The first storage device 2 has a student master (customer master) 2a shown in FIG.
a has personal information of a large number of students collected in a mock test, a workshop, and the like. Each record is text data having items as shown in FIG. 3, and is sequentially referred to by the data processing means 1a.

The second storage device 3 includes a postal code table 3a, a classroom table 3b, a classroom map image master 3c, and a curriculum image master 3d shown in FIG.

The postal code table 3a is text data having, as items, a postal code of an area near each classroom and an approximate required time from the area to the classroom. Each record has a list structure as shown in FIG. The data is called by the data processing means 1a each time. In addition,
The classroom code is a classroom identification code.

The classroom table 3b is text data having identification codes (hereinafter referred to as "curriculum codes") of the curriculum provided in each classroom and grades corresponding to the codes, and each record is as shown in FIG. This is variable-length text data having a list structure, and is called by the data processing means 1a each time.

The classroom map image master 3c is a set of image data of a classroom map output to a direct mail, and the classroom map image is a bitmap image file represented by a file name "classroom code.bmp". . Each map image may be created by DTP, or an image obtained by reading a map document with an image scanner may be used. The created image file of each classroom is managed by a file name, and is called by the data processing means 1a each time. Here, the image format is described as Windows BMP format data, but other image formats such as EPS and TIFF may be used.

The curriculum image master 3d is a set of curriculum image data output to direct mail, and the curriculum image is a bitmap image file represented by a file name "curriculum code.bmp". Each curriculum image may be created by DTP, or an image read by an image scanner may be used. Each created image file is managed by a file name, and is called by the data processing means 1a each time. Here, the case where the image format is data of Windows BMP format is described, but other image formats such as EPS and TIFF may be used.

The data processing means 1a sequentially reads each record of the student master 2a, searches for one curriculum image and one or a plurality of classroom map images to be output according to the contents of the items, reads these, reads them, and reads the address and the like. A process for creating a print image together with the text data is performed. Note that the number of classroom maps to be output is narrowed down by a preset parameter. The print image is data written in a language understood by the kanji printer 4 and includes printer control information, destination address information, image data, and the like.

The detailed procedure of the print image generation processing of the data processing means 1a will be described with reference to FIG. First, the data processing means 1a stores the personal information from the student master 2a as 1
The record is read (step # 10), the contents of each item are recognized, and one or more combinations of the curriculum code of the curriculum corresponding to the grade and the classroom code of the classroom in which the curriculum starts are read from the classroom table 3b (step #). 20).

Next, the data processing means 1a reads the combination of the postal code and the required time from the postal code table 3a using the classroom code included in the data read in step # 20 (step # 30). The same number as those of the parameters are extracted in the order of the required time, in the order of the required time, in the order of the postal code included in the personal information read from the student master 2 (step # 40).

The data processing means 1a reads the classroom map image from the classroom map image master 3c using the classroom code corresponding to the obtained combination, and reads the curriculum from the curriculum image master 3d using the curriculum code obtained in step # 20. Is read, and a print image is generated from these and the address information of the personal information (step # 50) and stored in the memory.

When the print image generation for one record is completed, the data processing means 1a sets the reference count value to 1
The number is increased and compared with the number of records stored in the student master 2a. If the reference count value is equal to the number of records, it means that the generation of the print image has been completed for all the records, and the process is terminated. If the reference count value is less than the number of records, the process returns to step # 10 to repeat the above processing (step # 10).
60).

The kanji printer 4 analyzes the print image generated by the data processing means 1a and prints the data on a pre-printed form (see FIG. 7) on which fixed information is printed in advance.

Next, the process from the creation of the attendance guide direct mail to the sending thereof by this system will be described with reference to FIG. First, the data processing means 1a reads the first record of personal information (first information shown in the example of FIG. 3) from the student master 2a, and recognizes the content of each item. Then, the following four combinations of classroom codes and curriculum codes are read from the classroom table 3b according to the grade (3). (B, CB3), (C, CC3), (D,
CD3), (E, CE3)

The data processing means 1a sets the postal code of the personal information to the postal code of the personal information (in the combination of the postal code and the required time, which is searched from the postal code table 3a by the classroom codes BE included in these combinations). 53
A process is performed to extract a match with 0). The combinations obtained by this are (530, 30) included in the record of the classroom code B and (530, 35) included in the record of the classroom code C.

Next, the data processing means 1a performs a process of taking out a number equal to the parameter value (1) from the above combinations in ascending order of the required time.
0, 30).

Since this combination is included in the record of the classroom code B, the curriculum image output on the first page is the data managed by the curriculum image master 3d under the file name "CB3.bmp". The classroom map image becomes data managed in the classroom map image master 3c under the file name "B.bmp", and these data are read. Then, a print image is created together with the address information obtained from the personal information.

In this manner, print images are created for all the student's personal information, and in parallel with this, data corresponding to each print image is printed on the pre-printed form by the kanji printer 4 (see FIG. 8). ). Then, the printed form is processed together with the enclosed material, and after sealing, folding, enclosing in an envelope, sealing, etc.,
Sorted, packed and shipped.

It should be noted that the present invention is not limited to the above embodiment, and various changes can be made. For example, the attribute information for selecting a curriculum may be information other than the grade, and may be, for example, a classification of a humanities or sciences, a grade in a test or the like, a past attendance history, or the like. Further, a combination of a plurality of pieces of information may be used. The parameter for determining the number of combinations extracted from the postal code table by the data processing means may be other than one.

Further, in the above embodiment, when the data processing means narrows down the combination of the postal code and the required time searched from the postal code table by the classroom identification code included in the combination read from the classroom table, Although a predetermined number of combinations whose postal code matches the postal code of personal information are extracted,
If the postal code matches the postal code of the personal information in a predetermined number of combinations of the postal code and the required time retrieved from the postal code table, the postal code is closest to the postal code of the personal information. The same processing (extraction in ascending order of required time) may be performed in order from the ones until a predetermined number is reached.

In addition to the above, various modifications can be made without departing from the gist of the present invention.

[0031]

According to the direct mail creation system for attending guidance according to the present invention, it is not necessary to create direct mail for attending guidance separately in a pattern as in the prior art. Work efficiency in the process is improved. In addition, since a direct mail creation system for attending courses in all classrooms can be created collectively and sent simultaneously, there is an advantage that the postal cost reduction system can be applied to reduce the mail cost.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram of an embodiment of the present invention.

FIG. 2 is a processing flow chart showing a processing flow by the system of FIG. 1;

FIG. 3 is a diagram showing a format and data example of data of a student master.

FIG. 4 is a diagram showing a format and data example of data of a postal code table.

FIG. 5 is a diagram showing a data format of a classroom table and a data example.

FIG. 6 is a flowchart illustrating a procedure of a print image generation process of the data processing unit.

FIG. 7 is a plan view of a pre-printed form.

FIG. 8 is a plan view of a printed form.

[Explanation of symbols]

 1a Data processing means 2a Student master (customer master) 3a Postal code table 3b Classroom table 3c Classroom map image master 3d Curriculum image master 4 Kanji printer

Claims (3)

[Claims] Claims: 1. A customer master storing personal information including names, zip codes, addresses, attribute information for selecting a curriculum, etc. of a large number of customers; A postal code table for searching for a combination of required times from an area to the classroom; a classroom table for searching for a combination of an identification code of a corresponding curriculum based on the attribute information and an identification code of a classroom in which the curriculum is held; A classroom map image master storing a classroom map image based on a classroom identification code; a curriculum image master storing a curriculum image based on a curriculum identification code; and reading personal information from the customer master. The classroom table according to the attribute information included in the personal information The combination of the identification code of the curriculum and the identification code of the classroom to be retrieved is read from the combination. A predetermined number of items matching the postal code of the information are extracted in ascending order of required time, and a classroom map image is read from the classroom map image master using the classroom identification code corresponding to the obtained combination, and the curriculum identification code is used. A direct course guidance system comprising: a data processing unit that reads a curriculum image from the curriculum image master to generate a print image; and a printer that prints the print image generated by the data processing unit. Baa Creation system. 2. The data processing means according to claim 1, wherein when a predetermined number of postal codes matching the postal code of said personal information do not exist in a combination of postal code and required time retrieved from said postal code table. 2. The system for creating a direct mail for attendance guidance according to claim 1, wherein the extracting means extracts the postal codes in order from the postal code closest to the postal code of the personal information until reaching a predetermined number. 3. The system according to claim 1, wherein the attribute information is a school year.