Database driven workflow management system for generating output material based on customer input
First Claim
1. A workflow management system for creating and delivering output material, comprising:
- computational resources;
at least one system computer readable medium including ajob status table, a database table, and content files; and
code executed by the computational resources and implementing a first and second workers, wherein the code is executed to perform operations, the operations comprising;
generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record;
adding a job record including a status field to the job status table for the customer record;
setting the added job record status to a first status;
processing a selected job in the job status table;
invoking the first worker if the selected job has the first status;
generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job by(i) processing a template including queries of records in the database table;
(ii) accessing at least one value in a field in one customer record to include in one query from the template against the database table;
(iii) applying the query against the database table to determine a record associated with one content file and including fields matching the query;
(iv) accessing the content file associated with the determined record; and
(v) generating the content from the at least one accessed content file into the template, which forms the output material;
setting the status for the selected job in the job status table to a second status after generating the output material with the first worker;
invoking the second worker if the selected job has the second status;
determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; and
transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record.
4 Assignments
0 Petitions
Accused Products
Abstract
Disclosed is a workflow management system for creating and delivering output material. A customer record is generated to include fields specifying at least one product, customer preferences, and a selected output method to deliver generated output material on the product specified in the customer record. A job record including a status field is added to a job status table for the customer record and set to a first status. A first worker generates output material from processing the product and customer preference fields in the customer record for the selected job, and sets the status for the selected job to a second status. A second worker determines a selected one of a plurality of delivery options from the customer record for the selected job and transmits the output material via the determined delivery option to the customer specified in the customer record.
-
Citations
21 Claims
-
1. A workflow management system for creating and delivering output material, comprising:
-
computational resources; at least one system computer readable medium including ajob status table, a database table, and content files; and code executed by the computational resources and implementing a first and second workers, wherein the code is executed to perform operations, the operations comprising; generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding a job record including a status field to the job status table for the customer record; setting the added job record status to a first status; processing a selected job in the job status table; invoking the first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job by (i) processing a template including queries of records in the database table; (ii) accessing at least one value in a field in one customer record to include in one query from the template against the database table; (iii) applying the query against the database table to determine a record associated with one content file and including fields matching the query; (iv) accessing the content file associated with the determined record; and (v) generating the content from the at least one accessed content file into the template, which forms the output material; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; and transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A workilow management system for creating and delivering output material, comprising:
-
computational resources; at least one system computer readable medium including; ajob status table; a worker transition table including a plurality of records, each indicating an input worker, a completion state, an output worker, and an output state, wherein the input worker indicates the worker assigned to process the job, the completion state is a status indicated for the job after the input worker processes the job, the output worker is the worker that processes the job after having been processed by the input worker and resulting in the completion state, and the output state is the state to which the job status in the job status table is set, and wherein the job status table further indicates a current worker assigned to process the job; code executed by the computational resources and implementing a first and second workers, wherein the code is executed to perform operations, the operations comprising; generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding ajob record including a status field to the job status table for the customer record; setting the added job record status to a first status; processing a selected job in the job status table; invoking a first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker by determining from the worker transition table one record having an input worker and completion state matching the current worker and the job status, respectively, and setting the status for the selected job to the output state and the current worker to the output worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; and transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record. - View Dependent Claims (8, 9)
-
-
10. A workilow management system for creating and delivering output material, comprising:
-
computational resources; a system computer readable medium including a job status table; and code executed by the computational resources and implementing a first worker, a second worker, and a data conditioning worker, wherein the code is executed to perform operations, the operations comprising; generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding a job record including a status field to the job status table for the customer record; setting the added job record status to a first status; processing a selected job in the job status table; invoking the first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record; setting the status to a third status after adding the job in the job status table; invoking the data conditioning worker if the job status for the selected job is the third status; processing, with the data conditioning worker, the customer record to determine whether at least one value satisfies at least one condition; taking corrective actions, with the data conditioning worker, if the data in the customer record does not satisfy each condition; and setting the status of the selected job to the first status if the data in the customer record satisfies each condition.
-
-
11. A workflow management system for creating and delivering output material, comprising:
-
computational resources; a system computer readable medium including a job status table; and code executed by the computational resources and implementing a first worker, a second worker, and an accounting worker, wherein the code is executed to perform operations, the operations comprising; generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding a job record including a status field to the job status table for the customer record; setting the added job record status to a first status; processing a selected job in the job status table; invoking the first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record; generating information on the output material; setting the status for the selected job in the job status table to a third status; invoking an accounting worker if the job has the third status; processing, with the accounting worker, the generated information on the output material to determine costs of generating the output material; and generating, with the accounting worker, an invoice including the determined costs of the output material.
-
-
12. An article of manufacture for use in a workflow management system for creating and delivering output material, the article of manufacture including code implemented in a computer readable medium, wherein the code implements a first worker and second worker, wherein the code is enabled to access ajob status table, a database table, and content files, and wherein the code is executed to perform operations comprising:
-
generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding ajob record including a status field to the customer record; setting the added job record status to a first status; processing a selected job in the job status table; invoking the first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job by; (i) processing a template including queries of records in the database table; (ii) accessing at least one value in a field in one customer record to include in one query from the template against the database table; (iii) applying the query against the database table to determine a record associated with a file including fields matching the query; (iv) accessing the one content file associated with the determined record; and (v) generating the content from the at least one accessed content file into the template, which forms the output material; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; and transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record. - View Dependent Claims (13, 14, 15, 16)
-
-
17. An article of manufacture for use in a workflow management system for creating and delivering output material, the article of manufacture including code implemented in a computer readable medium, wherein the code implements a first worker and second worker, wherein the code is enabled to access ajob status table, and wherein the code is executed to perform operations comprising:
-
generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding a job record including a status field to the job status table for the customer record; providing a worker transition table includes a plurality of records, each indicating an input worker, a completion state, an output worker, and an output state, wherein the input worker indicates the worker assigned to process the job, the completion state is a status indicated for the job after the input worker processes the job, the output worker is the worker that processes the job after having been processed by the input worker and resulting in the completion state, and the output state is the state to which the job status in the job status table is set, and wherein the job status table further indicates a current worker assigned to process the job; setting the added job record status to a first status; processing a selected job in the job status table; invoking the first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker, wherein setting the status for the selected job in the job status table comprises determining from the worker transition table one record having an input worker and completion state matching the current worker and the job status, respectively, and setting the status for the selected job to the output state and the current worker to the output worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; and transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record. - View Dependent Claims (18, 19)
-
-
20. An article of manufacture for use in a workflow management system for creating and delivering output material, the article of manufacture including code implemented in a computer readable medium, wherein the code implements a first worker, a second worker, and a data conditioning worker, wherein the code is enabled to access a job status table, and wherein the code is executed to perform operations comprising:
-
generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding a job record including a status field to the job status table for the customer record; setting the added job record status to a first status; processing a selected job in the job status table; invoking the first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record; setting the status to a third status after adding the job in the job status table; invoking the data conditioning worker if the job status for the selected job is the third status; processing, with the data conditioning worker, the customer record to determine whether at least one value satisfies at least one condition; taking corrective actions, with the data conditioning worker, if the data in the customer record does not satisfy each condition; and setting the status of the selected job to the first status if the data in the customer record satisfies each condition.
-
-
21. An article of manufacture for use in a workflow management system for creating and delivering output material, the article of manufacture including code implemented in a computer readable medium, wherein the code implements a first worker, a second worker, and an accounting worker, wherein the code is enabled to access ajob status table, a database table, and content files, and wherein the code is executed to perform operations comprising:
-
generating a customer record to include fields specifying at least one product, customer preferences, and a selected delivery option indicating a method to deliver generated output material on the product specified in the customer record; adding a job record including a status field to a job status table for the customer record; setting the added job record status to a first status; processing a selected job in the job status table; invoking the first worker if the selected job has the first status; generating, with the first worker, output material from processing the product and customer preference fields in the customer record for the selected job; setting the status for the selected job in the job status table to a second status after generating the output material with the first worker; invoking the second worker if the selected job has the second status; determining, with the second worker, a selected one of a plurality of delivery options from the customer record for the selected job; transmitting, with the second worker, the output material via the determined delivery option to the customer specified in the customer record; generating information on the output material; setting the status for the selected job in the job status table to a third status; invoking the accounting worker if the job has the third status; processing, with the accounting worker, the generated information on the output material to determine costs of generating the output material; and generating, with the accounting worker, an invoice including the determined costs of the output material.
-
Specification