Quick start guide to create export tasks for Enterprise Manager with the CSV to XML tool (Bulk PST Export) (4231092)

1. Click the red "Setup Wizard" button
2. Press both "Get" buttons
   
   
   1. SQL String is the SQL connection string value from the registry located under:
      [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Metalogix\exchangePAM\DataBase]
      "PamDBConnectionString"="Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=xxxxxxx;Initial Catalog=xxxxxxxx;User Id=xxxx;"
   2. DB owner value is located in the registry:
      [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Metalogix\exchangePAM\DataBase]
      "PamDBSchema"="xxxxxx"
   3. Click the TEST button to verify the connection and if successful click the Next button
3. Export base folder sets the location where the PST files will be exported.
   This setting is read from the exchangePAMManagerSv.config file which is located under:
   C:\Program Files (x86)\Metalogix\MAM4Exchange\Services\exchangePamManager
   
   
   
   The values specified in the Exportbase folder must match the value in the XML file!
4. Once configured, save the configuration and restart the tool.

Prepare the mailboxes for the export

1. In the main window specify the mailbox ID of the mailbox to be exported. This value can be found in the Enterprise Manager > Address book manager > Mailboxes tab or via SQL in the EXCHANGEPAMMAILBOXES table. You can enter multiple mailbox IDs separated by a comma ( for example: 4,5,9).

2. Here you can specify also additional filtering by Received Date.

3. It is recommended to turn on GetFile - Create folder structure option

4. Press the Create CSV button to create the CSV file for further processing.

5. * You can create the CSV file yourself if it should fail for some reason. You need to run the following query to get the needed columns:
   SELECT DOCGUID, DocVersion, MBXID, ParentFolder FROM EXCHANGEPAMDOCUMENTS WHERE MBXID = XX

   
   The CSV file MUST NOT contain headers and the values have to be separated by a comma!

Processing the CSV Files

1. Now the CSV Files have been created but they may contain too many items.
   It is recommended to keep a maximum of 100.000 items per XML file.
   Check the "Items per Xml" option and specify a value.

2. Click the CSV to XML button.

Injecting the XML Export task into the Enterprise Manager

1. It is recommended to create a copy of the existing files and folder under the Export Base folder.
   Injecting the XML Files will stop all running export tasks and will add the new tasks to the existing tasklist.xml.
   Press the Inject button and restart the Enterprise Manager console and the MAM Exchange Manager service in order
   to reload the tasklist. Once started navigate to Tools > Export Tasks in the Enterprise Manager console and start the
   export tasks. You should run a maximum of 4 export tasks at once! More tasks may crash the MAM Handler service!