CSVDE.exe woes

[William A. Avellan]

I would like to export a list of users and associated e-mail addresses
in a Active Directory domain using the CSVDE.EXE utility. This would
than be used to import into Outlook for non MAPI/LDAP/OWA users.
Unfortunately, the filter option does not seem to work properly or I
am running the tool incorrectly.

The command line parameters I am running:
csvde -f c:\working\company.csv -r objectclass=user -l
displayName,mail -m

My output file includes computer names even though I have specified
the objectclass=user option.

Here is a quick snippet of my output file:
"CN=HOWARDHOME,CN=Computers,DC=company,DC=na,DC=ks,DC=local",HOWARDHOME$,

"CN=Ken Liu,OU=Users,OU=Product
Development,OU=Departments,DC=company,DC=na,DC=ks,DC=local",Ken
Liu,[email protected]

"CN=Nancy Chu,OU=Users,OU=Product
Development,OU=Departments,DC=company,DC=na,DC=ks,DC=local",Nancy
Chu,[email protected]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A. Avellan
MCSE, MCT
Make my day, order a book I co-authored:
http://www.amazon.com/exec/obidos/ASIN/0782128815
Check out my aquarium (Photos - Founder):
http://groups.yahoo.com/group/reefcity/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[Matjaz Ladava [MVP]]

The right syntax would be

csvde -f c:\working\company.csv -r
"(&(objectCategory=person)(objectclass=user)) -l "displayName,mail" -m

You can't just specify (objectclass=user) as user class is the parent class
of computer class in AD schema. That is why you are getting both class
types. ObjectCategory=person is better as it is also indexed for searches.

--
Regards

Matjaz Ladava, MCSE (NT4 & 2000), Windows MVP
(e-mail address removed)
http://ladava.com

 

[William A. Avellan]

Matjaz, using your suggested command line parameters, I now receive 0
exports. Can you please confirm the command line? Please respond the
newsgroup and directly to me if possible. Thanks for all your help.

 

[Matjaz Ladava [MVP]]

Hi William,

Aparently I forgot a " at the end of -r query. Following should work. I have
just tried it.

csvde -f company.csv -r "(&(objectCategory=person)(objectclass=user))" -l
"displayName,mail" -m

Let me know, If you have any problems with this one

--
Regards

Matjaz Ladava, MCSE (NT4 & 2000), Windows MVP
(e-mail address removed)
http://ladava.com