Excel import error

Question

question

Akshay P asked Aug 05 2019 at 9:02 AM Joerg Vogel answered Aug 13 2019 at 4:55 PM

Excel import error

I have been trying to build a simulator for testing multiple factory automation setups. For this purpose, the first step is to import data from an excel file that I have that contains the schedule that needs to be followed to execute a lot. I have been trying to use the import function to get the file, but I have continuously been getting an error (see attached image). As the information is sensitive, I can not share the file, but can anyone tell me what could be the probable cause of this error. I am fairly new to flexsim, so this might be a ridiculous question to ask, but any help would be appreciated.

Thanks in advance!

Regards,

Akshay Pundir

Software Version:

FlexSim 19.1.1

simulation excel import excel importing data from excel file to source

imp-error.png (227.0 KiB)

· 2

Joerg Vogel commented · Aug 05 2019 at 10:25 AM

If you can't share the original data, perhaps you can build a table with similar data structure but totally different values? Have you tried to replace the space characters in the name of the file by underscore characters. Is the file still open in excel, while you try to import the data?

Have you tried to import a really simple data structure into FlexSim? Hopefully your column data doesn't mingle with different datatypes.The first character of value followed by numbers isn't an "e".

0 ·

Akshay P Joerg Vogel commented · Aug 05 2019 at 11:33 AM

Dear @Jörg Vogel,

Thank you for your reply. I have column data that mingles with multiple data types indeed. But can't I even import those values into flexsim then? What could be the possible fix for this?

Please refer to the attached image to get an idea about the data table.

sch-1.png

Regards,

Akshay Pundir

0 ·

sch-1.png (25.4 KiB)

Answer 1 · 2019-08-05T12:56:28Z

Joerg Vogel answered Aug 05 2019 at 12:56 PM

You said, you want to import schedule data. In this case try to import a single column of datetime data from an excel file. If you succeed you can build around that the data structure you want to assign to labels. It is a good practice to give FlexSim a data structure that the import filter can read. The import filter isn't clever enough to guess what you want to happen with the data in your table inside of FlexSim.

question