question

Sachin T avatar image
0 Likes"
Sachin T asked Logan Gold commented

importtable() not working

I am using the following code in onmodelreset. but nothing is happening. There are no errors to debug. I am not sure what i am doing wrong to import fucntion. I am using 2024 update 1.


the sourcefile is getting printed correctly. importtable function is not working.

1729694476440.png


FlexSim 24.2.1
importtable
1729694476440.png (5.7 KiB)
· 2
5 |100000

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

Logan Gold avatar image Logan Gold ♦♦ commented ·
Hey @Sachin T, we've been able to get this working based on the information you've provided. Can you send us the model and CSV file so we can try to replicate it?

Otherwise, you may just need to make sure the CSV file is using the same name in your sourcefile variable as the file in the model's directory. I don't think it throws an error if there is no file with the given name.

If you saved the file in Excel, make sure it is a CSV file. I like to see if I can open the file in a text editor to see if it looks fine.

You could also try changing directories just to make sure it's not a permissions issue. Or, you could try opening FlexSim with the "Run as administrator" option to also test permissions.

0 Likes 0 ·
Logan Gold avatar image Logan Gold ♦♦ commented ·

Hi @Sachin 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 Likes 0 ·

1 Answer

Jeanette F avatar image
0 Likes"
Jeanette F answered Jeanette F edited

Hello @Sachin T,

We are not able to replicate your issue.
I am able to import a test csv file. Please see my attached zip to see how I have everything set up. Can you check that your file is a csv file (not a workbook/worksheet) and that it is in the correct location?

ATest.zip
Can you send us your csv file for us to test?


atest.zip (34.3 KiB)
5 |100000

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