XADM: Bulk Import/Export FAQ

Please refer to the following Microsoft Knowledge Base articles:

152854 XADM: Using Bulk Import to Remove Data

152727 XADM: Importing Blank Value Won't Modify Mailbox Value

By default, the Secondary E-mail (Proxy) addresses are not exported. For information about how to export these addresses, please refer to the following Microsoft Knowledge Base article:

153028 XADM: How to Export Multiple (Secondary) E-mail Addresses

The following Microsoft Knowledge Base article describes how to associate more than one E-mail address with a mailbox:

148339 XADM: How to Import Multiple SMTP Addresses

The following Microsoft Knowledge Base article describes a possible reason why the export only contains header fields:

147854 XADM: Custom Recipients DIR Export Creates Headers-Only CSV

The directory import/export can be run from the command line and, therefore, can be run as part of a batch process. For more information on running import/export from the command line, please refer to Microsoft Exchange Administrator's Guide, pages 479-487.

Please refer to the following Microsoft Knowledge Base article:

152472 XADM: How to Specify a Tab or Space as Separator in .csv File

The following Microsoft Knowledge Base article provides more information about the ExportObject setting:

152300 XADM: ExportObject in Command-Line Export Options File Only

The following Microsoft Knowledge Base article describes how to perform a command line Directory Export of the Global Address List (GAL) using the Microsoft Exchange Administrator program:

149447 XADM: How to Perform a Directory Export of the GAL

Microsoft Excel has a limit of 255 characters per cell. When you open a .CSV file containing DL data, it is very likely that the Members field, which contains the members of the DL, will be larger than 255 characters in length. If you use Microsoft Excel to modify the data in the .CSV file, when you save the file any field with more than 255 characters will be truncated. This could cause problems when this data is imported back into the Microsoft Exchange system via the Directory Import command. It is possible that the members of large DLs will not have all the original members that were present when the data was exported. It is also likely that sending mail to these DLs will generate errors.

When you use the Directory Export command interactively from the Microsoft Exchange Administrator program, there is an Include Subcontainers check box on the Directory Export dialog. If this check box is set, subcontainers of the selected container will be exported.

When you run the Directory Export program from the command line, there is a setting in the Export Options file that you need to be set:

      [Export]
      Subcontainers=Yes
					

When you import data from a .CSV file, the following error might be received in the Event Log: