Arrival Schedule Direct Copy/Paste?

Arrival Schedule Direct Copy/Paste?

rajankur6494
Advocate Advocate
60 Views
1 Reply
Message 1 of 2

Arrival Schedule Direct Copy/Paste?

rajankur6494
Advocate
Advocate

[ FlexSim 21.0.10 ]

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!

0 Likes
Accepted solutions (1)
61 Views
1 Reply
Reply (1)
Message 2 of 2

kavika_faleumu
Autodesk
Autodesk
Accepted solution

@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


0 Likes