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
84610members
353909posts

Geo SCADA Bulk Location Configuration

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
Cbhasin
Ensign
Ensign
0 Likes
14
2846

Geo SCADA Bulk Location Configuration

Is there a way to bulk configure the location property of points to "Static" (About a thousand points). I tried using the Bulk Editor, but it can only be a boolean. I tried setting it to True, but it didn't help either. Maybe there is an Aggregate I should look into and write a script? What would be the recommended way?

Thank you!


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
2783

Re: Geo SCADA Bulk Location Configuration

Hi @BevanWeiss . Yes, I think so. At the time it was created I am not sure that aggregates with multiple child choices existed or were commonly needed to be edited, so the Bulk Editor did not need to support it. This should be asked of the support team.

Thanks.

Steve

See Answer In Context

14 Replies 14
Hardin4019
Lieutenant
Lieutenant
0 Likes
3
2829

Re: Geo SCADA Bulk Location Configuration

To the best of my knowledge the location of a point is "Inherited" from the Parent Group, and if that parent Group has its location "Inherited" it could come from as far up the DB Tree as the Root. So I would think the easy way is to make sure that all of the points and groups have the location set to inherited down to a specific group containing your ~1000 points, then change that group to "Static" and enter the new location information. Then all of the points within that group should be good.

geoffpatton
Commander
Commander
0 Likes
3
2828

Re: Geo SCADA Bulk Location Configuration

Looks like it is a bug in the Bulk Edit tool. You should report it to your local Schneider support team.

 

Since the Bulk Edit does not work I would change it using SQL the value to update that property to, will be a 1.

 

There are 4 options to set for the source and their numeric values are 0-3, Static is the second one so it is 1.

 

Cbhasin
Ensign
Ensign
0 Likes
2
2812

Re: Geo SCADA Bulk Location Configuration

@Hardin4019  Changing the Location Config of the group didn't change that of the points under it.

 

Cbhasin
Ensign
Ensign
0 Likes
2
2810

Re: Geo SCADA Bulk Location Configuration

SQL is giving me the same error: "expects type Boolean, but 1 is Integer" 

BevanWeiss
Spock
Spock
1
2809

Re: Geo SCADA Bulk Location Configuration

Nor should it 🙂

 

If the child items are set to 'Inherited' for the GeoLocationSource property then they will have the GeoLocationLatitude and GeoLocationLongitude of their parent group.

 

Depending on how you intend on using the Geo Location configuration will determine if this works for you or doesn't.

 

My recommendation is to have the GeoLocationSource defined as 'Static' or 'Dynamic' as high up the tree as makes sense for your application.  I would normally NOT consider this to be at a point level.  Since points would normally be associated with a group which represents a device, or a group of such devices which represent a site.

I don't see significant benefit in having GeoLocation tagged for 'Fault', when it could instead be tagged for 'Pump 1', or for 'SPS234 - Martin Ave'.

 

When you do a query, the GeoLocationSource = 'True' appears to be for anything except for 'Inherited' / 'None'.

Which is normally ideal, as long as you have it only set to 'Static' / 'Dynamic' at sensible locations.

 

Having a dozen stacked map symbols for Running, Fault, Manual, Auto, Current, No Flow, Duty all because you have set each of these pump point as 'Static' is bad... mmmkkaaayy...

Having a single item which represents the Pump location 'may' be better... (I would perhaps do this in a lagoon system, or a large treatment plant).. for sites like SPSs where the pumps and well are naturally so close together, then I would ONLY have 'Static' set at the site group, and all items beneath it will 'Inherit' this location.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
BevanWeiss
Spock
Spock
0 Likes
1
2808

Re: Geo SCADA Bulk Location Configuration

Can you include your full SQL query?


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
Cbhasin
Ensign
Ensign
0 Likes
0
2803

Re: Geo SCADA Bulk Location Configuration

I agree. I think I should have explained it better. I need to set the Location for 1000 different sites (not points, I was just using points as a proof of concept for now). I need to change the GeoLocationSource Property to Static for all of them. Would you please be able to recommend a way to do that?

Cheers

Cbhasin
Ensign
Ensign
0 Likes
5
2797

Re: Geo SCADA Bulk Location Configuration

@BevanWeiss  @geoffpatton  @Hardin4019 I was able to Set the Location Source to Static using the Automation Interface (VB):

I am assuming that I had written the query wrong.

 

Obj = Svr.FindObject("Example Projects.New Analog Point")
Aggr = Obj.Aggregate("GISLocationSource")
Aggr.Enable = True

 

Thank you!

BevanWeiss
Spock
Spock
0 Likes
4
2793

Re: Geo SCADA Bulk Location Configuration

On the SQL front, I don't believe you had.

I think this may indeed be a bug, although it's been a while since I played around with SQL and aggregates also, so perhaps I'm also doing it wrong.

 

It would be worth you reporting it to Tech Support.  There's potentially two situations:

a) We're all doing the query wrong, in which case great.  It's just the documentation situation that needs to be improved.

b) There is a valid bug. In which case the bug should be fixed, and the documentation situation should be improved.

 

 

Regards,


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
Cbhasin
Ensign
Ensign
0 Likes
0
2792

Re: Geo SCADA Bulk Location Configuration

Update CDBObject SET GISLocationSource = 1 WHERE Id =(SELECT Id FROM CDBObject WHERE FullName LIKE 'Example Projects.Internal.Bla.Bla point)


*** Prepare failed - Query error. ***
*** Column GISLOCATIONSOURCE expects type Boolean, but 1 is Integer.

Cannot write to column 'GISLocationSource'. ***

Cbhasin
Ensign
Ensign
0 Likes
3
2791

Re: Geo SCADA Bulk Location Configuration

Will let Support know. 🙂

sbeadle
Janeway Janeway
Janeway
2
2787

Re: Geo SCADA Bulk Location Configuration

The answer is:

c) There is no interface to create aggregates or switch between them from SQL. You may request this feature through support.

 

BevanWeiss
Spock
Spock
0 Likes
1
2785

Re: Geo SCADA Bulk Location Configuration

@sbeadle Is it expected that the Bulk Edit Tool should have been capable of this kind of functionality?

 

Maybe it's a double request situation.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
sbeadle
Janeway Janeway
Janeway
0 Likes
0
2784

Re: Geo SCADA Bulk Location Configuration

Hi @BevanWeiss . Yes, I think so. At the time it was created I am not sure that aggregates with multiple child choices existed or were commonly needed to be edited, so the Bulk Editor did not need to support it. This should be asked of the support team.

Thanks.

Steve