topic Re: How to add a Site ID to Storage System Address Scheme? in FlexSim Forum

How to add a Site ID to Storage System Address Scheme?

lars_jacobsen_ScandiSim — Wed, 10 Aug 2022 09:14:52 GMT

[ FlexSim 22.1.3 ]

Is it possible to expand the storage system address scheme with an additional field, i.e. Site ID? The issue is that I would like to query storage possibilities by site and not only globally.

Re: How to add a Site ID to Storage System Address Scheme?

moehlmann_fe — Wed, 10 Aug 2022 09:34:34 GMT

I don't believe that this is possible.

You could use an (indexed) slot label for that purpose though. Or is there any reason you would like to avoid using labels?

Re: How to add a Site ID to Storage System Address Scheme?

jason_lightfoot_adsk — Wed, 10 Aug 2022 09:52:55 GMT

The simplest way will be to duplicate the address scheme for each site and include the site ID at the start.

Then on the storage objects choose the correct scheme for the site:

Re: How to add a Site ID to Storage System Address Scheme?

lars_jacobsen_ScandiSim — Wed, 10 Aug 2022 10:09:39 GMT

So I should by able to query these two fields? They do not contain any value.

Re: How to add a Site ID to Storage System Address Scheme?

jason_lightfoot_adsk — Wed, 10 Aug 2022 10:40:31 GMT

You said you wanted to use change the address - here the slot.address=="LON-A-1-A-1-1" or "CPH-A-1-A-1-1". Without this, finding "A-1-A-1-1" would give slots in both racks.

Re: How to add a Site ID to Storage System Address Scheme?

lars_jacobsen_ScandiSim — Wed, 10 Aug 2022 10:54:03 GMT

I query the storage system like this

I am not sure how to access the 2 new fields in the address?

Re: How to add a Site ID to Storage System Address Scheme?

jason_lightfoot_adsk — Wed, 10 Aug 2022 11:14:25 GMT

If you want the siteID to be part of the Address then do as I suggest. If you want the siteID to be an attribute of the slot then label the slot as Felix suggests. If you want to have those set automatically write a script to do so that references a siteID label on the rack object or the site object. The two are not mutually exclusive, so you can use the address string and the slot attributes.

Re: How to add a Site ID to Storage System Address Scheme?

lars_jacobsen_ScandiSim — Wed, 10 Aug 2022 12:46:33 GMT

Thanks for the works arounds, however I was hoping that it would be possible to add another field to the address scheme, but that doesn't seem to be a possibility currently. I will post a request to dev.

Re: How to add a Site ID to Storage System Address Scheme?

joerg_vogel_HsH — Wed, 10 Aug 2022 16:18:36 GMT

@Lars Christian J2, you have still slot labels!

Re: How to add a Site ID to Storage System Address Scheme?

lars_jacobsen_ScandiSim — Thu, 11 Aug 2022 06:28:43 GMT

Thanks for all the input. I realized that I can use slot.storageObject to limit the result of the sql query.

Object Site = Model.find("SiteA");

Array WrhObj = Site.subnodes.toArray();

int Zone = 10;

return Storage.system.querySlots("WHERE slot.zoneID = $1 AND slot.storageObject IN $2", 0, Zone, WrhObj).as(Array).length;

Re: How to add a Site ID to Storage System Address Scheme?

jason_lightfoot_adsk — Sat, 13 Aug 2022 20:23:56 GMT

Yes - there's probably 20+ ways you can get around it without using the address. You could also also check if slot.storageObject.up = site. Might be more efficient than checking if it's in an array depending on the length.

Re: How to add a Site ID to Storage System Address Scheme?

joerg_vogel_HsH — Sun, 14 Aug 2022 08:01:10 GMT

@Lars Christian J2 , There exists an Aisle side management in manual for left and right side by mapping of Aisle ID and slot progression. Front and Back side are seperated by even and uneven numbering.

https://docs.flexsim.com/en/22.2/Reference/PropertiesPanels/WarehousingPanels/AddressMapping/AddressMapping.html#slotProgression

Re: How to add a Site ID to Storage System Address Scheme?

jason_lightfoot_adsk — Sun, 14 Aug 2022 12:04:13 GMT

I think the question was about a Site ID indicating the warehouse location rather than a Side ID.

Re: How to add a Site ID to Storage System Address Scheme?

Jeanette_Fullmer — Wed, 17 Aug 2022 18:32:13 GMT

Hi @Lars Christian J2, was one of Lars Christian J2's or Jason Lightfoot's or Felix Möhlmann's answers helpful? If so, please click the "Accept" button at the bottom of the one that best answers your question. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.