question

Jon Abbott avatar image
0 Likes"
Jon Abbott asked Jon Abbott commented

Importing boolean values using MTEI causes error

When I import a spreadsheet that contains Boolean values in a column, it shows the following error for each TRUE entry:

After importing, the entire column of Boolean values is blank. Other than skipping this column when importing, or editing the source spreadsheet to change TRUEs to 1 and FALSEs to 0, is there a way to have FlexSim handle this kind of data without having an error? I've included an example model and spreadsheet that reproduces the error. Thanks in advance for your help.

mtei.fsm

book1.xlsx

FlexSim 20.0.0
mteiboolean
screen-shot-2020-01-16-at-11604-pm.png (6.1 KiB)
mtei.fsm (23.6 KiB)
book1.xlsx (8.7 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
zacharyh avatar image
0 Likes"
zacharyh answered Jon Abbott commented
@Jon Abbott

FlexSim does not accept boolean imports from excel. You can take a look at a similar question for more information.

https://answers.flexsim.com/questions/67946/excelimporttable-command-issue.html

· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Jon Abbott avatar image Jon Abbott commented ·

Thanks @zachary.h. Are there any plans to add support for Boolean imports? Currently, FlexSim generates a separate error dialog box for each TRUE cell that it encounters, so there are potentially thousands of error dialog boxes to dismiss when importing a large spreadsheet. The only way I could find to cancel the import once the errors started was to force close FlexSim, which could have lost data if the model wasn't saved first. For now, I have disabled importing that column... it would be useful if the error dialog boxes had an option to disable reporting future errors, and/or an option to cancel the import. Thanks again for considering my feedback, and please let me know if you have any questions.

0 Likes 0 ·
zacharyh avatar image zacharyh ♦ Jon Abbott commented ·

@Jon Abbott

I will pass your information and suggestions along to the dev team. Thank you

0 Likes 0 ·
Jon Abbott avatar image Jon Abbott zacharyh ♦ commented ·

Thanks @zachary.h

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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