topic Re: Why the import doesn't work correctly ? in FlexSim Forum

Why the import doesn't work correctly ?

nicolas_membrezSQWTQ — Wed, 09 Jul 2025 12:33:32 GMT

Hi, I'm would like to import a csv table in a global table by code. The current result is a global table with one colomn. The result should be a GT with several column.

How can I correct it ?

Thanks

By the way, how can we make privates questions ?

Re: Why the import doesn't work correctly ?

kavika_faleumu — Thu, 21 Aug 2025 20:51:31 GMT

Hey @nicolas_membrezSQWTQ, I tried running the script you made, and it seems to work for me. I got a table with the correct number of rows and columns.

Have you tried running it again recently?

Re: Why the import doesn't work correctly ?

moehlmann_fe — Fri, 22 Aug 2025 06:27:06 GMT

Could be an issue with the OS language setting. If commas are used as decimal delimiters in the set language then the expected delimiter between values in the csv would become semi-colons. Though if the file opens correctly in Excel it should also be imported correctly into FlexSim.

Re: Why the import doesn't work correctly ?

kavika_faleumu — Fri, 22 Aug 2025 06:37:04 GMT

That is a possibility. I can investigate further with that hypothesis. Thank you for your insite!

Re: Why the import doesn't work correctly ?

kavika_faleumu — Tue, 26 Aug 2025 16:09:14 GMT

I was able to confirm that this is due to regional settings. For example, when in set my OS's country and regional formatting to Spain, the import doesn't work properly.

I'll add this to the dev list as a bug.

Re: Why the import doesn't work correctly ?

kavika_faleumu — Wed, 27 Aug 2025 16:21:26 GMT

According to the docs of the importtable command, you can set the listseparator and decimalseparator parameters, which lets you determine what your separators are, regardless of region. Have you tried setting those?