JP6499944B2 - Route book creation system - Google Patents

Description

  The present invention relates to a route book creation system for creating a route book used for delivery of newspapers, milk, and other contract products.

  When delivering newspapers, milk, and other various contracted products, a route book is conventionally used for showing delivery routes in an easy-to-understand manner to delivery members.

  In the conventional route book, for example, as shown in FIG. 4 of Patent Document 1 below, customer names are displayed in the order of delivery, and customer names and customer addresses are displayed for each customer. This conventional route book is created and printed by a route book creation system based on a customer database.

  Also, in the case of a delivery person who is not accustomed to only the address notation, it is necessary to deliver while referring to the map book one by one, and the delivery efficiency is remarkably deteriorated, so the route from each customer to the next customer is shown conventionally. It is customary to manually add a route symbol mark (also referred to as “text mark” in industry terms) to the route book by hand, and such a route book shown in FIG. The route mark mark is added by handwriting.

Utility Model Registration No. 3095008

  However, when adding customers to be delivered or canceling contracts with existing customers, it is necessary to output the route book again, so it is very difficult to write the route symbol mark by hand each time the route book is output again In addition, it is necessary to rewrite all the route mark marks by hand again even though only a part to be corrected is used, and a lot of time is wasted.

  If a customer A has delivered to a nearby customer B, the route symbol mark from the customer A to the customer B should be written somewhere in the past route book. If the route symbol mark from customer A to customer B is not filled in, it is complicated to find the past route book, so the route symbol mark from customer A to customer B is referred to one by one with reference to the map book etc. Newly created and filled in.

  SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide a novel route book creation system capable of outputting a route book including a route symbol mark, thereby reducing the amount of office work and consequently reducing delivery costs.

  In order to achieve the above object, the present invention takes the following technical means.

That is, the route book creation system of the present invention is
A customer database for managing a plurality of unique customer IDs in order of delivery;
For each customer ID managed in the customer database, a route book ID that generates a route book ID that combines the customer ID and a customer ID whose delivery order is one before or after the customer ID. Generating means;
A route book ID database for managing an unspecified number of route book IDs in association with one or more route symbol codes corresponding to each route book ID;
A route book ID registration unit for newly registering the route book ID in the route book ID database when the route book ID generated by the route book ID generation unit does not exist in the route book ID database;
A route symbol code registration means for registering one or more route symbol codes corresponding to each route book ID in the route book ID database;
A route book output means for referring to the customer database and the route book ID database and outputting a route book including a route symbol mark corresponding to the route symbol code for each customer ID;
Is provided.

  According to the route book creation system of the present invention, the route book ID and the route symbol code are managed using the route book ID database separately from the customer database, so that the route once registered in the route book ID database. The book ID and its route code can be managed in the route book ID database even if the route book ID is deleted from the customer database. Therefore, for example, when a customer C is newly added in the middle of a delivery route from the customer A to the customer B, and then the contract period of the customer C is ended, and the delivery is performed again from the customer A to the customer B. Since the past route book ID from customer A to customer B and the corresponding route symbol code remain in the route book ID database, there is no need to newly create a route symbol code indicating the route from customer A to customer B. It is possible to reduce the amount of office work. In addition, since the route book ID is formed by combining two unique customer IDs, the route book ID is also unique and is not overwritten by the route between different customers. A route symbol code can be registered for each route between customers. Then, the route book output means outputs a route book including a route symbol mark for each customer, so there is no need to add a route symbol mark to the route book by hand, and a significant reduction in the amount of office work is achieved. be able to.

  In the route book creation system of the present invention, the customer database may be a customer master database that collectively manages a number of customers' names, addresses, areas, contract product types, contract periods, etc. It may be another database that manages the customer IDs of some customers extracted from the customer master database under predetermined conditions (for example, delivery areas and delivery products) in the order of delivery. The delivery order management method may be performed by sorting or rearranging the registration order on the database in the order of delivery, or delivery order information (delivery order code or the like) indicating the delivery order for each customer ID. It can also be managed by associating and registering. In the present invention, each database may be composed of one or a plurality of tables managed by a database system that is independently operated, or in a CSV format or other appropriate file format. It may be constituted by a stored data group.

  Further, the route book ID generation means, the route book ID registration means, and the route book output means may be constituted by a program created using an appropriate programming language such as C language or a database system built-in macro language. It is also possible to configure by using functions such as queries and mathematical expressions incorporated in the database system.

  Further, the route book ID registration means checks whether or not the generated route book ID exists in the route book ID database in conjunction with the generation of the route book ID by the route book ID generation means. The route book ID may be automatically registered in the route book ID database, or the generated route book ID is once registered in the customer database and periodically registered in the route book ID. The means verifies the consistency between the customer database and the route book ID database, and if the route book ID registered in the customer database is not registered in the route book ID database, the route book ID is registered in the route book ID database. The route book ID registered in the customer database by the user's operation is the route book ID database. Do the confirmation process has been registered, it may perform the process of registering the route book ID to the route directory ID database if it is not registered.

  Further, the route symbol code registration means automatically accepts the input of the route symbol code associated with the route book ID in conjunction with the new registration of the route book ID by the route book ID registration means, and the inputted route symbol The code may be associated with the route symbol ID and registered in the route book ID database, or only the route book ID is once registered in the route book ID database, and then at a predetermined timing (for example, by the user) When a route code ID specified by the user or a route book ID for which a route code code is not registered is received, an associated route symbol code is input and the entered route symbol is received. The code may be associated with the route book ID and registered in the route book ID database. Further, the route symbol code may be configured to be input or selected by the user, or by referring to another appropriate database, the route symbol code corresponding to the route book ID is obtained, It can also be configured to register this in the route book ID database.

  Further, the route book output means typically prints out on paper, but may display and output the route book on the screen of a tablet terminal or other electronic terminal. Further, the present invention does not limit the format of the route book to a specific form, and the output form of the route book may be appropriate, for example, it may be output in the form of a form (table). Alternatively, it may be output in the form of a card for each customer.

  In the route book creation system of the present invention, a route symbol database for associating and managing a route symbol mark corresponding to each route symbol code, a new route symbol code and a route symbol mark associated therewith A route symbol registration means for newly registering in the database may be further provided, and the route book output means is configured to extract a route symbol mark corresponding to each route symbol code by referring to the route symbol database. Can do. According to this, it is possible for the user to arbitrarily additionally register a route symbol code that is easily understood by the user and output it to the route book. Instead of being managed in the database as described above, it is possible to use a character (font) that can be used by a computer as a route symbol mark and to use a character code of a route symbol mark as a route symbol code.

  Moreover, in the said route book creation system, a customer database links | relates and manages the route book ID produced | generated by the route book ID production | generation means for every customer ID, and a route book ID production | generation means is a customer database. When there is a change in the order of arrangement of a plurality of customer IDs, at least a route book ID corresponding to a customer ID that changes in the route book ID is generated and registered in the customer database so as to be associated with the customer ID. It's okay. Here, “when there is a change in the order of arrangement of a plurality of customer IDs” means not only a case where the arrangement order of a plurality of customer IDs already registered is changed, but also one or a plurality of customers already registered. This includes the case where the ID is deleted from the customer database and the case where a new customer ID is additionally registered.

  Further, the route book creation system of the present invention can further include a display screen, and the route symbol code registration means displays a plurality of route symbol marks on the display screen so as to be selectable, and a selection operation by the user has been made. A route symbol code corresponding to the route symbol mark may be associated with the route book ID in the order of selection and registered in the route book ID database. According to this, the route symbol mark registration process corresponding to one route book ID by the route symbol code registration means can be performed efficiently and visually intelligibly using the display screen. It is possible to improve input efficiency while reducing input mistakes.

  The route book ID registration unit is configured to use the registration information as it is when the route book ID generated by the route book ID generation unit is already registered in the route book ID database, for example, not to perform overwriting registration processing. It is preferable to do.

  According to the present invention, it is possible to efficiently create and output a route book including a route symbol mark by computerization, and to greatly reduce the office work burden of a delivery person such as a newspaper delivery and other clerk.

It is operation | movement explanatory drawing of the route book preparation system which concerns on one Embodiment of this invention. It is operation | movement explanatory drawing at the time of adding customer information in the same route book creation system. It is operation | movement explanatory drawing which shows the content of the customer database after customer information addition. It is a display screen which shows an example of a route symbol code registration means. It is a figure which shows an example of the route book output.

  A route book creation system according to an embodiment of the present invention can be configured using a personal computer, and includes a customer database, a route book ID database, and a route symbol database as illustrated in FIG. ing.

  The customer database is extracted from customer information managed by “dNEWS”, a customer management system manufactured by Duplo Corporation, according to appropriate extraction conditions such as contract period, store, delivery area, route number, delivery newspaper type information, etc. In this embodiment, a unique customer ID assigned to each customer, a delivery order code assigned so as to be in ascending order of customer delivery, and customer It has name (name or name), customer address, and delivery product name (newspaper type) as basic management items, and associates and manages information corresponding to each customer ID as one record (row) It is. These basic management items are managed by the customer management system, and a plurality of customer IDs are already managed in the order of delivery when they are output as a customer database.

  In addition, the customer database has a code for disassembling and registering the previous customer ID, (own) customer ID, route book ID, route symbol code group, route symbol code group as each extended code as an extended management item. 1 to code 5 (a plurality of route symbol codes), a mark 1 to a mark 5 (a plurality of route symbol marks) for registering marks corresponding to each code, and a route symbol mark formed by combining all marks These extended management items are also managed in association with each customer ID. This customer database can be configured by a CSV format file or the like, and can also have a conventionally known appropriate configuration such as a relational database system. In the illustrated example, five route symbol codes and five route symbol marks are configured to be registered. However, the number of these codes and marks is not particularly limited, and can be determined according to the user's request or the like. It is possible to make it possible to register 10 codes, to register 20 codes, or to register an appropriate number of codes and marks.

  In the route book creation system of this embodiment, for each customer ID managed in the customer database based on the customer ID and delivery order code of the basic management item, the delivery order is based on the customer ID and the customer ID. A route book ID generation program (route book ID generation means) that generates a route book ID formed by combining the previous customer ID is provided. When the route book ID generation program is executed, it reads the basic management items of the customer database, and for each customer ID, the customer ID information whose delivery order is one previous item is added to the extended management item “1 item” of the customer ID record. In addition to registering in the “previous customer ID”, the customer ID information is also registered in the extended management item “customer ID”, and the information registered in “previous customer ID” and “customer ID” is combined. A route book ID is generated and registered in the extended management item “route book ID”. As a delimiter, “A” is added to the first character of the route book ID, and “B” is added between “the previous customer ID” and “customer ID”. Thus, even when the number of digits of the customer ID is not constant, a unique route book ID is always generated from the two customer IDs, and the route book corresponding to the first customer ID in the delivery order The ID is clearly distinguishable from the others by making the letters “AB” and English letters continuous.

  The route book ID generation program can be configured in C language or other appropriate programming language. When managing a customer database by a relational database system, spreadsheet software, or the like, it is also possible to generate and register a route book ID by a mathematical formula embedded in a table, a macro program, or the like. Further, the route book ID generation program may be an internal program integrated with the customer management system.

  The route book ID generation program may be executed at an appropriate timing. If the integrated program of the customer management system, the transition of customer information may be constantly monitored to generate the route book ID in real time. The route book ID may be generated when a predetermined operation or process for updating the ID is performed. Even in the case of an external program, the directory book ID can be generated and updated in real time by constantly monitoring the directory where the customer database is stored, or the route book ID can be updated when a predetermined operation or process is performed. Can be generated and updated or newly registered.

  In this embodiment, as shown in FIG. 2, another route book ID database that manages each route book ID generated by the route book ID generation unit and registered in the customer database, and the route book ID generation unit generate the route book ID. When the route book ID does not exist in the route book ID database, a route book ID registration program (route book ID registration means) for newly registering the route book ID in the route book ID database, and a route symbol code registration program (route symbol code) Registration means). These route book ID registration program and route code code registration program may be internal programs integrated into the customer management system or external programs, as with the route book ID generation program.

  The route book ID database manages an unspecified number of route book IDs in association with a route symbol code group (one or a plurality of route symbol codes) corresponding to each route book ID. The route symbol code group is formed by combining route symbol codes composed of a three-digit number string up to a predetermined number (five in the illustrated example), that is, from 0 to a predetermined number (for each route book ID). For example, any number of route symbol codes up to 5) can be registered.

  The route book ID registration program is executed, for example, at a predetermined route book ID maintenance date or time, or is executed by a user's execution operation or the like, and detects a route book ID that exists in the customer database but does not exist in the route book ID database. Then, the route book ID that does not exist in the route book ID database is newly registered in the route book ID database. For example, in the example shown in FIG. 2, the customer ID “2000” (Hachiro Yoshida) is added to the customer database, so that the route book ID “A10001B20000” corresponding to the customer ID 2000 is newly generated, and this addition The route ID “A20000B16487” of the customer ID “16487” (Saburo Suzuki), which is the next delivery order of the registered customer ID, is also newly generated, and the new route book ID is registered in the customer database. ing. When the route book ID registration program is executed in this state, it is determined that these new route book IDs do not exist in the route book ID database, and these new route book IDs are newly registered (additional registration) in the route book ID database. ) At this time, the user can be prompted to input a route symbol code group corresponding to the new route book ID, but in this embodiment, the route symbol code group is configured to be registered at a separate opportunity as described later. ing.

  The route symbol code registration program is executed, for example, once a week at a predetermined route symbol code maintenance date or time, or is configured to be executable by a predetermined execution operation by a user. A route book ID in which no group is registered is searched, and for each route book ID, a route symbol code registration screen including a number of selectable route symbol marks as shown in FIG. 4 is displayed on the computer display (display screen). When the user selects and selects a route symbol mark to be registered using a mouse or a keyboard, the route symbol codes corresponding to the route symbol mark for which the selection operation has been performed are selected in the selected route book. In association with the ID, it is registered in the route book ID database. In the illustrated example, a code (image ID) 014 and a code 018 are sequentially selected. In this case, “014018” obtained by combining these two codes is associated with the route book code. It becomes. Note that an “Erase 1” icon is also displayed on the registration screen. When the icon is selected, one route symbol mark that has already been selected is deleted. In addition, a “registration end” icon is also displayed. When the icon is selected, the registration process is completed, and the route symbol code group selected at that time is registered in the route book ID database. Such registration processing is performed for all route book IDs for which the route symbol code group is not registered.

  Note that the route book ID ("AB19864" in the illustrated example) corresponding to the first customer ID in the delivery order is configured not to register the route symbol code group because it is not necessary to register. Basically, the route book ID once registered is configured not to be deleted from the route book ID database, thereby accumulating route symbol codes from a specific customer to another customer.

  Further, the correspondence between each route symbol code and the route symbol mark is managed by yet another route symbol database, and the route symbol code registration program refers to the route symbol database and is illustrated in FIG. It is configured to generate and display a registration screen. In this embodiment, a new route symbol code that does not exist in the route symbol database and a route symbol mark associated therewith can be newly registered in the route symbol database by a further route symbol registration program (route symbol registration means). The system is configured as follows. The route symbol registration program can be configured appropriately. For example, when a route symbol code is specified and executed, an icon editor for creating a route symbol mark is launched, and an arbitrary mark can be created and registered. Can be configured. Further, the route symbol registration program can be configured to be able to additionally register icon images separately provided by download or CD-ROM.

  Further, the route book creation system of this embodiment refers to the customer database and the route book ID database, and outputs a route book including a route symbol mark corresponding to the route symbol code for each customer ID. A book output program (route book output means) is provided. The program can also be realized as an internal program integrated with the customer management system, or as a single external program.

  When the route book output program is executed, a route symbol code group corresponding to each route book ID registered in the customer database is called (extracted) with reference to the route book ID database. Copy to the "Group" item. Further, the route symbol code group is separated into three-digit route symbol codes, and sequentially registered in “code 1” to “code 5”, and the route symbol database is referred to for each registered route symbol code. Corresponding route mark marks are called up and registered sequentially in “mark 1” to “mark 5”. For each customer ID, the route symbol marks registered in “mark 1” to “mark 5” are combined and registered in the “route symbol mark” item in the rightmost column. As shown in FIG. 1, the route book is printed out or screen-outputted in a form including a basic management item of the customer database and a “route symbol mark” item.

  Therefore, as shown in FIG. 2, when a new customer ID is registered, the new customer ID and its new group ID are registered until the route code code group corresponding to the new route book ID is registered by the route code code registration program. For the customer ID after one case, the route symbol mark is not output to the output route book. However, only in this case, the route symbol mark may be added to the route book by handwriting. After registering the route symbol code group by regular maintenance or temporary maintenance, as shown in FIG. 3, the route symbol mark can be output to the route book for the new customer ID and the customer ID after that. Moreover, in this embodiment, since the route book ID is generated by combining two customer IDs whose delivery order is before and after the delivery order, the two customer IDs are the same when the route is largely changed. In addition, the route book ID when the delivery order becomes different is also different from the route book ID before the change, and the route symbol mark can be individually managed for each delivery order of two specific customers.

  In addition, the output format of a route book may be an appropriate one. For example, as shown in FIG. 5, a route book including a route symbol mark in a card format can be output for each customer ID.

  The route book output program does not necessarily need to update the customer ID whose route symbol code group is already registered in the customer database with reference to the route book ID database, but in order to reflect the latest registration information. At the time of output, it is preferable to call and update the route symbol code group from the route book ID database for all customer IDs.

  The present invention is not limited to the above-described embodiment, and the design can be changed as appropriate. For example, in the above-described embodiment, the route symbol mark from the previous customer is displayed for each customer output to the route book, but the route symbol mark to the customer after the first case is displayed. Also good. Each of the above programs may be another completely independent program, or may be an internal program in one integrated application program. Further, although the customer ID managed by the customer management system is used as it is as the customer ID, the customer ID for outputting the route book different from the customer ID managed by the customer management system is generated and managed. May be.

Claims (4)

A customer database for managing a plurality of unique customer IDs in order of delivery;
For each customer ID managed in the customer database, a route book ID that generates a route book ID that combines the customer ID and a customer ID whose delivery order is one before or after the customer ID. Generating means;
A route book ID database for managing an unspecified number of route book IDs in association with one or more route symbol codes corresponding to each route book ID;
A route book ID registration unit for newly registering the route book ID in the route book ID database when the route book ID generated by the route book ID generation unit does not exist in the route book ID database;
A route symbol code registration means for registering one or more route symbol codes corresponding to each route book ID in the route book ID database;
A route book output means for referring to the customer database and the route book ID database and outputting a route book including a route symbol mark corresponding to the route symbol code for each customer ID;
Route book creation system with   In the route book creation system according to claim 1, a route symbol database for associating and managing a route symbol mark corresponding to each route symbol code, a new route symbol code, and a route symbol mark associated therewith Route symbol registration means for newly registering in the route symbol database, and the route book output means is configured to extract a route symbol mark corresponding to each route symbol code by referring to the route symbol database. A route book creation system characterized by   3. The route book creation system according to claim 1 or 2, wherein the customer database associates and manages the route book ID generated by the route book ID generation means for each customer ID, and the route book ID generation means. Is registered in the customer database so as to generate a route book ID corresponding to a customer ID in which at least a change in the route book ID occurs and associate it with the customer ID when there is a change in the order of arrangement of a plurality of customer IDs in the customer database. A route book creation system characterized by being configured to do.   4. The route book creation system according to claim 1, 2, or 3, further comprising a display screen, wherein the route symbol code registration means displays a plurality of route symbol marks on the display screen so that a selection operation can be performed by the user. A route book creation system configured to register a route symbol code corresponding to a route symbol mark made in the route book ID database in association with the route book ID in the order of selection.

Images