Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84650members
353990posts

Geo SCADA Import Points

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
DavidSkilbeck
Lt. Commander
Lt. Commander
0 Likes
8
2977

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,


Accepted Solutions
Jimi
Commander Commander
Commander
3
2970

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

See Answer In Context

8 Replies 8
BevanWeiss
Spock
Spock
0 Likes
1
2975

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..
Jimi
Commander Commander
Commander
3
2971

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
sbeadle
Janeway Janeway
Janeway
2
2964

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

 

geoffpatton
Commander
Commander
0 Likes
0
2945

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.

DavidSkilbeck
Lt. Commander
Lt. Commander
0 Likes
1
2887

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

geoffpatton
Commander
Commander
0 Likes
1
2878

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/

DavidSkilbeck
Lt. Commander
Lt. Commander
0 Likes
0
2860

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,

sbeadle
Janeway Janeway
Janeway
0 Likes
0
2817

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.