Versions Compared

Version Old Version 34 New Version 35
Changes made by

Julie Isebaert

Julie Isebaert

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Difficulty: expert

Content

Table of Contents
minLevel1
maxLevel1

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 add map multiple new devices to Studio.

Tip

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.

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 Tabs Browan hardware inventory files (SW internal)). For them to check this, please communicate box number / cartonID. This is a unique identification number per cardboard box.

Note

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:

View file
nameSensor mapping template.xlsx

Expand
title1. Prepare Location Master data

  1. Export location master data from IWMS.

  2. Use this location master data to fill in tab ROOMS of this file.

  3. Leave columns "Sensor" and "OK?" as-is for now.

Info

Make sure to include any data that is relevant for the installation team (for example location ID and location references, building and floor references, classification of the room etc)

Expand
title2. Inquire relevant Sensor IDs

Provided with the CartonID, the Spacewell Implementation Consultant can check Tabs Browan hardware inventory files (SW internal) and export the valid sensor IDs.

  1. Import relevant sensor IDs to column C "Sensor IDs" on tab SENSOR IDS of this file.

  2. In doing so, column A "last 4 digits" will show the last 4 digits of the sensor IDs provided in column C.

Expand
title3. Map Sensor ID with location to get immediate feedback if possible ID

Next to everything described in the sensors specific installation guides and Checklist for hardware on-site visit/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

Info

Check for the correct Device ID.

  • A sensor might list more information than needed. Check the Install & Configure Gateways & Sensors pages to know which format the sensor ID should resemble.

  • A Sensor ID might have a different format than what is required in Studio. Check the Install & Configure Gateways & Sensors pages to know how to modify the sensor ID.

  • Verify for typos, eg Tabs motion sensor ID is in HEX, so only 0-9; A-F characters are used. All letters are in CAPS.

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

  • If these 4 last digits are part of the available sensor list, they will appear in the column "OK?"

  • If these 4 last digits are not part of the available sensor list, the column "OK?" will state "NA"

  • If these 4 last digits are part of the available sensor list, but are already referenced somewhere in this mapping list, the column "OK?" will turn red

Expand
title4. Get the full sensor ID

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

Expand
title5. Import in Workplace back-end Studio

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

Search

Live Search