Read and Write from GeoSCADA database from/to Excel sheet

[Mehdi_Sajjadi]

Hi

I wanted to fill/change/set the classes and aggregated properties used in GeoSCADA by using an Excel sheet and VBA macros. I can handle the Excel sheet side, but I am quite unaware of how I can access the GeoSCADA database to manipulate it. 

For example, I want to assign DNP3 points using an Excel sheet. I want to read the DNP3 point number from SCADA to an Excel sheet or write new ones from Excel to GeoSCADA. 

I appreciate any idea of how I can change the values of the database schema. Especially using an Excel sheet.

[SurprisedEwe1]

The "Server Automation" section under "Coding" in the Geo SCADA Help contains the information that you are after.

First you'll have to create a connection to the database server using the "ScxV6Server" class then access the objects of the database with the "ScxV6Object" or "ScxV6Objects" classes.

An example straight from the Geo SCADA Help is:

Dim Svr As ScxV6DbClient.ScxV6Server

' Connect to the server
Svr = New ScxV6DbClient.ScxV6Server
Svr.Connect("MAIN", "", "")
Dim Obj As ScxV6DbClient.ScxV6Object
Obj = Svr.FindObject("Primary Serial Modbus Channel")
Obj.Property("Retries") = 5

' Disconnect
Svr.Disconnect()

The names of the properties (and any methods or aggregates etc.) can be found in the Database Schema - e.g. to set the DNP3 point number the property is "PointNumber". Other properties could be things such as "PointDataClass", "OutstationID", "EngineeringFullScale", "RawZeroScale" etc.

Also use the schema to determine the datatype returned by and required by the database and many will be enumerations - e.g. Alarm Severities are used as enumerations where on a base database installation 1 = Low, 334 = Medium, 667 = High and 1000 = Critical

[sbeadle]

This sample spreadsheet configuration tool may be helpful - a ready-built way to drive configuration into Geo SCADA from Excel.

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Tools-amp-Samples/ba-p/279123#toc-hId--77672493...