Board tasks can be bulk edited in excel through the use of Fluid Bulk Edit functionality.



To access the Bulk Edit functionality, navigate to the board you want to update. Select 'Tools' (top right of the page) and select 'Bulk Edit'.




Step 1: Download the data file

  • If you want to download existing data from the board into the file make sure the flag is set to Yes. To extract a blank upload file, set it to No.
  • Click on Download.





Step 2: Edit the data file


Make your required changes to the file that you downloaded. 


See the table at the bottom of this page for a full description of each column.



Step 3: Upload the data file


When you are happy with your changes, select Upload in the Bulk Edit dialog and select the file you want to upload.


If you are uploading the items to a different board, first navigate to the board you want to upload to and open the bulk edit dialog from there.




The progress bar will indicate when the upload process is completed and if any errors occurred during the upload process, they will be listed below the progress bar. 



Data File Column Description



Remember when populating the excel:
  • changes will only be applied if you have the right permissions to the board to make the data changes.
  • make sure to populate the SprintName column value with the name of the board you want the tasks to be uploaded to. If left blank, all tasks will be saved in the backlog. See below for more details.




Column & Title
Description
What happens if this field is left blank?
A. IdThe task unique Id of the task. This value is set by the system when a new task is created and is used to uniquely identify the record. This field should, therefore, be left blank when creating a new task.When updating existing tasks on a board, this is the ID that will be used to match the record in the excel to a task on the board.

If this field is blank then the upload will check the Guid (column P). If this is also missing the upload will not match to an existing task and a new task will be created.
B. ShortIdThe task unique identifier within the board. This value is set by the system and cannot be updated.Information purposes only. It is not necessary to populate this column on upload. 
C. TitleThe task title.This is the only mandatory field to complete in order to add or update a task.
D. DescriptionThe task description. This is a detailed explanation of the task.No description will be set.
E. AssignedToThe full names of the assignees.It is not necessary to populate this column on upload. 

Full names for assignees is just display text and is included in extracts to help you better identify who is assigned to an item. The User ID (column F) is the actual identifier that is used to match the assignee to an account in Fluid.
F. AssignedToIdThe assignee's usernames.This is the unique identifier Fluid will use to set the assignees - if this field is left blank, no assignees will be added to the item.

A persons username, or ID, can be found in brackets after their name if you search on them in Fluid.
G. StatusThe task status. Status values will vary depending on the customised columns of the board.If left blank:
  • the task will be dropped into the first column on the board if the SprintName value is set to a board,
  • or the task will be set to backlog if the SprintName value is blank, Backlog or _backlog.
H. SprintNameThe name of the board which the task will be added to.

To add a task to backlog, you can:
  • leave the value blank
  • set the value to Backlog or _backlog.


To add a task to the board, you need to set the value to the board name you want to add the task to.

If left blank the task will be dropped into the BACKLOG of the board.
I. TaskTypeThe task type.The type will default to Task.
J. PointsThe points effort it will take to complete the task.Points will default to 1 point.
K. ImpactThe impact that the task will have on the business overall.Impact will default to 1 point.
L. PriorityThe priority of the task – High, Medium or Low.Priority will default to Medium.
M. DueDateThe date that the task is due.No due date will be added.
N. ThemeThe task's theme.No theme will be selected.
O. ImpedimentThe factor that may slow the progress of the task down. Set as "No" by default in Fluid.Impediment flag will default to FALSE / NO.
P. GuidThe unique string identifier for the task.When updating existing tasks on a board, the Guid is used to match the record in the excel to a task on the board.

If this field is blank then the upload will check the ID (column A). If this is also missing the upload will not match to an existing task and a new task will be created.
Q. DeleteRecordIf you want to delete a task altogether, type in Yes. Remember, deleting a task this way is irreversible.The task will not be deleted.