Hello, Is it possible to export data collected/shown graphically in flexsim dashboard to SQL server? If yes, please share the steps to do that. Thank you.
I read this: https://answers.flexsim.com/questions/154040/is-it-possible-to-access-data-in-this-dashboard-ta.html
but I want steps to convert dashboard to statistics collectors as well.
The steps to expose the already present stats collector from a dashboard chart are to install it.
The way to export the data to a database is to use a Database.Connector and query the (now installed) StatsCollector and use the database's INSERT INTO clause (the syntax changes depending on the specific database).
This is already described in the post to which you linked.
It will be something like this (sqlite example):
Database.Connection con=Database.Connection("SQLiteConnection");
int connected=con.isConnected;
if (!connected)
connected=con.connect();
if (connected){
Database.PreparedStatement statement=con.prepareStatement("INSERT INTO StatsCollectorData VALUES(:Time,:Object,:Staytime)");
Table collector = Table("Staytime Collector");
int numrows=collector.numRows;
for (int i = 1; i <= numrows; i++) {
statement.bindParam("Time", collector[i]["Time"], Database.DataType.DateTime);
statement.bindParam("Object", StatisticsCollector.getPathFromID(collector[i]["Object"]), Database.DataType.VarChar);
statement.bindParam("Staytime", collector[i]["Staytime"], Database.DataType.Double);
statement.execute();
}
}
if (connected)
con.disconnect();
Model and db attached:
WriteStatsCollectorToSQLiteDB.fsm
18 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
