JP2014203197A - Tally file creation system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a tally file creation system capable of easily creating a tally.SOLUTION: A tally file creation system 1 is configured to create a tally file 22 for printing a tally to be attached to a forwarding object sorted for each postal code while using an inspection item file not including personal information of a dispatch destination. The inspection item file is created by a quality management system 3 and by registering the inspection item file in a quality management DB 41 of the quality management system 3, in the quality management system, processes of a dispatch object from printing of a document for each dispatch destination using master data received from a client to creation of a bundle of dispatch objects for which the printed documents are sorted are managed. The tally file creation system 1 comprises: a data arrival monitoring section for monitoring the arrival of the inspection item file transmitted from the quality management system; and a tally file creation section 12 for counting the number of data items for each postal code included in the inspection item file of which the arrival is detected, and creating a tally file 11 in which the postal code and the number of data items are made correspondent.

Description

  The present invention relates to a tally file creation system for creating a tally file for printing tally attached to a classified shipment.

Conventionally, as a service for companies that send out large amounts of invoices, postal items are bundled together by zip code under specified conditions, and a paper called “tally” is attached to each unit and sent. There is a mail discount system that allows you to receive discounts on charges.
And the system which reads the postal code attached | subjected to the mailpiece, prints a tally, and issues is disclosed (for example, patent document 1).
On the other hand, when manufacturing variable printing that includes personal information and has different printing contents for each product, management of manufacturing status is performed (for example, Patent Document 2). At that time, for example, a tally file is created by executing a program created according to the data format of the master data received from the client.

Japanese Patent Laid-Open No. 10-94761 Japanese Patent Laid-Open No. 2005-60080

  In the system described in Patent Document 1, a process of reading a zip code attached to a mail piece is necessary. Also, since the master data has a different data format for each client, it is necessary to customize the program so as to match the format of each master data.

  An object of the present invention is to provide a tally file creation system capable of easily creating tally.

  The present invention solves the above problems by the following means. In addition, in order to make an understanding easy, although the code | symbol corresponding to embodiment of this invention is attached | subjected and demonstrated, it is not limited to this. In addition, the configuration described with reference numerals may be improved as appropriate, or at least a part thereof may be replaced with another configuration.

The first invention creates a tally file (22) for printing a tally (8) attached to a shipment classified by area identification information, using an inspection item file not including personal information of a destination The tally file creation system (1), wherein the inspection item file is created by the quality management system (3), and the inspection item file is registered in the quality management database (41) of the quality management system, The quality management system manages each process of the shipment from the printing of the form for each delivery destination using the delivery destination data received from the requester to the creation of the aggregate that divides the printed form, and the quality management system A data arrival monitoring unit (11) that monitors the arrival of the inspection item file transmitted from the quality control system and connected via a communication network. And, in response to detecting the arrival of the inspection item file by the data arrival monitoring unit, the number of data is counted for each area identification information included in the inspection item file, and the region identification information and the number of cases are associated with each other. A tally file creation system comprising a tally file creation unit (12) for creating a tally file.
In a second invention, in the tally file creation system (1) of the first invention, the inspection item file monitored by the data arrival monitoring unit (11) is created for each client, and the quality The tally file creation system is characterized in that the system is before being divided according to the number of data to be registered in the management database (41).
According to a third aspect of the invention, in the tally file creation system (1) of the first or second aspect, the inspection item file monitored by the data arrival monitoring unit (11) is created using the destination data The tally file creation system is characterized in that it is extracted from the quality management database (41) in accordance with the normal pre-shipment processing of the generated form.
According to a fourth invention, in the tally file creation system (1) from the first invention to the third invention, the tally file creation unit (12) sets the file name of the tally file (22), A tally file creation system comprising: client identification information for identifying the client included in the inspection item file and a file creation date.

  ADVANTAGE OF THE INVENTION According to this invention, the tally file creation system which can produce a tally easily can be provided.

It is a figure which shows the whole structure of the form management system containing the tally file creation system which concerns on this embodiment. It is a figure for demonstrating the tally which concerns on this embodiment. It is a flowchart of a tally file creation process according to the present embodiment. It is a figure which shows the example of a screen and the example of alerting | reporting of the tally file creation system which concerns on this embodiment. It is a flowchart of a tally file creation process according to the present embodiment.

DESCRIPTION OF EMBODIMENTS Hereinafter, embodiments for carrying out the present invention will be described with reference to the drawings. This is merely an example, and the technical scope of the present invention is not limited to this.
(Embodiment)
FIG. 1 is a diagram showing an overall configuration of a form management system 100 including a tally file creation system 1 according to the present embodiment.
FIG. 2 is a diagram for explaining the tally 8 according to the present embodiment.
A form management system 100 shown in FIG. 1 is a system that manages from creation of a shipment to shipment.
The form management system 100 includes a tally file creation system 1, a quality management system 3, a form creation system 5, and a printer 7.
The tally file creation system 1 creates a tally file 22. Here, the tally file 22 refers to a data file whose content is tally 8.

The tally 8 is a paper tag printed as shown in FIG. The tally 8 includes an area identification unit 81, a discount type unit 82, and a serial number unit 83.
The area identification unit 81 is a part that describes the first five digits of the zip code (area identification information).
The discount type part 82 is a part describing the type of discount. There are three types of discounts, such as “discount” (no allowance), “special discount” (about 3 days), and “special feature” (about 7 days) depending on the degree of allowance for the number of delivery days. The characters need to be written in red at tally 8. Also, the paper color varies depending on the type of discount.
The mail number part 83 is a part that describes the number of mails included in the bundle 9 (aggregate) of the mailed goods.
As shown in FIG. 2B, the tally 8 is attached to a bundle 9 of shipments divided by zip code. If the post office asks the post office to ship the bundle 9 of shipments with the tally 8 attached, the post office has the merit of saving the sorting effort, and therefore, the shipping fee for the dispatch is discounted before shipping.

Returning to FIG. 1, the tally file creation system 1 is communicably connected to the quality management system 3. The tally file creation system 1 is connected to a printer 7.
The tally file creation system 1 includes a control unit 10, a communication I / F (interface) unit 15, a storage unit 20, an input unit 25, a display unit 26, and a notification unit 27.
The control unit 10 is a CPU (central processing unit) that controls the entire tally file creation system 1. The control unit 10 executes various functions according to the present invention in cooperation with the above-described hardware by appropriately reading and executing an operating system (OS) and application programs stored in the storage unit 20.
The control unit 10 includes a data arrival monitoring unit 11 and a tally file creation unit 12.
The data arrival monitoring unit 11 monitors the arrival of the inspection item file transmitted by the quality management system 3. The inspection item file will be described later.
The tally file creation unit 12 creates a tally file 22 from the inspection item file.
The communication I / F unit 15 is a communication interface for performing communication with the quality management system 3 by, for example, FTP (File Transfer Protocol).

The storage unit 20 is a storage area such as a hard disk or a semiconductor memory element for storing programs, data, and the like necessary for the control unit 10 to execute various processes.
The storage unit 20 includes a tally file storage unit 21.
The tally file storage unit 21 is a storage area for storing the tally file 22 created by the tally file creation unit 12.
The tally file 22 is created for each master data (destination data) received from the client. Here, the client refers to a company that requests shipping from creation of a bill or a receipt for each customer (destination), for example. If the shipment is a card payment statement, for example, the client is a credit card company. The master data is data including the print contents of the form, and includes data including personal information of the destination. The master data is data including the contents of the card payment details, for example.
The input unit 25 is an input device such as a keyboard and a mouse, for example.
The display unit 26 is a display device configured with, for example, a liquid crystal panel.
The notification unit 27 is an indicator lamp such as a warning lamp.

The quality management system 3 manages each process of printing, processing, enclosing a form using the master data, and sending a shipment enclosing the form for each destination.
The quality management system 3 is communicably connected to each of the tally file creation system 1 and the form creation system 5.
The quality management system 3 includes a control unit 30, a communication I / F unit 35, and a storage unit 40.

The control unit 30 is a CPU that controls the entire quality management system 3. The controller 30 executes various functions according to the present invention in cooperation with the hardware described above by appropriately reading and executing the OS and application programs stored in the storage unit 40.
The control unit 30 creates an inspection item file using the master data received from the client. The control unit 30 registers the inspection item file in the quality management DB (database) 41 and performs quality management. Quality control is performed by receiving status data of each process from the form creation system 5.
The communication I / F unit 35 is a communication interface for performing communication with the tally file creation system 1 and the form creation system 5.
The storage unit 40 is a storage area such as a hard disk or a semiconductor memory element for storing programs, data, and the like necessary for the control unit 30 to execute various processes.
The storage unit 40 includes a quality management DB 41.
The quality management DB 41 is a database having one form for each delivery destination created in the form creation system 5 as one record and having quality management information on the shipment.

The form creation system 5 includes a printing device 51, a processing device 52, a sealing device 53, etc., and uses master data to print, process, enclose a form for each destination, and classify a shipment that encloses the form, A bundle 9 of shipment items is created.
The printer 7 prints the tally file 22 created by the tally file creation system 1. The printed tally 8 is attached to the bundle 9 of shipments created and sorted by the form creation system 5 by an operator who attaches the tally 8 to the bundle 9 of shipments, for example.

Next, a tally file creation process in the form management system 100 will be described.
FIG. 3 is a flowchart of the tally file creation process according to this embodiment.
In S10, the control unit 30 of the quality management system 3 receives the master data received from the requester. The control unit 30 may store the master data received from the client in a master data server (not shown) that can communicate with the quality management system 3, and may receive the master data from the master data server. It may be directly read from the storage medium of the master data received from.
The master data is data including personal information of the destination, and there is a request for storage for a certain period. Therefore, it is desirable to store the data in another segment area with a high security level for centralized management.

In S11, the control unit 30 performs inspection item file creation processing and creates an inspection item file from the master data. One inspection item file is created for the master data received from the client. Here, the inspection item file is data used for registering in the quality management DB 41 data indicating that each shipment is in an uninspected state. Then, by registering the inspection item file in the quality management DB 41, the quality management DB 41 has inspection items such as whether the front and back sides of the form are correct and the number of sheets is correct.
In the inspection item file creation process, after the master data is sorted by zip code, each data necessary for quality control is extracted. Each of the extracted data includes the requester identification information that is identification information for identifying the requester, the zip code, the sequence information that is identification information for managing the shipment, and the like, and is sorted by the zip code. Has been. Further, the inspection item file does not include personal information of the destination.
In S <b> 12, the control unit 30 transmits the created inspection item file to the tally file creation system 1.

In S13, the control unit 30 counts the number of data items of the created inspection item file and determines whether the number is over 10,000. When the number of data items exceeds 10,000 (S13: YES), the control unit 30 moves the process to S14. On the other hand, when the number of data is 10,000 or less (S13: NO), the control unit 30 moves the process to S15.
In S14, the control unit 30 performs a dividing process for dividing the inspection item file into units of 10,000. This takes into account the load distribution when registering the inspection item file in the quality management DB 41. In addition, by performing this division processing after transmission to the tally file creation system 1, it is possible to prevent the inspection item file created for each client from being expanded into a plurality of files and being unable to be managed for each client. Can do.
In S15, the control unit 30 registers the inspection item file in the quality management DB 41 when the number is 10,000 or less, and the inspection item file after the division processing when the number is more than 10,000. Then, the control part 30 complete | finishes this process.

On the other hand, in S20, the control unit 10 (data arrival monitoring unit 11) of the tally file creation system 1 performs an arrival monitoring process for monitoring the arrival of the inspection item file transmitted from the quality management system 3.
In S21, the control unit 10 (data arrival monitoring unit 11) determines whether or not the arrival of the inspection item file has been detected. This can be determined based on whether or not an arrival folder of the inspection item file is determined in advance and the file has arrived there. When the arrival of the inspection item file is detected (S21: YES), the control unit 10 moves the process to S22. On the other hand, when the arrival of the inspection item file is not detected (S21: NO), the control unit 10 moves the process to S20.
In S22, the control unit 10 (tally file creation unit 12) performs tally file creation processing. In the tally file creation process, the zip code and sequence information included in the inspection item file are extracted. Then, from the extracted zip code and the sequence information, the number of data items for each zip code (first 5 digits), that is, the number of shipments is totaled in units of shipments. Then, a tally file 22 composed of the zip code and the total number of data items is created.

  In S23, the control unit 10 determines whether or not the tally file 22 has been created. The control unit 10 (tally file creation unit 12) can create the tally file 22 when the inspection item file conforms to the format of the tally file creation process. However, if the inspection item file is an empty file or does not conform to the tally file creation processing format, the tally file 22 cannot be created. If the tally file 22 can be created (S23: YES), the control unit 10 moves the process to S24. On the other hand, when the tally file 22 cannot be created (S23: NO), the control unit 10 moves the process to S24e.

In S <b> 24, the control unit 10 stores the tally file 22 in the tally file storage unit 21. The tally file creation unit 12 includes the file name of the created tally file 22 including the requester identification information acquired from the inspection item file and the file creation date.
On the other hand, in S24e, the control unit 10 performs notification processing. The notification process is performed by causing the notification unit 27 to notify the control unit 10. Thereafter, the control unit 10 ends the process.
In S25, for example, when an operator who attaches the tally 8 to the bundle 9 of shipments issues a print output instruction via the input unit 25, the control unit 10 outputs the tally file 22 to the printer 7, The printer 7 creates the tally 8. Then, the control part 10 complete | finishes this process.

  Separately from the processing of the tally file creation system 1 described above, the form creation system 5 creates a bundle 9 of shipment items from the master data to the destination for each delivery destination, from the printing of the form to the classification for each postal code of the shipment. doing. The worker can ship the bundle 9 of shipments by attaching the tally 8 corresponding to the bundle 9 of shipments to the bundle 9 of shipments.

Next, an example of the display unit 26 and the notification unit 27 in the processing of the tally file creation system 1 will be described.
FIG. 4 is a diagram illustrating a screen example and a notification example of the tally file creation system 1 according to the present embodiment.
FIG. 4A shows a screen example when the tally file 22 can be created (S23: YES in FIG. 3). The display unit 26 displays a monitoring screen 26a. The monitoring screen 26a includes a folder path display unit 26b and a log display unit 26c. The folder path display unit 26b displays a path of a folder for monitoring arrival of a predetermined inspection item file, a path of a folder for storing the processed tally file 22, and the like. The log display unit 26c displays the processing status of the tally file creation process. In this example, the log display unit 26c checks the format of the inspection item file after the arrival of the inspection item file, creates the tally file 22, and indicates that the creation has been completed and the destination of the used inspection item file. Is displayed. The used inspection item file is stored for a certain period of time and used, for example, when making an inquiry from the client.
In FIG. 4A, the tally file 22 has been successfully created, so the notification unit 27 is not operating.

On the other hand, FIG. 4B shows a screen example when the tally file 22 cannot be created (S23: NO in FIG. 3). The log display unit 26c displays that the tally file could not be created and the destination of the used inspection item file. And the alerting | reporting part 27 turns on and rotates a light and alert | reports (S24e of FIG. 3).
Therefore, for example, the operator of the tally file creation system 1 switches from the “log” tag of the log display unit 26 c to the “error log” tag by notification by the notification unit 27, for example, an inspection item file is an empty file The cause of the error such as Therefore, the worker can take measures such as executing the tally file creation process again.

Next, a tally file creation process in the form management system 100 performed at a timing different from that described above will be described.
FIG. 5 is a flowchart of the tally file creation process according to the present embodiment.
In S <b> 30, the control unit 30 of the quality management system 3 receives status data, which is the processing result of each process in the form creation system 5, from the form creation system 5 and updates the quality management DB 41 as needed. Do. Here, in the form creation system 5, the master data received from the requester is used to perform each process from printing, processing, enclosing the form, and sorting the shipment enclosing the form, and sending the status data in each process. To do.
In S <b> 31, the control unit 30 determines whether or not each step (pre-shipment processing) up to the sorting of the shipment in which the form is enclosed in the form creation system 5 is completed. Whether or not each process is completed can be grasped by the control unit 30 confirming the inspection items in the quality management DB 41. When each process is completed (S31: YES), the control unit 30 moves the process to S32. On the other hand, when each process is not completed (S31: NO), the control unit 30 moves the process to S30 and waits for an update to each process in the quality management DB 41.

In S32, the control unit 30 extracts data from the quality management DB 41 and creates an inspection item file. The inspection item file created here has the same data format as that created from the master data (see FIG. 3). The control unit 30 creates, as an inspection item file, data in which the process up to the sorting of the shipment is completed. Therefore, the data of the inspection item file does not include, for example, the damaged paper portion that cannot be printed due to a paper jam in the printing process or has become defective.
In S <b> 33, the control unit 30 transmits the created inspection item file to the tally file creation system 1. Then, the control part 30 complete | finishes this process.
On the other hand, the processing from S40 to S45 of the tally file creation system 1 is the same as the processing from S20 to S25 in FIG. The file name of the created tally file 22 includes identification information indicating that it has been created in a later process, in addition to the requester identification information and the file creation date.

Thus, according to this embodiment, there are the following effects.
(1) The tally file creation system 1 can create the tally file 22 by diverting the inspection item file created by the quality management system 3 and used for quality management of the form generation. By attaching the tally 8 on which the tally file 22 is printed to the bundle 9 of the shipment, it is possible to receive a discount when sending the shipment.
Since the inspection item file is used instead of the master data when the tally file 22 is created, the tally file creation system 1 does not need to manage the master data and can easily manage the data.
In addition, since the inspection item file is used, even if the master data is in a different format for each client or master data from a new client, regardless of the format difference or whether it is new You can create a tally file.
Since the inspection item file used by the tally file creation system 1 does not include personal information, security is improved. Moreover, since the inspection item file having fewer data items than the master data is used, the network load for transmission to the tally file creation system 1 can be reduced. Further, the tally file creation processing load can be reduced.
After the inspection item file is created by the quality management system 3, it is transmitted to the tally file creation system 1, and the tally file creation system 1 can create the tally file 22 after detecting the arrival of the inspection item file. Therefore, the tally file creation system 1 can automatically create the tally file 22.

(2) The tally file creation system 1 uses an inspection item file which has a large number of data and needs to be divided when it is registered in the quality management DB 41, before being divided. Therefore, since there is one inspection item file for each client, it is not necessary to handle a plurality of files. Further, since the inspection item file is created for each master data, it is possible to send out a form for each client.
(3) In the tally file creation process (part 2) described with reference to FIG. 5, the inspection item file is extracted from the quality management DB 41 in response to the normal process before the shipment is shipped, and the inspection item is extracted. You can use the file. Therefore, even if there is a defect such as broken paper in the middle of printing, the tally file 22 that matches the number of items to be shipped can be created.
(4) Since the file name of the tally file 22 is created including the requester identification information and the file creation date, the tally file 22 can be easily managed. Then, in the process of printing the tally file 22, it can be easily understood by the operator who attaches the tally 8 to the bundle 9 of shipment items, which tally 8 corresponds to which bundle 9 of shipment items. Therefore, work mistakes by the operator can be reduced.

  As mentioned above, although embodiment of this invention was described, this invention is not limited to embodiment mentioned above. In addition, the effects described in the embodiments are merely a list of the most preferable effects resulting from the present invention, and the effects of the present invention are not limited to those described in the embodiments. In addition, although embodiment mentioned above and the deformation | transformation form mentioned later can also be used combining suitably, detailed description is abbreviate | omitted.

(Deformation)
(1) In the present embodiment, the tally file 22 created in the tally file storage unit 21 of the tally file creation system 1 is described as being stored. However, the created tally file may be transmitted to a tally file server (not shown) that can communicate with the tally file creating system, and the tally file may be managed and printed by the server.
(2) In the present embodiment, the tally 8 for each zip code is created. However, for example, even if each courier service provider has a similar discount service, it may be created for each area identification information uniquely provided by each courier service provider.

(3) In this embodiment, the tally file 22 is created using the inspection item file before registration in the quality management DB 41 (hereinafter referred to as pre-processing creation), and the data is extracted from the quality management DB 41 and created. A description has been given of the creation of the tally file 22 using the inspection item file (hereinafter referred to as post-processing creation). However, the tally file may be created at either timing.
Further, the description has been given assuming that the file name of the tally file 22 is changed according to the creation timing of the tally file 22. However, a tally file having the same file name may be created for pre-processing creation and post-processing creation. Further, the contents of the tally file having different creation timings may be collated, and the tally file created after processing may be stored with the file name including the collation result.

(4) In the present embodiment, the form creation system 5 has been described as performing form printing, processing, enclosing, and sorting shipments enclosing forms. However, there may be other processes related to form creation, such as postcards that do not require sealing, those that do not have any processing, and those that have reprinting, and there may be processes that do not.
(5) In the present embodiment, a warning light has been described as an example of the notification unit 27. However, the notification unit may output a warning sound or cause the display unit to display a warning. Further, the notification unit is not essential.

DESCRIPTION OF SYMBOLS 1 Tally file creation system 3 Quality management system 5 Form creation system 7 Printer 8 Tally 9 Bundle of dispatched items 10, 30 Control unit 11 Data arrival monitoring unit 12 Tally file creation unit 15, 35 Communication I / F unit 20, 40 Storage unit 21 Tally file storage unit 22 Tally file 25 Input unit 26 Display unit 27 Notification unit 41 Quality management DB
100 form management system

Claims (4)

A tally file creation system that creates a tally file for printing tally attached to a shipment classified by region identification information using an inspection item file that does not include personal information of a destination,
The inspection item file is created by a quality control system,
By registering the inspection item file in the quality management database of the quality management system, the quality management system sorts the printed form from the printing of the form for each destination using the destination data received from the requester. Manage each process of the shipment until the aggregate creation
Connected to the quality management system via a communication network;
A data arrival monitoring unit that monitors the arrival of the inspection item file transmitted from the quality management system;
In response to detection of arrival of the inspection item file by the data arrival monitoring unit, the tally file in which the number of data is counted for each area identification information included in the inspection item file, and the area identification information and the number of cases are associated with each other. A tally file creation section for creating
Providing
Tally file creation system characterized by In the tally file creation system according to claim 1,
The inspection item file monitored by the data arrival monitoring unit is created for each requester, and is before being divided according to the number of data to be registered in the quality management database. ,
Tally file creation system characterized by In the tally file creation system according to claim 1 or 2,
The inspection item file monitored by the data arrival monitoring unit is extracted from the quality management database in accordance with normal pre-shipment processing of a form created using the destination data. ,
Tally file creation system characterized by In the tally file creation system according to any one of claims 1 to 3,
The tally file creation unit creates a file name of the tally file including requester identification information for identifying the requester included in the inspection item file, and a file creation date;
Tally file creation system characterized by

Images