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 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 ...
    • 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 ...
    • 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 ...
    • 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 ...