Microsoft KB Archive/185018

= XADM: How to Export Public Folder Directory Data to a CSV File =

Article ID: 185018

Article Last Modified on 10/28/2006

-

APPLIES TO


 * Microsoft Exchange Server 4.0 Standard Edition
 * Microsoft Exchange Server 5.0 Standard Edition
 * Microsoft Exchange Server 5.5 Standard Edition

-



This article was previously published under Q185018



SUMMARY
This article describes how to export the directory entries for Microsoft Exchange Server public folders.

The Microsoft Exchange Administrator program does not export public folder data. In some cases, it may be useful to export the directory attributes that are associated with public folders so that you can work with this data and then import it back. You can import the .csv file by using the Exchange Administrator program.



MORE INFORMATION
You can use the Dsexport.exe utility to export directory information about public folders. The Dsexport.exe utility is available in the Microsoft Platform Software Development Kit (SDK). Dsexport.exe is located in the Samples\Dbmsg\Exchange\Dsexport directory.

Dsexport.exe has some command-line arguments that are not recognized by the Microsoft Exchange Administrator Import\Export processor. These arguments make this tool particularly useful for dumping objects other than mailbox or recipient container objects.

For more information about Dsexport.exe, see the Microsoft Platform SDK documentation.

Dsexport.exe outputs information to a text file as comma separated values (.csv). If the destination file exists before you run Dsexport.exe, and this destination .csv file lists the name of each of the desired object attributes separated by commas, the file is used as a template header file when you run Dsexport.exe. This permits you to control the object attributes that are dumped. If the .csv file does not already exist, the file is created with 13 basic fields.  Copy Dsexport.exe to the \Exchsrvr\Bin directory.  In the \Exchsrvr\Bin directory, create a text file named PFlist.csv that contains only the following line of text:

Obj-Class,Directory Name,Display Name,E-mail Addresses

You can add any other attribute that you require to this header line.  Run the following command (all on one line) from the \Exchsrvr\Bin directory:

dsexport /FILE=PFLIST.CSV /DSA=%1 /BASEPOINT=/o=%2 /ou=%3 /CLASSES=PUBLIC-FOLDER /HIDDEN /SUBTREE

where:

%1 = (Case sensitive)

%2 = (Case sensitive)

%3 = (Case sensitive)



This creates a PFList.csv file that includes one line for each public folder that is in the site.

To export a list of all public folders in the entire Exchange organization instead of for one particular site, run the following command (all on one line):

dsexport /FILE=PFLIST.CSV /DSA=%1 /BASEPOINT=/o=%2 /CLASSES=PUBLIC-FOLDER /HIDDEN /SUBTREE

Additional query words: print public folder hierarchy

Keywords: kbhowto KB185018

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.