Import DevOps work items to a Fluid Board
If you have pre-existing work items in your DevOps instance, you can Bulk Edit and upload these onto your Fluid board. A Fluid card will be created for each DevOps work item uploaded, and will be linked to DevOps if your board is configured for integration. For more information on how to use Bulk Edit see How to use the Bulk Edit Function for Board Tasks.
First step is to run a Query in DevOps to select the work items you want to Bulk Edit and Upload. The DevOps query will return all the work items that match your specific criteria. See this Microsoft article for more details https://learn.microsoft.com/en-us/azure/devops/boards/queries/import-work-items-from-csv?view=azure-devops
Your query needs to contain the below values in the response at a minimum:
ID - The work item ID
Work Item Type - The task type of the work item, eg. Epic, Feature etc
State - The state of the work item, eg. New, In Progress, Completed etc
Title - The Title of the work item
Export to CSV and open the file in Excel.
On your Fluid board, top right of the main board view
Click on Tools
Select Bulk Edit
Click Download
Open the downloaded Excel file. This file represents items on the Fluid Board and should look similar to below
From the exported Query CSV file you will need to populate values for the following named columns on to the downloaded Bulk Edit Excel file.
Note: Below are the minimum required fields that need to be populated for each item. You can populate more column data if you wish. If you have configured the board to Sync data from DevOps into Fluid then any configured mapped fields will be automatically pulled in and don't need to be pre populated here. See How to configure Azure Devops to Fluid Boards integration for more details.
Title - The DevOps work item title
Status - The DevOps work item State, eg. New, In Progress etc.
Task Type - The DevOps work item type, eg. Epic, Task etc
AzureDevOps - The DevOps work item ID.
Save the Excel
Click Upload, and select the Excel file saved above when prompted and Click Open.
Cards will start to be created on the board for each of the row items in the Excel file and will be linked to the corresponding DevOps work item based on the AzureDevOps column cell values and the DevOps Board Integration Configuration you have setup. See How to configure Azure Devops to Fluid Boards integration for more information on how to setup your board for access to DevOps and integration.