New type of binding script

[KevinC.232]

Hello, I was looking at the binding scripts as I thought they would be able to help my team with our Continuum conversions. The spreadsheet binder does seem to work, but in our case, it feels like it could be more convenient. Although, as this is new to me, it may not be possible. 

Essentially, what I would like to do is take

/StLukes/Infinet Interface/Infinet Network A/Boilers/Application/IntrLkHeating/Value 

and place it into any program bind with a certain input, making the "to" be like

* is wildcard

/*/*/*/*/*/xxxProgram/InputBind

Thanks,

Kevin C

[StefanLundin · Accepted solution]

Hi Kevin, 

I’ve made an adjustment to the Spreadsheet Binder to support using a wildcard(*) in the "To" path.

Note that this is a quick implementation that crawls the system to find the matching objects. While it’s not the most efficient method, I ran a quick test and it worked in my test environment —though it may take some time to complete the crawl on a large system.

Please test it and let me know if it meets your needs and perhaps we could add the support for wildcard in the official SpreadsheetBinder script later on.

Be sure to test it in an virtual environment and ensure you have a full system backup beforehand.

Example CSV file:

From;To
/Server 1/Common Signals/Digital Value/Value;*/Program/MyProgram/MyBindToProperty

This created the following bindings in my simple test :

[Log] Binding using 1 entries  
[Log] Searching for properties ending with Program/MyProgram/MyBindToProperty  
[Log] Found 6 properties matching */Program/MyProgram/MyBindToProperty  
[Log] Binding /Server 1/Common Signals/Digital Value/Value to /Server 1/App1/Program/MyProgram/MyBindToProperty  
[Log] Successfully bound /Server 1/Common Signals/Digital Value/Value to /Server 1/App1/Program/MyProgram/MyBindToProperty  
[Log] Binding /Server 1/Common Signals/Digital Value/Value to /Server 1/App2/Program/MyProgram/MyBindToProperty  
[Log] Successfully bound /Server 1/Common Signals/Digital Value/Value to /Server 1/App2/Program/MyProgram/MyBindToProperty  
[Log] Binding /Server 1/Common Signals/Digital Value/Value to /Server 1/App3/Program/MyProgram/MyBindToProperty  
[Log] Successfully bound /Server 1/Common Signals/Digital Value/Value to /Server 1/App3/Program/MyProgram/MyBindToProperty  
[Log] Binding /Server 1/Common Signals/Digital Value/Value to /Server 1/App4/Program/MyProgram/MyBindToProperty  
[Log] Successfully bound /Server 1/Common Signals/Digital Value/Value to /Server 1/App4/Program/MyProgram/MyBindToProperty  
[Log] Binding /Server 1/Common Signals/Digital Value/Value to /Server 1/App5/Program/MyProgram/MyBindToProperty  
[Log] Successfully bound /Server 1/Common Signals/Digital Value/Value to /Server 1/App5/Program/MyProgram/MyBindToProperty  
[Log] Binding /Server 1/Common Signals/Digital Value/Value to /Server 1/App6/Program/MyProgram/MyBindToProperty  
[Log] Successfully bound /Server 1/Common Signals/Digital Value/Value to /Server 1/App6/Program/MyProgram/MyBindToProperty  
[Log] End

And if watched in EBO : 

1. Unzip the attached file
2. Import to the script in the SEAL Script utility using the Import Script button
3. Find the Script in your Custom folder and test it. 

[KevinC.232]

Thank you Stefan!