Add users

With the following user provisioning file it is possible to update and upload single users or batches of users without interfering with the status of the previously uploaded user data. It provides the flexibility of adding or updating 5 users without the need of sending through all users again.

The mechanism behind this upload goes as follows: Xpenditure keeps track of all users within the company account, if a new “users”-file is uploaded the data of the user will be updated or the user will be deactivated based on the provided “active” status. The benefit is that there is no need to provide all userdata for making a single change.

Use the following structure to upload user data:

Download example

companynameprefix_users_uniquedateornumber.csv
email;firstname;lastname;language;country;branchname;branchid;groupname;groupid;userid;reimbursementaccount;active;customfield
employee@company.com;John;Johnson;Eng;GB;Company ABC;10001;Sales;S00001;123456789;IBAN;0;value
employee2@company.com;James;Jameson;Eng;GB;Company ABC;10001;Sales;S00001;987654321;IBAN;1;value
Header Example Type Required Description
email employee@company.com string * Email address of the user, this is the unique key within Xpenditure to login to the mobile and web platform
firstname John string * First name of the user
lastname Johnson string * Last name of the user
language eng string * All languages are expressed according to the standard ISO 639-2/T coding. They are mandatory to set the language of a user account. Xpenditure currently supports following languages: English, Dutch, French, German, Portuguese, Italian, Spanish, Danish
country GB string * All countries are expressed according to the standard ISO 3166.
branchname CompanyABC string Name of company/entity
branchid 10001 string * Unique company/entity code
groupname Sales string * Name of the group that the user is part of. This is often used for defining departments or cost centers.
groupid S00001 string * Unique code of a group that the user is part of. Often used for departments or cost centers.
userid 123456789 string Unique code for a user. Often used for Employee number or Vendor Number of the ERP system.
reimbursementaccount IBAN string Direct deposit account of the employee where the reimbursement funds need to be received upon.
active 0 integer * Status if user needs to be created in the “active” or “inactive” status. With the “active” status equal to “1”, an automated email is sent upon creation of the user, to verify his account.
customfield XYZ123 string An optional field if any custom fields exists on a user level