41256members
184131posts

Geo SCADA Import Points

Highlighted

Geo SCADA Import Points

Hi,

Is there a way of importing a list of points into ClearSCADA?

Say from an excel spread sheet for example.

 

Thanks,

8 REPLIES 8
Highlighted
Commander

Re: Geo SCADA Import Points

There's a number of options here.

 

1. Import points via SDE, this allows you to get points into the database, but they must have been created in another database.  It also allows for easily getting in other object types like mimics etc etc.

2. Bulk Edit Tool.  This is a Schneider supplied tool which is available on the installation media provided with GeoSCADA Export (or ClearSCADA).  I would recommend you start here to see if it would suit your requirements.

4. It is possible to create objects via the Query Process, and 'Inserting Rows'. There are some challenges to getting all the required elements included in your INSERT statement however.

5. You can use the .NET API or the Automation Interface.  The Automation Interface is typically used by SIs in some VBA backing an Excel Spreadsheet allowing for rapid creation / modification of points.  However the development and use of these spreadsheets is a bit of ingrained Intellectual Property associated with SI businesses, so you'll largely have to develop your own.


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..
Highlighted
Lieutenant

Re: Geo SCADA Import Points

Hi David, 

I have a "unofficial" working example using some VB script embedded in an excel sheet, the VB will create the folder structure, object & configuration values. If you'd like a copy with an explanation on how to use it pop me an email & I'll send it to you. 

 

jeroen.alewijnse@se.com

Global Training Manager
SCADA & Telemetry
Highlighted
Sisko

Re: Geo SCADA Import Points

There is also a ready-made Excel tool on the Telemetry Resource Center:

https://tprojects.schneider-electric.com/telemetry/pages/viewpage.action?pageId=40535951

 

Highlighted
Ensign

Re: Geo SCADA Import Points

The Bulk Edit tool does not create points, it just lets you quickly edit parameters and property overrides of existing objects.

Highlighted

Re: Geo SCADA Import Points

Hi, we have tried to use the excel tool downloaded from the website. However, we have had little success. Are there any instructions for this tool please?

Thanks,

Screenshot.png

Highlighted
Ensign

Re: Geo SCADA Import Points

There is also this tool that elfstyle made. Not sure he has a user in this forum but he was active in the original one.

Maybe you'll find more success with his implementation.

 

https://sourceforge.net/projects/instancecreator/

Highlighted

Re: Geo SCADA Import Points

Hi, in order to use the import tool what set up is needed in GeoSCADA.
As we get "Cannot connect to database, check system name, user and password." when we attempt to import.

Is there any documentation any where as to setting this up please?

 

Thanks,

Highlighted
Sisko

Re: Geo SCADA Import Points

The CSImport spreadsheet needs the correct system name (defined in your Configure Connections tool) and a username/password of a real user.

See in row 1/2 columns B to D

SystemUsernamePassword
LocalFredBloggs

rafdsafdsaf

 

 

Note that column A of the main table is a command, e.g. Create or Update. See the page 'Example' which shows what you put in the other columns. (The descriptions in bold are ignored as there's no command on those rows).

The 'Update' command is a series of fieldname and value pairs.

To get field names, use the schema browser (localhost/schema) or click the fields on object forms in ViewX.