Create itemFlow in a rack from database

Question

question

Xabier A asked Jul 8, '20 Joerg Vogel answered Jul 8, '20

Create itemFlow in a rack from database

Hello,

I have been trying to create initial stock in a rack programatically according to the information of a database, and I have a problem:

(for the example Iam going to omit the database connection and I am going to do it directly)

- I have defined a connection to the database (I have check it and it works, no applicable for his example)

- I have defined a rack with the bay, level, slot location strategy.

- I have created a process flow with a source and a custom code that:

- retrieves information from the database (omit this part)

- creates an item (for each occurrence in the resultset)

- locates it in the rack

The problem is that after executing the code the rack doesn't shows the pallet in the location. There is no error so I don't understand what is happening.

Here is the model, any help will be appreciated.

initialStock3.fsm

Thanks in advance.

Software Version:

FlexSim 20.1.2

rack flexsim 20.1.2 database createflowitem

initialstock3.fsm (41.4 KiB)

5 |100000

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

Answer 1 · 2020-07-08T16:24:01Z

Joerg Vogel answered Jul 8, '20

I have edited your code to place the box into the rack. If you want to exchange the box by a pallet, then you can do. items in a container object like a pallet aren't managed by the storage system, because the item that gets a slot assigned is part of the storage, not its content.

initialstock3_jv.fsm

initialstock3-jv.fsm (39.4 KiB)

5 |100000

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

question