1. Home
  2. Knowledge Base
  3. Implementation
  4. How is the user data provided?
""
Eddy

How is the user data provided?

During the implementation process, the Flexwhere team will discuss with your organization the options for importing and maintaining users in Flexwhere.
Flexwhere supports three options for submitting users, these are discussed below.

A number of things are needed to set up the automatic synchronization of users:

  • Technical knowledge concerning Active Directory (AD)
  • Technical access;
  • Access to the Active Directory (AD).

If you choose to add users manually, you also need to maintain this manually.

The first possibility is to add one or more users manually in the Control Centre. Manual addition of users can only be performed by an Admin.

Multiple Users

  1. Sign in to Flexwhere Control Centre;
  2. Go to the Users menu;
  3. Click on the blue ‘+’ icon at the top right of the screen;
  4. Now select: ‘Add user list’;
  5. Select the correct CSV file with new users (download the template below);
  6. Confirm the choice;
  7. Select whether you want to add the users, or upload a completely new user list.
  8. Click submit.
  9. The system is now loading the list;

The CSV file must meet the following requirements and contents:

Field NameMandatory FieldsMin. CharactersMax. CharactersData typeExample
CSV_USERNAMEYes250AlphanumericJanJ
CSV_FIRSTNAMEYes250AlphanumericJan
CSV_SURNAMEYes250AlphanumericJansen
CSV_DISPLAYNAMEYes220AlphanumericJansen, Jan
CSV_TITLENo220AlphanumericManager
CSV_PHONENo220Numbers and Special characters(+,-,(,) etc)+3120123456
CSV_MOBILENo220Numbers and Special characters(+,-,(,) etc)+3165123456
CSV_DEPARTMENTNo250AlphanumericSupport
CSV_EMAILYes2NvtStandard formatj.jansen@flexwhere.com
CSV_EHBONo111 of 01
CSV_BHVNo111 of 00
CSV_PROFILEPHOTONo5500Hyperlink of bestandsnaamjanjansen.jpg

The CSV file must be named “flexwhere – users.csv”.

The contents of the fields must be placed within quotation marks. This prevents the addition of (hostile) code.

The separator between the fields in the CSV file must be “;”.

Note: If the ‘Replace the current user list with a new one’ option is selected then users not in the CSV file will be removed from Flexwhere.

Single user

  1. Sign in to Flexwhere Control Centre;
  2. Go to the Users menu;
  3. In the “Display Name” column, click the “+”;
  4. Fill in the information for the new user;
  5. Click save when the information is correct;
  6. The new user has now been created.

The second option involves exporting data from Active Directory to a CSV file. Next, this CSV file will need to be uploaded to the specifically created SFTP account for your organization.

When using SFTP, users are refreshed every 24 hours. For example, new colleagues are added to Flexwhere and any colleagues leaving the company no longer have access to the mobile app.

The CSV file must meet the following format:

Field NameMandatory FieldsMin. CharactersMax. CharactersData typeExample
CSV_USERNAMEYes250AlphanumericJanJ
CSV_FIRSTNAMEYes250AlphanumericJan
CSV_SURNAMEYes250AlphanumericJansen
CSV_DISPLAYNAMEYes220AlphanumericJansen, Jan
CSV_TITLENo220AlphanumericManager
CSV_PHONENo220Numbers and Special characters(+,-,(,) etc)+3120123456
CSV_MOBILENo220Numbers and Special characters(+,-,(,) etc)+3165123456
CSV_DEPARTMENTNo250AlphanumericSupport
CSV_EMAILYes2NvtStandard formatj.jansen@flexwhere.com
CSV_EHBONo111 of 01
CSV_BHVNo111 of 00
CSV_PROFILEPHOTONo5500Hyperlink of bestandsnaamjanjansen.jpg

The CSV file must be named “flexwhere – users.csv”.

The contents of the CSV file must be completed by default according to the rfc4180. To do this, save the file as Unicode (UTF-8).

The contents of the fields must be placed within quotation marks. This prevents the addition of (hostile) code.

The separator between the fields in the CSV file must be “;”.

The third possibility concerns a SCIM link. This requires a premium account with Azure AD.

With a SCIM link, users are refreshed in real time. For example, new colleagues are added to Flexwhere and any colleagues leaving the company no longer have access to the mobile app.

It is possible to configure which attributes are synchronized from the AD to Flexwhere.

Note: When users are resynchronized, please note that they will need to re-login to the Mobile and Web application.

Overview SCIM link

For an SFTP or SCIM connection: please contact the Flexwhere team.

Updated on 16-02-2024
Was this article helpful?

Related Articles