Emoji in username

[kimberleybrown]

Hello!

I saw this issue being handled by other users, but I'm having some trouble with my code remapping a team member name who has an emoji in their username since it is no longer supported.

"FieldMaps": [
            {
              "FieldMapType": "FieldValueMap",
              "WorkItemTypeName": "*",
              "sourceField": "System.ChangedBy",
              "targetField": "System.ChangedBy",
              "defaultValue": "",
              "valueMapping": {
                "Name🦉": "Name",
                "Name 🦉": "Name"
              }
            },

The user appears in comment and change history of a work item, so I have tried both the System.ChangedBy and System.History with no success. Whenever it starts migrating the work item, I get the error:

System.AggregateException: One or more errors occurred. ---> Microsoft.TeamFoundation.WorkItemTracking.Client.UnexpectedErrorException: There is a problem on the server. Contact your Azure DevOps Server administrator. ---> System.Web.Services.Protocols.SoapException: %error="600177";%:AddConstant: The following string is not supported by database collation: %String="Name??";%.

I have also tried the code:

"FieldMaps": [
            {
              "ObjectType": "FieldValueMapConfig",
              "FieldMapType": "FieldValueMap",
              "WorkItemTypeName": "*",
              "sourceField": "System.History",
              "targetField": "System.History",
              "defaultValue": "",
              "valueMapping": {
                "Name🦉": "Name",
                "Name 🦉": "Name"
              }
            },

• Removing actual name for confidentiality purposes.

[MrHinsh]

Hi @kimberleybrown you can use the #2643 StringManipulatorTool tool to get rid of this emoji across all string fields.