Bulk Edit Tool Create Instances

[justinoj]

Can we use Bulk edit tool to create new instances in Clear SCADA 2017 R3 version?

[tkswathik]

No. You cannot add anything into the ClearSCADA database using Bulk edit tool. It is only useful to make configuration updates to the points that already exist. From what I have seen it uses the FullName column to search the object and make updates to the properties as depicted in the columns (after the "Name" column). If you try to add something that doesn't exist it will throw an error something in the lines of "FullName not found or something"

You might want to use the APIs available in ClearSCADA to create multiple instances

[Adrian_Lee]

Nothing in the Bulk Edit Tool for creating objects I believe, but there is a Spreadsheet-based Configuration Import Tool on the Geo SCADA Knowledge Base which should be able to create objects.

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Tools-amp-Samples/ba-p/279123/jump-to/first-unr...

[du5tin]

We use the VBA Automation Interface to create instances and objects. Our team has coded several internal tools to handle this and the examples on the resource center are a great start! 

Another way to go is to use mimic scripting. This can sometimes be easier, faster, and more robust. Just depends on the use case and what you are trying to do. We've done things like create a script that takes a list of instances pasted into a form text box (one name per line) and builds them in a pre-defined folder. Just to spark your imagination a little. 🙂 

[sbeadle]

The Spreadsheet tool above has a simple way to instance templates. See the sheet Example inside the work book.

The Script just executes these methods:

Dim SCX As New ScxV6Server

...

SCX.Connect SCXSystem, SCXUserName, SCXPassword

...

Status = InstanceTemplate(SCX, ParentName, ItemName, TemplateName)