Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange 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
84548members
353802posts

Bulk Edit Tool Create Instances

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

justinoj
Ensign
Ensign
0 Likes
4
642

Bulk Edit Tool Create Instances

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

4 Replies 4
tkswathik
Lieutenant JG
Lieutenant JG

Re: Bulk Edit Tool Create Instances

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
Ensign Ensign
Ensign

Re: Bulk Edit Tool Create Instances

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.exchange.se.com/t5/Geo-SCADA-Knowledge-Base/Tools-amp-Samples/ba-p/279123/jump-to/...

 

du5tin
Lieutenant
Lieutenant

Re: Bulk Edit Tool Create Instances

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
Janeway Janeway
Janeway

Re: Bulk Edit Tool Create Instances

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)