When using CSVDE to output a .csv file, any 'sn' and 'givenname' entries with an accented character are displayed in the CSV file as something like this: "X'41c3af737361746f75'" when opened in Excel. Is this an Excel or CSVDE problem? Anyone tell me how to display such names properly? When I go into AD and remove the accented character the sn or givenname displays correctly. Maybe there is a better tool than CSVDE?

Here are a couple of examples of the CSVDE command:

C:\WINDOWS\system32>csvde -s "12.34.56.78" -f D:\IMG\IUCNEmail\Exchange\CSVDE\csvde1.csv -r "(&(objectclass=user)(proxyaddresses=SMTP*))" -l "cn,mail,physicalDeliveryOfficeName"

-----------------------------------------

C:\WINDOWS\system32>csvde -s "12.34.56.78" -f D:\IMG\IUCNEmail\Exchange\CSVDE\csvde1.csv -r "(&(objectclass=user)(proxyaddresses=SMTP*))" -l "displayname,mail,physicalDeliveryOfficeName" -o "DN"

(The -o to omit the DN output appears not to work....)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Dan Hinckley t: (41 22) 999 0183
Information Management Group f: (41 22) 999 0010
IUCN, The World Conservation Union e: [EMAIL PROTECTED]
1196 Gland, Switzerland w: http://iucn.org/


List info   : http://www.activedir.org/mail_list.htm
List FAQ    : http://www.activedir.org/list_faq.htm
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/

Reply via email to