Update People Work Days from Excel

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 for Update People Work Days.



The template has fifteen columns:
Person - the username or email address of the person who will be involved in the operation.
This Week days (7) - Sunday to Saturday followed by "TW" to denote "This Week".
Next Week days(7) - Sunday to Saturday followed by "NW" to denote "Next Week".

For each day, enter a single letter value to set the Working Days for that day. The possible values are:
O: Working From Office
R: Working Remotely
N: Non-Work Day

If the day is left blank then the existing value will not be overwritten.

To apply the Work Days in the completed spreadsheet to your users, choose the option Update People Work Days From Excel and select the file you have created.

    • Related Articles

    • 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 ...
    • 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: ...
    • Step 2: Configuring People

      People details should be configured before adding or importing users into OfficeMaps. People in an organisation can be configured to have a set of default work days which is accessible by using the menu option Preferences -> People. Every user has ...
    • 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 ...