Add/Update People from Excel in the browser client

To add multiple users to OfficeMaps from an Excel file:

First you need to download the example Excel file:

1. Click on the arrow on the left top corner (on top of your username).
   

1. Click on the 'People' button. 
   

1. Click on the 'Action' button on the top bar.

1. Click on 'Download Example Excel File Add/Update People' option.

Downloading Example Excel File

The table below explain each field on the Example Excel File:

Excel Column Headers	OfficeMaps Corresponding Field
Username	Is the 'Username' field when adding a user manually
Email	Is the 'Email' field when adding a user manually and is display on the User's Profile
FirstName	Is the 'First Name' field when adding a user manually and is display on the User's Profile
LastName	Is the 'Last Name' field when adding a user manually and is display on the User's Profile
DisplayName	Normally is auto generated from the First and Last Name field
Initials	Is the 'Initials' field when adding a user manually and is display on the User's Profile
Position	Is the 'Position' field when adding a user manually and is display on the User's Profile
Phone	Is the 'Phone' field when adding a user manually and is display on the User's Profile
PhoneExt	Is the 'PhoneExt' field when adding a user manually and is display on the User's Profile
Cell	This is only display on the User's Profile
HomePhone	This is only display on the User's Profile
ProfileBlurb	This is the Profile Description on the User's Profile
WebPage	This is only display on the User's Profile
Title	This is only display on the User's Profile
Facebook_Profile	This is the link to the User's Facebook Profile and it is only display on the User's Profile
Twitter_Profile	This is the link to the User's Twitter Profile and it is only display on the User's Profile
Linkedln_Profile	This is the link to the User's Linkedln Profile and it is only display on the User's Profile
Skype_Name	This is the link to the User's Teams Profile and it is only display on the User's Profile
BadgeNumber	BadgeNumber Text.
EmployeeId	EmployeeId Text.
TimeZone	TimeZone Text.
IsAllowOTPLogin	IsAllowOTPLogin Text.
IsExcludeFromStatusNotifications	IsExcludeFromStatusNotifications Text.
IsHiddenFromUsers	IsHiddenFromUsers Text.
Person ID	The internal OfficeMaps ID of the person who will be involved in the operation. This field is optional if the Username column is used.

To upload the file after you fill the 'Example Excel File' just:

1. Click on the arrow on the left top corner (on top of your username).
   

1. Click on the 'People' button. 
   

1. Click on the 'Action' button on the top bar.

1. Click on 'Add/Update From People' option.

1. Click on 'Select File' and choose the file on your computer.

Add/Upload People from Excel

In addition, the same process and template can be used to update details of users who already exist in OfficeMaps. 

Username and Email cannot be altered via Update, these are the fields used to identify the person during the process.

When performing updates, you can use restrict the columns to Username and or Email to identify the person and the additional field/s that you would like to update.

Note: If you would like to set a value for a field to be blank, use the special code {CLEAR} in the column rather than simply leaving it empty. Columns that have no value for a field will be skipped.

• Related Articles

• Adding People in the browser client

  To manually add a person to OfficeMaps: Click on the arrow on the left top corner (on top of your username). Click on the 'People' button. Click on the 'Add People' button on the top bar. Adding people to OfficeMaps A dialog will appear prompting for ...

• Update People Work Days from Excel

  OfficeMaps allows administrators to set the default Working Days for any individual to be controlled via a manually uploaded spreadsheet. To obtain the basic template for this spreadsheet on the People Tab, click Actions, Download Example Excel file ...

• Assign People to Assets From Excel

  OfficeMaps allows Permanent assignments to be controlled via a spreadsheet. To obtain the basic template for this spreadsheet on the People Tab, click Actions, Download Example Excel file to Assign People to Assets. The template has five columns: ...

• Step 3: Adding People to OfficeMaps

  There are 3 ways to add people to OfficeMaps: First: Manually via the browser interface. This allows you to edit users via the browser. Useful for adding/editing/removing small numbers of users. Users created this way are managed in OfficeMaps. ...

• Importing, Updating and Exporting People

  Exporting People A spreadsheet containing all OfficeMaps data for every user in the system is available by using the Export To Excel function. This function is available by selecting the People option from the menu and then selecting the Export ...