Data exported to a CSV file is formatted incorrectly in Excel on a computer that is running a localized non-Latin character based language version of Windows Server 2008

Data exported to a CSV file is formatted incorrectly in Excel on a computer that is running a localized non-Latin character based language version of Windows Server 2008

Article ID : 954406
Last Review : July 4, 2008
Revision : 1.0
On This Page

SYMPTOMS

Consider the following scenario:

• You export data from a snap-in in a localized version of Windows Server 2008 to create a Comma-Separated Values (CSV) file.
• The localized version of Windows Server 2008 is a non-Latin character based language version.
• You open the file in a spreadsheet program such as Microsoft Excel.

In this scenario, the data is formatted incorrectly. Additionally, the characters are not displayed correctly.

Back to the top

CAUSE

This problem occurs if you do not save the CSV file in Unicode format when you export the data.

Back to the top

WORKAROUND

To resolve this issue, save the CSV file in Unicode format. To do this, follow these steps:

1. Open the CSV file in Notepad.
2. On the File menu, click Save As.
3. In the Save As dialog box, click Unicode in the Encoding list.
4. Click Save.

Back to the top

MORE INFORMATION

When you export data from a snap-in in Windows Server 2008, you can create a CSV file in the following ways:

• Export a list of cached users from a read-only domain controller (RODC) that is running Windows Server 2008.
• Save event logs in a CSV file.
• Export the contents of an organizational unit (OU).

Back to the top

Steps to reproduce the problem

1. On a writable domain controller that is running Windows Server 2008, open the Active Directory Users and Computers snap-in. To do this, click Start, click Run, type dsa.msc, and then click OK.
2. In the Active Directory Users and Computers box, expand the Domain Controllers container, and then right-click Computer Account for an RODC.
3. On the Password Replication Policy tab, click Advanced.
4. In the Advanced Password Replication Policy dialog box, click the Policy Usage tab, and then click Export.
5. Save the file as a CSV file.
6. Open the saved file in Excel.

Back to the top

REFERENCES

For more information about RODC, visit the following Microsoft Web site:

http://technet2.microsoft.com/windowsserver2008/en/library/ea8d253e-0646-490c-93d3-b78c5e1d9db71033.mspx?mfr=true (http://technet2.microsoft.com/windowsserver2008/en/library/ea8d253e-0646-490c-93d3-b78c5e1d9db71033.mspx?mfr=true)

Back to the top


APPLIES TO
• Windows Server 2008 Standard
• Windows Server 2008 Datacenter
• Windows Server 2008 Enterprise
• Windows Server 2008 Datacenter without Hyper-V
• Windows Server 2008 Enterprise without Hyper-V
• Windows Server 2008 for Itanium-Based Systems
• Windows Server 2008 Standard without Hyper-V

Back to the top

Keywords: 
kbfix kbbug kbexpertiseadvanced kbtshoot KB954406

Back to the top

 

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
Microsoft Corporation. All rights reserved. Terms of Use | Trademarks


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image