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.
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
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.
12 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
