Method and apparatus of creating electronic forms to include internet list data

• US 10,089,673 B1
• Filed: 07/11/2017
• Issued: 10/02/2018
• Est. Priority Date: 07/29/2009
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: Open Invention Network LLC
• Inventors: Ledet, David Gerard
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Velez-Lopez, Mario M
• Application Number:
  US15/646,605
• Time in Patent Office: 448 Days
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06Q 30/0625 Directed, with specific intent or strategy

Abstract

A method and apparatus are disclosed that create an electronic form based on table data provided by Internet searching operations. One example may include determining at least one search term, querying, via a server, information provided by at least one network based on the search term, and copying at least one data table resulting from the information discovered during the querying operation. Additional operations may include parsing the at least one data table and storing the information in the server, displaying the data table to an end user so that the end user may select whether the data table should be included in the electronic form, and providing the user with the option to select and edit the contents of the data table. Upon the user'"'"'s approval the data table may be copied into the electronic form.

Claims

1. A method, comprising:

querying, via a server executing a form creating application, information provided by at least one network based on a search term;

receiving, by the form creating application, at least one web page as a result of the query;

extracting by the form creating application, at least one data table from the at least one web page, the at least one extracted data table comprising a plurality of individually selectable rows or a plurality of individually selectable columns;

including a column of the one or more individually selectable columns in the electronic form; and

when the selected column is selected to be copied into the electronic form, creating a form field in the electronic form and populating the form field as a drop down list containing the contents of the selected column via the form creating application.

2. The method of claim 1, further comprising creating a sub-table based on the contents of the at least one extracted data table and by another at least one extracted data table discovered during said querying operation.

3. The method of claim 1, further comprising generating a hierarchical schema, said hierarchical schema being at least one of an extensible markup language (XML)-based schema and an extensible style language family transformation (XSLT)-based schema.

4. The method of claim 1, comprising parsing the at least one column of the at least one extracted data table, wherein the parsing comprises introducing XML code into the at least one extracted data table contents.

5. The method of claim 1, comprising parsing the at least one column of the at least one extracted data table, wherein the parsing comprises introducing HTML code into the at least one extracted data table contents.

6. The method of claim 1, wherein said at least one network comprises the Internet.

7. The method of claim 1, wherein the at least one search term is queried by using a command line interface (CLI) application.

8. The method of claim 1, wherein the at least one search term is pre-defined.

9. The method of claim 1, wherein the at least one search term is provided by a user input.

10. An apparatus, comprising:

a processor configured to;

query, via a server, information provided by at least one network based on a search term;

receive at least one web page as a result of the query;

extract at least one data table from the at least one web page comprising at least one column comprising a plurality of individually selectable rows or a plurality of individually selectable columns;

include a column of the one or more individually selectable columns in the electronic form; and

when the selected column is selected to be copied into the electronic form, creating a form field in the electronic form and populating the form field as a drop down list containing the contents of the selected column.

11. The apparatus of claim 10, wherein the processor is further configured to create a sub-table based on the contents of the at least one extracted data table and by another at least one extracted data table discovered during said querying operation.

12. The apparatus of claim 10, wherein the processor is further configured to generate a hierarchical schema, said hierarchical schema being at least one of an extensible markup language (XML)-based schema and an extensible style language family transformation (XSLT)-based schema.

13. The apparatus of claim 10, wherein the processor is further configured to introduce XML code into the at least one extracted data table contents.

14. The apparatus of claim 10, wherein the processor is further configured to introduce HTML code into the at least one extracted data table contents.

15. The apparatus of claim 10, wherein said at least one network comprises the Internet.

16. The apparatus of claim 10, wherein the processor is further configured to query the search by using a command line interface (CLI) application.

17. The apparatus of claim 10, wherein the at least one search term is pre-defined.

18. The apparatus of claim 10, wherein the at least one search term is provided by a user input.

19. A non-transitory computer readable storage medium comprising computer code that when executed causes a processor to perform:

querying, via a server executing a form creating application, information provided by at least one network based on a search term;

receiving, by the form creating application, at least one web page as a result of the query;

extracting, by the form creating application, at least one data table from the at least one web page the at least one extracted data table comprising at least one column comprising a plurality of individually selectable rows or a plurality of individually selectable columns;

including a column of the one or more individually selectable columns in the electronic form; and

when the selected column is selected to be copied into the electronic form, creating a form field in the electronic form and populating the form field as a drop down list containing the contents of the selected column via the form creating application.

20. The non-transitory computer readable storage medium of claim 19, wherein the processor is further configured to perform creating a sub-table based on the contents of the at least one extracted data table and by another at least one extracted data table discovered during said querying operation.