help.fsmhel.xlsxHello I need help with the following model, I need to extract the specific units and specific amounts in the excel to the hangars (queues) of the system at the time specified by the excel, how can I do this? thanks for your attention
Just to clarify, you want the specific Queue to pull the item from the rack at the specified time and quantity?
If this is the case, then first, rather than use ports from the rack, I would push all of the items on the rack to a list.
Next I would set up a Process Flow with a Scheduled Source.
From there, I would import the table using the Excel Importer. (Either import it to a Global table within your model, or arrange the columns in your Excel File to match a scheduled source with Time / Name / Quantity as the columns, and import the table directly to the Scheduled Source.) This will cause the scheduled source to produce the quantity of tokens at the specified time, and you can include the queue they are supposed to go to as a label.
Then just have each of the tokens pull the appropriate item from the list, and move it to the appropriate queue, with a Move Object activity.
Is this the functionality you're looking for in your model?
Here's an example you can look at: moveitemsbytable.fsm
I eliminated the sink in this example so that you can see the items arriving at all the hangars.
11 People are following this question.
