topic Re: How to export data to a SQL Database on Model Stop in FlexSim Forum

How to export data to a SQL Database on Model Stop

abhishek_k — Fri, 26 Apr 2019 21:22:03 GMT

[ FlexSim 18.1.2 ]

Hello,

I have built a model in which I want to pull input data from a SQL database using a Database Connector, and then export the output to a table in that same SQL database. I am using Flexsim 18.1.

The question I have is - How to automatically export the data on model stop ?

I will be using windows task scheduler to run the model everyday at a specific time and on model open and reset, I'll refresh the input data. Then, the model will run for a specified time and "on model stop" , I want to write the result to the SQL database.

There is a provision to import data on model reset from the SQL database, but I dont know how to export the data based on the on model stop trigger.

data-export.png

Re: How to export data to a SQL Database on Model Stop

SimFlex_support — Fri, 26 Apr 2019 21:37:15 GMT

@Abhishek K

Have you ever used 'On Run Stop' trigger in the "ToolBox>Modeling Logic>Model Trigger>On Run Stop" option menu?

Re: How to export data to a SQL Database on Model Stop

abhishek_k — Fri, 26 Apr 2019 21:57:23 GMT

Thank you for the response, I have used it, but I dont know the scipt that is needed there to export data into a SQL database

Re: How to export data to a SQL Database on Model Stop

abhishek_k — Fri, 26 Apr 2019 22:47:30 GMT

I tried to toggle the export node as flexscript and then used nodefuntion() to execute it but that is not working either

Re: How to export data to a SQL Database on Model Stop

benjamin_w2 — Wed, 26 Jun 2019 16:38:49 GMT

Hi @Abhishek K,

The following code should help. make sure to correctly configure your Data Base Connector.

Also note, the "On Model Stop" trigger may not be the best place to use this code, since it will fire every time you hit the stop button. Consider designing a user event in the Toolbox or using Process Flow to export your data at a certain time.

function_s(model().find("Tools/DatabaseConnectors/DBConnector1"), "exportAll");

Re: How to export data to a SQL Database on Model Stop

benjamin_w2 — Wed, 10 Jul 2019 21:09:20 GMT

Hey @Abhishek K, was my answer helpful for you? If so, could you accept it? Otherwise, how else can I help?

Re: How to export data to a SQL Database on Model Stop

rafael_o9 — Mon, 30 May 2022 08:30:27 GMT

What if I only want to export the last row? and not all the rows...?

Re: How to export data to a SQL Database on Model Stop

jason_lightfoot_adsk — Mon, 30 May 2022 08:50:38 GMT

You should ask a new question but it sounds like you need need to add a single row to a table - you could use SQL's "INSERT INTO" for that.