Google
Search WWW Search msexchangetips.blogspot.com

Wednesday, August 30, 2006

Exchange: Export GAL Using CSVDE

Summary:

One common request is "How do I export the contents of the GAL?" Unfortunately there are no native tools that simply export the contents without some work. There are some third party tools such as IMI GAL Exporter ver.3 which you can purchase for a few bucks. I have tested their trial version is appears to be a very neat utility. The other option is to use LDIFDE and CSVDE. Unfortunately, you have to know all the attributes listed in the GAL so you can export them out. I have provided the following CSVDE command to export most if not all the attributes in the GAL.

From a command prompt type the following command.Substitute the following string

"dc=corp,dc=company,dc=net" with your Fully Qualified Domain Name. Use Excel to open the file when complete.


C:\>csvde -r "(objectClass=user)" -d "dc=corp,dc=company,dc=net" -l disp
layname,title,description,company,department,assistant,
physicaldeliveryofficename,telephoneNumber,othertelephone,
mail,streetaddress,postofficebox,l,st,postalcode,co,homephone,
otherhomephone,pager,otherpager,mobile,othermobile,
facsimileTelephoneNumber,info,manager,memberOf -f c:\gal.csv

Connecting to "DC1.corp.company.net"
Logging in as current user using SSPI
Exporting directory to file c:\gal.csv
Searching for entries...
Writing out entries.............................................................




James Chong
MCSE M+, S+, MCTS, Security+
msexchangetips.blogspot.com


How useful was this article? Want to see a tip not listed? Please leave a comment.

5 Comments:

Anonymous Anonymous said...

Excellent. So I've exported the GAL.
Say I want to update all the phone numbers or departments, can I then somehow import this back into the AD?

5:39 PM  
Anonymous Anonymous said...

That's an excellent question. I was wondering the same thing. Or, if one were to take the export of the GAL, and import it as contacts on another system, how would you do that?

8:52 AM  
Anonymous Anonymous said...

Unfortunately, CSVDE is only able to create new objects in AD, not modify. But the smae command line parameters work for it's big brother LDIFDE. Unlike CSVDE, LDIFDE has the ability to export, import new, modify and DELETE Active Directory objects.

Unfortunately, LDIFDE has a completely different data structure (still a plain text file but not Excel friendly). The trick with LDIFDE, like CSVDE, is to do an export first, then modify the output file for updates needed. Additionally, REMOVE ALL unnecessary fields you do not want updated. I thin at a minimum, you need the DN or DistinguishedName LDAP attribute and of course the attribute(s) you wish to modify or populate.

A good primer/tutorial for CSVDE is:
http://computerperformance.co.uk/Logon/Logon_CSVDE.htm

12:43 PM  
Blogger longge said...

replica handbags began designing luggage for the wealthy that traveled. His first invention was to design lv that was flat and therefore easy to stack in railway carriages. It gained popularity at lightening speed. It didn't take long before his competition was copying his design. In 1854 the replica louis vuitton business came to be, as luggage began to be replaced with replica bags ideas for handbags.

6:39 PM  
Blogger Simple Luxury said...

Burberry Outlet Store Online
Handbags Outlet Store Online


www.burberry-outlets.org
www.prada-outlet.org

9:10 AM  

Post a Comment

<< Home

xml:lang="en" lang="en"> MS Exchange Tips: Exchange: Export GAL Using CSVDE