question

lucas-t asked Feb 09 2023 at 9:14 PM Jeanette F commented Feb 22 2023 at 6:28 PM

Import lines from an excel file according to the model runtime

I have a very large excel file, and FlexSim crashes when trying to import it all at once, even after doing data cleaning and separating it into 12 different files. So, I would like to import it into FlexSim as needed by the model, for example, every 1 hour of running the model, 10000 rows are imported. I started using FlexSim recently, and I don't know if the best way to solve this problem is with FlexScript in the 'Custom Code' option, or if I should integrate my FlexSim with FlexSimPy. Could someone help me?

Software Version:

FlexSim 23.0.3

· 4

Jordan Johnson ♦♦ commented · Feb 09 2023 at 9:29 PM

I don't know that there is a limit on the size of Excel file. How big is the file? Also, what is the "Data Distinction" method set to? The best mode for large files is Values Only (very fast). Does that mode still crash for you?

0 ·

lucas-t Jordan Johnson ♦♦ commented · Feb 16 2023 at 8:33 PM

Thank you for the answer, and I’m sorry for being late. My Excel File has 1656243 lines, and with the “Values Only” mode all the lines are imported, but after the FlexSim model crashes in the same way, and I can’t move the objects in the model. I would like to know how to use the ‘excelmultitableimport()’ or another function that allow me to import lines according to the model runtime. For example, it would be interesting if the model read a limited amount of rows and then run the simulation, and after that read another amount of rows and run the simulation, and so on until all rows are read. As I said before, I am new to FlexSim, and an example using FlexScript would help me a lot. Thank you very much!

0 ·

Jason Lightfoot ♦♦ lucas-t commented · Feb 17 2023 at 6:55 AM

Can you post the excel file? It would be good to know why it crashes.

Have you tried making the table a bundle type? It will use less memory and be faster to access.

0 ·

Jeanette F ♦♦ commented · Feb 22 2023 at 6:28 PM

Hi @lucas-t,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

question

Import lines from an excel file according to the model runtime

0 Answers

Things to know…

question details

Cookie preferences

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

Are you sure you want a less customized experience?

Your experience. Your choice.

question

Import lines from an excel file according to the model runtime

0 Answers

Things to know…

question details

Related Questions

Cookie preferences

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

THIRD PARTY SERVICES

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

Are you sure you want a less customized experience?

Your experience. Your choice.