Check For Import Button?

Question

question

Ankur A3 asked May 30, '22 Ankur A3 commented Jun 2, '22

Check For Import Button?

Hi Team,

I am having data in excel and importing/updating it in model using Toolbox>Excel Import/Export. Is there any way to provide import/export button on dashboard for easy interaction?

HC Version 21.1.5

Thank you!

Software Version:

FlexSim 21.0.10

hc export import button user

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 · 2022-05-30T15:57:02Z

Jason Lightfoot answered May 30, '22 Ankur A3 commented Jun 1, '22

Yes, just add this to the OnPress code:

excelmultitableimport();

· 4

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.

Ankur A3 commented · Jun 01, 2022 at 05:12 AM

Hi @Jason Lightfoot,

I am still facing issue. Can you show me in model how to do it?

TestFile.xlsx

TestImportButtonFeature.fsm

Thank you!

0 ·

Jason Lightfoot ♦♦ Ankur A3 commented · Jun 01, 2022 at 10:52 AM

Sorry - I cannot do this - we'll need someone else to help you.

0 ·

Jacob W2 ♦ commented · Jun 01, 2022 at 03:33 PM

Hi @Ankur A3,

For some reason we are unable to access your model. Can you please send it again.

0 ·

Ankur A3 Jacob W2 ♦ commented · Jun 01, 2022 at 03:44 PM

Sure. Here it is.

TestFile.xlsx TestImportButtonFeature.fsm

Thanks!

0 ·

testfile.xlsx (9.6 KiB)

testimportbuttonfeature.fsm (25.2 KiB)

Answer 2 · 2022-06-01T18:22:50Z

Jacob W2 answered Jun 1, '22 Ankur A3 commented Jun 2, '22

Hi @Ankur A3,

Here is the test model with the import and export buttons set up to work. You need to make sure that the excel Import/Export is set up before the buttons will work. You can also check the logic behind the buttons by clicking anywhere on the dashboard and making sure that the "edit mode" button is selected.

Test import button_JW.fsm

testfile.xlsx

test-import-button-jw.fsm (26.5 KiB)

testfile.xlsx (9.7 KiB)

· 1

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.

Ankur A3 commented · Jun 02, 2022 at 05:22 PM

Thank you so much! @Jacob W2

0 ·

question