Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Solved
Go to Solution
Link copied. Please paste this link to share this article on your social media post.
Hello, i am trying to use the SEAL program and utilise the spreadsheet binder.
The ES is version 3.2.4.22 and ASPs 3.2.3.59
I have seal logged into the ES and imported the CSV file, I am unable to upload CSV files but have pasted below the format, the SEAL program says success but no binding happens?
Can anyone help on how to use this properly and is this safe to do hundreds of bindings across multiple controllers? ( obviously would take a backup first)
| From | To |
| /AS-12/Level 12/Floor Occupancy/Values/AhuHr5OptSs/Value | /AS-L28-AHUs/BACnet Interface/Application/Floor Opt SS/AhuHr5OptSs_Level 12/Priority16 |
Accepted Solutions
Link copied. Please paste this link to share this article on your social media post.
It seems like it won't parse your rows from the sheet. Did you check the example Excel file linked in the description?
It looks like the script wants a semicolon separator, you can open your csv file in notepad (after you saved as
CSV UTF-8 Comma delimited) and check the format.
Link copied. Please paste this link to share this article on your social media post.
Hi Anthony, I tried your use-case and got it to do the bind.
Your result log 'Binding using 0 entries' indicates you might have some format issue in your csv file.
The first line in csv should be a header line 'From;To'
If you click on Details on the Script card in the Library view you got an example csv file that you may download.
I've attached my csv as a zip as well.
Also , since your script need to write to a server outside the base path (to another server), ensure you have the 'Allow operations outside the confines of the base path' checked
Link copied. Please paste this link to share this article on your social media post.
adding the execution and results view
Link copied. Please paste this link to share this article on your social media post.
It seems like it won't parse your rows from the sheet. Did you check the example Excel file linked in the description?
It looks like the script wants a semicolon separator, you can open your csv file in notepad (after you saved as
CSV UTF-8 Comma delimited) and check the format.
Link copied. Please paste this link to share this article on your social media post.
Hi Anthony, I tried your use-case and got it to do the bind.
Your result log 'Binding using 0 entries' indicates you might have some format issue in your csv file.
The first line in csv should be a header line 'From;To'
If you click on Details on the Script card in the Library view you got an example csv file that you may download.
I've attached my csv as a zip as well.
Also , since your script need to write to a server outside the base path (to another server), ensure you have the 'Allow operations outside the confines of the base path' checked
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.