TDM: Norwegian Characters are not detected in the CSV file

Article Id: 143656

Status: Published

Updated On: 27-01-2020 14:55

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

While importing an existing CSV from an old version into a new version of a project in CA TDM Datamaker, the tables and columns having
Norwegian characters:
å
ø
æ

are not detected. The entries from the CSV map are not being imported in to a new version.

If manually editing the CSV file to replace the characters to Norwegian characters, an attempt to import gives the following error:

Environment:

Release : 4.8+

Component : CA Test Data Manager

Resolution:

Solution 1

The TDM application is in the UTF-8 (8-bit Unicode Transformation Format) encoding, therefore the issue is due to the Microsoft Excel setting.

Obtain and review the Microsoft Excel CSV file produced.
Microsoft Excel is opening the CSV file in the default ANSI format.

When the file is loaded correctly in the UTF-8 format, the data will be displayed.

Solution 2

Obtain the latest TDM 4.8.1 patch from the Support Team.