/
Creating a Point Conversion
Document toolboxDocument toolbox

Creating a Point Conversion

Owned by Documentation Reviewer
Last updated: Jan 29, 2024 by Kimberly Onnen

With the ability to auto-template events, your objects' data types must be numeric. Creating a point conversion provides you with this ability. In the screenshot example at the end of this paragraph, if an object has a database type of TEXT with the acceptable value of Occupied, you can convert this to a numeric value to represent "Occupied".  

  1. In Connect, choose the Configuration Explorer icon.
  2. On the left pane, expand the Agents tree on the left pane and choose the device.

  3. On the right pane, right-click on the object, and then choose Properties. 

  4. On the General Settings tab, choose the Conversion drop-down, choose Custom, and then choose Edit. 

  5. In the Conversion Editor, choose the Case Builder button. 

  6. Choose Add. 

  7. In the Edit Expression window, double-click val on the Stored Objects tab within the window to add this to the expression window.
  8. Choose the LIKE button to add to the expression.

  9. Choose the VAL button. In the pop-up window, enter Occupied.  

    The text must match the word exactly as returned by the point being converted, including case. For example, true or True.

  10. Choose the Result tab on the left. 

  11. Choose the VAL button and enter 1.
  12. Choose OK in the pop-up window.
  13. Verify the expression is 1 and then choose OK.

  14. In the Case Builder window, enter 0 for the Default Value.

  15. Verify the Case Expression is CASE WHEN {val} LIKE 'true' THEN 1 ELSE 0 END. Note that you can highlight and copy then paste the text in any text editor to use for Point Conversions for other objects with the same variables.
  16. Choose OK.
  17. Repeat this process for each of the objects that have a Text data type and will be used in Templated Analytics. These are typically Occupancy, Heat Cool Mode, and some Heating or Cooling Outputs.
  18. If the object text is different, for example True as compared to true, then the text must be edited. The expression would be CASE WHEN {val} LIKE 'True' then 1 ELSE 0 END.
  19. Other sample expressions may be:
    CASE WHEN {val} LIKE 'Occupied' THEN 1 ELSE 0 END
    CASE WHEN {val} LIKE 'occupied' THEN 1 ELSE 0 END
    CASE WHEN {val} LIKE 'Heat' THEN 1 ELSE 0 END
    CASE WHEN {val} LIKE 'heat' THEN 1 ELSE 0 END