Special Characters in EA Properties View

[philchudley]

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

[qwerty]

EA version? Jet4?

q.

[philchudley]

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

[Geert Bellekens]

It's definitely a codepage issue somewhere.
Can you define a codepage to use somewhere in EA? I'm not sure.

Geert

[qwerty]

You might re-save the CSV using UTF-8 (you can do this using Notepad++) rather than in any Windoze encoding.

q.

[Guillaume]

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.

[Takeshi K]

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,

[Polymorph]

Obviously very late to the party here... but I have found a possible resolution to this issue. With your model open

• Go to Settings Menu
• Go to options (Model panel)
• Go to Source Code Engineering
• Change page for source editing to "65001 (UTF-8)"
• With Excel file open, save as "CSV UTF-8 (Comma delimited) (*.csv)"
• Import as normal

In the CSV import screen you should see the Code Page panel now says 65001 (UTF-8).

If you don't also save the Excel file as UTF-8, then it doesn't work - but if you do it should remove the random �characters! from your imports