[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\system32csvde -s 12.34.56.78 -f D:\IMG\IUCNEmail\Exchange\CSVDE\csvde1.csv -r ((objectclass=user)(proxyaddresses=SMTP*)) -l cn,mail,physicalDeliveryOfficeName - C:\WINDOWS\system32csvde -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 Hinckleyt: (41 22) 999 0183 Information Management Groupf: (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/
RE: [ActiveDir] Accented characters in a CSVDE output
Is the character on this list? http://support.microsoft.com/?kbid=841091 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan HINCKLEY Sent: Wednesday, July 28, 2004 10:12 AM 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\system32csvde -s 12.34.56.78 -f D:\IMG\IUCNEmail\Exchange\CSVDE\csvde1.csv -r ((objectclass=user)(proxyaddresses=SMTP*)) -l cn,mail,physicalDeliveryOfficeName - C:\WINDOWS\system32csvde -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 Hinckleyt: (41 22) 999 0183 Information Management Groupf: (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/
RE: [ActiveDir] Accented characters in a CSVDE output
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\system32csvde -s 12.34.56.78 -f D:\IMG\IUCNEmail\Exchange\CSVDE\csvde1.csv -r ((objectclass=user)(proxyaddresses=SMTP*)) -l cn,mail,physicalDeliveryOfficeName - C:\WINDOWS\system32csvde -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 Hinckleyt: (41 22) 999 0183 Information Management Groupf: (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/
RE: [ActiveDir] Accented characters in a CSVDE output
Yes, but not for any of the objects noted under ES2003 which is what we're running, on a W2003 server. At 16:18 7/28/2004, you wrote: Is the character on this list? http://support.microsoft.com/?kbid=841091 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan HINCKLEY Sent: Wednesday, July 28, 2004 10:12 AM 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\system32csvde -s 12.34.56.78 -f D:\IMG\IUCNEmail\Exchange\CSVDE\csvde1.csv -r ((objectclass=user)(proxyaddresses=SMTP*)) -l cn,mail,physicalDeliveryOfficeName - C:\WINDOWS\system32csvde -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 Hinckleyt: (41 22) 999 0183 Information Management Groupf: (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/ 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/
