Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the 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
Link copied. Please paste this link to share this article on your social media post.
for such customization, it is better to export from out of the GEO Scada.
You can develop an ASP.net C# application that be connected to the GEO Scada using ODBC and make query that loops every 15 minute
First, define ODBC connection using ODBC Data Sources tool in both version (32bit and 64 bit)
then define it in the web.config file
<connectionStrings>
<add name="ConnectionString" connectionString="Dsn=scada;uid=scada_username;pwd=user_password;LOCALTIME=True;" providerName="System.Data.Odbc"/>
</connectionStrings>
then in any web page (c# code sample)
//define odbc object
OdbcConnection conn = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
//start connection
conn.Open();
//define query string
string query = "select valueasreal, RecordTime from cdbhistoric where id=10101 and recordtime =";
DateTime time = DateTime.Now.AddDays(-15);
//loop
while(DateTime.Compare(time, DateTime.Now)<0){
query += time.toString("yyyy-MM-dd HH:mm:ss");
using (OdbcCommand com = new OdbcCommand(query , conn))
{
using (OdbcDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
DateTime tt = reader.GetDateTime(1);
double r = reader.GetDouble(0) + "";
//write date to csv
} //end while
} //end reader
} // end com
time.AddMinutes(15); //add 15 minutes interval
}// end while (time)
hope this will help
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.