Bulk Edit is an easy way to add and update the allocation of multiple resources on a single project, or on multiple projects. 




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






Bulk Edit is available from:



Step 1: Download the data file

  • Select Resource Forecast on the left of the Bulk Edit dialog 
  • Select the date range that you want to edit resources for. 
  • 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. 


Extract example:Please 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. 




Remember - changes will only be applied if you have the right permissions to the projects to make resource changes. If you do not have permission to edit the projects in your data file the changes will not be made.




Data File Column Description


Each line in the upload file contains the details for a single resources allocation to the project for the period you selected when downloading the file.


Column & Title
Description
Data Type
What happens if this field is left blank?
A. AllocationIdFluid unique ID for the allocation record. If EDITING EXISTING resource allocation, do NOT change this field.
Leave the field blank if you want to add a new allocation record.
NumberThe record will be added as a new entry unless a record already exists for the project, resource and role combination.
B. ResourceRefThe USERNAME of the resource. You can find someone's username by searching for them using global search from the top nav. The text in brackets after their name is their Fluid username.

If there are no resources matching the ResourceRef value, then the row will be skipped.
Alphanumeric (numbers & text)This value is mandatory. If no value is specified, the row will be skipped.
C. ProjectNameThe name of the project the resource allocation applies to.TextThis column is for information only and is not processed on upload.
D. ProjectRefThe External Reference for the project the resource is allocated to. The External Reference can be found under Project Settings for the project.

If both ProjectRef and ProjectId (column E) values are set, they need to represent the same project in order for the entry to be processed. If only the ProjectRef value is specified and there is no AllocationId value set, Fluid will ignore the entry if it finds more than one project with the same ProjectRef as ProjectRef are not unique.
Alphanumeric (numbers & text)If both ProjectId (column E) and ProjectRef are blank Fluid will not process the entry. Otherwise the ProjectId value will be used to uniquely identify the project.
E. ProjectIdThe project Unique Id. The unique Id can be found in the top meta-data section of the Project Workspace.

If both ProjectId and ProjectRef (column E) values are set, they need to represent the same project in order for the entry to be processed.  If only the ProjectId value is specified, then it needs to match an existing project for the entry to be processed. 
NumberIf both ProjectId and ProjectRef (column D) are blank Fluid will not process the entry. Otherwise the ProjectRef value will be used to uniquely identify the project.
F. RoleThe assigned or specified position (role) of the resource within the business and the project (such as Business Analyst, Technician, Consultant, etc).

Note that it is not possible to create multiple records for the same resource and role combination for a given project.
TextMandatory field. Remember to use the roles that have been configured for your instance.
G onwards. Monthly Resource Allocation

The number of columns depends on Date Range selected on download. 
Resources are forecast as a percentage of one Full Time Employee (FTE) for each month in turn: e.g.
0 - No allocation.
1- 100% allocated.

0,5 - half allocated.

DecimalNo allocation will be made for that month.
Last column. DeleteRecordDeleting a financial forecast record will result in the resource being removed from the project community if the resource does not have an allocation for another role. A resource can only be removed from a project if:
  • there is no actuals amount posted for the resource and role combination

and

  • there is no forecast allocation for the resource and role combination in locked months
Yes / NoThe record will not be deleted.

 




Financial administrators can get an extract of all users in Fluid with ResourceRef and ResourceID details using the Resource Plans Upload