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.
| 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 (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 Browan hardware inventory files (SW internal)) /wiki/spaces/WM/pages/212828314 ). 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. |
| Warning |
|---|
There are no cartonIDs available for the US. |
Prepare Excel
Start by downloading following template:
| View file |
|---|
| name | Sensor mapping template.xlsx |
|---|
|
| Expand |
|---|
| title | 1. Prepare Location Master data |
|---|
|
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.
| 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 |
|---|
| title | 2. Inquire relevant Sensor IDs |
|---|
|
Provided with the CartonID, the Spacewell Implementation Consultant can check Browan hardware inventory files (SW internal) /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 4 6 digits" will show the last 4 6 digits of the sensor IDs provided in column C.
|
| Expand |
|---|
| title | 3. Map Sensor ID with location to get immediate feedback if possible ID |
|---|
|
Next to everything described in the sensors specific installation guides and Checklist hardware on-site visit/installation , provide the installer with | 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 . For example 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 6 digits of the sensor ID into column "Sensor ID" in the ROOMS tab. If these 4 6 last digits are part of the available sensor list, they will appear in the column "OK?" If these 4 6 last digits are not part of the available sensor list, the column "OK?" will state "NA" If these 4 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
|
| Expand |
|---|
| title | 4. Get the full sensor ID |
|---|
|
Get the full sensor ID from making a vlookup on the Sensor ID tab |
Search