Error Encountered While Importing Work Items

Question

Description: We are encountering an issue when importing work items in Azure Boards. The error message we receive is:

We have followed the steps to export work items from one organization to another by exporting the work items to a CSV file from the source organization and attempting to import them into the target organization. Despite ensuring the CSV file is correctly formatted and all required fields are populated, we are still experiencing this issue.

We need assistance to understand why this error is occurring and how to resolve it. Additionally, guidance on the best practices for exporting and importing work items between Azure DevOps organizations would be appreciated.

Please check and provide the solution for exporting work items from one organization to another organization and importing them.

Thank you, [Sathishkumar G]

Answer 1

Hi Sathishkumar G,

Thanks for reaching out to Microsoft Q&A.

We need assistance to understand why this error is occurring and how to resolve it.

Your error suggests that the "Test Case" work item type is not recognized in the target organization.

1. Ensure that the "Test Case" work item type exists in the target organization's process template.
   • Navigate to Project settings--> work-->process.
   • Check the list of work item types to ensure "Test Case" is listed.
   • If "Test Case" is not listed, you may need to add it or use an existing work item type that matches your needs. You can either customize the process to add a new work item type or change the work item type in the csv file to a type that is supported in the target organization.
2. Change Work Item Type__:__
   • If adding the "Test Case" work item type to the target organization is not feasible, you can modify the csv file to use a different work item type that is supported in the target organization. You need to test this and see if this will work out.
   • Use the modified csv file to reattempt the import process.

 Additionally, guidance on the best practices for exporting and importing work items between Azure DevOps organizations would be appreciated.

 Best Practices

1. Consistent Fields: Use a consistent set of fields between the source and target organizations.
2. Validation: Validate the CSV file before importing to ensure all fields are correctly populated and formatted.
3. Use Templates: If possible, use work item templates to standardize the work item structure across organizations.
4. Testing: Perform a test import with a small set of work items to identify any issues before importing the entire set.

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

Answer 2

@Sathishkumar G Thank you for posting your question!

Azure DevOps is currently not supported in the Q&A forums, the supported products are listed over here - https://docs.microsoft.com/en-us/answers/products (more to be added later on).

The product group for Azure DevOps / TFS actively monitors questions over at

https://developercommunity.visualstudio.com/report?space=21&entry=problem

https://developercommunity.visualstudio.com/report?space=22&entry=problem

Hope this helps!

---

If the response helped, do "Accept Answer" and up-vote it