it's not a CSVDE *problem* - it is the *solution* to keep the data transferrable via CSVDE... You'll find the same issue when trying to export address-fields which include carriage returns.
you should be able to export the data in a readable format via normal LDAP queries e.g. via DSQUERY or Joe's ADFIND /Guido -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan HINCKLEY Sent: Wednesday, July 28, 2004 4:12 PM To: [EMAIL PROTECTED] Subject: [ActiveDir] Accented characters in a CSVDE output 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/ 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/
