Create a database with an arrival time and access to it in the process flow

Question

I would like to create a database with different arrival times that my forklifts pick the pallets (rack pick) to the certain times. How could I do this? Which process blocks could I use to access to a database with arrival times? For example at 10am on May 20 45 pallets should pick out of the pallet rack. I tested it with a delay block and it works but only with different hours where the pallets get picked and not an specific date. The important thing is the date which I get from a database. process

Hi @JackSock, while this is surely possible, it sounds like a very bad idea from a modelling perspective. Why would you want to dictate when forklifts pick up stuff? Sounds like you got some data from the past and want to duplicate this. But typically, you should NOT do it like that. Just my 50 cents to re-think if this is really needed this way :) — Benjamin
I need it because I want to replace the loading truck which also would load the pallets to a certain time. Please could you tell me how I could do this? Its very important for my project — JackSock

Stuart Rossiter Stuart Rossiter · Accepted Answer · 2020-05-20T17:53:06

Probably the easiest way is to have your in-rack agents (after your RackStore block) sit in a Wait block, and be freed from there (using the Wait block's free function) --- to then carry on to a RackPick block --- via AnyLogic dynamic events whose timings come from a database table.

(Your model as-is will just have your agents immediately exiting the rack and going to the Sink because the Queue does not stop them leaving.)

Your model startup would loop through the rows in the table and create dynamic event instances with the appropriate timeouts (delays from model start), and with a dynamic event parameter which specified the number of pallets to pick (and thus the number to free from the Wait block).

Create a database with an arrival time and access to it in the process flow

1 Answers