Japanese characters are garbled during/after importing diagram from CSV format to Agile Designer

Document ID : KB000006145
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Import diagram from CSV format to Agile Designer, and then Japanese characters are garbled.

The steps to reproduce are:

  1. Save a diagram definition as CSV format with ANSI character set (= Shift JIS for Japanese Windows).

    Here is example. It includes some Japanese characters.
    ---------------------------------------------------------------------------------
    Blocks,

    Name,Description,Observation,Complexity,Block Type,Test Importance,Data Sensitivity,
    プロセス1,プロセス1,Observable,6,Code Action,Medium Importance,No Sensitivity,
    �件1,�件1,Observable,6,Code Action,Medium Importance,No Sensitivity,
    プロセス2,プロセス2,Observable,6,Code Action,Medium Importance,No Sensitivity,
    ,,,,,,
    Connections,
    Source,Target,Value,
    �件1,プロセス1,真,
    �件1,プロセス2,�,
    ,,,,,,
    ---------------------------------------------------------------------------------
  2. Select menu [Tools] - [Import] on Agile Designer.
  3. Select [General Diagram] and click [Import] button.
  4. Specify the CSV file to [Location] and click [Next] button.
  5. Identifier and/or Name maybe garbled if properties are Japanese in CSV file.

  6. If you can select any items in Import Wizard, you may see garbled diagram.


  

 

Cause:

Agile Requirements Designer (ARD) can handle UTF-8 format. ARD cannot accept Shift-JIS character set as CSV format.

Resolution:

Convert CSV file from Shift-JIS to UTF-8 format. After that, you can import the CSV file to ARD.

 

Additional Information:

Here is product manual as reference.

https://docops.ca.com/ca-agile-requirements-designer/2-3/en

If you are interested in Export/Import functions, select [Exporting and Importing] document.