question

Fwteini K avatar image
0 Likes"
Fwteini K asked Joerg Vogel edited

SQL

Hi @Brandon Peterson,

I hope you doing well.

The FlexSim version is 19.2.4 .

I had fixed in the script table an SQL code and doesn't work correctly. I want to have the same distances as like the dwg file Flexsim(racks distance).dwg that i had attached and the racks to look like as the next file fsm test1.fsm test1.fsm. You have any ideas?

Thanks in advance. Have a nice day!

FlexSim 19.2.4
flexsim 19.2.4sqlscript
test1.fsm (355.7 KiB)
test1.fsm (355.7 KiB)
· 2
5 |100000

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

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

Hi @Fwteini K,

It looks like this question may be part of a homework assignment or academic project. The professors who assign simulation modeling exercises using FlexSim expect that the academic integrity of their assignments will be maintained. In addition, we are supportive of Honor Codes or Pledges that regulate the behavior surrounding academic assignments.

I recommend reading our best practices page on the subject, which includes some resources that you should find helpful as you use FlexSim for academic purposes. I also highly recommend Dr. Allen Greenwood’s FlexSim Primer, which was written specifically for students and professors.

0 Likes 0 ·
Fwteini K avatar image Fwteini K Jason Lightfoot ♦♦ commented ·

Hi @jason.lightfoot,

Thak you for your reply. Otherwise i had seen this page before, but for the code doesn't mentioned something related.

Have a nice day.

0 Likes 0 ·

1 Answer

Dawid Dabal avatar image
0 Likes"
Dawid Dabal answered Joerg Vogel edited

Hi,

When you want to move racks using code you need to also take into consideration the rakcs size.

You can find your model with example script attached that

test2.fsm


test2.fsm (356.8 KiB)
· 10
5 |100000

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

Fwteini K avatar image Fwteini K commented ·

Hi, Dawid Dabal

thanks for your quickly reply.

Generally, i want to appear the central racks per 2 (central racks: 507 to 518) especialy, i want to seem the racks 507 and 508 abstain 1.5 meters between them, with aisle 1.8 meters between from the following racks and so on 509-510, 511-512, 513-514, 515-516, 517-518.

Thank you very much!

0 Likes 0 ·
Dawid Dabal avatar image Dawid Dabal Fwteini K commented ·

You could spilt those rack in two group, "left" racks (507, 509, 511) and "right" racks (508, 510, 512). the distances between racks in those groups will be the same (aisle width + rack width). You can manually move the first rack in each group, and then move the rest using code.


1 Like 1 ·
Fwteini K avatar image Fwteini K Dawid Dabal commented ·

Please can you attached the model to look like as the following picture with the new code that you mean please, because i can't find the exactly code to do this.

Thank you again.

0 Likes 0 ·
1.png (1.2 MiB)
Show more comments