AC DPA 5160 PWO October 6, 2 004
537657
METHOD AND DEVICE FOR THE TRANSMISSION OF NOTIFICATIONS
Description:
The invention relates to a method for the transmission of notifications by means of a notification component to users of an electronic parcel compartment system within a postal shipping system in which data from at least one database is 10 transmitted to a central sending component, where it is converted into notification information and the notification information is transmitted to a communication interface and from the communication interface to at least one receiving device, whereby notification jobs are stored in a storage 15 module and at least some of the requests for the transmission of notifications are transmitted by a control circuit to the storage module and a reading module acquires the notification jobs contained in the storage module and transmits them to the central sending component.
The invention also relates to a device for the transmission of notifications to users of an electronic parcel compartment system within a postal shipping system having at least one database, one central sending component and one communication 25 interface for the transmission of the notification information to receiving devices.
The invention relates especially to a method and to a device for informing senders or recipients of mailpieces about the 30 status of the shipment.
A method of the generic type is disclosed in French Patent FR 2 563 987. With this prior-art method, information about the
2
filling status of an electronic parcel compartment system is stored in a database of a server and can be retrieved from there.
Another notification method of the generic type is known from U.S. Pat. No. 5,790,974. With this method, two separate databases, each containing calendar information, are connected to each other and each contain software agents that allow a data comparison between the databases.
Another method of the generic type is known from U.S. Pat. No. 6,064,976. This method checks whether a user is present in a predetermined area. If the user is present in the area,
then the actual arrival time of the user and an estimated 15 arrival time of the user are compared to each other.
Moreover, U.S. Pat. No. 6,047,264 discloses a method for the transmission of the status of a shipment of a user in which an entry is generated in a central database when a user 20 orders a shipment. If the status of the shipment changes, for example, when it is transferred to a delivery company, when it is transported to different stations or when it is dropped off at the destination, the status change is recorded in the database. This recording can be done manually or 25 electronically. A notification component continuously uses a query module to query status changes in the database and generates messages to the appertaining users about a shipment for which the status has changed. The notification is preferably done by e-mail.
It is therefore an object of the present invention to provide an improved method and/or device for the transmission of notifications to users of an electronic parcel compartment
We lie ct^ilaT"p r q pebty ofi ce|
iir »J .7
- \ i\P\{ 2005
WO 2004/019242 PCT/DE2003/002666
2a system within a postal shipping system; or at least to provide the public with a useful choice.
In particular, the invention should be suitable for the 5 transmission of individual notifications to numerous users of an electronic parcel compartment system.
According to the invention, the objective is achieved by a method and by a device according to Claims 1 and 3.
Here, a method of this generic type is carried out in such a way that a method of the generic type is carried out in such a way that data from at least one database is transmitted to a central sending component (ZVK), where it is converted into 15 notification information, and in that the notification information is transmitted to a communication interface and from the communication interface to one or more receiving devices.
An especially preferred embodiment of the invention is characterized in that, using at least one template, the central sending component converts the data transmitted from the database into the notification information. The template is created, for example, on the basis of XSL:FO (extensible 25 Stylesheet Language Formatting Objects). It is especially advantageous to add data to a template.
It is especially advantageous for a control circuit to control the transmission of notification information.
The job requests for the transmission of notifications are transmitted at least partially by a control circuit.
'•'i-Vi Frfn Al~"^ 0PERTV~0FFiCE
T -M.7
-1 APR 2005 DECEIVED
AC DPA 5160 PWO
2b
Here, it is especially advantageous for at least some of the requests for the transmission of notifications to be transmitted by the control circuit directly to the central sending component.
In order to allow a notification of users at prescribed times and/or to utilize data transmission capacities more efficiently, it is advantageous for at least some of the
3
requests for the transmission of notifications to be transmitted by the control circuit directly to the central sending component
In order to allow a notification of users at prescribed times and/or to utilize data transmission capacities more efficiently, it is advantageous for at least some of the requests for the transmission of notifications to be transmitted by the control circuit to a storage module that serves to store notification requests.
An especially advantageous variant of this embodiment is characterized in that a reading module acquires the notification jobs contained in the storage module and transmits them to the central sending component.
Moreover, it is advantageous for information for creating jobs to be transmitted via an external interface.
In this manner, it is possible to enter externally determined
values and thus to control the sending of messages.
>
Such an integration of externally transmitted information is advantageous especially when the invention is used in a shipping logistic system. In this manner, information that is relevant 25 for the logistic process, especially about the arrival of shipments, for example, mailpieces, at prescribed destinations, can be acquired and integrated into the notification system.
An especially preferred application case in this context is the 30 use of the notification component within a postal shipping system. For example, when a mailpiece is dropped off in a compartment of an electronic parcel compartmen
OF N.7
-1 APR A®
RECEIVED
4
tion is automatically transmitted to the external interface. The external interface forwards this information. This information, or a request derived from it to transmit a message, is forwarded to one or more recipients.
It is especially advantageous for information used to create jobs to be transmitted via an external interface.
Here, it is especially advantageous to carry out the method in ^|0 such a way that the information for creating jobs is transmitted from the external interface to the control circuit.
Moreover, the invention comprises a logistic system with at least one means to transmit notifications to users of the 15 logistic system.
This logistic system is characterized in that the means for the transmission of the notifications is configured in such a way that it can cooperate with at least one database (KT, PD, AD) 20 and with a central sending component (ZVK), in that the central sending component (ZVK) is configured in such a way that it can convert data from the database (KT, PD, AD) into notification information (BI) , and in that the central sending component (ZVK) is connected to a communication interface for the transmission 25 of the notification information (BI) to receiving devices.
Additional advantages, special features and practical refinements of the invention ensue from the subordinate claims and from the presentation below of preferred embodiments making 30 reference to the drawings.
INTELLECTUAL PROPERTY OFFICE OF i\i.Z
-1 APR 2005
RECEIVED
The drawings show the following:
Figure 1 component view of the notification system,
Figure 2 status diagram for requests to transmit messages,
Figure 3 sequence diagram I - new event
Figure 4 sequence diagram II - reading out the pending notifications
Figure 5 sequence diagram III - sending the notification
Figure 6 sequence diagram IV - storing the result.
The use of the methods and devices for notification according to the invention will be described below.
The presented notification components are shown with reference to the example of the notification of users of a logistic system, especially of a transportation system for mailpieces.
The invention is limited neither to the depicted embodiments nor to the use in a logistic system. However, it is especially advantageous to equip a logistic system with the notification components described.
Figure 1 shows constituents of a notification component that is integrated into a shipping logistic system.
6
The notification component comprises an external interface EI for receiving event data ED of the shipping logistic system.
The external interface EI is connected to a control circuit AL. 5 The control circuit AL is equipped with transmission means for the transmission of job requests to the central sending component (ZVK) and to the Communication Request Queue CRC.
The Communication Request Queue CRC is preferably configured as a storage module that serves to store notification jobs. The storage module that serves to store notification jobs is connected to a reading module CR.
The reading module CR is connected to the central sending 15 component (ZVK) via a data line.
The notification component has an external interface into which jobs are entered in a message queue. These jobs are regularly read out in a timer-controlled manner by the central component 20 in order to supplement data from the customer database, parcel database or machine database, and these jobs are converted by means of various templates into a push-oriented means for the transmission of information, for example, an e-mail or SMS, and then sent via a suitable communication interface, preferably an 25 e-mail and SMS gateway.
Externally retrievable functions
Database access
7
The database is accessed using suitable access means, preferably based on EJB technology via Java Entity Beans.
Here, the access to the databases is transparently encapsulated. A database entry identified via the PRIMARY KEY is read in, by 5 creating the home interface of a bean and by subsequently searching with "ejFindByPrimaryKey".
The terms customer database, parcel database and machine database are of an abstract nature, the appertaining information ^O relates only to one or more tables within the same database instance. Through the use of the EJB, however, a separation into various instances or even databases can be carried out at a later point in time in a transparent manner.
Communication to the e-mail / SMS gateway
The communication between the notification component and the e-mail or SMS gateway is effectuated via the standard Java classes for SMTP communication.
Logging
Errors in sending e-mails or SMSs also have to be logged in an error LOG file. These error LOG files have to be monitored regularly, for example, in order to be able to ascertain the failure of a gateway. If all of the sent notifications are like-25 wise to be logged, then a separate LOG file is used for this purpose so as to simplify the error monitoring.
Design proposals and limitations
Database
Existing databases
8
In order to achieve a smooth transmission of the notifications, access to the following databases of the logistic system has to be ensured:
Customer database: provides information about a customer,
identified by the customer number Parcel database: provides information about a parcel,
identified by the unambiguous parcel number Machine database: provides information about the location of a machine, identified by the MachinelD. This is part of the ParcellD
Communication Request Database
It is advantageous to set up an additional database table to store the notifications that are to be sent. The table also serves as an intermediate storage for the second and third notifications to be sent. The table should only serve to administer the queue; concrete information about parcels and recipients are always read out of the customer database or out of the parcel database.
Field
Description
Type
Example
Internal fields that are needed to effectuate the shipment
ID
Unambiguous key for the identification of the entries, is generated internally
NUMBER (16)
PRIMARY KEY
InsertDate
Date of the entry into the queue, is generated internally
DATE
CompletionDate
Date of the complete processing
DATE
INTELLECTUAL PR0PF
1TY OFFiCE
OF N.Z
-1 APR 2005
RECEIVED
9
(status = 2) or failure (status = 9
RetryCount
Number of failed previous attempts
NUMBER (13)
State
Status of the request
NUMBER (3)
1 = new
2 = processed (complete)
3 = in process (logged)
9 = faulty
State
Status of the request
Number (3)
1 = new
2 = processed (complete)
3 = in process (logged)
9 = faulty
Externally prescribed fields
Communication-Type
Indicates the route of communication
VARCHAR (12)
SMS,
PlainText, User (= preferred method stored for the user) (can be augmented by FAX, PAGER, HTMLMail, RFC1149,
etc. )
SendDate
Date and time of day, after which the sending should take place
DATE
RecipientID
User ID of the recipient
VARCHAR (16)
LP_4711, LC_12 34, US 0815
ParcellD
Parcel number (can be blank)
VARCHAR (16)
Template
Name of the template to be used
VARCHAR (12)
BNKl, BNK2 , BNK3
Communication flags
Parameters for controlling the
NUMBER (8)
CheckParcel-InMachine
-1 APR 2005
RECEIVED
shipment, they are set by the B2B component so that, in case of later queries, it is possible to logically follow the decisions made in the Client Logic
DelaySMS-Sending
Preferred sequence diagrams are depicted below:
Figure 3 shows a sequence diagram for a new notification event, 5 for example, the placement of a parcel in a compartment of a parcel compartment system.
This event is transmitted to a message generating unit MQW. A request for the transmission of user data is sent by the message 10 generating unit MQW to a database for administering the user data B2BRM. The database for administering the user data B2BRM sends the information about the user and the appertaining data to the message generating unit MQW. This information, together ^ with additional notification information, for example, about the 15 recipient and/or sender of the mailpieces that were placed into the parcel compartments or that can be picked up, is transmitted to a message storage unit MQWB.
The pending notifications can be read out in a push-oriented as 20 well as a pull-oriented manner.
In the following preferred embodiment of the reading out of notifications, the advantages of push-oriented handling of the information to be dealt with are combined with the advantages of 25 pull-oriented handling.
INTELLECTUAL ^PROPERTY OFFICE
-1 APR 20®
I ncr cn/pn
11
This embodiment provides that the notification is transmitted to the message storage unit on the basis of an event, in an especially preferred embodiment on the basis of a time signal that comes from a timer.
The MQR transmits a request for reading new entries to the message storage unit MQDB. The message storage unit MQP reads the entry information from a database and transmits shipment-specific information, especially an identification number for ^0 individual parcel compartments, or else mailpieces placed there (ParcellD), user identification information (UserlD) and/or information about the electronic parcel compartment system (MachinelD) to a storage module CRC that serves to store notification jobs. The storage module CRC forwards this 15 identification information to suitable recipients, for example, users C of the electronic parcel compartment system, to participants in the logistic system, or to the electronic parcel compartment system.
The named recipients, or data processing units acting on their ^ behalf, send a new data object to the storage module CRC that serves to store notification jobs. The storage module forwards the new object to the message storage unit MQDB. The message storage unit MQDB subsequently sends a new notification request.
Classes
An especially preferred embodiment of the invention is characterized by the use of different classes of notifications. Preferably, a distinction is made between virtual classes and 30 singleton classes.
INTELLECTUAL PROPERTY OFFICE OF iM.7
-1 APR 2005
RECEIVED
12
A message reading unit MQR reads the entries from the message queue, draws up Notification Request Data Container objects and forwards them to the Notification Factory instance.
Message Queue DB
The class serves as an encapsulation of the access to the database table with the message queue. It provides the following methods:
InitReader ()
^^0 GetNextEntry ()
AddEntry ()
Notification Request Data Container
The class is a data container for the entries in the message 15 queue and the stored data in the customer database, parcel database and machine database. The class provides Get/Set methods for all of the required fields.
Customer database
The class serves as an encapsulation of the access to the database table with the customer database. It allows the customer data to be read out on the basis of a CustomerlD.
Parcel database
The class serves as an encapsulation of the access to the database table with the parcel database. It allows the parcel data to be read out on the basis of a ParcellD.
Machine database
The class serves as an encapsulation of the access to the
database table with the machine database. It allows the machine data to be read out on the basis of a MachinelD.
INTELLECTUAL pr0pertv OFFICE OF N.7
-1 APR 2005
13
Notification Factory
This class is the central administration of the notification service provider interfaces. This is where a list of all existing notification service provider interfaces is 5 administered.
In addition to functions for the administration of the notification SPIs, it provides the method bool machet (Notification Request Data Container *) ^^0 that sends all of the necessary notifications for a transmitted Notification Request Data Container object. For this purpose, the Notification Request Data Container object is transmitted to all notification SPIs.
Base Notification SPI
This class is the base class for all notification implementations. It provides the bool machet (Notification Request Data Container *)
method to be overwritten that sends a notification (if this is 20 possible from the transmitted data and if this is desired).
^ First of all, there will be two implementations for sending PlainText e-mails and for sending SMSs. Additional implementations (for example, for HTML-formatted e-mail, pager, 25 fax, FunCard ...) can easily be added.
Plain text e-mail notification SPI
Implementation of the Base Notification SPI for sending plain text e-mails
SMS notification SPI
Implementation of the Base Notification SPI for sending SMSs
INTELLECTUAL PRQPERTV OFFICE OF i\i.7.
-1 APR 2005
n r ^ c i \/ c n
14
Class template database
This class allows access to templates on the basis of several keys.
Overview of member variables and member functions
Class name de.post24.notificationSystem.TemplateDB
Inherits from
Implements
Public methods
TemplateDB ();
String GetTemplate (String class, String type,
String locale, bool usedefault)
Specification of member variables and member functions
String GetTemplate (String class, String type, String locale,
bool usedefault)
Supplies a template corresponding the transmitted parameters
^ In class indicates the classification of the template
*5 (plain text e-mail, SMS)
In type indicates the type of template (registration,
change, NewParcel, NewCODParcel)
In locale serves to distinguish among different language and country versions (e.g. "de-DE" (German-Germany) or "en-US" (English-United States)
In usedefault here, it is possible to set whether a default language should be used if the rpqnopi-pd—
INTELLECTUAL PROPERTY OFFICE Qr !>J.£
-1 APR 2005
RECEIVED _
language does not exist, or else an empty string
Return the method supplies the appropriate template or else an empty string, if no appropriate template was found
Template formatter
This class serves to format the template with the data to be 00 transmitted. It provides a method:
String FormatTemplate (String template, Notification Request Data Container *, int maxlen,
String [] neededTokens )
All of the placeholders in template are replaced by corresponding values. If the maximum length is set at maxlen, field contents are abbreviated in order not to exceed this maximum length. In neededTokens, a list of placeholders can be transmitted whose existence is checked in the template.
In a logistic system involving a delivery and/or pick-up of parcels in electronic parcel compartment systems, the notification component serves especially to generate and send customer notifications. For this purpose, events such as cus-25 tomer registration, change of customer master data, parcel delivery and pick-up are reported via an interface. On the basis of stored information, the notification component creates one or more push-oriented notifications such as e-mails and/or SMSs and sends them via a suitable, preferably push-oriented interface, 30 for example, an e-mail or SMS gateway. Preferably, the notification component also monitors the parcel pick-up and optionally sends second and third notifications.
intellectual^roperty office
-1 APR 2005
dfHFIVED
16
The notification component according to the invention is an integral part of a logistic system according to the invention.
The notification component is preferably a modular constituent 5 of the logistic system. Preferably, the notification component contains automated notification procedures that contain at least individual constituents for an automation of the logistic system. Preferably, the entire process of the logistic system is integrated.
Preferably, the notification component is informed externally about events. The events are preferably categorized in different classes and each event triggers previously defined or definable and optionally variable processing steps by the notification 15 component. An example of such an external event is the placement of a parcel into an electronic parcel compartment system that is part of the logistic system.
The notification component ensures the transmission of all 20 notifications. These are the notifications to automated data processing units as well as to recipients. The notification can be sent once or multiple times, so that this automated notification component also allows the automatic sending of reminders.
In the manner described, the notification component allows a refinement of the logistic system, an adaptation to omissions and utilizations of the logistic system and especially an integration of essentially or completely automated components, 30 such as electronic parcel compartment systems, into the logistic system.
intellectual^r^r1"7 of,ce
-1 APR 2005
RECEIVED
17
List of reference numerals
AD
database
AL
control circuit
BI
notification information
CR
reading module
CRC
storage module
EI
external interface
KT
database
•
MQR
message reading unit
MQW
message generating unit
MQDB
message storage unit
PD
database
T1
template
T2
template
T3
template
ZVK
sending component
INTELLECTUAL PROPERTY OFICE OF N.7
-1 APR 2005
RECEIVED