Arrival Schedule Direct Copy/Paste?

Question

question

Ankur A3 asked May 11, '22 Kavika F edited May 11, '22

Arrival Schedule Direct Copy/Paste?

Hi Team,

I have below arrival schedule in excel.

Is there any way to import this schedule directly in Date Time Source Activity without much changes?

Thank you!

Software Version:

FlexSim 21.0.10

schedule import weekly

1652251750029.png (7.2 KiB)

Answer 1 · 2022-05-11T22:27:33Z

Kavika F answered May 11, '22 Kavika F edited May 11, '22

@Ankur A3, you can import an excel sheet into a Date Time Source in Process Flow with the excel icon.

You have to make sure that the date/time format in the excel matches the table format. For example, in the image I attached, I imported a workbook with your sample data above. Even though it imported the values correctly (very right), it ignored the days and converted your times to 24-hour format. It will also delete the two required labels (Quantity and Name) - you have to put those back in by closing the table after importing, reopening it from the process flow source (Edit Arrivals), and adding them back in. If you get errors thrown around here it's because you have -2 labels and it doesn't like that.

I suggest editing your date/time formats to match the table format [dd:hh:mm:ss] so it imports the days and times correctly. (Like below)

1652308017689.png (73.7 KiB)

1652308159317.png (314.6 KiB)

question