Introduction

You can use the Excel file to add an InfoSource to a point and set its properties.

The system creates (at least one value is needed in one of the sub columns) or updates an InfoSource.

Example

An InfoSource is created inside the component described in the row

Columns syntax

Add a colum named "InfoSource" on the first line. Then you can define those following subcolumns (none of them are mandatory)

• description: the infoSource's description
• sourceDisplayName: the infoSource's Source Display Name
• mnemonic:the infoSource's mnemonic
• notes:the infoSource's notes
• syncUp: the infoSource's advancedConfig's Sync Up
• syncDown: the infoSource's advancedConfig's Sync Down
• inherit: the infoSource's advancedConfig's Inherit
• several info subColumns
• several slot subColumns
• several action subColumns
• several link subColumns

• markers: to define all the markers tags

• several tag subColumns. value using the following format: tag:dictionary:key{Niagara TypeSpec of the slot}. Example: tag:b:myTag{baja:Double}. If no TypeSpec is given, the system will use a BString by default. Similarly to the Tag subColumns, you can set the flags during the import.

  The tag subClumn will only be able to import/export SourceTags.

  
  
  

Accepted value

• description = String value
• sourceDisplayName = String value
• mnemonic = String value
• notes = String value
• syncUp = true/false
• syncDown = true/false
• inherit = true/false
• info values
• slot values
• action values
• link values
• markers= a list of tags (dictionary:key) separated by semicolons. Example: hs:ahu;hs:hvac
• tag = the following TypeSpecs are supported:

  • baja:Marker

  • baja:String

  • baja:Integer

  • baja:Long

  • baja:Float

  • baja:Double

  • baja:Boolean

  • baja:Ord

  • baja:DynamicEnum (the cell value must be the tag, not the ordinal)

  • baja:RelTime (the value must be in seconds)

  • baja:AbsTime (the value text must strictly conform to the ISO 8601 standard format of "yyyy-mm-ddThh:mm:ss.mmm[+/-]hh:mm")

IMPORT

Simply add values to the slots you want to update.

EXPORT

If there is a value in the slot associated to a column, the slot's value will be exported to the cell.

SPECIAL CASE FOR SOURCETAGS

It's not possible to update a readOnly SourceTag. However you can replace the "tag:" prefix with the "tagReadOnly:" prefix in your subColumn (example: tagReadOnly:b:myTag(baja:Double). This prefix will allow you to export the SourceTag to Excel. On the import the SourceTag will be created if it doesn't exist or ignored if it's already there as it's a readonly SourceTag.

Try it yourself !

Here is the file used in the above import example. Download it, try importing it and see the result.

createAnInfoSource.xlsx