- This topic has 11 replies, 5 voices, and was last updated 5 years, 7 months ago by
.
-
Posts
-
Is there any other way to input data into software interface? Or edit the DAT files in other software to input large amount of data? The actual method is very annoying and slow!
Tks.Hi,
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.Tks.
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.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.
Hi,
In this year it’s planned to develop a module that will receive data from a 3rd party database as input. As for me, Excel is not a good data source because it is not stable.Hi Mikhail,
Excel is not a good data source, so what is your suggested format file if want to receive data from the 3rd party database?
Hi Manjey73,
Thank you for your information. I will try it.
Jeff
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.
- You must be logged in to reply to this topic.