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

Document ID : KB000009986
Last Modified Date : 14/02/2018
Show Technical Document Details
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.

Background:

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
Instructions:

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. 

ANSI-UTF_screenshot.png

 

Note:

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

encoding_utf8.png

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.