topic Re: Exporting Dashboards to Excel in FlexSim Forum

Exporting Dashboards to Excel

idoia_a — Tue, 02 Apr 2019 13:18:15 GMT

[ FlexSim 19.0.2 ]

Hello,

I was wondering if it is possible to export several dashboards to one Excel file. For now, I have only been able to use "Export All Dashboards to CSV option", which creates separate files. Is it possible to export the data to specific cells in a specific excel file?

Thank you in advance,

Idoia

Re: Exporting Dashboards to Excel

joshua_s — Wed, 03 Apr 2019 19:31:24 GMT

To do this you will need to go to each of the templates in your dashboards and install them. This will create a stats collector for them if you do not already have them referencing a stats collector.

Then you can go to the Excel import/export interface, and then create a new export Table for each stats collector you have. Select the same excel workbook for each of them, but set each to a different sheet. Also deselect "Use Column Headers" and then use the sampler to select each stats collector.

Re: Exporting Dashboards to Excel

idoia_a — Thu, 04 Apr 2019 12:48:16 GMT

Thanks for the explanation. Unfortunately, I have not been able to see the output of the dashboards in the Excel file. I think it has to do with the format of the stats collectors created. If I export them individually to a CSV file it works, but if I do it using the Excel import/export interface, it doesn't export them and nothing shows in the file. Any idea about what I'm doing wrong?

Thanks.

Re: Exporting Dashboards to Excel

joshua_s — Fri, 05 Apr 2019 19:15:06 GMT

Can you upload your model so I we can take a look at it and waht you want exported?

Re: Exporting Dashboards to Excel

idoia_a — Fri, 12 Apr 2019 11:23:24 GMT

Sorry for late answer, I attach an example of what I want to do. There are 3 different dashboards that need to be exported to different sheets in the excel file. I installed them into a statistic collector as explained but I haven't been able to export them to Excel.

Thank you in advance.

export-dashboards.zip

Re: Exporting Dashboards to Excel

joshua_s — Fri, 19 Apr 2019 22:11:26 GMT

@Idoia A

Sorry for the late reply. Looks like I was incorrect about my assumptions for exporting the statistics collector tables to Excel using the Import/Export tool. When I did it I used the Export Data button before using the tool so I thought I was getting correct data when in actuality it was never exporting. I notified the Development team that this should be a feature for future releases.

Till then, I wrote a script that you can execute whenever you want to while your program is running and it will export the tables. I'ts not super pretty, but it works, let me know if there is any way I can help customize it for any changes you have made to your model since you last uploaded. It uses a "Dump" table to copy all the data from the statistics collector tables, then exports the Dump table.

export-dashboards-5.fsm