Author Topic: Special Characters in EA Properties View  (Read 251 times)

philchudley

  • EA User
  • **
  • Posts: 572
  • Karma: +11/-0
  • UML/EA Principal Consultant / Trainer
    • View Profile
Special Characters in EA Properties View
« on: October 02, 2019, 12:31:24 am »
Hi All

I have imported a number of elements from a CSV file the data for which contains characters such as č

However when this data is displayed in the EA Element properties, these characters are displayed as a black diamond with a white ? inside

The model repository is a centralised and hosted, I believe, on SQL Server

Can the EA properties display such special characters, and if so what is the configuration necessary?

Many thanks

Phil
follow me on Twitter

@SparxEAGuru

qwerty

  • EA Guru
  • *****
  • Posts: 10582
  • Karma: +232/-192
  • I'm no guru at all
    • View Profile
Re: Special Characters in EA Properties View
« Reply #1 on: October 02, 2019, 08:17:30 am »
EA version? Jet4?

q.

philchudley

  • EA User
  • **
  • Posts: 572
  • Karma: +11/-0
  • UML/EA Principal Consultant / Trainer
    • View Profile
Re: Special Characters in EA Properties View
« Reply #2 on: October 02, 2019, 06:57:11 pm »
Experienced in versions 14.1 and 15

After some experimentation I have discovered that the special characters can be displayed in the EA Workspace, I tested copy / paste from Excel and also direct entry.
I also discovered, that the raw CSV file contains the special characters, but after import using the usual CSV Import, the "transformation" occurs, so it appears that the issue lies within the CSV import.

I am going to perform the same import using the MS Office Integration MDG and see if that resolves the issue

All the best
Phil
follow me on Twitter

@SparxEAGuru

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9475
  • Karma: +266/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Special Characters in EA Properties View
« Reply #3 on: October 02, 2019, 07:13:28 pm »
It's definitely a codepage issue somewhere.
Can you define a codepage to use somewhere in EA? I'm not sure.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 10582
  • Karma: +232/-192
  • I'm no guru at all
    • View Profile
Re: Special Characters in EA Properties View
« Reply #4 on: October 02, 2019, 07:35:59 pm »
You might re-save the CSV using UTF-8 (you can do this using Notepad++) rather than in any Windoze encoding.

q.

Guillaume

  • EA User
  • **
  • Posts: 796
  • Karma: +22/-0
    • View Profile
    • www.umlchannel.com
Re: Special Characters in EA Properties View
« Reply #5 on: October 02, 2019, 10:57:53 pm »
I reported a similar issue yesterday to Sparx (or it could be the same).
Since EA 14, if you enter characters such a (fr) in an element's notes, it is stored in EA DB as codes e.g. é è ...
Hence the impact when exported to CSV or Excel via the MDG Office.

I ran a quick update query to replace all codes in the DB, but as soon I update a notes, the issue is back (as expected).

Opening the same project with EA13, updating the notes with the same characters, they're stored correctly in the DB.

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Takeshi K

  • EA User
  • **
  • Posts: 353
  • Karma: +9/-1
    • View Profile
Re: Special Characters in EA Properties View
« Reply #6 on: October 03, 2019, 09:42:01 am »
Hi all,

When EA imports and exports CSV files, EA uses the following setting as CSV file codepage. Specifying your codepage and then import/export would be successful.

Configure ribbon | Model panel | Options button | Source Code Engineering group | Code page for source editing

HTH,
--
t-kouno