Bulk registration using msImportExport.exe
Bulk registration from incompatible databases is possible using the msImportExport.exe tool and XML programming.
You will need to create a tool (I.E. script or program) that will interface and extract the username, password and domain(s) for the user base. After your tool has created the XML file, you can the use msImportExport.exe to convert the users to MailSite accounts.
The syntax for msImportExport.exe is as follows:
-server [-property old1[:new1][,old2[:new2]]..]
-domains [-property old1[:new1][,old2[:new2]]..]
-mailboxes [-plugin old1[:new1][,old2[:new2]]..]
-maillists [-plugin old1[:new1][,old2[:new2]]..]
Mailbox plugin types:
|Number||Mailbox type ||Comment
|0||Registry / SQL||Mailbox information stored in Registry OR SQL database
||Mailbox information stored in Registry and in NT user database
|2||Database||Stores mailbox name, domain and password in ODBC/ SQL database
Your tool, will have to conform to this basic structure in order for msImportExport.exe to parse the information correctly into mailsite. the following structure has all the properties in the maibox option filled in except for autoreply, and alias address.
The example below contains simple information such as user name password and domain. The tool that you develop needs to conform to this XML schema.
PLAIN TEXT PASSWORD SUPPORT
To import plain text passwords, see the example below. as it has the correct syntax for creating a proper XML document to import the plain text password. Please note the values for AlienPasswordType and AlienPassword, the numeric values must be identical or the import will fail migrating passwords.
When you have completed exporting your users to the XML file, you will need to run the msImportExport command as follows:
If you are converting the user base to registry mailboxes, type:
msImportExport.exe -import XMLfile.xml -domains -mailboxes -plugin
If you are importing to a database or SQL, ensure that you have database connectivity already running.
msImportExport.exe -import XMLfile.xml -domains -mailboxes -plugin 0:0
0:0 indicates convert registry mailboxes to SQL type mailboxes.
Assuming that they are currently in registry format: mailbox plugin type=0
See these other knowledge base documents:
Last revised 2011-3-31