Resource Plan Bulk Upload

Modified on Wed, 22 Nov 2023 at 03:44 PM

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 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.




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 return placeholder resources.
  • Click on the Download button to download the resource plan extract file.



Step 2. Edit the data file


  • Make the changes required to the downloaded file. You can find a detailed description of each column 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. 





NOTE: 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?
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.
ResourceIdThis is the unique ID for the user account.NumberLeave blank for new accounts. Fluid will generate the unique ID.
FirstnameResources first name.TextThe value is saved as blank.
LastnameResources last name.TextThe value is saved as blank.
EmailAddressResources email address.Alphanumeric (numbers & text)The value is saved as blank.
StatusThe resource plan status. Doesn't deviate from Plan.TextField is set to Plan
StartDateTypically the date the account was created.DateFluid will set the start date as the date of the upload.
EndDateThe date the user account is terminated - typically the date the resource leaves the organisation.DateThe end date is saved as blank, i.e no end date.
ManagerManager nameTextThis value is not processed, only the ManagerRef value is. 
ManagerRefThe resources line managers account IDAlphanumeric (numbers & text)The value is saved as blank.
CostCenterThe organisational department/area which incurs the cost of the resource.TextThe value is saved as blank.
RegionThe region of the resource is located in. The options available for this field are fully customisable by the system administrator.TextThe value is saved as blank.
CountryThe region of the resource is located in. The options available for this field are fully customisable by the system administrator.TextThe value is saved as blank.
EngagementTypeThe type of resource - i.e. FTE, contractor, consultant. The options available for this field are fully customisable by the system administrator.TextThe value is saved as blank.
ProfileRoleThe primary title/role of the resource within the organisation. The options available for this field are fully customisable by the system administrator.TextThe value is saved as blank.
Division

The name of this column is dependent on the instance configuration as the 'Division' label can be renamed in Project Setup page.
The resource division.

Note that if a valid value exists for the Team or TeamRef column, then the division value is automatically derived from the resource team.
TextIf no Team or TeamRef values are present, then the division value is saved as blank.
Otherwise, if the Team or TeamRef value is valid, the Division value is derived from the Team value.
Department

The name of this column is dependent on the instance configuration as the 'Department' label can be renamed in Project Setup page.
The resource department.

Note that if a valid value exists for the Team or TeamRef column, then the department value is automatically derived from the resource team.
TextIf no Team or TeamRef values are present, then the department value is saved as blank.
Otherwise, if the Team or TeamRef value is valid, the Department value is derived from the Team value.
Team

The name of this column is dependent on the instance configuration as the 'Team' label can be renamed in Project Setup page.
The resource team.

TextIf the TeamRef value exists and is valid, the Team value is derived from the TeamRef value.
Otherwise it is saved as blank.
TeamRefThe team reference ID.Alphanumeric (numbers & text)The value is saved as blank.
Capacity

The 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.
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.
Primary FunctionThe resource primary function.TextNo value is set.
Headcount ImpactThe resource headcount impactTextNo value is set.
Position IDThe resource position IDTextThe value will be left blank.
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.
NotesNotes associated to the resource plan.TextNo value is set.
SkillsList of the resource skills.TextNo value is set.
Account Exec 1The accountable executive the resource report into.

Note that this column name can be updated in Activity Set Up page.
TextThis value can be left blank as it is automatically calculated when calculating the resource manager hierarchy.
Account Exec 1 RefThe accountable executive external reference.Alphanumeric (numbers & text)This value can be left blank as it is automatically calculated when calculating the resource manager hierarchy.
Account Exec 2The direct report of accountable executive the resource report into.

Note that this column name can be updated in Activity Set Up page.
TextThis value can be left blank as it is automatically calculated when calculating the resource manager hierarchy.
Account Exec 2 RefThe accountable executive 2 external reference.Alphanumeric (numbers & text)This value can be left blank as it is automatically calculated when calculating the resource manager hierarchy.
EmailNotificationShould the resource receive Fluid email notifications?Yes/NoField is set to Yes.
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.
LicenseTypeThe type of license the user has. The options are Collaborator, Licensed and Unlicensed.
Text
The value will be set to Licensed if field is left blank.
UserThe minimum role required for the resource to access Fluid. Click here for more on account roles and what they permission.Yes/NoThe 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.
AccountableExecutiveIdentifies the resource as an Accountable Executive. Click here for more on account roles and what they permission.Yes/NoThe 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.
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/NoThe 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.
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/NoThe 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.
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/NoThe 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.
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/NoThe 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.
ProjectAccessAllows the resource access to the Fluid Projects module. Click here for more on account roles and what they permission.Yes/NoThe 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.
ProjectAdminAllows the resource full edit rights to all registered projects in Fluid. Click here for more on account roles and what they permission.Yes/NoThe 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.
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/NoThe 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.
ProjectViewerAllows the resource READ access to ALL projects registered in Fluid. This role is typically reserved for 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/NoThe 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.
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/NoThe 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.
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/NoThe 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.
TimesheetExemptThe resource is not required to submit timesheets. Click here for more on account roles and what they permission.Yes/NoThe 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.
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/NoThe 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.
DefaultWatchlistThe resources default filtered view on the project reporting dashboard page.Text (URL)No value is set.
AY onwardsPerson custom propertiesVariousNo values are set.






Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article