LogoLogo
More help and supportPhocas website
  • Home
  • Getting started
    • Navigation
    • Homepage
    • Data access
    • User licenses, profiles and permissions
    • Account settings
    • Databases
    • Periods
      • Offset dates
      • Default period for a database
    • Sharing and folders
      • Share a dashboard, favorite, or alert
    • Subscriptions
  • Analytics
    • Take a tour of Analytics
    • Work with the grid
    • View a summary of the data
    • Customize your view (Analytics)
      • Change the mode
        • Period mode
        • Period Variance mode
        • Period Stream mode
        • Moving mode
        • Stream mode
        • Total mode
        • Transaction mode
        • Matrix mode
        • Matrix Variance mode
        • Matrix Share mode
        • Variance mode
        • Search mode
        • Market mode
        • Custom mode
      • Change the properties (Analytics)
      • Change the measures (Analytics)
      • Change the stream
      • Use the activity filter
      • Change the data format
      • Change the period (Analytics)
    • Drill down into your data (view transactions)
    • Filter data (use dimensions)
    • Select data (Analytics)
    • Focus on data (Analytics)
    • Copy or export data
    • Search for data
      • Perform a basic search
      • Perform an advanced search
      • Search for similar or comparative data (right-click filter)
    • Add levels to the grid (grid nesting)
    • Compare data with Matrix mode
    • Get more options for viewing data
    • Visualize your data in a chart
      • Bar and Column charts
      • Combo chart
      • Pareto chart
      • Waterfall chart
      • Line chart
      • Area and % Area charts
      • Pie and Donut charts
      • Bubble chart
      • Radar chart
      • Gauge chart
      • Bullet chart
      • Summary and Ring Summary charts
      • Map charts
      • Configure the chart options
      • Select and focus on a chart segment
      • Export a chart as an image
      • Use the chart legend
    • Save favorites and add to dashboards (Analytics)
    • Reset data
    • Phocas AI
    • Flex Modes
      • Switch modes
      • Filter data (Flex Modes)
      • Apply conditional formatting
      • Add levels to the grid (Flex Modes)
      • Manage columns (Flex Modes)
      • Save and share a favorite (Flex Modes)
      • View your data in a chart (Flex Modes)
  • Financial Statements
    • Take a tour of Financial Statements
    • Overview of access to financial statements
    • Customize your view (Financial Statements)
      • Change the properties (Financial Statements)
      • Change the measures (Financial Statements)
      • Change the period (Financial Statements)
      • Change the current data
      • Change the budget data
      • Change the columns
      • Change the style
      • Change the rows (activity filter)
    • Filter the financial information
    • Select and focus on data (Financial Statements)
    • Copy or export financial information
    • Add a level in a financial statement
    • View financial information in a matrix (change column groups)
    • Add and view comments (Financial Statements)
    • View transactions (Financial Statements)
    • View financial information in a chart
      • Create a Pie and Donut chart (Financial Statements)
      • Create a Value card
      • Export a financial chart widget as an image
    • Save and share favorites (Financial Statements)
    • Add financial analysis to a dashboard
    • Manage financial statements
      • Overview of financial statements and dimensions
      • Create a financial statement
      • Delete a financial statement
      • Customize a financial statement
        • Rename a financial statement
        • Reorder a financial statement
        • Customize account groups
        • Customize calculations
          • Functions for Profit & Loss calculations
          • Formulas for financial ratios
        • Customize headings and spacers
        • Set the revenue row in a Profit & Loss statement
        • Customize columns
        • Customize a Cash Flow statement
          • Common account mapping for Cash Flow statements
        • Rebuild the database
      • Set the financial year end date
      • Map the Retained Earnings account(s)
      • Restrict access to accounts
      • Manage budget streams (Financial Statements)
        • Create a budget (Financial Statements)
      • Use statistical streams
      • Use multiple currencies
      • Manage dimension groups
      • Map categories from your Chart of Accounts
  • Budgets & Forecasts
    • Overview of key terms and concepts
      • Budgets versus forecasts
      • Users and data access
      • Relationship with the Financial Statements module
      • 3-statement budgeting
      • Filtering methods
      • Demand planning
      • Loan repayments
    • Take a tour of Budgets & Forecasts
      • Explore the budget workbook
      • Explore the forecast workbook
      • Explore the Balance Sheet and Cash Flow budgets and forecasts
    • Customize your view (Budgets & Forecasts)
      • Filter a worksheet (search for items)
      • Group period columns
      • Use layouts
    • Use session filters
    • Edit values in a worksheet
      • Open workbook notes
      • Use keyboard shortcuts
      • Copy and paste values
      • Use comparison rows
      • Use sum and working lines
      • Use formulas
      • Spread totals
      • Revert to the baseline values
      • Edit the Balance Sheet budget
      • View and use headcount data
    • Refresh a workbook
    • Use workflows
      • Contribute to the workflow
      • View the workflow history
      • View workflow comments
    • View budget information in a chart
    • Open baseline, comparative, or opening balance data
    • Review the budget or forecast
      • Add and view cell comments
      • View and restore the cell history
      • View the audit log
      • Compare actuals, budgets and forecasts
    • Export a workbook or worksheet tab
    • Manage budgets and forecasts
      • Create a budget workbook
        • Filtered budget or forecast
        • Multi-currency budget
        • Unclassified data
        • Period types in budgets
        • Additional measures for driver-based budgeting
      • Create a forecast workbook
      • Clone a workbook
      • Import a budget or forecast
      • Edit the workbook setup
      • Roll a budget forward
      • Add more detail to a budget or forecast
      • Add worksheet tabs (drivers)
        • Balance Sheet and Cash Flow tabs
        • Manual Entry tab
        • Database tab
        • Headcount tab
          • Headcount tab FAQs
        • Reference tab
        • Lookup tab
        • Allocations tab
        • Scratch Pad tab
      • Manage worksheet tabs
      • Add notes to a workbook
      • Customize the format of measures
      • Manage the workflow
      • Manage user access and notifications
      • Publish a budget, forecast or other worksheet tab
      • Fix the baseline in a budget
      • Delete or restore a workbook
      • Delete a stream (Budgets & Forecasts)
      • Troubleshoot performance issues
  • Rebates
    • Overview of rebates
    • Get started with Rebates
    • Projects
    • Rules
      • Parent-child rebate rules
      • Rebates calculation methods
      • Yearly rebates
      • Quarterly rebates
      • Monthly rebates
      • Whole rule period rebates
      • Retrospective rebates
      • Pro rata rebates
    • Calculations
      • Run a calculation
      • Schedule calculations
      • View calculation results and transactions
      • Post calculation results
    • Seasonal calendars
    • Rebates analysis
    • Rebates near miss analysis
  • CRM
    • Overview of CRM
    • Agenda
    • Contacts
    • Accounts
    • Leads
    • Activities
      • Microsoft 365 Outlook calendar integration
    • Campaigns
    • CRM analysis
    • CRM administration
  • Favorites
    • Save a favorite
    • Manage favorites
    • Set a favorite as your default view
    • Use alerts
  • Dashboards
    • Use dashboards
    • Create a dashboard
    • Set a dashboard as your homepage
    • Manage dashboards
  • Administration
    • Overview of access to data (Administration)
    • Users
      • Add, update or delete a user account
        • User maintenance form
        • User permissions
      • Create a user template
      • Manage a user's database access and restrictions
      • Manage user passwords
      • Monitor user activity
      • Lock user accounts
      • Impersonate a user
    • Profiles
    • Folders (Administration)
    • Favorites (Administration)
    • Dashboards (Administration)
    • Subscriptions (Administration)
    • Periods (Administration)
      • Period types
      • Working days
    • Databases (Administration)
    • Sync Sources
    • Connectors
    • Configuration
      • Set up SSO
      • Set up SSO with Microsoft Entra ID
    • Logs
    • Designer
      • Modify a database
      • Get your data into Phocas
      • Design a database
        • Create a database
        • Add (connect) data to a database
        • Map data to the database
        • Save your database design
      • Design a financial database
      • Build a database
      • View and revert to older design versions
      • Add a budget file to a financial database
      • Add a budget file to a non-financial database (easy budget upload)
    • Sync
      • Automatically join or split items during Sync (split view)
      • Schedule the sync process
      • Migrate Sync
      • Test the sync process
    • Reserved words and characters
    • End of year maintenance tips
  • OTHER INFORMATION
    • File upload
    • Encrypt (share secrets)
    • Glossary
    • Release notes
      • Analytics release notes
      • Financial Statements release notes
      • Budgets and Forecasts release notes
      • Rebates release notes
      • Administration release notes
    • System requirements
    • Technical limitations
    • Security information
    • Scheduled upgrade and maintenance periods
    • More help and support
Powered by GitBook

© Phocas Software

On this page
  • Add users
  • Manually add a user
  • Clone a user
  • Import users
  • Update users
  • Update an individual user
  • Update users in bulk
  • Delete a user
  • 1. Remove a user’s license
  • 2. Lock the user account (optional)
  • 3. Reassign a user’s content ownership
  • 4. Reassign the user’s CRM accounts
  • 5. Delete the user account

Was this helpful?

  1. Administration
  2. Users

Add, update or delete a user account

Add new users to Phocas and update their details and permissions as things change over time.

PreviousUsersNextUser maintenance form

Last updated 1 month ago

Was this helpful?

User permission:

Add users

There are three ways to add a new user account. You can manually add a new user account from scratch or clone an existing user account to create a new user account with most of the same settings. You can also import multiple user accounts (and assign the same settings) at the same time.

You start all of these actions on the .

Manually add a user

  1. On the Users page, click New.

  2. Select the applicable permissions: General (Account Locked and Detailed Logs), Folders and Custom Actions.

  3. Click Save. The new user account is created and extra tabs appear.

  4. Click Save > Close.

Clone a user

  1. On the Users page, select the existing user you want to clone and click Clone.

  2. Select the LDAP Authenticated? checkbox, if required.

  3. Select the Copy personal favorites checkbox, if you want to copy the original user's personal favorites and assign them to the new user. These are copies only - if the original user deletes a personal favorite, it doesn't affect the new user's copy.

    • Personal favorites are those favorites that are owned by the original user. Any favorites that were shared with the original owner are not copied.

    • Any shared users on the original owner's personal favorites are not copied.

    • Subscriptions are not copied.

  4. Enter and confirm a password for the new user.

  5. Select the Force password change? checkbox (only available on non-LDAP sites) if you want to user to be required to create a new password when they first sign in.

  6. Click Save. The new user account is created and opens on the User tab.

Import users

  1. On the Users page, click More > Import.

  2. Upload or select users, according to your server configuration, which is either Phocas (default) or LDAP authentication:

    • Phocas (default) authentication - The Import tool allows you to upload new users via a CSV text file, for example, based on a Microsoft Excel worksheet. Ensure the data in your file is in the order specified on the Import Users window. You might prefer to download and edit the example file below. Then select your file and click Upload.

  • LDAP authentication - The Import tool retrieves a list of all LDAP users who are not already in the Phocas user list. Select the required users and click Next.

  1. Assign the users to a group, territory and/or team. Unless you have the Users: All Users setting selected in your profile, the Group and Territory fields will automatically be populated with your own group and territory and show as disabled. If you have either Users: Users In Same Group or Users: Users In Same Territory, but not Users: All Users, both Group and Territory will be disabled.

  2. Select the applicable permissions: General (Detailed Logs), Folders and Custom Actions.

  3. Click Next.

  4. Select a defined period next to the database or databases you want the new users to be able to access.

  5. Click Save.

  6. Proceed to update the individual user accounts, as required.

Update users

Update an individual user

  • Favorites and Databases tabs: Remove the user’s access to favorites and dashboards.

Click Save to save and apply your changes, then click Close to return to the Users screen.

Update users in bulk

The Bulk Update feature allows you to update multiple settings, permissions and restrictions for one or more users at the same time, which can save you a lot time.

Update user settings, permissions and restrictions

As the following steps outline, along with updating the general permissions for selected users, you can specify the databases to which they have access. Then within each database, you can specify which dimensions, streams and measures the users can access. You can even apply filters to the dimensions to restrict access at the lowest level of data.

1. Select users and access the Bulk Update screen

On the User page, select the users for whom you want to update details and click More > Bulk Update.

On the Bulk Update screen, ensure you have selected the correct users (clear the checkboxes of any users you do not want to update) and click Confirm.

2. Update the user settings and permissions

On the next Bulk Update screen, update the General, License, Settings, Folders and Custom Actions permissions, as required and click Next.

3. Update the Database access

On the next Bulk Update screen, update the database access for the selected users, as required. You can give or remove access and change the default period for each database.

Users need to have a defined access period to be able to access a database.

To give access to a database, select a default period from the dropdown list.

To change the default period for a database, select a different default period from the Default Period dropdown list.

To remove access to a database, select the None option from the Default Period dropdown list.

4. Update the database restrictions
  1. On the next Bulk Update screen, click the Restrictions button (lock icon) of the database for which you want to update restrictions.

  2. On the Restriction on [database name] screen, confirm you are making changes for the correct users. In the top-left corner, you will see a blue link with the number of users included in the bulk update. You can click the link to view the list of user names. If you need to make any changes to the selected users, click Close > Cancel and start again.

  3. Set which Sub-Database (if applicable), Dimensions, Streams and Measures in the database are visible to the selected users:

    • Click the Dimensions/Stream/Measures tab (as required) and for each item.

    • Select either Visible or Invisible from the Bulk Change dropdown list, as applicable. If you do not want to make any changes, leave the Leave unchanged option selected. The numbers in the respective columns identify the changes you are making.

    • Apply filters to the dimensions: Click the Data Filters tab and expand the dimension for which you want to apply a filter. Select Create new filter, then configure the filter condition as required. Click the blue plus button to add another filter condition, if required.

  4. Click Done. You return to the Bulk Update screen, where the Restriction button is yellow to indicate that changes were made.

  5. Repeat the above steps to update the restrictions for other databases, as required.

5. Review and confirm changes
  1. Back on the Bulk Update screen, when you have made all your changes for the selected users, click Next.

Clear or delete database restrictions for the selected users

In addition to adding new restrictions or changing existing restrictions, you can clear and delete restrictions in bulk. At the bottom of the screen there are options to clear and delete those restrictions:

  • Clear restrictions: Reset all restrictions that were applied to the selected users (regardless of whether you have applied them during this update session or not). This action is the same as selecting Visible from the Bulk Change dropdown list for all items and deleting all filters. In other words, you give the selected users permission to view all the data in the database.

  • Delete restrictions: Remove all restrictions that were applied to the selected users (regardless of whether you have applied them during this update session or not) and apply the default database restrictions (if any) instead. This action disables the options in the database restrictions screen, as they are no longer applicable. In other words, you remove the special treatment you previously applied to the selected users, which as a result, might reduce the amount of data they can view in the database.

Click the Clear restrictions button or select the Delete restriction for users checkbox, as applicable, then click Done.

Delete a user

When you delete a user, you permanently remove their user account from Phocas. This action also removes any content the user owns, such as favorites they saved and dashboards they created. If this content is shared with other users, deleting the user might have negative consequences for your business, as you will lose access to content you actively use.

Deleting a user also removes any CRM accounts that the user created. Such accounts cannot be reassigned after you delete the user, so you must reassign them before you delete the user account.

The best way to remove a user but retain the content they created is to remove their license. This removes the user’s ability to sign in to Phocas. As a result, all of the user’s content will no longer have an owner. You can then assign that content to another user (owner) so that it is retained when you delete the user. If applicable, you should also reassign any CRM accounts created by the user to other users. You can then delete the user account from your Phocas site.

1. Remove a user’s license

2. Lock the user account (optional)

3. Reassign a user’s content ownership

After removing the user’s license, you can assign a new owner to that user’s favorites and dashboards.

Click Administration > Dashboards or Favorites (as applicable) and select the user (from whom you have just removed the license) from the Owner filter above the grid. The grid updates to display only the content that user owns.

Select an item row and click Share, then select a new owner and click Save.

Repeat the above steps to assign a new owner to the user’s other favorites and dashboards.

4. Reassign the user’s CRM accounts

5. Delete the user account

Click Administration > Users to open the Users screen, select the user row and click Delete.

Watch this Phocas Academy video:

On the New User page, enter the user’s details, including their email address and display name. See the for more information.

Determine whether or not you want to send the user an email with their login details. See .

Select the applicable .

Click the Profile tab and either assign a shared or create a user-specific profile.

Click the Databases tab and give the user access to the database(s) and set restrictions as applicable. See and .

Watch this Phocas Academy video:

In the Clone User window, enter the user’s username and display name. See the for more information.

Proceed to update the .

Watch this Phocas Academy video:

Select the applicable.

Determine whether or not you want to send the user an email with their login details. See .

You can update the details, settings, permissions and restrictions for an individual user account or update multiple user accounts at the same time using the .

On the Users page, click the user’s name (blue link) to open the where you can update the user account as required:

User tab: Update the user’s details, and main permissions.

Profile tab: Update the specific or .

Databases tab: Update the .

Watch this Phocas Academy video:

You might not see all of the permissions in the list, as some of them are only available to users whose profile has the Users: All Users permission or administrators with special permissions, as they relate to system-wide settings. Learn more about .

If your applied restrictions don’t look or behave as expected, please . We are aware that the application of restrictions differs slightly depending on where or how you apply them. We are working on making this more intuitive and consistent.

Review the changes you are about to make, then click Confirm to apply the changes to the selected users.

Open the Users page, click the green Users button and select License. Then, in the , select the blank option from the dropdown list to remove their Phocas license.

For peace of mind, in addition to removing the user’s license, you might want to .

See these pages for more information: and

Assign a new owner to the user’s CRM accounts, if applicable. You do this on the Account tab of each individual account record. See .

Add a new user in Phocas
User maintenance form
Manage user passwords
license(s)
profile
Overview of access to data (Administration)
Manage a user's database access and restrictions
Import users with CSV Import
User maintenance form
user’s maintenance form
Clone a user
license(s)
Manage user passwords
user maintenance form
license
user permissions
assign a different profile
user’s database access and permissions
Update users in bulk
contact our Support Team
lock their user account
Manage favorites (at the administration level)
Manage dashboards (at the administration level)
View and edit accounts
Bulk Update tool
Administration > Users page
administration permissions
Licence view
Administration > Users
1KB
upload.csv