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
84612members
353911posts

[Imported] Editing and distributing text call outs. alarm source

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.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
343

[Imported] Editing and distributing text call outs. alarm source

>>Message imported from previous forum - Category:Bulk Edit Tool<<
User: ROVSCADAENGINEER, originally posted: 2018-11-08 21:21:29 Id:315
We are using a system which texts operators after checking the communications status of the RTU's over an hour. the new logic needs to be deployed to all the templates and then in object folder for each site the digital points need to be tied to the new logic. the issue I am having is that for each alarm I need to change the alarm source to " folder name


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
342

Re: [Imported] Editing and distributing text call outs. alarm source

>>Responses imported from previous forum


Reply From User: geoffpatton, posted: 2018-11-09 04:03:51
The Bulk Edit tool should get the job done for this just select the groups the points are in and the point type and check the box for AlarmSource. Then Export that to an xlsx file and edit them. Finally Import the xlsx file back in.


Reply From User: ROVSCADAENGINEER, posted: 2018-11-12 00:21:50
thanks Geoff. I have never used the bulk edit tool. just looking for a link to download. this is helpful.


Reply From User: geoffpatton, posted: 2018-11-14 17:00:21
It is on the installation disk for ClearSCADA versions 2014 and up. Once you install it there is a user guide in the start menu. and if you are NOT on 2017 R2 or greater there is a startup bug, but just a click of a buttin gets you going right. https://se-scada.net/forum/discussion/144/startup-bug-with-the-property-overrides#latest


Reply From User: BevanWeiss, posted: 2019-01-03 22:56:58
This is the kind of situation where I prefer to go rogue and use QueryPad 😉
The Bulk Edit tool will be horrible for doing what you want.

What it sounds like you want is an
UPDATE AlarmSource = ParentGroupId-Name | ' Communications Down'
FROM CInternalDigital
WHERE Name = 'Comms State'

If you want further up the hierarchy you can use ParentGroupId-ParentGroupId-ParentGroupId-Name or something..

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
343

Re: [Imported] Editing and distributing text call outs. alarm source

>>Responses imported from previous forum


Reply From User: geoffpatton, posted: 2018-11-09 04:03:51
The Bulk Edit tool should get the job done for this just select the groups the points are in and the point type and check the box for AlarmSource. Then Export that to an xlsx file and edit them. Finally Import the xlsx file back in.


Reply From User: ROVSCADAENGINEER, posted: 2018-11-12 00:21:50
thanks Geoff. I have never used the bulk edit tool. just looking for a link to download. this is helpful.


Reply From User: geoffpatton, posted: 2018-11-14 17:00:21
It is on the installation disk for ClearSCADA versions 2014 and up. Once you install it there is a user guide in the start menu. and if you are NOT on 2017 R2 or greater there is a startup bug, but just a click of a buttin gets you going right. https://se-scada.net/forum/discussion/144/startup-bug-with-the-property-overrides#latest


Reply From User: BevanWeiss, posted: 2019-01-03 22:56:58
This is the kind of situation where I prefer to go rogue and use QueryPad 😉
The Bulk Edit tool will be horrible for doing what you want.

What it sounds like you want is an
UPDATE AlarmSource = ParentGroupId-Name | ' Communications Down'
FROM CInternalDigital
WHERE Name = 'Comms State'

If you want further up the hierarchy you can use ParentGroupId-ParentGroupId-ParentGroupId-Name or something..