User roles:  ✔ Financial Administrator  ✔ User Administrator  ✔ Data Administrator ✔ Application Administrator 


The Resource Plan Upload allows you to bulk create or edit user accounts in the form of a bulk upload.


In this article, you will learn:

          how to access the resource plan bulk edit functionality.

          the steps to update resource records.

          the rules that are applied when updating resource records.

          the file format to use to upload resource records.



How to access the Resource Plan Bulk Edit Functionality?


The Resource Plan Bulk Edit functionality is available from the Financial Administration page. You therefore need to have the financial administrator role to be able to access it. In addition you also need the User Administration role in order to be able to update user records.


Navigate to the financial administration page and scroll down to the Resource Upload and Reporting section to find the Resource Plan Bulk Edit functionality.





Steps to update resource plans


Step 1: Download the data file

  • Click on the Download button. This will open up a dialog.
  • Select from the dropdown list the portfolio you want to download resources for. 
  • Select the type of resources you want to download.
    • Download All Resources will return all resources regardless of whether they are users or placeholders.
    • Download Named Resources Only will only return resources that have been set up as users.
    • Download Placeholder Resources Only will only returned placeholder resources.
  • Click on the Download button to download the resource plan extract file.


Make your desired changes to the excel spreadsheet data you have downloaded. See the table at the bottom of the page for a full description of each column.




Step 2: Edit the data file


p>Make the change you need to the downloaded file. You can find a detailed description of each column value in the last section of this article.



Step 3: Upload the data file


When you are happy with your changes click on the UPLOAD button to upload the amended file.

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. 





User account records that are not in the file being uploaded will not be updated or deleted. Only records listed in the file will be updated.



Data File Column Description


Column & Title

Description
Data Type
What happens if field is left blank?
A. ResourceRefThe accounts user name. This is the identifier for the account and must be unique.Alphanumeric (numbers & text)This field is mandatory if you are creating or editing a user account.

If left blank and the resource being created is not a placeholder, then the row will be skipped.
B. ResourceIdThis is the unique ID for the user account.NumberLeave blank for new accounts. Fluid will generate the unique ID.
C. FirstnameResources first name.TextNo value is set.
D. LastnameResources last name.TextNo value is set.
E. EmailAddressResources email address.Alphanumeric (numbers & text)No value is set.
F. StatusThe resource plan status. Doesn't deviate from Plan.TextField is set to Plan
G. StartDateTypically the date the account was created.DateFluid will set the start date as the date of the upload.
H. EndDateThe date the user account is terminated - typically the date the resource leaves the organisation.DateNo value is set.
I. ManagerRefThe resources line managers account IDAlphanumeric (numbers & text)No value is set.
J. CostCenterThe organisational department/area which incurs the cost of the resource.TextNo value is set.
K. RegionThe region, country or office of the resource. The options available for this field are fully customisable by the system administrator.TextNo value is set.
L. EngagementTypeThe type of resource - i.e. FTE, contractor, consultant. The options available for this field are fully customisable by the system administrator.TextNo value is set.
M. ProfileRoleThe primary title/role of the resource within the organisation. The options available for this field are fully customisable by the system administrator.TextNo value is set.
N. PortfolioThe portfolio the resource works for.
Note that the name of this column is dependent on the instance configuration as the 'portfolio' label cane renamed in Activity Setup page.
TestNo value is set.
O. AllocationThe maximum allocation the resource can be allocated to a project.

When allocating the resource to projects any allocation above this percentage will be considered an overallocation.
PercentageThe field is set to 1 - allowing an allocation of 100% for the resource.
P. RateCardThe rate card that is to be applied to the resource for financial forecasting and actual cost.TimeNo value is set. No forecast or actual values will be generated for the resource on projects.
Q. Override Hourly RateThe resource hourly rate. This rate will override the hourly rate from the resource's rate card.

Note that this column is only visible if the Disable Resource Plan Hourly Rate feature is turned off.
NumericNo value is set.
R. Primary FunctionThe resource primary function.TextNo value is set.
S. Headcount ImpactThe resource headcount impactTextNo value is set.
T. Position IDThe resource position IDTextThe value will be left blank.
U. IsPlaceholderThe account does not belong to a resource - it is a 'placeholder' account that can be assigned to projects for forecasting and capacity planning until an actual resource can be allocated.Yes/NoNo value is set.
V. Notes


W. Skills


X. EmailNotificationShould the resource receive Fluid email notifications?Yes/NoField is set to Yes.
Y. EmailNotificationFrequencyThe frequency at which the resource should be sent email reminders of their assigned actions. The options are Never, Weekly and Monthly.TextField/option is set to Weekly.
Z. MobileNotificationShould the resource receive Fluid mobile notifications when using the app?Yes/NoField is set to Yes.
AA. UserThe minimum role required for the resource to access Fluid. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AB. AccountableExecutiveIdentifies the resource as an Accountable Executive. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AC. BenefitAccessAllows the resource access to the Benefits and Ongoing Costs sections of project workspaces, as well as any Benefits and Ongoing Costs reporting. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AD. DataAdministratorAllows the resource access to the data administration page to do bulk download, edit and upload of project information and financials. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AE. FinancialAccessAllows the resource access to the Financials sections of project workspaces, as well as any Financial reporting. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AF. FinancialAdministratorAllows the resource access to the financial administration page to do bulk editing and the management of portfolio financial data - as well as make changes to finance related elements of the system configuration. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AG. ProjectAccessAllows the resource access to the Fluid Projects module. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AH. ProjectAdminAllows the resource full edit rights to all registered projects in Fluid. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AI. ProjectSubmissionAllows the resource rights to create new projects and/or programs from the universal CREATE button on the top navigation. Useful to restrict who can create and add new projects to the portfolio. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AJ. ProjectViewerAllows the resource READ access to ALL projects registered in Fluid. This role is typically reserved for relatively senior stakeholders who need complete transparency across the portfolio. Without Project Viewer access a person would need to be assigned a role on the project to be able to access it. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AK. ResourcingAccessAllows the resource access to the Community (resourcing) section of project workspaces, as well as any Resource reporting. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AL. TimeAdminAllows resource access to edit timesheet settings, and manage the exempt user group and timesheet admin user group. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AM. TimesheetExemptThe resource is not required to submit timesheets. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AN. UserAdminGrants the resource administrative rights to create and manage user accounts in Fluid. Click here for more on account roles and what they permission.Yes/NoIf left blank, the field is set according to the default role configuration settings for the instance. If a default role field is set to Yes, if not a default role field is set to No.
AO. DefaultWatchlistThe resources default filtered view on the project reporting dashboard page.Text (URL)No value is set.
AP onwardsPerson custom propertiesVariousNo values are set.