In configuration database on SCADA administrator page, to input connection data ( on Devices panel) each line represents a Device , which has a name , an address, and so on…
My question is if exists other method to input these data than line by line, because in my application , has several devices to acquire data( approx. 100). By the actual method, will take a lot of engineering time to fill these fields.
In short i’m looking for a copy / paste function with excel data.
There are a few ways:
1. Export data, then import the same data with other IDs in SCADA-Administrator.
2. Generate SQL queries, connect to ScadaBase.sdf using a tool supports Microsoft SQL Server Compact 3.5 and execute the queries.
3. For input and output channels there are the built in auto create and clone features.
This reply was modified 3 years, 5 months ago by Mikhail.
If we are talking about the xlsx you can write a driver. The data format is nothing but an archived set of xml files. And search xml a realistic goal. If this is the old format it will be more difficult.
When we complete this module, you can specify SQL request to retrieve data from a database which has any structure. We are going to support Oracle, MS SQL, PostgreSQL and MySQL. You don’t need files working with DB.