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.

18 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  
Blogger dong dong said...

2015624dongdong
christian louboutin
oakley sunglasses cheap
christian louboutin outlet
hollister clothing store
ray ban outlet
louis vuitton outlet stores
christian louboutin sale
michael kors bag
cheap lululemon
michael kors outlet online sale
true religion outlet
coco chanel
michael kors handbags
www.louisvuitton.com
ray ban glasses
red christian louboutin
louis vuitton handbags
michael kors outlet online
coach outlet store online
rolex watches outlet
celine outlet
ray ban sunglasses
cheap jordans
coach factory outlet
jordan 13
hollister clothing
tory burch outlet online
oakley vault
jordan shoes
mont blanc
toms outlet
nfl jerseys

12:38 AM  
Blogger 风骚达哥 said...

20151012 junda
Abercrombie & Fitch Factory Outlet
michael kors outlet
coach factory outlet
michael kors outlet
Louis Vuitton Handbags Factory Store
louis vuitton
Cheap Jordans For Sale Wholesale
oakley sunglasses,oakley vault,prescription sunglasses,polarized sunglasses,aviator sunglasses,spy sunglasses,oakleys,oakley canada,cheap oakley sunglasses,oakley frogskins,oakley holbrook,cheap sunglasses,wayfarer sunglasses,oakley standard issue,fake oakleys,oakley glasses,oakley.com,oakley prescription glasses,oakley goggles,sunglasses for men,oakley gascan,oakley store,oakleys sunglasses
uggs australia
ugg boots
cheap ugg boots
michael kors handbag
Coach Factory Outlet Online Sale
Louis Vuitton Outlet USA
Air Jordan 4 Toro Bravo
canada goose outlet
toms outlet
New Louis Vuitton Handbags Outlet
Michael Kors Handbags Outlet Deals
michael kors outlet
Wholesale Authentic Designer Handbags
Ugg Boots,Ugg Boots Outlet,Ugg Outlet,Cheap Uggs,Uggs On Sale,Ugg Boots Clearance,Uggs For Women
cheap jordan shoes
michael kors outlet online
louis vuitton handbags
Coach Factory Outlet Private Sale
true religion jeans
Louis Vuitton Bags On Sale
Jordan 13 Shoes For Sale
Ralph Lauren Outlet Clothing

6:14 AM  
Blogger oakleyses said...

louis vuitton outlet, oakley sunglasses, michael kors handbags, cheap jordans, prada handbags, uggs outlet, michael kors outlet, oakley sunglasses, uggs on sale, ray ban sunglasses, burberry outlet, tiffany jewelry, uggs on sale, kate spade, gucci handbags, ray ban sunglasses, prada outlet, longchamp outlet, louboutin uk, burberry factory outlet, tory burch outlet, nike air max, tiffany jewelry, christian louboutin, louboutin shoes, oakley sunglasses, cheap oakley sunglasses, chanel handbags, michael kors outlet store, louis vuitton outlet, nike outlet, ralph lauren polo, louis vuitton, christian louboutin, michael kors outlet online, longchamp outlet, uggs outlet, michael kors outlet online, nike air max, longchamp bags, replica watches, ralph lauren outlet, oakley sunglasses, ray ban sunglasses, louis vuitton outlet online, nike free, michael kors

6:29 PM  
Blogger oakleyses said...

burberry pas cher, lunette oakley pas cher, coach outlet, kate spade outlet, true religion jeans, converse, coach outlet, longchamp soldes, north face uk, michael kors, louboutin pas cher, new balance, lululemon outlet, coach purses, nike air max, hermes pas cher, nike tn pas cher, vans pas cher, coach outlet store online, mulberry uk, lunette ray ban pas cher, nike air max uk, sac guess pas cher, nike air force, nike roshe run pas cher, longchamp pas cher, north face pas cher, nike air max pas cher, ray ban uk, true religion outlet, abercrombie and fitch, polo lacoste pas cher, true religion outlet, michael kors, jordan pas cher, nike free, polo ralph lauren uk, vanessa bruno pas cher, true religion outlet, hogan sito ufficiale, ralph lauren pas cher, michael kors outlet online, nike free pas cher, nike roshe uk, abercrombie and fitch UK, nike blazer pas cher, hollister uk

6:31 PM  
Blogger oakleyses said...

converse shoes outlet, salvatore ferragamo, timberland boots, softball bats, herve leger, ray ban, hollister, louboutin, gucci, nike roshe run, iphone cases, beats by dre, mcm handbags, oakley, p90x workout, insanity workout, wedding dresses, abercrombie and fitch, abercrombie, nike air max, mac cosmetics, babyliss pro, valentino shoes, bottega veneta, mont blanc, converse, jimmy choo outlet, hollister clothing, nike air max, north face outlet, new balance shoes, north face outlet, instyler ionic styler, soccer shoes, lululemon outlet, asics running shoes, ghd hair, giuseppe zanotti, soccer jerseys, nfl jerseys, longchamp uk, reebok outlet, nike air huarache, chi flat iron, hermes handbags, vans outlet, polo ralph lauren, celine handbags, nike trainers uk, vans scarpe

6:32 PM  
Blogger oakleyses said...

toms shoes, supra shoes, montre pas cher, ugg uk, juicy couture outlet, moncler, lancel, michael kors outlet online, ugg pas cher, michael kors handbags, barbour, doke & gabbana, michael kors outlet, coach outlet, louis vuitton uk, canada goose jackets, pandora charms, moncler, ugg,ugg australia,ugg italia, links of london uk, moncler jackets, hollister, juicy couture outlet, canada goose outlet, swarovski uk, pandora jewelry, canada goose pas cher, canada goose outlet, marc jacobs, moncler pas cher, thomas sabo uk, swarovski jewelry, karen millen uk, louis vuitton, moncler, moncler uk, sac louis vuitton, canada goose, moncler outlet, louis vuitton, canada goose, wedding dresses uk, ugg,uggs,uggs canada, canada goose uk, sac louis vuitton, moncler, replica watches, barbour jackets uk, bottes ugg pas cher, canada goose jackets

6:34 PM  
Blogger Minko Chen said...

kobe 9
nhl jerseys
nike air max
air max 90
mcm backpack
ugg outlet online
hermes belt for sale
ugg outlet store
ralph lauren outlet
louis vuitton outlet store
ralph lauren uk
juicy couture tracksuit
coach outlet
lacoste shirts
abercrombie and fitch
snow boots
true religion jeans
longchamp handbags
hermes outlet store
cheap nike shoes
1128MINKO

6:39 PM  
Blogger xumeiqing said...

151202meiqing
michaek kors handbags
nike trainers
chanel bags
north face jackets
pandora jewelry
michael kors outlet clearance
louis vuitton bags
lebron james shoes
ralph lauren outlet
nike huarache
jordan 11
cheap jordans
lebron james shoes 2015
cheap uggs
ugg boots
canada goose
ugg australia
michael kors outlet
ugg slippers
replica watches
uggs for sale
ugg boots for men
toms shoes
coach outlet online
cheap oakley sunglasses
louis vuitton outlet
michael kors outlet online
uggs australia
ugg boots
oakley sunglasses
michael kors outlet
ray ban sunglasses
uggs on sale
canada goose outlet
christian louboutin
uggs outlet
nike air max
coach factory outlet
ed hardy clothing
cheap jordans

5:32 PM  
Blogger 小 Gg said...

cheap oakley sunglasses
ray ban sale
nike outlet
prada outlet
nike sneakers
swarovski crystal
ralph lauren polo shirts
cheap oakley sunglasses
michael kors usa
wellensteyn coats
true religion jeans
air force one shoes
lululemon outlet
michael kors handbags
ray ban sunglasses
ralph lauren
true religion sale
coach outlet store online,coach outlet store,coach outlet
canada goose outlet
instyler ionic styler,instyler,instyler ionic styler pro
cheap ugg boots
air jordan 11 free shipping
swarovski outlet
hollister pas cher
cleveland cavaliers
CHENG1202

11:56 PM  
Blogger John said...

coach outlet online
louboutin pas cher
cheap oakley sunglasses
ugg boots on sale
the north face outlet
nike air force 1
ugg boots
michael kors outlet online
beats by dre
ralph lauren outlet
canada goose
coach outlet online
chanel handbags
michael kors handbags
louis vuitton outlet stores
canada goose outlet
cheap jordans
uggs outlet
michael kors handbags
louis vuitton handbags
louis vuitton outlet
coach factory outlet
abercrombie & fitch
uggs on sale
oakley sunglasses wholesale
polo ralph lauren
michael kors outlet online
cheap soccer shoes
coach outlet store online
20151203yuanyuan

7:16 PM  
Blogger 艾丰 said...

jianbin1217
fitflops shoes
fitflops sale
fitflops sale clearance
fitflops sale
fitflops shoes
michael kors outlet
michael kors outlet
michael kors outlet
tiffany and co
tiffany jewellery
beats by dr dre
beats by dre
oakley sunglasses
oakley sunglasses
ray-ban sunglasses
ray ban sunglasses
hollister uk
lululemon outlet
ugg outlet
ugg boots
ugg boots
rolex watches
mulberry handbags
mulberry bags
mulberry outlet
mulberry sale
mulberry handbags
mulberry handbags
louis vuitton handbags
louis vuitton handbags
toms shoes
omega watches
ferragamo shoes

6:20 PM  
Blogger Chen Jeje said...

michael kors handbags
tiffany and co outlet
oakley sunglasses wholesale
kobe basketball shoes
cheap true religion
fitflop sandals
fitflops outlet
http://www.nikedunks.us.org
http://www.oakley-sunglass.in.net
cheap oakley sunglasses
http://www.cheapairjordan.us
http://www.michaelkors-outletfactory.us.com
Michael Kors Online Outlet
replica christian louboutin
coach outlet online
michael kors outlet
fitflops outlet
air jordan
ralph lauren online
louis vuitton handbags
cheap jordans
oakley store online
cheap jordans online
http://www.chromehearts.in.net
michael kors outlet online

7:35 PM  
Blogger chenlina said...

ralph lauren uk
retro jordans
cheap cartier watches
coach outlet
kd 8 shoes
coach outlet store online
ghd hair straighteners
burberry outlet
adidas superstar
adidas originals
ralph lauren outlet
coach outlet
kobe bryant shoes
air jordans
celine bags
coach outlet
christian louboutin sale
toms shoes
polo ralph shirts
michael kors outlet
jordan 11
louis vuitton
hollister clothing
michael kors handbags
jordans
michael kors outlet
basketball shoes
coach outlet
jordan 13
ray ban sunglasses
coach outlet
coach outlet
louis vuitton outlet stores
louis vuitton outlet
lebron james shoes 13
ray ban sunglasses
mont blanc pens
ralph lauren polo
coach factory outlet
coach factory outlet
chenlina20160803

5:40 PM  

Post a Comment

<< Home

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