Automated messaging tool
A system and method for an automatic messaging system which automatically sends emails or pages to groups of people with specific data from a database. Other messaging tools may be utilized. The data source that provides information may be any ODBC compliant data source including standard DBMS (SQL Server, Oracle, Informix, DB2, Sybase, etc.) Access databases, or Excel spreadsheets.
1. A computer-implemented method comprising:
accessing, by an executable application, a main configuration file comprising a message sender, an address list including one or more message recipients, and query information identifying data to be queried from a database;
accessing, by the executable application, a message configuration file that includes definitions for one or more data queries defining the data that are to be queried from the database;
querying, by the executable application, the database for the data defined by the message configuration file; and
sending, by the executable application, a message from the message sender identified in the main configuration file to the one or more message recipients identified in the address list, the message including the data queried from the database.
2. The computer-implemented method of claim 1 , wherein the message configuration file includes one or more message parameters that are used by the executable application when sending the message.
3. The computer-implemented method of claim 2 , wherein the message parameters include a beginning delimiter and an ending delimiter specifying boundaries for the message parameters.
4. The computer-implemented method of claim 3 , wherein the beginning delimiter indicates to the executable application that the message parameters start from a specified line in the message configuration file, and wherein the ending delimiter indicates to the executable application that the message parameters stop on a specified line in the message configuration file.
5. The computer-implemented method of claim 2 , wherein a subsequent set of message parameters for at least one other message is specified in the message configuration file.
6. The computer-implemented method of claim 5 , wherein the subsequent set of message parameters for the at least one other message is implemented to send out a sequence of messages to one or more specified users identified in the address list.
7. The computer-implemented method of claim 1 , wherein a single command input at the executable application initiates transmission of one or more messages to a plurality of specified users identified in the address list.
8. The computer-implemented method of claim 1 , wherein the executable application is executed on a client computer system.
9. The computer-implemented method of claim 1 , wherein the executable application is executed on a server computer system.
10. The computer-implemented method of claim 1 , wherein the message sent from the message sender identified in the main configuration file is sent in a specified format.
11. The computer-implemented method of claim 1 , wherein a receiving device of the message recipient comprises at least one of:
a personal computer (PC) configured to display a notification through communications software;
a television;
a cellular phone;
a pager; or
a personal data assistant.
12. The computer-implemented method of claim 1 , wherein sending, by the executable application, the message from the message sender identified in the main configuration file to the one or more message recipients identified in the address list further comprises:
accessing, by the executable application, a list of valid message servers configured to send messages; and
sending the message from one of the valid message servers identified in the accessed list of valid message servers.
13. A system comprising a memory storing executable computer instructions that, when executed by a processor, perform operations including:
accessing, by an executable application, a main configuration file comprising a message sender, an address list including one or more message recipients, and query information identifying data to be queried from a database;
accessing, by the executable application, a message configuration file that includes definitions for one or more data queries defining the data that are to be queried from the database;
querying, by the executable application, the database for the data defined by the message configuration file; and
sending, by the executable application, a message from the message sender identified in the main configuration file to the one or more message recipients identified in the address list, the message including the data queried from the database.
14. The system of claim 13 , wherein the message configuration file includes one or more message parameters that are used by the executable application when sending the message.
15. The system of claim 14 , wherein a subsequent set of message parameters for at least one other message is specified in the message configuration file.
16. The system of claim 15 , wherein the subsequent set of message parameters for the at least one other message is implemented to send out a sequence of messages to one or more specified users identified in the address list.
17. The system of claim 13 , wherein a single command input at the executable application initiates transmission of one or more messages to a plurality of specified users identified in the address list.
18. The system of claim 13 , wherein the message sent from the message sender identified in the main configuration file is sent in a specified format.
19. The system of claim 13 , wherein sending, by the executable application, the message from the message sender identified in the main configuration file to the one or more message recipient identified in the address list further comprises:
accessing, by the executable application, a list of valid message servers configured to send messages; and
sending the message from one of the valid message servers identified in the accessed list of valid message servers.
20. A non-transitory computer-readable medium comprising computer-readable instructions that, when executed by at least one processor of a computing device, cause the computing device to:
access, by an executable application, a main configuration file comprising a message sender, an address list including one or more message recipients, and query information identifying data to be queried from a database;
access, by the executable application, a message configuration file that includes definitions for one or more data queries defining the data that are to be queried from the database;
query, by the executable application, the database for the data defined by the message configuration file; and
send, by the executable application, a message from the message sender identified in the main configuration file to the one or more message recipients identified in the address list, the message including the data queried from the database.