Possible bug csv importtable

[SCHamoen]

[ FlexSim 19.0.3 ]

Hi Guys,

When using the importtable function for importing a csv file we encountered 2 problems:

1. in the CSV a time stamp was used like 22:15:00. This was imported as number (22) so the : was ignored or something like that

2. we then tried to change the csv file and putting "" around the text it imported it as text but with the quotes. We would expect that it would ignore the quotes

We are not sure if they are bugs or by intention

I attached the csv file. (zipped because I couldn't upload the csv file)

Steven

opstelplan.zip

[philboboADSK · Accepted solution]

importtable() is currently just checking the first character to determine whether it is text or a number. importtable() is also not correctly handling quotation marks.

Based on the revision history, it appears that importtable() has always worked this way.

Right now, copy/paste and importtable() are two separate functions for handling parsing of CSV data, and they behave differently.

If you open this CSV file in Excel and then copy/paste it into FlexSim, it imports correctly.

I'll add a case to the dev list to look into fixing importtable() so that it works the way it should.

Thanks for pointing this out.

[sebastian_hemmannE3JAU]

Hi, it seems to be very hard to add a larger .csv file into a Schedule Source (PF) because the only way to add rows is actually by clicking the "+" Button.

[philboboADSK]

Please do not post a separate issue as a comment on an answer. Post a new question or idea rather than hijacking a thread. See Best practices for using this Answers site.