Export data from the experimenter

Question

question

Jason Botha asked Jun 01 2016 at 6:27 PM Ruben Mariduena commented Jul 21 2017 at 3:36 PM

Export data from the experimenter

Is there an easy way of exporting dashboard data from the experimenter in .csv format after all the replications have been run? I want to use the data for post-analysis in Qlikview.

Software Version:

FlexSim 16.0.1

experimenter user command replications csv exporting

Answer 1 · 2016-06-01T18:28:32Z

Ben Wilson answered Jun 01 2016 at 6:28 PM Ruben Mariduena commented Jul 21 2017 at 3:36 PM

FlexSim natively exporting .csv raw results from an experiment is something already on the development list to consider doing for FlexSim 2017. "Consider doing" is no guarantee, however, and it also doesn't help you today.

Attached is a sample model that includes a User Command called exportexperimentcsv(). This was created by our Canadian partner, @kris.geisberger. Hopefully this is what you're looking for.

In the model, run the experimenter, then when it finishes, hit the green arrow in the Script window to run the export.

exportexperimentcsv.fsm (76.0 KiB)

· 4

jing.c commented · Jun 02 2016 at 5:46 AM

Hi Ben, I had tried to open your model attached with FlexSim2016, but It seems failed which shows above.

The whole tools miss and It shows error when open experiment.

Could you give me any advice?

0 ·

openfailed.png (58.2 KiB)

Ben Wilson ♦♦ jing.c commented · Jun 02 2016 at 2:07 PM

Hi @jing.chen, sorry you're having troubles! Just in case there was anything wrong with the attachment, I have uploaded a new copy.

The model was built in 7.7, but will upgrade just fine to 2016.

Having just downloaded the new attachment, it opened and upgraded for 2016 without problems and runs perfectly on my computer.

If you continue to experience this issue with the new attachment, after opening the model try going to FlexSim's main menu and choose View > Open Default Workspace. Does that clear up the errors?

1 ·

jing.c Ben Wilson ♦♦ commented · Jun 04 2016 at 6:13 AM

Thank Ben, The new one works well. It really helps.

P.S. In the Description of User Command "change the confidence interval" should be Line 21 not Line 10.☺

1 ·

Ruben Mariduena commented · Jul 21 2017 at 3:36 PM

@Ben Wilson @Kris Geisberger thank you for this solution! this is exactly what I was looking for in the 2016.2 version. Do you guys know if this was developed in the 2017 Flexsim version? This is excellent because in my company we do a lot of statistical analysis with our large replications/scenarios data.

0 ·

question