topic Re: Date Time Source Excel Import in FlexSim Forum

Date Time Source Excel Import

idoia_a — Thu, 07 Mar 2019 08:10:38 GMT

[ FlexSim 19.0.2 ]

Hello,

I am trying to use the Date Time Source importing the schedule from Excel. I am using a weekly repetition, the problem is that every time I import the Excel file, the table changes: Monday and Tuesday are replaced by Quantity and Name, so the source doesn't work. This happens in the advanced table as well, it doesn't look as it should.

It's the first time I have tried to import an Excel file so I may have done something wrong while importing, I would appreciate any help. I attach pictures.

Thank you in advance,

Idoia

Re: Date Time Source Excel Import

tanner_p — Fri, 08 Mar 2019 22:29:31 GMT

@Idoia A, Is there any chance you could upload the files you're working with so we can attempt to import them? If they contain proprietary information, you may upload them in a private question so that only a few of us at FlexSim U.S. will see them.

Re: Date Time Source Excel Import

idoia_a — Tue, 12 Mar 2019 09:02:33 GMT

@Tanner Poulton, Hello.

Sorry for the late answer, I attach a simplified version of the model I'm working on, as well as the Excel file. The Date Time Source is being used in the Task Executer Flow ("Forklift2").

Thank you,

Idoia

datetimesource.zip

Re: Date Time Source Excel Import

joshua_s — Thu, 21 Mar 2019 22:16:19 GMT

@Idoia A

Add a new arrival source, go in to edit it, change the Quantity to maanantai, and Name to tiistai, then click the excel import and do the whole excel import routine. See if this works or if you still get issues showing up.

This method seemed to work, but still looking into why it doesn't work normally.

Re: Date Time Source Excel Import

idoia_a — Fri, 22 Mar 2019 07:44:57 GMT

It seems to work with your method, thank you. Now I have a question about updating the values of the table from the excel file. Should I import the excel table every time the model is reset, by using OnModelReset trigger? If so, how should I do it? Or is there another way to do it? Let me know if I should post another question with this matter.

Thanks a lot.

Re: Date Time Source Excel Import

joshua_s — Fri, 22 Mar 2019 19:38:21 GMT

@Idoia A

I talked with one of the developers and he said the UI for that table can be misleading. There are 2 buttons in the top right of the window, "Table" and "Advanced". The Table option is a basic outline of the week, but the Advanced option shows a more complete and real representation of how the schedule is working.

The first and second columns with be the start and end times, or Start Time and duration, but the next 2 columns need to be quantity for how many tokens will be created and the second needs to be name for the name of the tokens being created. In the normal view of the UI, anything else after that are labels. So you will need the format of the table you are importing to look more like this

which will account for your whole week in second.

Then you can toggle this button to have the model import the excel file every time the excel file changes on reset.

Sorry for the confusion.

Re: Date Time Source Excel Import

idoia_a — Mon, 25 Mar 2019 13:40:54 GMT

Thank you for clarifying, the tables look as they should now.

Re: Date Time Source Excel Import

clair_augsburgerZGWRZ — Mon, 12 Oct 2020 10:32:33 GMT

Thanks @Joshua S. One of our users did a similar mistake, the data in his Excel file had 4 columns exactly like the table shown by default in the arrivals window:

Start (DD:)HH:MM:SS
End (DD:)HH:MM:SS
Quantity
Name

So we corrected his Excel file to have instead:

Start Time (in model units)
Duration (in model units)
Quantity
Name

I agree that the UI for the table can be misleading. I notify @Jordan Johnson if he has ideas of improvement.