Importing Excel on Reset & Running Model Automatically (Silently) Not working.

Question

question

Suraj J asked Nov 2, '18 Suraj J commented Nov 15, '18

Importing Excel on Reset & Running Model Automatically (Silently) Not working.

Using the .zip file provide by @Ben Wilson on this Post, I have updated the model to import the process times from excel. I have setup data import from excel and it works fine unless I use Import Table on Model Reset. If this is unchecked, the model runs fine and results are written. The simulation does not go through if this option is checked. Considering that we would like the latest values to be used in simulation, how would one proceed in this situation? I am attaching the updated zip file here.flexsim-remote.zip

Software Version:

FlexSim 18.1.2

excel import excel command line command line interface

2018-11-02-17-25-07-flexsim-2018-testfsm.png (51.5 KiB)

flexsim-remote.zip (69.0 KiB)

· 7

Kari Payton commented · Nov 13, 2018 at 07:02 PM

Hi @Suraj J have you double checked that the excel workbook address is correct? It should read something like C:saved location. For example I saved your file in my downloads so it looks like this.

It's working for me on reset.

1 ·

excelinterfface.jpg (79.6 KiB)

Suraj J Kari Payton commented · Nov 14, 2018 at 05:30 AM

The path is correct as the file is saved at same location as the model. I am able to import the data. The reset import will also work if you are accessing it directly through GUI.

0 ·

Suraj J commented · Nov 02, 2018 at 12:24 PM

PS. Tried excelmultitableimport() on modelreset within model. Now the results are generated but for the old values. The values in global table are not updated.

0 ·

Suraj J commented · Nov 13, 2018 at 05:49 AM

@Ben Wilson I think this question has gone unnoticed. Could you please reply or refer the correct person to get in contact?

0 ·

Kari Payton commented · Nov 13, 2018 at 07:05 PM

also the model is stopping because there is a "stop" on the code for the process cycle time. If you click the yellow triangle, the red circle around it will disappear.

Now the model will run without stopping. @Suraj J

0 ·

stop.jpg (59.7 KiB)

Suraj J Kari Payton commented · Nov 13, 2018 at 07:22 PM

I think the model does not stop for the debug stop when running in background.

Your replies are helpful, but the issue I am facing is the results are not updated even when I change the values in excel file.
Let me apply your suggestions and I will confirm this tomorrow when I get back to office.

0 ·

Suraj J Kari Payton commented · Nov 14, 2018 at 05:11 AM

The model is not completing its run after removing the stop and enabling import on reset.
This is what I do,

Run the model in background (.bat) . Check results after run.
Change the process time in Spreadsheet and save it. Run the .bat file.
Model run stops.

If you open the model once, it will import the data on reset. Then the results will be generated if you run the bat file. After that, if the values are updated in the spreadsheet and the bat file is executed, the model run won't complete. The values are imported if they change in the spreadsheet, so the model would produce results until you change the values in the spreadsheet.

I think this stoppage has to do with the import window which shows the progress very briefly.

0 ·

2018-11-14-10-42-36-flexsim-2018-testfsm.png (57.1 KiB)

Answer 1 · 2018-11-14T20:45:17Z

Joshua S answered Nov 14, '18 Suraj J commented Nov 15, '18

Try this, it worked for me, don't know fully why. Toggle Import Table on Model Reset on, then add excelmultitableimport(); to the top line of your script file.

· 1

Suraj J commented · Nov 15, 2018 at 10:28 AM

It works! Thank You!

0 ·

question