You want to archive all emails securely on your PC/MAC/SERVER? Then I have the right solution. That's right: All emails are not archived on foreign servers, but stored directly on your computer. So, you have full control!
NOTE: The completely new version based on JAVA is now available in this offer. This means the software is not limited to Microsoft Windows, but now also works under macOS and Linux. Just everywhere where Java 17 is supported. It is still stored under SQLITE. If you are interested, even after purchase, I will provide a MySQL version in the next few weeks. Then you can also use MySQL as a database. Usually, SQLITE is sufficient because it can store data in the terabyte range. You can, if really the space is not enough simply saving the JAVA application in another folder and run it and already in a new directory the e-mail messages and e-mail attachments are stored (in the folder where this JAVA application is stored both (SQLITE database and in the attachments folder). In combination with the start and end time you will never have a bottleneck.
The license includes software updates for 1 year! The software must be extended after one year if you wish to continue using it.
With this software you can archive e-mail (IMAP) completely independent of the operating system.
The software works under Microsoft Windows, Apple macOS and under Linux (CentOS, Fedora, RHEL, AlmaLinux, Rockylinux, OpenSUSE, SLES, Ubuntu, Debian) with 64-bit.
The following records are stored in the database:
Tablename: EMailMessages
- id as UUID/VARCHAR
- smabody as LONGTEXT
Email text (text only no html - html is converted to text)
- smabodyhtml as LONGTEXT
Email text (html only)
- smacontentType as LONGTEXT
Content Type
- smaemailaccount as LONGTEXT
e.g. imap.gmail.com | irgendeineemail@gmail.com
- smaflags as LONGTEXT
Flags like /seen
- smafolder as LONGTEXT
The folder that was specified when the program was started. That is, the folder in which the e-mails are located is specified here (e.g. "inbox").
- smafrom as LONGTEXT
Who did the email came from.
- smafromAllHeaders as LONGTEXT
The complete header of the e-mail is displayed here.
- smamessageid as LONGTEXT
However, the message ID is not unique. If you delete a message then this number changes. Therefore, instead of this number a message must work only with this field "SmaUniqueMessageId".
- smareceivedDate as LONGTEXT
The date received in the following format:
Wed Jun 26 17:55:40 CEST 2019
- smarecipients as LONGTEXT
All recipients of this email in the format:
irgendeineemail@gmail.com |
- smasentDate as LONGTEXT
The send date (if it is an incoming email the date carries the date received) in the following format:
Wed Jun 26 17:55:40 CEST 2019
- smasize as BIGINT
The message size as BIGINT - for example:
61226
- smasubject as LONGTEXT
The subject of the message.
Tabellenname: EMailAttachments
- id as UUID/VARCHAR
- SmaUniqueMessageId as UUID/VARCHAR
Unique id (exists only once per email message). Is the unique id from the table EMailMessages.
- smaattfilename as LONGTEXT
File name of the attachment assigned by the system.
- smaattname as LONGTEXT
Original filename of the attachment.
- smafolder as LONGTEXT
The folder that was specified when the program was started. That is, the folder in which the e-mails are located is specified here (e.g. "inbox").
- smamessageid as LONGTEXT
The messages smamessageid have the same id of the original message from the table EMailMessages.
The attachments are stored in the program directory in the subfolder "attachments".
If you have any questions, you can always contact me at the following e-mail address:
support@auerdev.com
