I am wanting to import a somewhat large (~4GB) Outlook PST file to eMClient, but am running into trouble getting the “Saved Mail” folder (and it’s many sub-folders) to import into my “Local Folders” on eMClient. I selected ALL folders during import and everything else came in but that folder and subs, and then even went back and tried to import just those with no luck.
The key is that it DOES read and process ALL of this mail as I can see the folders being processed, but then doesn’t seem to put them anywhere.
I have more information. When I try to create a “Saved Mail” folder under “Local Folders” it says I can’t because there already IS one. When I right click on “Local Folders” and go to “Show/Hide Folders”, it does NOT show a “Saved Mail” folder which just happens to be hidden.
I also made a folder called “Saved” with no problem which did NOT show up under “Local Folders” but when I tried to make the same folder again it could not because it said one already exists. This folder also does NOT show up under the “Show/Hide Folders” menu.
So there seem to be folders that I can’t see, but which are not hidden according to the application.
WAIT. Now eMClient won’t open my mail and can’t fix the database. Message:
System.Data.SQLite.SQLiteException (0x80004005): attempt to write a readonly database
attempt to write a readonly database
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader…ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at MailClient.Storage.Data.DataStore.GetConnectionInternal(String relativeName)
at DbRepair.CorruptionChecker.CheckCorruption(RepairOptions repairOptions, CancellationToken token)
at DbRepair.CheckingProcess.Check(CancellationToken token)
Data:
SQLiteCommandText: pragma auto_vacuum=incremental;
databaseFile: Local Folders\mail_data.dat
I did that several times with no success; same message. It tries to repair the database and fails. I have since uninstalled it to try again; had I seen this message prior I would have been able to provide more info
I had actually started to post this update, but ran into the corruption issues below before I got this posted:
PROBLEM SOLVED: I had to shut down the application and then open it again, and the imported “Saved Mail” folders showed up (as well as the other “Saved” folder I created, which was empty).
Perhaps “Refresh” would have caused this as well? One key point is that all other folders other than those which were importing to “Local Folders” (Inbox, Drafts, Sent, Trash, etc) showed up after import WITHOUT refreshing or restarting the app, so it would not occur to the user that one DID need to refresh or restart the app.
So your fix of restarting would have worked. I still have the issue below however, and as I said, uninstalled the software so will start over.
If the database is corrupt, then there is no choice but to delete it and start again. Any messages, events and contacts saved in local folders will be lost unless you have a recent backup.
To delete the database, close eM Client, and then delete or rename C:\Users[username]\AppData\Roaming\eM Client. You may have to show hidden items in Explorer to do that.
Refresh is a command that forces a sync with POP3, calendars and contacts. This applies to online accounts only and does not refresh local folders.
I have not discovered why some local folders are not displayed until restart. There does not seem to be any pattern, but mostly they do appear immediately.
Hmmm. I guess that is a pretty big concern for me in deciding whether to move over to eMClient Pro from Outlook. Is there an automatic backup option, and whether there is is not, is the backup function incremental so that it can run pretty quickly? My starting point here is a 4GB PST file.
Thanks.
There is an automatic backup which you can configure in Menu > Tools > Settings > General > Backup. It is not incremental, but you can continue to use the application while the backup is running, so it does not matter how long it takes. It is a full snapshot of the database at the time of the backup. You will see in the settings that you can specify how many previous backups to keep to save on space.
If you are using IMAP, then your messages are already stored on a server, so there is less need for frequent backups. And if your email provider is worth anything, they will already be doing a backup of your data.
Ah, I see. I tend to avoid doing any email on mobile, so POP has always been fine for me, with all email being downloaded locally so I can completely run offline (which I need to do often). If I use IMAP, I assume you will just download headers until I select an email, and then the email content will load? Or perhaps there is a setting for this? (I am sorry for asking as I could find it myself, but as I said I have not yet reinstalled.)
Thank you for spending all the time on this. It does look like an amazing email solution for multiple accounts.
The default settings for IMAP in eM Client is such that it only downloads the header until you open the message. You can change this to enable offline use, so the entire message body and attachments will be downloaded. You will find the setting in the IMAP tab for your account in Menu > Tools > Accounts.
POP3 will always download the complete message and attachments, and then probably delete the message from the server. When using POP3 it is important to do regular backups.
Do you know whether a backup service (I use Carbonite) would be able to backup the database while eMCient is open and running, like at night? That would be another safety valve beyond your own internal backup. What file or files are part of the database?
I verified that my PST currently gets backed up each night; if eMClient could be the same, this might work.
External applications like Carbonite, cannot backup eM Client while it is running. You would have to ensure you close the application before the backup begins, otherwise your backup will contain empty files that cannot be used for a restore.
What you can do is use eM Client’s own backup, which saves the backup in your Documents folder, and then allow Carbonite to backup that file. The eM Client backup is a zipped file of C:\Users[username]\AppData\Roaming\eM Client.
One other minor thing: I am not sure that having the downloaded install file being named merely “setup.msi” is a great thing. Maybe name it something related to the name of your product? People are going to get it dumped into their “Downloads” folder and later forget what it is.
