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

• US 10,460,372 B1
• Filed: 10/01/2018
• Issued: 10/29/2019
• 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 T
• Assistant Examiner(s): Velez-Lopez, Mario M
• Application Number:
  US16/148,160
• Time in Patent Office: 393 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 at least one web page including at least one data table as a result of the query;

automatically extracting, by the form creating application, the at least one data table from the at least one web page as a result of the query;

automatically recognizing different columns of content in the at least one data table;

automatically displaying contents of the different columns recognized in the at least one data table within the form creating application, the contents of the different columns displayed separately from the at least one web page;

automatically generating and displaying selectable icons for corresponding ones of the different columns recognized in the at least one data table; and

when one or more of the selectable icons are selected, then via the form creating application creating one or more corresponding form fields in the electronic form and populating the one or more form fields as corresponding drop down lists containing the contents of the one or more columns that correspond to selected ones of the one or more selectable icons.

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 including at least one data table as a result of the query;

automatically extract the at least one data table from at least one web page as a result of the query;

automatically recognize different columns of content in the at least one data table;

automatically display contents of the different columns recognized in the at least one the data table within a form creating application, the contents of the different columns displayed separately from the at least one web page;

automatically generate and display selectable icons for corresponding ones of the different columns recognized in the at least one data table; and

when one or more of the selectable icons are selected, creating one or more corresponding form fields in the electronic form and populating the one or more form fields as corresponding drop down lists containing the contents of the one or more columns that correspond to selected ones of the one or more selectable icons.

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 at least one web page including at least one data table as a result of the query;

automatically extracting, by the form creating application, the at least one data table from the at least one web page as a result of the query;

automatically recognizing different columns of content in the at least one data table;

automatically displaying contents of the different columns recognized in the at least one data table within the form creating application, the contents of the different columns displayed separately from the at least one web page;

automatically generating and displaying selectable icons for corresponding ones of the different columns recognized in the at least one data table; and

when one or more of the selectable icons are selected, then via the form creating application creating one or more corresponding form fields in the electronic form and populating the one or more form fields as corresponding drop down lists containing the contents of the one or more columns that correspond to selected ones of the one or more selectable icons.

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.