Project status can be bulk edited in excel through the use of Fluid Bulk Edit functionality.


In this article, you will learn:

          how to access the bulk edit functionality.

          the steps to update the project status.




How to access the Project Status Bulk Edit Functionality? 


The Projects Status Bulk Edit functionality is available from:


Accessing Bulk Edit from Project Dashboard/Watchlist

To access Bulk Edit, select Tools (top right of the page) and select Bulk Edit.






Accessing Bulk Edit from Project Workspace

The Bulk Edit function can also be accessed from the project workspace page by selecting the Bulk Edit option (under the Tools section) on the left navigation menu.





Steps to update project status


Step 1: Download the data file

  • Select Project Status on the left of the Bulk Edit dialog 
  • If you want to download existing data from the project/s 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. 


The format of the excel file will vary depending on whether the file was downloaded from a watchlist page or a project workspace

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.

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 projects to make the data changes. If you do not have permission to edit the projects in your data file the upload will not process the changes.
  • When entering values that have been predefined in Fluid as selection options (e.g. RAG status) please make sure your entries exactly match the available configured entries in Fluid.




Column TitleDescriptionWhat happens if the field is left blank when uploading the file?
The below three columns are only present if the bulk edit functionality is accessed from a project watchlist.
The file must contain a value in the ProjectID column or Project Ref column to uniquely identify the project to be updated. If no values are set or if they are incorrect, the row will be skipped. In addition the user uploading the file must have rights to edit the project, i.e. they must be either a project administrator or the PM or editor of the project.
ProjectThe project name or title.This field is for information only and is not used by the upload process.
ProjectIdThe project unique ID in Fluid. If ProjectRef is blank too or if there are no projects in the database matching the ProjectRef value, then the row will be skipped.
ProjectRefThe project external reference. If ProjectId is blank too or if there are no projects in the database matching the ProjectId value, then the row will be skipped.
The below columns are always present regardless from where the bulk edit functionality is accessed.
StatusDateThe date of the project status report.

If a status report already exists for this date, the report will be updated as per the data in the file being uploaded.
Fluid will default to the date of upload.
OverallHealthRAGThe project RAG status - specify between Red, Amber or Green. If any other value is specified, then the RAG status will be set to GreenThe RAG status will be set to Green.
StraplineHigh level elevator pitch that speaks to the RAG status of the project.This is a mandatory field. If left blank, the row will be skipped.
AchievementsDescription of what has been achieved.The status report won't have any achievements recorded.
NextStepsDescription of the planned next steps.The status report won't have any next steps recorded.
Executive SummaryExecutive summary description. This property can be used to provide an additional status commentary that you can use as an alternative update.The status report won't have an executive summary recorded.
The following columns are repeated for each status RAG component that has been configured by the administrator. You can find more on status report RAG components here.
<RAG Component Title> RAGThe RAG status of the RAG component.The RAG component will be set to Green.
<RAG Component Title> OwnerThe name of the person who is responsible for the resolution of that RAG component.It is not necessary to populate this column on upload. 
Owners full names are included in extracts to help you better identify who owns the item - because the Owner ID (which is the proper identifier) can be cryptic!
<RAG Component Title> OwnerIdThe username of the person who is responsible for the resolution of that RAG component. This is the unique identifier Fluid will use to set the owner of the component RAG
This value is mandatory if the RAG status has been set to Red or Amber.
If the component RAG is Green, then no owners will be set. Otherwise the row will not be processed as this is a mandatory field for Amber and Red RAG components.
<RAG Component Title> PathToGreenThe date which the RAG component will be expected to be on the path to green status.
This value is mandatory if the RAG status has been set to Red or Amber.
If the component RAG is Green, then no path to green value will be set. Otherwise the row will not be processed as this is a mandatory field for Amber and Red RAG components.
<RAG Component Title> Issue/Risk IdThe Fluid unique ID of the issue/risk linked to this RAG component.
The issue or risk record must already exist. If an invalid ID is specified, then no risks or issues will be associated to the component RAG.
No risks or issues will be associated to the RAG component.
<RAG Component Title> Issue/Risk NameThe title of the issue/risk linked to this RAG component.It is not necessary to populate this column on upload. 
The risk or issue titles are included in the extract for information only.
<RAG Component Title> CommentaryThe path-to-green mitigating commentary.
This value is mandatory if the RAG status has been set to Red or Amber.
If the component RAG is Green, then no commentary will be set. Otherwise the row will not be processed as this is a mandatory field for Amber and Red RAG components.

Status report custom propertiesIf status report custom properties have been set by your system administrator, there will be a column for each custom property that has been set to Reportable.  The properties will be left blank.
DeleteRecordEnter Yes if you want the delete the impact record. The date of the status report to be deleted must not be empty.Fluid will not delete any entry.