GTDatamaker: How to load non-ASCII characters in a CSV file into the seed data table of the repository from GTDatamaker GUI

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

This article will explain in detail on how to load non-ASCII characters in a CSV file into the seed data table of the repository from GTDatamaker GUI along with the known limitation.

Customized seed data can be inserted into the GTSRC_REFERENCE_DATA table, more commonly called the seed table of the repository, from the GTDatamaker GUI.
There are various ways in which one can achieve this.
This article explains the method in which one can import the data that may contain non-ASCII characters or latin characters from a CSV file into the seed table.

Environment

All supported TDM releases.

Resolution

Steps:
1. Launch GTDatamaker. Enter your credentials and get to the home page.
2. Go to Tools -> Maintain Seed Data.
3. Click on the Green plus icon on the left hand side on the top.
4. A "New Seed Data Type" page will pop up.
     Enter seed data name in the "Data Type Name" box, number of columns, and the names of the columns along with example data in "column value".
     Click on the green tick button.
5. Your seed data will now appear in the middle pane ready for import. Click on the "Seed Data from CSV" button, which is the second button on the top right hand side of the page.

If the CSV file contains Latin characters and non-ASCII, like ü, ö, ä, etc.

and the encoding is ANSI, the data that gets imported will be garbled. When we convert this file to have UTF-8 encoding, the data will go in as expected. 

Note:
You can change the encoding by opening the file in Notepad++ and from Encoding menu option, convert to UTF-8.

Additional Information

Refer to documentation section "Propagate Seed List Data Across Masking Engines" of the release you are running for more information.about various other methods of moving the seed data.