Automatic Insertion of Data from Web Forms into Documents

• US 20100318889A1
• Filed: 06/12/2009
• Published: 12/16/2010
• Est. Priority Date: 06/12/2009
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Billharz, Alan, Rey-Babarro, Marta, Monarch, Michael
• Application Number:
  US12/483,670
• Publication Number:
  US 20100318889A1
• Time in Patent Office: Days
• US Class Current: 715/212
• CPC Class Codes: G06F 40/174 Form filling; Merging

Abstract

A host computing system automatically inserts data submitted from web forms into documents. The host computing system stores a document file comprising data that represents a document. The document comprises at least one document element. The host computing system receives a block of web form data. The block of web form data comprises a value assigned to a web form element in a web form. In response to receiving the block of web form data, the host computing system automatically updates the document element to specify the value when the document file comprises element mapping metadata that maps the document element to the web form element.

Claims

1. A method for automatically updating documents based on data from web forms, the method comprising:

storing, at a data storage system accessible to a computing system, a document file comprising data that represents a document, the document being a discrete set of human-readable content, the document comprising a document element, the document element being a logical sub-part of the document;

receiving, at the computing system, a block of web form data, the block of web form data comprising a value submitted to a server computing system via a web form, the web form comprising a web form element, the value assigned to the web form element; and

in response to receiving the block of web form data, automatically insert, by the computing system, data based on the value into the document element of the document file when the document file comprises element mapping metadata that maps the document element to the web form element.

2. The method of claim 1,

wherein the document is a word processor document;

and

wherein the document element one of;

a text box within the word processor document.

3. The method of claim 1, wherein storing the document file comprises storing, by the computing system, the document file at the data storage system in response to receiving the block of web form data.

4. The method of claim 1,

wherein the document is a spreadsheet document;

and

wherein the document element is one of;

a row within the spreadsheet document,

a column within the spreadsheet document,

a range of rows within the spreadsheet document, or

a range of columns within the spreadsheet document.

5. The method of claim 1, further comprising:

in response to receiving the block of web form data and prior to automatically inserting the data based in the value into the document element, automatically applying, by the computing system, a transformation to the value, thereby generating the data based on the value.

6. The method of claim 1, further comprising:

before receiving the block of web form data;

receiving, at the computing system, a document open request from a user, the document open request indicating that the user wants to open the document file;

in response to receiving the document open request, automatically determining, by the computing system, whether the document file comprises the element mapping metadata; and

in response to determining that the document file comprises the element mapping metadata, automatically sending, by the computing system, a web form data request to the server computing system via an electronic communications network, the computing system receiving the block of web form data in response to the web form data request.

7. The method of claim 6,

wherein receiving the document open request comprises receiving, at the computing system, the document open request from a client computing system, the user interacting with the client computing system;

and

wherein the method further comprises after inserting the value into the document element, automatically sending, by the computing system, a copy of the document file to the client computing system in response to the document open request.

8. The method of claim 1, further comprising:

before receiving the block of web form data;

sending, by the computing system, web form data requests to the server computing system via an electronic communications network on a periodic basis, the web form data requests requesting the server computing system to send blocks of web form data to the computing system, the blocks of web form data comprising values submitted to the server computing system via the web form, the blocks of web form data including the block of web form data.

9. The method of claim 1, wherein the document element is visibly differentiated from other parts of the document.

10. The method of claim 1, further comprising:

receiving, at the computing system, web form selection input, the web form selection input specifying the web form;

in response to receiving the web form selection input, updating, at the computing system, the document file to contain form mapping metadata, the form mapping metadata specifying the web form;

causing, by the computing system, a display device to display a list of web form elements in the web form;

after causing the display device to display the list of web form elements, receiving, at the computing system, element selection input, the element selection input indicating that a user has selected the web form element from the list of web form elements; and

in response to receiving the element selection input, updating, at the computing system, the document file to contain the element mapping metadata.

11. The method of claim 10,

wherein the method further comprises:

displaying, at the computing system, at least part of the document in a document application user interface;

receiving, at the computing system, mapping tool open input, the mapping tool open input indicating to the computing system that the user wants the computing system to display a mapping tool, the mapping tool being a user interface that enables the user to map web form elements to document elements in the document; and

in response to receiving the mapping tool open input, automatically causing, by the computing system, the display device to display the mapping tool;

wherein receiving the web form selection input comprises receiving the web form selection input via the mapping tool;

wherein causing the display device to display the list of web form elements comprises automatically causing, by the computing system, the display device to display the list of web form elements in the mapping tool; and

wherein receiving the element selection input comprises receiving, at the computing system, the element selection input via the mapping tool.

12. The method of claim 1, further comprising:

receiving, at the computing system, document creation input from a user, the document creation input indicating that the user wants to create a new document;

in response to receiving the document creation input, automatically generating, at the computing system, the document file;

after generating the document file, receiving, at the computing system, element creation input from the user, the element creation input indicating that the user wants to add a new document element to the document; and

in response to receiving the element creation input, updating, by the computing system, the document file to include the document element.

13. The method of claim 1, further comprising:

after storing the document file and before receiving the block of web form data;

receiving, at the computing system, web form creation input from a user; and

in response to receiving the web form creation input;

automatically creating, by the computing system, the web form;

automatically updating, by the computing system, the document file to include the element mapping metadata;

causing the server computing system to make the web form accessible on an electronic communication network.

14. The method of claim 1,

wherein the method further comprises automatically determining, at the computing system, whether the element mapping metadata indicates that the value is to be appended to data specified by the document element, whether the value is to replace the data specified by the document element, or whether the computing system is to create a new copy of the document file in which the value replaces the data specified by the document element;

and

wherein automatically inserting the value into the document element comprises;

automatically replacing, by the computing system, the data specified by the document element with the value when the element mapping metadata indicates that the value is to replace the data specified by the document element;

automatically appending, by the computing system, the value to the data specified by the document element when the element mapping metadata indicates that the value is to be appended to the data specified by the document element; and

automatically creating, by the computing system, the new copy of the document file when the element mapping metadata indicates that the computing system is to create the new copy of the document file in which the value replaces the data specified by the document element.

15. The method of claim 1,

wherein the computing system comprises an electronic computing device, the electronic computing device comprising a computer-readable data storage medium, a processing unit, and a network interface card;

wherein receiving the block of web form data comprises receiving, at the computing system, the block of web form data via the network interface card; and

wherein automatically inserting value into the document element comprises automatically executing, by the processing unit, software instructions stored on the computer-readable data storage medium, the software instructions, when executed by the processing unit, cause the computing system to automatically insert the value into the document element only when the document file comprises the element mapping metadata.

16. A server computing system comprising:

a processing unit; and

a data storage system storing software instructions that, when executed by the processing unit, cause the server computing system to;

receive a block of web form data from a client computing system, the block of web form data comprising a value submitted to the server computing system via a web form, the web form comprising a web form element, the value assigned to the web form element; and

automatically send the block of web form data to a host computing system, the host computing system hosting a document file, the document file comprising data that represents a document, the document being a discrete set of human-readable content, the document comprising a document element, the document element being a logical sub-part of the document, the document file comprising element mapping metadata that maps the document element to the web form element, the host computing system configured to respond to receiving the block of web form data by automatically inserting the value into the document element of the document file.

17. The server computing system of claim 16, wherein the software instructions, when executed by the processing unit, further cause the server computing system to:

receive a web form request from the client computing system, the web form request requesting the web form; and

send, in response to receiving the web form request, the web form to the client computing system.

18. The server computing system of claim 16, wherein the software instructions, when executed by the processing unit, further cause the server computing system to:

store the block of web form data at the data storage system;

receive, after the server computing system stores the block of web form data at the data storage system, a web form data request from the host computing system, the web form data request requesting the server computing system to send the block of web form data to the host computing system; and

send, in response to receiving the web form data request, the block of web form data to the host computing system.

19. The server computing system of claim 16,

wherein the software instructions, when executed by the processing unit, further cause the server computing system to store the block of web form data along with a plurality of blocks of web form data at the data storage system, marking the block of web form data as unsynchronized;

and

wherein the software instructions that cause the server computing system to send the block of web form data to the host computing system cause the server computing system to send the block of web form data to the host computing system without first receiving a request from the host computing system for the block of web form data.

20. A computer-readable data storage medium storing software instructions that, when executed by a processing unit of a computing system, cause the computing system to:

receive, at the computing system, document creation input from a user, the document creation input indicating that the user wants to create a word processor document;

in response to receiving the document creation input, generate, at the computing system, a document file comprising data that represents the word processor document, the word processor document being a document comprising human-readable content having a specific format that defines how the human-readable content is laid out when the word processor document is physically printed;

after generating the document file, receive, at the computing system, element creation input from the user, the element creation input indicating that the user wants to add a document element to the word processor document, the document element being a text box within the word processor document, the document element being visibly differentiated from other parts of the word processor document;

in response to receiving the element creation input, update, by the computing system, the document file such that the word processor document includes the document element;

after updating the document file to include the document element, receive, at the computing system, a mapping tool open input, the mapping tool open input indicating that the user wants the computing system to display a mapping tool, the mapping tool being a user interface that enables the user to map web form elements to document elements in the word processor document;

in response to receiving the mapping tool open input, automatically cause, by the computing system, a display device to display the mapping tool;

receive, at the computing system, web form selection input via the mapping tool, the web form selection input specifying a web form;

in response to receiving the web form selection input, automatically update, at the computing system, the document file to contain form mapping metadata, the form mapping metadata specifying the web form;

in response to receiving the web form selection input, automatically identify, by the computing system, web form elements in the web form;

in response to receiving the web form selection input, automatically cause, by the computing system, the display device to display a list of the web form elements in the web form and a list of document elements in the word processor document;

after causing the display device to display the list of web form elements in the web form and the list of document elements in the word processor document, receive, at the computing system, web form element selection input via the mapping tool, the element selection input indicating that the user has selected a web form element from the list of web form elements;

after causing the display device to display the list of web form elements in the web form and the list of document elements in the word processor document, receive, at the computing system, document element selection input via the mapping tool, the document element selection input indicating that the user has selected the document element from the list of document elements in the word processor document;

in response to receiving the element selection input, update, at the computing system, the document file to contain element mapping metadata, the element mapping metadata mapping the document element to the web form element;

save, by the computing system, the document file at a data storage system accessible to the computing system;

receive, at the computing system, a document open request from the user, the document open request indicating that the user wants to open the word processor document;

in response to receiving the document open request, automatically determine, at the computing system, whether the document file comprises the element mapping metadata;

in response to determining that the document file comprises the element mapping metadata, automatically send, by the computing system, a web form data request to a server computing system via an electronic communications network;

receive, at the computing system, a block of web form data from the server computing system, the computing system receiving the block of web form data in response to the web form data request, the block of web form data comprising a value submitted to the server computing system via the web form, the value assigned to the web form element;

determine, at the computing system, whether the element mapping metadata indicates that the value is to be appended to data specified by the document element, whether the value is to replace the data specified by the document element, or whether the computing system is to create a new copy of the document file in which the value replaces the data specified by the document element;

in response to receiving the block of web form data, automatically replace, by the computing system, the data specified by the document element with the value when the element mapping metadata indicates that the value is to replace the data specified by the document element;

automatically append, by the computing system, the value to the data specified by the document element when the element mapping metadata indicates that the value is to be appended to the data specified by the document element;

automatically create, by the computing system, the new copy of the document file when the element mapping metadata indicates that the computing system is to create the new copy of the document file in which the value replaces the data specified by the document element.