Is it possible to do excel import in start of replication in experimenter

Question

question

Patrick Zweekhorst asked Dec 6, '19 Matthew Gillespie edited Dec 6, '19

Is it possible to do excel import in start of replication in experimenter

Hi,

We have a customer that wants only 1 variable in its experimenter.
This variable will be the name of an excel sheet that needs to be imported.
I have set the excel import such that it will look at the correct table.

The problem now is that the file is not imported, and I get some exceptions in the system console of the replication.

exception: Exception Caught in ExcelAuto::updateProgress(string status, double value) object: /Tools/ExcelAuto
exception: Exception Caught in ExcelAuto::importTables(int onreset) object: /Tools/ExcelAuto
exception: Exception Caught in ExcelAuto::doImport() object: /Tools/ExcelAuto
exception: Exception Caught in ObjectFunction99__project_exec_commandlist_excelmultitableimport_node object: MAIN:/project/exec/commandlist/excelmultitableimport/node i: MAIN:/project/exec/commandlist/excelmultitableimport/node class: MAIN:/project/exec/commandlist/excelmultitableimport/node
exception: Exception caught in TreeNode::callMemberFunction() c++/dll execution. Throwing... MAIN:/project/exec/commandlist/excelmultitableimport/node c: MAIN:/project/exec/commandlist/excelmultitableimport/node i: MAIN:/project/exec/commandlist/excelmultitableimport/node thisClass: MAIN:/project/exec/commandlist/excelmultitableimport/node
exception: Exception caught in evaluation of MAIN:/project/exec/commandlist/excelmultitableimport/node

I think the problem is related to the fact that the view tree does not exists in the experimenter.
Is it possible to use the excelmultitableimport command in the start of experiment trigger?
Or are there other suggestions?

Thank you for your time,
Patrick

Software Version:

FlexSim 19.0.7

experimenter excel import excel replications start replication trigger

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2019-12-06T22:40:27Z

Jordan Johnson answered Dec 6, '19 Matthew Gillespie edited Dec 6, '19

Our connection to excel is only single threaded, so multiple replications of excel can't access a workbook at the same time. Most customers import all the necessary tables before beginning the experiment, and switch based on the current replication number. You could also consider using a database. Most databases are designed to have many readers/writers, so importing during an experiment is very doable.

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question