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:
- Click on the arrow on the left top corner (on top of your username).
- Click on the 'People' button.
- Click on the 'Action' button on the top bar.
- Click on 'Download Example Excel File Add/Update People' option.
Downloading Example Excel FileThe 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_Profile | This is the link to the User's Teams Profile and it is only display on the User's Profile |
To upload the file after you fill the 'Example Excel File' just:
- Click on the arrow on the left top corner (on top of your username).
- Click on the 'People' button.
- Click on the 'Action' button on the top bar.
- Click on 'Add/Update From People' option.
- Click on 'Select File' and choose the file on your computer.
Add/Upload People from ExcelIn 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
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 three columns: ...
How To: View the map for a future date in the browser client
View the map for a future date in the browser client There are 2 methods to view the map for a future date: First method: Click on the reserve button on the top bar. Use the calendar icon to select a day you want to check if a desk is available. It ...
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 ...