PlainText field to Html field migration issue

[sergeykrulikovskiy]

Hello,

In my source project I have one field which is PlainText type (MyProject.BugRejectReason). In a target Project I created a new field (Custom.BugRejectReasonText) which is "Text (multiple lines)" type. In source project this field contains important information (from several words to numerous lines) and must be migtrated.

I've added the FieldMappingTool in order to map those fields, but validation fails with the following message:

[01:54:28 INF] [16.3.3] Start validation of work item type 'Bug'.
[01:54:28 INF] [16.3.3] Validating source field 'MyProject.BugRejectReason' (Bug Reject Reason).
[01:54:28 INF] [16.3.3] Source field 'MyProject.BugRejectReason' is mapped to 'Custom.BugRejectReasonText'.
[01:54:28 WRN] [16.3.3] Source field 'MyProject.BugRejectReason' and target field 'Custom.BugRejectReasonText' have different types: source = '"PlainText"', target = '"Html"'.

If I add MyProject.BugRejectReason to the ExcludeSourceFields - validation finishes sucessfully and migration starts. So I'm 100% sure the problem in PlainText to Html transition.

Can somebody give a hint which one Tool or Processors I should use in this case?
Just for the info: my source server version is: Dev17.M153.5

Thank you in advance!

{
  "$schema": "https://devopsmigration.io/schema/configuration.schema.json",
  "Serilog": {
    "MinimumLevel": "Debug"
  },

  "MigrationTools": {
    "Version": "16.3",
    "Endpoints": {
      "Source": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://tfs-vm/Tfs-server-2/",
        "Project": "ProjectName",
        "Authentication": {
          "AuthenticationMode": "Prompt"
        },
        "ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        },
        "ProductVersion": "OnPremises"
      },
      "Target": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://dev.azure.com/sergey/",
        "Project": "TestMigration2",
        "Authentication": {
          "AuthenticationMode": "AccessToken",
          "AccessToken": "xxxxxx"
        },
        "ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        },
        "ProductVersion": "OnPremises"
      }
    },
    "Processors": [
      {
        "ProcessorType": "TfsWorkItemMigrationProcessor",
        "Enabled": true,
        "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType]='Feature' ORDER BY [System.ChangedDate] desc",
        "FixHtmlAttachmentLinks": true,
        "WorkItemCreateRetryLimit": 5,
        "FilterWorkItemsThatAlreadyExistInTarget": true,
        "GenerateMigrationComment": false,
        "SourceName": "Source",
        "TargetName": "Target"
      }
    ],
    "CommonTools": {
      "TfsWorkItemTypeValidatorTool": {
        "Enabled": true,
        "ExcludeDefaultWorkItemTypes": true,
        "ExcludeSourceFields": {
          "*": [
            "Microsoft.VSTS.Build.IntegrationBuild",
            "Microsoft.VSTS.Build.FoundIn"
          ]
        },
        "ExcludeWorkItemTypes": [
          "Change Request",
          "Sprint"
        ]
      },
      "FieldMappingTool": {
        "Enabled": true,
        "FieldMaps": [
          {
            "FieldMapType": "FieldToFieldMap",
            "ApplyTo": [
              "Bug"
            ],
            "sourceField": "MyProject.BugRejectReason",
            "targetField": "Custom.BugRejectReasonText"
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "ApplyTo": [
              "Bug"
            ],
            "sourceField": "MyProject.BugCategory",
            "targetField": "Custom.BugCategory"
          },
          {
            "FieldMapType": "FieldValueMap",
            "ApplyTo": [
              "Bug"
            ],
            "sourceField": "System.Reason",
            "targetField": "System.Reason",
            "valueMapping": {
              "Pushed to New": "New defect reported",
              "Pushed to Re-Opened": "Additional work found",
              "Pushed to Fixed": "Work finished",
              "Pushed to Closed": "Work finished",
              "Pushed to Postponed": "Work stopped",
              "Pushed to Rejected": "Not a Bug",
              "Pushed to Removed": "Removed from the backlog"
            }
          },
          {
            "FieldMapType": "FieldValueMap",
            "ApplyTo": [
              "Product Backlog Item"
            ],
            "Enabled": true,
            "sourceField": "System.Reason",
            "targetField": "System.Reason",
            "valueMapping": {
              "New task": "Moved to the backlog",
              "Work started": "Commitment made by the team",
              "Work resumed": "Additional work found"
            }
          },
          {
            "FieldMapType": "FieldValueMap",
            "ApplyTo": [
              "Bug"
            ],
            "Enabled": true,
            "sourceField": "System.State",
            "targetField": "System.State",
            "valueMapping": {
              "Closed": "Done",
              "Fixed": "Done",
              "Opened": "New",
              "Re-opened": "New",
              "Postponed": "New",
              "Rejected": "Removed"
            }
          },
          {
            "FieldMapType": "FieldValueMap",
            "ApplyTo": [
              "Product Backlog Item"
            ],
            "Enabled": true,
            "sourceField": "System.State",
            "targetField": "System.State",
            "valueMapping": {
              "Closed": "Done",
              "Implemented": "Done",
              "In Progress": "Committed",
              "To Do": "Approved"
            }
          }
        ]
      }
    }
  }
}```

[sergeykrulikovskiy]

I reread the documentation page for the TfsWorkItemTypeValidatorTool and realized that ExcludeSourceFields is exactly what I need. The PlainText-to-HTML conversion works perfectly.