Phone Lines icon GFI Support

Articles in this section

See more

How to remove the folder structure from GFI MailArchiver ( ONLY)

Author: Luis Fernandes Updated

Answer

This is a legacy article. It is not maintained anymore and might contain outdated information.
Please refer to this article instead: Script: RemoveEmptyFolderStructure (INTERNAL ONLY)


 
The following procedure explains how to remove the existing folder structure from the Archive Stores and reassociate the emails to either the Inbox or the Sent Items folder. The procedure differs if you are using Microsoft SQL or the GFI MailArchiver Firebird database as a database backend. Follow the appropriate procedure described below:
 
IMPORTANT
  • This script should be applied ONLY to installations of the following builds of GFI MailArchiver 2013: 20130510, 20130704, 20130723, 20131111
  • Please ensure to read the readme.txt bundled with the script
  • It is recommended to take a backup of your GFI MailArchiver databases before applying the scripts below
PROCEDURE
  1. Download the script: http://ftp.gfisoftware.com/support/MARC/ScriptsAndTools/2013/MARC2013_REMOVE_FOLDER_STRUCTURE_SCRIPT_20140130_01.zip
  2. Extract the download zip file
  3. It contains 4 individual scripts to be used dependent on the situation:
  • Microsoft SQL\MSSQL_MARC2013_remove_folder_structure.sql
  • Microsoft SQL\MSSQL_MARC2013_remove_folder_structure_for_user.sql
  • FireBird\FB_MARC2013_remove_folder_structure.sql
  • FireBird\FB_MARC2013_remove_folder_structure_for_user.sql

Microsoft SQL Server 2005 / 2008 / 2008R2 / 2012
 
MSSQL_MARC2013_remove_folder_structure.sql
Clears the folder structure except for Calendar folders. Each email is then associated to either the user's Inbox or Sent folder.
 
MSSQL_MARC2013_remove_folder_structure_for_user.sql
Clears the folder structure for a specific user. Each email is then associated to either the user's Inbox or Sent folder. Look for 'TODO:' tag in script to enter username.
  1. Load the 'Management Studio'
  2. Register and connect to your instance of SQL Server with 'sa' account
  3. Select File -> Open and browse for the script file
  4. Select the archive store's database on which to apply the script
  5. Modify the folder name in the TODO part of the script
  6. Press F5 to execute query

GFI MailArchiver Firebird database
 
'FB_MARC2013_remove_folder_structure.sql'
Clears the folder structure except for Calendar folders. Each email is then associated to either the user's Inbox or Sent folder.
 
'FB_MARC2013_remove_folder_structure_for_user.sql';
Clears the folder structure for a specific user. Each email is then associated to either the user's Inbox or Sent folder. Look for 'TODO:' tag in script to enter username.
 
Note: None of the scripts will remove the Inbox/Sent folders:
  1. Stop the GFI MailArchiver Store Service service
  2. Make sure that you take a backup of the Firebird database located under the GFI MailArchiver\Databases folder
  3. Load IBExpert
  4. Register and Connect to the Firebird Database
  5. Tools -> SQL Executive
  6. Load '[FB_MARC2013_remove_folder_structure.sql]' or ['FB_MARC2013_remove_folder_structure_for_user.sql']
  7. Enable 'Use current connect' check box
  8. Modify the foldername in the TODO part of the script
  9. Execute Script (Press Green Play Button)
  10. Close IBExpert
  11. Start the GFI MailArchiver Store Service service