Method and system for extracting information from electronic data sources

• US 8,239,357 B1
• Filed: 09/11/2009
• Issued: 08/07/2012
• Est. Priority Date: 09/12/2008
• Status: Active Grant

• Current Assignee: Ryan LLC
• Original Assignee: Ryan LLC
• Inventors: Kirkpatrick, Timothy Michael, Meredith, Kyle Day
• Primary Examiner(s): Ly, Anh
• Application Number:
  US12/557,717
• Time in Patent Office: 1,061 Days
• Field of Search: 707/705, 707/726, 707/805, 707/E17.005, 707/E17.014, 715/206, 715/700
• US Class Current: 707/705
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]

Abstract

A system and method of extracting information from electronic data sources that includes generating a list of file names containing the information to be extracted. Each file name in the list is read into memory, the file that corresponds to the file name is read into memory, and the information is extracted from the file by executing a series of programming instructions. The information is saved to an extracted file, and one or more file names in the list is identified to correspond to an extracted file.

Claims

1. A method for the automated extraction of targeted electronic data from a data warehouse, the method comprising:

creating a master list of records according to defined criteria for the targeted electronic data;

generating a pull list of target file names by removing invalid file names from the master list of records, each file name corresponding to an element of the targeted electronic data;

for each file name in the pull list of file names,

reading the file name into memory;

accessing a file that corresponds to the file name by reading the file into memory;

attempting to extract a data element from the file by executing a series of computer programming instructions, wherein the computer programming instructions act to manipulate a graphical user interface displayed on a display;

saving the extracted data element to a new file, wherein each extracted data element is saved to a separate new file; and

creating a list of found file names that correspond to each new file having an extracted data element.

2. The method of claim 1 wherein the extracting a data element from the file by executing a series of programming instructions further comprises executing a series of programming instructions to manipulate an extraction application without user input to extraction application.

3. The method of claim 2 wherein the series of programming instructions to manipulate an extraction application without user interaction comprises:

causing an internet browser software program to execute;

loading a hyperlink associated with the file;

manipulating the graphical user interface to select a command from a menu of the browser; and

sending an instruction to the internet browser software program.

4. The method of claim 3 wherein the sending an instruction to the Internet browser software program sends an instruction selected from a group consisting of save, save as, print, send, export, cut and copy.

5. The method of claim 1, further comprising:

identifying one or more file names in the pull list target file names that do not correspond to a file in the list of found file names; and

for each file name in the pull list of target file names that do not correspond to a file in the list of found file names,

reading the file name into memory;

reading a file that corresponds to the file name into memory; and

attempting to extract a data element from the file by executing a second series of programming instructions, wherein the second series of programming instructions manipulate a graphical user interface displayed on a display.

6. The method of claim 1 wherein the extracted data element is the entire file.

7. An apparatus for the extraction of targeted electronic data from a data warehouse comprising a computer-readable physical medium containing a plurality of instructions executable on a computer, wherein the plurality of instructions comprise:

instructions that create a master list of records according to defined criteria for the targeted electronic data;

instructions that generate a pull list of target file names by removing invalid file names from the master list of records;

for each file name in the pull list of target file names,

instructions that read the file name into memory;

instructions that read a file that corresponds to the file name into memory;

instructions that attempt to extract a data element from the file by executing a series of computer programming instructions, wherein the computer programming instructions manipulate a graphical user interface displayed on a display;

instructions that save the extracted data element to a new file, wherein each extracted data element is saved to a separate new file; and

instructions that create a list of new file names that correspond to each new file having an extracted data element.

8. The apparatus of claim 7 wherein the plurality of computer programming instructions further comprise instructions that manipulate an extraction application without user input to the extraction application.

9. The apparatus of claim 8 wherein the computer programming instructions to manipulate an extraction application without user interaction comprise:

instructions that execute an internet browser software program;

instructions that load a hyperlink associated with the file;

instructions that manipulate the graphical user interface to select a command from a menu of the browser; and

instructions that send an instruction to the internet browser software program.

10. The method of claim 9 wherein the instruction sent to the Internet browser software is selected from a group consisting of save, save as, print, send, export, cut and copy.

11. The apparatus of claim 7, wherein the plurality of computer programming instructions further comprise:

instructions that identify one or more file names in the pull list of target file names that do not correspond to a new file; and

for each file name in the pull list of target file names that do not correspond to a new file, read the file name into memory;

instructions that read a file that corresponds to the file name into memory; and

instructions that extract a data element from the file by executing a second series of programming instructions, wherein the second series of programming instructions manipulate a graphical user interface displayed on a display.

12. The method of claim 7 wherein the extracted data element is the entire file.

13. A system for the extraction of targeted electronic data from a data warehouse comprising:

means for creating a master list of records according to defined criteria for the targeted electronic data;

means for generating a pull list of target file names by removing invalid file names from the master list of records;

for each file name in the pull list of target file names,

means for reading the file name into memory;

means for reading a file that corresponds to the file name into memory;

means for attempting to extract a data element from the file by executing a series of programming instructions, wherein the series of programming instructions comprises a means for manipulating a graphical user interface displayed on a display;

means for saving the extracted data element to a new file, wherein each data element is saved to a separate new file; and

means for identifying one or more file names in the pull list of target files that correspond to one of the new files.

14. The system of claim 13 wherein the means for attempting to extract a data element from the file by executing a series of programming instructions further comprises means for executing a series of programming instructions to manipulate an extraction application without user input to the extraction application.

15. The method of claim 14 wherein the means for executing a series of programming instructions to manipulate an extraction application without user interaction comprises:

means for causing an internet browser software program to execute;

means for loading a hyperlink associated with the file;

means for manipulating the graphical user interface to select a command a menu of the browser; and

means for sending an instruction to the internet browser software program.

16. The method of claim 15 wherein the means for sending an instruction to the interne browser software program sends an instruction selected from a group consisting of save, save as, print, send, export, cut and copy.

17. The system of claim 13, further comprising;

means for identifying one or more file names in the pull list of target file names that do not correspond to a new file; and

for each file name in the null list of target file names that do not correspond to a new file,

means for reading the file name into memory;

means for reading a file that corresponds to the file name into memory; and

means for extracting a data element from the file by executing a second series of programming instructions.

18. The method of claim 13 wherein the extracted data element is the entire file.