DMT does not respect me - french ascii letters

Kinetic ERP
, ,
1

In your best indigent French accent repeat after me.

DMT does not respect me - DMT ne me respecte pas.

We’re bringing on board a new division in France and naturally, the names of their customers and streets use traditional French letters with accents; however, when loading in DMT, it converts the accents to 2 characters that are unreadable.

My first thought was the DMT or a .CSV file didn’t maintain the UTF8 characters, so I save in excel and tried again. No go:

Notepad .csv
Hôpital privé Océane

Excel .xlsx
Hôpital privé Océane

DMT
Hôpital privé Océane

How to get DMT to respect the French letters?

2

Solved my own issue.

In Excel, one must Data → Get Data ‘From Text/CSV’

image

‘Load’ in order to have Excel respect the French characters. Then and only then ( using the Excel file ) will DMT maintain the ascii characters.

Dropping leading 0’s ( zeros ), still a pita.

Au revoir

Ok - found a way around disappearing leading zero’s on import. Still a pita, but does solve the problem.

When on the first screen ‘From Text/CSV’, select ‘Transform Data’ instead of ‘Load’

image

Next screen - ‘Advanced Editor’

image

Where it says ‘Int64.Type’, change to ‘type text’ — And walla, respect for leading zeros!

image
image866×84 5.08 KB

1 Like
3

You can preserve the numbers with leading zeros by sending an equals sign and surrounding the number with double quotes:

="000123"

Easy as un, deux, trois. :wink:

2 Likes
4

To prevent dropping the leading zeros, change the column type to text. For example, {"CustNumCustID", Int64.Type} → becomes → {"CustNumCustID", type text}