Welcome to IMI GAL Exporter

The Global Address List Exporter for Microsoft Exchange Server (further referred to as - IMI GAL Exporter), is a small convenient tool for Microsoft Exchange Server administrators and Microsoft Office Outlook, which facilitates the export of GAL (Global Access List).

The user may export the entire GAL or choose one port or separate containers with Mailboxes and/or Distributions Lists. The available versions of Microsoft Exchange Server do not support the option, which is why we undertook the development of this product.

With its help you may choose which exact options of Mailboxes/Distributions Lists you need exported, the database where the information is stored, and the table names.

This may help you organize your work better.

Software requirements

To use “IMI GAL Exporter” you need a valid MAPI profile on your computer. This profile has to be configured correctly so that you can use the options of Microsoft Exchange Server. If so far you have used your Microsoft Outlook in Corporate or Workgroup mode, you are familiar with the configuration of MAPI profile and you may skip this part of the manual.

The Messaging API (MAPI) is a COM-like API that provides access to the contents of messaging stores. "Extended MAPI" provides access to Microsoft Office Outlook/Microsoft Exchange Server - compatible objects. Using Extended MAPI, a program can connect to a Message store, and then perform operations against that store.

MAPI is an automatic install with the full version of Microsoft Office, provided Microsoft Outlook to work in Corporate or Workgroup mode.

Note: This is a 32 bits application and supports only 32 bits version of Microsoft Office!

Starting with Exchange 2007, Microsoft distribute the MAPI client libraries and CDO 1.2.1 as a Web download - Microsoft Exchange Server MAPI Client and Collaboration Data Objects 1.2.1

If your PC Box does not have Microsoft Outlook installed, you can get "Extended MAPI" from the link above.

Note: Only for Outlook 98/2000 - Corporate or Workgroup mode is required!

You may check/change the working regime of your Microsoft Office Outlook (98/2000) as follows:

• Select Options from the Outlook menu (see fig. 1)

Fig. 1

• Select Mail Services and click Reconfigure Mail Support (see fig. 2)

Fig. 2

• This will open a window similar to the one shown on fig. 3. If the Corporate or Workgroup regime is checked, this means that the full version of MAPI has been installed on the user PC, if not, you should check the Corporate or Workgroup option and follow the steps of the Wizard.

Fig. 3

MAPI profile

To use “IMI GAL Exporter” you need a valid MAPI profile on your computer. This profile has to be configured correctly so that you can use the options of Microsoft Exchange Server. If so far you have used your Microsoft Outlook in Corporate or Workgroup mode (Outlook 98-2000 only), you are familiar with the configuration of MAPI profile and you may skip this part of the manual.

To configure MAPI profile you need to click on the Mail icon from the Control Panel of your computer (see fig. 4). 

fig. 4

The window on fig. 5 will open.

fig. 5

The profile contains the options supported by Microsoft Exchange Server (see fig. 6). Use the Help provided by Microsoft for the configuration of MAPI profile. If you encounter difficulties, ask your system administrator for help.

fig. 6

 For Outlook 2002/2003/2007/2010 configuration is similar.

Getting started

Authentication

The profile selection is performed through Authentication.

The program will allow you to select the MAPI/Outlook profile you are going to use:

• The default one
• Another existing profile as selected by you
• Temporary profile

If there are several Microsoft Exchange Server Organizations in your local area network you can - through the selection of a concrete profile - perform the export of data placed in different Microsoft Exchange Server Organizations from one workplace.

If you are unsure of the number of Microsoft Exchange Server Organizations in you LAN or you encounter difficulties in the selection of profile, ask your system administrator.

Click on the “Log On” button to continue.

If you have selected “Without Profile” a new dialogue window will ask you for a name of the Exchange Server and a username.

To continue you should verify the entered data and then click on the “Check Name” button.

On the left side of the application there will be a list with the available address books. When you choose one of them the right side of the application will show the names of the users with their email addresses. This list is only for information. You can restrict it at a later stage.

If you are working with Microsoft Office Outlook 2010 and there is more than one Exchange Server to your MAPI profile you can choose a specific Address list for export.

Select the folder with the recipients  you want to export. 

Select the Next button so that you get the desired format of the exported file.

Choose the format of the file to which you are going  to export.

Depending on the format you have chosen you can define additional formatting values. They are available for:

• CSV
• XML
• HTML

Available fields:

• DateTime Format - A date and time format string defines the text representation of a DateTime value. For example, the Birthday field for a given contact is from DateTime type.
• Boolean True/False - how to define Boolean values in the exported file. For example, the field 'Private for a given contact is from Boolean type.
• Float Format - how to define digital values containing a decimal point in the exported file.
• Currency Format - how to define Currency values in the exported file.  For example, the additional field Salary is from Currency type.
• Null string - how to define values from the fields without an assumptive value.

CSV Options

• Quote string - When we use literal strings we use the single quote (‘) character to indicate the beginning and ending of a string for some field (in case when delimiter is space). For example – ‘this is a string’ ‘this is second string’
• Comma – default delimiter between the fields in the exported file
• Multi-Value delimiter – certain properties contain more than one row. For example, the field Children. In order to separate each value and reorder the fields into one, you should choose Multi-Value delimiter or use the default one – pipe

SQL Options

• Table Name – The name of SQL table
• Add “Create Table statement” – in the title section it adds the following SQL text in the exported file
  CREATE TABLE [TableName] (TableFieldDefinition);
• Commit Options – some SQL servers provide the opportunity of saving the data at a certain stage of the implementation of the script. This can be done through the Commit SQL instruction. For example, you can save the result every 10 entries – then, for Commit after, you should set the value of 10. If you want to perform the Commit operation after the last entry as well then you should choose Commit after script.

An example of exported file with the following settings:

XML Options

• Standalone - The XML standalone element defines the existence of an externally-defined DTD.

It is a value element and stores the data corresponding to the value of the standalone string in the declaration. It is always a child of the XmlDecl element. Valid values for the standalone element are yes and no. An result example is shown below:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<!DOCTYPE s1 PUBLIC "http://www.imibo.com/example.dtd" "example.dtd">

<s1>.........</s1>

• ADO Friendly – the generated exported file, can be next imported in any application supporting ADO (Active Data Objects) such as Microsoft SQL Server 2005 and above, Microsoft Access 2000 and above, etc..

HTML Options

• You can define the font (name and size) of the text as well as the color used in the cells. Title of the HTML page.

• You can define the font (name and size) of the text
• Background image

Microsoft Access & Office Excel Options

• Define the name of the table in Microsoft Access (Worksheet in Microsoft Excel)

Export options

You can choose which specific properties of the items to include in the exported file. You can also save as collection the columns defined by you and use it again at a later stage.

You can define which specific items to export – Mailboxes, Distribution Lists, Public Folder (if they have an alias е-mail address), Remote Mail Users.

It you do not choose any of these items all of them will be exported.

If „Export also Object type info”, option is chosen in the exported file, information for the item will be included in a first column - Mailbox (User), Distribution List, etc.

You can also restrict the exported result if you create a filter. For example, you can include only those users (items) for which, for instance, the field City equals New York.

When you export Distribution List and the DL Members field has been chosen you can determine which address to include in the export - SMTP or Exchange.

 To continue click on the Export button and the actual export of the data will begin.

Distribution List Exporter for Exchange Server

Distribution List Exporter for Exchange Server is in addition to IMI GAL Exporter, which gives you the unique opportunity to export the members of Exchange Server Distribution List.  The available versions of Microsoft Exchange Server do not support the option, which is why we undertook the development of this product.

The user interface is similar to the one of IMI GAL Exporter. Therefore, we will pay attention only to the differences.

After you have chosen MAPI/Outlook profile and there is a connection with Microsoft Exchange Server you will be able to see all available visible Distribution Lists. Choose the one you want to export and then click on Next button in order to select format of the file.

Choose the format of the file to which you are going  to export.

Please see  section for IMI GAL Exporter

Export options

You can choose which specific properties of the items to include in the exported file. You can also save as collection the columns defined by you and use it again at a later stage.

To continue click on the Export button and the actual export of the data will begin.

IMI GAL Exporter Console

“IMI GAL Exporter Console” is an individual application supporting the same options as IMI GAL Exporter, except for user interface. With it you can export data from the command line, include the application in a batch process, start it through script languages such as Perl, Java Script, VB script, etc.

“IMI GAL Exporter Console” (GALExportConsole.exe) uses the configuration file Imigalec.ini in the same directory. You may edit it using any text editor (e.g. Notepad).

The configuration file is divided into sections:

Example file:

; This version of imigalec.ini use MAPI PROFILE
; The process/user running this application should have
; Administrative rights over Microsoft Exchange Organization, Site, Server


[Config]
; ShowExportProgress 0 or 1
ShowExportProgress = 1

; If the value is 1 then some of succeeded actions (and all errors) will be logged
; The application uses Windows Application Event Log for that propose
; Accept 0 (FALSE) or 1 (TRUE)
LogSuccess = 1


; For creating a temporary MAPI profile
; Mailbox - Display name or Alias of Mailbox with Admin rights over
; MS Exchange Organization, Site, Server
; ServerName - Exchange Server where is located this Mailbox
; If Mailbox or ServerName is Empty DEFAULT MAPI PROFILE will be used.

; For example:
; Mailbox = A.King
; ServerName = MyExchangeServer

Mailbox =
ServerName =

; If you like application to use an existing Microsoft Office Outlook profile
; For example Outlook

Profile = Outlook


;DList Members Export Address
; How to export EMS_AB_MEMBER property (see below)
; 0 means None, only Display Name will be exported.
; 1 means SMTP Address will be exported also
; 2 means EX Address will be exported also

DLMembersExportAddress = 0


; Export To
; Type of exported file
; Valid options are:
; 0 -> CSV file (A comma-separated values)
; 1 -> SQL file (SQL script)
; 2 -> XML file (Extensible Markup Language)
; 3 -> HTML file(Hypertext Markup Language)
; 4 -> Microsoft Office Excel XLS
; 5 -> Microsoft Office Access MDB

ExportTo = 3


; FilePathAndName - Path and name for exported file
; If it is EMPTY then file will be created in current directory with
; name IMIGAL.XXX where XXX is file extension from ExportTo parameter

FilePathAndName = C:\MyGAL.htm


; AsUNICODE
; Save CSV, SQL, HTML, XML file in UTF-8 format
; Default is 0 (False) - ANSI will be used. Use 1 to enable UTF-8
AsUNICODE =

[GENERAL FORMAT OPTIONS]

; SQLStatementTerminator
; By default, the SQL export uses a semicolon ( ; ) as the default statement terminator.
; You can specify a different statement terminator for an SQL statement.
SQLStatementTerminator =

; SQLCommitStatement
; The SQL commit statement ends a unit of work and commits the database changes that were made by that unit of work.
; By default, the SQL export uses a "COMMIT"
SQLCommitStatement =

; SQLTableName
; The SQL/Excel Sheet/Access Table name
; If not specified, the application will use as default "GAL" as Table/Sheet name
SQLTableName =

; CreateSQLTable
; When it is 1 (true), the application will include "CREATE TABLE" statement
; For example as: CREATE TABLE [GAL] (id INT, data VARCHAR(100));
; Default value is 1 (true)
CreateSQLTable =

; SQL Commit After Script
; Add SQLCommitStatement at end of SQL sqript
; Default value is 0 (false)
SQLCommitAfterScript =

; BooleanTrue
; How to save True values in exported file
; Default is "TRUE"
BooleanTrue =

; BooleanFalse
; How to save False values in exported file
; Default is "FALSE"
BooleanFalse =

; DateTime Format
; How to save Date/Time values in exported file
; Default value is fetched from LOCAL regional settings
; For USA it is mm/dd/yyyy hh:nn:ss
; For most of EU countries it is dd/mm/yyyy hh:nn:ss
; Where yyyy - year, mm - month, dd - day, hh - hour, nn - minutes, ss - second
; SQL export uses always "yyyy-mm-dd hh:nn:ss" as DateTime Format
DateTimeFormat =

; CSV Quote
; Default value is "(double quote)
CSVQuote =

; Use CSVQuote
; Default value is 1 (True)
UseCSVQuote =

; Multi Value
; Multi values delimiter
; Default is | (Pipe character)
MultiValue =


[RESTRICTION]
; USE - Can be 0 that means NOT RESTRICTION, or 1 - restrictions will be used
; Default = 0
; If the table requested by this operation contains too many names and cannot be accessed, restriction is ignored
USE =0

; PROP - Name of Property identifying the string property to be checked for occurrence of the search string.
; Property should be included in the exported file
; Valid properties are all string properties

; EMS_AB_ASSOC_NT_ACCOUNT, EMS_AB_MANAGER, EMS_AB_REPORTS, CREATION_TIME, LAST_MODIFICATION_TIME CANNOT BE USED!!!
PROP =

; VAL = Containing the string value to use as a restriction string.
; EMPTY value ignores all Restriction settings
VAL =

; OPER - can be 1 or 2
; OPER describe how to search restricted field for matching
; No Default Value !

; 1 is "SUBSTRING" //  slow
; To match, the search string (VAL) must be contained anywhere within the property identified by PROP.

; 2 = "PREFIX" // fastest
; To match, the search string (VAL) must appear at the beginning of the property identified by PROP.
; The two strings should be compared only up to the length of the search string indicated by PROP.

OPER = 2

[EXPORTS]
; TYPE - Define type of Object to be exported
; 0 or Empty = All Objects - Mailboxes, Distribution list, Public folder, Remote Mail user
; Sum of types are allowed - for example 5 will export 1 (Mailboxes) and 4 (Public folders), or 3 will export
; Mailboxes and Distribution Lists
; 1 = Mailboxes
; 2 = Distribution list
; 4 = Public folder
; 8 = Remote Mail user
TYPE = 0


; The section below describes the properties that can be exported
; If value is 0 or EMPTY, the property will be IGNORED
; To include property in a export table, value should be 1
; PropertyName = 0
; or
; PropertyName = 1

[Property]

; OBJECT Type
; # 0
; The property contains the Object type as Mailbox, Distribution List, Remote User, etc
Object type = 1

; GIVEN_NAME
; # 1
; The property contains the first name of the recipient
First Name = 1

; INITIALS
; # 2
; The property contains the initials for parts of the full name of the recipient
Initials = 1

; SURNAME
; # 3
; The property contains the recipient's family name
Last Name = 1

; DISPLAY NAME
; # 4
; The property contains recipient's display name
Display Name = 1

; ACCOUNT
; # 5
; The property contains the recipient's alias
Alias = 1

; SMTP ADDRESS
; # 6
; The property contains the recipient's Primary E-Mail address
Primary E-Mail address = 1

;EMAIL ADDRESS
; # 7
;The property contains the messaging user's EX e-mail address as /c=US/a=att/p=Microsoft/o=Finance/ou=Purchasing/s=Furthur/g=Joe
Native E-Mail address = 1

;AB DESCRIPTION
; # 8
;The property contains an optional description of an object.
Description = 1

; COMMON NAME
; # 9
; The property contains the common name of a messaging user
Common Name = 1

; AB ASSOC NT ACCOUNT
; # 10
; The property contains the primary Windows NT account associated with a mailbox
Windows NT account = 1

; BUSINESS ADDRESS STREET
; # 11
Address = 1

;BUSINESS ADDRESS CITY
; # 12
City = 1

;BUSINESS ADDRESS STATE OR PROVINCE
; # 13
State = 1

;BUSINESS ADDRESS POSTAL CODE
; # 14
Zip Code = 1

;BUSINESS ADDRESS COUNTRY
; # 15
Country = 1

;TITLE
; # 16
Title = 1

;COMPANY NAME
; # 17
Company = 1

;DEPARTMENT NAME
; # 18
Department = 1

;OFFICE LOCATION
; # 19
Office = 1

;ASSISTANT
; # 20
Assistant = 1

;BUSINESS TELEPHONE NUMBER
; # 21
Phone = 1

;AB MANAGER
; # 22
Manager = 1

;AB REPORTS
; # 23
Direct reports = 1

;AB IS MEMBER OF DL
; # 24
Distribution List Membership = 1

;BUSINESS2 TELEPHONE NUMBER
; # 25
Phone Business 2 = 1

;PRIMARY FAX NUMBER
; # 26
FAX = 1

;ASSISTANT TELEPHONE NUMBER
; # 27
Phone Assistant = 1

;HOME TELEPHONE NUMBER
; # 28
Phone Home = 1

;HOME2 TELEPHONE NUMBER
; # 29
Phone Home 2 = 1

;CELLULAR TELEPHONE NUMBER
; # 30
Phone Mobile = 1

;BEEPER TELEPHONE NUMBER
; # 31
Pager = 1

;COMMENT
; # 32
Notes = 1

;AB PROXY ADDRESSES
; # 33
Proxy Addresses = 1

;CREATION TIME
; ; # 34
When Created = 1

;LAST MODIFICATION TIME
; # 35
When Changed = 1

;AB EXTENSION ATTRIBUTE_1
; # 36
Custom attribute 1 = 1

;AB EXTENSION ATTRIBUTE_2
; # 37
Custom attribute 2 = 1

;AB EXTENSION ATTRIBUTE_3
; # 38
Custom attribute 3 = 1

;AB EXTENSION ATTRIBUTE_4
; # 39
Custom attribute 4 = 1

;AB EXTENSION ATTRIBUTE_5
; # 40
Custom attribute 5 = 1

;AB EXTENSION ATTRIBUTE_6
; # 41
Custom attribute 6 = 1

;AB EXTENSION ATTRIBUTE_7
; # 42
Custom attribute 7 = 1

;AB EXTENSION ATTRIBUTE_8
; # 43
Custom attribute 8 = 1

;AB EXTENSION ATTRIBUTE_9
; # 44
Custom attribute 9 = 1

;AB EXTENSION ATTRIBUTE_10
; # 45
Custom attribute 10 = 1

;AB EXTENSION ATTRIBUTE_11
; # 46
Custom attribute 11 = 1

;AB EXTENSION ATTRIBUTE_12
; # 47
Custom attribute 12 = 1

;AB EXTENSION ATTRIBUTE_13
; # 48
Custom attribute 13 = 1

;AB EXTENSION ATTRIBUTE_14
; # 49
Custom attribute 14 = 1

;AB EXTENSION ATTRIBUTE_15
; # 50
Custom attribute 15 = 1

;AB OBJ VIEW CONTAINERS
; # 51
View Containers = 1

;AB ALT RECIPIENT
; # 52
Alternate recipient = 1

;AB MEMBER
;The property contains the list of members of a distribution list.
; # 53
DList Members = 1

;AB HOME_MDB
;Exchange Server name where Mailbox reside
; # 54
Home Server = 1

Tabular presentation of the possible fields in the exported file

Format Specifiers 

DateTime Format - How to save Date/Time values in exported file
Default value is fetched from LOCAL regional settings
For USA it is mm/dd/yyyy hh:nn:ss
For most of EU countries it is dd/mm/yyyy hh:nn:ss

Where yyyy - year, mm - month, dd - day, hh - hour, nn - minutes, ss - second
SQL export uses always "yyyy-mm-dd hh:nn:ss" as DateTime Format

In the following table, specifiers are given in lowercase. Case is ignored in formats, except for the "am/pm" and "a/p" specifiers.

Float/Currency Format - formats the floating-point value. The following format specifiers are supported in the format string.

IMI GAL Exporter
Copyright © 1999 - 2011 IMIBO All rights reserved.