Difference between revisions of "Bulk Import of Email Files"

[unchecked revision][checked revision]
m (picture added)
 
(26 intermediate revisions by 5 users not shown)
Line 1: Line 1:
+++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++ DRAFT +++
 
 
 
When archiving email files, MailStore only allows archiving of individual email files (PST, MBOX) or directories which contain email files of one user (EML, MSG).
 
When archiving email files, MailStore only allows archiving of individual email files (PST, MBOX) or directories which contain email files of one user (EML, MSG).
  
The following describes how to archive all PST-, MBOX-, EML- or MSG-files of all users in a few steps, using the Python bulk import script.
+
The following describes how to archive all PST-, MBOX-, EML- or MSG-files of all users in a few steps, using a bulk import script written in Python.
  
The bulk import script expects the email files in folders that are named after  the corresponding MailStore users. Such a folder structure can easily be created by another included script.
+
The bulk import script expects the email files in folders that are named after  the corresponding MailStore users. Such a folder structure can easily be created by another script included in the [[Media:Scripts.zip|Python scripting package]].
  
If you want to archive PST- or MBOX-files of one user only, you can use the [[Windows Batch Scripts|bulkImportPST.bat- and bulkImportMBOX.bat-]]scripts from  the [[Media:MailStoreScripts.zip‎|scripting package]]. The installation of Python is not required for this purpose.
+
If you want to archive PST- or MBOX-files of one user only, you can use the bulk import scripts from  the [[Media:Batchscripts.zip|batch scripting package]]; the installation of Python is not required in that case.
  
= Preparing Python =
+
== Preparing Python ==
 +
The provided scripts are written in Python. Python 3.6 or newer is required as well as the [[Media:scripts.zip|Python scripting package]].
 +
The [[Python API Wrapper Tutorial|Python API-Wrapper]] has to be installed.
  
The provided scripts are written in Python. Python 3.2 or newer is required as well as the [Media:MailStoreScripts.zip‎|scripting package]].
+
== Preparing the Folder Structure ==
Python con be downloaded from the Python website [http://www.python.org www.python.org]. The <tt>mailstoreapi</tt> directory from the scripting package must be moved into the <tt>site-packages</tt> directory of your Python installation. The default location of Python 3.3 under Windows is <tt>C:\Python33\Lib\site-packages</tt>. The scripts themselves can be stored in any other location such as "My Documents".
+
The scripting package contains the <code>create_user_folders_server/spe.py</code> script which prepares the folders by fetching a list of existing MailStore Server users and creating folders with the same names in the filesystem. The actual bulk archiving script uses these folder names to assign the enclosed files to the corresponding users in MailStore.
  
= Preparing the Folder Structure =
+
The MailStore Server Administration API must be enabled in the [[MailStore Server Service Configuration]].
  
The scripting package contains the <tt>createUserFolders.py</tt> script. This prepares the folders by fetching a list of existing MailStore Server users and creating folders with the same names in the filesystem. The actual bulk archiving script uses these folder names to assign the files to their appropriate users in MailStore.
+
After installing Python, the script can be modified by right-clicking on it, then selecting ''IDLE'', the supplied Python editor. Adapt the values of <code>USER</code>, <code>PASS</code>, <code>HOST</code> and <code>PORT</code> to your installation.
  
The [[MailStore Server Administration API]] must be enabled in the [[MailStore Server Service Configuration]].
+
The <code>rootpath</code> variable contains the path where the folders will be created.
 
 
After installing Python, the script can be modified by right-clicking on it, then selecting ''IDLE'', the supplied Python editor. Adjust the values ​​of <tt>USER</tt>, <tt>PASSWORD</tt>, <tt>HOST</tt> and <tt>PORT</tt> according to your installation.
 
 
 
The <tt>rootpath</tt> variable contains the path where the folders will be created.
 
  
 
Press F5 to run the script. A security question follows.
 
Press F5 to run the script. A security question follows.
  
= Preparing the Archiving Profile =
+
== Preparing the Archiving Profile ==
 
 
 
Before executing the bulk import script, a new archiving profile that corresponds to the email files (PST, MBOX, EML/MSG) to be archived must be created manually in MailStore Server.
 
Before executing the bulk import script, a new archiving profile that corresponds to the email files (PST, MBOX, EML/MSG) to be archived must be created manually in MailStore Server.
  
The properties of the archiving profile get applies to all read files. For instance, if your exclude or include folders or define filters, it will be applied to all files you archive from.
+
The profile must of the type ''Single User''. The settings in this archiving profile apply to all read files. For instance, if your exclude or include folders or define filters, they will be applied to all files you archive from.
 
 
The path to the PST or MBOX file, or the folder containing EML/MSG files, that you specify in the profile does not play a role, as it gets overwritten by the bulk import script. Additionally sub folder are recognized when archiving EML/MSG files, whereas MailStore headers are always ignored.
 
 
 
<p class="msnote">'''Important Notice:''' If you want to archive PST files, Microsoft Outlook must be installed on the machine where the archiving profile is executed.</p>
 
 
 
The created profiles must be named after the file type to archive, e.g. <tt>templateBulkImportEMLMSG</tt>, <tt>templateBulkImportPST</tt> or <tt>templateBulkImportMBOX</tt>.
 
 
 
= Filling the Folders =
 
 
 
Put the email files of the users to archive into the corresponding folders under the <tt>rootpath</tt>. A simultaneous import of multiple file types is not supported. Would you like to archive PST and MBOX files, a separate run is necessary for each. 
 
  
= Archiving =
+
The path you specify in the profile to the PST or MBOX file, or the folder containing EML/MSG files, is irrelevant, as it gets overwritten by the bulk import script. Additionally, sub folders are recognized when archiving  EML/MSG files, whereas MailStore headers in EML files are always ignored.
  
Archiving is done by the <tt>bulkImport.py</tt> script. Before execution it must be adjusted to your MailStore Server installation by using ''IDLE'' (see ''Preparing the Folder Structure'').
+
<p class="msnote">'''Important Notice:''' If you want to archive PST files, Microsoft Outlook must be installed on the machine where the archiving profile is run.</p>
  
To retrieve the correct parameter values for your installation, open the properties of an existing scheduled task of a MailStore archiving profile and copy the ''Run'' command line into a text editor of your choice.<br/>Alternatively you may pretend creating a new archiving profile for an existing archiving profile, by clicking on ''Schedule'' and then ''Copy CMD''. Now open a text editor and paste  the command line to see all parameter values. It is now safe to cancel the creation of a new scheduled task.
+
Depending on the file type to be archived, the created profiles must be named <code>templateBulkImportEMLMSG</code>, <code>templateBulkImportPST</code> or <code>templateBulkImportMBOX</code>.
  
[[File:Cmd_values_en.png|center|640px]]
+
== Filling the Folders ==
 +
For each user, put the email files to be archived into the corresponding folders under the <code>rootpath</code>. When archiving PST files, these can be located in subfolders. A simultaneous import of different file types is not supported. If you want to archive PST and MBOX files, a separate run is necessary for each.
  
For the <tt>MAILSTORECMD</tt> variable, ''MailStoreCmdSilent.exe'' can be used instead of ''MailStoreCmd.exe''. This prevents MailStore from displaying empty command line windows while archiving.
+
== Archiving ==
 +
Archiving is done by the <code>bulk_import.py</code> script. Before running it must be adapted to your MailStore installation by using ''IDLE''. Since this script uses the MailStore Client to connect to the server, rather than connecting to the  MailStore Server Administration API you have to use slightly other values.
  
The bulk import script requires the encrypted version of the password. This corresponds to the value of the <tt>--pc=</tt> parameter.
+
The path to <code>MailStoreCmdSilent.exe</code>, the host name, credentials of an administrator and the <code>rootpath</code> have to be adjusted.
  
Analog to the <tt>createUserFolders.py</tt> script, <tt>rootpath</tt> points to the folder containing the actual user folders.
+
When importing into MailStore Server the <code>HOST</code> has to be in the format <code>computer:port</code>. When importing into a MailStore SPE instance the format has to be <code><nowiki>https://computer:port/instanceid</nowiki></code>.
The <tt>filetype</tt> variable can have one of the following values corresponding to the file type to archive: <tt>pst</tt>, <tt>mbox</tt> or <tt>emlmsg</tt>.
 
  
In ''IDLE'', pressing the F5 key executes the script.
+
Similar to the <code>create_user_folders_server/spe.py</code> script, <code>rootpath</code> points to the folder that contains the actual user folders.
 +
The <code>filetype</code> variable can have one of the following values according to the file type to archive: <code>pst</code>, <code>mbox</code> or <code>emlmsg</code>.
  
= Logging =
+
In ''IDLE'', press the F5 key to run the script.
  
While the archiving process runs, the progress can be monitored in the status window. The message ''exitcode: 0'' means, that the file or folder has been archived successfully. A different output would show the error. The task logs of the procedures are store in the <tt>rootpath</tt> folder and are named as follows:
+
== Logging ==
 +
While the archiving process runs, its progress can be monitored in the status window. The message ''exitcode: 0'' means that the file or folder has been archived successfully. A different output would show the error. The task logs of the procedures are stored in the <code>rootpath</code> folder and are named as follows:
  
 
   Date-Time-User-File.log (PST,MBOX)
 
   Date-Time-User-File.log (PST,MBOX)
Line 69: Line 57:
 
   Date-Time-User.log (EML/MSG)
 
   Date-Time-User.log (EML/MSG)
  
The table ''Recent Results'' in MailStore Client gives you an overview of all executed archiving profiles. Failed runs can by easily identified by its start time, as the file names of the log files begin with the same value.
+
The table ''Recent Results'' in MailStore Client gives you an overview of all run archiving profiles. Failed runs can by easily identified by their start time as the file names of the log files begin with the same value.
  
 
[[de:Massenimport von E-Mail-Dateien]]
 
[[de:Massenimport von E-Mail-Dateien]]
 +
[[en:Bulk Import of Email Files]]

Latest revision as of 15:35, 10 April 2024

When archiving email files, MailStore only allows archiving of individual email files (PST, MBOX) or directories which contain email files of one user (EML, MSG).

The following describes how to archive all PST-, MBOX-, EML- or MSG-files of all users in a few steps, using a bulk import script written in Python.

The bulk import script expects the email files in folders that are named after the corresponding MailStore users. Such a folder structure can easily be created by another script included in the Python scripting package.

If you want to archive PST- or MBOX-files of one user only, you can use the bulk import scripts from the batch scripting package; the installation of Python is not required in that case.

Preparing Python

The provided scripts are written in Python. Python 3.6 or newer is required as well as the Python scripting package. The Python API-Wrapper has to be installed.

Preparing the Folder Structure

The scripting package contains the create_user_folders_server/spe.py script which prepares the folders by fetching a list of existing MailStore Server users and creating folders with the same names in the filesystem. The actual bulk archiving script uses these folder names to assign the enclosed files to the corresponding users in MailStore.

The MailStore Server Administration API must be enabled in the MailStore Server Service Configuration.

After installing Python, the script can be modified by right-clicking on it, then selecting IDLE, the supplied Python editor. Adapt the values of USER, PASS, HOST and PORT to your installation.

The rootpath variable contains the path where the folders will be created.

Press F5 to run the script. A security question follows.

Preparing the Archiving Profile

Before executing the bulk import script, a new archiving profile that corresponds to the email files (PST, MBOX, EML/MSG) to be archived must be created manually in MailStore Server.

The profile must of the type Single User. The settings in this archiving profile apply to all read files. For instance, if your exclude or include folders or define filters, they will be applied to all files you archive from.

The path you specify in the profile to the PST or MBOX file, or the folder containing EML/MSG files, is irrelevant, as it gets overwritten by the bulk import script. Additionally, sub folders are recognized when archiving EML/MSG files, whereas MailStore headers in EML files are always ignored.

Important Notice: If you want to archive PST files, Microsoft Outlook must be installed on the machine where the archiving profile is run.

Depending on the file type to be archived, the created profiles must be named templateBulkImportEMLMSG, templateBulkImportPST or templateBulkImportMBOX.

Filling the Folders

For each user, put the email files to be archived into the corresponding folders under the rootpath. When archiving PST files, these can be located in subfolders. A simultaneous import of different file types is not supported. If you want to archive PST and MBOX files, a separate run is necessary for each.

Archiving

Archiving is done by the bulk_import.py script. Before running it must be adapted to your MailStore installation by using IDLE. Since this script uses the MailStore Client to connect to the server, rather than connecting to the MailStore Server Administration API you have to use slightly other values.

The path to MailStoreCmdSilent.exe, the host name, credentials of an administrator and the rootpath have to be adjusted.

When importing into MailStore Server the HOST has to be in the format computer:port. When importing into a MailStore SPE instance the format has to be https://computer:port/instanceid.

Similar to the create_user_folders_server/spe.py script, rootpath points to the folder that contains the actual user folders. The filetype variable can have one of the following values according to the file type to archive: pst, mbox or emlmsg.

In IDLE, press the F5 key to run the script.

Logging

While the archiving process runs, its progress can be monitored in the status window. The message exitcode: 0 means that the file or folder has been archived successfully. A different output would show the error. The task logs of the procedures are stored in the rootpath folder and are named as follows:

 Date-Time-User-File.log (PST,MBOX)

or

 Date-Time-User.log (EML/MSG)

The table Recent Results in MailStore Client gives you an overview of all run archiving profiles. Failed runs can by easily identified by their start time as the file names of the log files begin with the same value.