Add/Update People from Excel

Add/Update People from Excel

Add/Update People from Excel

To add multiple users to OfficeMaps from an Excel file, you can begin by clicking the Download Example Excel file for Add/Update People , this will download a file named PersonImportTemplate.csv , which has the current list of fields that can be set/updated. 



This table shows the OfficeMaps People fields that can be assigned and one or more corresponding text terms that must be used as column headers within Excel. If multiple column header terms are acceptable these will be separated by a comma. The import can read any combination of upper and lowercase letters.

OfficeMaps Field 
Corresponding Excel Column Headers 
 Username 
 Username, User Name 
 EmailAddress
 Email, EmailAddress, Email Address
 FirstName
 FirstName, First Name, GivenName, Given Name
 LastName 
 LastName, Last Name, Surname 
 DisplayName 
 DisplayName, Display Name 
 Initials 
 Initials 
 Position
 Position
 Phone
 Phone, Ph
 PhoneExtension
 PhoneExtension, Phone Extension, Extension, Ext
 Cell 
 Cell, CellPhone, Cell Phone, Mobile, MobilePhone, Mobile Phone 
 HomePhone 
 HomePhone, Home Phone 
 ProfileBlurb
 ProfileBlurb, Profile Blurb, Profile, Description 
 WebPage 
 WebPage, Web Page 
 Title
 Title
 Facebook_Profile 
 FacebookProfile, Facebook_Profile, Facebook 
 Twitter_Profile
 TwitterProfile, Twitter_Profile, Twitter
 GooglePlus_Profile 
 GooglePlusProfile, GooglePlus_Profile, GooglePlus, Google 
 LinkedIn_Profile 
 LinkedInProfile, LinkedIn_Profile, LinkedIn 
 Skype_Name 
 SkypeName, Skype_Name, Skype 
 TimeZone
 TimeZone

To Perform the operation, Click the Actions button, then select Add/Update People from Excel.



After selecting the option you will be prompted to select the file.



All data that is in columns recognised by the Add/Update Import from Excel process will be assigned to each new user as the user is created. A dialog will appear with information about the success of the operation.



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

    • 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: ...
    • 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 ...
    • Sync People from AD

      Please ensure the steps required have been done prior to attempting to run Ad Sync. For Azure Ad/ Office 365, Setup the Integration Provider . (including setting How are new people added). For AD (on premise) - Open the main menu and choose ...
    • Adding People

      To manually add a person to OfficeMaps, select the People option from the menu. The following screen will appear:     Enter values into the filter to restrict results to those people who match this value.   Click the Add Person button and enter ...