SpreadsheetBinder - SEAL Script

[StefanLundin]

Purpose
The SpreadsheetBinder script automates the process of binding property paths in an EcoStruxure Building Operation (EBO) system using a CSV file. It simplifies bulk binding operations for large-scale configurations and now supports features like wildcards and list bindings.

• What the Script Does

  This script reads a CSV file to perform bindings in an EBO system.

  • CSV Input: Reads a CSV file with a header From<delimiter>To, where:

    • From specifies the source property or object path to bind from (e.g., /Server 1/Common signals/Value).
    • To specifies the target property path to bind to (e.g., /Server 1/App1/Program/MyProgram/MyBindToProperty).
      • Optionally supports wildcard in the To column (e.g., */Program/MyProgram/MyBindToProperty) to bind to all matching properties.

  • Delimiter Selection: Choose between semicolon (;), comma (,), or tab (\t) for CSV parsing.

  • Exact Path Binding: Binds the From path to the To path as specified in the CSV.

  • Wildcard Binding: Crawls the system tree to apply bindings to all matching target properties.

  • Binding Types Supported:

    • ObjectReference
    • PropertyReference
    • VariablesPropertyReference
    • MPxOutputBindingList
  
  

Typical Use Cases

• Bulk Binding for System Setup: Configure multiple property bindings in a new EBO system by preparing a CSV file with all required bindings, saving time over manual configuration.
• System Updates: Update or reconfigure bindings in bulk when modifying an existing system, such as during maintenance or expansion.
• Standardized Configurations: Use a CSV file to apply consistent bindings across multiple devices or applications in an EBO environment.
• Wildcard Operations: Quickly bind properties across multiple programs or folders using wildcard patterns.
  
  

Important Note About Lists

When binding to List-type properties such as MPxOutputBindingList (used by BACnet Producer objects), the script:

• Creates a list and assigns the binding to index 0 (List[0]).
• Overwrites any existing binding in that position.
• Does not append additional bindings.

Safety first

• Back up your system before bulk updates.

Availability

• The script is available in SEAL Script → Standard Scripts.

[StefanLundin]

Update Notice
Version 1.6.0 of the Standard Script for SpreadsheetBinder has been released and the original post has been updated.

What’s New in This Version

• Wildcard Support: The To column can include wildcards (e.g., */path/to/property) to bind the source property to all matching target properties.
• List Binding Support: Handles MPx/RPx list properties. Thanks goes to @JohnnyCarlsen 
• Custom Delimiter Selection: Choose between semicolon (;), comma (,), or tab (\t) for CSV parsing.

Ping @JohnnyCarlsen , @Adam_Tri-M , @AV27 , @KevinC.232 

[KevinC.232]

Hey Stefan, I have been trying to create a new post about a script I developed using wildcards, but I've been unable to, due to the current forum issues. I see one thing that could be improved, as I did in my script, my implementation may not be perfect, but it may help you get closer to a better solution. Essentially, it filters out most items when scrolling through the tree by matching the first three characters of the object. Feedback on my script would also be great if you see anything you would do better/differently. Either way, hopefully it gives you and your team some ideas, possibly.