New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Geo SCADA Expert Forum
Make the most of your remote operations with end-to-end solutions with Process Automation’s SCADA and Telemetry Solutions. With the challenges that remote sites present, reliable communications for remote operation, monitoring & management are vital in enhancing productivity and ensuring profitability.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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
Lieutenant JG

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
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
Lieutenant JG

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

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

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

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