question

Akshay P avatar image
0 Likes"
Akshay P asked Joerg Vogel answered

Excel import error

imp-error.pngHi all,

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

FlexSim 19.1.1
simulationexcel importexcelimporting data from excel file to source
imp-error.png (227.0 KiB)
· 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.

Joerg Vogel avatar image Joerg Vogel commented ·

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 Likes 0 ·
Akshay P avatar image Akshay P Joerg Vogel commented ·

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 Likes 0 ·
sch-1.png (25.4 KiB)

1 Answer

Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered

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.

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.