question

Steven Hamoen avatar image
0 Likes"
Steven Hamoen asked Phil BoBo edited

Possible bug csv importtable

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

FlexSim 19.0.3
importtablecsv files
opstelplan.zip (464 B)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
Phil BoBo avatar image
0 Likes"
Phil BoBo answered Phil BoBo edited

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.

· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Sebastian Hemmann avatar image Sebastian Hemmann commented ·

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.

0 Likes 0 ·
Phil BoBo avatar image Phil BoBo ♦♦ Sebastian Hemmann commented ·

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.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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