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
Is there a way of importing a list of points into ClearSCADA?
Say from an excel spread sheet for example.
Solved! Go to Solution.
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.
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.
There is also a ready-made Excel tool on the Telemetry Resource Center:
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?
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?
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.
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
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.