export dashboard data to sql server

Question

This post has been wikified, any user with enough reputation can edit it.

question

Urvi Sukharamwala asked Jan 30 2024 at 4:45 PM Jason Lightfoot commented Feb 12 2024 at 9:21 PM

export dashboard data to sql server

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.

Software Version:

FlexSim 24.0.1

dashboards export data sql server

Answer 1 · 2024-02-05T14:16:04Z

Jason Lightfoot answered Feb 05 2024 at 2:16 PM Jason Lightfoot commented Feb 12 2024 at 9:21 PM

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.

· 2

Urvi Sukharamwala commented · Feb 05 2024 at 4:37 PM

Thank you. Can you please tell me the script for exporting the data from stats collector to database?

0 ·

Jason Lightfoot ♦♦ Urvi Sukharamwala commented · Feb 12 2024 at 9:21 PM

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

TestDB.zip

0 ·

writestatscollectortosqlitedb.fsm (630.6 KiB)

testdb.zip (983 B)

question

export dashboard data to sql server

1 Answer

Things to know…

question details

question

export dashboard data to sql server

1 Answer

Things to know…

question details

Related Questions