US 6,457,012 B1Grant
Method and system of updating address records utilizing a clientserver interface
Issue Date:2002-09-24
•10 Claims
•6 Drawing Sheets
Abstract
The invention is a method and system of updating address data representative of a changed address. Updates are accomplished by initiating an address data request at a client system. The request is transmitted to an application host system where it is translated into a format readable by a master system comprising change of address files. The interface between the application host system and the master system includes a translation step. The translation step begins by creating a data map representative of the address data request. The created data map is compared against either a mailing list correction (MLC) scheme or a multi-line optical character reader (MLOCR) scheme to establish a second data map representative of the address request. The second data map is then transmitted via a SCSI interface to the master system for processing of the address request. The master system matches the address data request to records of address changes to determine whether a match exists. If a match occurs, then a record of the match is placed into an address data reply which is then transmitted back to the application host system where it is first translated and then transmitted back to the client for use in updating address files. The system is capable of printing one or more reports representative of the requests, replies, and/or statistics arising from the transactions.
Metadata
Assignee
- Pitney Bowes Inc.
Inventor
- Paul Jatkowski
Application Information
Application Number:US 08/872,435
Filing Date:1997-06-10
Priority Date:1997-06-10
Art Unit:7
Classifications
IPC:
G06F 1730
Field of Search:
707100707101707 10707104380 2537920136447812364478143644780723546224700226709217
Patent Drawings (6 sheets)
Description
Background of the Invention
[0002] The challenges of mail delivery within the United States and in the growing ranks of industrialized countries has grown so that, in the United States alone, the postal service delivers approximately 600 million pieces of mail per day. To the growing postal burden is added the requirements of keeping address data accurate in the face of a growing social mobility. To promote operating efficiency, the United States Postal Service (U.S.P.S.) has offered discounts for the use of 5 digit zip codes, bar codes, delivery point bar coding, and various forms of address coding such as those used on the Optional Endorsement Line of printed address blocks.
[0003] The most common form of coding is directed to the postal zip code. The basic elements of a postal zip code consist of four parts; these are: (i) the “zip code,” which consists of 5 digits and refers to geographic area or zone; (ii) the “zip plus 4” further breaks down a zip code region into smaller sub-regions, this consists of four digits added to the base zip code; (iii) “delivery point digits” which consist of two additional digits that further break down a zip plus 4 so that the U.S.P.S. can more accurately pin point an exact location; and, (iv) a check sum digit. The delivery point digits are extracted from the street line of the address using a U.S.P.S. approved algorithm.
[0004] But, the best coding systems available are of little use if the intended recipient is no longer at the address that has been coded. Of particular concern to the U.S.P.S. is the relatively high amount of mail that is undeliverable because the intended recipient has moved and not left a forwarding address.
[0005] With the need to reduce costs while improving the efficiency and reliability of its operations, continuous review of methodology and the systems used to implement operations is continuously required. Review by the U.S.P.S. has led to a series of sweeping changes that are to be implemented in a series of changes grouped together under the banner of “Postal Reclassification.” The first such change occurred on Jul. 1, 1996; the second on Jan. 1, 1997. The new standards under Postal Reclassification will enable the U.S.P.S. to improve efficiency and remain competitive by reducing the amount of work effort required to deliver mail.
[0006] The change of Jan. 1, 1997 includes standards for a series of move updates that effect address databases. Among the standards are: a National Change of Address (NCOA); U.S.P.S. Address Correction Requested (ACR); USPS Forwarding and Address Correction Requested; USPS Address Change Service; and, access to USPS FASTforward technology.
[0007] Under the new standards, companies are required to show that they are implementing a process to track a customer's change of address. The U.S.P.S. requires that companies implement the change of address process against customer information files at least once every six months in order to continue receiving postal discounts for First-Class mail. In addition to maintaining discounts when utilizing certain U.S.P.S. services, companies will be able to add efficiencies by improving their customer satisfaction, reducing postage expenses, and reducing returned mail and rework costs.
[0008] One of the initiatives of the U.S.P.S., designed to improve the levels of address quality in corporate mailings, has been the development of FASTforward which has evolved from work between the U.S.P.S. and vendors of commercial multi-line optical character readers (MLOCRs). The apparent goal of the U.S.P.S. is to have MLOCR solutions incorporate FASTforward technology to help identify customer change of address information.
[0009] FASTforward identifies and reads address data from the mailpieces introduced to the system, as well as the ZIP+4 coding, to determine if a change of address notification or forwarding order exists for a given addressee. If a change of address notification or forwarding order is found, then FASTforward has the capability for correcting the destination address on the mailpiece.
[0010] For those industry vendors developing systems for the mailing and/or addressing market, the U.S.P.S. has promulgated the FASTforward specification and requirements in order to promote uniformity and compatibility in interfacing the vendor product with the U.S.P.S. system. Vendors are responsible for design of the required interface systems. Thus, unique approaches are required for interfacing mailing and address systems with FASTforward in order to provide seamless service for customers.
[0011] One approach to designing an interface system for FASTforward is to create a client-server environment that provides privacy as well as control of customer data that is provided to FASTforward as well as obtained from it.
[0012] Therefore, it is an object of the present invention to provide a client-server interface and environment that provides privacy as well as control of customer data when interfacing with the U.S.P.S. FASTforward system. It is a further object of the present invention to utilize change of address information provided by the FASTforward system to return a new address and related data to the customer's mailing and/or addressing system and to include a graphical user interface (GUI) for easy task establishment and monitoring of the task execution.
Summary of the Invention
[0013] The invention overcomes the shortcomings and limitations of the prior art and satisfies the intended objectives through a method and system of updating address data representative of a changed address. The method is accomplished by initiating an address data request at a data processing system (client).
[0014] The address data request is for an update of individual address records contained in the database serviced by the data processing system. The request is transmitted from the client to an application host system such as ForwardTrak. The address data request is translated at the application host system into a format readable by a master system comprising change of address files. In order for the translated request to be transmitted from the application host system to the master system, there must be created an interface that allows passage of the translated address data request from the application host system to master system so that said translated address data request can be read and responded to by the master system.
[0015] The interface is created during the method's translation step. The translation step comprises a number of further steps that begin with creating a data map of the data representative of the address data request. The created data map is compared against a second set of data representative of a mailing list correction (MLC) scheme, or a multi-line optical character reader (MLOCR) scheme. The comparison establishes a second data map which is representative of the address request in either the MLC or the MLOCR scheme. The second data map is then transmitted via a SCSI interface to the master system for processing of the address request.
[0016] The master system, such as the U.S.P.S. FastForward system, matches the address data request to records of address changes that are resident in an address database operatively connected to the master system. After matching the address data request against the change of address database, the method and system determine whether a match exists between the address data request and any address record resident on the address database. If a match occurs, then a record of the match is placed into an address data reply. The reply is then transmitted back to the application host system.
[0017] When a reply is received from the master system, whether that reply is positive (a match occurred) or negative (no match found), the reply is translated into a format capable of being read by the client data processing system. The translated reply is then transmitted back to the client for use in updating address files operatively accessible by the client data processing system.
[0018] The address files are updated by entering a new address extracted from the reply format if the result of the address record request was positive; that is, that a match occurred between the request and the master system's change of address file.
[0019] The system is capable of printing one or more reports. The reports are based on the transactions between the application data processor and the master system, and representative of the requests, replies, and/or statistics arising from the transactions.
Brief Description of the Drawings
[0020] FIG. 1 is block diagram of a client server system utilizing the subject method of updating address data.
[0021] FIG. 2 is an upper level flowchart of the method of the ForwardTrak system which is a preferred embodiment of the subject system and method.
[0022] FIG. 3A is a flowchart of the method of the address record input up to the point of translation at the interface application of the client server.
[0023] FIG. 3B is an alternate embodiment of the method of FIG. 3A wherein the system queries as to the access rights of the initiator.
[0024] FIG. 4 is a flowchart of the steps of the translation process.
[0025] FIG. 5 is a flowchart of the method steps upon receiving the address record file from the master system.
Detailed Description of the Preferred Embodiments
[0026] Turning to FIG. 1, there are depicted in block form two subsets that, combined, form an addressing system. In a preferred embodiment, the addressing system is comprised of the United States Postal Service (U.S.P.S.) FastForward system and a client server interface system such as the ForwardTrak system available from Pitney Bowes Inc. of Stamford, Connecticut. A draft copy of the ForwardTrak Operating Guide is attached hereto and is incorporated herein by reference.
[0027] Addressing subsystem 10 is a representative example of a system that could host the U.S.P.S. FastForward system. The representative system comprises: data processing system 12 which can be a mainframe or midframe computer which in turn is comprised of: a monitor; user interface devices such as a keyboard and/or mouse; RAM and disk drive memory; a modem; a database comprising address correction data; and interface cable 30afor providing a SCSI interface connection to addressing subsystem 20.
[0028] Addressing subsystem 20 is a client server interface system comprising: data processing system 22 connected to addressing subsystem 10 by SCSI interface connection 30a. Data processing system 22 can be a mainframe, midframe, or micro-computer which in turn is comprised of: a monitor; user interface devices such as a keyboard and/or mouse; RAM and disk drive memory; a modem; a database comprising address correction data; interface connection 30efor connection between the data processing system 22 and a client input station 26; and, interface connection 30bfor connection between data processing system 22 and a server batch driver system 24. In turn, client input station 26 is connected to interface connection 30dfor connecting to address database 28; and, server batch driver system 24 is connected to address database 28 via interface connection 30c.
[0029] A data processing system that can download data that can be printed on a printer, whether that printer is a peripheral device of the data processing system or not, uses application programs for creating data. These are resident in the data processing system ROM memory, additional memory, or external devices such as database 28 can be utilized for the storing of address lists. The printers commonly utilized in the addressing art may also contain a microprocessor that is able to assign bar code data to addresses that are delivered from the host. These so-called “smart” printers vary in their ability to process data.
[0030] Turning to FIG. 2, there is shown a high level flowchart of the subject method within the system of FIG. 1.
[0031] The method begins at step 50 where the system operator initiates an addressing application. The method advances from step 50 to step 52 where the system user calls up an address record from a CASS certified addressing system such as the SmartMailer system available from Pitney Bowes of Stamford, Conn.; or, the system user can simply enter the name and address data as part of a request. The address record can be resident in a database which is located within a memory of the addressing system or can be called up from a remote database. The address data request is transferred to either a client batch driver or to a system batch driver; the request can contain one or more address records to be checked. At step 54, the batch driver transmits the request via conventional communications means to an interface application resident in a client server system such as the ForwardTrak system available from Pitney Bowes of Stamford, Conn. The ForwardTrak system is the subject of this application; an operator guide is attached hereto and incorporated herein by reference.
[0032] The interface application receives the address data request at step 56 and begins reformatting the input data from the format of the initiating application to the format of the master system application to which the address data request is to be forwarded. Reformatting of the address data request is completed at step 58 when the interface application simulates an MLOCR interface that is capable of transferring the data via a SCSI connector to the master system application; the method at step 58 is also suitable for use with a mailing list correction scheme (MLC).
[0033] Once the MLOCR, or MLC, interface is formatted, the interface application invokes the master system application at step 60. In a preferred embodiment of the present application, the master system application is the U.S.P.S. FastForward system.
[0034] Once the master system application has been invoked, the address data request is transmitted from the interface application to the master system application at step 62. The master system application receives the request at step 64 and processes the request by matching the address data request to a list of changed addresses (National Change of Address Database, or NCOA), determining whether or not a match has occurred, and then determining a reply which is to be sent back to the interface application at step 66.
[0035] At step 66, the interface application receives the reply from the master system application. The reply is reformatted by the interface application to a format readable by the initiating application. The interface application transmits the reformatted reply to the initiating application at step 68. The method then advances to step 70, where the initiating application utilizes the new address to update the corresponding address record of the address database if the reply is based upon a match found by the master system application in the change of address database; otherwise, the reply simply indicates that no match has been found and the initiating application will process the address data accordingly.
[0036] From step 70, the method advances to a query at step 72 which asks whether a next request is to be entered. If the response to the query is “YES,” then the method returns to step 52 where a new address data request is entered; however, if the response to the query at step 72 is “NO,” then the initiating application closes out the data request application.
[0037] Turning to FIG. 3A, there is shown a flowchart of the method of the address record input up to the point of translation at the interface application of the client server.
[0038] The method begins at step 100 where the data input sequence is initiated. Name and address data, representative of an address record request, is entered into the application, at step 102, by either entering the data directly through an operator input device such as a keypad or scanner; or, the data can be brought into the application from an address database. The purpose of the address record request is to determine whether the addressee has indicated a change of address to a master application such as the National Change of Address (NCOA) database. Once the data is entered, the system queries at step 104 as to whether or not the entered data is in a pre-parsed zip+4 format. If the response to the query is “YES,” then the system advances to step 106 where the address data request is sent to the batch driver and then on to a client server system hosting an interface application such as ForwardTrak. The method advances from step 106 to step 118.
[0039] Returning to step 104, if the response to the query is “NO,” then the method advances to a query at step 108 which asks whether or not the data is unparsed and in a non-zip+4 format. If the response to the query is “NO,” then the system advances to step 110 where the address data request is rejected and the system turns to a query at step 112. At step 112, the method queries as to whether or not there is a next address data request. If the response to the request is “YES,” then the method turns to re-enter the flow at step 102. If, however, the response to the query at step 112 is “NO,” then the method advances to step 114 where the application is closed.
[0040] Returning to step 108, if the response to the query is “YES,” the method turns to step 116 where the address data request is sent to the batch driver in address line format and then on to a client server system hosting an interface application such as ForwardTrak. The data is received at the client server at step 118 before being translated to an MLOCR or MLC format at step 120. The translation into an MLOCR or MLC format is detailed in FIG. 4.
[0041] Turning to FIG. 3B, there is shown a flowchart of an alternative embodiment of the method of FIG. 3A, wherein the clearance level of the request initiator is checked before the client server prepares the request for translation.
[0042] The method begins at step 120 where the data input sequence is initiated. Name and address data, representative of an address record request, is entered into the application, at step 122, by either entering the data directly through an operator input device such as a keypad or scanner; or, the data can be brought into the application from an address database. The purpose of the address record request is to determine whether the addressee has indicated a change of address to a master application such as the National Change of Address (NCOA) database. Once the data is entered, the system queries at step 124 as to whether or not the entered data is in a pre-parsed zip+4 format. If the response to the query is “YES,” then the system advances to step 126 where the address data request is sent to the batch driver and then on to a client server system hosting an interface application such as ForwardTrak. The method advances from step 126 to step 138.
[0043] Returning to step 124, if the response to the query is “NO,” then the method advances to a query at step 128 which asks whether or not the data is unparsed and in a non-zip+4 format. If the response to the query is “NO,” then the system advances to step 132 where the address data request is rejected at step 132 before the system turns to a query at step 134. At step 134, the method queries as to whether or not there is a next address data request. If the response to the request is “YES,” then the method turns to re-enter the flow at step 122. If, however, the response to the query at step 134 is “NO,” then the method advances to step 136 where the application is closed.
[0044] Returning to step 128, if the response to the query is “YES,” the method turns to step 130 where the address data request is sent to the batch driver in address line format and then on to a client server system hosting an interface application such as ForwardTrak. The data is received at the client server at step 138. From step 138 the system advances to a query at step 140 which asks if the request initiator has file access. If the response to the query is “NO,” then the request is rejected at step 132. However, if the response to the query at step 140 is “YES,” then the system advances to step 142 before being translated to an MLOCR or MLC format at step 142. The translation into an MLOCR or MLC format is detailed in FIG. 4.
[0045] Turning to FIG. 4, there is shown a flowchart of the steps of the translation process that are performed by the interface application. The application begins the translation sequence at step 150 and advances to step 152 where the address data is mapped into either an MLC or an MLOCR format depending upon the requirements of the master system or the system interface by comparing the mapped data to a look-up data of corresponding values to produce either the MLC or MLOCR data map. From step 152, the method advances to step 154 where the format requirements are performed before advancing to step 156.
[0046] At step 156, the method takes the mapped MLOCR or MLC data and establishes an MLOCR or MLC interface that is capable of allowing transmission of the data, at step 158, over a SCSI interface to the master system application. The address record request is received by the master system application at step 160.
[0047] Turning to FIG. 5, there is shown a flowchart of the method steps that are followed upon receiving the address record file from the master system application.
[0048] The master system application performs the steps of record matching to determine whether or not there is a match between an address record request and a change of address as filed on the NCOA database. If there is a match, then the master system application will post the new address to the request and return the new file as a reply; in this way, the initiating application can make an appropriate change to its database upon receiving the reply. However, if no match is determined by the master system application, then the reply will contain a notation that no change of address could be determined.
[0049] The reply is sent by the master system application to the interface application via a SCSI transmission interface. There are three possible alternative replies that can be received: (1) the addressee has moved and left a forwarding address; the addressee has moved and not left a forwarding address; or, (3) the addressee has not moved. Upon receiving the reply at step 180, the system advances to step 182 where it queries as to whether or not the addressee who/which is the subject of the address record request has moved from the address of record. If the response to the query is “NO,” then the system advances to step 186 where the uncorrected (unmatched) address data reply is accepted for translation. If however, the response to the query at step 182 is “YES,” then the system advances to the dependent query at step 184. which queries as to whether or not the address record has been corrected (a match found) by the master system application. If the response to the query is “NO,” then the method advances to step 186 where the uncorrected (unmatched) address data reply is accepted for translation. The translation of the uncorrected reply from MLOCR or MLC format to the format of the initiating application is performed at step 188 before being transmitted to the initiating application (client) by the interface application (client server) at step 190.
[0050] Returning to step 184, if the response to the query is “YES,” then method advances to step 192 where the corrected (matched) address data reply is accepted for translation. The translation of the corrected reply from MLOCR or MLC format to the format of the initiating application is performed at step 194. While the translation is being performed, the interface application holds the updated record in memory, at step 196, long enough to update the interface application (client server) before transmitting the corrected address record to the initiating application (client) at step 198. After transmission of the corrected address record, the system advances to step 200 where the corrected address record is deleted from the memory of the interface application. If the transmission of the corrected address record at step 198 were to be unsuccessful, then the initiating would have to repeat their address update request.
[0051] In an alternate embodiment of the subject invention, the interface application queries as to whether or not the transmission to the initiating application was successful. If the response to the query is “YES,” then the system advances to direct the interface application to delete the corrected address data reply from memory. If, however, the response to the query is “NO,” then the interface application, holds the corrected address data file in memory for later retransmission. Attempts at retransmission will occur until the record is purged from the interface application or until the system has received an indication that the corrected record has been successfully delivered.
[0052] It is to be understood that the present invention is not to be considered as limited to the specific embodiment described above and shown in the accompanying drawings, which merely illustrates the best mode presently contemplated for carrying out the invention and which is susceptible to such changes as may be obvious to one skilled in the art, but rather that the invention is intended to cover all such variations, modifications and equivalents thereof as may be deemed to be within the scope of the claims appended hereto.
Claims
What is claimed is:
1. A method of updating address data in a first data processing system comprising the steps of:
(a) initiating an address data request at said first data processing system;
(b) transmitting said address data request from said first data processing (system to an application host system;
(c) translating said address data request at said application host system into a format readable by a second data processing system;
(d) creating an interface between said application host system and said second data processing system wherein said interface allows passage of said translated address data request from said application host system to said second data processing system so that said translated address data request can be read and responded to by said second data processing system;
(e) matching said address data request to records of address changes that are resident in a first address database operatively connected with said second data processing system;
(f) determining whether a match exists between said address data request and an address record resident on said first address database and placing a result of said determination into an address data reply;
(g) transmitting said result from said second data processing system to said application host system;
(h) translating said result into a reply format capable of being read by said first data processing system;
(i) transmitting said reply format to said first data processing system; and
(j) updating a second address database operatively connected to said first data processing system by entering a new address extracted from said reply format if said result were a positive response.
2. The method of claim 1, wherein said translation step comprises the further steps of:
(a) creating a first data map of a first set of data representative of said address data request;
(b) comparing said first data map against a second set of data representative of a mailing list correction (MLC) or multi-line optical character reader format to establish a second data map representative of said address request; and
(c) transmitting said second data map to said second data processing system for processing of said address request.
3. The method of claim 1, wherein said first data processing system prints a plurality of reports and wherein said plurality of reports are representative of a transaction comprising said request, and/or said reply, and/or a set of statistics derived from said transaction parameters.
4. The method of claim 1, wherein said address data request comprises a plurality of address data records and wherein each of said plurality of address data records are representative of a destination address.
5. A system of updating address records comprising:
(a) a first data processing system further comprising:
(i) data entry means for entering address data to a request for service;
(ii) first communication means for transmitting said request for service to a client server interface system and for receiving a reply to said service request from said client server interface system;
(iii) record update means for updating an address data record if said reply contains data indicating an address record change;
(b) a second data processing system comprising said client server interface system, wherein said second data processing system further comprises:
(i) second communication means for receiving said request from said first data processing system, for transmitting a reformatted request to an address retrieval system, for receiving said reply to said reformatted request from said address retrieval system, and for transmitting a reformatted reply to said first data processing system;
(ii) translation means for translating said request into said reformatted request capable of being understood by said address retrieval system;
(c) third data processing means comprising said address retrieval system;
(d) address correction means for reading said reformatted reply, determining if updated address data is contained within said reformatted reply, and correcting a listing of address records capable of being accessed by said first data processing means; and
(e) an address database for storing said listing of address records.
6. The system of claim 5, wherein said address data is selected from among a plurality of address data records contained within a database resident in a memory.
7. The system of claim 6, wherein said memory is co-located with said first data processing system.
8. The system of claim 6, wherein said memory is located at a client server data processing system which is linked to said first data processing system by communication means for exchanging data between said first data processing system and said client server data processing system.
9. The system of claim 5, wherein said first data processing system further comprises a printer for printing one or more pre-determined reports wherein said one or more reports are representative of a transaction comprising said request, and/or said reply, and/or a set of statistics derived from said transaction parameters.
10. The system of claim 5, wherein said address retrieval system further comprises a postal service change of address database.
Patent Citations (24)
| Patent | Date | Inventor | Cited By |
|---|---|---|---|
| US4992649(A) | 1991-02-01 | Mampe et al. | Applicant |
| US5005124(A) | 1991-04-01 | Connell et al. | Applicant |
| US5050078(A) | 1991-09-01 | Sansone | Applicant |
| US5073954(A) | 1991-12-01 | Tyne et al. | Applicant |
| US5142482(A) | 1992-08-01 | Sansone | Applicant |
| US5146403(A) | 1992-09-01 | Goodman | Examiner |
| US5227970(A) | 1993-07-01 | Harris | Examiner |
| US5239577(A) | 1993-08-01 | Bates et al. | Examiner |
| US5341505(A) | 1994-08-01 | Whitehouse | Applicant |
| US5377120(A) | 1994-12-01 | Humes et al. | Examiner |
| US5410646(A) | 1995-04-01 | Tondevold et al. | Examiner |
| US5422821(A) | 1995-06-01 | Allen et al. | Examiner |
| US5446880(A) | 1995-08-01 | Balgeman et al. | Examiner |
| US5452203(A) | 1995-09-01 | Moore | Examiner |
| US5563955(A) | 1996-10-01 | Bass et al. | Applicant |
| US5608874(A) | 1997-03-01 | Ogawa et al. | Examiner |
| US5612889(A) | 1997-03-01 | Pintsov et al. | Examiner |
| US5709783(A) | 1998-01-01 | Sanchez et al. | Examiner |
| US5781634(A) | 1998-07-01 | Cordery et al. | Examiner |
| US5987508(A) | 1999-11-01 | Agraharam et al. | Examiner |
| US6006237(A) | 1999-12-01 | Frisbey | Examiner |
| US6292709(B1) | 2001-09-01 | Uh et al. | Examiner |
| US2001/0010334(A1) | 2001-08-01 | Park et al. | Examiner |
| US2001/0037463(A1) | 2001-11-01 | Salta | Examiner |
Non-Patent Literature (1)
- ForwardTrak Technical Specification, dated Apr. 1997.Applicant