Why the import doesn't work correctly ?

Why the import doesn't work correctly ?

nicolas_membrezSQWTQ
Observer Observer
316 Views
5 Replies
Message 1 of 6

Why the import doesn't work correctly ?

nicolas_membrezSQWTQ
Observer
Observer

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 ?

0 Likes
317 Views
5 Replies
Replies (5)
Message 2 of 6

kavika_faleumu
Autodesk
Autodesk

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?

0 Likes
Message 3 of 6

moehlmann_fe
Advocate
Advocate

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.

0 Likes
Message 4 of 6

kavika_faleumu
Autodesk
Autodesk

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

0 Likes
Message 5 of 6

kavika_faleumu
Autodesk
Autodesk

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.

0 Likes
Message 6 of 6

kavika_faleumu
Autodesk
Autodesk

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?

0 Likes