question

Ankur A3 avatar image
0 Likes"
Ankur A3 asked Kavika F edited

Arrival Schedule Direct Copy/Paste?

Hi Team,

I have below arrival schedule in excel.

1652251750029.png

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

Thank you!

FlexSim 21.0.10
scheduleimportweekly
1652251750029.png (7.2 KiB)
5 |100000

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

1 Answer

Kavika F avatar image
0 Likes"
Kavika F answered Kavika F edited

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

1652308159317.png

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



1652308017689.png (73.7 KiB)
1652308159317.png (314.6 KiB)
5 |100000

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