Granted Patent B2

US 8,996,634 · App. 13/591,581 · Granted Mar 31, 2015

Abstract

Claims (63)

1. A system comprising:

a computer processor;

memory;

querying logic configured with a first configuration information file for selecting data from a plurality of data sources,

wherein the first configuration information file is saved in the memory, and the first configuration information file includes a plurality of sets of instructions for selecting the data from the plurality of data sources, each set of instructions comprising:

a connection string to connect to a data source, the connection string being abstracted by an operating system, wherein the operating system is a WINDOWS operating system;

a structured query language statement to select data from the data source to send in a message;

a subject of the message;

a message header; and

an address corresponding to a sender of the message;

email messaging logic configured with at least a second configuration information file for automatically sending the data selected within the message to an address entry of an address list, wherein the second configuration information file specifying the address list is saved in the memory and includes a list of addresses for sending the message;

a scheduler for scheduling a periodicity that the data selected is sent by the email messaging logic, wherein the scheduler is a WINDOWS scheduler;

testing logic configured to test a connection to the data source according to the connection string,

wherein the plurality of sets of instructions for selecting the data from the plurality of data sources contains instructions for connecting to at least two different data sources; and

the email messaging logic is configured to generate an error file when a configuration information file results in an error.

2. The system of claim 1 , wherein the first configuration information file further includes a default email address.

3. The system of claim 1 , wherein the error file contains a time that the error occurred and a name of the configuration information file that was in use at the time that the error occurred.

4. The system of claim 1 , wherein the error comprises at least one of an incorrect query, an incorrect user name, an incorrect password, an incorrect connection string, or invalid file formatting.

5. The system of claim 1 , wherein said each set of instructions further comprises a message footer that is to be included at a bottom of the message.

6. The system of claim 1 , wherein the first configuration information file further includes a default email address; wherein the error file contains a time that the error occurred and a name of the configuration information file that was in use at the time that the error occurred; wherein the error comprises at least one of an incorrect query, an incorrect user name, an incorrect password, an incorrect connection string, or invalid file formatting; and wherein said each set of instructions further comprises a message footer that is to be included at a bottom of the message.

7. A method of automatically transmitting data comprising:

maintaining an address list of address entries;

configuring a first configuration file with information to select data from a plurality of databases and to automatically send data from the plurality of databases to the address entries in the address list, wherein the address list is specified in a second configuration file;

executing an application using the information from the first configuration file to send a plurality of messages including data from the plurality of databases to the address entries in the address list using an email messaging system,

wherein the information in the first configuration file includes a plurality of sets of instructions for selecting the data from the plurality of data sources, each set of instructions comprising:

a connection string to connect to a data source, the connection string being abstracted by an operating system, wherein the operating system is a WINDOWS operating system, wherein the plurality of sets of instructions for selecting the data from the plurality of data sources contains instructions for connecting to at least two different data sources;

a structured query language statement to select data from the data source to send in a message;

a subject of the message;

a message header; and

an address corresponding to a sender of the message,

wherein the second configuration file specifying the address list includes a list of addresses for sending the message;

scheduling a periodicity that the data selected is sent using a WINDOWS scheduler;

testing a connection to the data source according to the connection string; and

generating an error file when an error results from the execution of the application.

8. The method of claim 7 , wherein the first configuration file further includes a default email address.

9. The method of claim 7 , wherein configuring the first configuration file further includes configuring the email messaging system.

10. The method of claim 7 , wherein the error file contains a time that the error occurred and a name of the configuration information file that was in use at the time that the error occurred.

11. The method of claim 7 , wherein the error comprises at least one of an incorrect query, an incorrect user name, an incorrect password, an incorrect connection string, or invalid file formatting.

12. The method of claim 7 , wherein said each set of instructions further comprises a message footer that is to be included at a bottom of the message.

13. The method of claim 7 , wherein the first configuration information file further includes a default email address; wherein the error file contains a time that the error occurred and a name of the configuration information file that was in use at the time that the error occurred; wherein the error comprises at least one of an incorrect query, an incorrect user name, an incorrect password, an incorrect connection string, or invalid file formatting; and wherein said each set of instructions further comprises a message footer that is to be included at a bottom of the message.

14. A non-transitory computer readable storage medium including executable computer code for performing a method for automatically sending a message with selected data, the method comprising:

saving an address in a memory device, the address corresponding to an intended recipient of the message;

selecting a set of instructions, from a plurality of sets of instructions contained in a first configuration file, for selecting data from a plurality of databases of a plurality of data servers, each set of instructions comprising:

a connection string to connect to a database, the connection string being abstracted by an operating system, wherein the operating system is a WINDOWS operating system and the plurality of sets of instructions for selecting the data from the plurality of databases contains instructions for connecting to at least two different data servers of the plurality of data servers;

a structured query language statement to select data from the database to send in the message;

a subject of the message; and

a message header;

for each set of instructions, connecting to the database and querying the database for selected data from the database;

for each set of instructions, creating the message to include the results of the query;

for each set of instructions, automatically sending the message to the address of the intended recipient using an email messaging system, wherein the address is specified in a second configuration file, wherein the sending of the message is according to a schedule defined using a WINDOWS scheduler;

scheduling a periodicity that the message is sent using the WINDOWS scheduler;

saving an address corresponding to a sender of the message in the first configuration file;

saving the address corresponding to the intended recipient in a list of addresses for sending the message in the second configuration file, wherein the first configuration file contains

a name of the second configuration file;

saving a name of a file where queries are stored in the first configuration file;

checking for an error resulting from the execution of the query;

testing a connection to the database according to the connection string; and

generating an error file when an error results from the execution of the query.

15. The non-transitory computer readable storage medium of claim 14 , wherein the error file contains a time that the error occurred and a name of the configuration information file that was in use at the time that the error occurred.

16. The non-transitory computer readable storage medium of claim 15 , wherein the error comprises at least one of an incorrect query, an incorrect user name, an incorrect password, an incorrect connection string, or invalid file formatting.

17. The non-transitory computer readable storage medium of claim 14 , wherein said each set of instructions further comprises a message footer that is to be included at a bottom of the message.

18. The non-transitory computer readable storage medium of claim 14 , wherein the first configuration information file further includes a default email address.

19. The non-transitory computer readable storage medium of claim 14 , wherein the first configuration information file further includes a default email address; wherein the error file contains a time that the error occurred and a name of the configuration information that was in use at the time that the error occurred; wherein the error comprises at least one of an incorrect query, an incorrect user name, an incorrect password, an incorrect connection string, or invalid file formatting; and wherein said each set of instructions further comprises a message footer that is to be included at a bottom of the message.

Assignments (10)