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

CA Test Data Manager (TDM)- Datamaker

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 … 

Krüger & Busse 

Schlößer 

Klara Lämmerhirt 

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. 

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJsIAAW" alt="ANSI-UTF_screenshot.png" width="1344" height="355">

 

Note:

You can change the encoding in notepad++ . See the screenshot below for reference.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJsJAAW" alt="encoding_utf8.png" width="337" height="250">

Additional Information

Please follow the link below to get detailed information about various other methods of moving the seed data.

https://docops.ca.com/display/TDM/.Propagate+Seed+List+Data+Across+Masking+Engines+v3.2 

If you face any issues or have any questions about the steps, please open a support case by going to https://support.ca.com/irj/portal/anonymous/newhome or by calling customer care at http://www3.ca.com/us/support/customer-assistance.aspx.