Geo SCADA Import Points

[DavidSkilbeck]

Hi,

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

Say from an excel spread sheet for example.

Thanks,

[BevanWeiss]

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.

[Jimi · Accepted solution]

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

[sbeadle]

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

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Resource-Center-Home/ba-p/279133

[geoffpatton]

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

[DavidSkilbeck]

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,

[geoffpatton]

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/

[DavidSkilbeck]

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,

[sbeadle]

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

System	Username	Password
Local	FredBloggs	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.