Apparatus and method for producing fulfillment pieces on demand in a variable imaging system

• US 6,088,710 A
• Filed: 10/29/1997
• Issued: 07/11/2000
• Est. Priority Date: 10/29/1997
• Status: Expired due to Term

• Current Assignee: RR Donnelley & Sons Company
• Original Assignee: RR Donnelley & Sons Company
• Inventors: Warmus, James L., Dreyer, Mark G.
• Primary Examiner(s): Hong, Stephen S.
• Application Number:
  US08/960,519
• Time in Patent Office: 986 Days
• Field of Search: 707/513, 707/515, 707/517, 707/518, 707/520, 707/522, 364/469.03, 364/469.04, 395/104, 395/111, 395/117
• US Class Current: 715/246
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/174 Form filling; Merging

Abstract

The present invention discloses a method for assembling fulfillment pieces with custom documents in an efficient manner. The fulfillment pieces, which may have fixed and/or variable information, are produced in line on the same press as the custom documents. This "on demand" fulfillment is accomplished through the manipulation of an original database containing document recipient information. The database manipulation includes adding records (rows) or columns to the original database to represent the custom document and the fulfillment pieces. The modified databases are used to create press command files, which are combined according to the configuration of the database to produce ordered output from a press.

Claims

1. A method of reproducing books and fulfillment pieces in distribution order, wherein each book and fulfillment piece may include variable data, comprising the steps of:

(a) modifying a database containing variable data for pages in the book to include reference to the fulfillment pieces;

(b) creating template page files, the page files having fixed information and a placeholder at the location on the page where the variable data will be reproduced;

(c) generating a press command file to specify the distribution order in which the pages and the fulfillment pieces should be reproduced;

(d) interpreting the pages and fulfillment pieces according to the press command file, including incorporating the variable data from the database into the pages at the location of the corresponding placeholder; and

(e) transmitting the pages and fulfillment pieces to a display device in distribution order.

2. The method of claim 1, wherein the display device is a demand printer that prints the pages and fulfillment pieces.

3. The method of claim 1, wherein the display device is a computer.

4. The method of claim 1, wherein the pages and fulfillment pieces are transmitted to a computer network.

5. The method of claim 1, further comprising the step of attaching the fulfillment pieces to the pages to be distributed to a single address.

6. The method of claim 1, wherein the reference to the fulfillment piece in the database comprises a file name corresponding to the fulfillment piece.

7. The method of claim 6, wherein the fulfillment pieces are generated as QuarkXPress®

files.

8. The method of claim 1, wherein the database contains a record for each person and the step of modifying the database comprises:

(i) adding one column to the database for each fulfillment piece; and

(ii) for each column, adding the reference to the fulfillment piece for each person in each record.

9. The method of claim 8, wherein the step of generating a press command file comprises:

(i) creating a separate press command file for each book and each fulfillment piece;

(ii) for each record in the modified database, copying the press command file for the book and the press command file for each fulfillment piece referenced; and

(iii) merging the copied press command files into a new press command file.

10. The method of claim 1, wherein the step of modifying the database comprises:

(i) creating a controlling database containing variable data for the book, a record for each person and a column including a unique identification for each person; and

(ii) creating a fulfillment database for each fulfillment piece, wherein each fulfillment database contains variable information for the fulfillment piece, a record for each person and a column including the unique identification for each person.

11. The method of claim 10, wherein the step of generating a press command file comprises:

(i) creating a separate press command file for each book and each fulfillment piece;

(ii) analyzing the controlling database for identification numbers and for each identification number, searching each fulfillment database for the records containing that unique identification;

(iii) for each record in each fulfillment database containing that identification number, copying a press command file associated with the identification number; and

(iv) merging the copied press command files into a new press command file.

12. The method of claim 1, further comprising the step of adding a number of blank page files to the template page files, wherein the number of blank page files corresponds to a maximum number of pages in the fulfillment pieces.

13. The method of claim 12, wherein the pages of the fulfillment pieces are generated as QuarkXPress®

files and stored in EPS format.

14. The method of claim 12, further comprising inserting an image box on each added blank page file.

15. The method of claim 14, wherein each image box is named corresponding to a column name in the modified database.

16. The method of claim 12, wherein the database contains a record for each person and each page in the fulfillment pieces is stored in a named file, and wherein the step of modifying the database further comprises adding the file name of the fulfillment piece pages for each record.

17. The method of claim 1, wherein the database contains a record for each person and the step of modifying the database comprises adding an additional number of records for each person, wherein the number of additional records per person corresponds to the number of fulfillment pieces for that person.

18. The method of claim 17, wherein the additional records for each person are added to the database in distribution order.

19. A method of generating books and fulfillment pieces in distribution order, wherein each book comprises a plurality of pages having static and variable information and the variable information is stored in a database which contains a record for each person to receive a book, comprising the steps of:

(a) creating template page files representing each page, wherein the page files include the static information and a placeholder at the location on the page where the variable information will be reproduced;

(b) adding an additional number of records to the database for each person, wherein the number of additional records per person corresponds to the number of fulfillment pieces for that person;

(c) for each additional record added to the database, inserting a reference to a fulfillment piece; and

(d) reading each record from the database, including mapping the variable information in the database to the corresponding placeholder on the page files to generate a book and, for each reference in the database to a fulfillment piece, generating that fulfillment piece.

20. The method of claim 19, further comprising the step of transmitting the books and fulfillment pieces to a demand printer to print the books and fulfillment pieces.

21. The method of claim 20, wherein the demand printer prints the books and the fulfillment pieces as separate pages.

22. The method of claim 19, wherein the additional records for each person are added to the database in distribution order.

23. The method of claim 19, wherein the fulfillment pieces include variable information.

24. The method of claim 19, further comprising the step of imposing the books and the fulfillment pieces into a single book.

25. The method of claim 24, further comprising the step of printing the imposed books and fulfillment pieces as a single document.

26. A method of generating books and fulfillment pieces in distribution order, wherein each book comprises a plurality of pages having static and variable information and the variable information is stored in a database which contains a record for each person to receive a book, comprising the steps of:

(a) creating template page files representing each page, wherein the page files include the static information and a placeholder at the location on the page where the variable information will be reproduced;

(b) adding a column to the database for each fulfillment piece and, for each column, adding a reference to the fulfillment pieces for each record;

(c) creating a press command file for each book and each fulfillment piece and, for each record in the database, copying the press command file for the book and the press command file for each fulfillment piece referenced, and merging the copied press command files into a new press command file; and

(d) interpreting the page files according to the new press command file, including mapping the variable data from the database to the corresponding placeholders on the page files.

27. The method of claim 26, further comprising the step of transmitting the books and fulfillment pieces to a demand printer to print the books and fulfillment pieces.

28. The method of claim 27, wherein the demand printer prints the books and the fulfillment pieces as separate pages.

29. The method of claim 26, further comprising the step of imposing the books and the fulfillment pieces into a single book.

30. The method of claim 29, further comprising the step of printing the imposed books and fulfillment pieces as a single document.

31. A method of generating books and fulfillment pieces in distribution order, wherein each book comprises a plurality of pages having static and variable information and the variable information is stored in a database, comprising the steps of:

(a) creating template page files representing each page, wherein the page files include the static information and a placeholder at the location on the page where the variable information will be reproduced;

(b) creating a controlling database containing variable data for the book, a record for each person to receive the book and a unique identification for each person;

(c) creating a fulfillment database for each fulfillment piece, wherein each fulfillment database contains variable information for the fulfillment piece, a record for each person and the unique identification for each person;

(d) analyzing the controlling database for identification numbers, and for each identification number, searching each fulfillment database for the records containing that unique identification, and for each record in each database containing that identification number, copying a press command file associated with the identification number and merging the copied press command files into a new press command file; and

(e) interpreting the page files according to the new press command file, including mapping the variable information from the databases to the corresponding placeholders on the page files.

32. The method of claim 31, further comprising the step of transmitting the books and fulfillment pieces to a demand printer to print the books and fulfillment pieces.

33. The method of claim 32, wherein the demand printer prints the books and the fulfillment pieces as separate pages.

34. The method of claim 31, further comprising the step of imposing the books and the fulfillment pieces into a single book.

35. The method of claim 34, further comprising the step of printing the imposed books and fulfillment pieces as a single document.

36. A method of generating books and fulfillment pieces in distribution order, wherein each book comprises a plurality of pages having static and variable information and the variable information is stored in a database which contains a record for each person, comprising the steps of:

(a) creating template page files representing each page in a book, wherein the page files include the static information and a placeholder at the location on the page where the variable information will be reproduced;

(b) adding a number of blank page files to the template page files, wherein the number of blank page files corresponds to a maximum number of pages in the fulfillment pieces;

(c) inserting an image box on each added blank page file;

(d) modifying the database by adding a reference to fulfillment piece pages for each record;

(e) interpreting the page files, including mapping the variable information from the database to the corresponding placeholders on the page files;

and

(f) imposing the book pages and the fulfillment piece pages for each record in the database into a single book.

37. The method of claim 36, wherein each image box is named corresponding to a column name in the modified database.

38. The method of claim 36, wherein the fulfillment piece pages are stored in a named file and the reference to the fulfillment pages in the database is the file name.

39. The method of claim 36, wherein the fulfillment piece pages contain variable information.

40. The method of claim 36, further comprising the step of transmitted the single book to a demand printer.