Difficulty: expert

Content

1 Prerequisites
2 Inquire the list of possible sensors
3 Prepare Excel

Learning Objectives

After reading this article, you’ll be able to:

Set up an excel that makes it’s really easy for the installer to provide location installation information
Use an excel sheet for batch upload of many sensors

Some projects include HUGE amounts of sensors - having the installer paste the stickers-with-sensor-ID on the sensor plan and manually taking it from there might be very time consuming.
If your project has more than (tabs) 50 or 100 sensors, you might consider using excel.

This page describes how to set up an excel that installers can use to quickly enter the (correct) device ID. At the end of an installation day, you will have an excel sheet that contains device ID and location information, allowing you to easily map multiple new devices to Studio.

Best practice is to already upload these devices in Studio, as soon as you have the file (so prior to installation), so that anyone accessing Studio:

knows how many sensors are linked to that customer,
knows how many sensors still need to be mapped/linked to a location
and, as soon as mapping is done: can immediately see how many sensors are live (for example installer partner that has access to Studio).

Prerequisites

Set up location master data in IWMS. We’ll need the location unique ID for upload in Studio, but probably the location is known to the customer with “nicer” reference. For example, a meeting room might be called “Louvre”, but unique ID in this case is 910000000007087.

Inquire the list of possible sensors

Most sensors are shipped directly from the manufacturer.

Only for Tabs sensors, your Spacewell Implementation Consultant will be able to indicate which device IDs were shipped (see https://spacewell.atlassian.net/wiki/spaces/WM/pages/212828314 ). For them to check this, please communicate box number / cartonID. This is a unique identification number per cardboard box.

There are tabs 100 sensors in 1 box, so in case your shipment does not include a multiple of 100, some IDs mentioned in the provided list might not belong to you.

There are no cartonIDs available for the US.

Prepare Excel

Start by downloading following template:

Export location master data from IWMS.
Use this location master data to fill in tab ROOMS of this file.
Leave columns "Sensor" and "OK?" as-is for now.

Provided with the CartonID, the Spacewell Implementation Consultant can check https://spacewell.atlassian.net/wiki/spaces/WM/pages/212828314 and export the valid sensor IDs.

Import relevant sensor IDs to column C "Sensor IDs" on tab SENSOR IDS of this file.
In doing so, column A "last 6 digits" will show the last 6 digits of the sensor IDs provided in column C.

Next to everything described in the sensors specific installation guides and Checklist hardware on-site visit or installation , provide the installer with

the sensor plan
an indication of location names (for example meeting room reference or workplace number)
your prepared excel sheet

Upon installation, fill in the last 6 digits of the sensor ID into column "Sensor ID" in the ROOMS tab.

If these 6 last digits are part of the available sensor list, they will appear in the column "OK?"
If these 6 last digits are not part of the available sensor list, the column "OK?" will state "NA"
If these 6 last digits are part of the available sensor list, but are already referenced somewhere in this mapping list, the column "OK?" will turn red

Get the full sensor ID from making a vlookup on the Sensor ID tab

Copy the Location IDs and the Sensor IDs into the sensor import file. See Configure devices (add, remove, import, and export) for more information on batch import.

Search

Workplace Knowledge Base (support.spacewell.com)

Prepare batch import file before installation

Analytics

Content

Learning Objectives

Prerequisites

Inquire the list of possible sensors

Prepare Excel

Related content