MailAttachmentBot is a plugin for SQLMessenger designed to automate email attachment processing. It provides the following functionalities:
Automatically imports spreadsheet or text file attachments into a PostgreSQL database (installed on your computer along with SQLMessenger) when new emails are received.
Saves email attachments to a designated folder for centralized storage.
Sends a notification email to the sender confirming that their email has been processed.
Notifies the sender if an error occurs during processing, such as an incorrect file format.
After the plugin is installed and configured, the system will check the inbox every 30 seconds. If a new email is detected, it will trigger MailAttachmentBot to determine the email type and attachment format before processing the attachment. Upon successful processing, the system will send a notification email to the sender.
Get Started with MailAttachmentBot
Follow these steps to set up and start using MailAttachmentBot:
1 Install the MailAttachmentBot plugin.
2 Open the MailAttachmentBot Manager.
4 Configure email types and define the relationships between email types and file types.
5 Set up the email account to trigger MailAttachmentBot upon receiving new emails.
You can export imported data from the MailAttachmentBot File Manager to spreadsheet files for further processing. The system supports merging data from multiple tables into a single spreadsheet.
Additionally, you can configure reporting tasks in SQLMessenger to process and analyze the imported data, generating customized reports. SQLMessenger also provides a messaging feature that allows you to send these reports to colleagues or clients. For detailed instructions on configuring report tasks, please refer to the SQLMessenger documentation.
Your data and files are secure. All processing occurs locally on your computer, and no data is transmitted to external servers. Processed data and files are also stored exclusively on your machine.
PostgreSQL is an open-source relational database developed by The PostgreSQL Global Development Group.
When installing SQLMessenger, the PostgreSQL database is automatically installed. SQLMessenger uses this database to store processed data.
For more details about PostgreSQL, visit https://www.postgresql.org/about/