Area and iterations are not getting mapped to custom values

[pravinkanhekar-cv]

I am trying to migrate work items, they are getting migrated to targeted ADO but with areas and iterations same as source replacing the Base path. I want to migrate to the some custom value for area and iteration which will be same for all the migrated items in target ado. Please find my Config file below-

{
  "$schema": "https://devopsmigration.io/schema/configuration.schema.json",
  "Serilog": {
    "MinimumLevel": "Information"
  },
  "MigrationTools": {
    "Version": "16.2",
    "Endpoints": {
      "Source": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://dev.azure.com/pinpointinfo/",
        "Project": "SmartApplications",
        "Authentication": {
          "AccessToken": "PAT"
        },
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        }
      },
      "Target": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://dev.azure.com/advantive-devops-sandbox/",
        "Project": "Advantive",
        "Authentication": {
          "AccessToken": "PAT"
        },
        "ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        }
      }
    },
    "Processors": [
      {
        "ProcessorType": "TfsWorkItemMigrationProcessor",
        "Enabled": true,
        "UpdateCreatedDate": true,
        "UpdateCreatedBy": true,
        "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.Id] IN (1773) AND [System.TeamProject] = @TeamProject",
        "FixHtmlAttachmentLinks": true,
        "WorkItemCreateRetryLimit": 5,
        "FilterWorkItemsThatAlreadyExistInTarget": true,
        "GenerateMigrationComment": true,
        "SourceName": "Source",
        "TargetName": "Target",
        "StopIfValidationFails": "false",
        "SkipFieldsNotExplicitlyMapped": true,
        "SkipFieldValidation": true,
        "FieldSkipMap": true,
        "StopMigrationOnMissingAreaIterationNodes": false,
		"AreaMaps": {
			"^AbacaSystems(.*)": "Advantive"
      },
      "IterationMaps": {
			"^AbacaSystems(.*)": "Advantive"
      },
      "SkipRevisionWithInvalidIterationPath": false,
      "SkipRevisionWithInvalidAreaPath": false
      }
    ],
    "CommonTools": {
      "Enabled": "True",
      "WorkItemTypeMappingTool": {
        "Enabled": true,
        "Mappings": {
          "Epic": "Epic",
          "Feature": "Feature",
          "Bug": "Regression",
          "Support Ticket": "Support",
          "Task": "Task",
          "Infrastructure": "Technical",
          "User Story": "User Story"
        }
      },
      "FieldMappingTool": {
        "Enabled": true,
        "FieldMaps": [
          {
            "FieldMapType": "FieldValueMap",
            "sourceField": "System.State",
            "targetField": "System.State",
            "defaultValue": "New",
            "valueMapping": {
              "Active": "Active",
              "Closed": "Done",
              "New": "New",
              "Removed": "Removed",
              "Resolved": "Resolved"
            },
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldValueMap",
            "sourceField": "System.State",
            "targetField": "Custom.Status",
            "defaultValue": "00 New",
            "valueMapping": {
              "Active": "30 Dev In Progress",
              "Closed": "50 Done",
              "New": "00 New",
              "Removed": "99 Cancelled",
              "Resolved": "40 Ready for QA"
            },
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.AreaPath",
            "targetField": "Custom.Module",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldValueMap",
            "sourceField": "Priority",
            "targetField": "Custom.SupportPriority",
            "defaultValue": null,
            "valueMapping": {
              "1": "P1: Critical",
              "2": "P2: High",
              "3": "P3: Medium",
              "4": "P4: Low"
            },
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.Id",
            "targetField": "Custom.TrackingId",
            "defaultValue": null,
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.State",
            "targetField": "Custom.LegacyState",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.CreatedDate",
            "targetField": "Custom.LegacyCreatedDate",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "PinPoint.Customer",
            "targetField": "Custom.Customer",
            "defaultValue": null,
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "Microsoft.VSTS.Build.FoundIn",
            "targetField": "Custom.AffectedVersion",
            "defaultValue": null,
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "Microsoft.VSTS.Build.IntegrationBuild",
            "targetField": "Custom.FixedinVersion",
            "defaultValue": null,
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.Id",
            "targetField": "Custom.LegacyTrackingId",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.Tags",
            "targetField": "Custom.LegacyTags",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "Microsoft.VSTS.Common.ResolvedReason",
            "targetField": "Microsoft.VSTS.Common.Resolution",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          }
        ]
      },
      "TfsWorkItemTypeValidatorTool": {
        "Enabled": true,
        "IncludeWorkItemtypes": [
          "*"
        ],
        "FixedTargetFields": {
          "Bug": [
            "System.Reason"
          ]
        },
        "TfsNodeStructureTool": {
          "Enabled": false,
          "Iterations": {
            "Mappings": [
              {
                "Match": "^SmartApplications([\\\\]?.*)$",
                "Replacement": "Advantive"
              }
            ]
          },
          "Areas": {
            "Mappings": [
              {
                "Match": "^SmartApplications([\\\\]?.*)$",
                "Replacement": "Advantive"
              }
            ]
          },
          "ShouldCreateMissingRevisionPaths": false,
          "ReplicateAllExistingNodes": false
        }
      }
    }
  }
}

[MrHinsh]

Area and Iterations are mapped using the TfsNodeStructureTool and not in the processor.

[pravinkanhekar-cv]

I have tried removing the configuration from Processor and TfsNodeStructureTool is already there in CommonTools, still its not working.

[pravinkanhekar-cv]

{
  "$schema": "https://devopsmigration.io/schema/configuration.schema.json",
  "Serilog": {
    "MinimumLevel": "Information"
  },
  "MigrationTools": {
    "Version": "16.2",
    "Endpoints": {
      "Source": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://dev.azure.com/pinpointinfo/",
        "Project": "SmartApplications",
        "Authentication": {
          "AccessToken": ""
        },
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        }
      },
      "Target": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://dev.azure.com/advantive-devops-sandbox/",
        "Project": "Advantive",
        "Authentication": {
          "AccessToken": ""
        },
        "ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        }
      }
    },
    "Processors": [
      {
        "ProcessorType": "TfsWorkItemMigrationProcessor",
        "Enabled": true,
        "UpdateCreatedDate": true,
        "UpdateCreatedBy": true,
        "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.Id] IN (39000) AND [System.TeamProject] = @TeamProject",
        "FixHtmlAttachmentLinks": true,
        "WorkItemCreateRetryLimit": 5,
        "FilterWorkItemsThatAlreadyExistInTarget": true,
        "GenerateMigrationComment": true,
        "SourceName": "Source",
        "TargetName": "Target",
        "StopIfValidationFails": "false",
        "SkipFieldsNotExplicitlyMapped": true,
        "SkipFieldValidation": true,
        "FieldSkipMap": true,
        "StopMigrationOnMissingAreaIterationNodes": false,
        "SkipRevisionWithInvalidIterationPath": false,
        "SkipRevisionWithInvalidAreaPath": false,
		"EnableTeamSettingsMigration": true
      },
	  {
		  "ProcessorType": "TfsTeamSettingsProcessor",
		  "Enabled": false
	}
    ],
    "CommonTools": {
      "Enabled": "True",
	  "TfsNodeStructureTool": {
        "Areas": {
          "Mappings": [
            {
              "Match": "^SmartApplications(\\\\.*)?$",
              "Replacement": "Advantive\\Manufacturing\\PINpoint\\PINpoint Team"
            }
          ]
        },
        "Enabled": "True",
        "Iterations": {
          "Mappings": [
            {
             "Match": "^SmartApplications(\\\\.*)?$",
             "Replacement": "Advantive\\2025 Year\\25.3 Quarter\\PINpoint\\2025.3.0"
            }
          ]
        },
        "ShouldCreateMissingRevisionPaths": "false",
        "ReplicateAllExistingNodes": "False"
      },
      "WorkItemTypeMappingTool": {
        "Enabled": true,
        "Mappings": {
          "Epic": "Epic",
          "Feature": "Feature",
          "Bug": "Regression",
          "Support Ticket": "Support",
          "Task": "Task",
          "Infrastructure": "Technical",
          "User Story": "User Story"
        }
      },
      "FieldMappingTool": {
        "Enabled": true,
        "FieldMaps": [
          {
            "FieldMapType": "FieldValueMap",
            "sourceField": "System.State",
            "targetField": "System.State",
            "defaultValue": "Backlog",
            "valueMapping": {
              "Active": "In Progress",
              "Closed": "Done",
              "New": "Backlog",
              "Pending": "Backlog",
              "Removed": "Removed",
              "Resolved": "Review"
            },
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldValueMap",
            "sourceField": "System.State",
            "targetField": "Custom.Status",
            "defaultValue": "00 New",
            "valueMapping": {
              "Active": "30 Dev In Progress",
              "Closed": "50 Done",
              "New": "00 New",
              "Pending": "00 New",
              "Removed": "99 Cancelled",
              "Resolved": "40 Ready for QA"
            },
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldValueMap",
            "sourceField": "System.AreaPath",
            "targetField": "Custom.Module",
            "defaultValue": "PINpoint",
            "valueMapping": {
              "SmartApplications\\Client": "PINpoint\\Client",
              "SmartApplications\\Client\\SmartBuild": "PINpoint\\Client\\SmartBuild",
              "SmartApplications\\Client\\SmartScreen": "PINpoint\\Client\\SmartScreen",
              "SmartApplications\\Database": "PINpoint\\Database",
              "SmartApplications\\Database\\Metadata": "PINpoint\\Database\\Metadata",
              "SmartApplications\\Database\\Stored Procedures": "PINpoint\\Database\\Stored Procedures",
              "SmartApplications\\Data\\DataManager Models": "PINpoint\\Data\\DataManager Models",
              "SmartApplications\\QA": "PINpoint\\QA",
              "SmartApplications\\Reports": "PINpoint\\Reports",
              "SmartApplications\\Reports\\Fastening": "PINpoint\\Reports\\Fastening",
              "SmartApplications\\Reports\\Product": "PINpoint\\Reports\\Product",
              "SmartApplications\\Reports\\Reports - UI": "PINpoint\\Reports\\Reports - UI",
              "SmartApplications\\Services\\DataManager": "PINpoint\\Services\\DataManager",
              "SmartApplications\\Services\\DataManager\\Event": "PINpoint\\Services\\DataManager\\Event",
              "SmartApplications\\Services\\DataManager\\Tracking": "PINpoint\\Services\\DataManager\\Tracking",
              "SmartApplications\\Shared": "PINpoint\\Shared",
              "SmartApplications\\Shared\\Messages": "PINpoint\\Shared\\Messages",
              "SmartApplications\\Shared\\Security": "PINpoint\\Shared\\Security",
              "SmartApplications\\Test Automation": "PINpoint\\Test Automation",
              "SmartApplications\\Tools": "PINpoint\\Tools",
              "SmartApplications\\Tools\\DatabaseDeployment": "PINpoint\\Tools\\DatabaseDeployment",
              "SmartApplications\\Tools\\ToolSimulator": "PINpoint\\Tools\\ToolSimulator",
              "SmartApplications\\Web": "PINpoint\\Web",
              "SmartApplications\\Web\\Dashboard": "PINpoint\\Web\\Dashboard",
              "SmartApplications\\Web\\Linguo": "PINpoint\\Web\\Linguo",
              "SmartApplications\\Web\\SmartScreen": "PINpoint\\Web\\SmartScreen",
              "SmartApplications\\Web\\Tracking": "PINpoint\\Web\\Tracking",
              "SmartApplications\\Web\\WebService": "PINpoint\\Web\\WebService"
            },
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.State",
            "targetField": "Custom.LegacyState",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.CreatedDate",
            "targetField": "Custom.LegacyCreatedDate",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.AssignedTo",
            "targetField": "Custom.DeveloperAssigned",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.Id",
            "targetField": "Custom.LegacyTrackingId",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.Tags",
            "targetField": "Custom.LegacyTags",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "System.Parent",
            "targetField": "Custom.LegacyParentId",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "PinPoint.Customer",
            "targetField": "Custom.Customer",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "PinPoint.Customer",
            "targetField": "Custom.Customer",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldValueMap",
            "sourceField": "Microsoft.VSTS.Common.Severity",
            "targetField": "Custom.SupportPriority",
            "defaultValue": "P3: Medium",
            "valueMapping": {
              "1 - Critical": "P1: Critical",
              "2 - High": "P2: High",
              "3 - Medium": "P3: Medium",
              "4 - Low": "P4: Low"
            },
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "Microsoft.VSTS.Build.FoundIn",
            "targetField": "Custom.AffectedVersion",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          },
          {
            "FieldMapType": "FieldToFieldMap",
            "sourceField": "Microsoft.VSTS.Build.IntegrationBuild",
            "targetField": "Custom.FixedinVersion",
            "defaultValue": "",
            "ApplyTo": [
              "*"
            ]
          }
        ]
      },
      "TfsWorkItemTypeValidatorTool": {
        "Enabled": true,
        "IncludeWorkItemtypes": [
          "*"
        ]
      }
    }
  }
}```

[pravinkanhekar-cv]

Please find my complete json file.

[MrHinsh]

Your config file is totallyinvalid. AI does a very poor job of creating valid configs. Please use the documentation on https://devopsmigration.io.

If you need more support, we have commercial support options.