Skip to main content
User Management: CSV Upload

How to properly utilize the CSV Upload Functionality

Ryan Goetz avatar
Written by Ryan Goetz
Updated over 3 months ago

For Vic.ai Organization Admins, we support a variety of user management functions via CSV Upload.
​
​Supported functionality:

  • Add new Users

  • Add Companies to an Existing User

  • Edit Rights for an Existing User

What you can't do is Delete a user via CSV. We make you delete a user via the User tab, to protect against mistakes!

Instructions for CSV Uploads and how to modify the file will be found on the upload instructions page. To upload a CSV, select CSV Upload as seen below.


Add New User

To add a new user, follow these steps:

  • Download a fresh CSV of your User population

  • Add information to the following columns

    1. Name (column A)

      1. Name of the User

      2. Example: John Doe

    2. Email (column B)

      1. Email address of the User

    3. User's Manager (Column E)

      1. Email Address of the manager - must already exist in Vic.ai (used for certain PO Mismatch flows)

    4. Company (column G)

      1. Exact Company name as spelled in Vic.ai. Tip: copy the name from an existing user!

      2. Example: Apple

    5. Roles (column H)

      1. "accountant"

      2. "admin"

      3. "invoice_approver"

      4. "po_mismatch_approver"

      5. "payment_approver"

      6. "payment_initiator"

      7. Protip: To add multiple companies to a new user, follow the steps described below for "Add Companies to Existing User"


Add Companies to Existing User

To add additional companies to a new user, add additional rows underneath their name in the CSV upload. Leave the Name and Email column blank, like in the example below that the arrows point to.
​

John Doe will be added to two companies, while Jane will be added to two.


Edit Rights for Existing User

To edit the rights for existing users, make modifications to the Type or Level column and upload the CSV.

  • Roles (column H) - separated by a comma

    • "accountant"

    • "admin"

    • "invoice_approver"

    • "po_mismatch_approver"

    • "payment_approver"

    • "payment_initiator"

Did this answer your question?